C_PurchaseOrderItemDEX

Data Extraction View for PO Item | view: CMMPOITMDX | TRAN | Extraction: Full or Incremental | Component: Reporting

Tables used: EKKO, EKKO, EKPO, T001, TKA02

🔑 Keys (2)
💰 Amounts (2)
∑ Quantities (1)
📅 Dates (3)
☰ Categorical (8)
Other (8)
🔗 Relations (23)

Column Name	Description
PurchaseOrder FK	Purchase Order Number
PurchaseOrderItem	Item Number of Purchase Order

Column Name	Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount	Net Price in Purchasing Document (in Document Currency)
NetAmount	Net Order Value in PO Currency

Column Name	Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity	Purchase Order Quantity

Column Name	Description
PurchaseOrderDate	Purchase Order Date
ValidityStartDate	Start of Validity Period
ValidityEndDate	End of Validity Period

Column Name	Description
PurchasingDocumentOrigin	Status of Purchasing Document	Show values
PurchaseOrderCategory	Purchasing Document Category	Show values
IsCompletelyDelivered	"Delivery Completed" Indicator	Show values
IsFinallyInvoiced	Final Invoice Indicator	Show values
InvoiceIsExpected	Invoice receipt indicator	Show values
InvoiceIsGoodsReceiptBased	Indicator: GR-Based Invoice Verification	Show values
GoodsReceiptIsExpected	Goods Receipt Indicator	Show values
EvaldRcptSettlmtIsAllowed	Evaluated Receipt Settlement (ERS)	Show values

Column Name	Description	Domain name
ExchangeRate	Exchange Rate	KURSP
PurchasingDocumentDeletionCode	Deletion Indicator in Purchasing Document	ELOEK
PurchaseOrderItemText	Short Text	TEXT40
CompanyCode	Company Code	BUKRS
NetPriceQuantity	Price Unit	DEC5
RequisitionerName	Name of requisitioner/requester	AFNAM
OrderItemQtyToBaseQtyDnmntr	Denominator for Conversion of Order Unit to Base Unit	UMBSN
OrderItemQtyToBaseQtyNmrtr	Numerator for Conversion of Order Unit to Base Unit	UMBSZ

Master Data Relations	Join Conditions
Base Unit of Measure Client Base Unit of Measure	`C_PURCHASEORDERITEMDEX.MANDT == T006.MANDT` `C_PURCHASEORDERITEMDEX.BASEUNIT == T006.MSEHI`
Currency Key Client Currency Key Currency Key	`C_PURCHASEORDERITEMDEX.MANDT == TCURC.MANDT` `C_PURCHASEORDERITEMDEX.DOCUMENTCURRENCY == TCURC.WAERS` `C_PURCHASEORDERITEMDEX.LOCALCURRENCY == TCURC.WAERS`
Different Invoicing Party Different Invoicing Party Client	`C_PURCHASEORDERITEMDEX.INVOICINGPARTY == LFA1.LIFNR` `C_PURCHASEORDERITEMDEX.MANDT == LFA1.MANDT`
Currency Key Client Currency Key Currency Key	`C_PURCHASEORDERITEMDEX.MANDT == TCURC.MANDT` `C_PURCHASEORDERITEMDEX.DOCUMENTCURRENCY == TCURC.WAERS` `C_PURCHASEORDERITEMDEX.LOCALCURRENCY == TCURC.WAERS`
Material number Material number Client	`C_PURCHASEORDERITEMDEX.MANUFACTURERMATERIAL == MARA.MATNR` `C_PURCHASEORDERITEMDEX.MANDT == MARA.MANDT`
Material Number Material Number Client	`C_PURCHASEORDERITEMDEX.MATERIAL == MARA.MATNR` `C_PURCHASEORDERITEMDEX.MANDT == MARA.MANDT`
Material Group Client Material Group	`C_PURCHASEORDERITEMDEX.MANDT == T023.MANDT` `C_PURCHASEORDERITEMDEX.MATERIALGROUP == T023.MATKL`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Client	`C_PURCHASEORDERITEMDEX.ORDERPRICEUNIT == T006.MSEHI` `C_PURCHASEORDERITEMDEX.MANDT == T006.MANDT`
Plant Client Plant	`C_PURCHASEORDERITEMDEX.MANDT == T001W.MANDT` `C_PURCHASEORDERITEMDEX.PLANT == T001W.WERKS`
Item category in purchasing document Client Item category in purchasing document	`C_PURCHASEORDERITEMDEX.MANDT == T163.MANDT` `C_PURCHASEORDERITEMDEX.PURCHASEORDERITEMCATEGORY == T163.PSTYP`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`C_PURCHASEORDERITEMDEX.MANDT == T006.MANDT` `C_PURCHASEORDERITEMDEX.PURCHASEORDERQUANTITYUNIT == T006.MSEHI`
Purchase Order Type Purchase Order Type Client Purchasing Document Category	`C_PURCHASEORDERITEMDEX.PURCHASEORDERTYPE == T161.BSART` `C_PURCHASEORDERITEMDEX.MANDT == T161.MANDT` `C_PURCHASEORDERITEMDEX.PURCHASEORDERCATEGORY == T161.BSTYP`
Purchasing Group Purchasing Group Client	`C_PURCHASEORDERITEMDEX.PURCHASINGGROUP == T024.EKGRP` `C_PURCHASEORDERITEMDEX.MANDT == T024.MANDT`
Reason for Ordering Client Reason for Ordering	`C_PURCHASEORDERITEMDEX.MANDT == TBSG.MANDT` `C_PURCHASEORDERITEMDEX.PURCHASINGORDERREASON == TBSG.BSGRU`
Purchasing organization Purchasing organization Client	`C_PURCHASEORDERITEMDEX.PURCHASINGORGANIZATION == T024E.EKORG` `C_PURCHASEORDERITEMDEX.MANDT == T024E.MANDT`
Promotion Promotion Client	`C_PURCHASEORDERITEMDEX.RETAILPROMOTION == WAKH.AKTNR` `C_PURCHASEORDERITEMDEX.MANDT == WAKH.MANDT`
Storage Location Storage Location Client Plant	`C_PURCHASEORDERITEMDEX.STORAGELOCATION == T001L.LGORT` `C_PURCHASEORDERITEMDEX.MANDT == T001L.MANDT` `C_PURCHASEORDERITEMDEX.PLANT == T001L.WERKS`
Supplier Supplier Client	`C_PURCHASEORDERITEMDEX.SUPPLIER == LFA1.LIFNR` `C_PURCHASEORDERITEMDEX.MANDT == LFA1.MANDT`
Supplying (issuing) plant in case of stock transport order Client Supplying (issuing) plant in case of stock transport order	`C_PURCHASEORDERITEMDEX.MANDT == T001W.MANDT` `C_PURCHASEORDERITEMDEX.SUPPLYINGPLANT == T001W.WERKS`
Goods Supplier Goods Supplier Client	`C_PURCHASEORDERITEMDEX.SUPPLYINGSUPPLIER == LFA1.LIFNR` `C_PURCHASEORDERITEMDEX.MANDT == LFA1.MANDT`