P_POItemCnvrtdAmounts

PO Items with Converted Amounts | view: PPOITMCONVRTDAMT | TRAN | Extraction: Not supported | Component: Purchase Orders

Tables used: EKKO, EKPO, MMPUR_ANA_CONF

🔑 Keys (2)
💰 Amounts (4)
∑ Quantities (1)
📅 Dates (2)
☰ Categorical (8)
Other (10)
🔗 Relations (22)

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

Column Name	Description
ExpectedOverallLimitAmount	null
OverallLimitAmount	null
NetPriceAmount	null
NetAmount	null

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

Column Name	Description
PurchaseOrderDate	Purchase Order Date
CreationDate	Creation Date of Purchasing Document

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
NetPriceQuantity	Price Unit	DEC5
StockSegment	Stock Segment	SGT_SRCA

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