SAP table EINE (Purchasing Info Record: Purchasing Organization Data)

SAP table EINE has 5 primary key fields being MANDT,INFNR,EKORG,ESOKZ,WERKS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
INFNR Number of purchasing info record CHAR 10 0 EINA INFNR
EKORG Purchasing organization CHAR 4 0 T024E EKORG
ESOKZ Purchasing info record category CHAR 1 0 ESOKZ
0 Standard
1 Chargeable
2 Consignment
3 Subcontracting
P Pipeline
WERKS Plant CHAR 4 0 T001W EWERK
LOEKZ Purch. info: Purch. organization data flagged for deletion CHAR 1 0 ILOEE
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
EKGRP Purchasing Group CHAR 3 0 T024 BKGRP
WAERS Currency Key CUKY 5 0 TCURC WAERS
BONUS Indicator: Volume-Based Rebate CHAR 1 0 WRBON
MGBON Indicator: Quantity-Based Volume Rebate CHAR 1 0 MGBON
MINBM Minimum Purchase Order Quantity QUAN 13 3 MINBM
NORBM Standard Purchase Order Quantity QUAN 13 3 NORBM
APLFZ Planned Delivery Time in Days DEC 3 0 PLIFZ
UEBTO Overdelivery Tolerance DEC 3 1 UEBTO
UEBTK Unlimited Overdelivery Allowed CHAR 1 0 UEBTK
UNTTO Underdelivery Tolerance DEC 3 1 UNTTO
ANGNR Quotation Number CHAR 10 0 ANGNR
ANGDT Quotation Validity Date DATS 8 0 ANGDT
ANFNR RFQ Number CHAR 10 0 EKKO ANFNR
ANFPS Item Number of RFQ NUMC 5 0 EKPO ANFPS
ABSKZ Rejection Indicator CHAR 1 0 ABSKZ
AMODV Amortization period from DATS 8 0 AMODV
AMODB Amortization period to DATS 8 0 AMODB
AMOBM Amortized planned quantity QUAN 15 3 AMOBM
AMOBW Amortized planned value CURR 15 2 AMOBW
AMOAM Amortized actual quantity QUAN 15 3 AMOAM
AMOAW Amortized actual value CURR 15 2 AMOAW
AMORS Indicator: Amortization reset CHAR 1 0 AMORS
BSTYP Purchasing Document Category CHAR 1 0 BSTYP
A Request for quotation
B Purchase requisition
C Central Contract
F Purchase order
I Info record
K Contract
L Scheduling agreement
N Central Request for Quotation
O Quotation
Q Service entry sheet
R Request for Quotation
S Simplified service entry sheet
T Central Quotation
W Source list
EBELN Purchasing Document Number CHAR 10 0 EKKO EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EKPO EBELP
DATLB Date of Last PO or Sched. Agreement Document in Info Record DATS 8 0 DATLB
NETPR Net Price in Purchasing Info Record CURR 11 2 IPREI
PEINH Price unit DEC 5 0 EPEIN
BPRME Order Price Unit (Purchasing) UNIT 3 0 T006 BBPRM
PRDAT Price Valid Until DATS 8 0 PRGBI
BPUMZ Numerator for Conversion of Order Price Unit into Order Unit DEC 5 0 BPUMZ
BPUMN Denominator for Conv. of Order Price Unit into Order Unit DEC 5 0 BPUMN
MTXNO Material Master Record PO Text Not Relevant CHAR 1 0 MTXNO
WEBRE Indicator: GR-Based Invoice Verification CHAR 1 0 WEBRE
EFFPR Effective Price in Purchasing Info Record CURR 11 2 EFFPR
EKKOL Condition Group with Supplier CHAR 4 0 EKKOG
SKTOF Item Does Not Qualify for Cash Discount CHAR 1 0 ESKTOF
KZABS Order Acknowledgment Requirement CHAR 1 0 KZABS
MWSKZ Tax on sales/purchases code CHAR 2 0 T007A MWSKZ
TXDAT_FROM Valid-From Date of the Tax Rate DATS 8 0 FOT_TXDAT_FROM
TAX_COUNTRY Tax Reporting Country/Region CHAR 3 0 T005 FOT_TAX_COUNTRY
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
EBONU Settlement Group 1 (Purchasing) CHAR 2 0 EBONU
EVERS Shipping Instructions CHAR 2 0 T027A EVERS
EXPRF Procedure CHAR 8 0 T616 EXPRF
BSTAE Confirmation Control Key CHAR 4 0 T163L BSTAE
MEPRF Price Determination (Pricing) Date Control CHAR 1 0 MEPRF
No Control
1 Purchase Order Date
2 Delivery Date
3 Current Date
4 Manual
5 GR/Post. Date
6 GR/Doc. Date
INCO1 Incoterms (Part 1) CHAR 3 0 TINC INCO1
INCO2 Incoterms (Part 2) CHAR 28 0 INCO2
XERSN No Evaluated Receipt Settlement (ERS) CHAR 1 0 XERSN
EBON2 Settlement Group 2 (Rebate Settlement, Purchasing) CHAR 2 0 EBON2
EBON3 Settlement Group 3 (Rebate Settlement, Purchasing) CHAR 2 0 EBON3
EBONF Item Not Relevant to Subseq. (Period-End Rebate) Settlement CHAR 1 0 EBONF
MHDRZ Minimum Remaining Shelf Life DEC 4 0 MHDRZ
VERID Production Version CHAR 4 0 MKAL VERID
BSTMA Maximum Purchase Order Quantity QUAN 13 3 MAXBM
RDPRF Rounding Profile CHAR 4 0 RDPR RDPRF
MEGRU Unit of Measure Group CHAR 4 0 TWMEG MEGRU
J_1BNBM Brazilian NCM Code CHAR 16 0 T604F J_1BNBMCO1
SPE_CRE_REF_DOC Create Purchase Order for Delivery Without Reference CHAR 1 0 /SPE/CRE_REF_DOC
IPRKZ Period Indicator for Shelf Life Expiration Date CHAR 1 0 DATTP
Day
1 Week
2 Month
3 Year
CO_ORDER Real-Time Consumption Posting of Subcontracting Components CHAR 1 0 ME_IR_CO_ORDER
VENDOR_RMA_REQ Supplier RMA Number Required CHAR 1 0 MSR_VRMA_REQ_EINE
Supplier RMA Not Required
V Information from Supplier Master Record
X Supplier RMA Required
DIFF_INVOICE Differential Invoicing CHAR 2 0 DIFF_INVOICE
01 Not Relevant
02 Relevant
INCOV Incoterms Version CHAR 4 0 TINCV INCOV
INCO2_L Incoterms Location 1 CHAR 70 0 INCO2_L
INCO3_L Incoterms Location 2 CHAR 70 0 INCO3_L
AUT_SOURCE Relevant for Automatic Sourcing CHAR 1 0 AUT_SOURCE
Not Relevant for Automatic Sourcing
X Relevant for Automatic Sourcing
DUMMY_EINE_INCL_EEW_PS EINE_INCL_EEW CHAR 1 0 EINE_INCL_EEW
ISEOPBLOCKED Business Purpose Completed CHAR 1 0 EOPBLOCKED
Ongoing Business, Active Purpose
X Business Purpose Completed, End of Purpose Reached
FSH_DCI_CORR Delivery Completion Indicator Correlation CHAR 1 0 FSH_DCI_CORRELATION
FSH_RLT Replenishment Lead Time for Raw Material DEC 3 0 FSH_PDT_RLT
FSH_MLT Manufacturing Lead Time DEC 3 0 FSH_PDT_MLT
FSH_PLT Packing Lead time DEC 3 0 FSH_PDT_PLT
FSH_TLT Transportation Lead Time DEC 3 0 FSH_PDT_TLT
MRPIND Max. Retail Price Relevant CHAR 1 0 J_1IRMRPIND
Non Maximum Retail Price relevant.
X Maximum Retail Price relevant.
SGT_SSREL Stock Segment Relevant Indicator CHAR 1 0 SGT_SSREL
TRANSPORT_CHAIN Transportation Chain CHAR 10 0 WRF_PSCD_TCHAINH WRF_PSCD_TC_ID
STAGING_TIME Staging Time in Days DEC 3 0 WRF_PSCD_MST

