1. Home
  2. Resources
  3. SAP Tables
  4. LFB1 - Vendor Master (Company Code)

SAP Table LFB1

Vendor Master (Company Code)

LFB1 (Vendor Master (Company Code)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link LFB1 to other SAP tables.

LFB1 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
BUKRS Company Code BUKRS T001 CHAR 4 0
PERNR Personnel Number PERNR_D NUMC 8 0
ERDAT Date on which the Record Was Created ERDAT_RF DATS 8 0
ERNAM Name of Person who Created the Object ERNAM_RF CHAR 12 0
SPERR Posting block for company code SPERB_B CHAR 1 0
X Yes
NULL No
LOEVM Deletion Flag for Master Record (Company Code Level) LOEVM_B CHAR 1 0
X Yes
NULL No
ZUAWA Key for sorting according to assignment numbers DZUAWA TZUN CHAR 3 0
AKONT Reconciliation Account in General Ledger AKONT SKB1 CHAR 10 0
BEGRU Authorization Group BRGRU CHAR 4 0
VZSKZ Interest calculation indicator VZSKZ T056 CHAR 2 0
ZWELS List of the Payment Methods to be Considered DZWELS CHAR 10 0
XVERR Indicator: Clearing between customer and vendor? XVERR_LFB1 CHAR 1 0
X Yes
NULL No
ZAHLS Block Key for Payment DZAHLS T008 CHAR 1 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
EIKTO Our account number with the vendor EIKTO_K CHAR 12 0
ZSABE Clerk at vendor DZSABE_K CHAR 15 0
KVERM Memo KVERM CHAR 30 0
FDGRV Planning group FDGRV T035 CHAR 10 0
BUSAB Accounting clerk BUSAB T001S CHAR 2 0
LNRZE Head office account number LNRZE LFA1 CHAR 10 0
LNRZB Account number of the alternative payee LNRZB LFA1 CHAR 10 0
ZINDT Key date of the last interest calculation DZINDT DATS 8 0
ZINRT Interest calculation frequency in months DZINRT NUMC 2 0
01 1 month
02 2 months
03 3 months
04 4 months
05 5 months
06 6 months
07 7 months
08 8 months
09 9 months
10 10 months
11 11 months
12 12 months
DATLZ Date of the last interest calculation run DATLZ DATS 8 0
XDEZV Indicator: Local processing? XDEZV CHAR 1 0
X Yes
NULL No
WEBTR Bill of exchange limit (in local currency) WEBTR CURR 13 2
KULTG Probable time until check is paid KULTG DEC 3 0
REPRF Check Flag for Double Invoices or Credit Memos REPRF CHAR 1 0
X Yes
NULL No
TOGRU Tolerance group for the business partner/G/L account TOGRU T043G CHAR 4 0
HBKID Short Key for a House Bank HBKID T012 CHAR 5 0
XPORE Indicator: Pay all items separately ? XPORE CHAR 1 0
X Yes
NULL No
QSZNR Certificate Number of the Withholding Tax Exemption QSZNR CHAR 10 0
QSZDT Validity Date for Withholding Tax Exemption Certificate QSZDT DATS 8 0
QSSKZ Withholding Tax Code QSSKZ CHAR 2 0
BLNKZ Subsidy indicator for determining the reduction rates BLNKZ CHAR 2 0
MINDK Minority Indicators MINDK T059M CHAR 3 0
ALTKN Previous Master Record Number ALTKN CHAR 10 0
ZGRUP Key for Payment Grouping DZGRUP TZGR CHAR 2 0
MGRUP Key for dunning notice grouping MGRUP T047R CHAR 2 0
UZAWE Payment Method Supplement UZAWE T042F CHAR 2 0
QSREC Vendor Recipient Type QSREC T059A CHAR 2 0
QSBGR Authority for Exemption from Withholding Tax QSBGR CHAR 1 0
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 Key QLAND T005Q CHAR 3 0
XEDIP Indicator: Send Payment Advices by EDI XEDIP CHAR 1 0
X Yes
NULL No
FRGRP Release Approval Group FRGRP VBWF08 CHAR 4 0
TOGRR Tolerance group; Invoice Verification TOGRR T169L CHAR 4 0
TLFXS Accounting clerk's fax number at the customer/vendor TLFXS CHAR 31 0
INTAD Internet address of partner company clerk INTAD CHAR 130 0
XLFZB Indicator: Alternative payee using account number XLFZB CHAR 1 0
X Yes
NULL No
GUZTE Payment Terms Key for Credit Memos GUZTE CHAR 4 0
GRICD Activity Code for Gross Income Tax J_1AGICD_D J_1AGICD CHAR 2 0
GRIDT Distribution Type for Employment Tax J_1ADTYP_D J_1ADTYP CHAR 2 0
XAUSZ Indicator for periodic account statements XAUSZ T048K CHAR 1 0
CERDT Certification date CERDT DATS 8 0
CONFS Status of Change Authorization (Company Code Level) CONFS_B CHAR 1 0
UPDAT Date on Which the Changes Were Confirmed UPDAT_RF DATS 8 0
UPTIM Time of Last Change Confirmation UPTIM_RF TIMS 6 0
NODEL Deletion bock for master record (company code level) NODEL_B CHAR 1 0
X Yes
NULL No
TLFNS Accounting clerk's telephone number at business partner TLFNS CHAR 30 0
AVSND Indicator: Send Payment Advice by XML AVSND CHAR 1 0
X Without E-mail
Y With E-mail
AD_HASH E-Mail Address for Avis: Hash Value ADHASH CHAR 10 0
J_SC_SUBCONTYPE Subcontractor Type /SAPNEA/J_SC_SUBCONTYPE CHAR 1 0
NULL 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 /SAPNEA/J_SC_COMPLETIONDATE NUMC 3 0
J_SC_OFFSM Offset Method /SAPNEA/J_SC_OFFSM CHAR 1 0
1 Inventory-Based Offset
2 Consumption-Based Offset
3 Percentage-Based Offset
4 Payment Condition Offset
NULL No Offset
J_SC_OFFSR Offset Percentage /SAPNEA/J_SC_OFFSR NUMC 3 0
BASIS_PNT Average daily basis points for purchase cards FMBASIS_POINTS DEC 6 3
GMVKZK Vendor is in execution GMVKZK CHAR 1 0
X Yes
NULL No
INTERCOCD Intercompany code OIU_INTERCOCD T001 CHAR 4 0
RSTR_CHG_FL Restricted Mass-transaction flag OIU_RSTR_CHG_FL CHAR 1 0
X Active
NULL Inactive
CHECK_FLAG ID that the owner's check needs to be printed 1st. OIU_CHECK_FLAG CHAR 1 0
X Active
NULL Inactive
OVRD_RCPMT Override Recoupment Flag OIU_OVRD_RCPMT CHAR 1 0
X Active
NULL Inactive
MIN_PAY Mininum Payment Amount OIU_MIN_PAY CURR 6 2
PAY_FRQ_CD Payment Frequency Code OIU_PAY_FRQ_CD CHAR 2 0
01 Normal
02 Quarterly
03 Semi-annually
04 Annually
05 Pay regardless
06 Not applicable
07 Texas annual pay
NULL
RECOUP_PC Recoupment Percentage OIU_RECOUP_PC DEC 5 2
ALLOT_MTH_CD Allotee Payment Method Code OIU_ALLOT_MTH_CD CHAR 2 0
01 Checks to MMS
02 Payments to others
03 EFT to MMS
04 Royalty-in-kind
05 Checks to MMS for BIA
06 EFT to BIA - disconnected
07 Lockbox payments
NULL
ESCH_CD Escheat Code OIU_ESCH_CD CHAR 1 0
N Owner is not in escheat
Y Owner has been identified to be in escheat
S Owner has been processed after being in escheat
ESCHEAT_DT Escheat Date - Owner was put into escheat OIU_ESCH_DT DATS 8 0
PREPAY_RELEVANT Prepayment Relevance (Vendor Master) WRF_PREPAY_RELEVANT CHAR 1 0
NULL Prepayment Not Allowed
A Prepayment Requested
B Prepayment Not Requested Before GR Effected
C Prepayment Possible, but Not Planned
ASSIGN_TEST Assignment Test Group WRF_MRM_ASSIGN_GROUP WRF_ASSIGN_GRP CHAR 4 0

LFB1 foreign key relationships

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