SAP table LFM1 (Vendor master record purchasing organization data)

SAP table LFM1 has 3 primary key fields being MANDT,LIFNR,EKORG.

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
LIFNR Vendor's account number CHAR 10 0 LFA1 ELIFN
EKORG Purchasing organization CHAR 4 0 T024E EKORG
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
SPERM Purchasing block at purchasing organization level CHAR 1 0 SPERM_M
LOEVM Deletion Indicator for Supplier at Purchasing Level CHAR 1 0 LOEVM_M
LFABC ABC indicator CHAR 1 0 LFABC
WAERS Purchase order currency CUKY 5 0 TCURC BSTWA
VERKF Responsible Salesperson at Supplier's Office CHAR 30 0 EVERK
TELF1 Supplier's Telephone Number CHAR 16 0 TELFE
MINBW Minimum order value CURR 13 2 MINBW
ZTERM Terms of payment key CHAR 4 0 DZTERM
INCO1 Incoterms (Part 1) CHAR 3 0 TINC INCO1
INCO2 Incoterms (Part 2) CHAR 28 0 INCO2
WEBRE Indicator: GR-Based Invoice Verification CHAR 1 0 WEBRE
KZABS Order Acknowledgment Requirement CHAR 1 0 KZABS
KALSK Group for Calculation Schema (Supplier) CHAR 2 0 TMKK KALSK
KZAUT Automatic Generation of Purchase Order Allowed CHAR 1 0 KZAUT
EXPVZ Mode of Transport at the Border (Intrastat) CHAR 1 0 T618 EXPVZ
ZOLLA Customs Office: Office of Exit/Entry for Foreign Trade CHAR 6 0 T615 DZOLLS
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
EKGRP Purchasing Group CHAR 3 0 T024 EKGRP
XERSY Evaluated Receipt Settlement (ERS) CHAR 1 0 XERSY
PLIFZ Planned Delivery Time in Days DEC 3 0 PLIFZ
MRPPP Planning Calendar CHAR 3 0 T439G MRPPP_W
LFRHY Planning Cycle CHAR 3 0 T439G LFRHY
LIBES Order entry by supplier CHAR 1 0 LIBES
LIPRE Price marking, supplier CHAR 2 0 TWYAZ LIPRE
LISER Rack-jobbing: supplier CHAR 1 0 LISER
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
WEORA Acceptance At Origin CHAR 1 0 WEORA
PRFRE Indicator: "relev. to price determination (vend. hierarchy) CHAR 1 0 PRFRE_LH
NRGEW Indicator whether discount in kind granted CHAR 1 0 NRGEW
BOIND Indicator: index compilation for subseq. settlement active CHAR 1 0 BOIND
BLIND Indicator: Doc. index compilation active for purchase orders CHAR 1 0 BLIND
KZRET Indicates whether supplier is returns supplier CHAR 1 0 KZRET
SKRIT Supplier sort criterion for materials CHAR 1 0 SKRIT
By VSR sequence number
A By EAN
B By material number
C By supplier material number
D By material group
BSTAE Confirmation Control Key CHAR 4 0 T163L BSTAE
RDPRF Rounding Profile CHAR 4 0 RDPR RDPRF
MEGRU Unit of Measure Group CHAR 4 0 TWMEG MEGRU
VENSL Supplier Service Level DEC 4 1 VENSL
BOPNR Restriction Profile for PO-Based Load Building CHAR 4 0 TWBO1 BOPNR
XERSR Automatic evaluated receipt settlement for return items CHAR 1 0 XERSR
EIKTO Our account number with the supplier CHAR 12 0 EIKTO_M
ABUEB Release Creation Profile CHAR 4 0 ABUEB
PAPRF Profile for transferring material data via IDoc PROACT CHAR 4 0 TWVMO WVMI_PAPRF
AGREL Indicator: Relevant for Settlement Management CHAR 1 0 AGREL
XNBWY Revaluation allowed CHAR 1 0 XNBWY
VSBED Shipping Conditions CHAR 2 0 TVSB VSBED
LEBRE Indicator for Service-Based Invoice Verification CHAR 1 0 LEBRE
BOLRE Indicator: supplier subject to subseq. settlement accounting CHAR 1 0 BOLRE
UMSAE Comparison/agreement of business volumes necessary CHAR 1 0 UMSAE
VENDOR_RMA_REQ Supplier RMA Number Required CHAR 1 0 MSR_VRMA_REQ_LFM1
Supplier RMA Not Required
X Supplier RMA Required
INCO2_KEY Incoterm Location 1 - Place of Destination RAW 16 0 /SCMTMS/INC_LOC_1_KEY
INCO3_KEY Incoterm Location 2 - Place of Delivery RAW 16 0 /SCMTMS/INC_LOC_2_KEY
INCO4_KEY Incoterm - Deviating Place of Destination RAW 16 0 /SCMTMS/INC_DEV_PLACE_DEST_KEY
LFM1_EEW_PS Data Element Extensibility for purchase CHAR 1 0 LFM1_EEW_PS
J_1NBOESL Exchange Key for NF Processing CHAR 3 0 /NFM/TBOESL /NFM/BOESL
AUBEL Automatic debit creation on goods issue CHAR 1 0 AUBEL
VALID_PRO Settlement profile for automatic evaluated receipt settlemnt CHAR 4 0 CVALID VALID_PRO
HSCABS Absolute handling surcharge CURR 13 2 HSCABS
HSCPE Percentage handling surcharge DEC 5 2 HSCPE
HSCMIN Minimum handling surcharge CURR 13 2 HSCMIN
HSCMAX Maximum handling surcharge CURR 13 2 HSCMAX
FSH_SC_CID Customer/Supplier Identifier CHAR 2 0 FSH_SC_VCIDS FSH_SC_CID
FSH_VAS_DETC VAS Determination Mode CHAR 1 0 FSH_VAS_DETC
No Determination
1 Determination and No VAS Item Generation
2 Determination and VAS Item Generation on Save
3 Determination and Instant VAS Item Generation
UPPRS Pricing on Subitems (MPN/SUS) CHAR 1 0 UPPRS
Individual pricing
A Copying of main item to sub-items
B Price comparison between main item and sub-item
ACTIVITY_PROFIL Activity Profile for PO Controlling CHAR 4 0 WRFT_ACT_PROF WRF_PCTR_ACT_PROF
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

