I_PURCHASEORDERITEMENHANCED

CDS View
57 Fields 8 CDS Views

Purchase Order Item enhanced

I_PURCHASEORDERITEMENHANCED is a CDS View in S/4HANA. Purchase Order Item enhanced. It contains 57 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
C_Arberp_ConfIn_PO_Item view from CONSUMPTION CDS View of purchase order item for CONF IN
C_Arberp_Ordrout_Po_Item view from CONSUMPTION CDS View of purchase order items for ORDR OUT
C_BSOrdItmProcFlwPurchaseOrder view from CONSUMPTION PO Item Attrib for BSOrd Prgrs
C_PoByPurgInfoRecd view from CONSUMPTION Purchase Order Item
C_PurchaseOrderGR view from CONSUMPTION View for GR and Purchase Order
C_PurchaseOrderLimitItem view from CONSUMPTION Purchase Order Limit Item
C_PurOrderItemHierFactSheet view from CONSUMPTION Purchase Order Item Hierarchy information
C_PurOrdItemEnh view from CONSUMPTION Purchase Order Item

Fields (57)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder PurchaseOrder,UI5NetworkGraphAttributeValue 4
KEY PurchaseOrderItem PurchaseOrderItem 3
AccountAssignmentCategory AccountAssignmentCategory 1
CommodityCode CommodityCode 2
CompanyCode CompanyCode 1
DocumentCurrency DocumentCurrency 2
EffectiveAmount EffectiveAmount 1
EvaldRcptSettlmtIsAllowed EvaldRcptSettlmtIsAllowed 1
ExpectedOverallLimitAmount ExpectedOverallLimitAmount 1
FirstDeliveryDate FirstDeliveryDate 1
GoodsReceiptIsExpected GoodsReceiptIsExpected 2
GoodsReceiptIsNonValuated GoodsReceiptIsNonValuated 1
IncotermsClassification IncotermsClassification 3
IncotermsLocation1 IncotermsLocation1 2
IncotermsLocation2 IncotermsLocation2 2
IncotermsTransferLocation IncotermsTransferLocation 1
InfoRecordIsToBeUpdated InfoRecordIsToBeUpdated 2
InternationalArticleNumber InternationalArticleNumber 1
InvoiceIsExpected InvoiceIsExpected 2
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased 1
IsCompletelyDelivered IsCompletelyDelivered 2
IsFinallyInvoiced IsFinallyInvoiced 1
IsReturnsItem IsReturnsItem 1
IsToBeAcceptedAtOrigin IsToBeAcceptedAtOrigin 2
ItemDeliveryAddressID ItemDeliveryAddressID 1
Manufacturer Manufacturer 1
ManufacturerMaterial ManufacturerMaterial 2
ManufacturerPartNmbr ManufacturerPartNmbr 1
Material Material,Product 3
MaterialGroup MaterialGroup 3
NetAmount NetAmount 1
NetPriceAmount NetPriceAmount 1
OrderPriceUnit OrderPriceUnit 1
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr 1
OrderQuantity OrderQuantity 2
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr 1
OverallLimitAmount OverallLimitAmount 1
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct 1
Plant Plant 3
PriceIsToBePrinted PriceIsToBePrinted 1
ProductType ProductType 1
PurchaseOrderItemCategory PurchaseOrderItemCategory,PurchasingDocumentCategory 3
PurchaseOrderItemText PurchaseOrderItemText 3
PurchaseOrderNetAmount PurchaseOrderItemNetAmount 1
PurchaseOrderNetPriceQuantity PurchaseOrderNetPriceQuantity 1
PurchaseOrderQty PurchaseOrderQty 1
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit 2
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode 2
PurContractForOverallLimit PurContractForOverallLimit 2
PurContractItemForOverallLimit PurContractItemForOverallLimit 1
ServicePackage ServicePackage 1
StorageLocation StorageLocation 2
SupplierConfirmationControlKey SupplierConfirmationControlKey 1
SupplierMaterialNumber SupplierMaterialNumber 1
TaxJurisdiction TaxJurisdiction 1
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct 1
UnlimitedOverdeliveryIsAllowed UnlimitedOverdeliveryIsAllowed 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.

-- Purchase Order Item enhanced
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCHASEORDERITEMENHANCED (
    PURCHASEORDER,
    PURCHASEORDERITEM,
    ACCOUNTASSIGNMENTCATEGORY,
    COMMODITYCODE,
    COMPANYCODE,
    DOCUMENTCURRENCY,
    EFFECTIVEAMOUNT,
    EVALDRCPTSETTLMTISALLOWED,
    EXPECTEDOVERALLLIMITAMOUNT,
    FIRSTDELIVERYDATE,
    GOODSRECEIPTISEXPECTED,
    GOODSRECEIPTISNONVALUATED,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INFORECORDISTOBEUPDATED,
    INTERNATIONALARTICLENUMBER,
    INVOICEISEXPECTED,
    INVOICEISGOODSRECEIPTBASED,
    ISCOMPLETELYDELIVERED,
    ISFINALLYINVOICED,
    ISRETURNSITEM,
    ISTOBEACCEPTEDATORIGIN,
    ITEMDELIVERYADDRESSID,
    MANUFACTURER,
    MANUFACTURERMATERIAL,
    MANUFACTURERPARTNMBR,
    MATERIAL,
    MATERIALGROUP,
    NETAMOUNT,
    NETPRICEAMOUNT,
    ORDERPRICEUNIT,
    ORDERPRICEUNITTOORDERUNITNMRTR,
    ORDERQUANTITY,
    ORDPRICEUNITTOORDERUNITDNMNTR,
    OVERALLLIMITAMOUNT,
    OVERDELIVTOLRTDLMTRATIOINPCT,
    PLANT,
    PRICEISTOBEPRINTED,
    PRODUCTTYPE,
    PURCHASEORDERITEMCATEGORY,
    PURCHASEORDERITEMTEXT,
    PURCHASEORDERNETAMOUNT,
    PURCHASEORDERNETPRICEQUANTITY,
    PURCHASEORDERQTY,
    PURCHASEORDERQUANTITYUNIT,
    PURCHASINGDOCUMENTDELETIONCODE,
    PURCONTRACTFOROVERALLLIMIT,
    PURCONTRACTITEMFOROVERALLLIMIT,
    SERVICEPACKAGE,
    STORAGELOCATION,
    SUPPLIERCONFIRMATIONCONTROLKEY,
    SUPPLIERMATERIALNUMBER,
    TAXJURISDICTION,
    UNDERDELIVTOLRTDLMTRATIOINPCT,
    UNLIMITEDOVERDELIVERYISALLOWED,
    PRIMARY KEY (PURCHASEORDER, PURCHASEORDERITEM)
);

Learn More