P_CHANGEDOCUMENTITEM3

CDS View

Change Document

P_CHANGEDOCUMENTITEM3 is a CDS View in S/4HANA. Change Document. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_InfoRecordPriceVariance1 view left_outer CONSUMPTION Info Record Price Variance 1
P_PurContractPriceVariance1 view left_outer CONSUMPTION Purchase Contract Price Variance 1 
@AbapCatalog.sqlViewName: 'PMMCDPOS3'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.viewType : #CONSUMPTION
@VDM.private: true
@AccessControl.personalData.blocking: #NOT_REQUIRED

define view P_ChangeDocumentItem3 

with parameters 
      P_StartDate       : vdm_validitystart,
      P_EndDate         : vdm_validityend

as select from P_ChangeDocumentItem2 ( P_StartDate: $parameters.P_StartDate,
                                                         P_EndDate: $parameters.P_EndDate )
 
{
  key ChangeDocObject,
  key Item,
  key DatabaseTable,
  
  sum( NumberOfPriceChanges ) as NumberOfPriceChanges
  
}group by ChangeDocObject, 
          Item,
          DatabaseTable

Learn More