I_CostCenterChangeLog

DDL: I_COSTCENTERCHANGELOG SQL: ICCCHNGLOG Type: view COMPOSITE

Cost Center Change Log

I_CostCenterChangeLog is a Composite CDS View that provides data about "Cost Center Change Log" in SAP S/4HANA. It reads from 2 data sources (P_CostCenterChangeLog, I_CostCenter) and exposes 33 fields with key fields ChangeDocumentControllingArea, ChangeDocumentCostCenter, ChangeDocumentValidityEndDate, ChangeDocValidityStartDate, ChangeDocObject.

2 data source(s) 33 fields

Data Sources (2)

SourceAliasJoin Type
P_CostCenterChangeLog ChangeDocumentItem from
I_CostCenter CostCenter left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICCCHNGLOG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Cost Center Change Log view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocumentControllingArea P_CostCenterChangeLog ChangeDocumentControllingArea
KEY ChangeDocumentCostCenter P_CostCenterChangeLog ChangeDocumentCostCenter
KEY ChangeDocumentValidityEndDate P_CostCenterChangeLog ChangeDocumentValidityEndDate
KEY ChangeDocValidityStartDate P_CostCenterChangeLog ChangeDocValidityStartDate
KEY ChangeDocObject P_CostCenterChangeLog ChangeDocObject
KEY ChangeDocument P_CostCenterChangeLog ChangeDocument
KEY ChangeDocDatabaseTableField P_CostCenterChangeLog ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType P_CostCenterChangeLog ChangeDocItemChangeType
ChangeDocObjectClass P_CostCenterChangeLog ChangeDocObjectClass
DatabaseTable P_CostCenterChangeLog DatabaseTable
ChangeDocTableKey P_CostCenterChangeLog ChangeDocTableKey
ChangeDocPreviousUnit P_CostCenterChangeLog ChangeDocPreviousUnit
ChangeDocNewUnit P_CostCenterChangeLog ChangeDocNewUnit
ChangeDocPreviousCurrency P_CostCenterChangeLog ChangeDocPreviousCurrency
ChangeDocNewCurrency P_CostCenterChangeLog ChangeDocNewCurrency
ChangeDocNewFieldValue P_CostCenterChangeLog ChangeDocNewFieldValue
ChangeDocPreviousFieldValue P_CostCenterChangeLog ChangeDocPreviousFieldValue
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
ChangeDocLanguage ChangeDocLanguage
BusinessArea I_CostCenter BusinessArea
CompanyCode I_CostCenter CompanyCode
ControllingArea I_CostCenter ControllingArea
CostCenter I_CostCenter CostCenter
ValidityEndDate I_CostCenter ValidityEndDate
ValidityStartDate I_CostCenter ValidityStartDate
_ChangeDocLongTableKey P_CostCenterChangeLog _ChangeDocLongTableKey
_ChangeDocument P_CostCenterChangeLog _ChangeDocument
_ChangeDocumentItemExtension P_CostCenterChangeLog _ChangeDocumentItemExtension
_BusinessArea I_CostCenter _BusinessArea
_CompanyCode I_CostCenter _CompanyCode
_ControllingArea I_CostCenter _ControllingArea 
@AbapCatalog.sqlViewName: 'ICCCHNGLOG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Cost Center Change Log'
@ObjectModel.usageType: {
  sizeCategory: #L,
  serviceQuality: #C,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE

define view I_CostCenterChangeLog
  as select from    P_CostCenterChangeLog as ChangeDocumentItem
    left outer join I_CostCenter          as CostCenter on  ChangeDocumentItem.ChangeDocumentControllingArea = CostCenter.ControllingArea
                                                        and ChangeDocumentItem.ChangeDocumentCostCenter      = CostCenter.CostCenter
                                                        and ChangeDocumentItem.ChangeDocumentValidityEndDate = CostCenter.ValidityEndDate
                                                        and ChangeDocumentItem.ChangeDocValidityStartDate    = CostCenter.ValidityStartDate
{
      //P_CostCenterChangeLog

  key ChangeDocumentItem.ChangeDocumentControllingArea,
  key ChangeDocumentItem.ChangeDocumentCostCenter,
  key ChangeDocumentItem.ChangeDocumentValidityEndDate,
  key ChangeDocumentItem.ChangeDocValidityStartDate,
  key ChangeDocumentItem.ChangeDocObject,
  key ChangeDocumentItem.ChangeDocument,
  key ChangeDocumentItem.ChangeDocDatabaseTableField,
  key ChangeDocumentItem.ChangeDocItemChangeType,
      ChangeDocumentItem.ChangeDocObjectClass,
      ChangeDocumentItem.DatabaseTable,
      ChangeDocumentItem.ChangeDocTableKey,
      ChangeDocumentItem.ChangeDocPreviousUnit,
      ChangeDocumentItem.ChangeDocNewUnit,
      ChangeDocumentItem.ChangeDocPreviousCurrency,
      ChangeDocumentItem.ChangeDocNewCurrency,
      ChangeDocumentItem.ChangeDocNewFieldValue,
      ChangeDocumentItem.ChangeDocPreviousFieldValue,
      CreatedByUser,
      CreationDate,
      CreationTime,
      ChangeDocLanguage,

      //CostCenter

      CostCenter.BusinessArea,
      CostCenter.CompanyCode,
      CostCenter.ControllingArea,
      CostCenter.CostCenter,
      CostCenter.ValidityEndDate,
      CostCenter.ValidityStartDate,

      /* Associations */
      //P_CostCenterChangeLog

      ChangeDocumentItem._ChangeDocLongTableKey,
      ChangeDocumentItem._ChangeDocument,
      ChangeDocumentItem._ChangeDocumentItemExtension,
      //_CostCenter

      CostCenter._BusinessArea,
      CostCenter._CompanyCode,
      CostCenter._ControllingArea

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COSTCENTER",
"P_COSTCENTERCHANGELOG"
],
"ASSOCIATED":
[
"I_BUSINESSAREA",
"I_CHANGEDOCLONGTABLEKEY",
"I_CHANGEDOCUMENT",
"I_CHANGEDOCUMENTITEMEXTENSION",
"I_COMPANYCODE",
"I_CONTROLLINGAREA"
],
"BASE":
[
"I_COSTCENTER",
"P_COSTCENTERCHANGELOG"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More