LFM1 foreign key relationships

Table Field Check Table Check Field
0 LFM1 ACTIVITY_PROFIL WRFT_ACT_PROF Activity Profile MANDT
0 LFM1 ACTIVITY_PROFIL WRFT_ACT_PROF Activity Profile ACT_PROF
1 LFM1 BOPNR TWBO1 Customizing table for opt. PO-based load building profiles MANDT
1 LFM1 BOPNR TWBO1 Customizing table for opt. PO-based load building profiles BOPNR
1 LFM1 BOPNR TWBO1 Customizing table for opt. PO-based load building profiles BORESTRI
0 LFM1 BSTAE T163L Confirmation Control Keys BSTAE
1 LFM1 EKGRP T024 Purchasing Groups EKGRP
0 LFM1 EKORG T024E Purchasing Organizations EKORG
1 LFM1 EXPVZ T618 Mode of Transport at the Border LAND1
0 LFM1 FSH_SC_CID FSH_SC_VCIDS Customer- & material-IDs MANDT
0 LFM1 FSH_SC_CID FSH_SC_VCIDS Customer- & material-IDs FSH_SC_IDT
0 LFM1 FSH_SC_CID FSH_SC_VCIDS Customer- & material-IDs FSH_SC_ID
1 LFM1 INCO1 TINC Customers: Incoterms INCO1
0 LFM1 INCOV TINCV Incoterms Versions MANDT
0 LFM1 INCOV TINCV Incoterms Versions INCOV
1 LFM1 KALSK TMKK Group for Calculation Schema (Supplier) MANDT
1 LFM1 KALSK TMKK Group for Calculation Schema (Supplier) KALSK
0 LFM1 LFRHY T439G PP Planning periods: header table MANDT
0 LFM1 LFRHY T439G PP Planning periods: header table WERKS
1 LFM1 LIFNR LFA1 Supplier Master (General Section) MANDT
1 LFM1 LIFNR LFA1 Supplier Master (General Section) LIFNR
0 LFM1 LIPRE TWYAZ Price Marking Agreement MANDT
0 LFM1 LIPRE TWYAZ Price Marking Agreement LIPRE
1 LFM1 MANDT T000 Clients MANDT
0 LFM1 MEGRU TWMEG Unit of measure group MANDT
0 LFM1 MEGRU TWMEG Unit of measure group MEGRU
0 LFM1 MEGRU TWMEG Unit of measure group MEINS
1 LFM1 MRPPP T439G PP Planning periods: header table MANDT
1 LFM1 MRPPP T439G PP Planning periods: header table WERKS
0 LFM1 PAPRF TWVMO Control profiles for transferring material data to vendor MANDT
0 LFM1 PAPRF TWVMO Control profiles for transferring material data to vendor PAPRF
1 LFM1 RDPRF RDPR Rounding profile MANDT
1 LFM1 RDPRF RDPR Rounding profile WERKS
1 LFM1 RDPRF RDPR Rounding profile RDPRF
1 LFM1 RDPRF RDPR Rounding profile RDZAE
0 LFM1 TRANSPORT_CHAIN WRF_PSCD_TCHAINH Transportation Chain, Header MANDT
0 LFM1 TRANSPORT_CHAIN WRF_PSCD_TCHAINH Transportation Chain, Header TC_ID
1 LFM1 VALID_PRO CVALID Settlement profile for automatic ERS EKORG
0 LFM1 VSBED TVSB Shipping Conditions MANDT
0 LFM1 VSBED TVSB Shipping Conditions VSBED
1 LFM1 WAERS TCURC Currency Codes MANDT
1 LFM1 WAERS TCURC Currency Codes WAERS
0 LFM1 ZOLLA T615 Foreign Trade: Customs Offices LAND1
0 LFM1 ZOLLA T615 Foreign Trade: Customs Offices ZOLLA