MMPUR_EXT_EKPO

Purchasing Document Item | #transactional | Component: Procurement Hub

🔑 Keys (4)
💰 Amounts (19)
∑ Quantities (11)
📅 Dates (19)
☰ Categorical (86)
Other (125)
🔗 Relations (65)

Column Name	Description
MANDT	Client
EBELN	Purchasing Document Number
EBELP	Item Number of Purchasing Document
EXTSOURCESYSTEM	Connected System ID

Column Name	Description
💲 Currency Key (EKKO.WAERS):
NETPR	Net Price in Purchasing Document (in Document Currency)
NETWR	Net Order Value in PO Currency
BRTWR	Gross order value in PO currency
ZWERT	Target Value for Outline Agreement in Document Currency
NAVNW	Non-deductible input tax
EFFWR	Effective value of item
GNETWR	Currently not used
KZWI1	Subtotal 1 from Pricing Procedure for Price Element
KZWI2	Subtotal 2 from Pricing Procedure for Price Element
KZWI3	Subtotal 3 from Pricing Procedure for Price Element
KZWI4	Subtotal 4 from Pricing Procedure for Price Element
KZWI5	Subtotal 5 from Pricing Procedure for Price Element
KZWI6	Subtotal 6 from Pricing Procedure for Price Element
BONBA	Rebate Basis 1
DPAMT	Down Payment Amount in Document Currency
TARGET_VALUE	Target Value at Item Level in Procurement Hub
EXPECTED_VALUE	Expected Value of Overall Limit
LIMIT_AMOUNT	Overall Limit
💲 Currency of statistical values for foreign trade (EKKO.GRWCU):
GRWRT	Statistical value for foreign trade

Column Name	Description
📏 Purchase Order Unit of Measure (MEINS):
KTMNG	Target Quantity
MENGE	Purchase Order Quantity
ABFTZ	Agreed Cumulative Quantity
ABMNG	Standard release order quantity
MFZHI	Maximum Cumulative Material Go-Ahead Quantity
FFZHI	Maximum Cumulative Production Go-Ahead Quantity
CQU_SAR	Cumulative Goods Receipts from Redirected Purchase Orders
📏 Unit of Weight (GEWEI):
NTGEW	Net Weight
BRGEW	Gross weight
📏 Volume unit (VOLEH):
VOLUM	Volume
📏 Points Unit (PUNEI):
ANZPU	Number of Points

Column Name	Description
AEDAT	Purchasing Document Item Change Date
AGDAT	Deadline for Submission of Bid/Quotation
TXDAT_FROM	Valid-From Date of the Tax Rate
TXDAT	Date for Determining Tax Rates
ABDAT	Reconciliation date for agreed cumulative quantity
PRDAT	Date of Price Determination
LEWED	Latest Possible Goods Receipt
EILDT	Start Date for GR-Based Settlement
DRDAT	Last Transmission
DRUHR	Time
NLABD	Next Forecast Delivery Schedule Transmission
NFABD	Next JIT Delivery Schedule Transmission
J_1AIDATEP	Inflation Index Date
CREATIONDATE	Purchasing Document Creation Date
CREATIONTIME	Purchasing Document Creation Time
DPDAT	Due Date for Down Payment
ENH_DATE1	Start date of WKA working period
ENH_DATE2	End date of WKA working period
_DATAAGING	Data Filter Value for Data Aging

