P_POItem

Legacy Purchase Order items | view: PPURORDITEM | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: EKKOEKPOEKETEKBEEKBEHMMPUR_ANA_CONF
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
ExpectedOverallLimitAmount null
OverallLimitAmount null
NetPriceAmount null
NetAmount null
GoodReceiptAmount null
StillToBeDeliveredValue null
InvoiceReceiptAmount null
StillToInvoiceValue null
Column Name Description
NextDeliveryQuantity null
OrderQuantity Purchase Order Quantity
GoodsReceiptQuantity null
StillToBeDeliveredQuantity null
InvoiceReceiptQty null
StillToInvoiceQuantity null
Column Name Description
PurchaseOrderDate Purchase Order Date
CreationDate Creation Date of Purchasing Document
NextDeliveryDate Item delivery date
today null
Column Name Description
IsReturnsItem Returns Item Show values
GoodsReceiptIsExpected Goods Receipt Indicator Show values
GoodsReceiptIsNonValuated Goods Receipt, Non-Valuated Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
InvoiceIsExpected Invoice receipt indicator Show values
InvoiceIsGoodsReceiptBased Indicator: GR-Based Invoice Verification Show values
IsFinallyInvoiced Final Invoice Indicator Show values
IsInfoRecordUpdated Indicator: Update Info Record Show values
Column Name Description Domain name
CreatedByUser User of person who created a purchasing document USNAM
PurchaseOrderItemText Short Text TEXT40
ProductType Product Type Group CHAR2
PurOrderItemExtCategory Action Text TEXT40
ServicePerformer Service Performer BU_PARTNER
PurchaseRequisition Purchase Requisition Number BANFN
RequestForQuotation Identifier for Request for Quotation EBELN
RequestForQuotationItem Item Number for Request for Quotation EBELP
RequirementTracking Requirement Tracking Number CHAR10
NextDeliveryStatus null
ScheduleLine null
NetPriceQuantity Price Unit DEC5
StockSegment Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • P_POITEM.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • P_POITEM.MANDT == T163K.MANDT
Company Code
  • Client
  • Company Code
  • P_POITEM.MANDT == T001.MANDT
  • P_POITEM.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • P_POITEM.MANDT == TCURC.MANDT
  • P_POITEM.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • P_POITEM.MANDT == MARA.MANDT
  • P_POITEM.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_POITEM.MANDT == T023.MANDT
  • P_POITEM.MATERIALGROUP == T023.MATKL
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • P_POITEM.ORDERPRICEUNIT == T006.MSEHI
  • P_POITEM.MANDT == T006.MANDT
Plant
  • Client
  • Plant
  • P_POITEM.MANDT == T001W.MANDT
  • P_POITEM.PLANT == T001W.WERKS
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • P_POITEM.MANDT == T163.MANDT
  • P_POITEM.PURCHASEORDERITEMCATEGORY == T163.PSTYP
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_POITEM.MANDT == T006.MANDT
  • P_POITEM.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchase Order Type
  • ?
  • Client
  • Purchase Order Type
  • P_POITEM.[column in domain "BSTYP"] == T161.BSTYP
  • P_POITEM.MANDT == T161.MANDT
  • P_POITEM.PURCHASEORDERTYPE == T161.BSART
Purchasing Group
  • Client
  • Purchasing Group
  • P_POITEM.MANDT == T024.MANDT
  • P_POITEM.PURCHASINGGROUP == T024.EKGRP
Number of purchasing info record
  • Client
  • Number of purchasing info record
  • P_POITEM.MANDT == EINA.MANDT
  • P_POITEM.PURCHASINGINFORECORD == EINA.INFNR
Purchasing organization
  • Client
  • Purchasing organization
  • P_POITEM.MANDT == T024E.MANDT
  • P_POITEM.PURCHASINGORGANIZATION == T024E.EKORG
Storage Location
  • Storage Location
  • Client
  • Plant
  • P_POITEM.STORAGELOCATION == T001L.LGORT
  • P_POITEM.MANDT == T001L.MANDT
  • P_POITEM.PLANT == T001L.WERKS
Supplier
  • Client
  • Supplier
  • P_POITEM.MANDT == LFA1.MANDT
  • P_POITEM.SUPPLIER == LFA1.LIFNR
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • P_POITEM.MANDT == T001W.MANDT
  • P_POITEM.SUPPLYINGPLANT == T001W.WERKS