SAP table LFA1 (Supplier Master (General Section))

The LFA1 table in SAP contains the general information about vendors. This data is shared across all company codes and purchasing organizations within the system.

Key Features:

The LFA1 table is essential for managing vendor master records and integrating them with purchasing and accounting processes.

SAP table LFA1 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 T000 MANDT
LIFNR Account Number of Supplier CHAR 10 0 LIFNR
LAND1 Country/Region Key CHAR 3 0 T005 LAND1_GP
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 T005S REGIO
SORTL Sort field CHAR 10 0 SORTL
STRAS Street and House Number CHAR 35 0 STRAS_GP
ADRNR Address CHAR 10 0 ADRNR
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
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
LFA1_EEW_SUPP Dataelement Exstensibility for Supplier CHAR 1 0 LFA1_EEW_SUPP
J_SC_CAPITAL Capital Amount CURR 15 2 /SAPNEA/J_SC_CAPITAL
J_SC_CURRENCY Currency CUKY 5 0 TCURC /SAPNEA/J_SC_CURRENCY
ALC Agency Location Code CHAR 8 0 FMFGT_ALC FMFG_ALC
PMT_OFFICE Payment Office CHAR 5 0 FMFGT_PO FMFG_PMT_OFF
PPA_RELEVANT Vendor is PPA relevant CHAR 1 0 FMFG_PPA_RELEVANT
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 CHAR 4 0 FMFG_EFT_IND
PSOFG Processor group CHAR 10 0 PSO19 PSOFG
PSOIS Subledger acct preprocessing procedure CHAR 20 0 PSOIS
PSON1 Name 1 CHAR 35 0 NAME1_GP
PSON2 Name 2 CHAR 35 0 NAME2_GP
PSON3 Name 3 CHAR 35 0 NAME3_GP
PSOVN First Name CHAR 35 0 PSOVN
PSOTL Title CHAR 20 0 PSOTL
PSOHS House number: is no longer used from Release 4.6B CHAR 6 0 PSOHS
PSOST Street: No longer used from Release 4.6B CHAR 28 0 PSOST
BORGR_DATUN Date Limit for External Document Identification DATS 8 0 BORGR_DATUN
BORGR_YEAUN Annual Repetition of Date Limit CHAR 1 0 BORGR_YEAUN
AU_CARRYING_ENT Is payer making payment in course of carrying on enterprise CHAR 1 0 FIAPAU_CARRY_ENT
AU_IND_UNDER_18 Is an individual under 18 and payment does not exceed $350 CHAR 1 0 FIAPAU_IND_UNDER_18
AU_PAYMENT_NOT_EXCEED_75 The payment does not exceed $75, excl. GST CHAR 1 0 FIAPAU_PMNT_NOT_EXCEED
AU_WHOLLY_INP_TAXED The supply that the payment relates to is wholly input taxed CHAR 1 0 FIAPAU_INPUT_TAXED
AU_PARTNER_WITHOUT_GAIN The supply is made by an individual without gain CHAR 1 0 FIAPAU_PARTNER_NO_GAIN
AU_NOT_ENTITLED_ABN The supplier is not entitled to an ABN CHAR 1 0 FIAPAU_ABN_ELIGIBLE
AU_PAYMENT_EXEMPT The whole of the payment is exempt income. CHAR 1 0 FIAPAU_PMNT_EXEMPT
AU_PRIVATE_HOBBY An activity done as a private recreational pursuit CHAR 1 0 FIAPAU_PVT_HOBBY
AU_DOMESTIC_NATURE wholly of a private or domestic nature CHAR 1 0 FIAPAU_DOM_NATURE
ADDR2_STREET Street CHAR 60 0 AD_STREET
ADDR2_HOUSE_NUM House Number CHAR 10 0 AD_HSNM1
ADDR2_POST City postal code CHAR 10 0 AD_PSTCD1
ADDR2_CITY City CHAR 40 0 AD_CITY1
ADDR2_COUNTRY Country/Region Key CHAR 3 0 * LAND1
CATEG Subcontractor's Business Type CHAR 12 0 CIS_CATEGORY
CO company
PT partnership
ST soletrader
TT trust
PARTNER_NAME Partner's Trading Name CHAR 30 0 CIS_PARTNER_NAME
PARTNER_UTR Partner's Unique Tax Reference (UTR) CHAR 20 0 CIS_PARTNER_UTR
STATUS Verification Status CHAR 3 0 CIS_VFNSTATUS
ST1 Unmatched by HMRC, details must be verified with subcontract
ST2 Unmatched, details must be matched and verified by HMRC
ST3 Unmatched, details must be verified by HMRC
ST4 Verified, verification number and tax treatment not updated
ST5 Verified, vendor master data updated
VFNUM Verification Number CHAR 20 0 GB_CIS_SC_VFNNUM
VFNID Tax Status of the Verified Subcontractor CHAR 1 0 CIS_VFN_ID
G Gross
N Net
U Unidentified
CRN Companies House Registration Number CHAR 8 0 GB_CIS_CRN
FR_OCCUPATION Organisation Occupation CHAR 50 0 FIWTFR_OCC
J_1IEXCD ECC Number CHAR 40 0 J_1IEXCD
J_1IEXRN Excise Registration Number CHAR 40 0 J_1IEXRN
J_1IEXRG Excise Range CHAR 60 0 J_1IEXRG
J_1IEXDI Excise Division CHAR 60 0 J_1IEXDI
J_1IEXCO Excise Commissionerate CHAR 60 0 J_1IEXCO
J_1ICSTNO Central Sales Tax Number CHAR 40 0 J_1ICSTNO
J_1ILSTNO Local Sales Tax Number CHAR 40 0 J_1ILSTNO
J_1IPANNO Permanent Account Number CHAR 40 0 J_1IPANNO
J_1IEXCIVE Excise tax indicator for vendor CHAR 1 0 J_1ITAXIND J_1IEXCIVE
J_1ISSIST SSI Status CHAR 1 0 J_1ISSIST
0
J_1IVTYP Type of Vendor CHAR 2 0 J_1IVTYP
DI First Stage or Second Stage dealer of imported goods
FD First Stage Dealer of indigenous excisable goods
I Importer, from his depot or his consignment agent
M Manufacturer
MD Manufacturer's Depot or Consignment Agent
SD Second Stage Dealer of indigenous excisable goods
J_1IVENCRE CENVAT Scheme Participant CHAR 1 0 J_1IVENCRE
AEDAT (Obsolete) Last Changed On – do not use DATS 8 0 J_1IAEDAT_OBSOLETE
USNAM (Obsolete) Changed by the user – do not use CHAR 12 0 J_1IUSNAM_OBSOLETE
J_1ISERN Service Tax Registration Number CHAR 40 0 J_1ISERN
J_1IPANREF PAN Reference Number CHAR 40 0 J_1IPANREF
J_1IPANVALDT PAN Valid From Date DATS 8 0 J_1IPANVALDT
J_1I_CUSTOMS Customs Vendor CHAR 1 0 J_1I_CUSTOMS
J_1IDEDREF Deductee Reference Number CHAR 10 0 J_1IDEDREF
VEN_CLASS Vendor Classification for GST CHAR 1 0 J_1IGTAKLD
ENTPUB Vendor is public entity? CHAR 1 0 PFM_12ENTPUB
ESCRIT Deed of public use CHAR 80 0 PFM_12ESCRIT
DVALSS Social Security certificate validity date DATS 8 0 PFM_12DVALSS
FRMCSS Social Security certificate submission form CHAR 50 0 PFM_12FRMCSS
CODCAE CAE code NUMC 5 0 PFM_12TCAE PFM_12CODCAE
AUSDIV Absence of debt CHAR 1 0 PFM_12AUSDIV
SC_CAPITAL Capital Amount CURR 15 2 JSUG_SC_CAPITAL
SC_CURRENCY Currency CUKY 5 0 TCURC JSUG_SC_CURRENCY
TRANSPORT_CHAIN Transportation Chain CHAR 10 0 WRF_PSCD_TCHAINH WRF_PSCD_TC_ID
STAGING_TIME Staging Time in Days DEC 3 0 WRF_PSCD_MST
SCHEDULING_TYPE Scheduling Procedure CHAR 1 0 WRF_PSCD_SCHED_TYPE
1 Maximum Dateline
2 Minimum Dateline
3 Maximum Before Minimum Dateline
SUBMI_RELEVANT Cross Docking: Relevant for Collective Numbering CHAR 1 0 WRF_SUBMI_RELEVANT

