SAP TABLES | Logistics - General | Logistics Basic Data | Vendor Master(LO-MD-BP-VM) SAP LO

LFB1 SAP Vendor Master (Company Code) Table








LFB1 is a standard SAP Table which is used to store Vendor Master (Company Code) information. This 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 Table LFB1 and the data within it using relevant SAP 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


Dictionary fields for SAP Table LFB1




FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
LIFNRLIFNRCHAR10 LFA1Account Number of Vendor or CreditorALPHA
BUKRSBUKRSCHAR4 T001Company Code
PERNRPERNR_DNUMC8 Personnel Number
.INCLUDESI_LFB1 Vendor Master (Company Code)
ERDATERDAT_RFDATS8 Date on which the Record Was Created
ERNAMERNAM_RFCHAR12 Name of Person who Created the Object
SPERRSPERB_BCHAR1 Posting block for company code
LOEVMLOEVM_BCHAR1 Deletion Flag for Master Record (Company Code Level)
ZUAWADZUAWACHAR3 TZUNKey for sorting according to assignment numbers
AKONTAKONTCHAR10 SKB1Reconciliation Account in General LedgerALPHA
BEGRUBRGRUCHAR4
*
Authorization Group
VZSKZVZSKZCHAR2 T056Interest calculation indicator
ZWELSDZWELSCHAR10 List of the Payment Methods to be Considered
XVERRXVERR_LFB1CHAR1 Indicator: Clearing between customer and vendor?
ZAHLSDZAHLSCHAR1 T008Block Key for Payment
ZTERMDZTERMCHAR4 Terms of Payment Key
EIKTOEIKTO_KCHAR12 Our account number with the vendor
ZSABEDZSABE_KCHAR15 Clerk at vendor
KVERMKVERMCHAR30 Memo
FDGRVFDGRVCHAR10 T035Planning groupALPHA
BUSABBUSABCHAR2 T001SAccounting clerk
LNRZELNRZECHAR10 LFA1Head office account numberALPHA
LNRZBLNRZBCHAR10 LFA1Account number of the alternative payeeALPHA
ZINDTDZINDTDATS8 Key date of the last interest calculation
ZINRTDZINRTNUMC2 Interest calculation frequency in months
DATLZDATLZDATS8 Date of the last interest calculation run
XDEZVXDEZVCHAR1 Indicator: Local processing?
WEBTRWEBTRCURR13(2) Bill of exchange limit (in local currency)
KULTGKULTGDEC3 Probable time until check is paid
REPRFREPRFCHAR1 Check Flag for Double Invoices or Credit Memos
TOGRUTOGRUCHAR4 T043GTolerance group for the business partner/G/L account
HBKIDHBKIDCHAR5 T012Short Key for a House Bank
XPOREXPORECHAR1 Indicator: Pay all items separately ?
QSZNRQSZNRCHAR10 Certificate Number of the Withholding Tax Exemption
QSZDTQSZDTDATS8 Validity Date for Withholding Tax Exemption Certificate
QSSKZQSSKZCHAR2
*
Withholding Tax Code
BLNKZBLNKZCHAR2
*
Subsidy indicator for determining the reduction rates
MINDKMINDKCHAR3 T059MMinority Indicators
ALTKNALTKNCHAR10 Previous Master Record Number

ZGRUPDZGRUPCHAR2 TZGRKey for Payment Grouping
MGRUPMGRUPCHAR2 T047RKey for dunning notice grouping
UZAWEUZAWECHAR2 T042FPayment Method Supplement
QSRECQSRECCHAR2 T059AVendor Recipient Type
QSBGRQSBGRCHAR1 Authority for Exemption from Withholding Tax
QLANDQLANDCHAR3 T005QWithholding Tax Country Key
XEDIPXEDIPCHAR1 Indicator: Send Payment Advices by EDI
FRGRPFRGRPCHAR4 VBWF08Release Approval Group
TOGRRTOGRRCHAR4 T169LTolerance group; Invoice Verification
TLFXSTLFXSCHAR31 Accounting clerk's fax number at the customer/vendor
INTADINTADCHAR130 Internet address of partner company clerk
XLFZBXLFZBCHAR1 Indicator: Alternative payee using account number
GUZTEGUZTECHAR4 Payment Terms Key for Credit Memos
GRICDJ_1AGICD_DCHAR2 J_1AGICDActivity Code for Gross Income Tax
GRIDTJ_1ADTYP_DCHAR2 J_1ADTYPDistribution Type for Employment Tax
XAUSZXAUSZCHAR1 T048KIndicator for periodic account statements
CERDTCERDTDATS8 Certification date
CONFSCONFS_BCHAR1 Status of Change Authorization (Company Code Level)
UPDATUPDAT_RFDATS8 Date on Which the Changes Were Confirmed
UPTIMUPTIM_RFTIMS6 Time of Last Change Confirmation
NODELNODEL_BCHAR1 Deletion bock for master record (company code level)
TLFNSTLFNSCHAR30 Accounting clerk's telephone number at business partner
AVSNDAVSNDCHAR1 Indicator: Send Payment Advice by XML
AD_HASHADHASHCHAR10 E-Mail Address for Avis: Hash Value
J_SC_SUBCONTYPE/SAPNEA/J_SC_SUBCONTYPECHAR1 Subcontractor Type
J_SC_COMPDATE/SAPNEA/J_SC_COMPLETIONDATENUMC3 Completion Date Of Inspection
J_SC_OFFSM/SAPNEA/J_SC_OFFSMCHAR1 Offset Method
J_SC_OFFSR/SAPNEA/J_SC_OFFSRNUMC3 Offset Percentage
.APPENDALFB1_FMFG PS fields for company code-specific master data field
BASIS_PNTFMBASIS_POINTSDEC6(3) Average daily basis points for purchase cards
.APPENDALFB1_PSO IS-PS: Data Appendix Vendor Master Record (Company Code)
GMVKZKGMVKZKCHAR1 Vendor is in execution
.APPENDWRF_LFB1_APPEND LFB1 Extension with New Fields - Seasonal Procurement
.INCLUDEWRF_LFB1_STY LFB1 Extension with New Fields - Seasonal Procurement
PREPAY_RELEVANTWRF_PREPAY_RELEVANTCHAR1 Prepayment Relevance (Vendor Master)
ASSIGN_TESTWRF_MRM_ASSIGN_GROUPCHAR4 WRF_ASSIGN_GRPAssignment Test Group


Key field
Non-key field


RELATIONS BETWEEN LFB1 AND 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