LFA1 SAP Vendor Master (General Section) Table and data
LFA1 is a standard SAP Table which is used to store Vendor Master (General Section) data and is available within R/3 SAP systems depending on the version and release level.
Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP LFA1 Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.
Delivery Class: A - Application table containing master and transaction data
Display/Maintenance via SM30: Yes but with Restrictions
Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories
==>View Table relationships
SAP LFA1 Table fields within data Dictionary
| Field | Data Element | Data Type | length (Decimals) | Check table | Description | Conversion Routine |
| MANDT | MANDT | CLNT | 3 | T000 | Client | |
| LIFNR | LIFNR | CHAR | 10 | Account Number of Vendor or Creditor | ALPHA | |
| LAND1 | LAND1_GP | CHAR | 3 | T005 | Country Key | |
| NAME1 | NAME1_GP | CHAR | 35 | Name 1 | ||
| NAME2 | NAME2_GP | CHAR | 35 | Name 2 | ||
| NAME3 | NAME3_GP | CHAR | 35 | Name 3 | ||
| NAME4 | NAME4_GP | CHAR | 35 | Name 4 | ||
| ORT01 | ORT01_GP | CHAR | 35 | City | ||
| ORT02 | ORT02_GP | CHAR | 35 | District | ||
| PFACH | PFACH | CHAR | 10 | PO Box | ||
| PSTL2 | PSTL2 | CHAR | 10 | P.O. Box Postal Code | ||
| PSTLZ | PSTLZ | CHAR | 10 | Postal Code | ||
| SORTL | SORTL | CHAR | 10 | Sort field | ||
| STRAS | STRAS_GP | CHAR | 35 | House number and street | ||
| ADRNR | ADRNR | CHAR | 10 |
* | Address | ALPHA |
| MCOD1 | MCDK1 | CHAR | 25 | Search term for matchcode search | ||
| MCOD2 | MCDK2 | CHAR | 25 | Search term for matchcode search | ||
| MCOD3 | MCDK3 | CHAR | 25 | Search term for matchcode search | ||
| .INCLUDE | SI_LFA1 | Vendor Master (General Section) | ||||
| ANRED | ANRED | CHAR | 15 | Title | ||
| BAHNS | BAHNS | CHAR | 25 | Train station | ||
| BBBNR | BBBNR | NUMC | 7 | International location number (part 1) | ||
| BBSNR | BBSNR | NUMC | 5 | International location number (Part 2) | ||
| BEGRU | BRGRU | CHAR | 4 |
* | Authorization Group | |
| BRSCH | BRSCH | CHAR | 4 | T016 | Industry key | |
| BUBKZ | BUBKZ | NUMC | 1 | Check digit for the international location number | ||
| DATLT | DATLT | CHAR | 14 | Data communication line no. | ||
| DTAMS | DTAMS | CHAR | 1 | Indicator for Data Medium Exchange | ||
| DTAWS | DTAWS | CHAR | 2 |
* | Instruction key for data medium exchange | |
| ERDAT | ERDAT_RF | DATS | 8 | Date on which the Record Was Created | ||
| ERNAM | ERNAM_RF | CHAR | 12 | Name of Person who Created the Object | ||
| ESRNR | ESRNR | CHAR | 11 | ISR Subscriber Number | ||
| KONZS | KONZS | CHAR | 10 | Group key | ||
| KTOKK | KTOKK | CHAR | 4 | T077K | Vendor account group | |
| LNRZA | LNRZA | CHAR | 10 | LFA1 | Account Number of the Alternative Payee | ALPHA |
| LOEVM | LOEVM_X | CHAR | 1 | Central Deletion Flag for Master Record | ||
| SPERR | SPERB_X | CHAR | 1 | Central posting block | ||
| SPERM | SPERM_X | CHAR | 1 | Centrally imposed purchasing block | ||
| SPRAS | SPRAS | LANG | 1 | T002 | Language Key | ISOLA |
| STCD1 | STCD1 | CHAR | 16 | Tax Number 1 | ||
| STCD2 | STCD2 | CHAR | 11 | Tax Number 2 | ||
| STKZA | STKZA | CHAR | 1 | Indicator: Business Partner Subject to Equalization Tax? | ||
| STKZU | STKZU | CHAR | 1 | Liable for VAT | ||
| TELBX | TELBX | CHAR | 15 | Telebox number | ||
| TELF1 | TELF1 | CHAR | 16 | First telephone number | ||
| TELF2 | TELF2 | CHAR | 16 | Second telephone number | ||
| TELFX | TELFX | CHAR | 31 | Fax Number | ||
| TELTX | TELTX | CHAR | 30 | Teletex number | ||
| TELX1 | TELX1 | CHAR | 30 | Telex number | ||
| XCPDK | XCPDK | CHAR | 1 | Indicator: Is the account a one-time account? | ||
| XZEMP | XZEMP | CHAR | 1 | Indicator: Alternative payee in document allowed ? | ||
| VBUND | RASSC | CHAR | 6 | T880 | Company ID of trading partner | ALPHA |
| FISKN | FISKN_K | CHAR | 10 | LFA1 | Account number of the master record with fiscal address | ALPHA |
| STCEG | STCEG | CHAR | 20 | VAT Registration Number | ||
| STKZN | STKZN | CHAR | 1 | Natural Person | ||
| SPERQ | QSPERRFKT | CHAR | 2 | TQ04A | Function That Will Be Blocked | |
| GBORT | GBORT_Q | CHAR | 25 | Place of birth of the person subject to withholding tax | ||
| GBDAT | GBDAT_Q | DATS | 8 | Date of birth of the person subject to withholding tax | ||
| SEXKZ | SEXKZ | CHAR | 1 | Key for the Sex of the Person Subject to Withholding Tax | ||
| KRAUS | KRAUS_CM | CHAR | 11 | Credit information number | ||
| REVDB | REVDB_CM | DATS | 8 | Last review (external) | ||
| QSSYS | QSSYS_IST | CHAR | 4 | TQ02B | Vendor's QM system | |
| KTOCK | KTOCK | CHAR | 4 | T077K | Reference Account Group for One-Time Account (Vendor) | |
| PFORT | PFORT_GP | CHAR | 35 | PO Box city | ||
| WERKS | WERKS_EXT | CHAR | 4 |
* | Plant (Own or External) | |
| LTSNA | LTSNA | CHAR | 1 | Indicator: vendor sub-range relevant | ||
| WERKR | WERKR | CHAR | 1 | Indicator: plant level relevant | ||
| PLKAL | FABKL | CHAR | 2 | TFACD | Factory calendar key | |
| DUEFL | DUEFL_BKPF | CHAR | 1 | Status of Data Transfer into Subsequent Release | ||
| TXJCD | TXJCD | CHAR | 15 | TTXJ | Tax Jurisdiction | |
| SPERZ | SPERZ | CHAR | 1 | Payment Block | ||
| SCACD | SCACD | CHAR | 4 | Standard carrier access code | ||
| SFRGR | SFRGR | CHAR | 4 | TSFG | Forwarding agent freight group | |
| LZONE | LZONE | CHAR | 10 | TZONE | Transportation zone to or from which the goods are delivered | |
| XLFZA | XLFZA | CHAR | 1 | Indicator: Alternative payee using account number | ||
| DLGRP | DLGRP | CHAR | 4 | TVFCD | Service agent procedure group | |
| FITYP | J_1AFITP_D | CHAR | 2 | J_1AFITP | Tax type | |
| STCDT | J_1ATOID | CHAR | 2 | J_1ATODC | Tax Number Type | |
| REGSS | J_1AREGSS | CHAR | 1 | Registered for Social Insurance | ||
| ACTSS | J_1AACTSS | CHAR | 3 | J_1AACT | Activity Code for Social Insurance | |
| STCD3 | STCD3 | CHAR | 18 | Tax Number 3 | ||
| STCD4 | STCD4 | CHAR | 18 | Tax Number 4 | ||
| STCD5 | STCD5 | CHAR | 60 | Tax Number 5 | ||
| IPISP | J_1BINDEQU | CHAR | 1 | Tax Split | ||
| TAXBS | TAXBS | NUMC | 1 | Tax Base in Percentage | ||
| PROFS | PROFS | CHAR | 30 | Profession | ||
| STGDL | STGDL | CHAR | 2 | VTSGD | Shipment: statistics group, transportation service agent | |
| EMNFR | EMNFR | CHAR | 10 | External manufacturer code name or number | ||
| LFURL | URL | CHAR | 132 | Uniform Resource Locator | ||
| J_1KFREPRE | REPRES | CHAR | 10 | Name of Representative | ||
| J_1KFTBUS | GESTYP | CHAR | 30 | BUSTYPE | Type of Business | |
| J_1KFTIND | INDTYP | CHAR | 30 | INDUSTYPE | Type of Industry | |
| CONFS | CONFS_X | CHAR | 1 | Status of Change Authorization (Central) | ||
| UPDAT | UPDAT_RF | DATS | 8 | Date on Which the Changes Were Confirmed | ||
| UPTIM | UPTIM_RF | TIMS | 6 | Time of Last Change Confirmation | ||
| NODEL | NODEL_X | CHAR | 1 | Central deletion block for master record | ||
| QSSYSDAT | QQSSYSDAT | DATS | 8 | Validity date of certification | ||
| PODKZB | PODKZB | CHAR | 1 | Vendor indicator relevant for proof of delivery | ||
| FISKU | FISKU | CHAR | 10 | LFA1 | Account Number of Master Record of Tax Office Responsible | ALPHA |
| STENR | STENR | CHAR | 18 | Tax Number at Responsible Tax Authority | ||
| CARRIER_CONF | /SPE/CARRIER_CNF | CHAR | 1 | Carrier confirmation is expected | ||
| MIN_COMP | J_1BMICRO_COMP | CHAR | 1 | Micro company indicator | ||
| TERM_LI | J_1BTERMS_LIAB | CHAR | 1 | Terms of Liability | ||
| CRC_NUM | J_1BCRC_NUM | CHAR | 25 | CRC number | ||
| .INCLUDE | LFA1BRAZIL | Vendor Master Data - Brazil | ||||
| RG | J_1BRG | CHAR | 11 | RG Number | ||
| EXP | J_1BEXP | CHAR | 3 | Issued by | ||
| UF | J_1BUF | CHAR | 2 | State | ||
| RGDATE | J_1BRGDATE | DATS | 8 | RG Issue Date | ||
| RIC | J_1BRIC | NUMC | 11 | RIC Number | ||
| RNE | J_1BRNE | CHAR | 10 | Foreign National Registration | ||
| RNEDATE | J_1BRNEDATE | DATS | 8 | RNE Issue Date | ||
| CNAE | J_1BCNAE | CHAR | 7 | J_1BTCNAE | CNAE | |
| LEGALNAT | J_1BLEGALNAT | NUMC | 4 | J_1BTLEGALNAT | Legal Nature | |
| CRTN | J_1BCRTN | CHAR | 1 | CRT Number | ||
| ICMSTAXPAY | J_1BICMSTAXPAY | CHAR | 2 | J_1BTICMSTAXPAY | ICMS Taxpayer | |
| INDTYP | J_1BINDTYP | CHAR | 2 | J_1BTINDTYP | Industry Main Type | |
| TDT | J_1BTDT | CHAR | 2 | J_1BTTDT | Tax Declaration Type | |
| COMSIZE | J_1BCOMSIZE | CHAR | 2 | J_1BTCOMSIZE | Company Size | |
| DECREGPC | J_1BDECREGPC | CHAR | 2 | J_1BTDECREGPC | Declaration Regimen for PIS/COFINS | |
| .APPEND | /SAPHT/RN_SLFA1_DUNSP4 | LFA1 テーブルでの DUNS+4 (下 4 桁) の APPEND 構造 | ||||
| DUNSP4 | /SAPHT/RN_DUNSP4 | CHAR | 4 | DUNS+4 number (the last four digit) | ||
| .APPEND | /SAPNEA/J_SC_LFA1 | Subcontractor Information | ||||
| J_SC_CAPITAL | /SAPNEA/J_SC_CAPITAL | CURR | 15(2) | Capital Amount | ||
| J_SC_CURRENCY | /SAPNEA/J_SC_CURRENCY | CUKY | 5 | TCURC | Currency | |
| .APPEND | ALFA1_FMFG | US Federal Government Vendor Master Data Additional Fields | ||||
| ALC | FMFG_ALC | CHAR | 8 | FMFGT_ALC | Agency Location Code | |
| PMT_OFFICE | FMFG_PMT_OFF | CHAR | 5 | FMFGT_PO | Payment Office | |
| PPA_RELEVANT | FMFG_PPA_RELEVANT | CHAR | 1 | Vendor is PPA relevant | ||
| .APPEND | ALFA1_PSO | Local Authority Additional Fields (Address) | ||||
| PSOFG | PSOFG | CHAR | 10 | PSO19 | Processor group | |
| PSOIS | PSOIS | CHAR | 20 | Subledger acct preprocessing procedure | ||
| .INCLUDE | IADDR_PSO | Local Authority Additional Fields (Address) | ||||
| PSON1 | NAME1_GP | CHAR | 35 | Name 1 | ||
| PSON2 | NAME2_GP | CHAR | 35 | Name 2 | ||
| PSON3 | NAME3_GP | CHAR | 35 | Name 3 | ||
| PSOVN | PSOVN | CHAR | 35 | First Name | ||
| PSOTL | PSOTL | CHAR | 20 | Title | ||
| PSOHS | PSOHS | CHAR | 6 | House number: is no longer used from Release 4.6B | ||
| PSOST | PSOST | CHAR | 28 | Street: No longer used from Release 4.6B | ||
| .APPEND | BORGR_WE | Enhancements Auto Two-Step Goods Receipt | ||||
| .INCLUDE | BORGR_WE_LFA1 | Fields for Two-Step Goods Receipt | ||||
| BORGR_DATUN | BORGR_DATUN | DATS | 8 | Date Limit for External Document Identification | ||
| BORGR_YEAUN | BORGR_YEAUN | CHAR | 1 | Annual Repetition of Date Limit | ||
| .APPEND | WRF_LFA1_APPEND | LFA1 Extension with New Fields - Seasonal Procurement | ||||
| .INCLUDE | WRF_LFA1_STY | LFA1 Extension with New Fields - Seasonal Procurement | ||||
| TRANSPORT_CHAIN | WRF_PSCD_TC_ID | CHAR | 10 | WRF_PSCD_TCHAINH | Transportation Chain | |
| STAGING_TIME | WRF_PSCD_MST | DEC | 3 | Staging Time in Days | ||
| SCHEDULING_TYPE | WRF_PSCD_SCHED_TYPE | CHAR | 1 | Scheduling Procedure | ||
| SUBMI_RELEVANT | WRF_SUBMI_RELEVANT | CHAR | 1 | Cross Docking: Relevant for Collective Numbering | ||
| Key field | |
| Non-key field |
LFA1 relationships with other tables
BOSG-Uppermost Hierarchy Segment for BRF
BKPF-Accounting Document Header
BSEG-Accounting Document Segment
BSET-Tax Data Document Segment
FAGLFREESEL-General Ledger: Custom Selections (Enhanced)
KNA1-General Data in Customer Master
KNBK-Customer Master (Bank Details)
KNB1-Customer Master (Company Code)
KNB4-Customer Payment History
KNB5-Customer Master (Dunning Data)
KNKK-Credit Management Cust. Mstr: Control Area Data
KNC1-Customer Master (Transaction Figures)
KNC3-Customer Master (Special G/L Transaction Figures)
LFA1-Vendor Master (General Section)
LFBK-Vendor Master (Bank Details)
LFB1-Vendor Master (Company Code)
LFB5-Vendor Master (Dunning Data)
LFC1-Vendor Master (Transaction Figures)
LFC3-Vendor Master (Transaction Figures) Special Ledger
SKA1-G/L Account Master Record (Chart of Accounts)
SKB1-G/L Account Master Record (Company Code)
SKC1A-G/L Sales Segment Derived from GLDB - Internal
SKC1C-G/L Account C-Segment from GLT0 -Currency Amounts-
LFA1-Vendor Master (General Section)
ADDR1_VAL-Address Data
LFAS-Vendor Master (General Part EU Tax Number)
LFBK-Vendor Master (Bank Details)
LFB1-Vendor Master (Company Code)
LFB5-Vendor Master (Dunning Data)
LFC1-Vendor Master (Transaction Figures)
LFC3-Vendor Master (Transaction Figures) Special Ledger
BSIK-Accounting: Secondary Index for Vendors
ADMI_FILES-Archive Files
BSIKEXT-Secondary Index & Additions Section (BSEGA)
BKPF-Accounting Document Header
BSEG-Accounting Document Segment
WITH_ITEM-Witholding Tax Info.per W/Tax Type and FI Line Itm
GSEG-Offsetting Items for B-Segment in Reporting
