P_PurchaseContractChange

DDL: P_PURCHASECONTRACTCHANGE SQL: PMMCHNGCON Type: view CONSUMPTION

Purchase Contract Changes

P_PurchaseContractChange is a Consumption CDS View that provides data about "Purchase Contract Changes" in SAP S/4HANA. It reads from 3 data sources (I_ChangeDocumentItem, I_ChangeDocumentItem, I_ChangeDocumentItem) and exposes 14 fields with key fields ChangeDocTableKey, ChangeDocObject, ChangeDocObject, ChangeDocObject.

3 data source(s) 14 fields

Data Sources (3)

SourceAliasJoin Type
I_ChangeDocumentItem I_ChangeDocumentItem from
I_ChangeDocumentItem I_ChangeDocumentItem union_all
I_ChangeDocumentItem I_ChangeDocumentItem union_all

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PMMCHNGCON view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Purchase Contract Changes view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocTableKey ChangeDocTableKey
KEY ChangeDocObject ChangeDocObject
NumberOfQuantityChanges
NumberOfPriceChanges
NumberOfItems
KEY ChangeDocObject ChangeDocObject
NumberOfQuantityChanges
NumberOfPriceChanges
NumberOfItems
KEY ChangeDocObject ChangeDocObject
NumberOfQuantityChanges
NumberOfPriceChanges
NumberOfItems
NmbrOfPurContrItmChgs 
@AbapCatalog.sqlViewName: 'PMMCHNGCON'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Purchase Contract Changes'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType : #CONSUMPTION
@VDM.private: true
define view P_PurchaseContractChange
  as select from I_ChangeDocumentItem
{
  key    ChangeDocTableKey,
  key    ChangeDocObject,

         cast( 1 as mm_a_numberofquantitychanges ) as NumberOfQuantityChanges,

         cast( 0 as mm_a_numberofpricechanges )    as NumberOfPriceChanges,

         cast( 0 as mmpur_ana_numberofitemsadded ) as NumberOfItems,

         cast( 1 as mmpur_ana_purgcontitmchanges)  as NmbrOfPurContrItmChgs


}
where
      I_ChangeDocumentItem.DatabaseTable = 'EKPO'
  and ChangeDocItemChangeType            = 'U'
  and ChangeDocDatabaseTableField        = 'KTMNG'
union all select from I_ChangeDocumentItem

{

  key    ChangeDocTableKey,
  key    ChangeDocObject,

         cast( 0 as mm_a_numberofquantitychanges ) as NumberOfQuantityChanges,

         cast( 1 as mm_a_numberofpricechanges )    as NumberOfPriceChanges,

         cast( 0 as mmpur_ana_numberofitemsadded ) as NumberOfItems,

         cast( 1 as mmpur_ana_purgcontitmchanges)  as NmbrOfPurContrItmChgs

}
where
      I_ChangeDocumentItem.DatabaseTable = 'EKPO'
  and ChangeDocItemChangeType            = 'U'
  and ChangeDocDatabaseTableField        = 'NETPR'
union all select from I_ChangeDocumentItem

{

  key    ChangeDocTableKey,
  key    ChangeDocObject,

         cast( 0 as mm_a_numberofquantitychanges ) as NumberOfQuantityChanges,

         cast( 0 as mm_a_numberofpricechanges )    as NumberOfPriceChanges,

         cast( 1 as mmpur_ana_numberofitemsadded ) as NumberOfItems,

         cast( 1 as mmpur_ana_purgcontitmchanges)  as NmbrOfPurContrItmChgs

}
where
      I_ChangeDocumentItem.DatabaseTable = 'EKPO'
  and ChangeDocItemChangeType            = 'I'
  and ChangeDocDatabaseTableField        = 'KEY'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEDOCUMENTITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More