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
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
1 Single data record not to be forwarded to the Bundesbank
0 Single data record can be forwarded to the Bundesbank
NULL Use house bank default value
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
X Yes
NULL No
SPERR Central posting block SPERB_X CHAR 1 0
X Yes
NULL No
SPERM Centrally imposed purchasing block SPERM_X CHAR 1 0
X Yes
NULL No
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
NULL Not subject to equalization tax
X Subject to equalization tax
STKZU Liable for VAT STKZU CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
XZEMP Indicator: Alternative payee in document allowed ? XZEMP CHAR 1 0
X Yes
NULL No
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
X Natural person
NULL Legal person
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
1 Male
2 Female
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
X Yes
NULL No
WERKR Indicator: plant level relevant WERKR CHAR 1 0
X Yes
NULL No
PLKAL Factory calendar key FABKL TFACD CHAR 2 0
DUEFL Status of Data Transfer into Subsequent Release DUEFL_BKPF CHAR 1 0
NULL Not transferred yet
A Transfer taken place, document changed later
X Transfer taken place, document unchanged
TXJCD Tax Jurisdiction TXJCD TTXJ CHAR 15 0
SPERZ Payment Block SPERZ CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
TAXBS Tax Base in Percentage TAXBS NUMC 1 0
1 80%
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
X Yes
NULL No
QSSYSDAT Validity date of certification QQSSYSDAT DATS 8 0
PODKZB Vendor indicator relevant for proof of delivery PODKZB CHAR 1 0
NULL Do not send proof of delivery
A Always send proof of delivery
B Only send proof of delivery if there are changes
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
NULL Carrier confirmation not expected
X Carrier confirmation expected via Carrier portal
B Carrier confirmation expected via IDocs
MIN_COMP Micro company indicator J_1BMICRO_COMP CHAR 1 0
X Yes
NULL No
TERM_LI Terms of Liability J_1BTERMS_LIAB CHAR 1 0
X Yes
NULL No
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
1 Simples Nacional
2 Simples Nacional � excesso de sublimite da receita bruta
3 Regime Normal (n�o simples)
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
X Yes
NULL No
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
01 Charitable
02 Federal
03 Indian
04 State
05 Other Exempt Entities
06 Not Applicable
07 Taxable Indians
08 Corporation
09 Individual
10 Partnership, Trust, or Estate
11 Trust or Fiduciary
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
1 Maximum Dateline
2 Minimum Dateline
3 Maximum Before Minimum Dateline
SUBMI_RELEVANT Cross Docking: Relevant for Collective Numbering WRF_SUBMI_RELEVANT CHAR 1 0
X Yes
NULL No

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 BRSCH T016 Industries BRSCH
LFA1 BRSCH LFA1 MANDT T016 Industries MANDT
LFA1 CNAE SYST MANDT J_1BTCNAE CNAE MANDT
LFA1 CNAE LFA1 CNAE J_1BTCNAE CNAE J_1BCNAE
LFA1 COMSIZE SYST MANDT J_1BTCOMSIZE Company Size MANDT
LFA1 COMSIZE LFA1 COMSIZE J_1BTCOMSIZE Company Size J_1BCOMSIZE
LFA1 DECREGPC LFA1 DECREGPC J_1BTDECREGPC Declaration Regimen for PIS/COFINS J_1BDECREGPC
LFA1 DECREGPC SYST MANDT J_1BTDECREGPC Declaration Regimen for PIS/COFINS MANDT
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 MANDT LFA1 Vendor Master (General Section) MANDT
LFA1 FISKN LFA1 FISKN LFA1 Vendor Master (General Section) LIFNR
LFA1 FISKU SYST MANDT LFA1 Vendor Master (General Section) MANDT
LFA1 FISKU LFA1 FISKU LFA1 Vendor Master (General Section) LIFNR
LFA1 FITYP LFA1 MANDT J_1AFITP Tax Types MANDT
LFA1 FITYP 'K' J_1AFITP Tax Types KOART
LFA1 FITYP LFA1 FITYP J_1AFITP Tax Types J_1AFITP
LFA1 ICMSTAXPAY SYST MANDT J_1BTICMSTAXPAY ICMS Taxpayer MANDT
LFA1 ICMSTAXPAY LFA1 ICMSTAXPAY J_1BTICMSTAXPAY ICMS Taxpayer J_1BICMSTAXPAY
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 MANDT T077K Vendor account groups MANDT
LFA1 KTOCK LFA1 KTOCK T077K Vendor account groups KTOKK
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 LAND1 T005 Countries LAND1
LFA1 LAND1 LFA1 MANDT T005 Countries MANDT
LFA1 LEGALNAT LFA1 LEGALNAT J_1BTLEGALNAT Legal Nature J_1BLEGALNAT
LFA1 LEGALNAT SYST MANDT J_1BTLEGALNAT Legal Nature MANDT
LFA1 LNRZA LFA1 LNRZA LFA1 Vendor Master (General Section) LIFNR
LFA1 LNRZA LFA1 MANDT LFA1 Vendor Master (General Section) MANDT
LFA1 LZONE LFA1 LAND1 TZONE Customers: Regional zones LAND1
LFA1 LZONE LFA1 LZONE TZONE Customers: Regional zones ZONE1
LFA1 LZONE LFA1 MANDT TZONE Customers: Regional zones MANDT
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 MANDT PSO19 Group Responsibility MANDT
LFA1 PSOFG LFA1 PSOFG PSO19 Group Responsibility PSOFG
LFA1 QSSYS LFA1 QSSYS TQ02B QM system QSSYSFAM
LFA1 QSSYS LFA1 MANDT TQ02B QM system MANDT
LFA1 REGIO LFA1 REGIO T005S Taxes: Region (Province) Key BLAND
LFA1 REGIO LFA1 MANDT T005S Taxes: Region (Province) Key MANDT
LFA1 REGIO LFA1 LAND1 T005S Taxes: Region (Province) Key LAND1
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 LFA1 TRANSPORT_CHAIN WRF_PSCD_TCHAINH Transportation Chain, Header TC_ID
LFA1 TRANSPORT_CHAIN * WRF_PSCD_TCHAINH Transportation Chain, Header TC_MODE
LFA1 TRANSPORT_CHAIN SYST MANDT WRF_PSCD_TCHAINH Transportation Chain, Header MANDT
LFA1 TXJCD LFA1 MANDT TTXJ Check Table for Tax Jurisdiction MANDT
LFA1 TXJCD T005 KALSM TTXJ Check Table for Tax Jurisdiction KALSM
LFA1 TXJCD LFA1 TXJCD TTXJ Check Table for Tax Jurisdiction TXJCD
LFA1 VBUND LFA1 VBUND T880 Global Company Data (for KONS Ledger) RCOMP
LFA1 VBUND LFA1 MANDT T880 Global Company Data (for KONS Ledger) MANDT