Column Name	Description
STATU	Origin of a Purchasing Document Item	Show values
INSMK	Stock Type	Show values
SPINF	Indicator: Update Info Record	Show values
PRSDR	Price Printout	Show values
SCHPR	Indicator: Estimated Price	Show values
UEBTK	Unlimited Overdelivery Allowed	Show values
ABSKZ	Rejection Indicator	Show values
ELIKZ	"Delivery Completed" Indicator	Show values
EREKZ	Final Invoice Indicator	Show values
KZVBR	Consumption posting	Show values
VRTKZ	Distribution Indicator for Multiple Account Assignment	Show values
TWRKZ	Partial invoice indicator	Show values
WEPOS	Goods Receipt Indicator	Show values
WEUNB	Goods Receipt, Non-Valuated	Show values
REPOS	Invoice receipt indicator	Show values
WEBRE	Indicator: GR-Based Invoice Verification	Show values
KZABS	Order Acknowledgment Requirement	Show values
KZSTU	Firm/Trade-Off Zones Binding with Regard to Mat. Planning	Show values
NOTKZ	Exclusion in Outline Agreement Item with Material Class	Show values
BSTYP	Purchasing Document Category	Show values
XOBLR	Item affects commitments	Show values
SKTOF	Item Does Not Qualify for Cash Discount	Show values
ETDRK	Indicator: Print-relevant schedule lines exist	Show values
INSNC	Quality inspection indicator cannot be changed	Show values
MEPRF	Price Determination (Pricing) Date Control	Show values
VORAB	Advance procurement: project stock	Show values
STAPO	Item is statistical	Show values
LBLKZ	Subcontracting Supplier	Show values
ATTYP	Material Category	Show values
KANBA	Kanban Indicator	Show values
DELIVERY_ADDRESS_TYPE	Purchasing Delivery Address Type	Show values
XERSY	Evaluated Receipt Settlement (ERS)	Show values
EBONF	Item Relevant to Subsequent (Period-End Rebate) Settlement	Show values
MLMAA	Material Ledger Activated at Material Level	Show values
KZKFG	Origin of Configuration	Show values
RETPO	Returns Item	Show values
AUREL	Relevant to Allocation Table	Show values
NRFHG	Material qualifies for discount in kind	Show values
J_1BMATUSE	Usage of the material	Show values
J_1BMATORG	Origin of the material	Show values
J_1BOWNPRO	Produced in-house	Show values
J_1BINDUST	Material CFOP category	Show values
KZBWS	Valuation of Special Stock	Show values
FABKZ	Indicator: Item Relevant to JIT Delivery Schedules	Show values
EGLKZ	"Outward Delivery Completed" Indicator	Show values
KZTLF	Partial Delivery at Item Level (Stock Transfer)	Show values
KZFME	Units of measure usage	Show values
CHG_SRV	Configuration changed	Show values
CHG_FPLNR	No invoice for this item although not free of charge	Show values
NOVET	Item blocked for SD delivery	Show values
IPRKZ	Period Indicator for Shelf Life Expiration Date	Show values
LEBRE	Indicator for Service-Based Invoice Verification	Show values
XCONDITIONS	Conditions for item although no invoice	Show values
APOMS	APO as Planning System	Show values
CCOMP	Posting Logic in the Case of Stock Transfers	Show values
STATUS	Status of Purchasing Document Item	Show values
WEORA	Acceptance At Origin	Show values
SRV_BAS_COM	Service-Based Commitment	Show values
DIFF_INVOICE	Differential Invoicing	Show values
TRMRISK_RELEVANT	Risk Relevancy in Purchasing	Show values
SPE_CRM_FKREL	Billing Relevance CRM	Show values
SPE_CHNG_SYS	Last Changer's System Type	Show values
SPE_INSMK_SRC	Stock Type of Source Storage Location in STO	Show values
SPE_CQ_CTRLTYPE	CQ Control Type	Show values
SPE_CQ_NOCQ	No Transmission of Cumulative Quantities in SA Release	Show values
SPE_EWM_DTC	EWM Delivery Based Tolerance Check	Show values
FLS_RSTO	Store Return with Inbound and Outbound Delivery	Show values
ITCONS	Real-Time Consumption Posting of Subcontracting Components	Show values
FIXMG	Delivery Date and Quantity Fixed	Show values
WABWE	Indicator for GI-based goods receipt	Show values
CMPL_DLV_ITM	Complete Delivery Requested for Purchase Order Item	Show values
GR_BY_SES	Are GRs posted by using Service Entry Sheet	Show values
RENEGOTIATION_STATUS	Renegotiation Status	Show values
STATUS_PCS	Product Compliance Supplier Check Status (Item)	Show values
STATUS_PMA	Product Marketability Status (Item)	Show values
STATUS_DG	Dangerous Goods Status (Item)	Show values
STATUS_SDS	Safety Data Sheet Status (Item)	Show values
TAX_SUBJECT_ST	Tax Subject to Substituição Tributária	Show values
/BEV1/NEGEN_ITEM	Indicator: Item Is Generated	Show values
/BEV1/NEDEPFREE	Indicator: Dependent Items Are Free of Charge	Show values
/BEV1/NESTRUCCAT	Structure Category for Material Relationship	Show values
IUID_RELEVANT	IUID-Relevant	Show values
MRPIND	Max. Retail Price Relevant	Show values
ISNOTEAVAILABLE	Boolean Variables (X=true, space=false)	Show values
ISATTACHMENTAVAILABLE	Boolean Variables (X=true, space=false)	Show values
PURCHASEORDERITEMSTATUS	Status Descriptions for Purchase Order Item	Show values

