C_CostRevnReassgmtSenderCount

DDL: C_COSTREVNREASSGMTSENDERCOUNT SQL: CCOSREVREASSC Type: view CONSUMPTION

Cost, Revenue Reassignment Sender Count

C_CostRevnReassgmtSenderCount is a Consumption CDS View that provides data about "Cost, Revenue Reassignment Sender Count" in SAP S/4HANA. It reads from 4 data sources (I_AccountAssignmentType, I_AccountAssignmentType, I_GLAccountLineItemRawData, I_GLAccountLineItemRawData) and exposes 11 fields with key fields FiscalYear, ControllingArea, ReferenceDocument, ControllingArea, ReferenceDocument.

4 data source(s) 11 fields

Data Sources (4)

SourceAliasJoin Type
I_AccountAssignmentType _AccountAssignmentType inner
I_AccountAssignmentType _AccountAssignmentType inner
I_GLAccountLineItemRawData _Item from
I_GLAccountLineItemRawData _Item union_all

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CCOSREVREASSC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label Cost, Revenue Reassignment Sender Count view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY FiscalYear I_GLAccountLineItemRawData FiscalYear
KEY ControllingArea I_GLAccountLineItemRawData ControllingArea
KEY ReferenceDocument I_GLAccountLineItemRawData ReferenceDocument
ControllingBusTransacType I_GLAccountLineItemRawData ControllingBusTransacType
BusinessTransactionCategory I_GLAccountLineItemRawData BusinessTransactionCategory
FiscalYear
KEY ControllingArea I_GLAccountLineItemRawData ControllingArea
KEY ReferenceDocument I_GLAccountLineItemRawData ReferenceDocument
ControllingBusTransacType I_GLAccountLineItemRawData ControllingBusTransacType
BusinessTransactionCategory I_GLAccountLineItemRawData BusinessTransactionCategory
NumberOfSenderCompanyCodes 
@AbapCatalog.sqlViewName: 'CCOSREVREASSC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK


@VDM.viewType: #CONSUMPTION

@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #C
@EndUserText.label: 'Cost, Revenue Reassignment Sender Count'
define view C_CostRevnReassgmtSenderCount 
as select from I_GLAccountLineItemRawData as _Item
    
  inner join I_AccountAssignmentType as _AccountAssignmentType
    on _AccountAssignmentType.AccountAssignmentType = _Item.AccountAssignmentType 
{
  key _Item.FiscalYear,
  key _Item.ControllingArea, 
  key _Item.ReferenceDocument,
  _Item.ControllingBusTransacType,
  _Item.BusinessTransactionCategory,
  count ( distinct _Item.CompanyCode ) as NumberOfSenderCompanyCodes
}where
  (
       ( _Item.ControllingBusTransacType = 'KAMV' and _Item.BusinessTransactionCategory = 'KAMV' )  
    or ( _Item.ControllingBusTransacType = 'RKU1' and _Item.BusinessTransactionCategory = 'RKU1' )     
  )
  and
  _Item.ReferenceDocumentType = 'COBK'
  and
  _Item.OriginCtrlgDebitCreditCode = 'H'
  and
  _Item._Ledger.IsLeadingLedger = 'X' 
  and _Item.LogicalSystem = '' 
  and _Item._JournalEntry.SenderLogicalSystem = '' 
  and (_Item.SourceLedger = _Item._JournalEntry.LedgerGroup or _Item._JournalEntry.LedgerGroup = '' ) 
group by
_Item.FiscalYear,
_Item.ControllingArea,
_Item.ReferenceDocument,
_Item.ControllingBusTransacType,
_Item.BusinessTransactionCategory
   
  union all select from I_GLAccountLineItemRawData as _Item
    
  inner join I_AccountAssignmentType as _AccountAssignmentType
    on _AccountAssignmentType.AccountAssignmentType = _Item.AccountAssignmentType
 {
  key _Item.FiscalYear,
  key _Item.ControllingArea, 
  key _Item.ReferenceDocument,
  _Item.ControllingBusTransacType,
  _Item.BusinessTransactionCategory,
  count ( distinct _Item.CompanyCode ) as NumberOfSenderCompanyCodes
}where
  (
       _Item.ControllingBusTransacType = 'RKU2'
       and _Item.BusinessTransactionCategory = 'RKU2'     
  )
  and
  _Item.ReferenceDocumentType = 'COBK'
  and
  _Item.OriginCtrlgDebitCreditCode = 'S'
  and
  _Item._Ledger.IsLeadingLedger = 'X'
  and _Item.LogicalSystem = '' 
  and _Item._JournalEntry.SenderLogicalSystem = '' 
  and (_Item.SourceLedger = _Item._JournalEntry.LedgerGroup or _Item._JournalEntry.LedgerGroup = '' )
group by
_Item.FiscalYear,
_Item.ControllingArea,
_Item.ReferenceDocument,
_Item.ControllingBusTransacType,
_Item.BusinessTransactionCategory   
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCOUNTASSIGNMENTTYPE",
"I_GLACCOUNTLINEITEMRAWDATA",
"I_JOURNALENTRY",
"I_LEDGER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More