P_CostCenterChangeLogItem

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
@VDM: {
  private: true,
  viewType: #COMPOSITE
}
define view entity P_CostCenterChangeLogItem
  as select from I_ChangeDocumentItem
{
  key ChangeDocObject,
  key ChangeDocObjectClass,
  key ChangeDocument,
  key DatabaseTable,
  key ChangeDocTableKey,
  key ChangeDocDatabaseTableField,
  key ChangeDocItemChangeType,

  cast( substring( ChangeDocTableKey, 18, 8 ) as datbi ) as ChangeDocumentValidityEndDate,
  cast( substring( ChangeDocTableKey, 26, 8) as datab )  as ChangeDocValidityStartDate,
  cast( substring( ChangeDocObject, 1, 4 ) as kokrs )    as ControllingArea,
  cast( substring( ChangeDocObject, 5, 10 ) as kostl )   as CostCenter,
  cast( substring( ChangeDocTableKey, 18, 8 ) as datbi ) as ValidityEndDate,
  cast( substring( ChangeDocTableKey, 26, 8) as datab )  as ValidityStartDate,
  ChangeDocPreviousUnit,
  ChangeDocNewUnit,
  ChangeDocPreviousCurrency,
  ChangeDocNewCurrency,
  ChangeDocNewFieldValue,
  ChangeDocPreviousFieldValue,
  ChangeDocTextIsChanged,

  /* Associations */
  _ChangeDocLongTableKey,
  _ChangeDocument,
  _ChangeDocumentItemExtension,
  _FieldTextDDIC,
  _FieldTextLabel,
  _FieldTextReplace,
  _FieldTextView,
  _TableTextDDIC,
  _TableTextView
}
where ChangeDocObjectClass = 'KOSTL'
  and DatabaseTable = 'CSKSB'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEDOCUMENTITEM"
],
"ASSOCIATED":
[
"I_CHANGEDOCFIELDLABEL",
"I_CHANGEDOCFIELDNAMES",
"I_CHANGEDOCFIELDTEXT",
"I_CHANGEDOCLONGTABLEKEY",
"I_CHANGEDOCTABLENAMES",
"I_CHANGEDOCTABLETEXT",
"I_CHANGEDOCUMENT",
"I_CHANGEDOCUMENTITEMEXTENSION",
"I_CHANGEDOCVIEWTEXT"
],
"BASE":
[
"I_CHANGEDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/