P_PurOrderItemDocumentChanges

DDL: P_PURORDERITEMDOCUMENTCHANGES SQL: PPOIDOCCHNG Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS

PO Item Document Changes

P_PurOrderItemDocumentChanges is a Consumption CDS View that provides data about "PO Item Document Changes" in SAP S/4HANA. It reads from 2 data sources (I_ChangeDocument, I_ChangeDocumentItem) and exposes 18 fields with key fields ChangeDocObject, ChangeDocument, DatabaseTable, ChangeDocTableKey, ChangeDocDatabaseTableField. Part of development package ODATA_MM_ANALYTICS.

2 data source(s) 18 fields

Data Sources (2)

SourceAliasJoin Type
I_ChangeDocument ChangeDocument inner
I_ChangeDocumentItem ChangeDocumentItem from

Parameters (2)

NameTypeDefault
P_StartDate vdm_validitystart
P_EndDate vdm_validityend

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPOIDOCCHNG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject I_ChangeDocumentItem ChangeDocObject
KEY ChangeDocument I_ChangeDocumentItem ChangeDocument
KEY DatabaseTable DatabaseTable
KEY ChangeDocTableKey ChangeDocTableKey
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField
ChangeDocPreviousUnit ChangeDocPreviousUnit
ChangeDocNewUnit ChangeDocNewUnit
ChangeDocPreviousCurrency ChangeDocPreviousCurrency
ChangeDocNewCurrency ChangeDocNewCurrency
ChangeDocNewFieldValue ChangeDocNewFieldValue
ChangeDocPreviousFieldValue ChangeDocPreviousFieldValue
ChangeDocTextIsChanged ChangeDocTextIsChanged
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
ChangeTransactionCode ChangeTransactionCode
ChangeDocChangeType ChangeDocChangeType
ChangeDocObjectClass I_ChangeDocumentItem ChangeDocObjectClass 
@AbapCatalog.sqlViewName: 'PPOIDOCCHNG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType : #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE 
@VDM.private: true
define view P_PurOrderItemDocumentChanges
  with parameters
    P_StartDate : vdm_validitystart,
    P_EndDate   : vdm_validityend

  as select from I_ChangeDocumentItem as ChangeDocumentItem
    inner join   I_ChangeDocument     as ChangeDocument on  ChangeDocumentItem.ChangeDocObjectClass = ChangeDocument.ChangeDocObjectClass
                                                        and ChangeDocumentItem.ChangeDocObject      = ChangeDocument.ChangeDocObject
                                                        and ChangeDocumentItem.ChangeDocument       = ChangeDocument.ChangeDocument

{
  key ChangeDocumentItem.ChangeDocObject,
  key ChangeDocumentItem.ChangeDocument,
  key DatabaseTable,
  key ChangeDocTableKey,
  key ChangeDocDatabaseTableField,

      //  key ChangeDocItemChangeType,


      ChangeDocPreviousUnit,
      ChangeDocNewUnit,
      ChangeDocPreviousCurrency,
      ChangeDocNewCurrency,
      ChangeDocNewFieldValue,
      ChangeDocPreviousFieldValue,
      ChangeDocTextIsChanged,

      CreatedByUser,
      CreationDate,
      CreationTime,
      ChangeTransactionCode,
      ChangeDocChangeType,
      
      // Added for DCL

      ChangeDocumentItem.ChangeDocObjectClass

}
where
  (
       ChangeDocumentItem.ChangeDocObjectClass = 'EINKBELEG'
  )
  and  CreationDate  between $parameters.P_StartDate and $parameters.P_EndDate

Learn More