I_PURCHASINGDOCUMENTITEM

CDS View
102 Fields 97 CDS Views

Purchasing Document Item

I_PURCHASINGDOCUMENTITEM is a CDS View in S/4HANA. Purchasing Document Item. It contains 102 fields. 97 CDS views read from this table.

CDS Views using this table (97)

ViewTypeJoinVDMDescription
C_DspDocFlwPurDocItemAttrib view from CONSUMPTION PO Item Attributes for DDF
C_ExchPurContrItemSchedgKPI view from CONSUMPTION Exchange Purchase Contract Item Scheduling for KPI
C_FldLogsProcRcptCstmFldExtn view from CONSUMPTION Consumption For Extensibility
C_GB_StRpAuditMMFileC view_entity inner CONSUMPTION GB HRMC Audit File for MM - Cube
C_GRIRPurchasingDocItem view from CONSUMPTION GR/IR Purchasing Document Item
C_InvcExcdGRPurgDocItm view from CONSUMPTION Overpaid GR in Purchasing Document Item
C_POItemQtyAndValueDCCalc view from CONSUMPTION PO Item Qty and Value in DC Calc Fields
C_ProcurementSmartFilter view inner CONSUMPTION Global Filter for Procurement Overview Page
C_PurContrSourceNomination view from CONSUMPTION Purchase Contract Header View
C_PurgDocFldValChg view inner CONSUMPTION Change Information Purchasing Document
C_PurgDocItemPurgIssue view from CONSUMPTION Purg Doc Item Purchasing Issue
C_PurgDocSuplrConfObj view inner CONSUMPTION Supplier Confirmations Object Page
C_PurOrdMaintainOutlAIValHelp view from CONSUMPTION PO Maintenance: Value Help for Outline Agreement Items
C_PurReqnSchedAgrmtVH view from CONSUMPTION Sched Agreement val help for Prof PR
C_RelPurOrdStkTranspOrdDlvr view from CONSUMPTION Reltd Purchase Order/Stk Transport Order
C_RequirementTrackingPurRFQ view from CONSUMPTION RFQ by Requirement Tracking
C_SlsDocFlfmtPurgDocItem view from CONSUMPTION Sales Doc Fulfillment: Purg Doc Item
C_SuplrEvalChangedScores view inner CONSUMPTION Supplier Evaluation Changed Scores
C_UnlmtdOvrdelivPurOrder view from CONSUMPTION Unlimited Over Delivery Purchase Order
I_AlignPOSchedLineQtyInBsUoM view from BASIC Qty in Base unit of measure
I_AlignPurOrdHdrItmSched view from COMPOSITE PO Header, Item and Schedule Line Data
I_CFinPurchasingDocHistory view inner COMPOSITE CFin Purchasing Document: History
I_CFinPurchasingDocumentItem view union_all COMPOSITE CFin Purchasing Document: Item
I_CFinPurgDocAccountAssignment view inner COMPOSITE CFin Purchasing Doc: Account Assignment
I_CFinPurgDocScheduleLine view inner COMPOSITE CFin Purchasing Document: Schedule Line
I_DigitalVehiclePurOrderItem view_entity inner COMPOSITE Vehicle Purchase Order
I_FieldLogisticsPurchaseOrder view_entity from COMPOSITE Field Logistics Purchase Order
I_FldLogsDocFlwInbDeliv view from COMPOSITE Field Logistics : Inbound Delivery
I_FldLogsKitOutbDelivIndrctRef view_entity from COMPOSITE Kit Outbound Delivery with Indirect PO Ref
I_FldLogsKitOutbDelivIndrctRef view_entity inner COMPOSITE Kit Outbound Delivery with Indirect PO Ref
I_FldLogsKitOutbDelivItmRef view_entity inner COMPOSITE Kit Outbound Delivery Item Reference Document
I_FldLogsOutbDelivAtRmteInfo view_entity from COMPOSITE Outbound Delivery Info At Remote
I_FldLogsPrdcssrDocRemote view from COMPOSITE Field Logistics Predecessor documents
I_FldLogsProcessReceiptsTP view inner TRANSACTIONAL Field Logistics : Process Receipts
I_FldLogsProcRcptFollowOnDocs view from COMPOSITE Field Logistics Follow on Documents
I_FldLogsProcRcptOutpReq view_entity from COMPOSITE FL Process Receipts Output Request
I_FldLogsPurchaseOrderVH view inner COMPOSITE Field Logistics : Process Receipts PO Value Help
I_FldLogsPurchasingItem view_entity from COMPOSITE Field Logistics Purchasing Items
I_FldLogsRcptHndlgUnitOutpReq view_entity from COMPOSITE FL Process Receipts Output Request
I_FldLogsRetServicePurOrdVH view from COMPOSITE Service PO F4 Help for FL Returns
I_FldLogsSTOFrmPurOrd view_entity from COMPOSITE STO Details by Purchase Order
I_MRPPurchaseOrder view inner COMPOSITE MRP Purchase Order
I_ProdCmplncLicRlvtPurgDocs view from COMPOSITE License Relevant Purchase Order Items
I_PurchaseOrderItemPurgIssue view inner COMPOSITE SOFM Purchase Order Item Purchasing Issue
I_PurchaseOrderOfSIT view from TRANSACTIONAL Value Help for Purchase Order
I_PurchasingDocumentItemStdVH view from COMPOSITE Purchasing Document Item
I_PurOrdAccrsCFinPurgDocAssgmt view inner COMPOSITE PurOrdAccrs: CFin PO Item Assgmt
I_PurOrdAccrsCFinPurgDocItem view union_all COMPOSITE PurOrdAccrs: Purchasing Document Item
I_RFM_PurContrItmCnsmpnOth view from COMPOSITE Pur Contr Itm Cnsmpn Oth
I_RfqItem_Api01 view from BASIC Item in Request for Quotation
I_SchedAgrmtReleaseListItem view from COMPOSITE Schedule Agreement Release List Item
I_SourcesOfSupply view from COMPOSITE Sources of Supply
I_SupAssgmtSitnOrdItemDet view union_all COMPOSITE View at Order item details for situation
OIJ09_SourceNominationSchedule view inner Source Schedule
P_AnaEketSdmMiration view inner COMPOSITE Pur Docs not migrated to MMPUR_ANA_EKET
P_AnaEketSdmMiration1 view inner COMPOSITE Pur Docs not migrated to MMPUR_ANA_EKET
P_ARUNDMNDITEM view union COMPOSITE
P_DDMaterialSOS view inner CONSUMPTION
P_DDOrderDetails view union_all CONSUMPTION
P_DDPurchaseOrder view inner COMPOSITE
P_FilteredSourceOfSupply view inner CONSUMPTION Filtered Source of Supply
P_GetLastPostingDate view from COMPOSITE
P_GRIR_USER view from CONSUMPTION
P_JITMatlRcpntDocuments view from COMPOSITE
P_JP_IRPurchaseDocumentHeader view inner COMPOSITE
P_MY_SupplierInvoiceItem view inner COMPOSITE
P_POItemCastedAmounts view from CONSUMPTION PO Item Casted Amounts
P_PrepaymentRefDocTotalAmount view inner COMPOSITE Prepayment Document Total Amount
P_PrepaymentRefDocTotalAmtPO view_entity inner COMPOSITE Prepayment Document Total Amount
P_PurchaseOrderItemForCIC view_entity from BASIC
P_Purchaseorders_Fs view left_outer BASIC
P_PurchasingGroupAnalysis1 view from CONSUMPTION Purchasing Group Analysis 1
P_PurchDocAmntInDocCurr view from COMPOSITE Purch Document Amnt In Document Currency
P_PurchDocWthGRIRFlagNotSet view inner CONSUMPTION Purchasing Document filtered by date
P_PurDocItemCurConv view from CONSUMPTION Purchase Document with Currency Conversion for dates
P_PurDocItmforReturnDel view from CONSUMPTION Purchasing Document Item for Return Del
P_PurgDocMissingSuplrConf view from CONSUMPTION P view for missing confirmations
P_Purgdocscheduleline view inner CONSUMPTION Purchasing Document Schedule Lines
P_PurgDocSuplrConf view inner CONSUMPTION
P_PurgOrdSchKeyDate view inner CONSUMPTION View for Delivery Date and Quantity
P_PurOrdItemTimeVar view inner CONSUMPTION Purchase Order Item for Time Variance
P_PurOrdMaintainPDocWAccAsLine view from CONSUMPTION
P_PurReqnSuccssrDocs view from COMPOSITE
P_RFQSuccssrDocs view from COMPOSITE
P_RFQSuccssrDocs view union_all COMPOSITE
P_RU_MaterialRcptDateMM3 view inner CONSUMPTION
P_RU_PurchaseOrderHistoryGRIR view from CONSUMPTION
P_RU_SuplrInvcAcctgItem view inner CONSUMPTION
P_RU_SuplrInvcLogsItem view inner CONSUMPTION
P_SalesOrderInSupplyPurgIssue1 view from COMPOSITE
P_SalesOrderInSupplyPurgIssue4 view from COMPOSITE
P_SCHDLNMIGRATION view inner CONSUMPTION Schedule Line Migration
P_SlsOrderInSupplyPurgIssue3 view from COMPOSITE
P_SlsOrderInSupplyPurgIssue3 view union_all COMPOSITE
P_SourcesOfSupply view inner COMPOSITE
P_TotalGrInvQty view from CONSUMPTION
shsm_ekpo_ekko view from Value Help for Purchasing Document

