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:

  • Stores basic vendor details such as name, address, and contact information.
  • Includes global data used for communication and vendor classification.
  • Acts as a foundation for other vendor-specific data tables, such as LFB1 (company code data).

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 are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

LFA1 columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyLIFNR 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
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
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
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
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
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
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
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
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
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
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
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
VFNUM Verification Number CHAR 20 0 GB_CIS_SC_VFNNUM
VFNID Tax Status of the Verified Subcontractor CHAR 1 0 CIS_VFN_ID
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
J_1IVTYP Type of Vendor CHAR 2 0 J_1IVTYP
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
SUBMI_RELEVANT Cross Docking: Relevant for Collective Numbering CHAR 1 0 WRF_SUBMI_RELEVANT
/ Relationships

LFA1 foreign keys.

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