Follow us on LinkedIn for your next SAP project

SAP Table LFA1

Vendor Master (General Section)

LFA1 (Vendor Master (General Section)) 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 LFA1 to other SAP tables.

LFA1 table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
MANDT T000
CLNT
3 0
LIFNR
Account Number of Vendor or Creditor
LIFNR
CHAR
10 0
LAND1
Country Key
LAND1_GP T005
CHAR
3 0
NAME1
Name 1
NAME1_GP
CHAR
35 0
NAME2
Name 2
NAME2_GP
CHAR
35 0
NAME3
Name 3
NAME3_GP
CHAR
35 0
NAME4
Name 4
NAME4_GP
CHAR
35 0
ORT01
City
ORT01_GP
CHAR
35 0
ORT02
District
ORT02_GP
CHAR
35 0
PFACH
PO Box
PFACH
CHAR
10 0
PSTL2
P.O. Box Postal Code
PSTL2
CHAR
10 0
PSTLZ
Postal Code
PSTLZ
CHAR
10 0
REGIO
Region (State, Province, County)
REGIO T005S
CHAR
3 0
SORTL
Sort field
SORTL
CHAR
10 0
STRAS
House number and street
STRAS_GP
CHAR
35 0
ADRNR
Address
ADRNR
CHAR
10 0
MCOD1
Search term for matchcode search
MCDK1
CHAR
25 0
MCOD2
Search term for matchcode search
MCDK2
CHAR
25 0
MCOD3
Search term for matchcode search
MCDK3
CHAR
25 0
ANRED
Title
ANRED
CHAR
15 0
BAHNS
Train station
BAHNS
CHAR
25 0
BBBNR
International location number (part 1)
BBBNR
NUMC
7 0
BBSNR
International location number (Part 2)
BBSNR
NUMC
5 0
BEGRU
Authorization Group
BRGRU
CHAR
4 0
BRSCH
Industry key
BRSCH T016
CHAR
4 0
BUBKZ
Check digit for the international location number
BUBKZ
NUMC
1 0
DATLT
Data communication line no.
DATLT
CHAR
14 0
DTAMS
Indicator for Data Medium Exchange
DTAMS
CHAR
1 0
DTAWS
Instruction key for data medium exchange
DTAWS
CHAR
2 0
ERDAT
Date on which the Record Was Created
ERDAT_RF
DATS
8 0
ERNAM
Name of Person who Created the Object
ERNAM_RF
CHAR
12 0
ESRNR
ISR Subscriber Number
ESRNR
CHAR
11 0
KONZS
Group key
KONZS
CHAR
10 0
KTOKK
Vendor account group
KTOKK T077K
CHAR
4 0
KUNNR
Customer Number
KUNNR KNA1
CHAR
10 0
LNRZA
Account Number of the Alternative Payee
LNRZA LFA1
CHAR
10 0
LOEVM
Central Deletion Flag for Master Record
LOEVM_X
CHAR
1 0
SPERR
Central posting block
SPERB_X
CHAR
1 0
SPERM
Centrally imposed purchasing block
SPERM_X
CHAR
1 0
SPRAS
Language Key
SPRAS T002
LANG
1 0
STCD1
Tax Number 1
STCD1
CHAR
16 0
STCD2
Tax Number 2
STCD2
CHAR
11 0
STKZA
Indicator: Business Partner Subject to Equalization Tax?
STKZA
CHAR
1 0
STKZU
Liable for VAT
STKZU
CHAR
1 0
TELBX
Telebox number
TELBX
CHAR
15 0
TELF1
First telephone number
TELF1
CHAR
16 0
TELF2
Second telephone number
TELF2
CHAR
16 0
TELFX
Fax Number
TELFX
CHAR
31 0
TELTX
Teletex number
TELTX
CHAR
30 0
TELX1
Telex number
TELX1
CHAR
30 0
XCPDK
Indicator: Is the account a one-time account?
XCPDK
CHAR
1 0
XZEMP
Indicator: Alternative payee in document allowed ?
XZEMP
CHAR
1 0
VBUND
Company ID of trading partner
RASSC T880
CHAR
6 0
FISKN
Account number of the master record with fiscal address
FISKN_K LFA1
CHAR
10 0
STCEG
VAT Registration Number
STCEG
CHAR
20 0
STKZN
Natural Person
STKZN
CHAR
1 0
SPERQ
Function That Will Be Blocked
QSPERRFKT TQ04A
CHAR
2 0
GBORT
Place of birth of the person subject to withholding tax
GBORT_Q
CHAR
25 0
GBDAT
Date of birth of the person subject to withholding tax
GBDAT_Q
DATS
8 0
SEXKZ
Key for the Sex of the Person Subject to Withholding Tax
SEXKZ
CHAR
1 0
KRAUS
Credit information number
KRAUS_CM
CHAR
11 0
REVDB
Last review (external)
REVDB_CM
DATS
8 0
QSSYS
Vendor's QM system
QSSYS_IST TQ02B
CHAR
4 0
KTOCK
Reference Account Group for One-Time Account (Vendor)
KTOCK T077K
CHAR
4 0
PFORT
PO Box city
PFORT_GP
CHAR
35 0
WERKS
Plant (Own or External)
WERKS_EXT
CHAR
4 0
LTSNA
Indicator: vendor sub-range relevant
LTSNA
CHAR
1 0
WERKR
Indicator: plant level relevant
WERKR
CHAR
1 0
PLKAL
Factory calendar key
FABKL TFACD
CHAR
2 0
DUEFL
Status of Data Transfer into Subsequent Release
DUEFL_BKPF
CHAR
1 0
TXJCD
Tax Jurisdiction
TXJCD TTXJ
CHAR
15 0
SPERZ
Payment Block
SPERZ
CHAR
1 0
SCACD
Standard carrier access code
SCACD
CHAR
4 0
SFRGR
Forwarding agent freight group
SFRGR TSFG
CHAR
4 0
LZONE
Transportation zone to or from which the goods are delivered
LZONE TZONE
CHAR
10 0
XLFZA
Indicator: Alternative payee using account number
XLFZA
CHAR
1 0
DLGRP
Service agent procedure group
DLGRP TVFCD
CHAR
4 0
FITYP
Tax type
J_1AFITP_D J_1AFITP
CHAR
2 0
STCDT
Tax Number Type
J_1ATOID J_1ATODC
CHAR
2 0
REGSS
Registered for Social Insurance
J_1AREGSS
CHAR
1 0
ACTSS
Activity Code for Social Insurance
J_1AACTSS J_1AACT
CHAR
3 0
STCD3
Tax Number 3
STCD3
CHAR
18 0
STCD4
Tax Number 4
STCD4
CHAR
18 0
STCD5
Tax Number 5
STCD5
CHAR
60 0
IPISP
Tax Split
J_1BINDEQU
CHAR
1 0
TAXBS
Tax Base in Percentage
TAXBS
NUMC
1 0
PROFS
Profession
PROFS
CHAR
30 0
STGDL
Shipment: statistics group, transportation service agent
STGDL VTSGD
CHAR
2 0
EMNFR
External manufacturer code name or number
EMNFR
CHAR
10 0
LFURL
Uniform Resource Locator
URL
CHAR
132 0
J_1KFREPRE
Name of Representative
REPRES
CHAR
10 0
J_1KFTBUS
Type of Business
GESTYP BUSTYPE
CHAR
30 0
J_1KFTIND
Type of Industry
INDTYP INDUSTYPE
CHAR
30 0
CONFS
Status of Change Authorization (Central)
CONFS_X
CHAR
1 0
UPDAT
Date on Which the Changes Were Confirmed
UPDAT_RF
DATS
8 0
UPTIM
Time of Last Change Confirmation
UPTIM_RF
TIMS
6 0
NODEL
Central deletion block for master record
NODEL_X
CHAR
1 0
QSSYSDAT
Validity date of certification
QQSSYSDAT
DATS
8 0
PODKZB
Vendor indicator relevant for proof of delivery
PODKZB
CHAR
1 0
FISKU
Account Number of Master Record of Tax Office Responsible
FISKU LFA1
CHAR
10 0
STENR
Tax Number at Responsible Tax Authority
STENR
CHAR
18 0
CARRIER_CONF
Carrier confirmation is expected
/SPE/CARRIER_CNF
CHAR
1 0
MIN_COMP
Micro company indicator
J_1BMICRO_COMP
CHAR
1 0
TERM_LI
Terms of Liability
J_1BTERMS_LIAB
CHAR
1 0
CRC_NUM
CRC number
J_1BCRC_NUM
CHAR
25 0
RG
RG Number
J_1BRG
CHAR
11 0
EXP
Issued by
J_1BEXP
CHAR
3 0
UF
State
J_1BUF
CHAR
2 0
RGDATE
RG Issue Date
J_1BRGDATE
DATS
8 0
RIC
RIC Number
J_1BRIC
NUMC
11 0
RNE
Foreign National Registration
J_1BRNE
CHAR
10 0
RNEDATE
RNE Issue Date
J_1BRNEDATE
DATS
8 0
CNAE
CNAE
J_1BCNAE J_1BTCNAE
CHAR
7 0
LEGALNAT
Legal Nature
J_1BLEGALNAT J_1BTLEGALNAT
NUMC
4 0
CRTN
CRT Number
J_1BCRTN
CHAR
1 0
ICMSTAXPAY
ICMS Taxpayer
J_1BICMSTAXPAY J_1BTICMSTAXPAY
CHAR
2 0
INDTYP
Industry Main Type
J_1BINDTYP J_1BTINDTYP
CHAR
2 0
TDT
Tax Declaration Type
J_1BTDT J_1BTTDT
CHAR
2 0
COMSIZE
Company Size
J_1BCOMSIZE J_1BTCOMSIZE
CHAR
2 0
DECREGPC
Declaration Regimen for PIS/COFINS
J_1BDECREGPC J_1BTDECREGPC
CHAR
2 0
J_SC_CAPITAL
Capital Amount
/SAPNEA/J_SC_CAPITAL
CURR
15 2
J_SC_CURRENCY
Currency
/SAPNEA/J_SC_CURRENCY TCURC
CUKY
5 0
ALC
Agency Location Code
FMFG_ALC FMFGT_ALC
CHAR
8 0
PMT_OFFICE
Payment Office
FMFG_PMT_OFF FMFGT_PO
CHAR
5 0
PPA_RELEVANT
Vendor is PPA relevant
FMFG_PPA_RELEVANT
CHAR
1 0
PSOFG
Processor group
PSOFG PSO19
CHAR
10 0
PSOIS
Subledger acct preprocessing procedure
PSOIS
CHAR
20 0
PSON1
Name 1
NAME1_GP
CHAR
35 0
PSON2
Name 2
NAME2_GP
CHAR
35 0
PSON3
Name 3
NAME3_GP
CHAR
35 0
PSOVN
First Name
PSOVN
CHAR
35 0
PSOTL
Title
PSOTL
CHAR
20 0
PSOHS
House number: is no longer used from Release 4.6B
PSOHS
CHAR
6 0
PSOST
Street: No longer used from Release 4.6B
PSOST
CHAR
28 0
ENTY_CD
Entity Code
OIU_ENTY_CD
CHAR
2 0
RES_CNTRY
Resident Country
OIU_RES_CNTRY T005
CHAR
3 0
RES_REGION
Region of Residence
OIU_RES_REGION T005S
CHAR
3 0
CCODE
Company Code
BUKRS
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
SCHEDULING_TYPE
Scheduling Procedure
WRF_PSCD_SCHED_TYPE
CHAR
1 0
SUBMI_RELEVANT
Cross Docking: Relevant for Collective Numbering
WRF_SUBMI_RELEVANT
CHAR
1 0

