P_PurchaseOrderChange

DDL: P_PURCHASEORDERCHANGE SQL: PMMPURORDCHANGE Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS

Purchase Order Change

P_PurchaseOrderChange is a Consumption CDS View that provides data about "Purchase Order Change" in SAP S/4HANA. It reads from 2 data sources (I_ChangeDocument, I_ChangeDocumentItem) and exposes 3 fields with key field ChangeDocTableKey. Part of development package ODATA_MM_ANALYTICS.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
I_ChangeDocument I_ChangeDocument inner
I_ChangeDocumentItem I_ChangeDocumentItem from

Parameters (2)

NameTypeDefault
P_StartDate cddatum
P_EndDate cddatum

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMMPURORDCHANGE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocTableKey I_ChangeDocumentItem ChangeDocTableKey
ChangeDocObject I_ChangeDocumentItem ChangeDocObject
DatabaseTable DatabaseTable 
@AbapCatalog.sqlViewName: 'PMMPURORDCHANGE'
//@ClientDependent: true

@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.viewType : #CONSUMPTION
@VDM.private: true
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view P_PurchaseOrderChange
  with parameters 
    P_StartDate : cddatum,
    P_EndDate   : cddatum
    
  as select from I_ChangeDocumentItem
    inner join   I_ChangeDocument                   on  I_ChangeDocument.ChangeDocObject      = I_ChangeDocumentItem.ChangeDocObject
                                                    and I_ChangeDocument.ChangeDocObjectClass = I_ChangeDocumentItem.ChangeDocObjectClass
                                                    and I_ChangeDocument.ChangeDocument       = I_ChangeDocumentItem.ChangeDocument
//    inner join   P_RelevantDates( P_Date: $parameters.P_Date,

//                                  P_EvaluationTimeFrameInDays: $parameters.P_EvaluationTimeFrameInDays

//                                 ) as RelevantDates on I_ChangeDocument.CreationDate = RelevantDates.CalendarDate

{
  key I_ChangeDocumentItem.ChangeDocTableKey,
      I_ChangeDocumentItem.ChangeDocObject,
      DatabaseTable //,


      //substring(ChangeDocTableKey,4,10) as PurchaseOrder


}
where
      DatabaseTable           = 'EKKO'
  and ChangeDocItemChangeType = 'U'
  and I_ChangeDocument.CreationDate >= $parameters.P_StartDate
  and I_ChangeDocument.CreationDate <= $parameters.P_EndDate

group by
  I_ChangeDocumentItem.ChangeDocTableKey,
  I_ChangeDocumentItem.ChangeDocObject,
  DatabaseTable

Learn More