1. Home
  2. Resources
  3. SAP Tables
  4. SI_LFA1 - Vendor Master (General Section)

SAP Table SI_LFA1

Vendor Master (General Section)

SI_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 SI_LFA1 to other SAP tables.

Source: SI_LFA1 (Vendor Master (General Section))

SI_LFA1 table fields

Field Data element Checktable Datatype Length Decimals
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

SI_LFA1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SI_LFA1 ACTSS SYST MANDT J_1AACT Activity code for social security withholding MANDT
SI_LFA1 ACTSS SI_LFA1 ACTSS J_1AACT Activity code for social security withholding J_1AACT
SI_LFA1 BRSCH LFA1 MANDT T016 Industries MANDT
SI_LFA1 BRSCH SI_LFA1 BRSCH T016 Industries BRSCH
SI_LFA1 CNAE SYST MANDT J_1BTCNAE CNAE MANDT
SI_LFA1 CNAE SI_LFA1 CNAE J_1BTCNAE CNAE J_1BCNAE
SI_LFA1 COMSIZE SYST MANDT J_1BTCOMSIZE Company Size MANDT
SI_LFA1 COMSIZE SI_LFA1 COMSIZE J_1BTCOMSIZE Company Size J_1BCOMSIZE
SI_LFA1 DECREGPC SI_LFA1 DECREGPC J_1BTDECREGPC Declaration Regimen for PIS/COFINS J_1BDECREGPC
SI_LFA1 DECREGPC SYST MANDT J_1BTDECREGPC Declaration Regimen for PIS/COFINS MANDT
SI_LFA1 DLGRP SI_LFA1 DLGRP TVFCD Service Agent Procedure Group for Shipment Costs DLGRP
SI_LFA1 DLGRP LFA1 MANDT TVFCD Service Agent Procedure Group for Shipment Costs MANDT
SI_LFA1 FISKN SI_LFA1 FISKN LFA1 Vendor Master (General Section) LIFNR
SI_LFA1 FISKN LFA1 MANDT LFA1 Vendor Master (General Section) MANDT
SI_LFA1 FISKU SI_LFA1 FISKU LFA1 Vendor Master (General Section) LIFNR
SI_LFA1 FISKU SYST MANDT LFA1 Vendor Master (General Section) MANDT
SI_LFA1 FITYP SI_LFA1 FITYP J_1AFITP Tax Types J_1AFITP
SI_LFA1 FITYP 'K' J_1AFITP Tax Types KOART
SI_LFA1 FITYP LFA1 MANDT J_1AFITP Tax Types MANDT
SI_LFA1 ICMSTAXPAY SI_LFA1 ICMSTAXPAY J_1BTICMSTAXPAY ICMS Taxpayer J_1BICMSTAXPAY
SI_LFA1 ICMSTAXPAY SYST MANDT J_1BTICMSTAXPAY ICMS Taxpayer MANDT
SI_LFA1 INDTYP SYST MANDT J_1BTINDTYP Industry Main Type MANDT
SI_LFA1 INDTYP SI_LFA1 INDTYP J_1BTINDTYP Industry Main Type J_1BINDTYP
SI_LFA1 J_1KFTBUS SI_LFA1 J_1KFTBUS BUSTYPE Type of Business GESTYP
SI_LFA1 J_1KFTBUS LFA1 MANDT BUSTYPE Type of Business MANDT
SI_LFA1 J_1KFTIND SI_LFA1 J_1KFTIND INDUSTYPE Type of Industry INDTYPE
SI_LFA1 J_1KFTIND LFA1 MANDT INDUSTYPE Type of Industry MANDT
SI_LFA1 KTOCK LFA1 MANDT T077K Vendor account groups MANDT
SI_LFA1 KTOCK SI_LFA1 KTOCK T077K Vendor account groups KTOKK
SI_LFA1 KTOKK SI_LFA1 KTOKK T077K Vendor account groups KTOKK
SI_LFA1 KTOKK LFA1 MANDT T077K Vendor account groups MANDT
SI_LFA1 KUNNR LFA1 MANDT KNA1 General Data in Customer Master MANDT
SI_LFA1 KUNNR SI_LFA1 KUNNR KNA1 General Data in Customer Master KUNNR
SI_LFA1 LEGALNAT SI_LFA1 LEGALNAT J_1BTLEGALNAT Legal Nature J_1BLEGALNAT
SI_LFA1 LEGALNAT SYST MANDT J_1BTLEGALNAT Legal Nature MANDT
SI_LFA1 LNRZA LFA1 MANDT LFA1 Vendor Master (General Section) MANDT
SI_LFA1 LNRZA SI_LFA1 LNRZA LFA1 Vendor Master (General Section) LIFNR
SI_LFA1 LZONE SI_LFA1 LZONE TZONE Customers: Regional zones ZONE1
SI_LFA1 LZONE LFA1 LAND1 TZONE Customers: Regional zones LAND1
SI_LFA1 LZONE LFA1 MANDT TZONE Customers: Regional zones MANDT
SI_LFA1 PLKAL SI_LFA1 PLKAL TFACD Factory calendar definition IDENT
SI_LFA1 QSSYS SI_LFA1 QSSYS TQ02B QM system QSSYSFAM
SI_LFA1 QSSYS LFA1 MANDT TQ02B QM system MANDT
SI_LFA1 SFRGR SI_LFA1 SFRGR TSFG Forwarding agent freight group SFRGR
SI_LFA1 SFRGR LFA1 MANDT TSFG Forwarding agent freight group MANDT
SI_LFA1 SPERQ SI_LFA1 SPERQ TQ04A Functions that can be blocked SPERRFKT
SI_LFA1 SPERQ LFA1 MANDT TQ04A Functions that can be blocked MANDT
SI_LFA1 SPRAS SI_LFA1 SPRAS T002 Language Keys (Component BC-I18) SPRAS
SI_LFA1 STCDT LFA1 MANDT J_1ATODC Type of identification MANDT
SI_LFA1 STCDT SI_LFA1 STCDT J_1ATODC Type of identification J_1ATODC
SI_LFA1 STGDL SI_LFA1 STGDL VTSGD Shipment: Statistic Groups, Transportation Service Agent STGDL
SI_LFA1 STGDL LFA1 MANDT VTSGD Shipment: Statistic Groups, Transportation Service Agent MANDT
SI_LFA1 TDT SYST MANDT J_1BTTDT TDT MANDT
SI_LFA1 TDT SI_LFA1 TDT J_1BTTDT TDT J_1BTDT
SI_LFA1 TXJCD LFA1 MANDT TTXJ Check Table for Tax Jurisdiction MANDT
SI_LFA1 TXJCD T005 KALSM TTXJ Check Table for Tax Jurisdiction KALSM
SI_LFA1 TXJCD SI_LFA1 TXJCD TTXJ Check Table for Tax Jurisdiction TXJCD
SI_LFA1 VBUND SI_LFA1 VBUND T880 Global Company Data (for KONS Ledger) RCOMP
SI_LFA1 VBUND LFA1 MANDT T880 Global Company Data (for KONS Ledger) MANDT