EINE foreign key relationships

Table Field Check Table Check Field
0 EINE ANFNR EKKO Purchasing Document Header MANDT
0 EINE ANFNR EKKO Purchasing Document Header EBELN
1 EINE ANFPS EKPO Purchasing Document Item MANDT
1 EINE ANFPS EKPO Purchasing Document Item EBELN
0 EINE BPRME T006 Units of Measurement MANDT
1 EINE BSTAE T163L Confirmation Control Keys BSTAE
0 EINE BWTAR T149D Global Valuation Types MANDT
0 EINE BWTAR T149D Global Valuation Types BWTAR
1 EINE EBELN EKKO Purchasing Document Header EBELN
0 EINE EBELP EKPO Purchasing Document Item MANDT
0 EINE EBELP EKPO Purchasing Document Item EBELN
1 EINE EKGRP T024 Purchasing Groups EKGRP
0 EINE EKORG T024E Purchasing Organizations EKORG
1 EINE EVERS T027A Shipping Instructions, Purchasing EVERS
0 EINE EXPRF T616 Procedure LAND1
1 EINE INCO1 TINC Customers: Incoterms INCO1
0 EINE INCOV TINCV Incoterms Versions MANDT
0 EINE INCOV TINCV Incoterms Versions INCOV
1 EINE INFNR EINA Purchasing Info Record: General Data INFNR
0 EINE J_1BNBM T604F Import Processing: Control Code MANDT
0 EINE J_1BNBM T604F Import Processing: Control Code LAND1
1 EINE MANDT T000 Clients MANDT
0 EINE MEGRU TWMEG Unit of measure group MANDT
0 EINE MEGRU TWMEG Unit of measure group MEGRU
0 EINE MEGRU TWMEG Unit of measure group MEINS
1 EINE MWSKZ T007A Tax Keys KALSM
1 EINE MWSKZ T007A Tax Keys MWSKZ
0 EINE RDPRF RDPR Rounding profile MANDT
0 EINE RDPRF RDPR Rounding profile WERKS
0 EINE RDPRF RDPR Rounding profile RDPRF
0 EINE RDPRF RDPR Rounding profile RDZAE
1 EINE TAX_COUNTRY T005 Countries MANDT
1 EINE TAX_COUNTRY T005 Countries LAND1
0 EINE TRANSPORT_CHAIN WRF_PSCD_TCHAINH Transportation Chain, Header MANDT
0 EINE TRANSPORT_CHAIN WRF_PSCD_TCHAINH Transportation Chain, Header TC_ID
1 EINE VERID MKAL Production Versions of Material WERKS
1 EINE VERID MKAL Production Versions of Material VERID
0 EINE WAERS TCURC Currency Codes MANDT
0 EINE WAERS TCURC Currency Codes WAERS
1 EINE WERKS T001W Plants/Branches MANDT
1 EINE WERKS T001W Plants/Branches WERKS