LFA1 foreign key relationships

Table Field Check Table Check Field
0 LFA1 ACTSS J_1AACT Activity code for social security withholding MANDT
1 LFA1 ALC FMFGT_ALC Agency Location Code - U.S. Federal Government MANDT
0 LFA1 BRSCH T016 Industries BRSCH
1 LFA1 CODCAE PFM_12TCAE CAE code table for vendor master data MANDT
1 LFA1 CODCAE PFM_12TCAE CAE code table for vendor master data CODCAE
0 LFA1 COMSIZE J_1BTCOMSIZE Company Size J_1BCOMSIZE
1 LFA1 DECREGPC J_1BTDECREGPC Declaration Regimen for PIS/COFINS J_1BDECREGPC
0 LFA1 DLGRP TVFCD Service Agent Procedure Group for Shipment Costs MANDT
0 LFA1 DLGRP TVFCD Service Agent Procedure Group for Shipment Costs DLGRP
1 LFA1 FISKN LFA1 Supplier Master (General Section) MANDT
1 LFA1 FISKN LFA1 Supplier Master (General Section) LIFNR
0 LFA1 FISKU LFA1 Supplier Master (General Section) MANDT
0 LFA1 FISKU LFA1 Supplier Master (General Section) LIFNR
1 LFA1 FITYP J_1AFITP Tax Types MANDT
0 LFA1 ICMSTAXPAY J_1BTICMSTAXPAY ICMS Taxpayer J_1BICMSTAXPAY
1 LFA1 INDTYP J_1BTINDTYP Industry Main Type J_1BINDTYP
0 LFA1 J_1IEXCIVE J_1ITAXIND Excise Tax Indicator MANDT
1 LFA1 J_1KFTBUS BUSTYPE Type of Business GESTYP
0 LFA1 J_1KFTIND INDUSTYPE Type of Industry MANDT
0 LFA1 J_1KFTIND INDUSTYPE Type of Industry INDTYPE
1 LFA1 J_SC_CURRENCY TCURC Currency Codes MANDT
1 LFA1 J_SC_CURRENCY TCURC Currency Codes WAERS
0 LFA1 KTOCK T077K Supplier Account Groups MANDT
1 LFA1 KTOKK T077K Supplier Account Groups MANDT
0 LFA1 KUNNR KNA1 General Data in Customer Master MANDT
0 LFA1 KUNNR KNA1 General Data in Customer Master KUNNR
1 LFA1 LAND1 T005 Countries MANDT
1 LFA1 LAND1 T005 Countries LAND1
0 LFA1 LNRZA LFA1 Supplier Master (General Section) MANDT
0 LFA1 LNRZA LFA1 Supplier Master (General Section) LIFNR
1 LFA1 LZONE TZONE Customers: Regional zones MANDT
1 LFA1 LZONE TZONE Customers: Regional zones LAND1
1 LFA1 LZONE TZONE Customers: Regional zones ZONE1
0 LFA1 MANDT T000 Clients MANDT
1 LFA1 PMT_OFFICE FMFGT_PO Payment Office - U.S. Federal Government MANDT
1 LFA1 PMT_OFFICE FMFGT_PO Payment Office - U.S. Federal Government PMT_OFFICE
0 LFA1 PSOFG PSO19 Group Responsibility MANDT
0 LFA1 PSOFG PSO19 Group Responsibility PSOFG
1 LFA1 QSSYS TQ02B QM system MANDT
1 LFA1 QSSYS TQ02B QM system QSSYSFAM
0 LFA1 REGIO T005S Taxes: Region (Province) Key LAND1
1 LFA1 SC_CURRENCY TCURC Currency Codes MANDT
1 LFA1 SC_CURRENCY TCURC Currency Codes WAERS
0 LFA1 SFRGR TSFG Forwarding agent freight group MANDT
1 LFA1 SPERQ TQ04A Functions that can be blocked SPERRFKT
0 LFA1 STCDT J_1ATODC Type of identification J_1ATODC
1 LFA1 STGDL VTSGD Shipment: Statistic Groups, Transportation Service Agent MANDT
0 LFA1 TDT J_1BTTDT TDT J_1BTDT
1 LFA1 TRANSPORT_CHAIN WRF_PSCD_TCHAINH Transportation Chain, Header MANDT
1 LFA1 TRANSPORT_CHAIN WRF_PSCD_TCHAINH Transportation Chain, Header TC_ID
0 LFA1 TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
0 LFA1 TXJCD TTXJ Check Table for Tax Jurisdiction KALSM
1 LFA1 VBUND T880 Global Company Data (for KONS Ledger) MANDT
1 LFA1 VBUND T880 Global Company Data (for KONS Ledger) RCOMP