SAP Table LFM1

Vendor master record purchasing organization data

LFM1 (Vendor master record purchasing organization data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link LFM1 to other SAP tables.

LFM1 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
LIFNR Vendor Account Number ELIFN LFA1 CHAR 10 0
EKORG Purchasing Organization EKORG T024E CHAR 4 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
SPERM Purchasing block at purchasing organization level SPERM_M CHAR 1 0
X Yes
NULL No
LOEVM Delete flag for vendor at purchasing level LOEVM_M CHAR 1 0
X Yes
NULL No
LFABC ABC indicator LFABC CHAR 1 0
WAERS Purchase order currency BSTWA TCURC CUKY 5 0
VERKF Responsible Salesperson at Vendor's Office EVERK CHAR 30 0
TELF1 Vendor's telephone number TELFE CHAR 16 0
MINBW Minimum order value MINBW CURR 13 2
ZTERM Terms of Payment Key DZTERM CHAR 4 0
INCO1 Incoterms (Part 1) INCO1 TINC CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
WEBRE Indicator: GR-Based Invoice Verification WEBRE CHAR 1 0
X Yes
NULL No
KZABS Order Acknowledgment Requirement KZABS CHAR 1 0
X Yes
NULL No
KALSK Group for Calculation Schema (Vendor) KALSK TMKK CHAR 2 0
KZAUT Automatic Generation of Purchase Order Allowed KZAUT CHAR 1 0
X Yes
NULL No
EXPVZ Mode of Transport for Foreign Trade EXPVZ T618 CHAR 1 0
ZOLLA Customs Office: Office of Exit/Entry for Foreign Trade DZOLLS T615 CHAR 6 0
MEPRF Price Determination (Pricing) Date Control MEPRF CHAR 1 0
NULL No Control
1 Purchase Order Date
2 Delivery Date
3 Current Date
4 Manual
5 GR Date
EKGRP Purchasing Group EKGRP T024 CHAR 3 0
XERSY Evaluated Receipt Settlement (ERS) XERSY CHAR 1 0
X Yes
NULL No
PLIFZ Planned Delivery Time in Days PLIFZ DEC 3 0
MRPPP Planning calendar MRPPP_W T439G CHAR 3 0
LFRHY Planning cycle LFRHY T439G CHAR 3 0
LIBES Order entry by vendor LIBES CHAR 1 0
LIPRE Price marking, vendor LIPRE TWYAZ CHAR 2 0
LISER Rack-jobbing: vendor LISER CHAR 1 0
PRFRE Indicator: "relev. to price determination (vend. hierarchy) PRFRE_LH CHAR 1 0
X Yes
NULL No
NRGEW Indicator whether discount in kind granted NRGEW CHAR 1 0
BOIND Indicator: index compilation for subseq. settlement active BOIND CHAR 1 0
X Yes
NULL No
BLIND Indicator: Doc. index compilation active for purchase orders BLIND CHAR 1 0
X Yes
NULL No
KZRET Indicates whether vendor is returns vendor KZRET CHAR 1 0
X Yes
NULL No
SKRIT Vendor sort criterion for materials SKRIT CHAR 1 0
NULL By VSR sequence number
A By EAN
B By material number
C By vendor material number
D By material group
BSTAE Confirmation Control Key BSTAE T163L CHAR 4 0
RDPRF Rounding Profile RDPRF RDPR CHAR 4 0
MEGRU Unit of Measure Group MEGRU TWMEG CHAR 4 0
VENSL Vendor service level VENSL DEC 4 1
BOPNR Restriction Profile for PO-Based Load Building BOPNR TWBO1 CHAR 4 0
XERSR Automatic evaluated receipt settlement for return items XERSR CHAR 1 0
X Yes
NULL No
EIKTO Our account number with the vendor EIKTO_M CHAR 12 0
ABUEB Release Creation Profile ABUEB CHAR 4 0
PAPRF Profile for transferring material data via IDoc PROACT WVMI_PAPRF TWVMO CHAR 4 0
AGREL Indicator: Relevant for agency business AGREL CHAR 1 0
X Yes
NULL No
XNBWY Revaluation allowed XNBWY CHAR 1 0
X Yes
NULL No
VSBED Shipping Conditions VSBED TVSB CHAR 2 0
LEBRE Indicator for Service-Based Invoice Verification LEBRE CHAR 1 0
X Yes
NULL No
BOLRE Indicator: vendor subject to subseq. settlement accounting BOLRE CHAR 1 0
X Yes
NULL No
UMSAE Comparison/agreement of business volumes necessary UMSAE CHAR 1 0
X Yes
NULL No
VENDOR_RMA_REQ Vendor RMA Number Required MSR_VRMA_REQ_LFM1 CHAR 1 0
NULL Vendor RMA Not Required
X Vendor RMA Required
OIHANTYP Excise Duty Handling Type OIH_HANTYP OIH5 CHAR 2 0
OIA_SPLTIV Indicator for split invoice verification OIA_SPLTIV CHAR 1 0
NULL No split invoice verification
X Split invoice verification
OIHVGROUP Vendor group (refinery/mill/other) OIH_J1B_VTXGR OIH2V_J1B CHAR 4 0
OIMATCYC Invoice cycle OIA_INVCYC NUMC 1 0
ACTIVITY_PROFIL Activity Profile for PO Controlling WRF_PCTR_ACT_PROF WRFT_ACT_PROF CHAR 4 0
TRANSPORT_CHAIN Transportation Chain WRF_PSCD_TC_ID WRF_PSCD_TCHAINH CHAR 10 0
STAGING_TIME Staging Time in Days WRF_PSCD_MST DEC 3 0

LFM1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
LFM1 ACTIVITY_PROFIL SYST MANDT WRFT_ACT_PROF Activity Profile MANDT
LFM1 ACTIVITY_PROFIL LFM1 ACTIVITY_PROFIL WRFT_ACT_PROF Activity Profile ACT_PROF
LFM1 BOPNR * TWBO1 Customizing table for opt. PO-based load building profiles BOTYPI
LFM1 BOPNR LFM1 MANDT TWBO1 Customizing table for opt. PO-based load building profiles MANDT
LFM1 BOPNR LFM1 BOPNR TWBO1 Customizing table for opt. PO-based load building profiles BOPNR
LFM1 BOPNR * TWBO1 Customizing table for opt. PO-based load building profiles BORESTRI
LFM1 BSTAE LFM1 MANDT T163L Confirmation Control Keys MANDT
LFM1 BSTAE LFM1 BSTAE T163L Confirmation Control Keys BSTAE
LFM1 EKGRP SYST MANDT T024 Purchasing Groups MANDT
LFM1 EKGRP LFM1 EKGRP T024 Purchasing Groups EKGRP
LFM1 EKORG LFM1 EKORG T024E Purchasing Organizations EKORG
LFM1 EKORG LFM1 MANDT T024E Purchasing Organizations MANDT
LFM1 EXPVZ SYST MANDT T618 Foreign Trade: Modes of Transport MANDT
LFM1 EXPVZ *T001 LAND1 T618 Foreign Trade: Modes of Transport LAND1
LFM1 EXPVZ LFM1 EXPVZ T618 Foreign Trade: Modes of Transport EXPVZ
LFM1 INCO1 SYST MANDT TINC Customers: Incoterms MANDT
LFM1 INCO1 LFM1 INCO1 TINC Customers: Incoterms INCO1
LFM1 KALSK SYST MANDT TMKK Group for Calculation Schema (Vendor) MANDT
LFM1 KALSK LFM1 KALSK TMKK Group for Calculation Schema (Vendor) KALSK
LFM1 LFRHY LFM1 LFRHY T439G PPplanning periods: header table MRPPP
LFM1 LFRHY SYST MANDT T439G PPplanning periods: header table MANDT
LFM1 LFRHY LFM2 WERKS T439G PPplanning periods: header table WERKS
LFM1 LIFNR LFM1 MANDT LFA1 Vendor Master (General Section) MANDT
LFM1 LIFNR LFM1 LIFNR LFA1 Vendor Master (General Section) LIFNR
LFM1 LIPRE SYST MANDT TWYAZ Price Marking Agreement MANDT
LFM1 LIPRE LFM1 LIPRE TWYAZ Price Marking Agreement LIPRE
LFM1 MANDT LFM1 MANDT T000 Clients MANDT
LFM1 MEGRU LFM1 MANDT TWMEG Unit of measure group MANDT
LFM1 MEGRU LFM1 MEGRU TWMEG Unit of measure group MEGRU
LFM1 MEGRU * TWMEG Unit of measure group MEINS
LFM1 MRPPP SYST MANDT T439G PPplanning periods: header table MANDT
LFM1 MRPPP LFM2 WERKS T439G PPplanning periods: header table WERKS
LFM1 MRPPP LFM1 MRPPP T439G PPplanning periods: header table MRPPP
LFM1 OIHANTYP LFM1 MANDT OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) MANDT
LFM1 OIHANTYP LFM1 OIHANTYP OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) HANTYP
LFM1 OIHVGROUP LFM1 OIHVGROUP OIH2V_J1B Check table for vendor tax group OIHVTXGR
LFM1 OIHVGROUP SYST MANDT OIH2V_J1B Check table for vendor tax group MANDT
LFM1 PAPRF LFM1 MANDT TWVMO Control profiles for transferring material data to vendor MANDT
LFM1 PAPRF LFM1 PAPRF TWVMO Control profiles for transferring material data to vendor PAPRF
LFM1 RDPRF LFM1 RDPRF RDPR Rounding profile RDPRF
LFM1 RDPRF * RDPR Rounding profile RDZAE
LFM1 RDPRF LFM1 MANDT RDPR Rounding profile MANDT
LFM1 RDPRF * RDPR Rounding profile WERKS
LFM1 TRANSPORT_CHAIN LFM1 TRANSPORT_CHAIN WRF_PSCD_TCHAINH Transportation Chain, Header TC_ID
LFM1 TRANSPORT_CHAIN * WRF_PSCD_TCHAINH Transportation Chain, Header TC_MODE
LFM1 TRANSPORT_CHAIN SYST MANDT WRF_PSCD_TCHAINH Transportation Chain, Header MANDT
LFM1 VSBED LFM1 MANDT TVSB Shipping Conditions MANDT
LFM1 VSBED LFM1 VSBED TVSB Shipping Conditions VSBED
LFM1 WAERS LFM1 WAERS TCURC Currency Codes WAERS
LFM1 WAERS SYST MANDT TCURC Currency Codes MANDT
LFM1 ZOLLA *T001 LAND1 T615 Foreign Trade: Customs Offices LAND1
LFM1 ZOLLA LFM1 ZOLLA T615 Foreign Trade: Customs Offices ZOLLA
LFM1 ZOLLA SYST MANDT T615 Foreign Trade: Customs Offices MANDT