C_PurOrdItemEnh

Purchase Order Item | view: CPURORDITEMENH | Extraction: Not supported | Component: Purchase Orders

Tables used: EKKO, EKPO, EKET, EKBE, EKBEH, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, NAST, KNA1, T001W, LFA1, T163B, LFA1, T161M

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

Column Name	Description
PurchaseOrder FK	Purchasing Document Number
PurchaseOrderItem	Item Number of Purchasing Document

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
FirstDeliveryDate	Item delivery date
PerformancePeriodStartDate	Start Date for Period of Performance
PerformancePeriodEndDate	End Date for Period of Performance

Column Name	Description
IsOrderAcknRqd	Order Acknowledgment Requirement	Show values
ItemIsRejectedBySupplier	Rejection Indicator	Show values

Column Name	Description	Domain name
PurchaseOrderItemText	Short Text	TEXT40
PurchaseRequisition	Purchase Requisition Number	BANFN
ProductType	Product Type Group	CHAR2
PurchaseOrderNetPriceQuantity	Price Unit	DEC5
PurchasingDocumentDeletionCode	Deletion Indicator in Purchasing Document	ELOEK
ServicePerformer	Service Performer	BU_PARTNER
PurchaseOrderItemStatus	Purchasing Document Status Name
PurgDocOrderAcknNumber	Order Acknowledgment Number	TEXT20

Master Data Relations	Join Conditions
Account Assignment Category Account Assignment Category Client	`C_PURORDITEMENH.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP` `C_PURORDITEMENH.MANDT == T163K.MANDT`
Currency Key Currency Key Client	`C_PURORDITEMENH.DOCUMENTCURRENCY == TCURC.WAERS` `C_PURORDITEMENH.MANDT == TCURC.MANDT`
Material number Material number Client	`C_PURORDITEMENH.MANUFACTURERMATERIAL == MARA.MATNR` `C_PURORDITEMENH.MANDT == MARA.MANDT`
Material Number Material Number Client	`C_PURORDITEMENH.MATERIAL == MARA.MATNR` `C_PURORDITEMENH.MANDT == MARA.MANDT`
Material Group Client Material Group	`C_PURORDITEMENH.MANDT == T023.MANDT` `C_PURORDITEMENH.MATERIALGROUP == T023.MATKL`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Order Price Unit (Purchasing) Client	`C_PURORDITEMENH.PURCHASEORDERPRICEUNIT == T006.MSEHI` `C_PURORDITEMENH.ORDERPRICEUNIT == T006.MSEHI` `C_PURORDITEMENH.MANDT == T006.MANDT`
Plant Client Plant	`C_PURORDITEMENH.MANDT == T001W.MANDT` `C_PURORDITEMENH.PLANT == T001W.WERKS`
Item category in purchasing document Client Item category in purchasing document	`C_PURORDITEMENH.MANDT == T163.MANDT` `C_PURORDITEMENH.PURCHASEORDERITEMCATEGORY == T163.PSTYP`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Order Price Unit (Purchasing) Client	`C_PURORDITEMENH.PURCHASEORDERPRICEUNIT == T006.MSEHI` `C_PURORDITEMENH.ORDERPRICEUNIT == T006.MSEHI` `C_PURORDITEMENH.MANDT == T006.MANDT`
Purchase Order Unit of Measure Purchase Order Unit of Measure Client	`C_PURORDITEMENH.PURCHASEORDERQUANTITYUNIT == T006.MSEHI` `C_PURORDITEMENH.MANDT == T006.MANDT`
Purchase Order Type ? Client Purchase Order Type	`C_PURORDITEMENH.[column in domain "BSTYP"] == T161.BSTYP` `C_PURORDITEMENH.MANDT == T161.MANDT` `C_PURORDITEMENH.PURCHASEORDERTYPE == T161.BSART`
Purchasing Group Purchasing Group Client	`C_PURORDITEMENH.PURCHASINGGROUP == T024.EKGRP` `C_PURORDITEMENH.MANDT == T024.MANDT`
Purchasing organization Purchasing organization Client	`C_PURORDITEMENH.PURCHASINGORGANIZATION == T024E.EKORG` `C_PURORDITEMENH.MANDT == T024E.MANDT`
Confirmation Control Key Client Confirmation Control Key	`C_PURORDITEMENH.MANDT == T163L.MANDT` `C_PURORDITEMENH.SUPPLIERCONFIRMATIONCONTROLKEY == T163L.BSTAE`