SAP table EIPA (Order Price History: Info Record)

SAP table EIPA has 4 primary key fields being MANDT,INFNR,EBELN,EBELP.

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
EBELN Purchasing Document Number CHAR 10 0 EKKO EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EKPO EBELP
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
EKORG Purchasing organization CHAR 4 0 T024E EKORG
BEDAT Purchase Order Date DATS 8 0 BEDAT
PREIS Net Price in Purchasing Document (in Document Currency) CURR 11 2 BPREI
PEINH Price unit DEC 5 0 EPEIN
BPRME Order Price Unit (Purchasing) UNIT 3 0 T006 BBPRM
BWAER Currency Key CUKY 5 0 TCURC WAERS
LPREI Price CURR 11 2 PREIS
LPEIN Price unit DEC 5 0 EPEIN
LMEIN Base Unit of Measure UNIT 3 0 T006 MEINS
LWAER Currency Key CUKY 5 0 TCURC WAERS
MENGE Quantity QUAN 13 3 MENGE_D

EIPA foreign key relationships

Table Field Check Table Check Field
0 EIPA BPRME T006 Units of Measurement MANDT
1 EIPA BWAER TCURC Currency Codes MANDT
1 EIPA BWAER TCURC Currency Codes WAERS
0 EIPA EBELN EKKO Purchasing Document Header EBELN
1 EIPA EBELP EKPO Purchasing Document Item MANDT
1 EIPA EBELP EKPO Purchasing Document Item EBELN
0 EIPA EKORG T024E Purchasing Organizations EKORG
1 EIPA INFNR EINA Purchasing Info Record: General Data INFNR
0 EIPA LMEIN T006 Units of Measurement MANDT
0 EIPA LMEIN T006 Units of Measurement MSEHI
1 EIPA LWAER TCURC Currency Codes MANDT
1 EIPA LWAER TCURC Currency Codes WAERS
0 EIPA MANDT T000 Clients MANDT
1 EIPA WERKS T001W Plants/Branches WERKS