SAP table BIW_LFA1_S (Provider Structure: Vendor Master Data from LFA1)
SAP table BIW_LFA1_S has 2 primary key fields being MANDT,LIFNR.
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
Account Number of Supplier
CHAR
10
0
LIFNR
ANRED
Title
CHAR
15
0
ANRED
BAHNS
Train station
CHAR
25
0
BAHNS
BBBNR
International location number (part 1)
NUMC
7
0
BBBNR
BBSNR
International location number (Part 2)
NUMC
5
0
BBSNR
BEGRU
Authorization Group
CHAR
4
0
BRGRU
BRSCH
Industry key
CHAR
4
0
BRSCH
BUBKZ
Check digit for the international location number
NUMC
1
0
BUBKZ
DATLT
Data communication line no.
CHAR
14
0
DATLT
DTAMS
Report key for data medium exchange
CHAR
1
0
DTAMS
Use house bank default value
0
Single data record can be forwarded to the Bundesbank
1
Single data record not to be forwarded to the Bundesbank
DTAWS
Instruction Key for Data Medium Exchange
CHAR
2
0
DTAWS
ERDAT
Date on which the Record Was Created
DATS
8
0
ERDAT_RF
ERNAM
Name of Person who Created the Object
CHAR
12
0
ERNAM_RF
ESRNR
ISR subscriber number
CHAR
11
0
ESRNR
KONZS
Group key
CHAR
10
0
KONZS
KTOKK
Vendor account group
CHAR
4
0
KTOKK
KUNNR
Customer Number
CHAR
10
0
KUNNR
LAND1
Country/Region Key
CHAR
3
0
LAND1_GP
LNRZA
Account Number of the Alternative Payee
CHAR
10
0
LNRZA
LOEVM
Central Deletion Flag for Master Record
CHAR
1
0
LOEVM_X
NAME1
Name 1
CHAR
35
0
NAME1_GP
NAME2
Name 2
CHAR
35
0
NAME2_GP
NAME3
Name 3
CHAR
35
0
NAME3_GP
NAME4
Name 4
CHAR
35
0
NAME4_GP
ORT01
City
CHAR
35
0
ORT01_GP
ORT02
District
CHAR
35
0
ORT02_GP
PFACH
PO Box
CHAR
10
0
PFACH
PSTL2
P.O. Box Postal Code
CHAR
10
0
PSTL2
PSTLZ
Postal Code
CHAR
10
0
PSTLZ
REGIO
Region (State, Province, County)
CHAR
3
0
REGIO
SORTL
Sort field
CHAR
10
0
SORTL
SPERR
Central posting block
CHAR
1
0
SPERB_X
SPERM
Centrally imposed purchasing block
CHAR
1
0
SPERM_X
SPRAS
Language Key
LANG
1
0
SPRAS
STCD1
Tax Number 1
CHAR
16
0
STCD1
STCD2
Tax Number 2
CHAR
11
0
STCD2
STCD3
Tax Number 3
CHAR
18
0
STCD3
STKZA
Indicator: Business Partner Subject to Equalization Tax?
CHAR
1
0
STKZA
Not subject to equalization tax
X
Subject to equalization tax
STKZU
Liable for VAT
CHAR
1
0
STKZU
STRAS
Street and House Number
CHAR
35
0
STRAS_GP
TELBX
Telebox number
CHAR
15
0
TELBX
TELF1
First telephone number
CHAR
16
0
TELF1
TELF2
Second telephone number
CHAR
16
0
TELF2
TELFX
Fax Number
CHAR
31
0
TELFX
TELTX
Teletex number
CHAR
30
0
TELTX
TELX1
Telex number
CHAR
30
0
TELX1
XCPDK
Indicator: Is the account a one-time account?
CHAR
1
0
XCPDK
XZEMP
Indicator: Alternative Payee in Document Allowed?
CHAR
1
0
XZEMP
VBUND
Company ID of Trading Partner
CHAR
6
0
RASSC
FISKN
Account number of the master record with fiscal address
CHAR
10
0
FISKN_K
STCEG
VAT Registration Number
CHAR
20
0
STCEG
STKZN
Natural Person
CHAR
1
0
STKZN
Legal person
X
Natural person
SPERQ
Function That Will Be Blocked
CHAR
2
0
QSPERRFKT
MCOD1
Search term for matchcode search
CHAR
25
0
MCDK1
MCOD2
Search term for matchcode search
CHAR
25
0
MCDK2
MCOD3
Search term for matchcode search
CHAR
25
0
MCDK3
GBORT
Place of birth of the person subject to withholding tax
CHAR
25
0
GBORT_Q
GBDAT
Date of Birth of the Person Subject to Withholding Tax
DATS
8
0
GBDAT_Q
SEXKZ
Key for the Sex of the Person Subject to Withholding Tax
CHAR
1
0
SEXKZ
Gender Not Known
1
Male
2
Female
KRAUS
Credit Information Number
CHAR
11
0
KRAUS_CM
REVDB
Last External Review
DATS
8
0
REVDB_CM
QSSYS
Supplier's QM System
CHAR
4
0
QSSYS_IST
KTOCK
Reference Account Group for One-Time Account (Vendor)
CHAR
4
0
KTOCK
PFORT
PO Box city
CHAR
35
0
PFORT_GP
WERKS
Plant
CHAR
4
0
WERKS_D
LTSNA
Indicator: vendor sub-range relevant
CHAR
1
0
LTSNA
WERKR
Indicator: plant level relevant
CHAR
1
0
WERKR
PLKAL
Factory calendar key
CHAR
2
0
FABKL
TXJCD
Tax Jurisdiction
CHAR
15
0
TXJCD
SPERZ
Payment Block
CHAR
1
0
SPERZ
ADRNR
Address
CHAR
10
0
ADRNR
STCD4
Tax Number 4
CHAR
18
0
STCD4
STCD5
Tax Number 5
CHAR
60
0
STCD5
SAM_UE_ID
System for Award Management Unique Entity Identifier
CHAR
12
0
FMFG_UNIQUE_ENTITY_ID
SAM_EFT_IND
System for Award Management Electronic Funds Transfer Ind