P_COSTCENTERCHANGELOG

CDS View

P_COSTCENTERCHANGELOG is a CDS View in S/4HANA. It contains 20 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 20 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CostCenterChangeLog view from COMPOSITE Cost Center Change Log

Fields (20)

KeyField CDS FieldsUsed in Views
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField 1
KEY ChangeDocItemChangeType ChangeDocItemChangeType 1
KEY ChangeDocObject ChangeDocObject 1
KEY ChangeDocument ChangeDocument 1
KEY ChangeDocumentControllingArea ChangeDocumentControllingArea 1
KEY ChangeDocumentCostCenter ChangeDocumentCostCenter 1
KEY ChangeDocumentValidityEndDate ChangeDocumentValidityEndDate 1
KEY ChangeDocValidityStartDate ChangeDocValidityStartDate 1
_ChangeDocLongTableKey _ChangeDocLongTableKey 1
_ChangeDocument _ChangeDocument 1
_ChangeDocumentItemExtension _ChangeDocumentItemExtension 1
ChangeDocNewCurrency ChangeDocNewCurrency 1
ChangeDocNewFieldValue ChangeDocNewFieldValue 1
ChangeDocNewUnit ChangeDocNewUnit 1
ChangeDocObjectClass ChangeDocObjectClass 1
ChangeDocPreviousCurrency ChangeDocPreviousCurrency 1
ChangeDocPreviousFieldValue ChangeDocPreviousFieldValue 1
ChangeDocPreviousUnit ChangeDocPreviousUnit 1
ChangeDocTableKey ChangeDocTableKey 1
DatabaseTable DatabaseTable 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
@VDM: {
  private: true,
  viewType: #COMPOSITE
}

define view entity P_CostCenterChangeLog
  as select from P_CostCenterChangeLogHeader as _Header
    association [1..*] to P_CostCenterChangeLogItem as _Item
      on    _Item.ChangeDocObject = _Header.ChangeDocObject
        and _Item.ChangeDocObjectClass = _Header.ChangeDocObjectClass
        and _Item.ChangeDocument = _Header.ChangeDocument
        and _Item.ControllingArea = _Header.ControllingArea
        and _Item.CostCenter = _Header.CostCenter
{
  key ControllingArea as ChangeDocumentControllingArea,
  key CostCenter as ChangeDocumentCostCenter,
  key cast( substring( _Item.ChangeDocTableKey, 18, 8 ) as datbi )             as ChangeDocumentValidityEndDate,
  key cast( substring( _Item.ChangeDocTableKey, 26, 8) as datab )              as ChangeDocValidityStartDate,
  key _Item.ChangeDocObject,
  key _Item.ChangeDocument,
  key _Item.ChangeDocDatabaseTableField,
  key _Item.ChangeDocItemChangeType,

      ControllingArea,
      CostCenter,
      cast( substring( _Item.ChangeDocTableKey, 18, 8 ) as datbi )             as ValidityEndDate,
      cast( substring( _Item.ChangeDocTableKey, 26, 8) as datab )              as ValidityStartDate,
      _Item.ChangeDocObjectClass,
      CreatedByUser,
      CreationDate,
      CreationTime,
      ChangeDocLanguage,
      _Item.DatabaseTable,
      _Item.ChangeDocTableKey,
      _Item.ChangeDocPreviousUnit,
      _Item.ChangeDocNewUnit,
      _Item.ChangeDocPreviousCurrency,
      _Item.ChangeDocNewCurrency,
      cast( _Item.ChangeDocNewFieldValue as changedocnewfieldvalue )           as ChangeDocNewFieldValue,
      cast( _Item.ChangeDocPreviousFieldValue as changedocpreviousfieldvalue ) as ChangeDocPreviousFieldValue,

      /* Associations */
      //I_ChangeDocumentItem,

      _Item._ChangeDocLongTableKey,
      _Item._ChangeDocument,
      _Item._ChangeDocumentItemExtension
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_COSTCENTERCHANGELOGHEADER",
"P_COSTCENTERCHANGELOGITEM"
],
"ASSOCIATED":
[
"I_CHANGEDOCLONGTABLEKEY",
"I_CHANGEDOCUMENT",
"I_CHANGEDOCUMENTITEMEXTENSION"
],
"BASE":
[
"P_COSTCENTERCHANGELOGITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More