P_POITEMINVOICEPRICE

CDS View
23 Fields 1 CDS Views

PO Item for Invoice Price

P_POITEMINVOICEPRICE is a CDS View in S/4HANA. PO Item for Invoice Price. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PurgMatlPriceChg1 view inner CONSUMPTION Material Price Change 1

Fields (23)

KeyField CDS FieldsUsed in Views
AccountAssignmentCategory AccountAssignmentCategory 1
BaseUnit BaseUnit 1
CompanyCode CompanyCode 1
DocumentCurrency DocumentCurrency 1
IsReturnsItem IsReturnsItem 1
Material Material 1
MaterialGroup MaterialGroup 1
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution 1
NetAmount NetAmount 1
NetPriceAmount NetPriceAmount 1
NetPriceQuantity NetPriceQuantity 1
OrderItemQtyToBaseQtyDnmntr OrderItemQtyToBaseQtyDnmntr 1
OrderItemQtyToBaseQtyNmrtr OrderItemQtyToBaseQtyNmrtr 1
OrderPriceUnit OrderPriceUnit 1
OrderQuantity OrderQuantity 1
Plant Plant 1
ProductType ProductType 1
PurchaseOrderDate PurchaseOrderDate 1
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit 1
PurchaseOrderType PurchaseOrderType 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
Supplier Supplier 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- PO Item for Invoice Price
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_POITEMINVOICEPRICE (
    ACCOUNTASSIGNMENTCATEGORY,
    BASEUNIT,
    COMPANYCODE,
    DOCUMENTCURRENCY,
    ISRETURNSITEM,
    MATERIAL,
    MATERIALGROUP,
    MULTIPLEACCTASSGMTDISTRIBUTION,
    NETAMOUNT,
    NETPRICEAMOUNT,
    NETPRICEQUANTITY,
    ORDERITEMQTYTOBASEQTYDNMNTR,
    ORDERITEMQTYTOBASEQTYNMRTR,
    ORDERPRICEUNIT,
    ORDERQUANTITY,
    PLANT,
    PRODUCTTYPE,
    PURCHASEORDERDATE,
    PURCHASEORDERQUANTITYUNIT,
    PURCHASEORDERTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SUPPLIER
);

Learn More