P_ClosingChangeLog

DDL: P_CLOSINGCHANGELOG SQL: PCLSGCHNGLOG Type: view COMPOSITE Package: FCCO_VDM_MD

Closing Change Log

P_ClosingChangeLog is a Composite CDS View that provides data about "Closing Change Log" in SAP S/4HANA. It reads from 1 data source (I_ChangeDocumentItem) and exposes 16 fields with key fields ChangeDocObject, ChangeDocObjectClass, ChangeDocument, DatabaseTable, ChangeDocTableKey. Part of development package FCCO_VDM_MD.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_ChangeDocumentItem I_ChangeDocumentItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PCLSGCHNGLOG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject ChangeDocObject
KEY ChangeDocObjectClass ChangeDocObjectClass
KEY ChangeDocument ChangeDocument
KEY DatabaseTable DatabaseTable
KEY ChangeDocTableKey ChangeDocTableKey
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType ChangeDocItemChangeType
ChangeDocPreviousUnit ChangeDocPreviousUnit
ChangeDocNewUnit ChangeDocNewUnit
ChangeDocPreviousCurrency ChangeDocPreviousCurrency
ChangeDocNewCurrency ChangeDocNewCurrency
ChangeDocNewFieldValue
ChangeDocPreviousFieldValue
_ChangeDocLongTableKey _ChangeDocLongTableKey
_ChangeDocument _ChangeDocument
_ChangeDocumentItemExtension _ChangeDocumentItemExtension 
@AbapCatalog.sqlViewName: 'PCLSGCHNGLOG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
  dataClass: #TRANSACTIONAL,
  serviceQuality: #C,
  sizeCategory: #L
}
@VDM: {
  private: true,
  viewType: #COMPOSITE
}

define view P_ClosingChangeLog
  as select from I_ChangeDocumentItem
{
  //I_ChangeDocumentItem

  key ChangeDocObject,
  key ChangeDocObjectClass,
  key ChangeDocument,
  key DatabaseTable,
  key ChangeDocTableKey,
  key ChangeDocDatabaseTableField,
  key ChangeDocItemChangeType,
      ChangeDocPreviousUnit,
      ChangeDocNewUnit,
      ChangeDocPreviousCurrency,
      ChangeDocNewCurrency,
      cast( ChangeDocNewFieldValue as changedocnewfieldvalue )           as ChangeDocNewFieldValue,
      cast( ChangeDocPreviousFieldValue as changedocpreviousfieldvalue ) as ChangeDocPreviousFieldValue,

      /* Associations */
      //I_ChangeDocumentItem

      _ChangeDocLongTableKey,
      _ChangeDocument,
      _ChangeDocumentItemExtension
}
where
      ChangeDocObjectClass = 'FCCO'

Learn More