P_PurOrdItm

Purchase Order Item Details | view: PPURORDITM | TRAN | Extraction: Not supported | Component: Purchase Orders

Tables used: EKKO, EKBE, EKPO, EKKN, EKBEH, EKET, MMPUR_ANA_EKET, EKBE, EKBEH, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, NAST, T001, TKA02, TKA01, CSKS, CSKS, CSKT, T001W, T163B, T161, T161T, MMPUR_ANA_CONF, T163, T163Y, T000, T001L, LFA1, PRPS, T161M

🔑 Keys (3)
💰 Amounts (8)
∑ Quantities (7)
📅 Dates (3)
☰ Categorical (8)
Other (24)
🔗 Relations (19)

Column Name	Description
PurchaseOrder FK	Purchasing Document Number
PurchaseOrderItem	Item Number of Purchase Order
AccountAssignmentNumber	Sequential Number of Account Assignment

Column Name	Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount	Net Price in Purchasing Document (in Document Currency)
NetAmountInCoCodeCurrency	Net Amount in Company Currency
NetAmount	Net Order Value in PO Currency
GoodsReceiptAmount	null
StillToBeDeliveredValue	null
InvoiceRcptAmtInCoCodeCrcy	null
StillToInvoiceValue	null
PurgDocNetAmount	Net Order Value in PO Currency

Column Name	Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity	Purchase Order Quantity
GoodsReceiptQuantity	null
StillToBeDeliveredQuantity	null
InvoiceReceiptQty	null
StillToInvoiceQuantity	null
ScheduleLineOpenQty	null
Quantity	Quantity

Column Name	Description
PurchaseOrderDate	Purchase Order Date
CreationDate	Creation Date of Purchasing Document
DeliveryDate	Item delivery date

Column Name	Description
IsReturnsItem	Returns Item	Show values
ObjectType	Num1	Show values
GoodsReceiptIsExpected	Goods Receipt Indicator	Show values
IsCompletelyDelivered	"Delivery Completed" Indicator	Show values
InvoiceIsExpected	Invoice receipt indicator	Show values
IsFinallyInvoiced	Final Invoice Indicator	Show values
MultipleAcctAssgmtDistribution	Distribution Indicator for Multiple Account Assignment	Show values
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values

Column Name	Description	Domain name
PurchaseOrderItemUniqueID	Concatenation of EBELN and EBELP	PURCHASINGDOCUMENTITEMUNIQUEID
FormattedPurchaseOrderItem	null
PurchaseOrderItemText	Short Text	TEXT40
CompanyCodeName	Name of Company Code or Company	TEXT25
StorageLocationName	Storage Location Name	TEXT16
ServicePerformer	Service Performer	BU_PARTNER
ProductType	Product Type Group	CHAR2
NetPriceQuantity	Price Unit	DEC5
WorkItem	Work Item ID	/CPD/PFP_WORKITEM_ID
Supplier	Supplier	LIFNR
SupplierName	Name of Supplier	TEXT80
Status	null
PurchasingDocumentStatusName	Purchasing Document Status Name	DDTEXT
PurgDocExternalItemCategory	Item Category in Purchasing Document	EPSTP
CreatedByUser	User of person who created a purchasing document	USNAM
PlantName	Plant Name	TEXT30
SupplyingPlantName	Plant Name	TEXT30
PurgDocItemCategoryName	Text for Item Category	TEXT20
PurchasingDocumentTypeName	Short Description of Purchasing Document Type	TEXT20
CostCenterName	Cost Center Name	TEXT20
SalesOrder	Sales and Distribution Document Number	VBELN
SalesOrderItem	Sales Document Item	POSNR
WBSElementExternalID	Work Breakdown Structure Element (WBS Element)	PS_POSID
MultipleAcctAssgmtDistrPercent	Distribution percentage in the case of multiple acct assgt	VPROZ

Master Data Relations	Join Conditions
Account Assignment Category Account Assignment Category Client	`P_PURORDITM.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP` `P_PURORDITM.MANDT == T163K.MANDT`
Company Code Company Code Client	`P_PURORDITM.COMPANYCODE == T001.BUKRS` `P_PURORDITM.MANDT == T001.MANDT`
Currency Key Currency Key Currency Key Client	`P_PURORDITM.COMPANYCODECURRENCY == TCURC.WAERS` `P_PURORDITM.DOCUMENTCURRENCY == TCURC.WAERS` `P_PURORDITM.MANDT == TCURC.MANDT`
Cost Center Cost Center Creation Date of Purchasing Document ? Client	`P_PURORDITM.COSTCENTER == CSKS.KOSTL` `P_PURORDITM.CREATIONDATE == CSKS.DATBI` `P_PURORDITM.[column in domain "KOKRS"] == CSKS.KOKRS` `P_PURORDITM.MANDT == CSKS.MANDT`
Currency Key Currency Key Currency Key Client	`P_PURORDITM.COMPANYCODECURRENCY == TCURC.WAERS` `P_PURORDITM.DOCUMENTCURRENCY == TCURC.WAERS` `P_PURORDITM.MANDT == TCURC.MANDT`
Material Number Client Material Number	`P_PURORDITM.MANDT == MARA.MANDT` `P_PURORDITM.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`P_PURORDITM.MANDT == T023.MANDT` `P_PURORDITM.MATERIALGROUP == T023.MATKL`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Client	`P_PURORDITM.ORDERPRICEUNIT == T006.MSEHI` `P_PURORDITM.MANDT == T006.MANDT`
Plant Plant Client	`P_PURORDITM.PLANT == T001W.WERKS` `P_PURORDITM.MANDT == T001W.MANDT`
Item category in purchasing document Client Item category in purchasing document	`P_PURORDITM.MANDT == T163.MANDT` `P_PURORDITM.PURCHASEORDERITEMCATEGORY == T163.PSTYP`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`P_PURORDITM.MANDT == T006.MANDT` `P_PURORDITM.PURCHASEORDERQUANTITYUNIT == T006.MSEHI`
Purchase Order Type ? Purchase Order Type Purchase Order Type Client	`P_PURORDITM.[column in domain "BSTYP"] == T161.BSTYP` `P_PURORDITM.PURCHASEORDERTYPE == T161.BSART` `P_PURORDITM.PURCHASINGDOCUMENTTYPE == T161.BSART` `P_PURORDITM.MANDT == T161.MANDT`
Purchase Order Type ? Purchase Order Type Purchase Order Type Client	`P_PURORDITM.[column in domain "BSTYP"] == T161.BSTYP` `P_PURORDITM.PURCHASEORDERTYPE == T161.BSART` `P_PURORDITM.PURCHASINGDOCUMENTTYPE == T161.BSART` `P_PURORDITM.MANDT == T161.MANDT`
Purchasing Group Purchasing Group Client	`P_PURORDITM.PURCHASINGGROUP == T024.EKGRP` `P_PURORDITM.MANDT == T024.MANDT`
Purchasing organization Purchasing organization Client	`P_PURORDITM.PURCHASINGORGANIZATION == T024E.EKORG` `P_PURORDITM.MANDT == T024E.MANDT`
Storage Location Plant Storage Location Client	`P_PURORDITM.PLANT == T001L.WERKS` `P_PURORDITM.STORAGELOCATION == T001L.LGORT` `P_PURORDITM.MANDT == T001L.MANDT`
Supplying (issuing) plant in case of stock transport order Supplying (issuing) plant in case of stock transport order Client	`P_PURORDITM.SUPPLYINGPLANT == T001W.WERKS` `P_PURORDITM.MANDT == T001W.MANDT`