P_InternalOrderItemChangeLog

DDL: P_INTERNALORDERITEMCHANGELOG SQL: PIOICHL Type: view CONSUMPTION

Change Log for fields of Internal Order

P_InternalOrderItemChangeLog is a Consumption CDS View that provides data about "Change Log for fields of Internal Order" in SAP S/4HANA. It reads from 1 data source (I_ChangeDocumentItem) and exposes 17 fields with key fields ChangeDocObject, ChangeDocument, ChangeDocTableKey, ChangeDocDatabaseTableField, ChangeDocItemChangeType.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_ChangeDocumentItem I_ChangeDocumentItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PIOICHL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #CONSUMPTION view
EndUserText.label Change Log for fields of Internal Order view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject ChangeDocObject
KEY ChangeDocument ChangeDocument
KEY ChangeDocTableKey ChangeDocTableKey
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType ChangeDocItemChangeType
KEY ChangeDocumentInternalOrder
ChangeDocObjectClass ChangeDocObjectClass
DatabaseTable DatabaseTable
ChangeDocNewFieldValue ChangeDocNewFieldValue
ChangeDocPreviousFieldValue ChangeDocPreviousFieldValue
CreatedByUser _ChangeDocument CreatedByUser
CreationDate _ChangeDocument CreationDate
CreationTime _ChangeDocument CreationTime
ChangeDocLanguage _ChangeDocument ChangeDocLanguage
_ChangeDocLongTableKey _ChangeDocLongTableKey
_ChangeDocument _ChangeDocument
_ChangeDocumentItemExtension _ChangeDocumentItemExtension 
@AbapCatalog.sqlViewName: 'PIOICHL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: {
  serviceQuality: #C,
  sizeCategory : #L,
  dataClass: #TRANSACTIONAL
}

@VDM.private: true
@VDM.viewType: #CONSUMPTION

@EndUserText.label: 'Change Log for fields of Internal Order'
define view P_InternalOrderItemChangeLog as select from I_ChangeDocumentItem {

  key ChangeDocObject,
  key ChangeDocument,
  key ChangeDocTableKey,
  key ChangeDocDatabaseTableField,
  key ChangeDocItemChangeType,
  key cast( ChangeDocObject as fis_internalorder ) as ChangeDocumentInternalOrder,

  ChangeDocObjectClass,
  DatabaseTable,
  ChangeDocNewFieldValue,
  ChangeDocPreviousFieldValue,

  _ChangeDocument.CreatedByUser,
  _ChangeDocument.CreationDate,
  _ChangeDocument.CreationTime,
  _ChangeDocument.ChangeDocLanguage,

  /* Associations */
  _ChangeDocLongTableKey,
  _ChangeDocument,
  _ChangeDocumentItemExtension

} where ChangeDocObjectClass = 'RKAUFTRAG'

Learn More