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

LFB1 SAP Vendor Master (Company Code) Table and data







LFB1 is a standard SAP Table which is used to store Vendor Master (Company Code) 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 LFB1 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 LFB1 Table fields within data Dictionary




FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3T000Client
LIFNRLIFNRCHAR10LFA1Account Number of Vendor or CreditorALPHA
BUKRSBUKRSCHAR4T001Company Code
PERNRPERNR_DNUMC8Personnel Number
.INCLUDESI_LFB1Vendor Master (Company Code)
ERDATERDAT_RFDATS8Date on which the Record Was Created
ERNAMERNAM_RFCHAR12Name of Person who Created the Object
SPERRSPERB_BCHAR1Posting block for company code
LOEVMLOEVM_BCHAR1Deletion Flag for Master Record (Company Code Level)
ZUAWADZUAWACHAR3TZUNKey for sorting according to assignment numbers
AKONTAKONTCHAR10SKB1Reconciliation Account in General LedgerALPHA
BEGRUBRGRUCHAR4
*
Authorization Group
VZSKZVZSKZCHAR2T056Interest calculation indicator
ZWELSDZWELSCHAR10List of the Payment Methods to be Considered
XVERRXVERR_LFB1CHAR1Indicator: Clearing between customer and vendor?
ZAHLSDZAHLSCHAR1T008Block Key for Payment
ZTERMDZTERMCHAR4Terms of Payment Key
EIKTOEIKTO_KCHAR12Our account number with the vendor
ZSABEDZSABE_KCHAR15Clerk at vendor
KVERMKVERMCHAR30Memo
FDGRVFDGRVCHAR10T035Planning groupALPHA
BUSABBUSABCHAR2T001SAccounting clerk
LNRZELNRZECHAR10LFA1Head office account numberALPHA
LNRZBLNRZBCHAR10LFA1Account number of the alternative payeeALPHA
ZINDTDZINDTDATS8Key date of the last interest calculation
ZINRTDZINRTNUMC2Interest calculation frequency in months
DATLZDATLZDATS8Date of the last interest calculation run
XDEZVXDEZVCHAR1Indicator: Local processing?
WEBTRWEBTRCURR13(2)Bill of exchange limit (in local currency)
KULTGKULTGDEC3Probable time until check is paid
REPRFREPRFCHAR1Check Flag for Double Invoices or Credit Memos
TOGRUTOGRUCHAR4T043GTolerance group for the business partner/G/L account
HBKIDHBKIDCHAR5T012Short Key for a House Bank
XPOREXPORECHAR1Indicator: Pay all items separately ?
QSZNRQSZNRCHAR10Certificate Number of the Withholding Tax Exemption
QSZDTQSZDTDATS8Validity Date for Withholding Tax Exemption Certificate
QSSKZQSSKZCHAR2
*
Withholding Tax Code
BLNKZBLNKZCHAR2
*
Subsidy indicator for determining the reduction rates
MINDKMINDKCHAR3T059MMinority Indicators
ALTKNALTKNCHAR10Previous Master Record Number

ZGRUPDZGRUPCHAR2TZGRKey for Payment Grouping
MGRUPMGRUPCHAR2T047RKey for dunning notice grouping
UZAWEUZAWECHAR2T042FPayment Method Supplement
QSRECQSRECCHAR2T059AVendor Recipient Type
QSBGRQSBGRCHAR1Authority for Exemption from Withholding Tax
QLANDQLANDCHAR3T005QWithholding Tax Country Key
XEDIPXEDIPCHAR1Indicator: Send Payment Advices by EDI
FRGRPFRGRPCHAR4VBWF08Release Approval Group
TOGRRTOGRRCHAR4T169LTolerance group; Invoice Verification
TLFXSTLFXSCHAR31Accounting clerk's fax number at the customer/vendor
INTADINTADCHAR130Internet address of partner company clerk
XLFZBXLFZBCHAR1Indicator: Alternative payee using account number
GUZTEGUZTECHAR4Payment Terms Key for Credit Memos
GRICDJ_1AGICD_DCHAR2J_1AGICDActivity Code for Gross Income Tax
GRIDTJ_1ADTYP_DCHAR2J_1ADTYPDistribution Type for Employment Tax
XAUSZXAUSZCHAR1T048KIndicator for periodic account statements
CERDTCERDTDATS8Certification date
CONFSCONFS_BCHAR1Status of Change Authorization (Company Code Level)
UPDATUPDAT_RFDATS8Date on Which the Changes Were Confirmed
UPTIMUPTIM_RFTIMS6Time of Last Change Confirmation
NODELNODEL_BCHAR1Deletion bock for master record (company code level)
TLFNSTLFNSCHAR30Accounting clerk's telephone number at business partner
AVSNDAVSNDCHAR1Indicator: Send Payment Advice by XML
AD_HASHADHASHCHAR10E-Mail Address for Avis: Hash Value
.APPEND/SAPNEA/J_SC_LFB1Subcontracting Management
J_SC_SUBCONTYPE/SAPNEA/J_SC_SUBCONTYPECHAR1Subcontractor Type
J_SC_COMPDATE/SAPNEA/J_SC_COMPLETIONDATENUMC3Completion Date Of Inspection
J_SC_OFFSM/SAPNEA/J_SC_OFFSMCHAR1Offset Method
J_SC_OFFSR/SAPNEA/J_SC_OFFSRNUMC3Offset Percentage
.APPENDALFB1_FMFGPS fields for company code-specific master data field
BASIS_PNTFMBASIS_POINTSDEC6(3)Average daily basis points for purchase cards
.APPENDALFB1_PSOIS-PS: Data Appendix Vendor Master Record (Company Code)
GMVKZKGMVKZKCHAR1Vendor is in execution
.APPENDWRF_LFB1_APPENDLFB1 Extension with New Fields - Seasonal Procurement
.INCLUDEWRF_LFB1_STYLFB1 Extension with New Fields - Seasonal Procurement
PREPAY_RELEVANTWRF_PREPAY_RELEVANTCHAR1Prepayment Relevance (Vendor Master)
ASSIGN_TESTWRF_MRM_ASSIGN_GROUPCHAR4WRF_ASSIGN_GRPAssignment Test Group



Key field
Non-key field

LFB1 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