SAP table LFMH (Vendor hierarchy)

SAP table LFMH has 5 primary key fields being MANDT,HITYP,LIFNR,EKORG,DATAB.

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
HITYP Hierarchy Category: Supplier Hierarchy CHAR 1 0 TLHIT HITYP_LH
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
EKORG Purchasing organization CHAR 4 0 T024E EKORG
DATAB Start of validity period for assignment DATS 8 0 DATAB_KH
DATBI End of validity period for the assignment DATS 8 0 DATBI_KH
HLIFNR Vendor number of higher-level vendor hierarchy CHAR 10 0 LFA1 HLIFNR_LH
HEKORG Higher-level purchasing organization CHAR 4 0 T024E HEKORG
GRPNO Number of the Routine Used for Copying NUMC 3 0 GRPNO
BOLRE Indicator: supplier subject to subseq. settlement accounting CHAR 1 0 BOLRE
PRFRE Indicator: "relev. to price determination (vend. hierarchy) CHAR 1 0 PRFRE_LH
HZUOR Assignment to Hierarchy NUMC 2 0 HZUOR

LFMH foreign key relationships

Table Field Check Table Check Field
0 LFMH EKORG T024E Purchasing Organizations EKORG
1 LFMH HEKORG T024E Purchasing Organizations EKORG
0 LFMH HITYP TLHIT Vendor Hierarchy Category MANDT
1 LFMH HLIFNR LFA1 Supplier Master (General Section) MANDT
1 LFMH HLIFNR LFA1 Supplier Master (General Section) LIFNR
0 LFMH LIFNR LFA1 Supplier Master (General Section) MANDT
0 LFMH LIFNR LFA1 Supplier Master (General Section) LIFNR
1 LFMH MANDT T000 Clients MANDT