P_CHANGEDOCUMENTITEM3
P_CHANGEDOCUMENTITEM3 is a CDS View in S/4HANA. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_InfoRecordPriceVariance1 | view | left_outer | CONSUMPTION | |
| P_PurContractPriceVariance1 | view | left_outer | CONSUMPTION |
@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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CHANGEDOCUMENTITEM2"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/