P_PURORDMAINTAINITEMACTIVE

CDS View
81 Fields 2 CDS Views

PO Maintenance: Purchase Order Items (Active)

P_PURORDMAINTAINITEMACTIVE is a CDS View in S/4HANA. PO Maintenance: Purchase Order Items (Active). It contains 81 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_PurOrdMaintainItemAll view from CONSUMPTION PO Maintenance: Purchase Order Item All
P_PurOrdMaintainRefDocumentAll view from CONSUMPTION PO Maintenance: Ref. Doc. for PO Create (Item + Inforecord)

Fields (81)

KeyField CDS FieldsUsed in Views
KEY Plant Plant 2
KEY PurchaseOrder PurchaseOrder 2
KEY PurchaseOrderItem PurchaseOrderItem 2
AcctAssignmentCategory AcctAssignmentCategory 2
ControllingArea ControllingArea 1
CostCenter CostCenter 1
CreatedByUser CreatedByUser 1
Currency Currency 1
Customer Customer 1
DeliveryAddressCityName DeliveryAddressCityName 1
DeliveryAddressCountry DeliveryAddressCountry 1
DeliveryAddressHouseNumber DeliveryAddressHouseNumber 1
DeliveryAddressName DeliveryAddressName 1
DeliveryAddressPostalCode DeliveryAddressPostalCode 1
DeliveryAddressRegion DeliveryAddressRegion 1
DeliveryAddressStreetName DeliveryAddressStreetName 1
DeliveryDate DeliveryDate 2
EditState EditState 1
FunctionalArea FunctionalArea 1
GLAccount GLAccount 1
GoodsReceiptIsExpected GoodsReceiptIsExpected 2
GoodsReceiptIsNonValuated GoodsReceiptIsNonValuated 2
HasTwin HasTwin 1
IncotermsClassification IncotermsClassification 2
IncotermsLocation1 IncotermsLocation1 2
IncotermsLocation2 IncotermsLocation2 2
IncotermsTransferLocation IncotermsTransferLocation 2
IncotermsVersion IncotermsVersion 1
InvoiceIsExpected InvoiceIsExpected 2
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased 2
IsCompletelyDelivered IsCompletelyDelivered 1
IsDeleted IsDeleted 2
IsFinallyInvoiced IsFinallyInvoiced 1
LastChangeDateTime LastChangeDateTime 1
LastChangeUser LastChangeUser 1
ManualDeliveryAddressID ManualDeliveryAddressID 1
Material Material 2
MaterialGroup MaterialGroup 2
MaterialType MaterialType 2
NetPriceIsDerived NetPriceIsDerived 1
OrderItemQtyToBaseQtyDnmntr OrderItemQtyToBaseQtyDnmntr 2
OrderItemQtyToBaseQtyNmrtr OrderItemQtyToBaseQtyNmrtr 2
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr 2
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr 2
OverallLimitAmount OverallLimitAmount 1
OverallLimitAmountIsUnlimited OverallLimitAmountIsUnlimited 1
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct 2
PerformancePeriodEndDate PerformancePeriodEndDate 2
PerformancePeriodStartDate PerformancePeriodStartDate 2
PricingProcedure PricingProcedure 1
ProductType ProductType 2
ProfitCenter ProfitCenter 1
PurchaseOrderItemCategory PurchaseOrderItemCategory 2
PurchaseOrderNetAmount PurchaseOrderNetAmount 1
PurchaseOrderNetPriceAmount PurchaseOrderNetPriceAmount 2
PurchaseOrderNetPriceQuantity PurchaseOrderNetPriceQuantity 2
PurchaseOrderPriceUnit PurchaseOrderPriceUnit 2
PurchaseOrderQty PurchaseOrderQty 2
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit 2
PurchasingDocumentItemText PurchasingDocumentItemText 2
PurchasingDocumentType PurchasingDocumentType 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
PurOrderEffectiveItemAmount PurOrderEffectiveItemAmount 1
RefPurchaseOutlineAgreement RefPurchaseOutlineAgreement 2
RefPurchOutlineAgrmtItem RefPurchOutlineAgrmtItem 2
RefPurOrderInfoRecord RefPurOrderInfoRecord 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
ServicePackage ServicePackage 1
ServicePerformer ServicePerformer 2
StorageLocation StorageLocation 2
Supplier Supplier 1
SupplierMaterialNumber SupplierMaterialNumber 2
TaxCalculationProcedure TaxCalculationProcedure 1
TaxCode TaxCode 2
TaxJurisdiction TaxJurisdiction 2
TaxJurisdictionCalcProcedure TaxJurisdictionCalcProcedure 1
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct 2
UnlimitedOverdeliveryIsAllowed UnlimitedOverdeliveryIsAllowed 2
WBSElementInternalID WBSElementInternalID 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 Maintenance: Purchase Order Items (Active)
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PURORDMAINTAINITEMACTIVE (
    PLANT,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    ACCTASSIGNMENTCATEGORY,
    CONTROLLINGAREA,
    COSTCENTER,
    CREATEDBYUSER,
    CURRENCY,
    CUSTOMER,
    DELIVERYADDRESSCITYNAME,
    DELIVERYADDRESSCOUNTRY,
    DELIVERYADDRESSHOUSENUMBER,
    DELIVERYADDRESSNAME,
    DELIVERYADDRESSPOSTALCODE,
    DELIVERYADDRESSREGION,
    DELIVERYADDRESSSTREETNAME,
    DELIVERYDATE,
    EDITSTATE,
    FUNCTIONALAREA,
    GLACCOUNT,
    GOODSRECEIPTISEXPECTED,
    GOODSRECEIPTISNONVALUATED,
    HASTWIN,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    INVOICEISEXPECTED,
    INVOICEISGOODSRECEIPTBASED,
    ISCOMPLETELYDELIVERED,
    ISDELETED,
    ISFINALLYINVOICED,
    LASTCHANGEDATETIME,
    LASTCHANGEUSER,
    MANUALDELIVERYADDRESSID,
    MATERIAL,
    MATERIALGROUP,
    MATERIALTYPE,
    NETPRICEISDERIVED,
    ORDERITEMQTYTOBASEQTYDNMNTR,
    ORDERITEMQTYTOBASEQTYNMRTR,
    ORDERPRICEUNITTOORDERUNITNMRTR,
    ORDPRICEUNITTOORDERUNITDNMNTR,
    OVERALLLIMITAMOUNT,
    OVERALLLIMITAMOUNTISUNLIMITED,
    OVERDELIVTOLRTDLMTRATIOINPCT,
    PERFORMANCEPERIODENDDATE,
    PERFORMANCEPERIODSTARTDATE,
    PRICINGPROCEDURE,
    PRODUCTTYPE,
    PROFITCENTER,
    PURCHASEORDERITEMCATEGORY,
    PURCHASEORDERNETAMOUNT,
    PURCHASEORDERNETPRICEAMOUNT,
    PURCHASEORDERNETPRICEQUANTITY,
    PURCHASEORDERPRICEUNIT,
    PURCHASEORDERQTY,
    PURCHASEORDERQUANTITYUNIT,
    PURCHASINGDOCUMENTITEMTEXT,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURORDEREFFECTIVEITEMAMOUNT,
    REFPURCHASEOUTLINEAGREEMENT,
    REFPURCHOUTLINEAGRMTITEM,
    REFPURORDERINFORECORD,
    SALESORDER,
    SALESORDERITEM,
    SERVICEPACKAGE,
    SERVICEPERFORMER,
    STORAGELOCATION,
    SUPPLIER,
    SUPPLIERMATERIALNUMBER,
    TAXCALCULATIONPROCEDURE,
    TAXCODE,
    TAXJURISDICTION,
    TAXJURISDICTIONCALCPROCEDURE,
    UNDERDELIVTOLRTDLMTRATIOINPCT,
    UNLIMITEDOVERDELIVERYISALLOWED,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (PLANT, PURCHASEORDER, PURCHASEORDERITEM)
);

Learn More