P_CostCtrChangeLogCostCenter

DDL: P_COSTCTRCHANGELOGCOSTCENTER SQL: PCCCDCOSTCENTER Type: view CONSUMPTION

P_CostCtrChangeLogCostCenter is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_CostCenter, I_CostCenter) and exposes 8 fields with key fields ChangeDocObjectClass, ControllingArea, CostCenter, ControllingArea, CostCenter. It has 1 association to related views.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
I_CostCenter I_CostCenter from
I_CostCenter I_CostCenter union

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CostCenter _CostCenter I_CostCenterChangeLog.ChangeDocumentControllingArea = _CostCenter.ControllingArea and I_CostCenterChangeLog.ChangeDocumentCostCenter = _CostCenter.CostCenter and I_CostCenterChangeLog.ChangeDocValidityStartDate = _CostCenter.ValidityStartDate

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCCCDCOSTCENTER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObjectClass ChangeDocObjectClass
KEY ControllingArea ChangeDocumentControllingArea
KEY CostCenter ChangeDocumentCostCenter
KEY ControllingArea ControllingArea
KEY CostCenter CostCenter
KEY ValidityStartDate ValidityStartDate
KEY ValidityEndDate ValidityEndDate
CostCenterName 
@AbapCatalog.sqlViewName: 'PCCCDCOSTCENTER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM: {
    private: true,
    viewType: #CONSUMPTION
}
define view P_CostCtrChangeLogCostCenter
  as select distinct from I_CostCenterChangeLog
  association [0..*] to I_CostCenter as _CostCenter on  I_CostCenterChangeLog.ChangeDocumentControllingArea = _CostCenter.ControllingArea
                                                    and I_CostCenterChangeLog.ChangeDocumentCostCenter      = _CostCenter.CostCenter
                                                    and I_CostCenterChangeLog.ChangeDocValidityStartDate    = _CostCenter.ValidityStartDate
{
  key ChangeDocObjectClass,
  key ChangeDocumentControllingArea    as ControllingArea,
  key ChangeDocumentCostCenter         as CostCenter,
  key cast( case dats_is_valid(ChangeDocValidityStartDate)
              when 1 then ChangeDocValidityStartDate
              else '00010101'
            end as validitystartdate ) as ValidityStartDate,
  key cast( case dats_is_valid(ChangeDocumentValidityEndDate)
              when 1 then ChangeDocumentValidityEndDate
              else '99991231'
            end as validityenddate )   as ValidityEndDate,

      _CostCenter._Text[ Language = $session.system_language ].CostCenterName
}
union select from I_CostCenter
{
  key 'KOSTL' as ChangeDocObjectClass,
  key ControllingArea,
  key CostCenter,
  key ValidityStartDate,
  key ValidityEndDate,
      _Text[ Language = $session.system_language ].CostCenterName
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COSTCENTER",
"I_COSTCENTERCHANGELOG",
"I_COSTCENTERTEXT"
],
"ASSOCIATED":
[
"I_COSTCENTER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More