LFB1 is a standard Financial Accounting Transparent Table in SAP FI application, which stores Vendor Master (Company Code) 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 LFB1. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

LFB1 — Meta Data

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

LFB1 — 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 LFA1
    3 BUKRS Company Code X CHAR 4 T001
    4 PERNR Personnel No. NUMC 8
    5 .INCLUDE 0
    6 ERDAT Created on DATS 8
    7 ERNAM Created by CHAR 12
    8 SPERR Central posting block CHAR 1
    9 LOEVM Deletion Indicator CHAR 1
    10 ZUAWA Key for sorting according to assignment numbers CHAR 3 TZUN
    11 AKONT Recon. account CHAR 10 SKB1
    12 BEGRU Authorization Group CHAR 4 *
    13 VZSKZ Interest Calculation Indicator CHAR 2 T056
    14 ZWELS List of Respected Payment Methods CHAR 10
    15 XVERR Indicator: Clearing between customer and vendor ? CHAR 1
    16 ZAHLS Block Key for Payment CHAR 1 T008
    17 ZTERM Payt terms CHAR 4
    18 EIKTO Shipper's (Our) Account Number at the Customer or Vendor CHAR 12
    19 ZSABE User at customer CHAR 15
    20 KVERM Updated information in related user data field CHAR 30
    21 FDGRV Planning group CHAR 10 T035
    22 BUSAB Accounting clerk CHAR 2 T001S
    23 LNRZE Head office account number CHAR 10 LFA1
    24 LNRZB Updated information in related user data field CHAR 10 LFA1
    25 ZINDT Key Date of Last Interest Calculation DATS 8
    26 ZINRT Version Number Component NUMC 2
    27 DATLZ Date of the last interest calculation run DATS 8
    28 XDEZV Updated information in related user data field CHAR 1
    29 WEBTR Updated information in related user data field CURR 13
    30 KULTG Updated information in related user data field DEC 3
    31 REPRF Updated information in related user data field CHAR 1
    32 TOGRU Tolerance Group for G/L Accounts CHAR 4 T043G
    33 HBKID Short key for a house bank CHAR 5 T012
    34 XPORE Indicator: Single Payment CHAR 1
    35 QSZNR Certificate Number of Withholding Tax Exemption CHAR 10
    36 QSZDT Updated information in related user data field DATS 8
    37 QSSKZ Withholding Tax Code CHAR 2 *
    38 BLNKZ (Obsolete) Subsidy Ind. for Determining the Reduction Rate CHAR 2 *
    39 MINDK Updated information in related user data field CHAR 3 T059M
    40 ALTKN Previous Master Record Number CHAR 10
    41 ZGRUP Updated information in related user data field CHAR 2 TZGR
    42 MGRUP Key for Dunning Notice Grouping CHAR 2 T047R
    43 UZAWE Pmt meth.supl. CHAR 2 T042F
    44 QSREC Updated information in related user data field CHAR 2 T059A
    45 QSBGR Updated information in related user data field CHAR 1
    46 QLAND Country Key CHAR 3 T005Q
    47 XEDIP Updated information in related user data field CHAR 1
    48 FRGRP Updated information in related user data field CHAR 4 VBWF08
    49 TOGRR Updated information in related user data field CHAR 4 T169L
    50 TLFXS Accounting clerk's fax number at the customer/vendor CHAR 31
    51 INTAD Internet Address of Partner Company Clerk CHAR 130
    52 XLFZB Updated information in related user data field CHAR 1
    53 GUZTE Updated information in related user data field CHAR 4
    54 GRICD Activity Code for Gross Income Tax CHAR 2 J_1AGICD
    55 GRIDT Updated information in related user data field CHAR 2 J_1ADTYP
    56 XAUSZ Indicator for Periodic Account Statements CHAR 1 T048K
    57 CERDT Date DATS 8
    58 CONFS Status of Change Authorization (Central) CHAR 1
    59 UPDAT Update DATS 8
    60 UPTIM Time of Last Change (in UTC) TIMS 6
    61 NODEL Central deletion block for master record CHAR 1
    62 TLFNS Accounting clerk's telephone number at business partner CHAR 30
    63 AVSND Updated information in related user data field CHAR 1
    64 AD_HASH E-Mail Address for Avis: Hash Value CHAR 10
    65 CVP_XBLCK_B Updated information in related user data field CHAR 1
    66 CIIUCODE Updated information in related user data field NUMC 4
    67 .INCLUDE 0
    68 LFB1_EEW_CC CHAR 1
    69 .INCLU--AP 0
    70 ZBOKD DATS 8
    71 .INCLUDE 0
    72 ZQSSKZ CHAR 2 T059Q
    73 ZQSZDT Date (batch input) DATS 8
    74 ZQSZNR Certificate Number of the Withholding Tax Exemption CHAR 10
    75 .INCLU--AP 0
    76 ZMINDAT DATS 8
    77 .INCLU--AP 0
    78 J_SC_SUBCONTYPE Single-Character Flag CHAR 1
    79 J_SC_COMPDATE Completion Date Of Inspection NUMC 3
    80 J_SC_OFFSM Updated information in related user data field CHAR 1
    81 J_SC_OFFSR Updated information in related user data field NUMC 3
    82 .INCLU--AP 0
    83 BASIS_PNT Updated information in related user data field DEC 6
    84 .INCLU--AP 0
    85 GMVKZK Vendor is in execution CHAR 1
    86 .INCLU--AP 0
    87 BRSCH Industry key CHAR 4 T016
    88 WRBTR Amount CURR 23
    89 WAERS Currency CUKY 5 TCURC
    90 .INCLU--AP 0
    91 FORGN Foreigner(s) CHAR 1
    92 SHARE_IN_FOREIGN DEC 5
    93 NOTES Attachments CHAR 200
    94 ACTIVE Single-Character Indicator CHAR 1
    95 .INCLU--AP 0
    96 .INCLUDE 0
    97 INTERCOCD Intercompany code CHAR 4 T001
    98 RSTR_CHG_FL Restricted Mass-transaction flag CHAR 1
    99 CHECK_FLAG Replacement for Real Boolean Type: 'X' == True '' == False CHAR 1
    100 OVRD_RCPMT Override Recoupment Flag CHAR 1
    101 MIN_PAY Mininum Payment Amount CURR 6
    102 PAY_FRQ_CD Payment Frequency Code CHAR 2
    103 RECOUP_PC Recoupment Percentage DEC 5
    104 ALLOT_MTH_CD Allotee Payment Method Code CHAR 2
    105 ESCH_CD Escheat Code CHAR 1
    106 ESCHEAT_DT Escheat Date - Owner was put into escheat DATS 8
    107 .INCLU--AP 0
    108 .INCLUDE 0
    109 PREPAY_RELEVANT Updated information in related user data field CHAR 1
    110 ASSIGN_TEST Updated information in related user data field CHAR 4 WRF_ASSIGN_GRP