Fields (102)

KeyField CDS FieldsUsed in Views
KEY Material Material,matnr,Product 28
KEY MaterialGroup MaterialGroup,matkl,ProductGroup 18
KEY Plant Plant,storage_plant,werks 32
KEY PurchasingDocument OrderID,PurchaseOrder,PurchasingDocument,PurchasingDocumentNumber,RequestForQuotation,SchedulingAgreement,SourceDocument,StockTransportOrder,SubsequentDocument 47
KEY PurchasingDocumentItem PurchaseOrderItem,PurchasingDocumentItem,PurchasingDocumentItemNumber,SchedulingAgreementItem,SourceDocumentItem,SubsequentDocumentItem 54
KEY PurchasingDocumentItemUniqueID MaintOrdProcurementDocument,PurchasingDocumentItemUniqueID 4
KEY RequestForQuotationItem PrecedingDocumentItem 1
KEY SupplierQuotation PrecedingDocument 1
KEY SupplierQuotationItem PrecedingDocumentItem 1
_CompanyCode _CompanyCode 4
_ConsumptionPosting _ConsumptionPosting 2
_DocumentCurrency _DocumentCurrency 5
_ManufacturerMaterial _ManufacturerMaterial 1
_Material _Material 2
_MaterialGroup _MaterialGroup 3
_OrderQuantityUnit _OrderQuantityUnit 2
_Plant _Plant 6
_ProductType _ProductType 1
_PurchaseContract _PurchaseContract 1
_PurchaseContractItem _PurchaseContractItem 1
_PurchasingDocument _PurchasingDocument,_Schedgagrmthdr 9
_PurchasingInfoRecord _PurchasingInfoRecord 1
_PurgDocumentCategory _PurgDocumentCategory 3
_PurgDocumentItemCategory _PurgDocumentItemCategory 2
AccountAssignmentCategory AccountAssignmentCategory,knttp 6
BaseUnit BaseUnit,lmein 8
BudgetPeriod BudgetPeriod 2
CommitmentItem CommitmentItemShortID 2
CompanyCode bukrs,CompanyCode 8
ConsumptionPosting ConsumptionPosting 2
DocumentCurrency Currency,DocumentCurrency,MaintOrdOpComponentCurrency 15
EvaldRcptSettlmtIsAllowed EvaldRcptSettlmtIsAllowed 2
ExpectedOverallLimitAmount ExpectedOverallLimitAmount 2
FunctionalArea FunctionalArea 2
Fund Fund 2
FundsCenter FundsCenter 2
GoodsReceiptDurationInDays GoodsReceiptDurationInDays,MaterialGoodsReceiptDuration 2
GoodsReceiptIsExpected GoodsReceiptIsExpected,wepos 11
GoodsReceiptIsNonValuated GoodsReceiptIsNonValuated 3
GrantID GrantID 2
GrossAmount GrossAmount 2
IncotermsClassification IncotermsClassification 1
IncotermsLocation1 IncotermsLocation1 1
IncotermsLocation2 IncotermsLocation2 1
IncotermsTransferLocation IncotermsTransferLocation 1
InventorySpecialStockType InventorySpecialStockType 4
InvoiceIsExpected InvoiceIsExpected 3
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased,webre 8
IsCompletelyDelivered complete_indicator,elikz,IsCompletelyDelivered 15
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 7
IsFinallyInvoiced IsFinallyInvoiced 9
IsOrderAcknRqd IsOrderAcknRqd 1
IsReturnsItem IsReturnsItem,retpo,return_indicator 7
IsStatisticalItem IsStatisticalItem 2
IssuingStorageLocation SupplyingStorageLocation 1
ManualDeliveryAddressID ManualDeliveryAddressID 1
Manufacturer Manufacturer 1
ManufacturerMaterial ManufacturerMaterial,MaterialNumber 4
ManufacturerPartNmbr ManufacturerPartNmbr 1
MaterialType MaterialType 2
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution,vrtkz 5
NetAmount NetAmount,netwr 8
NetPriceAmount netpr,NetPriceAmount 12
NetPriceQuantity NetPriceQuantity,peinh 7
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount 2
OrderItemQtyToBaseQtyDnmntr OrderItemQtyToBaseQtyDnmntr,quantity_denominator,umren 6
OrderItemQtyToBaseQtyNmrtr OrderItemQtyToBaseQtyNmrtr,quantity_numerator,umrez 6
OrderPriceUnit bprme,OrderPriceUnit 5
OrderPriceUnitToOrderUnitNmrtr BPUMZ,OrderPriceUnitToOrderUnitNmrtr 4
OrderQuantity FldLogsPOTotalQty,MENGE_EKPO,OrderQuantity,PurchaseOrderItemQuantity,PurchasingDocumentOrderQty,quantity,RequirementQuantityInBaseUnit 17
OrderQuantityUnit BaseUnit,meins,MEINS_EKPO,OrderQuantityUnit,OrderUnit,PurchaseOrderItemQuantityUnit,PurchaseOrderQuantityUnit,PurgDocOrderQuantityUnit,quantity_unit 33
OrdPriceUnitToOrderUnitDnmntr bpumn,OrdPriceUnitToOrderUnitDnmntr 4
OverallLimitAmount OverallLimitAmount 2
PartialDeliveryIsAllowed PartialDeliveryIsAllowed 2
PartialInvoiceDistribution PartialInvoiceDistribution 3
PlannedDeliveryDurationInDays MaterialPlannedDeliveryDurn,PlannedDeliveryDurationInDays 2
PlndOrderReplnmtElmntType PlndOrderReplnmtElmntType 1
ProductType ProductType,ProductTypeCode,PurgDocProductType 6
ProfitCenter ProfitCenter 3
PurchaseContract konnr,PurchaseContract,PurchaseOutlineAgreement 4
PurchaseContractItem KTPNR,PurchaseContractItem,PurchaseOutlineAgreementItem 3
PurchaseRequisition PurchaseRequisition 8
PurchaseRequisitionItem PurchaseRequisitionItem 7
PurchasingDocumentCategory PurchasingDocumentCategory,SourceDocumentType,SubsequentDocumentCategory 17
PurchasingDocumentDeletionCode deletion_indicator,loekz,PurchasingDocItemDeletionCode,PurchasingDocumentDeletionCode 10
PurchasingDocumentItemCategory aspect_type,ItemCategory,MaterialProcurementCategory,pstyp,PurchasingDocumentItemCategory 14
PurchasingDocumentItemText ComponentDescription,PurchasingDocumentItemText,PurchasingText,ShortText,text 18
PurchasingInfoRecord PurchasingInfoRecord 3
ReferenceDeliveryAddressID ReferenceDeliveryAddressID 1
RequirementTracking RequirementTracking 2
RequisitionerName RequisitionerName 2
ServicePackage ServicePackage 2
ServicePerformer SERVICEPERFORMER 1
StockType TargetStockType 1
StorageLocation lgort,ReceivingStorageLocation,StorageLocation 7
Subcontractor Subcontractor 1
SupplierConfirmationControlKey bstae,ConfirmationControl,SupplierConfirmationControlKey 3
SupplierMaterialNumber SupplierMaterialNumber 2
TargetQuantity TargetQuantity 5
TaxCode TaxCode 3
TaxJurisdiction TaxJurisdiction 2
ValuationType ValuationType 2

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.

