SAP table BIW_LFM1_S (Provider Structure for Vendor Master Data from LFM1)
SAP table BIW_LFM1_S 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
*
MANDT
LIFNR
Vendor's account number
CHAR
10
0
*
ELIFN
EKORG
Purchasing organization
CHAR
4
0
*
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
*
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
*
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
*
KALSK
KZAUT
Automatic Generation of Purchase Order Allowed
CHAR
1
0
KZAUT
EXPVZ
Mode of Transport at the Border (Intrastat)
CHAR
1
0
*
EXPVZ
ZOLLA
Customs Office: Office of Exit/Entry for Foreign Trade
CHAR
6
0
*
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
*
EKGRP
BOLRE
Indicator: supplier subject to subseq. settlement accounting
CHAR
1
0
BOLRE
UMSAE
Comparison/agreement of business volumes necessary
CHAR
1
0
UMSAE
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
*
MRPPP_W
LFRHY
Planning Cycle
CHAR
3
0
*
LFRHY
LIBES
Order entry by supplier
CHAR
1
0
LIBES
LIPRE
Price marking, supplier
CHAR
2
0
*
LIPRE
LISER
Rack-jobbing: supplier
CHAR
1
0
LISER
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
*
BSTAE
RDPRF
Rounding Profile
CHAR
4
0
*
RDPRF
MEGRU
Unit of Measure Group
CHAR
4
0
*
MEGRU
VENSL
Supplier Service Level
DEC
4
1
VENSL
BOPNR
Restriction Profile for PO-Based Load Building
CHAR
4
0
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