LFA1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
LFA1 ACTSS SYST MANDT J_1AACT
Activity code for social security withholding
MANDT
LFA1 ACTSS LFA1 ACTSS J_1AACT
Activity code for social security withholding
J_1AACT
LFA1 ALC LFA1 MANDT FMFGT_ALC
Agency Location Code - U.S. Federal Government
MANDT
LFA1 ALC LFA1 ALC FMFGT_ALC
Agency Location Code - U.S. Federal Government
ALC
LFA1 BRSCH LFA1 MANDT T016
Industries
MANDT
LFA1 BRSCH LFA1 BRSCH T016
Industries
BRSCH
LFA1 CNAE LFA1 CNAE J_1BTCNAE
CNAE
J_1BCNAE
LFA1 CNAE SYST MANDT J_1BTCNAE
CNAE
MANDT
LFA1 COMSIZE SYST MANDT J_1BTCOMSIZE
Company Size
MANDT
LFA1 COMSIZE LFA1 COMSIZE J_1BTCOMSIZE
Company Size
J_1BCOMSIZE
LFA1 DECREGPC SYST MANDT J_1BTDECREGPC
Declaration Regimen for PIS/COFINS
MANDT
LFA1 DECREGPC LFA1 DECREGPC J_1BTDECREGPC
Declaration Regimen for PIS/COFINS
J_1BDECREGPC
LFA1 DLGRP LFA1 MANDT TVFCD
Service Agent Procedure Group for Shipment Costs
MANDT
LFA1 DLGRP LFA1 DLGRP TVFCD
Service Agent Procedure Group for Shipment Costs
DLGRP
LFA1 FISKN LFA1 FISKN LFA1
Vendor Master (General Section)
LIFNR
LFA1 FISKN LFA1 MANDT LFA1
Vendor Master (General Section)
MANDT
LFA1 FISKU SYST MANDT LFA1
Vendor Master (General Section)
MANDT
LFA1 FISKU LFA1 FISKU LFA1
Vendor Master (General Section)
LIFNR
LFA1 FITYP 'K' J_1AFITP
Tax Types
KOART
LFA1 FITYP LFA1 FITYP J_1AFITP
Tax Types
J_1AFITP
LFA1 FITYP LFA1 MANDT J_1AFITP
Tax Types
MANDT
LFA1 ICMSTAXPAY LFA1 ICMSTAXPAY J_1BTICMSTAXPAY
ICMS Taxpayer
J_1BICMSTAXPAY
LFA1 ICMSTAXPAY SYST MANDT J_1BTICMSTAXPAY
ICMS Taxpayer
MANDT
LFA1 INDTYP SYST MANDT J_1BTINDTYP
Industry Main Type
MANDT
LFA1 INDTYP LFA1 INDTYP J_1BTINDTYP
Industry Main Type
J_1BINDTYP
LFA1 J_1KFTBUS LFA1 MANDT BUSTYPE
Type of Business
MANDT
LFA1 J_1KFTBUS LFA1 J_1KFTBUS BUSTYPE
Type of Business
GESTYP
LFA1 J_1KFTIND LFA1 MANDT INDUSTYPE
Type of Industry
MANDT
LFA1 J_1KFTIND LFA1 J_1KFTIND INDUSTYPE
Type of Industry
INDTYPE
LFA1 J_SC_CURRENCY LFA1 MANDT TCURC
Currency Codes
MANDT
LFA1 J_SC_CURRENCY LFA1 J_SC_CURRENCY TCURC
Currency Codes
WAERS
LFA1 KTOCK LFA1 KTOCK T077K
Vendor account groups
KTOKK
LFA1 KTOCK LFA1 MANDT T077K
Vendor account groups
MANDT
LFA1 KTOKK LFA1 MANDT T077K
Vendor account groups
MANDT
LFA1 KTOKK LFA1 KTOKK T077K
Vendor account groups
KTOKK
LFA1 KUNNR LFA1 MANDT KNA1
General Data in Customer Master
MANDT
LFA1 KUNNR LFA1 KUNNR KNA1
General Data in Customer Master
KUNNR
LFA1 LAND1 LFA1 MANDT T005
Countries
MANDT
LFA1 LAND1 LFA1 LAND1 T005
Countries
LAND1
LFA1 LEGALNAT SYST MANDT J_1BTLEGALNAT
Legal Nature
MANDT
LFA1 LEGALNAT LFA1 LEGALNAT J_1BTLEGALNAT
Legal Nature
J_1BLEGALNAT
LFA1 LNRZA LFA1 MANDT LFA1
Vendor Master (General Section)
MANDT
LFA1 LNRZA LFA1 LNRZA LFA1
Vendor Master (General Section)
LIFNR
LFA1 LZONE LFA1 LZONE TZONE
Customers: Regional zones
ZONE1
LFA1 LZONE LFA1 MANDT TZONE
Customers: Regional zones
MANDT
LFA1 LZONE LFA1 LAND1 TZONE
Customers: Regional zones
LAND1
LFA1 MANDT LFA1 MANDT T000
Clients
MANDT
LFA1 PLKAL LFA1 PLKAL TFACD
Factory calendar definition
IDENT
LFA1 PMT_OFFICE LFA1 MANDT FMFGT_PO
Payment Office - U.S. Federal Government
MANDT
LFA1 PMT_OFFICE LFA1 PMT_OFFICE FMFGT_PO
Payment Office - U.S. Federal Government
PMT_OFFICE
LFA1 PSOFG LFA1 PSOFG PSO19
Group Responsibility
PSOFG
LFA1 PSOFG LFA1 MANDT PSO19
Group Responsibility
MANDT
LFA1 QSSYS LFA1 MANDT TQ02B
QM system
MANDT
LFA1 QSSYS LFA1 QSSYS TQ02B
QM system
QSSYSFAM
LFA1 REGIO LFA1 MANDT T005S
Taxes: Region (Province) Key
MANDT
LFA1 REGIO LFA1 LAND1 T005S
Taxes: Region (Province) Key
LAND1
LFA1 REGIO LFA1 REGIO T005S
Taxes: Region (Province) Key
BLAND
LFA1 RES_CNTRY SYST MANDT T005
Countries
MANDT
LFA1 RES_CNTRY LFA1 RES_CNTRY T005
Countries
LAND1
LFA1 RES_REGION SYST MANDT T005S
Taxes: Region (Province) Key
MANDT
LFA1 RES_REGION LFA1 RES_CNTRY T005S
Taxes: Region (Province) Key
LAND1
LFA1 RES_REGION LFA1 RES_REGION T005S
Taxes: Region (Province) Key
BLAND
LFA1 SFRGR LFA1 MANDT TSFG
Forwarding agent freight group
MANDT
LFA1 SFRGR LFA1 SFRGR TSFG
Forwarding agent freight group
SFRGR
LFA1 SPERQ LFA1 MANDT TQ04A
Functions that can be blocked
MANDT
LFA1 SPERQ LFA1 SPERQ TQ04A
Functions that can be blocked
SPERRFKT
LFA1 SPRAS LFA1 SPRAS T002
Language Keys (Component BC-I18)
SPRAS
LFA1 STCDT LFA1 MANDT J_1ATODC
Type of identification
MANDT
LFA1 STCDT LFA1 STCDT J_1ATODC
Type of identification
J_1ATODC
LFA1 STGDL LFA1 MANDT VTSGD
Shipment: Statistic Groups, Transportation Service Agent
MANDT
LFA1 STGDL LFA1 STGDL VTSGD
Shipment: Statistic Groups, Transportation Service Agent
STGDL
LFA1 TDT SYST MANDT J_1BTTDT
TDT
MANDT
LFA1 TDT LFA1 TDT J_1BTTDT
TDT
J_1BTDT
LFA1 TRANSPORT_CHAIN * WRF_PSCD_TCHAINH
Transportation Chain, Header
TC_MODE
LFA1 TRANSPORT_CHAIN SYST MANDT WRF_PSCD_TCHAINH
Transportation Chain, Header
MANDT
LFA1 TRANSPORT_CHAIN LFA1 TRANSPORT_CHAIN WRF_PSCD_TCHAINH
Transportation Chain, Header
TC_ID
LFA1 TXJCD LFA1 TXJCD TTXJ
Check Table for Tax Jurisdiction
TXJCD
LFA1 TXJCD LFA1 MANDT TTXJ
Check Table for Tax Jurisdiction
MANDT
LFA1 TXJCD T005 KALSM TTXJ
Check Table for Tax Jurisdiction
KALSM
LFA1 VBUND LFA1 MANDT T880
Global Company Data (for KONS Ledger)
MANDT
LFA1 VBUND LFA1 VBUND T880
Global Company Data (for KONS Ledger)
RCOMP