SAP Help, Wiki Resources, and Forum Discussions on LFB1

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


Related Tables

TABLE Description Functional Area
LFM1 Vendor master record purchasing organization data Logistics - Vendor Master
LFBK Vendor Master (Bank Details) FI - Financial Accounting
LFA1 Vendor Master (General Section) FI - Financial Accounting
LFB5 Vendor master (dunning data) FI - Financial Accounting
EKPO Purchasing Document Item MM - Purchasing
RF02K Maintain vendor master record screen and work fields LO - Vendor Master
MARA General Material Data Logistics - Material Master

Transaction Codes for SAP Table LFB1

TCODE Description Functional Area
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
MIRO Enter Incoming Invoice MM - Invoice Verification
XK01 Create Vendor (Centrally) FI - Basic Functions
MIGO Goods Movement MM - Inventory Management
ME21N Create Purchase Order MM - Purchasing
SE16 Data Browser Basis - Workbench Utilities
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
F110 Parameters for Automatic Payment FI - Financial Accounting

FMs for SAP Table LFB1

FM Description Functional Area
WS_UPLOAD OBSOLETE: Transfer Presentation Server File to Internal Table Basis - Graphic
GUI_UPLOAD Upload for Data Provider Basis - Graphical User Interface
BDC_OPEN_GROUP Open batch input session for adding transactions 700 - UI Services
BDC_INSERT Insert batch input transactions in batch input session 700 - UI Services
BDC_CLOSE_GROUP Close batch input session 700 - UI Services
F4_FILENAME F4 for filename / Filemanager support to locate file in a directory PM - Plant Maintenance
FORMAT_MESSAGE BC - Print and Output Management
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer

ABAP Reports for SAP Table LFB1

ABAP REPORT Description Functional Area
SAPMF02K Vendor Master Data FI - Basic Functions
SAPLSPO1 ?...
BDCRECX1 Include f Basis - UI Services, Screen, Batch Input
SAPMM06E Module Pool: PO History MM - Purchasing
SAPMM06B Module Pool: Purchase Requisitions MM - Purchasing
SPRSL TEXT 630 - Workbench Tools: Editors
RSBDCSUB Batch Input: Process All Sessions Basis - UI Services, Screen, Batch Input
SAPMV45A Sales Order Processing SD - Sales

BW Datasources for SAP Table LFB1

BW DATASOURCE Description Functional Area
0VENDOR_ATTR Vendor Number MM - Materials Management
0FI_GL_4 General Ledger: Line Items with Delta Extraction FI - General Ledger Accounting
2LIS_02_ITM Purchasing Data (Item Level) MM - Materials Management
0FI_AP_4 Vendors: Line Items with Delta Extrcation FI - Accounts Payable
2LIS_02_SGR Produced Activity: Delivery of Schedule Lines MM - Materials Management
2LIS_13_VDITM Billing Document Item Data SD - Sales and Distribution
2LIS_02_SCL Purchasing Data (Schedule Line Level) MM - Materials Management
2LIS_03_BF Goods Movements From Inventory Management MM - Materials Management

Authorization Objects for SAP Table LFB1

AUTHORIZATION OBJECT Description Functional Area
C_SIGN Authorization for Digital Signature
S_ADMI_FCD System Authorizations
P_TCODE HR: Transaction codes
F_LFA1_BEK Vendor: Account Authorization
F_BKPF_KOA Accounting Document: Authorization for Account Types
F_BKPF_BEK Accounting Document: Account Authorization for Vendors
F_BKPF_BUK Accounting Document: Authorization for Company Codes