P_PURORDMAINTAINITEMDRAFT

CDS View
87 Fields 1 CDS Views

PO Maintenance: Purchase Order Items (Draft)

P_PURORDMAINTAINITEMDRAFT is a CDS View in S/4HANA. PO Maintenance: Purchase Order Items (Draft). It contains 87 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PurOrdMaintainItemAll view union_all CONSUMPTION PO Maintenance: Purchase Order Item All

Fields (87)

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

Learn More