P_PurInfoRecordDocumentChanges

DDL: P_PURINFORECORDDOCUMENTCHANGES SQL: PPIRDOCCHNG Type: view CONSUMPTION

P_PurInfoRecordDocumentChanges is a Consumption CDS View 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.

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 PPIRDOCCHNG 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: 'PPIRDOCCHNG'
@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_PurInfoRecordDocumentChanges 
  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 = 'INFOSATZ'
  and  CreationDate  between $parameters.P_StartDate and $parameters.P_EndDate
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEDOCUMENT",
"I_CHANGEDOCUMENTITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More