P_POItemEnhanced

Purchase Order Items Enhanced | view: PPOITEMENH | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: EKKO, EKPO, MMPUR_ANA_EKET, EKBE, EKBEH, MMPUR_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 Net Amount (in Reporting Currency 1)
GoodReceiptAmount null
StillToBeDeliveredValue null
InvoiceReceiptAmount null
StillToInvoiceValue null
Column Name Description
NextDeliveryQuantity Open Quantity
OrderQuantity Purchase Order Quantity
GoodsReceiptQuantity Delivered Quantity
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
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
ScheduleLine Schedule Line Number ETENR
NextDeliveryStatus null
NetPriceQuantity Price Unit DEC5
StockSegment Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • P_POITEMENHANCED.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • P_POITEMENHANCED.MANDT == T163K.MANDT
Company Code
  • Company Code
  • Client
  • P_POITEMENHANCED.COMPANYCODE == T001.BUKRS
  • P_POITEMENHANCED.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_POITEMENHANCED.MANDT == TCURC.MANDT
  • P_POITEMENHANCED.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • P_POITEMENHANCED.MANDT == MARA.MANDT
  • P_POITEMENHANCED.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_POITEMENHANCED.MANDT == T023.MANDT
  • P_POITEMENHANCED.MATERIALGROUP == T023.MATKL
Order Price Unit (Purchasing)
  • Client
  • Order Price Unit (Purchasing)
  • P_POITEMENHANCED.MANDT == T006.MANDT
  • P_POITEMENHANCED.ORDERPRICEUNIT == T006.MSEHI
Plant
  • Plant
  • Client
  • P_POITEMENHANCED.PLANT == T001W.WERKS
  • P_POITEMENHANCED.MANDT == T001W.MANDT
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • P_POITEMENHANCED.PURCHASEORDERITEMCATEGORY == T163.PSTYP
  • P_POITEMENHANCED.MANDT == T163.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_POITEMENHANCED.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • P_POITEMENHANCED.MANDT == T006.MANDT
Purchase Order Type
  • ?
  • Client
  • Purchase Order Type
  • P_POITEMENHANCED.[column in domain "BSTYP"] == T161.BSTYP
  • P_POITEMENHANCED.MANDT == T161.MANDT
  • P_POITEMENHANCED.PURCHASEORDERTYPE == T161.BSART
Purchasing Group
  • Purchasing Group
  • Client
  • P_POITEMENHANCED.PURCHASINGGROUP == T024.EKGRP
  • P_POITEMENHANCED.MANDT == T024.MANDT
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • P_POITEMENHANCED.PURCHASINGINFORECORD == EINA.INFNR
  • P_POITEMENHANCED.MANDT == EINA.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_POITEMENHANCED.PURCHASINGORGANIZATION == T024E.EKORG
  • P_POITEMENHANCED.MANDT == T024E.MANDT
Storage Location
  • Plant
  • Storage Location
  • Client
  • P_POITEMENHANCED.PLANT == T001L.WERKS
  • P_POITEMENHANCED.STORAGELOCATION == T001L.LGORT
  • P_POITEMENHANCED.MANDT == T001L.MANDT
Supplier
  • Supplier
  • Client
  • P_POITEMENHANCED.SUPPLIER == LFA1.LIFNR
  • P_POITEMENHANCED.MANDT == LFA1.MANDT
Supplying (issuing) plant in case of stock transport order
  • Supplying (issuing) plant in case of stock transport order
  • Client
  • P_POITEMENHANCED.SUPPLYINGPLANT == T001W.WERKS
  • P_POITEMENHANCED.MANDT == T001W.MANDT