SAP table LFB1 (Vendor Master (Company Code))

The LFB1 table in SAP contains company code-specific data for vendors. It complements the general vendor data stored in the LFA1 table by adding financial and accounting details for each company code.

Key Features:

The LFB1 table is critical for ensuring proper financial integration and management of vendors in SAP.

SAP table LFB1 has 3 primary key fields being MANDT,LIFNR,BUKRS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
BUKRS Company Code CHAR 4 0 T001 BUKRS
PERNR Personnel Number NUMC 8 0 PERNR_D
ERDAT Date on which the Record Was Created DATS 8 0 ERDAT_RF
ERNAM Name of Person who Created the Object CHAR 12 0 ERNAM_RF
SPERR Posting block for company code CHAR 1 0 SPERB_B
LOEVM Deletion Flag for Master Record (Company Code Level) CHAR 1 0 LOEVM_B
ZUAWA Key for sorting according to assignment numbers CHAR 3 0 TZUN DZUAWA
AKONT Reconciliation Account in General Ledger CHAR 10 0 SKB1 AKONT
BEGRU Authorization Group CHAR 4 0 * BRGRU
VZSKZ Interest Indicator CHAR 2 0 T056 VZSKZ
ZWELS List of Respected Payment Methods CHAR 10 0 DZWELS
XVERR Indicator: Clearing between customer and vendor? CHAR 1 0 XVERR_LFB1
ZAHLS Block Key for Payment CHAR 1 0 T008 DZAHLS
ZTERM Terms of payment key CHAR 4 0 DZTERM
EIKTO Our account number with the vendor CHAR 12 0 EIKTO_K
ZSABE Clerk at vendor CHAR 15 0 DZSABE_K
KVERM Memo CHAR 30 0 KVERM
FDGRV Planning Group CHAR 10 0 T035 FDGRV
BUSAB Accounting Clerk Abbreviation CHAR 2 0 T001S BUSAB
LNRZE Head office account number CHAR 10 0 LFA1 LNRZE
LNRZB Account number of the alternative payee CHAR 10 0 LFA1 LNRZB
ZINDT Key Date of Last Interest Calculation DATS 8 0 DZINDT
ZINRT Interest Calculation Frequency in Months NUMC 2 0 DZINRT
DATLZ Date of Last Interest Calculation Run DATS 8 0 DATLZ
XDEZV Indicator: Local Processing? CHAR 1 0 XDEZV
WEBTR Bill of Exchange Limit (in Local Currency) CURR 13 2 WEBTR_CS
KULTG Probable Time Until Check Is Paid DEC 3 0 KULTG
REPRF Check Flag for Double Invoices or Credit Memos CHAR 1 0 REPRF
TOGRU Tolerance Group for Business Partner/G/L Account CHAR 4 0 T043G TOGRU
HBKID Short Key for a House Bank CHAR 5 0 T012 HBKID
XPORE Indicator: Pay All Items Separately? CHAR 1 0 XPORE
QSZNR Certificate Number of the Withholding Tax Exemption CHAR 10 0 QSZNR
QSZDT Validity Date for Withholding Tax Exemption Certificate DATS 8 0 QSZDT
QSSKZ Withholding Tax Code CHAR 2 0 * QSSKZ
BLNKZ (Obsolete) Subsidy Ind. for Determining the Reduction Rate CHAR 2 0 * BLNKZ
MINDK Minority Indicator CHAR 3 0 T059M MINDK
ALTKN Previous Master Record Number CHAR 10 0 ALTKN
ZGRUP Key for Payment Grouping CHAR 2 0 TZGR DZGRUP
MGRUP Key for Dunning Notice Grouping CHAR 2 0 T047R MGRUP
UZAWE Payment method supplement CHAR 2 0 T042F UZAWE
QSREC Vendor Recipient Type CHAR 2 0 T059A QSREC
QSBGR Authority for Exemption from Withholding Tax CHAR 1 0 QSBGR
0 No Exemption Reason Reported
1 Income Connected with a Company in the USA
2 Exempt due to an IRS Code
3 Income not from the USA
4 Exempt due to a Tax Agreement
5 Interest Exemption Portfolio for Internal Revenue Code Sect.
6 Intermediary with Responsibility for Withholding Tax Amount
7 Foreign Private Limited Company / Trust with WH Tax Oblig.
8 U.S. Branch with Status of a U.S. Person
9 Revenues in Accord. with Qualified Intermediary: Tax-Exempt
A Securities Lender for Replacement Dividends
QLAND Withholding Tax Country/Region Key CHAR 3 0 T005Q QLAND
XEDIP Indicator: Send Payment Advices by EDI CHAR 1 0 XEDIP
FRGRP Release Approval Group CHAR 4 0 VBWF08 FRGRP
TOGRR Tolerance Group in Invoice Verification CHAR 4 0 T169L TOGRR
TLFXS Accounting clerk's fax number at the customer/vendor CHAR 31 0 TLFXS
INTAD Internet address of partner company clerk CHAR 130 0 INTAD
XLFZB Indicator: Alternative Payee Using Account Number CHAR 1 0 XLFZB
GUZTE Payment Terms Key for Credit Memos CHAR 4 0 GUZTE
GRICD Activity Code for Gross Income Tax CHAR 2 0 J_1AGICD J_1AGICD_D
GRIDT Distribution Type for Employment Tax CHAR 2 0 J_1ADTYP J_1ADTYP_D
XAUSZ Indicator for Periodic Account Statements CHAR 1 0 T048K XAUSZ
CERDT Certification Date DATS 8 0 CERDT
CONFS Status of Change Authorization (Company Code Level) CHAR 1 0 CONFS_B
UPDAT Date on Which the Changes Were Confirmed DATS 8 0 UPDAT_RF
UPTIM Time of Last Change Confirmation TIMS 6 0 UPTIM_RF
NODEL Deletion bock for master record (company code level) CHAR 1 0 NODEL_B
TLFNS Accounting clerk's telephone number at business partner CHAR 30 0 TLFNS
AVSND Indicator: Send Payment Advice by XML CHAR 1 0 AVSND
X Without E-mail
Y With E-mail
AD_HASH E-Mail Address for Avis: Hash Value CHAR 10 0 ADHASH
CVP_XBLCK_B Business Purpose Completed Flag CHAR 1 0 CVP_XBLCK
not blocked
X blocked
CIIUCODE Main economic activity NUMC 4 0 CIIUCODE
PAYMENTCLEARINGGRPID Payment Clearing Group ID CHAR 8 0 FAR_PYMT_CLG_GRP FAR_PAYMENT_CLEARING_GROUP
PAYTRSN Payment Reason CHAR 4 0 * FARP_PAYT_RSN
LFB1_EEW_CC Dataelement for the Extension Company Code CHAR 1 0 LFB1_EEW_CC
ZBOKD LEDGER MANAGEMENT EXPIRATION DATE DATS 8 0 /ATL/VBOKD
ZQSSKZ Future Withholding tax code CHAR 2 0 T059Q /ATL/VQSSKZ
ZQSZDT Validity date for withholding tax exemption certificate DATS 8 0 /ATL/VQSZDT
ZQSZNR Certificate number of the withholding tax exemption CHAR 10 0 /ATL/VQSZNR
ZMINDAT Certification date for minimum wage DATS 8 0 /ATL/VMINDAT
J_SC_SUBCONTYPE Subcontractor Type CHAR 1 0 /SAPNEA/J_SC_SUBCONTYPE
Not subcontractor with chargeable component
1 Subcontractor (Covered by Subcontracting Act)
2 Subcontractor (Not Covered by Subcontracting Act)
J_SC_COMPDATE Completion Date Of Inspection NUMC 3 0 /SAPNEA/J_SC_COMPLETIONDATE
J_SC_OFFSM Offset Method CHAR 1 0 /SAPNEA/J_SC_OFFSM
No Offset
1 Inventory-Based Offset
2 Consumption-Based Offset
3 Percentage-Based Offset
4 Payment Condition Offset
J_SC_OFFSR Offset Percentage NUMC 3 0 /SAPNEA/J_SC_OFFSR
BASIS_PNT Average daily basis points for purchase cards DEC 6 3 FMBASIS_POINTS
GMVKZK Vendor is in execution CHAR 1 0 GMVKZK
BRSCH Industry key CHAR 4 0 T016 BRSCH
WRBTR Amount for Payment Program CURR 23 2 KR_AMOUNT
WAERS Currency Key CUKY 5 0 TCURC WAERS
FORGN Foreign Shareholder CHAR 1 0 FIWTKW_LOCALITY
SHARE_IN_FOREIGN Share in Dividend Paying Company DEC 5 2 FIWTKW_OWNED_SHARE
NOTES Notes CHAR 200 0 FIWTKW_NOTES
ACTIVE Boolean Variable ('X'=Shareholder is active, ''=not active) CHAR 1 0 FIWTKW_SHR_ACTIVE
US_REC_COUNTRY Country/Region Key CHAR 3 0 * LAND1
US_GIIN US Recipient GIIN CHAR 19 0 FIWTUS_RECIPIENT_GIIN
US_FTID US Recipient Foreign Tax ID CHAR 22 0 FIWTUS_RECIPIENT_FTID
US_REC_DOB US Recipient Date Of Birth DATS 8 0 FIWTUS_RECIPIENT_DOB
US_LOB_CODE LOB Treaty Code CHAR 2 0 FIWTUS_LOB_CODE
US_W8_RECVDATE US W8 Form Received Date DATS 8 0 FIWTUS_W8_RECV_DATE
US_W9_RECVDATE US W8 Form Received Date DATS 8 0 FIWTUS_W9_RECV_DATE
US_TIN_NOTICE Second TIN Notice from IRS CHAR 1 0 FIWTUS_SECOND_TIN_NOTICE
US_PARTNERSHIP_IND Partnership Interest Indicator CHAR 1 0 FIWTUS_PARTNERSHIP_IND
US_FATCA_IND US FATCA Indicator CHAR 1 0 FIWTUS_FATCA_IND
PREPAY_RELEVANT Prepayment Relevance (Supplier Master) CHAR 1 0 WRF_PREPAY_RELEVANT
Prepayment Not Allowed
A Prepayment Requested
B Prepayment Not Requested Before GR Effected
C Prepayment Possible, but Not Planned
ASSIGN_TEST Assignment Test Group CHAR 4 0 WRF_ASSIGN_GRP WRF_MRM_ASSIGN_GROUP

