P_PurOrderItemCalculation

PO Item Calculated fields | view: PPORDITEMCALC | TRAN | Extraction: Not supported | Component: Purchase Orders

Tables used: EKKO, EKBE, EKPO, EKBEH, EKET, MMPUR_ANA_EKET, T001, TKA02, T001W, T161, T161T, MMPUR_ANA_CONF, T163, T163Y, T001L, LFA1

🔑 Keys (2)
💰 Amounts (7)
∑ Quantities (6)
📅 Dates (3)
☰ Categorical (8)
Other (17)
🔗 Relations (17)

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

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

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

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
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
PurgDocExternalItemCategory	Item Category in Purchasing Document	EPSTP
PlantName	Plant Name	TEXT30
CompanyCodeName	Name of Company Code or Company	TEXT25
CreatedByUser	User of person who created a purchasing document	USNAM
SupplyingPlantName	Plant Name	TEXT30
PurgDocItemCategoryName	Text for Item Category	TEXT20
Supplier	Supplier	LIFNR
SupplierName	Name of Supplier	TEXT80
PurchasingDocumentTypeName	Short Description of Purchasing Document Type	TEXT20

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