Column Name	Description	Domain name
UNIQUEID	Concatenation of PO No., PO item No., and Ext.Source System.	CENTRLPURCHASEDOCITEMUNIQUEID
LOEKZ	Deletion Indicator in Purchasing Document	ELOEK
TXZ01	Short Text	TEXT40
BEDNR	Requirement Tracking Number	CHAR10
IDNLF	Material Number Used by Supplier	IDNEX
BPUMZ	Numerator for Conversion of Order Price Unit into Order Unit	UMBSZ
BPUMN	Denominator for Conv. of Order Price Unit into Order Unit	UMBSN
UMREZ	Numerator for Conversion of Order Unit to Base Unit	UMBSZ
UMREN	Denominator for Conversion of Order Unit to Base Unit	UMBSN
PEINH	Price unit	DEC5
WEBAZ	Goods receipt processing time in days	DEC3
TAX_COUNTRY	Tax Reporting Country/Region	LAND1
BONUS	Settlement Group 1 (Purchasing)	EBONU
MAHNZ	Number of Reminders/Expediters	PACK2
MAHN1	Number of Days for First Reminder/Expediter	MAHNT
MAHN2	Number of Days for Second Reminder/Expediter	MAHNT
MAHN3	Number of Days for Third Reminder/Expediter	MAHNT
UEBTO	Overdelivery Tolerance	PRZ21
UNTTO	Underdelivery Tolerance	PRZ21
LABNR	Order Acknowledgment Number	TEXT20
ETFZ1	Firm Zone (Go-Ahead for Production)	PACK2
ETFZ2	Trade-Off Zone (Go-Ahead for Materials Procurement)	PACK2
EKKOL	Condition Group with Supplier	CHAR4
STAFO	Update Group for statistics update	STAFO
PLIFZ	Planned Delivery Time in Days	DEC3
ARSNR	Settlement reservation number	MDNUM
ARSPS	Item number of the settlement reservation	RSPOS
EAN11	International Article Number (EAN/UPC)	EAN11
REVLV	Revision Level	REVLV
GEBER	Fund	BP_GEBER
FISTL	Funds Center	FISTL
KO_GSBER	Business area reported to the partner	GSBER
KO_PARGB	assumed business area of the business partner	GSBER
INCO2	Incoterms (Part 2)	INCO2
FPLNR	Invoicing plan number	CHAR10
VSART	Shipping Type	VERSART
HANDOVERLOC	Location for a physical handover of goods	HANDOVER_LOC
CUOBJ	Configuration (internal object number)	CUOBJ
DRUNR	Sequential Number	NUMC4
ABELP	Allocation Table Item	ABELP
SAISJ	Season Year	CJAHR
EBON2	Settlement Group 2 (Rebate Settlement, Purchasing)	EBONU
EBON3	Settlement Group 3 (Rebate Settlement, Purchasing)	EBONU
MHDRZ	Minimum Remaining Shelf Life	DEC4
UMSOK	Special stock indicator for physical stock transfer	SOBKZ
BANFN	Purchase Requisition Number	BANFN
UPVOR	Subitems Exist	CHAR1
LOADINGPOINT	Loading/Unloading Point
MPROF	Mfr part profile	MPROF
TECHS	Parameter Variant/Standard Variant	TECHS
MFRPN	Manufacturer Part Number	CHAR40
EMNFR	External manufacturer code name or number	CHAR10
AFNAM	Name of requisitioner/requester	AFNAM
TZONRC	Time zone of recipient location	TZNZONE
GRANT_NBR	Grant	GM_GRANT_NBR
FKBER	Functional Area	FKBER
KBLNR	Document Number for Earmarked Funds	KBLNR
KBLPOS	Earmarked Funds: Document Item	KBLPOS
KOSTL	Cost Center	KOSTL
EMPST	Receiving Point	TEXT25
VCM_CHAIN_CATEGORY	Value Chain Category	VCM_CHAIN_CATEGORY
SPE_ABGRU	Reason for rejection of quotations and sales orders	ABGRU
SPE_CRM_SO	CRM Sales Order Number for TPOP Process	/SPE/VBELN_CRM
SPE_CRM_SO_ITEM	CRM Sales Order Item Number in TPOP Process	/SPE/POSNR_CRM
SPE_CRM_REF_SO	CRM Reference Order Number for TPOP Process	/SPE/REF_VBELN_CRM
SPE_CRM_REF_ITEM	CRM Reference Sales Order Item Number in TPOP Process	/SPE/REF_POSNR_CRM
REASON_CODE	Goods Receipt Reason Code	/SAPPSPRO/_GR_REASON_CODE
ANZSN	Number of serial numbers	INT4
EXLIN	Hierarchy Number	EXLIN
EXSNR	External Sort Number	EXSNR
RETPC	Retention in Percent	PRZ32
DPTYP	Down Payment Indicator	ME_DPTYPE_DOMAIN
DPPCT	Down Payment Percentage	PRZ32
EXT_RFX_NUMBER	Document Number of External Document	ME_EXT_DOC_ID
EXT_RFX_ITEM	Item Number of External Document	ME_EXT_DOC_ITEM_ID
EXT_RFX_SYSTEM	Logical System	LOGSYS
SRM_CONTRACT_ID	Central Contract	BBP_BAPI_EBELN
SRM_CONTRACT_ITM	Central Contract Item Number	BBP_ITEMNO
BLK_REASON_ID	Blocking Reason - ID	BLK_REASON_ID
BLK_REASON_TXT	Blocking Reason - Text	BLK_REASON_TXT
INCO2_L	Incoterms Location 1	INCO_L
INCO3_L	Incoterms Location 2	INCO_L
INCO2_KEY	Incoterm Location 1 - Place of Destination	/SCMTMS/LOCUUID
INCO3_KEY	Incoterm Location 2 - Place of Delivery	/SCMTMS/LOCUUID
INCO4_KEY	Incoterm - Deviating Place of Destination	/SCMTMS/LOCUUID
STAWN	Commodity Code	/SAPSLL/CCNGN
ISVCO	Intrastat Service Code	/SAPSLL/CCNGN
SERVICEPERFORMER	Service Performer	BU_PARTNER
PRODUCTTYPE	Product Type Group	CHAR2
REQUESTFORQUOTATION	Identifier for Request for Quotation	EBELN
REQUESTFORQUOTATIONITEM	Item Number for Request for Quotation	EBELP
EXTMATERIALFORPURG	Material of External System	MATNR
EXTERNALREFERENCEID	External Reference ID	MMPUR_EXTREFID
TC_AUT_DET	Tax Code Automatically Determined	MWSKZ
MANUAL_TC_REASON	Manual Tax Code Reason	J_1BMANUAL_TC_REASON
FISCAL_INCENTIVE	Tax Incentive Type	J_1BFISCAL_INCENTIVE_CODE
FISCAL_INCENTIVE_ID	Incentive ID	J_1BFISCAL_INCENTIVE_ID
SF_TXJCD	Jurisdiction Code of the Point of Origin	J_1BTXJCD
DUMMY_EKPO_INCL_EEW_PS	Data Element for Extensibility of Purchasing Document Item	EKPO_INCL_EEW
CONTRACT_FOR_LIMIT	Purchase Contract for Enhanced Limit	EBELN
ENH_PERCENT	WKA: Percentage of wages	PRZ32
ENH_NUMC1	Working time in hours	NUM10
CUPIT	CUP Italy Codice Unico di Progetto - Unique Project Code	GLO_IT_CUP
CIGIT	CIG Italy : Competition Identification Number	GLO_IT_CIG
TXS_BUSINESS_TRANSACTION	Tax Service Business Transaction	TXS_BUSINESS_TRANSACTION
TXS_MATERIAL_USAGE	Tax Service Material Usage
TXS_USAGE_PURPOSE	Tax Service Usage Purpose	TXS_USAGE_PURPOSE
ADVCODE	Advice Code	/ISDFPS/ADVCODE
BUDGET_PD	Budget Period	FM_BUDGET_PERIOD
EXCPE	Acceptance Period	NUM02
FMFGUS_KEY	United States Federal Government Fields	SYSUUID_22
SGT_SCAT	Stock Segment	SGT_SRCA
SGT_RCAT	Requirement Segment	SGT_SRCA
TMS_REF_UUID	Reference UUID of Transportation Management	SYSUUID_22
TMS_SRC_LOC_KEY	Location GUID (004) with Conversion Exit	/SCMTMS/LOCUUID
TMS_DES_LOC_KEY	Location GUID (004) with Conversion Exit	/SCMTMS/LOCUUID
WRF_CHARSTC1	Characteristic Value 1	WRF_CHARSTC
WRF_CHARSTC2	Characteristic Value 2	WRF_CHARSTC
WRF_CHARSTC3	Characteristic Value 3	WRF_CHARSTC
TAXPROCEDURE	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	KALSM
SUBCONTRACTORADDRESSID	Address	ADRNR
CUSTOMERADDRESSID	Address	ADRNR
DUMMY_EXT_EKPO_INCL_EEW_PS	Data Element for Extensibility of Purchasing Document Item	EKPO_INCL_EEW
PURCHASEORDERITEMSTATUSNAME	Purchase Order Item Status	CHAR260
POITEMDELIVERYADDRESSID	Address Number	AD_ADDRNUM

