I_PURCHASEORDERBYPRODUCT

CDS View

Purchase Order by Product

I_PURCHASEORDERBYPRODUCT is a CDS View in S/4HANA. Purchase Order by Product. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ProductObjPgPurchaseOrder view from CONSUMPTION Product Object Page - Purchase Order 
@AbapCatalog.sqlViewName: 'IPRCHSORDRBYPRD'
@EndUserText.label: 'Purchase Order by Product'

@AbapCatalog.compiler.compareFilter: true
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #COMPOSITE
@ObjectModel: {
    representativeKey: 'PurchaseOrder',
    usageType: {
        serviceQuality: #B,
        sizeCategory : #L,
        dataClass: #TRANSACTIONAL
   }
}

define view I_PurchaseOrderByProduct
  as select distinct from I_PurchaseOrderItem
{
      @ObjectModel.foreignKey.association: '_Product'
  key Material                                                 as Product,
  key cast(PurchaseOrder as vdm_purchaseorder preserving type) as PurchaseOrder,

      _Material                                                as _Product,
      _PurchaseOrder
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDERITEM"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_PURCHASEORDER"
],
"BASE":
[
"I_PURCHASEORDERITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More