-- Purchasing Document Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCHASINGDOCUMENTITEM (
    MATERIAL,
    MATERIALGROUP,
    PLANT,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGDOCUMENTITEMUNIQUEID,
    REQUESTFORQUOTATIONITEM,
    SUPPLIERQUOTATION,
    SUPPLIERQUOTATIONITEM,
    _COMPANYCODE,
    _CONSUMPTIONPOSTING,
    _DOCUMENTCURRENCY,
    _MANUFACTURERMATERIAL,
    _MATERIAL,
    _MATERIALGROUP,
    _ORDERQUANTITYUNIT,
    _PLANT,
    _PRODUCTTYPE,
    _PURCHASECONTRACT,
    _PURCHASECONTRACTITEM,
    _PURCHASINGDOCUMENT,
    _PURCHASINGINFORECORD,
    _PURGDOCUMENTCATEGORY,
    _PURGDOCUMENTITEMCATEGORY,
    ACCOUNTASSIGNMENTCATEGORY,
    BASEUNIT,
    BUDGETPERIOD,
    COMMITMENTITEM,
    COMPANYCODE,
    CONSUMPTIONPOSTING,
    DOCUMENTCURRENCY,
    EVALDRCPTSETTLMTISALLOWED,
    EXPECTEDOVERALLLIMITAMOUNT,
    FUNCTIONALAREA,
    FUND,
    FUNDSCENTER,
    GOODSRECEIPTDURATIONINDAYS,
    GOODSRECEIPTISEXPECTED,
    GOODSRECEIPTISNONVALUATED,
    GRANTID,
    GROSSAMOUNT,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INVENTORYSPECIALSTOCKTYPE,
    INVOICEISEXPECTED,
    INVOICEISGOODSRECEIPTBASED,
    ISCOMPLETELYDELIVERED,
    ISENDOFPURPOSEBLOCKED,
    ISFINALLYINVOICED,
    ISORDERACKNRQD,
    ISRETURNSITEM,
    ISSTATISTICALITEM,
    ISSUINGSTORAGELOCATION,
    MANUALDELIVERYADDRESSID,
    MANUFACTURER,
    MANUFACTURERMATERIAL,
    MANUFACTURERPARTNMBR,
    MATERIALTYPE,
    MULTIPLEACCTASSGMTDISTRIBUTION,
    NETAMOUNT,
    NETPRICEAMOUNT,
    NETPRICEQUANTITY,
    NONDEDUCTIBLEINPUTTAXAMOUNT,
    ORDERITEMQTYTOBASEQTYDNMNTR,
    ORDERITEMQTYTOBASEQTYNMRTR,
    ORDERPRICEUNIT,
    ORDERPRICEUNITTOORDERUNITNMRTR,
    ORDERQUANTITY,
    ORDERQUANTITYUNIT,
    ORDPRICEUNITTOORDERUNITDNMNTR,
    OVERALLLIMITAMOUNT,
    PARTIALDELIVERYISALLOWED,
    PARTIALINVOICEDISTRIBUTION,
    PLANNEDDELIVERYDURATIONINDAYS,
    PLNDORDERREPLNMTELMNTTYPE,
    PRODUCTTYPE,
    PROFITCENTER,
    PURCHASECONTRACT,
    PURCHASECONTRACTITEM,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTDELETIONCODE,
    PURCHASINGDOCUMENTITEMCATEGORY,
    PURCHASINGDOCUMENTITEMTEXT,
    PURCHASINGINFORECORD,
    REFERENCEDELIVERYADDRESSID,
    REQUIREMENTTRACKING,
    REQUISITIONERNAME,
    SERVICEPACKAGE,
    SERVICEPERFORMER,
    STOCKTYPE,
    STORAGELOCATION,
    SUBCONTRACTOR,
    SUPPLIERCONFIRMATIONCONTROLKEY,
    SUPPLIERMATERIALNUMBER,
    TARGETQUANTITY,
    TAXCODE,
    TAXJURISDICTION,
    VALUATIONTYPE,
    PRIMARY KEY (MATERIAL, MATERIALGROUP, PLANT, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM, PURCHASINGDOCUMENTITEMUNIQUEID, REQUESTFORQUOTATIONITEM, SUPPLIERQUOTATION, SUPPLIERQUOTATIONITEM)
);

Learn More