LFA1 is a standard Financial Accounting Transparent Table in SAP FI application, which stores Vendor Master (General Section) data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for LFA1. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

LFA1 — Meta Data

Description: Vendor Master (General Section)
Main Category: FI
Sub Category: Financial Accounting
Table type: Transparent Table (TRANSP)

LFA1 — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 MANDT Client X CLNT 3 T000
    2 LIFNR Vendor X CHAR 10
    3 LAND1 Country CHAR 3 T005
    4 NAME1 Name 1 CHAR 35
    5 NAME2 Name 2 CHAR 35
    6 NAME3 Name 3 CHAR 35
    7 NAME4 Name 4 CHAR 35
    8 ORT01 City CHAR 35
    9 ORT02 District CHAR 35
    10 PFACH PO Box CHAR 10
    11 PSTL2 P.O. Box Postal Code CHAR 10
    12 PSTLZ P.Code/City CHAR 10
    13 REGIO Region (State CHAR 3 T005S
    14 SORTL Sort field CHAR 10
    15 STRAS House number and street CHAR 35
    16 ADRNR Address CHAR 10
    17 MCOD1 Search term for matchcode search CHAR 25
    18 MCOD2 Search term for matchcode search CHAR 25
    19 MCOD3 Search term for matchcode search CHAR 25
    20 .INCLUDE 0
    21 ANRED Form of address CHAR 15
    22 BAHNS Train station CHAR 25
    23 BBBNR International location number (part 1) NUMC 7
    24 BBSNR International location number (Part 2) NUMC 5
    25 BEGRU Authorization Group CHAR 4 *
    26 BRSCH Industry key CHAR 4 T016
    27 BUBKZ Check digit for the international location number NUMC 1
    28 DATLT Data communication line no. CHAR 14
    29 DTAMS Report key for data medium exchange CHAR 1
    30 DTAWS Instruction key for data medium exchange CHAR 2 *
    31 ERDAT Created on DATS 8
    32 ERNAM Created by CHAR 12
    33 ESRNR POR subscriber number CHAR 11
    34 KONZS Group key CHAR 10
    35 KTOKK - obsolete - CHAR 4 T077K
    36 KUNNR Customer CHAR 10 KNA1
    37 LNRZA Account Number of the Alternative Payee CHAR 10 LFA1
    38 LOEVM Deletion Indicator CHAR 1
    39 SPERR Central posting block CHAR 1
    40 SPERM Centrally imposed purchasing block CHAR 1
    41 SPRAS Language Key LANG 1 T002
    42 STCD1 Tax Number 1 CHAR 16
    43 STCD2 Tax Number 2 CHAR 11
    44 STKZA Indicator: Business Partner Subject to Equalization Tax? CHAR 1
    45 STKZU Liable for VAT CHAR 1
    46 TELBX Telebox number CHAR 15
    47 TELF1 First telephone number CHAR 16
    48 TELF2 Second telephone number CHAR 16
    49 TELFX Fax Number CHAR 31
    50 TELTX Teletex number CHAR 30
    51 TELX1 Telex number CHAR 30
    52 XCPDK Indicator: Is the account a one-time account? CHAR 1
    53 XZEMP Indicator: Alternative payee in document allowed ? CHAR 1
    54 VBUND Trading Partner CHAR 6 T880
    55 FISKN Account number of the master record with fiscal address CHAR 10 LFA1
    56 STCEG VAT registration number CHAR 20
    57 STKZN Natural Person CHAR 1
    58 SPERQ Function That Will Be Blocked CHAR 2 TQ04A
    59 GBORT Location of Affected Property CHAR 25
    60 GBDAT Birth date DATS 8
    61 SEXKZ Key for the Sex of the Person Subject to Withholding Tax CHAR 1
    62 KRAUS Credit information number CHAR 11
    63 REVDB Last review (external) DATS 8
    64 QSSYS Vendor's QM system CHAR 4 TQ02B
    65 KTOCK Reference Account Group for One-Time Account (Vendor) CHAR 4 T077K
    66 PFORT PO Box city CHAR 35
    67 WERKS Plant CHAR 4
    68 LTSNA Indicator: vendor sub-range relevant CHAR 1
    69 WERKR Indicator: plant level relevant CHAR 1
    70 PLKAL Factory calendar key CHAR 2 TFACD
    71 DUEFL Status of data transfer into subsequent release CHAR 1
    72 TXJCD Jurisdiction for Tax Calculation - Tax Jurisdiction Code CHAR 15 TTXJ
    73 SPERZ Payment Block CHAR 1
    74 SCACD Standard carrier access code CHAR 4
    75 SFRGR Forwarding agent freight group CHAR 4 TSFG
    76 LZONE Transportation zone to or from which the goods are delivered CHAR 10 TZONE
    77 XLFZA Indicator: Alternative payee using account number CHAR 1
    78 DLGRP Service agent procedure group CHAR 4 TVFCD
    79 FITYP Tax type CHAR 2 J_1AFITP
    80 STCDT Tax Number Type CHAR 2 J_1ATODC
    81 REGSS Registered for Social Insurance CHAR 1
    82 ACTSS Activity Code for Social Insurance CHAR 3 J_1AACT
    83 STCD3 Tax Number 3 CHAR 18
    84 STCD4 Tax Number 4 CHAR 18
    85 STCD5 Tax Number 5 CHAR 60
    86 IPISP Tax Split CHAR 1
    87 TAXBS Tax Base in Percentage NUMC 1
    88 PROFS Profession CHAR 30
    89 STGDL Shipment: statistics group CHAR 2 VTSGD
    90 EMNFR External manufacturer code name or number CHAR 10
    91 LFURL Uniform resource locator CHAR 132
    92 J_1KFREPRE Name of Representative CHAR 10
    93 J_1KFTBUS Type of Business CHAR 30 BUSTYPE
    94 J_1KFTIND Type of Industry CHAR 30 INDUSTYPE
    95 CONFS Status of Change Authorization (Central) CHAR 1
    96 UPDAT Update DATS 8
    97 UPTIM Time of Last Change (in UTC) TIMS 6
    98 NODEL Central deletion block for master record CHAR 1
    99 QSSYSDAT Validity date of certification DATS 8
    100 PODKZB Vendor indicator relevant for proof of delivery CHAR 1
    101 FISKU Account Number of Master Record of Tax Office Responsible CHAR 10 LFA1
    102 STENR Tax Number at Responsible Tax Authority CHAR 18
    103 CARRIER_CONF Carrier confirmation is expected CHAR 1
    104 MIN_COMP Micro company indicator CHAR 1
    105 TERM_LI Terms of Liability CHAR 1
    106 CRC_NUM CRC number CHAR 25
    107 CVP_XBLCK Business Purpose Completed Flag CHAR 1
    108 .INCLUDE 0
    109 RG RG Number CHAR 11
    110 EXP Issued by CHAR 3
    111 UF State CHAR 2
    112 RGDATE RG Issuing Date DATS 8
    113 RIC RIC Number NUMC 11
    114 RNE Foreign National Registration CHAR 10
    115 RNEDATE RNE Issuing Date DATS 8
    116 CNAE CNAE CHAR 7 J_1BTCNAE
    117 LEGALNAT Legal Nature NUMC 4 J_1BTLEGALNAT
    118 CRTN CRT Number CHAR 1
    119 ICMSTAXPAY ICMS Taxpayer CHAR 2 J_1BTICMSTAXPAY
    120 INDTYP Industry Main Type CHAR 2 J_1BTINDTYP
    121 TDT Tax Declaration Type CHAR 2 J_1BTTDT
    122 COMSIZE Company Size CHAR 2 J_1BTCOMSIZE
    123 DECREGPC Declaration Regimen for PIS/COFINS CHAR 2 J_1BTDECREGPC
    124 .INCLUDE 0
    125 LFA1_EEW_SUPP CHAR 1
    126 .INCLU--AP 0
    127 J_SC_CAPITAL Capital Amount CURR 15
    128 J_SC_CURRENCY Currency CUKY 5 TCURC
    129 .INCLU--AP 0
    130 ALC Agency Location Code CHAR 8 FMFGT_ALC
    131 PMT_OFFICE Payment Office CHAR 5 FMFGT_PO
    132 PPA_RELEVANT Vendor is PPA relevant CHAR 1
    133 .INCLU--AP 0
    134 PSOFG Processor group CHAR 10 PSO19
    135 PSOIS Subledger acct preprocessing procedure CHAR 20
    136 .INCLUDE 0
    137 PSON1 Name 1 CHAR 35
    138 PSON2 Name 2 CHAR 35
    139 PSON3 Name 3 CHAR 35
    140 PSOVN First Name CHAR 35
    141 PSOTL Title CHAR 20
    142 PSOHS House number: is no longer used from Release 4.6B CHAR 6
    143 PSOST Street: No longer used from Release 4.6B CHAR 28
    144 .INCLU--AP 0
    145 .INCLUDE 0
    146 BORGR_DATUN Updated information in related user data field DATS 8
    147 BORGR_YEAUN Updated information in related user data field CHAR 1
    148 .INCLU--AP 0
    149 ADDR2_STREET Street CHAR 60
    150 ADDR2_HOUSE_NUM House Number CHAR 10
    151 ADDR2_POST City postal code CHAR 10
    152 ADDR2_CITY City CHAR 40
    153 ADDR2_COUNTRY Country Key CHAR 3 *
    154 .INCLU--AP 0
    155 CATEG Obsolete CHAR 12
    156 PARTNER_NAME Vendor/Customer name CHAR 30
    157 PARTNER_UTR Partner's Unique Tax Reference (UTR) CHAR 20
    158 STATUS Indicates whether a Call-off is valid or invalid CHAR 3
    159 VFNUM Verification Number CHAR 20
    160 VFNID Tax Status of the Verified Subcontractor CHAR 1
    161 CRN Regional council (code CHAR 8
    162 .INCLU--AP 0
    163 J_1IEXCD ECC Number CHAR 40
    164 J_1IEXRN Excise Registration Number CHAR 40
    165 J_1IEXRG Excise Range CHAR 60
    166 J_1IEXDI Excise Division CHAR 60
    167 J_1IEXCO Excise Commissionerate CHAR 60
    168 J_1ICSTNO Central Sales Tax Number CHAR 40
    169 J_1ILSTNO Local Sales Tax Number CHAR 40
    170 J_1IPANNO Permanent Account Number CHAR 40
    171 J_1IEXCIVE Excise tax indicator for vendor CHAR 1 J_1ITAXIND
    172 J_1ISSIST SSI Status CHAR 1
    173 J_1IVTYP Type of Vendor CHAR 2
    174 J_1IVENCRE CENVAT Scheme Participant CHAR 1
    175 AEDAT Changed on DATS 8
    176 USNAM User name CHAR 12
    177 J_1ISERN Service Tax Registration Number CHAR 40
    178 J_1IPANREF PAN Reference Number CHAR 40
    179 J_1IPANVALDT PAN Valid From Date DATS 8
    180 J_1I_CUSTOMS Customs Vendor CHAR 1
    181 J_1IDEDREF CHAR 10
    182 VEN_CLASS CHAR 1
    183 .INCLU--AP 0
    184 .INCLUDE 0
    185 ENTY_CD Entity Code CHAR 2
    186 RES_CNTRY unused, will be deleted in the future CHAR 3 T005
    187 RES_REGION Region of Residence CHAR 3 T005S
    188 CCODE unused, will be deleted in the future CHAR 4
    189 .INCLU--AP 0
    190 ENTPUB CHAR 1
    191 ESCRIT CHAR 80
    192 DVALSS DATS 8
    193 FRMCSS CHAR 50
    194 CODCAE NUMC 5 PFM_12TCAE
    195 AUSDIV CHAR 1
    196 .INCLU--AP 0
    197 .INCLUDE 0
    198 TRANSPORT_CHAIN Transportation Chain CHAR 10 WRF_PSCD_TCHAINH
    199 STAGING_TIME Staging Time in Days DEC 3
    200 SCHEDULING_TYPE Scheduling Procedure CHAR 1
    201 SUBMI_RELEVANT Cross Docking: Relevant for Collective Numbering CHAR 1

SAP Help, Wiki Resources, and Forum Discussions on LFA1

Click the above link for the full list of resources and help pages, only the first few are posted below

  • Please need help on vbrk and LFA1 | SCN

    I am askin for vbeln as ip from user and i want the corresponding addr(name1,ort01,land1) from LFA1 but i cant relate these 2 tables,

    http://scn.sap.com/message/3122328

  • Custom ZFields in BLFA1 | SCN

    Skip to Content We're sorry, but you're attempting to access SCN content that was not migrated to the new SAP Community experience. ...

    http://scn.sap.com/message/10255692

  • HOW TO JOIN RBKP AND LFA1...?

    In a relational database, you normally need to read data simultaneously from more than one database table into an application program. You can read from more than one table in a single SELECT statement, such that the data in the tables all has to meet the same conditions, using the following join expression:

    http://scn.sap.com/message/3563644

  • How to manage custom fields(appended to LFA1) in tab on the tx MK02/XK02

    I want to add some custom fields(appended to LFA1 and LFM1) in the tab on the tx MK02/XK02 . Which BAdI do I need to implement and what is the suitable step that I might follow?

    http://scn.sap.com/message/11150704

  • Mapping between LFA1 and  BKPF | SCN

    hi expert,

    Plz guide me how to map tables LFA1, BESG,BSET, BKPF.

    Thanks in Advance..

    Regards

    abaper.

    http://scn.sap.com/message/3304400

  • Change LFA1-KTOKK (Account group) | SCN

    Hi,

    in our R/3 are some Vendors with a wrong Account group.

    I there any possibility (Standard SAP) to change the

    group?

    Is there any possibility to check if an LAND is <> DE

    don't user Account group f. example INLA?

    Thanks for help

    Regards, Dieter

    http://scn.sap.com/message/2606986

  • Difference between title field in LFA1 table and title key filed in adrc ta

    there is any diffrence b/n title (ANRED) in LFA1 and title in ADRc table , we found that for a particular vendor different tilte in LFA1 and adrc.

    http://scn.sap.com/message/10179876

  • How to activate sap field LFA1-J_SC_CURRENCY - Toolbox for IT Groups

    This is a business requirement, I don't see it on the vendor master display screens and I don't know how to activate it.

    http://sap.ittoolbox.com/groups/technical-functional/sap-acct/how-to-activate-sap-field-lfa1j_sc_currency-4579784

  • HOW to extract data from BSEG-BKPF-LFA1? - Toolbox for IT Groups

    I have to extract data for the report preparation of list of Vendor = Suppliers.I am uploading my data into BIW through Flat File.Table LFA1 = is a vendor master ,BSEG consists of the amount field and other = important information, and BKPF is the header for BSEG.I will extract = field Posting Date from BKPF.

    http://sap.ittoolbox.com/groups/technical-functional/sap-bw/how-to-extract-data-from-bsegbkpflfa1-96882

  • Link between LFA1 and ADR6 - Toolbox for IT Groups

    Have you searched for the strings ADR or ADDR? They may be called Address or Address number.

    http://sap.ittoolbox.com/groups/technical-functional/sap-dev/link-between-lfa1-and-adr6-3096184

  • Edit the Contents of LFA1 Table [SOLVED] - Toolbox for IT Groups

    Is this in the production instance? As an SAP Security consultant, I'd love to know why a modification has to be made to a table in the production instance. Basically, it should never be done; first and foremost, you'd likely mess up more than one table, since it is possible that it exists in more than one table. Data integrity issues would then occur, which over time will cause users more headache...

    http://sap.ittoolbox.com/groups/technical-functional/sap-dev/edit-the-contents-of-lfa1-table-4496427


Related Tables

TABLE Description Functional Area
EKPO Purchasing Document Item MM - Purchasing
MARA General Material Data Logistics - Material Master
LFB1 Vendor Master (Company Code) FI - Financial Accounting
MAKT Material Descriptions Logistics - Material Master
VBAK Sales Document: Header Data SD - Sales
LFM1 Vendor master record purchasing organization data Logistics - Vendor Master
RF02K Maintain vendor master record screen and work fields LO - Vendor Master

Transaction Codes for SAP Table LFA1

TCODE Description Functional Area
SLIS FI-SL Spec.Purpose Ledg. Info.System FI - Information System
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
XK01 Create Vendor (Centrally) FI - Basic Functions
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
SE38 ABAP Editor Basis - ABAP Editor
SE16 Data Browser Basis - Workbench Utilities
MIRO Enter Incoming Invoice MM - Invoice Verification
MIGO Goods Movement MM - Inventory Management

FMs for SAP Table LFA1

FM Description Functional Area
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
REUSE_ALV_FIELDCATALOG_MERGE Create field catalog from dictionary structure or internal table BC - SAP List Viewer
REUSE_ALV_LIST_DISPLAY Output a simple list (single line or several lines) BC - SAP List Viewer
REUSE_ALV_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer
BDC_OPEN_GROUP Open batch input session for adding transactions 700 - UI Services
WS_UPLOAD OBSOLETE: Transfer Presentation Server File to Internal Table Basis - Graphic
GUI_UPLOAD Upload for Data Provider Basis - Graphical User Interface

ABAP Reports for SAP Table LFA1

ABAP REPORT Description Functional Area
SAPMF02K Vendor Master Data FI - Basic Functions
SAPLSPO1 ?...
BDCRECX1 Include f Basis - UI Services, Screen, Batch Input
SAPMF02D Customer Master Data Logistics - Customer Master
RFBIKR00 Batch Input Interface for Vendors FI - Financial Accounting
SAPLMGMM Material Master: Central Main Program
SAPLBANK ?... Cross Application - Bank
SAPMM06E Module Pool: PO History MM - Purchasing

BW Datasources for SAP Table LFA1

BW DATASOURCE Description Functional Area
0VENDOR_ATTR Vendor Number MM - Materials Management
2LIS_03_BF Goods Movements From Inventory Management MM - Materials Management
2LIS_02_ITM Purchasing Data (Item Level) MM - Materials Management
2LIS_02_HDR Purchasing Data (Header Level) MM - Materials Management
0FI_GL_4 General Ledger: Line Items with Delta Extraction FI - General Ledger Accounting
2LIS_11_VASCL Sales Document Schedule Line SD - Sales and Distribution
2LIS_13_VDITM Billing Document Item Data SD - Sales and Distribution
2LIS_04_P_ARBPL Work Center View from PP/PP-PI PP - Production Planning and Control

Authorization Objects for SAP Table LFA1

AUTHORIZATION OBJECT Description Functional Area
F_LFA1_BEK Vendor: Account Authorization
F_LFA1_AEN Vendor: Change Authorization for Certain Fields
I_TCODE PM: Transaction Code
S_TCODE Transaction Code Check at Transaction Start
S_TABU_DIS Table Maintenance (via standard tools such as SM30)
F_BKPF_KOA Accounting Document: Authorization for Account Types
P_PERNR HR: Master Data - Personnel Number Check
C_SIGN Authorization for Digital Signature

Most searched SAP Financial Accounting Tables