LFB1 foreign key relationships

Table Field Check Table Check Field
0 LFB1 AKONT SKB1 G/L account master (company code) MANDT
0 LFB1 AKONT SKB1 G/L account master (company code) BUKRS
1 LFB1 ASSIGN_TEST WRF_ASSIGN_GRP Assignment Test Group MANDT
1 LFB1 ASSIGN_TEST WRF_ASSIGN_GRP Assignment Test Group BUKRS
1 LFB1 ASSIGN_TEST WRF_ASSIGN_GRP Assignment Test Group ASSIGN_GROUP
0 LFB1 BRSCH T016 Industries BRSCH
1 LFB1 BUKRS T001 Company Codes BUKRS
0 LFB1 BUSAB T001S Accounting Clerks MANDT
0 LFB1 BUSAB T001S Accounting Clerks BUKRS
0 LFB1 BUSAB T001S Accounting Clerks BUSAB
1 LFB1 FDGRV T035 Planning groups GRUPP
0 LFB1 FRGRP VBWF08 Release Groups MANDT
0 LFB1 FRGRP VBWF08 Release Groups FRGRP
1 LFB1 GRICD J_1AGICD Activity codes for gross income tax declaration MANDT
1 LFB1 GRICD J_1AGICD Activity codes for gross income tax declaration LAND1
0 LFB1 GRIDT J_1ADTYP Distribution Types for Gross Income Tax MANDT
0 LFB1 GRIDT J_1ADTYP Distribution Types for Gross Income Tax BUKRS
1 LFB1 HBKID T012 House Banks BUKRS
0 LFB1 LIFNR LFA1 Supplier Master (General Section) MANDT
0 LFB1 LIFNR LFA1 Supplier Master (General Section) LIFNR
1 LFB1 LNRZB LFA1 Supplier Master (General Section) MANDT
1 LFB1 LNRZB LFA1 Supplier Master (General Section) LIFNR
0 LFB1 LNRZE LFA1 Supplier Master (General Section) MANDT
0 LFB1 LNRZE LFA1 Supplier Master (General Section) LIFNR
1 LFB1 MANDT T000 Clients MANDT
0 LFB1 MGRUP T047R Grouping rules for dunning notices MANDT
0 LFB1 MGRUP T047R Grouping rules for dunning notices MGRUP
1 LFB1 MINDK T059M Minority Indicators MANDT
0 LFB1 QLAND T005Q Country Keys for Withholding Tax Calculation MANDT
0 LFB1 QLAND T005Q Country Keys for Withholding Tax Calculation LAND1
1 LFB1 QSREC T059A Type of Recipient For Vendors MANDT
1 LFB1 QSREC T059A Type of Recipient For Vendors LAND1
1 LFB1 QSREC T059A Type of Recipient For Vendors QSREC
0 LFB1 TOGRR T169L Supplier-Specific Parameters for Invoice Verification MANDT
0 LFB1 TOGRR T169L Supplier-Specific Parameters for Invoice Verification BUKRS
1 LFB1 TOGRU T043G Tolerances for Groups of Customers/Vendors MANDT
1 LFB1 TOGRU T043G Tolerances for Groups of Customers/Vendors BUKRS
1 LFB1 TOGRU T043G Tolerances for Groups of Customers/Vendors TOGRU
0 LFB1 UZAWE T042F Payment method supplements MANDT
0 LFB1 UZAWE T042F Payment method supplements UZAWE
1 LFB1 VZSKZ T056 Interest Indicator MANDT
1 LFB1 VZSKZ T056 Interest Indicator VZSKZ
0 LFB1 WAERS TCURC Currency Codes MANDT
0 LFB1 WAERS TCURC Currency Codes WAERS
1 LFB1 XAUSZ T048K Indicator for Periodic Account Statements MANDT
1 LFB1 XAUSZ T048K Indicator for Periodic Account Statements XAUSZ
0 LFB1 ZAHLS T008 Blocking Reasons for Automatic Payment Transcations MANDT
0 LFB1 ZAHLS T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
1 LFB1 ZGRUP TZGR Grouping rules for automatic payments ZGRUP
0 LFB1 ZQSSKZ T059Q Withholding Tax MANDT
0 LFB1 ZQSSKZ T059Q Withholding Tax LAND1
0 LFB1 ZQSSKZ T059Q Withholding Tax QSSKZ