P_AssocPurOrdItmPurConItm

Association PO Item / Contract Item | view: PASCPOITMPCONITM | Extraction: Not supported | Component: Purchase Orders

Tables used: EKAB, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, EKKO, EKPO, ADR2, ADR6, ADRC, T001, TKA02, TINC, MARA, T023, T001W, T161T, T024, T024E, T001L, ADR2, ADR6, LFA1, LFA1

🔑 Keys (4)
💰 Amounts (5)
∑ Quantities (5)
📅 Dates
☰ Categorical (14)
Other (26)
🔗 Relations (24)

Column Name	Description
PurchaseOrder FK	Purchasing Document Number
PurchaseOrderItem	Item Number of Purchase Order
PurchaseContract FK	Number of principal purchase agreement
PurchaseContractItem FK	Item number of principal purchase agreement

Column Name	Description
💲 Currency Key (DocumentCurrency):
ContractNetPriceAmount	Net Price in Purchasing Document (in Document Currency)
TargetAmount	Target Value
NetAmount	Net Order Value in PO Currency
EffectiveAmount	Effective value of item
NetPriceAmount	Net Price in Purchasing Document (in Document Currency)

Column Name	Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
ReleasedQuantity	Released Quantity
TargetQuantity	Target Quantity
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity	Purchase Order Quantity
📏 Volume unit (ItemVolumeUnit):
ItemVolume	Volume
📏 Unit of Weight (ItemWeightUnit):
ItemNetWeight	Net Weight

Column Name	Description

Column Name	Description
PurchasingDocumentCategory	Purchasing Document Category	Show values
GoodsReceiptIsExpected	Goods Receipt Indicator	Show values
MultipleAcctAssgmtDistribution	Distribution Indicator for Multiple Account Assignment	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
EvaldRcptSettlmtIsAllowed	Evaluated Receipt Settlement (ERS)	Show values
UnlimitedOverdeliveryIsAllowed	Unlimited Overdelivery Allowed	Show values
PartialInvoiceDistribution	Partial invoice indicator	Show values
PricingDateControl	Price Determination (Pricing) Date Control	Show values
IsReturnsItem	Returns Item	Show values
PriceIsToBePrinted	Price Printout	Show values

Column Name	Description	Domain name
FormattedPurchaseContractItem	Purchase Contract Item ID
SupplierName	Name 1	NAME
CreatedByUser	User of person who created a purchasing document	USNAM
SupplierAddressID	Address Number	AD_ADDRNUM
DeliveryAddressID	Address	ADRNR
IncotermsClassification	Incoterms (Part 1)	INCO1
IncotermsTransferLocation	Incoterms (Part 2)	INCO2
Material	Material Number	MATNR
PurchaseContractItemText	Short Text	TEXT40
NetPriceQuantity	Price Unit	DEC5
MaterialGroup	Product Group	MATKL
PlantName	Plant Name	TEXT30
StorageLocationName	Storage Location Name	TEXT16
ManualDeliveryAddressID	Manual address number in purchasing document item	AD_ADDRNUM
PurchasingDocumentDeletionCode	Deletion Indicator in Purchasing Document	ELOEK
SupplierMaterialNumber	Material Number Used by Supplier	IDNEX
ManufacturerPartNmbr	Manufacturer Part Number	CHAR40
PurchaseOrderItemText	Short Text	TEXT40
OrderItemQtyToBaseQtyNmrtr	Numerator for Conversion of Order Unit to Base Unit	UMBSZ
OrderItemQtyToBaseQtyDnmntr	Denominator for Conversion of Order Unit to Base Unit	UMBSN
OverdelivTolrtdLmtRatioInPct	Overdelivery Tolerance	PRZ21
UnderdelivTolrtdLmtRatioInPct	Underdelivery Tolerance	PRZ21
RequisitionerName	Name of requisitioner/requester	AFNAM
InternationalArticleNumber	International Article Number (EAN/UPC)	EAN11
OrderPriceUnitToOrderUnitNmrtr	Numerator for Conversion of Order Price Unit into Order Unit	UMBSZ
OrdPriceUnitToOrderUnitDnmntr	Denominator for Conv. of Order Price Unit into Order Unit	UMBSN