Master Data Relations	Join Conditions
Check Against Customizing Plant Release Creation Profile	`MMPUR_EXT_EKPO.MANDT == T163P.MANDT` `MMPUR_EXT_EKPO.WERKS == T163P.WERKS` `MMPUR_EXT_EKPO.ABUEB == T163P.ABUEB`
Number of delivery address Number of delivery address ? ?	`MMPUR_EXT_EKPO.MANDT == ADRC.CLIENT` `MMPUR_EXT_EKPO.ADRN2 == ADRC.ADDRNUMBER` `MMPUR_EXT_EKPO.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM` `MMPUR_EXT_EKPO.[column in domain "AD_NATION"] == ADRC.NATION`
Link to Central Address Management Manual address number in purchasing document item Purchasing Document Item Change Date ?	`MMPUR_EXT_EKPO.MANDT == ADRC.CLIENT` `MMPUR_EXT_EKPO.ADRNR == ADRC.ADDRNUMBER` `MMPUR_EXT_EKPO.AEDAT == ADRC.DATE_FROM` `MMPUR_EXT_EKPO.[column in domain "AD_NATION"] == ADRC.NATION`
Internal Comment on Quotation	`MMPUR_EXT_EKPO.MANDT == TMAM.MANDT` `MMPUR_EXT_EKPO.AGMEM == TMAM.AGMEM`
Promotion Promotion Client	`MMPUR_EXT_EKPO.AKTNR == WAKH.AKTNR` `MMPUR_EXT_EKPO.MANDT == WAKH.MANDT`
MRP Area	`MMPUR_EXT_EKPO.MANDT == MDLV.MANDT` `MMPUR_EXT_EKPO.BERID == MDLV.BERID`
Order Price Unit (Purchasing)	`MMPUR_EXT_EKPO.MANDT == T006.MANDT` `MMPUR_EXT_EKPO.BPRME == T006.MSEHI`
Reason for Ordering	`MMPUR_EXT_EKPO.MANDT == TBSG.MANDT` `MMPUR_EXT_EKPO.BSGRU == TBSG.BSGRU`
Confirmation Control Key Confirmation Control Key Client	`MMPUR_EXT_EKPO.BSTAE == T163L.BSTAE` `MMPUR_EXT_EKPO.MANDT == T163L.MANDT`
Company Code	`MMPUR_EXT_EKPO.MANDT == T001.MANDT` `MMPUR_EXT_EKPO.BUKRS == T001.BUKRS`
Valuation Type	`MMPUR_EXT_EKPO.MANDT == T149D.MANDT` `MMPUR_EXT_EKPO.BWTAR == T149D.BWTAR`
Valuation Category Valuation Category Client	`MMPUR_EXT_EKPO.BWTTY == T149C.BWTTY` `MMPUR_EXT_EKPO.MANDT == T149C.MANDT`
External Hierarchy Category External Hierarchy Category Client	`MMPUR_EXT_EKPO.EHTYP == TMSRM_EHTYP.EHTYP` `MMPUR_EXT_EKPO.MANDT == TMSRM_EHTYP.MANDT`
Material number Material number Client	`MMPUR_EXT_EKPO.EMATN == MARA.MATNR` `MMPUR_EXT_EKPO.MANDT == MARA.MANDT`
Supplier to be Supplied/Who is to Receive Delivery	`MMPUR_EXT_EKPO.MANDT == LFA1.MANDT` `MMPUR_EXT_EKPO.EMLIF == LFA1.LIFNR`
Shipping Instructions Shipping Instructions Client	`MMPUR_EXT_EKPO.EVERS == T027A.EVERS` `MMPUR_EXT_EKPO.MANDT == T027A.MANDT`
Commitment Item Commitment Item ? Date of Price Determination	`MMPUR_EXT_EKPO.MANDT == FMFPO.MANDT` `MMPUR_EXT_EKPO.FIPOS == FMFPO.FIPOS` `MMPUR_EXT_EKPO.[column in domain "FIKRS"] == FMFPO.FIKRS` `MMPUR_EXT_EKPO.PRDAT == FMFPO.DATBIS`
Unit of Weight	`MMPUR_EXT_EKPO.MANDT == T006.MANDT` `MMPUR_EXT_EKPO.GEWEI == T006.MSEHI`
Incoterms (Part 1) Incoterms (Part 1) Client	`MMPUR_EXT_EKPO.INCO1 == TINC.INCO1` `MMPUR_EXT_EKPO.MANDT == TINC.MANDT`
Number of purchasing info record Number of purchasing info record Client	`MMPUR_EXT_EKPO.INFNR == EINA.INFNR` `MMPUR_EXT_EKPO.MANDT == EINA.MANDT`
Inflation Index	`MMPUR_EXT_EKPO.MANDT == J_1AINFT20.MANDT` `MMPUR_EXT_EKPO.J_1AINDXP == J_1AINFT20.J_1AINDX`
Brazilian NCM Code Brazilian NCM Code Client ?	`MMPUR_EXT_EKPO.J_1BNBM == T604F.STEUC` `MMPUR_EXT_EKPO.MANDT == T604F.MANDT` `MMPUR_EXT_EKPO.[column in domain "LAND1"] == T604F.LAND1`
Account Assignment Category	`MMPUR_EXT_EKPO.MANDT == T163K.MANDT` `MMPUR_EXT_EKPO.KNTTP == T163K.KNTTP`
Prior Supplier	`MMPUR_EXT_EKPO.MANDT == LFA1.MANDT` `MMPUR_EXT_EKPO.KOLIF == LFA1.LIFNR`
Partner Profit Center ? ? Partner Profit Center	`MMPUR_EXT_EKPO.MANDT == CEPC.MANDT` `MMPUR_EXT_EKPO.[column in domain "DATBI"] == CEPC.DATBI` `MMPUR_EXT_EKPO.[column in domain "KOKRS"] == CEPC.KOKRS` `MMPUR_EXT_EKPO.KO_PPRCTR == CEPC.PRCTR`
Profit Center ? ? Profit Center	`MMPUR_EXT_EKPO.MANDT == CEPC.MANDT` `MMPUR_EXT_EKPO.[column in domain "DATBI"] == CEPC.DATBI` `MMPUR_EXT_EKPO.[column in domain "KOKRS"] == CEPC.KOKRS` `MMPUR_EXT_EKPO.KO_PRCTR == CEPC.PRCTR`
Customer	`MMPUR_EXT_EKPO.MANDT == KNA1.MANDT` `MMPUR_EXT_EKPO.KUNNR == KNA1.KUNNR`
Delivery Type for Returns to Supplier	`MMPUR_EXT_EKPO.MANDT == TVLK.MANDT` `MMPUR_EXT_EKPO.LFRET == TVLK.LFART`
Storage location Storage location Client Plant	`MMPUR_EXT_EKPO.LGORT == T001L.LGORT` `MMPUR_EXT_EKPO.MANDT == T001L.MANDT` `MMPUR_EXT_EKPO.WERKS == T001L.WERKS`
Base Unit of Measure	`MMPUR_EXT_EKPO.MANDT == T006.MANDT` `MMPUR_EXT_EKPO.LMEIN == T006.MSEHI`
Supplier Subrange Supplier Subrange Prior Supplier Client	`MMPUR_EXT_EKPO.LTSNR == WYT1.LTSNR` `MMPUR_EXT_EKPO.KOLIF == WYT1.LIFNR` `MMPUR_EXT_EKPO.MANDT == WYT1.MANDT`
Material Group	`MMPUR_EXT_EKPO.MANDT == T023.MANDT` `MMPUR_EXT_EKPO.MATKL == T023.MATKL`
Material Number Material Number Client	`MMPUR_EXT_EKPO.MATNR == MARA.MATNR` `MMPUR_EXT_EKPO.MANDT == MARA.MANDT`
Purchase Order Unit of Measure	`MMPUR_EXT_EKPO.MANDT == T006.MANDT` `MMPUR_EXT_EKPO.MEINS == T006.MSEHI`
Material freight group Material freight group Client	`MMPUR_EXT_EKPO.MFRGR == TMFG.MFRGR` `MMPUR_EXT_EKPO.MANDT == TMFG.MANDT`
Manufacturer number	`MMPUR_EXT_EKPO.MANDT == LFA1.MANDT` `MMPUR_EXT_EKPO.MFRNR == LFA1.LIFNR`
Material type	`MMPUR_EXT_EKPO.MANDT == T134.MANDT` `MMPUR_EXT_EKPO.MTART == T134.MTART`
Tax on sales/purchases code ? Tax on sales/purchases code	`MMPUR_EXT_EKPO.MANDT == T007A.MANDT` `MMPUR_EXT_EKPO.[column in domain "KALSM_D"] == T007A.KALSM` `MMPUR_EXT_EKPO.MWSKZ == T007A.MWSKZ`
Package number	`MMPUR_EXT_EKPO.MANDT == ESLH.MANDT` `MMPUR_EXT_EKPO.PACKNO == ESLH.PACKNO`
Requirement Priority Requirement Priority Client	`MMPUR_EXT_EKPO.PRIO_REQ == PREQ.PRIO_REQ` `MMPUR_EXT_EKPO.MANDT == PREQ.MANDT`
Requirement Urgency Requirement Urgency Client	`MMPUR_EXT_EKPO.PRIO_URG == PURG.PRIO_URG` `MMPUR_EXT_EKPO.MANDT == PURG.MANDT`
Item category in purchasing document Item category in purchasing document Client	`MMPUR_EXT_EKPO.PSTYP == T163.PSTYP` `MMPUR_EXT_EKPO.MANDT == T163.MANDT`
Points Unit	`MMPUR_EXT_EKPO.MANDT == T006.MANDT` `MMPUR_EXT_EKPO.PUNEI == T006.MSEHI`
Rounding Profile Plant Rounding Profile ?	`MMPUR_EXT_EKPO.MANDT == RDPR.MANDT` `MMPUR_EXT_EKPO.WERKS == RDPR.WERKS` `MMPUR_EXT_EKPO.RDPRF == RDPR.RDPRF` `MMPUR_EXT_EKPO.[column in domain "RDZAE"] == RDPR.RDZAE`
Issuing Storage Location for Stock Transport Order Issuing Storage Location for Stock Transport Order Client ?	`MMPUR_EXT_EKPO.RESLO == T001L.LGORT` `MMPUR_EXT_EKPO.MANDT == T001L.MANDT` `MMPUR_EXT_EKPO.[column in domain "WERKS_D"] == T001L.WERKS`
Season Category	`MMPUR_EXT_EKPO.MANDT == T6WSP.MANDT` `MMPUR_EXT_EKPO.SAISO == T6WSP.SAISO`
G/L Account Number ? Client G/L Account Number	`MMPUR_EXT_EKPO.[column in domain "KTOPL"] == SKA1.KTOPL` `MMPUR_EXT_EKPO.MANDT == SKA1.MANDT` `MMPUR_EXT_EKPO.SAKTO == SKA1.SAKNR`
Cross-Plant Configurable Material Cross-Plant Configurable Material Client	`MMPUR_EXT_EKPO.SATNR == MARA.MATNR` `MMPUR_EXT_EKPO.MANDT == MARA.MANDT`
Processing key for sub-items Processing key for sub-items Client	`MMPUR_EXT_EKPO.SIKGR == TMSI2.SIKGR` `MMPUR_EXT_EKPO.MANDT == TMSI2.MANDT`
Special Stock Indicator	`MMPUR_EXT_EKPO.MANDT == T148.MANDT` `MMPUR_EXT_EKPO.SOBKZ == T148.SOBKZ`
Control Key for Quality Management in Procurement Control Key for Quality Management in Procurement Client	`MMPUR_EXT_EKPO.SSQSS == TQ08.QM_PUR` `MMPUR_EXT_EKPO.MANDT == TQ08.MANDT`
Tax Jurisdiction ? Tax Jurisdiction	`MMPUR_EXT_EKPO.MANDT == TTXJ.MANDT` `MMPUR_EXT_EKPO.[column in domain "TAX_KALSM"] == TTXJ.KALSM` `MMPUR_EXT_EKPO.TXJCD == TTXJ.TXJCD`
Subitem Category, Purchasing Document Subitem Category, Purchasing Document Client	`MMPUR_EXT_EKPO.UPTYP == TMSI1.UPTYP` `MMPUR_EXT_EKPO.MANDT == TMSI1.MANDT`
Volume unit	`MMPUR_EXT_EKPO.MANDT == T006.MANDT` `MMPUR_EXT_EKPO.VOLEH == T006.MSEHI`
Plant	`MMPUR_EXT_EKPO.MANDT == T001W.MANDT` `MMPUR_EXT_EKPO.WERKS == T001W.WERKS`
Certificate Type	`MMPUR_EXT_EKPO.MANDT == TQ05.MANDT` `MMPUR_EXT_EKPO.ZGTYP == TQ05.ZGTYP`

Other Relations \| to Master Data Relations ↑	Join Conditions
Quota arrangement usage	`MMPUR_EXT_EKPO.MANDT == TMQ2.MANDT` `MMPUR_EXT_EKPO.USEQU == TMQ2.USEQU`