P_PrftCtrChangeLogPrftCtr

DDL: P_PRFTCTRCHANGELOGPRFTCTR Type: view_entity CONSUMPTION

Profit Center in Profit Center ChangeLog

P_PrftCtrChangeLogPrftCtr is a Consumption CDS View that provides data about "Profit Center in Profit Center ChangeLog" in SAP S/4HANA. It reads from 2 data sources (I_ProfitCenter, I_ProfitCenter) and exposes 8 fields with key fields ChangeDocObjectClass, ControllingArea, ProfitCenter, ControllingArea, ProfitCenter. It has 1 association to related views.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
I_ProfitCenter I_ProfitCenter from
I_ProfitCenter I_ProfitCenter union

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ProfitCenter _ProfitCenter P_ProfitCenterChangeLog.ControllingArea = _ProfitCenter.ControllingArea and P_ProfitCenterChangeLog.ProfitCenter = _ProfitCenter.ProfitCenter and P_ProfitCenterChangeLog.ValidityStartDate = _ProfitCenter.ValidityStartDate

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Profit Center in Profit Center ChangeLog view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObjectClass ChangeDocObjectClass
KEY ControllingArea ControllingArea
KEY ProfitCenter ProfitCenter
KEY ControllingArea ControllingArea
KEY ProfitCenter ProfitCenter
KEY ValidityStartDate ValidityStartDate
KEY ValidityEndDate ValidityEndDate
ProfitCenterName 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Profit Center in Profit Center ChangeLog'
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
    private: true,
    viewType: #CONSUMPTION
}
define view entity P_PrftCtrChangeLogPrftCtr 
  as select distinct from P_ProfitCenterChangeLog
  association [0..*] to I_ProfitCenter as _ProfitCenter on  P_ProfitCenterChangeLog.ControllingArea = _ProfitCenter.ControllingArea
                                                    and P_ProfitCenterChangeLog.ProfitCenter      = _ProfitCenter.ProfitCenter
                                                    and P_ProfitCenterChangeLog.ValidityStartDate    = _ProfitCenter.ValidityStartDate
{
  key ChangeDocObjectClass,
  key ControllingArea,   
  key ProfitCenter,
  key cast( case dats_is_valid(ValidityStartDate)
              when 1 then ValidityStartDate
              else '00010101'
            end as validitystartdate ) as ValidityStartDate,
  key cast( case dats_is_valid(ValidityEndDate)
              when 1 then ValidityEndDate
              else '99991231'
            end as validityenddate )   as ValidityEndDate,

      _ProfitCenter._Text[ Language = $session.system_language ].ProfitCenterName
}
union select from I_ProfitCenter
{
  key 'PRCTR' as ChangeDocObjectClass,
  key ControllingArea,
  key ProfitCenter,
  key ValidityStartDate,
  key ValidityEndDate,
      _Text[ Language = $session.system_language ].ProfitCenterName
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROFITCENTER",
"I_PROFITCENTERTEXT",
"P_PROFITCENTERCHANGELOG"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More