SAP table SI_LFA1 (Vendor Master (General Section))

Field Description Data Type Length Decimals Checktable Data Element
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 T016 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 T077K KTOKK
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
LNRZA Account Number of the Alternative Payee CHAR 10 0 LFA1 LNRZA
LOEVM Central Deletion Flag for Master Record CHAR 1 0 LOEVM_X
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 T002 SPRAS
STCD1 Tax Number 1 CHAR 16 0 STCD1
STCD2 Tax Number 2 CHAR 11 0 STCD2
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
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 T880 RASSC
FISKN Account number of the master record with fiscal address CHAR 10 0 LFA1 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 TQ04A QSPERRFKT
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 TQ02B QSSYS_IST
KTOCK Reference Account Group for One-Time Account (Vendor) CHAR 4 0 T077K KTOCK
PFORT PO Box city CHAR 35 0 PFORT_GP
WERKS Plant (Own or External) CHAR 4 0 WERKS_EXT
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 TFACD FABKL
DUEFL Status of Data Transfer into Subsequent Release CHAR 1 0 DUEFL_BKPF
Not transferred yet
A Transfer taken place, document changed later
X Transfer taken place, document unchanged
TXJCD Tax Jurisdiction CHAR 15 0 TTXJ TXJCD
SPERZ Payment Block CHAR 1 0 SPERZ
SCACD Standard carrier access code CHAR 4 0 SCACD
SFRGR Forwarding agent freight group CHAR 4 0 TSFG SFRGR
LZONE Transportation zone to or from which the goods are delivered CHAR 10 0 TZONE LZONE
XLFZA Indicator: Alternative Payee Using Account Number CHAR 1 0 XLFZA
DLGRP Service agent procedure group CHAR 4 0 TVFCD DLGRP
FITYP Tax type CHAR 2 0 J_1AFITP J_1AFITP_D
STCDT Tax Number Type CHAR 2 0 J_1ATODC J_1ATOID
REGSS Registered for Social Insurance CHAR 1 0 J_1AREGSS
ACTSS Activity Code for Social Insurance CHAR 3 0 J_1AACT J_1AACTSS
STCD3 Tax Number 3 CHAR 18 0 STCD3
STCD4 Tax Number 4 CHAR 18 0 STCD4
STCD5 Tax Number 5 CHAR 60 0 STCD5
STCD6 Tax Number 6 CHAR 20 0 STCD6
IPISP Tax Split CHAR 1 0 J_1BINDEQU
TAXBS Tax Base in Percentage NUMC 1 0 TAXBS
1 80%
PROFS Profession CHAR 30 0 PROFS
STGDL Shipment: statistics group, transportation service agent CHAR 2 0 VTSGD STGDL
EMNFR External manufacturer code name or number CHAR 10 0 EMNFR
LFURL Uniform resource locator CHAR 132 0 URL
J_1KFREPRE Name of Representative CHAR 10 0 REPRES
J_1KFTBUS Type of Business CHAR 30 0 BUSTYPE GESTYP
J_1KFTIND Type of Industry CHAR 30 0 INDUSTYPE INDTYP
CONFS Status of Change Authorization (Central) CHAR 1 0 CONFS_X
UPDAT Date on Which the Changes Were Confirmed DATS 8 0 UPDAT_RF
UPTIM Time of Last Change Confirmation TIMS 6 0 UPTIM_RF
NODEL Central deletion block for master record CHAR 1 0 NODEL_X
QSSYSDAT Validity Date of Certification DATS 8 0 QQSSYSDAT
PODKZB Supplier indicator relevant for proof of delivery CHAR 1 0 PODKZB
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 CHAR 10 0 LFA1 FISKU
STENR Tax Number at Responsible Tax Authority CHAR 18 0 STENR
CARRIER_CONF Carrier confirmation is expected CHAR 1 0 /SPE/CARRIER_CNF
MIN_COMP Micro company indicator CHAR 1 0 J_1BMICRO_COMP
TERM_LI Terms of Liability CHAR 1 0 J_1BTERMS_LIAB
CRC_NUM CRC number CHAR 25 0 J_1BCRC_NUM
CVP_XBLCK Business Purpose Completed Flag CHAR 1 0 CVP_XBLCK
not blocked
X blocked
WEORA Acceptance At Origin CHAR 1 0 WEORA
RG RG Number CHAR 11 0 J_1BRG
EXP Issued by CHAR 3 0 J_1BEXP
UF State CHAR 2 0 J_1BUF
RGDATE RG Issuing Date DATS 8 0 J_1BRGDATE
RIC RIC Number NUMC 11 0 J_1BRIC
RNE Foreign National Registration CHAR 10 0 J_1BRNE
RNEDATE RNE Issuing Date DATS 8 0 J_1BRNEDATE
CNAE CNAE CHAR 7 0 J_1BTCNAE J_1BCNAE
LEGALNAT Legal Nature NUMC 4 0 J_1BTLEGALNAT J_1BLEGALNAT
CRTN CRT Number CHAR 1 0 * J_1BCRTN
1 Simples Nacional
2 Simples Nacional # excesso de sublimite da receita bruta
3 Regime Normal (não simples)
4 Simples Nacional - Microempreendedor Individual - MEI
ICMSTAXPAY ICMS Taxpayer CHAR 2 0 J_1BTICMSTAXPAY J_1BICMSTAXPAY
INDTYP Industry Main Type CHAR 2 0 J_1BTINDTYP J_1BINDTYP
TDT Tax Declaration Type CHAR 2 0 J_1BTTDT J_1BTDT
COMSIZE Company Size CHAR 2 0 J_1BTCOMSIZE J_1BCOMSIZE
DECREGPC Declaration Regimen for PIS/COFINS CHAR 2 0 J_1BTDECREGPC J_1BDECREGPC
ALLOWANCE_TYPE TW: Allowance Type in Business Partner Extension CHAR 1 0 TWVAT_ALLOWANCE_TYPE
1 Allowance issued by buyer
2 Allowance issued by seller
PAYTRSN Payment Reason CHAR 4 0 FARP_PAYT_RSN

SI_LFA1 foreign key relationships

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