Master Data Relations	Join Conditions
Account Assignment Category Account Assignment Category Client	`P_ASSOCPURORDITMPURCONITM.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP` `P_ASSOCPURORDITMPURCONITM.MANDT == T163K.MANDT`
Base Unit of Measure Base Unit of Measure Client	`P_ASSOCPURORDITMPURCONITM.BASEUNIT == T006.MSEHI` `P_ASSOCPURORDITMPURCONITM.MANDT == T006.MANDT`
Company Code Company Code Client	`P_ASSOCPURORDITMPURCONITM.COMPANYCODE == T001.BUKRS` `P_ASSOCPURORDITMPURCONITM.MANDT == T001.MANDT`
Currency Key Currency Key Currency Key Client	`P_ASSOCPURORDITMPURCONITM.DOCUMENTCURRENCY == TCURC.WAERS` `P_ASSOCPURORDITMPURCONITM.CURRENCY == TCURC.WAERS` `P_ASSOCPURORDITMPURCONITM.MANDT == TCURC.MANDT`
Currency Key Currency Key Currency Key Client	`P_ASSOCPURORDITMPURCONITM.DOCUMENTCURRENCY == TCURC.WAERS` `P_ASSOCPURORDITMPURCONITM.CURRENCY == TCURC.WAERS` `P_ASSOCPURORDITMPURCONITM.MANDT == TCURC.MANDT`
Different Invoicing Party Different Invoicing Party Client	`P_ASSOCPURORDITMPURCONITM.INVOICINGPARTY == LFA1.LIFNR` `P_ASSOCPURORDITMPURCONITM.MANDT == LFA1.MANDT`
Volume unit Client Volume unit	`P_ASSOCPURORDITMPURCONITM.MANDT == T006.MANDT` `P_ASSOCPURORDITMPURCONITM.ITEMVOLUMEUNIT == T006.MSEHI`
Unit of Weight Unit of Weight Client	`P_ASSOCPURORDITMPURCONITM.ITEMWEIGHTUNIT == T006.MSEHI` `P_ASSOCPURORDITMPURCONITM.MANDT == T006.MANDT`
Material number Client Material number	`P_ASSOCPURORDITMPURCONITM.MANDT == MARA.MANDT` `P_ASSOCPURORDITMPURCONITM.MANUFACTURERMATERIAL == MARA.MATNR`
Order Price Unit Order Price Unit (Purchasing) Order Price Unit Client	`P_ASSOCPURORDITMPURCONITM.PURCHASEORDERPRICEUNIT == T006.MSEHI` `P_ASSOCPURORDITMPURCONITM.ORDERPRICEUNIT == T006.MSEHI` `P_ASSOCPURORDITMPURCONITM.MANDT == T006.MANDT`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure Purchase Order Unit of Measure	`P_ASSOCPURORDITMPURCONITM.MANDT == T006.MANDT` `P_ASSOCPURORDITMPURCONITM.ORDERQUANTITYUNIT == T006.MSEHI` `P_ASSOCPURORDITMPURCONITM.PURCHASEORDERQUANTITYUNIT == T006.MSEHI`
Plant Plant Client	`P_ASSOCPURORDITMPURCONITM.PLANT == T001W.WERKS` `P_ASSOCPURORDITMPURCONITM.MANDT == T001W.MANDT`
Profit Center ? Profit Center ? Client	`P_ASSOCPURORDITMPURCONITM.[column in domain "DATBI"] == CEPC.DATBI` `P_ASSOCPURORDITMPURCONITM.PROFITCENTER == CEPC.PRCTR` `P_ASSOCPURORDITMPURCONITM.[column in domain "KOKRS"] == CEPC.KOKRS` `P_ASSOCPURORDITMPURCONITM.MANDT == CEPC.MANDT`
Purchasing Document Type Purchasing Document Category Purchasing Document Category Purchasing Document Type Client	`P_ASSOCPURORDITMPURCONITM.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP` `P_ASSOCPURORDITMPURCONITM.PURCHASEORDERCATEGORY == T161.BSTYP` `P_ASSOCPURORDITMPURCONITM.PURCHASECONTRACTTYPE == T161.BSART` `P_ASSOCPURORDITMPURCONITM.MANDT == T161.MANDT`
Item category in purchasing document Client Item category in purchasing document	`P_ASSOCPURORDITMPURCONITM.MANDT == T163.MANDT` `P_ASSOCPURORDITMPURCONITM.PURCHASEORDERITEMCATEGORY == T163.PSTYP`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Order Price Unit Client	`P_ASSOCPURORDITMPURCONITM.PURCHASEORDERPRICEUNIT == T006.MSEHI` `P_ASSOCPURORDITMPURCONITM.ORDERPRICEUNIT == T006.MSEHI` `P_ASSOCPURORDITMPURCONITM.MANDT == T006.MANDT`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure Purchase Order Unit of Measure	`P_ASSOCPURORDITMPURCONITM.MANDT == T006.MANDT` `P_ASSOCPURORDITMPURCONITM.ORDERQUANTITYUNIT == T006.MSEHI` `P_ASSOCPURORDITMPURCONITM.PURCHASEORDERQUANTITYUNIT == T006.MSEHI`
Number of purchasing info record Client Number of purchasing info record	`P_ASSOCPURORDITMPURCONITM.MANDT == EINA.MANDT` `P_ASSOCPURORDITMPURCONITM.PURCHASINGINFORECORD == EINA.INFNR`
Storage Location Plant Storage Location Client	`P_ASSOCPURORDITMPURCONITM.PLANT == T001L.WERKS` `P_ASSOCPURORDITMPURCONITM.STORAGELOCATION == T001L.LGORT` `P_ASSOCPURORDITMPURCONITM.MANDT == T001L.MANDT`
Supplier Supplier Client	`P_ASSOCPURORDITMPURCONITM.SUPPLIER == LFA1.LIFNR` `P_ASSOCPURORDITMPURCONITM.MANDT == LFA1.MANDT`
Goods Supplier Goods Supplier Client	`P_ASSOCPURORDITMPURCONITM.SUPPLYINGSUPPLIER == LFA1.LIFNR` `P_ASSOCPURORDITMPURCONITM.MANDT == LFA1.MANDT`