P_POItemInvoicePrice

DDL: P_POITEMINVOICEPRICE SQL: PPOITMINVPRC Type: view CONSUMPTION

PO Item for Invoice Price

P_POItemInvoicePrice is a Consumption CDS View that provides data about "PO Item for Invoice Price" in SAP S/4HANA. It reads from 2 data sources (I_PurchaseOrder, I_PurchaseOrderItem) and exposes 25 fields with key fields PurchaseOrder, PurchaseOrderItem.

2 data source(s) 25 fields

Data Sources (2)

SourceAliasJoin Type
I_PurchaseOrder _PurOrd from
I_PurchaseOrderItem _PurOrdItem inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPOITMINVPRC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label PO Item for Invoice Price view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
CompanyCode I_PurchaseOrderItem CompanyCode
IsReturnsItem I_PurchaseOrderItem IsReturnsItem
PurchaseOrderDate I_PurchaseOrder PurchaseOrderDate
PurchasingOrganization I_PurchaseOrder PurchasingOrganization
PurchasingGroup I_PurchaseOrder PurchasingGroup
Supplier I_PurchaseOrder Supplier
PurchaseOrderType I_PurchaseOrder PurchaseOrderType
Material I_PurchaseOrderItem Material
MaterialGroup I_PurchaseOrderItem MaterialGroup
Plant I_PurchaseOrderItem Plant
ProductType I_PurchaseOrderItem ProductType
NetPriceAmount I_PurchaseOrderItem NetPriceAmount
NetPriceQuantity I_PurchaseOrderItem NetPriceQuantity
OrderQuantity I_PurchaseOrderItem OrderQuantity
PurchaseOrderQuantityUnit I_PurchaseOrderItem PurchaseOrderQuantityUnit
AccountAssignmentCategory I_PurchaseOrderItem AccountAssignmentCategory
MultipleAcctAssgmtDistribution I_PurchaseOrderItem MultipleAcctAssgmtDistribution
NetAmount I_PurchaseOrderItem NetAmount
DocumentCurrency I_PurchaseOrder DocumentCurrency
OrderPriceUnit I_PurchaseOrderItem OrderPriceUnit
BaseUnit I_PurchaseOrderItem BaseUnit
OrderItemQtyToBaseQtyDnmntr I_PurchaseOrderItem OrderItemQtyToBaseQtyDnmntr
OrderItemQtyToBaseQtyNmrtr I_PurchaseOrderItem OrderItemQtyToBaseQtyNmrtr 
@AbapCatalog.sqlViewName: 'PPOITMINVPRC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType : #CONSUMPTION
@VDM.private : true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'PO Item for Invoice Price'
define view P_POItemInvoicePrice 
as select from I_PurchaseOrder as _PurOrd
inner join I_PurchaseOrderItem as _PurOrdItem on _PurOrd.PurchaseOrder = _PurOrdItem.PurchaseOrder
                                                             

{
        key _PurOrd.PurchaseOrder,
        key PurchaseOrderItem,
        
        _PurOrdItem.CompanyCode,
        _PurOrdItem.IsReturnsItem,
        _PurOrd.PurchaseOrderDate,
        _PurOrd.PurchasingOrganization,
        _PurOrd.PurchasingGroup,
        _PurOrd.Supplier,
        _PurOrd.PurchaseOrderType,
        _PurOrdItem.Material,
        _PurOrdItem.MaterialGroup,
        _PurOrdItem.Plant,
        _PurOrdItem.ProductType,
        _PurOrdItem.NetPriceAmount,
        _PurOrdItem.NetPriceQuantity,
        _PurOrdItem.OrderQuantity,
        _PurOrdItem.PurchaseOrderQuantityUnit,
        
        _PurOrdItem.AccountAssignmentCategory,
        _PurOrdItem.MultipleAcctAssgmtDistribution,
        _PurOrdItem.NetAmount,
        
        _PurOrd.DocumentCurrency,
        _PurOrdItem.OrderPriceUnit,
        _PurOrdItem.BaseUnit,
        
        _PurOrdItem.OrderItemQtyToBaseQtyDnmntr,
        _PurOrdItem.OrderItemQtyToBaseQtyNmrtr
         
            
}where      _PurOrdItem.PurchasingDocumentDeletionCode = '' 
        and _PurOrd.PurchasingDocumentDeletionCode = '' 
        and _PurOrd.PurchasingCompletenessStatus = ''
        and _PurOrd.ReleaseIsNotCompleted = '' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDER",
"I_PURCHASEORDERITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More