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 | Possible values | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
LOEVM
Delete flag for vendor at purchasing level
|
LOEVM_M |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
KZABS
Order Acknowledgment Requirement
|
KZABS |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
KALSK
Group for Calculation Schema (Vendor)
|
KALSK | TMKK |
CHAR
|
2 | 0 | |||||||||||||||
|
KZAUT
Automatic Generation of Purchase Order Allowed
|
KZAUT |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
EKGRP
Purchasing Group
|
EKGRP | T024 |
CHAR
|
3 | 0 | |||||||||||||||
|
XERSY
Evaluated Receipt Settlement (ERS)
|
XERSY |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
NRGEW
Indicator whether discount in kind granted
|
NRGEW |
CHAR
|
1 | 0 | ||||||||||||||||
|
BOIND
Indicator: index compilation for subseq. settlement active
|
BOIND |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
BLIND
Indicator: Doc. index compilation active for purchase orders
|
BLIND |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
KZRET
Indicates whether vendor is returns vendor
|
KZRET |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
SKRIT
Vendor sort criterion for materials
|
SKRIT |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
XNBWY
Revaluation allowed
|
XNBWY |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
VSBED
Shipping Conditions
|
VSBED | TVSB |
CHAR
|
2 | 0 | |||||||||||||||
|
LEBRE
Indicator for Service-Based Invoice Verification
|
LEBRE |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
BOLRE
Indicator: vendor subject to subseq. settlement accounting
|
BOLRE |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
UMSAE
Comparison/agreement of business volumes necessary
|
UMSAE |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
VENDOR_RMA_REQ
Vendor RMA Number Required
|
MSR_VRMA_REQ_LFM1 |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
OIHANTYP
Excise Duty Handling Type
|
OIH_HANTYP | OIH5 |
CHAR
|
2 | 0 | |||||||||||||||
|
OIA_SPLTIV
Indicator for split invoice verification
|
OIA_SPLTIV |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | 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 | 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 | BSTAE | LFM1 | BSTAE |
T163L
Confirmation Control Keys
|
BSTAE |
| LFM1 | BSTAE | LFM1 | MANDT |
T163L
Confirmation Control Keys
|
MANDT |
| LFM1 | EKGRP | SYST | MANDT |
T024
Purchasing Groups
|
MANDT |
| LFM1 | EKGRP | LFM1 | EKGRP |
T024
Purchasing Groups
|
EKGRP |
| LFM1 | EKORG | LFM1 | MANDT |
T024E
Purchasing Organizations
|
MANDT |
| LFM1 | EKORG | LFM1 | EKORG |
T024E
Purchasing Organizations
|
EKORG |
| LFM1 | EXPVZ | *T001 | LAND1 |
T618
Foreign Trade: Modes of Transport
|
LAND1 |
| LFM1 | EXPVZ | LFM1 | EXPVZ |
T618
Foreign Trade: Modes of Transport
|
EXPVZ |
| LFM1 | EXPVZ | SYST | MANDT |
T618
Foreign Trade: Modes of Transport
|
MANDT |
| LFM1 | INCO1 | LFM1 | INCO1 |
TINC
Customers: Incoterms
|
INCO1 |
| LFM1 | INCO1 | SYST | MANDT |
TINC
Customers: Incoterms
|
MANDT |
| LFM1 | KALSK | SYST | MANDT |
TMKK
Group for Calculation Schema (Vendor)
|
MANDT |
| LFM1 | KALSK | LFM1 | KALSK |
TMKK
Group for Calculation Schema (Vendor)
|
KALSK |
| LFM1 | LFRHY | SYST | MANDT |
T439G
PPplanning periods: header table
|
MANDT |
| LFM1 | LFRHY | LFM2 | WERKS |
T439G
PPplanning periods: header table
|
WERKS |
| LFM1 | LFRHY | LFM1 | LFRHY |
T439G
PPplanning periods: header table
|
MRPPP |
| 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 | * |
TWMEG
Unit of measure group
|
MEINS | |
| LFM1 | MEGRU | LFM1 | MANDT |
TWMEG
Unit of measure group
|
MANDT |
| LFM1 | MEGRU | LFM1 | MEGRU |
TWMEG
Unit of measure group
|
MEGRU |
| LFM1 | MRPPP | LFM1 | MRPPP |
T439G
PPplanning periods: header table
|
MRPPP |
| LFM1 | MRPPP | SYST | MANDT |
T439G
PPplanning periods: header table
|
MANDT |
| LFM1 | MRPPP | LFM2 | WERKS |
T439G
PPplanning periods: header table
|
WERKS |
| 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 | SYST | MANDT |
OIH2V_J1B
Check table for vendor tax group
|
MANDT |
| LFM1 | OIHVGROUP | LFM1 | OIHVGROUP |
OIH2V_J1B
Check table for vendor tax group
|
OIHVTXGR |
| 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 | MANDT |
RDPR
Rounding profile
|
MANDT |
| LFM1 | RDPRF | * |
RDPR
Rounding profile
|
WERKS | |
| LFM1 | RDPRF | LFM1 | RDPRF |
RDPR
Rounding profile
|
RDPRF |
| LFM1 | RDPRF | * |
RDPR
Rounding profile
|
RDZAE | |
| LFM1 | TRANSPORT_CHAIN | SYST | MANDT |
WRF_PSCD_TCHAINH
Transportation Chain, Header
|
MANDT |
| 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 | VSBED | LFM1 | MANDT |
TVSB
Shipping Conditions
|
MANDT |
| LFM1 | VSBED | LFM1 | VSBED |
TVSB
Shipping Conditions
|
VSBED |
| LFM1 | WAERS | SYST | MANDT |
TCURC
Currency Codes
|
MANDT |
| LFM1 | WAERS | LFM1 | WAERS |
TCURC
Currency Codes
|
WAERS |
| LFM1 | ZOLLA | SYST | MANDT |
T615
Foreign Trade: Customs Offices
|
MANDT |
| LFM1 | ZOLLA | *T001 | LAND1 |
T615
Foreign Trade: Customs Offices
|
LAND1 |
| LFM1 | ZOLLA | LFM1 | ZOLLA |
T615
Foreign Trade: Customs Offices
|
ZOLLA |