SAP Table BLFB1

Vendor Master Record Company Code Data (Batch Input)

BLFB1 (Vendor Master Record Company Code Data (Batch Input)) 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 BLFB1 to other SAP tables.

BLFB1 table fields

Field Data element Checktable Datatype Length Decimals
STYPE Batch Input Interface Record Type STYPE_BI CHAR 1 0
TBNAM Table Name TABNAME CHAR 30 0
AKONT Reconciliation Account in General Ledger AKONT CHAR 10 0
ZUAWA Key for sorting according to assignment numbers DZUAWA CHAR 3 0
LNRZE Head office account number LNRZE CHAR 10 0
BLNKZ Subsidy indicator for determining the reduction rates BLNKZ CHAR 2 0
XDEZV Indicator: Local processing? XDEZV CHAR 1 0
X Yes
NULL No
FDGRV Planning group FDGRV CHAR 10 0
BEGRU Authorization Group BRGRU CHAR 4 0
VZSKZ Interest calculation indicator VZSKZ CHAR 2 0
ZINDT Date (batch input) DATUM_BI CHAR 8 0
ZINRT Interest Frequency in Months (Batch Input) DZINRT_BI CHAR 2 0
DATLZ Date (batch input) DATUM_BI CHAR 8 0
QSSKZ Withholding Tax Code QSSKZ CHAR 2 0
QSZNR Certificate Number of the Withholding Tax Exemption QSZNR CHAR 10 0
QSZDT Date (batch input) DATUM_BI CHAR 8 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
TOGRU Tolerance group for the business partner/G/L account TOGRU CHAR 4 0
KULTG Probable Time until Check is Paid (Batch Input) KULTG_BI CHAR 3 0
REPRF Check Flag for Double Invoices or Credit Memos REPRF CHAR 1 0
X Yes
NULL No
ZWELS List of the Payment Methods to be Considered DZWELS CHAR 10 0
ZAHLS Block Key for Payment DZAHLS CHAR 1 0
LNRZB Account number of the alternative payee LNRZB CHAR 10 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
WEBTR Bill of exchange limit (in local curr.)(batch input field) WEBTR_BI CHAR 16 0
XVERR Indicator: Clearing between customer and vendor? XVERR_LFB1 CHAR 1 0
X Yes
NULL No
BUSAB Accounting clerk BUSAB CHAR 2 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
LOEVM Deletion Flag for Master Record (Company Code Level) LOEVM_B CHAR 1 0
X Yes
NULL No
SPERR Posting block for company code SPERB_B CHAR 1 0
X Yes
NULL No
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
PERNR Personnel Number (Batch Input Field) PERNR_BI CHAR 8 0
TLFXS Accounting clerk's fax number at the customer/vendor TLFXS CHAR 31 0
TOGRR Tolerance group; Invoice Verification TOGRR CHAR 4 0
INTAD Internet address of partner company clerk INTAD CHAR 130 0
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 Date (batch input) DATUM_BI CHAR 8 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
GMVKZK Vendor is in execution GMVKZK CHAR 1 0
X Yes
NULL No
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 CHAR 4 0
AVSND Indicator: Send Payment Advice by XML AVSND CHAR 1 0
X Without E-mail
Y With E-mail
SMTP_ADDR E-Mail Address AD_SMTPADR CHAR 241 0
INTERCOCD Intercompany code OIU_INTERCOCD 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 test OIU_MIN_PAY_C CHAR 7 0
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 Recoup Percentage in Character OIU_RECOUP_PC_C CHAR 6 0
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 OIU_ESCH_DT_C CHAR 8 0
SENDE Record End Indicator for Batch Input Interface SENDE_BI CHAR 1 0