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
- Vendor Master Tables
- Customer Master Tables
- Company Codes Tables
- Tax Code Tables
- Gl Account Tables
- Gl Account Master Tables
- Bank Account Tables
- Withholding Tax Tables
- Payment Term Tables
- Region Tables
- Bank Details Tables
- Company Code Tables
- Payment Method Tables
- Asset Tables
- Transaction Type Tables
- Tax Jurisdiction Tables
- Customer Tables
- Vendor Tables
- Business Area Tables
- Payment Tables
- Plant Company Code Tables
- Account Assignment Tables