SAP Table BIW_LFB1_S

Provider Structure: Vendor Master Data from LFB1

BIW_LFB1_S (Provider Structure: Vendor Master Data from LFB1) 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 BIW_LFB1_S to other SAP tables.

Source: BIW_LFB1_S (Provider Structure: Vendor Master Data from LFB1)

BIW_LFB1_S table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
BUKRS Company Code BUKRS 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 CHAR 3 0
AKONT Reconciliation Account in General Ledger AKONT CHAR 10 0
BEGRU Authorization Group BRGRU CHAR 4 0
VZSKZ Interest calculation indicator VZSKZ 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 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 CHAR 10 0
BUSAB Accounting clerk BUSAB CHAR 2 0
LNRZE Head office account number LNRZE CHAR 10 0
LNRZB Account number of the alternative payee LNRZB 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
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 CHAR 4 0
HBKID Short Key for a House Bank HBKID 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 CHAR 3 0
ALTKN Previous Master Record Number ALTKN CHAR 10 0
ZGRUP Key for Payment Grouping DZGRUP CHAR 2 0
MGRUP Key for dunning notice grouping MGRUP CHAR 2 0
UZAWE Payment Method Supplement UZAWE CHAR 2 0
QSREC Vendor Recipient Type QSREC 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 CHAR 3 0
XEDIP Indicator: Send Payment Advices by EDI XEDIP CHAR 1 0
X Yes
NULL No
FRGRP Release Approval Group FRGRP CHAR 4 0
TOGRR Tolerance group; Invoice Verification TOGRR 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 CHAR 2 0
GRIDT Distribution Type for Employment Tax J_1ADTYP_D CHAR 2 0
XAUSZ Indicator for periodic account statements XAUSZ 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