P_CNSLDTNUNIT_COMBINED

CDS View

P_CNSLDTNUNIT_COMBINED is a CDS View in S/4HANA. 5 CDS views read from this table.

Used by 5 CDS view(s)

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_CnsldtnUnitValueHelp_2 view from CONSUMPTION Consolidation Unit Value Help
FINCS_SEL_BUNIT_OLD_REP_LOGIC view from
I_CnsldtnUnitEnhcd_2 view from COMPOSITE Consolidation Unit Enhanced 2
P_CnsldtnUnit_2 view from COMPOSITE
P_VEC_CnsldtnUnit view from COMPOSITE 
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter:true
@VDM.private:true
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'PCSCUCOMB'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.representativeKey: 'ConsolidationUnit'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {
  dataClass: #CUSTOMIZING,
  serviceQuality: #C,
  sizeCategory: #M
}

define view P_CnsldtnUnit_Combined
  as select from P_CnsldtnUnit_Aggregated

  association [0..*] to P_CnsldtnUnit_CombinedText as _Text on $projection.ConsolidationUnit = _Text.ConsolidationUnit

{
       @ObjectModel.text.association: '_Text'
  key  ConsolidationUnit,
       ConsolidationDimension,

       case Source
        when 1 then _Attr1.Country
        when 2 then _Attr2.Country
       end as Country,

       case Source
        when 1 then cast( _Attr1.DocumentEntryIsInGroupCurrency as fc_gcind )
        when 2 then cast( _AttrTVD.DocumentEntryIsInGroupCurrency as fc_gcind )
       end as DocumentEntryIsInGroupCurrency,

       _Text
}
where
  ConsolidationDimension = 'Y1'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNSLDTNUNIT",
"I_CNSLDTNUNITBYTIMEVERSION",
"I_CNSLDTNUNIT_3",
"P_CNSLDTNUNIT_AGGREGATED"
],
"ASSOCIATED":
[
"P_CNSLDTNUNIT_COMBINEDTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More