P_EngmntProjChangeLogDoc

DDL: P_ENGMNTPROJCHANGELOGDOC SQL: PENGPROJCHNGEDOC Type: view CONSUMPTION Package: CPD_CDS

Private CDS for Change Log Document

P_EngmntProjChangeLogDoc is a Consumption CDS View that provides data about "Private CDS for Change Log Document" in SAP S/4HANA. It reads from 2 data sources (I_ChangeDocumentItem, I_ChangeDocument) and exposes 17 fields with key fields ChangeDocObjectClass, ChangeDocObject, ChangeDocument. It has 3 associations to related views. Part of development package CPD_CDS.

2 data source(s) 17 fields

Data Sources (2)

SourceAliasJoin Type
I_ChangeDocumentItem _ChangeDocItem left_outer
I_ChangeDocument _ChangeHeader from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_User UserDetails _ChangeHeader.CreatedByUser = UserDetails.UserID
[0..*] I_PersnWrkAgreementDet _PrevEmployee _ChangeDocItem.ChangeDocPreviousFieldValue = _PrevEmployee.PersonWorkAgreement
[0..*] I_PersnWrkAgreementDet _NewEmployee _ChangeDocItem.ChangeDocNewFieldValue = _NewEmployee.PersonWorkAgreement

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PENGPROJCHNGEDOC view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Private CDS for Change Log Document view
VDM.viewType #CONSUMPTION view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObjectClass I_ChangeDocument ChangeDocObjectClass
KEY ChangeDocObject I_ChangeDocument ChangeDocObject
KEY ChangeDocument I_ChangeDocument ChangeDocument
CreatedByUser I_ChangeDocument CreatedByUser
UserDescription UserDetails UserDescription
CreationDate I_ChangeDocument CreationDate
CreationTime I_ChangeDocument CreationTime
ChangeDocDatabaseTableField I_ChangeDocumentItem ChangeDocDatabaseTableField
ChangeDocItemChangeType I_ChangeDocumentItem ChangeDocItemChangeType
ChangeDocPreviousCurrency I_ChangeDocumentItem ChangeDocPreviousCurrency
ChangeDocNewCurrency I_ChangeDocumentItem ChangeDocNewCurrency
ChangeDocPreviousFieldValue I_ChangeDocumentItem ChangeDocPreviousFieldValue
PreviousFieldValue
ChangeDocNewFieldValue I_ChangeDocumentItem ChangeDocNewFieldValue
NewFieldValue
ChangeDocPreviousUnit I_ChangeDocumentItem ChangeDocPreviousUnit
ChangeDocNewUnit I_ChangeDocumentItem ChangeDocNewUnit 
@AbapCatalog.sqlViewName: 'PENGPROJCHNGEDOC'
@AbapCatalog.compiler.compareFilter: true
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Private CDS for Change Log Document'
@VDM.viewType: #CONSUMPTION
define view P_EngmntProjChangeLogDoc
  as select from    I_ChangeDocument     as _ChangeHeader

    left outer join I_ChangeDocumentItem as _ChangeDocItem on  _ChangeDocItem.ChangeDocObject      = _ChangeHeader.ChangeDocObject
                                                           and _ChangeDocItem.ChangeDocObjectClass = _ChangeHeader.ChangeDocObjectClass
                                                           and _ChangeDocItem.ChangeDocument       = _ChangeHeader.ChangeDocument
  association [0..1] to I_User                 as UserDetails   on _ChangeHeader.CreatedByUser = UserDetails.UserID

  association [0..*] to I_PersnWrkAgreementDet as _PrevEmployee on _ChangeDocItem.ChangeDocPreviousFieldValue = _PrevEmployee.PersonWorkAgreement
  association [0..*] to I_PersnWrkAgreementDet as _NewEmployee  on _ChangeDocItem.ChangeDocNewFieldValue = _NewEmployee.PersonWorkAgreement

{
  key _ChangeHeader.ChangeDocObjectClass,
  key _ChangeHeader.ChangeDocObject,
  key _ChangeHeader.ChangeDocument,
      _ChangeHeader.CreatedByUser,
      UserDetails.UserDescription,
      _ChangeHeader.CreationDate,
      _ChangeHeader.CreationTime,
      _ChangeDocItem.ChangeDocDatabaseTableField,
      _ChangeDocItem.ChangeDocItemChangeType,
      _ChangeDocItem.ChangeDocPreviousCurrency,
      _ChangeDocItem.ChangeDocNewCurrency,
      _ChangeDocItem.ChangeDocPreviousFieldValue,
      _PrevEmployee._WorkforcePerson.PersonFullName  as PreviousFieldValue,
      _ChangeDocItem.ChangeDocNewFieldValue,
      _NewEmployee._WorkforcePerson.PersonFullName   as NewFieldValue,
      _ChangeDocItem.ChangeDocPreviousUnit,
      _ChangeDocItem.ChangeDocNewUnit
}
where
     _ChangeHeader.ChangeDocObjectClass = '/CPD/SS_CHDOC'
  or _ChangeHeader.ChangeDocObjectClass = '/CPD/PWS_BO_MP'
  or _ChangeHeader.ChangeDocObjectClass = '/CPD/PLAN_HDR'

Learn More