I_DrctActyAllocCoCodeCount

DDL: I_DRCTACTYALLOCCOCODECOUNT SQL: IDRCTACTYCCC Type: view COMPOSITE

Direct Activity Allocation - CoCd Count

I_DrctActyAllocCoCodeCount is a Composite CDS View that provides data about "Direct Activity Allocation - CoCd Count" in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItemRawData) and exposes 7 fields with key fields FiscalYear, ControllingArea, ReferenceDocument. It has 1 association to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_GLAccountLineItemRawData _Item from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CompanyCode _CompanyCodeText $projection.CompanyCode = _CompanyCodeText.CompanyCode

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IDRCTACTYCCC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Direct Activity Allocation - CoCd Count view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY FiscalYear FiscalYear
KEY ControllingArea ControllingArea
KEY ReferenceDocument ReferenceDocument
CompanyCode
CompanyCodeName
CompanyCodeCount
_CompanyCodeText _CompanyCodeText 
@AbapCatalog.sqlViewName: 'IDRCTACTYCCC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Direct Activity Allocation - CoCd Count'

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@VDM.viewType: #COMPOSITE

define view I_DrctActyAllocCoCodeCount 
  as select from I_GLAccountLineItemRawData as _Item //I_DirectActivityAllocationItem

  
  association [1..1] to I_CompanyCode as _CompanyCodeText
    on  $projection.CompanyCode = _CompanyCodeText.CompanyCode
{
  key FiscalYear,
  key ControllingArea, 
  key ReferenceDocument,
  max (CompanyCode) as CompanyCode,
  cast('' as fis_butxt) as CompanyCodeName,
  count ( distinct CompanyCode ) as CompanyCodeCount,
  
  _CompanyCodeText
}
where
  ( //RKL - Leistungsverrechnung; RKLU - Umbuchung Leist.verr.

    ControllingBusTransacType = 'RKL'
    and ( BusinessTransactionCategory = 'RKL' or BusinessTransactionCategory = 'RKLU' )   
  )
  and ReferenceDocumentType = 'COBK'
  and OriginCtrlgDebitCreditCode = 'S'
  and _Ledger.IsLeadingLedger = 'X'
  
group by
FiscalYear,
ControllingArea,
ReferenceDocument
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLACCOUNTLINEITEMRAWDATA",
"I_LEDGER"
],
"ASSOCIATED":
[
"I_COMPANYCODE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More