@AbapCatalog.sqlViewName: 'PMMCHNGREQ'
@ClientDependent: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType : #CONSUMPTION
@VDM.private: true
define view P_PurchaseRequisitionChange
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 mm_a_numberofpurggrpchanges ) as NmbrOfPurchasingGroupChanges,
cast( 0 as mm_a_numberofsupplierchanges ) as NumberOfSupplierChanges,
cast( 0 as mm_a_numberofmatgrpchanges ) as CountOfMaterialGroupChanges,
cast( 1 as mm_a_purgreqnitmchanges) as PurchaseRequisitionItemChanges
}
where I_ChangeDocumentItem.DatabaseTable = 'EBAN' and ChangeDocItemChangeType = 'U'
and ChangeDocDatabaseTableField = 'MENGE'
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 mm_a_numberofpurggrpchanges ) as NmbrOfPurchasingGroupChanges,
cast( 0 as mm_a_numberofsupplierchanges ) as NumberOfSupplierChanges,
cast( 0 as mm_a_numberofmatgrpchanges ) as CountOfMaterialGroupChanges,
cast( 1 as mm_a_purgreqnitmchanges) as PurchaseRequisitionItemChanges
}
where I_ChangeDocumentItem.DatabaseTable = 'EBAN' and ChangeDocItemChangeType = 'U'
and ChangeDocDatabaseTableField = 'PREIS'
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 mm_a_numberofpurggrpchanges ) as NmbrOfPurchasingGroupChanges,
cast( 0 as mm_a_numberofsupplierchanges ) as NumberOfSupplierChanges,
cast( 0 as mm_a_numberofmatgrpchanges ) as CountOfMaterialGroupChanges,
cast( 1 as mm_a_purgreqnitmchanges) as PurchaseRequisitionItemChanges
}
where I_ChangeDocumentItem.DatabaseTable = 'EBAN' and ChangeDocItemChangeType = 'U'
and ChangeDocDatabaseTableField = 'EKGRP'
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( 0 as mm_a_numberofpurggrpchanges ) as NmbrOfPurchasingGroupChanges,
cast( 1 as mm_a_numberofsupplierchanges ) as NumberOfSupplierChanges,
cast( 0 as mm_a_numberofmatgrpchanges ) as CountOfMaterialGroupChanges,
cast( 1 as mm_a_purgreqnitmchanges) as PurchaseRequisitionItemChanges
}
where I_ChangeDocumentItem.DatabaseTable = 'EBAN' and ChangeDocItemChangeType = 'U'
and ChangeDocDatabaseTableField = 'LIFNR'
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( 0 as mm_a_numberofpurggrpchanges ) as NmbrOfPurchasingGroupChanges,
cast( 0 as mm_a_numberofsupplierchanges ) as NumberOfSupplierChanges,
cast( 1 as mm_a_numberofmatgrpchanges ) as CountOfMaterialGroupChanges,
cast( 1 as mm_a_purgreqnitmchanges) as PurchaseRequisitionItemChanges
}
where I_ChangeDocumentItem.DatabaseTable = 'EBAN' and ChangeDocItemChangeType = 'U'
and ChangeDocDatabaseTableField = 'MATKL'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEDOCUMENTITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/