SAP Table LFB1
Vendor Master (Company Code)
What Is the SAP LFB1 Table?
SAP LFB1 table stores the company code-specific data of vendor master records in SAP Financial Accounting. The information in LFB1 is maintained for each company code wise in each vendor is used.
Vendor master data in SAP is maintained at different organization levels and stored in different tables
- LFA1 – Vendor Master General Data
- LFB1 – Vendor Master Company Code Data
- LFM1 – Vendor Master Purchasing organization data
For example:
When a vendor invoice is posted, using transaction code FB60, the user enter the vendor account number and company code. SAP uses LFA1 to identify the vendor details and retrieve general information. Based on the selected company code, the system uses LFB1 to retrieve financial accounting information and updates in the accounting document automatically.
After posting, the vendor accounting document information is stored in BKPF and BSEG tables. In SAP ECC, the unpaid vendor item is available as open item in BSIK until it is cleared. Once the invoice is cleared, the corresponding cleared item information is available in the BSAK table.
Vendor Master > LFA1 + LFB1 > Vendor Invoice Posting > BKPF/BSEG > Open Item in BSIK > Cleared Item in BSAK
Quick overview
| SAP table | LFB1 |
|---|---|
| Short description | Vendor Master (Company Code) |
| Table type | Transparent table |
| Primary key | MANDT (Client), LIFNR (Account Number of Supplier), BUKRS (Company Code) |
| Client-dependent | Yes |
Important fields explained
| Field | SAP field description | What this field means |
|---|---|---|
LIFNR |
Account Number of Supplier | Vendor Number that identifies the vendor master record |
BUKRS |
Company Code | Company code for which the vendor specific finacial accounting data is maintained |
ZUAWA |
Key for sorting according to assignment numbers | Sort key used to determine how the assignment field in vendor accounting line item is populated |
AKONT |
Reconciliation Account in General Ledger | Reconciliation account which connects subledger account to general ledger |
ZAHLS |
Block Key for Payment | Payment block key used to control or block payments for the vendor |
ZTERM |
Terms of Payment Key | Terms of payment key used to determine payment due dates and cash discounts for the vendor |
At a glance
- Module
- Financial Accounting
- Application component
- LOGISTICS - GENERAL LO
- Subcomponent
- LOGISTICS BASIC DATA LO-MD
- Specific component
- BUSINESS PARTNERS LO-MD-BP
- Component level 4
- VENDOR MASTER LO-MD-BP-VM
Technical details
- Delivery class
- A (Application table: master and transaction data)
- Data class
- APPL0 (Master Data, Transparent Tables)
- Package
- General services vendor master (WLIFCORE)
Primary key fields
| Field | Description | Data element | Type | Length |
|---|---|---|---|---|
MANDT
|
Client | MANDT | CLNT | 3 |
LIFNR
|
Account Number of Supplier | LIFNR | CHAR | 10 |
BUKRS
|
Company Code | BUKRS | CHAR | 4 |
Table fields
106 fields
106 fields
| Field | Description | Data element | Domain | Type | Length | Decimals | Check table |
|---|---|---|---|---|---|---|---|
MANDT
Key
|
Client | MANDT | MANDT | CLNT | 3 | — | T000 |
LIFNR
Key
|
Account Number of Supplier | LIFNR | LIFNR | CHAR | 10 | — | LFA1 |
BUKRS
Key
|
Company Code | BUKRS | BUKRS | CHAR | 4 | — | T001 |
PERNR
|
Personnel Number | PERNR_D | PERNR | NUMC | 8 | — | |
ERDAT
|
Record Created On | ERDAT_RF | DATUM | DATS | 8 | — | |
ERNAM
|
Name of Person who Created the Object | ERNAM_RF | USNAM | CHAR | 12 | — | |
SPERR
|
Posting block for company code | SPERB_B | XFELD | CHAR | 1 | — | |
LOEVM
|
Deletion Flag for Master Record (Company Code Level) | LOEVM_B | XFELD | CHAR | 1 | — | |
ZUAWA
|
Key for sorting according to assignment numbers | DZUAWA | ZUAWA | CHAR | 3 | — | TZUN |
AKONT
|
Reconciliation Account in General Ledger | AKONT | SAKNR | CHAR | 10 | — | SKB1 |
BEGRU
|
Authorization Group | BRGRU | BRGRU | CHAR | 4 | — | |
VZSKZ
|
Interest Indicator | VZSKZ | VZSKZ | CHAR | 2 | — | T056 |
ZWELS
|
List of Respected Payment Methods | DZWELS | ZWELS | CHAR | 10 | — | |
XVERR
|
Indicator: Clearing between customer and vendor? | XVERR_LFB1 | XFELD | CHAR | 1 | — | |
ZAHLS
|
Block Key for Payment | DZAHLS | ZAHLS | CHAR | 1 | — | T008 |
ZTERM
|
Terms of Payment Key | DZTERM | ZTERM | CHAR | 4 | — | |
EIKTO
|
Our account number with the vendor | EIKTO_K | CHAR12 | CHAR | 12 | — | |
ZSABE
|
Clerk at vendor | DZSABE_K | TEXT15 | CHAR | 15 | — | |
KVERM
|
Memo | KVERM | TEXT30 | CHAR | 30 | — | |
FDGRV
|
Planning Group | FDGRV | FDGRP | CHAR | 10 | — | T035 |
BUSAB
|
Accounting Clerk Abbreviation | BUSAB | BUSAB | CHAR | 2 | — | T001S |
LNRZE
|
Head Office Account Number | LNRZE | LIFNR | CHAR | 10 | — | LFA1 |
LNRZB
|
Account number of the alternative payee | LNRZB | LIFNR | CHAR | 10 | — | LFA1 |
ZINDT
|
Key Date of Last Interest Calculation | DZINDT | DATUM | DATS | 8 | — | |
ZINRT
|
Interest Calculation Frequency in Months | DZINRT | ZINRT | NUMC | 2 | — | |
DATLZ
|
Date of Last Interest Calculation Run | DATLZ | DATUM | DATS | 8 | — | |
XDEZV
|
Indicator: Local Processing? | XDEZV | XFELD | CHAR | 1 | — | |
WEBTR
|
Bill of Exchange Limit (in Local Currency) | WEBTR_CS | WERT7 | CURR | 13 | 2 | |
KULTG
|
Probable Time Until Check Is Paid | KULTG | PACK2 | DEC | 3 | 0 | |
REPRF
|
Check Flag for Double Invoices or Credit Memos | REPRF | XFELD | CHAR | 1 | — | |
TOGRU
|
Tolerance Group for Business Partner/G/L Account | TOGRU | TOGRU | CHAR | 4 | — | T043G |
HBKID
|
Short Key for a House Bank | HBKID | HBKID | CHAR | 5 | — | T012 |
XPORE
|
Indicator: Pay All Items Separately? | XPORE | XFELD | CHAR | 1 | — | |
QSZNR
|
Certificate Number of the Withholding Tax Exemption | QSZNR | CHAR10 | CHAR | 10 | — | |
QSZDT
|
Validity Date for Withholding Tax Exemption Certificate | QSZDT | DATUM | DATS | 8 | — | |
QSSKZ
|
Withholding Tax Code | QSSKZ | QSSKZ | CHAR | 2 | — | |
BLNKZ
|
(Obsolete) Subsidy Ind. for Determining the Reduction Rate | BLNKZ | BLNKZ | CHAR | 2 | — | |
MINDK
|
Minority Indicator | MINDK | MINDK | CHAR | 3 | — | T059M |
ALTKN
|
Previous Master Record Number | ALTKN | CHAR10 | CHAR | 10 | — | |
ZGRUP
|
Key for Payment Grouping | DZGRUP | ZGRUP | CHAR | 2 | — | TZGR |
MGRUP
|
Key for Dunning Notice Grouping | MGRUP | MGRUP | CHAR | 2 | — | T047R |
UZAWE
|
Payment method supplement | UZAWE | UZAWE | CHAR | 2 | — | T042F |
QSREC
|
Vendor Recipient Type | QSREC | QSREC | CHAR | 2 | — | T059A |
QSBGR
|
Authority for Exemption from Withholding Tax | QSBGR | QSBGR | CHAR | 1 | — | |
QLAND
|
Withholding Tax Country/Region Key | QLAND | QLAND | CHAR | 3 | — | T005Q |
XEDIP
|
Indicator: Send Payment Advices by EDI | XEDIP | XFELD | CHAR | 1 | — | |
FRGRP
|
Release Approval Group | FRGRP | FRGRP | CHAR | 4 | — | VBWF08 |
TOGRR
|
Tolerance Group in Invoice Verification | TOGRR | TOGRR | CHAR | 4 | — | T169L |
TLFXS
|
Accounting clerk's fax number at the customer/vendor | TLFXS | TEXT31 | CHAR | 31 | — | |
INTAD
|
Internet address of partner company clerk | INTAD | TXT130 | CHAR | 130 | — | |
XLFZB
|
Indicator: Alternative Payee Using Account Number | XLFZB | XFELD | CHAR | 1 | — | |
GUZTE
|
Payment Terms Key for Credit Memos | GUZTE | ZTERM | CHAR | 4 | — | |
GRICD
|
Activity Code for Gross Income Tax | J_1AGICD_D | J_1AGICD2 | CHAR | 2 | — | J_1AGICD |
GRIDT
|
Distribution Type for Employment Tax | J_1ADTYP_D | J_1ADTYP | CHAR | 2 | — | J_1ADTYP |
XAUSZ
|
Indicator for Periodic Account Statements | XAUSZ | AUSZG | CHAR | 1 | — | T048K |
CERDT
|
Certification Date | CERDT | DATUM | DATS | 8 | — | |
CONFS
|
Status of Change Authorization (Company Code Level) | CONFS_B | CHAR1 | CHAR | 1 | — | |
UPDAT
|
Date on Which the Changes Were Confirmed | UPDAT_RF | DATUM | DATS | 8 | — | |
UPTIM
|
Time of Last Change Confirmation | UPTIM_RF | AS4TIME | TIMS | 6 | — | |
NODEL
|
Deletion bock for master record (company code level) | NODEL_B | XFELD | CHAR | 1 | — | |
TLFNS
|
Accounting clerk's telephone number at business partner | TLFNS | CHAR30 | CHAR | 30 | — | |
AVSND
|
Indicator: Send Payment Advice by XML | AVSND | AVSND | CHAR | 1 | — | |
AD_HASH
|
E-Mail Address for Avis: Hash Value | ADHASH | ADHASH | CHAR | 10 | — | |
CVP_XBLCK_B
|
Business Purpose Completed Flag | CVP_XBLCK | CVP_XBLCK | CHAR | 1 | — | |
CIIUCODE
|
Main economic activity | CIIUCODE | CIIUCODE | NUMC | 4 | — | |
PAYMENTCLEARINGGRPID
|
Payment Clearing Group ID | FAR_PAYMENT_CLEARING_GROUP | FAR_PAYMENT_CLEARING_GROUP | CHAR | 8 | — | FAR_PYMT_CLG_GRP |
PAYTRSN
|
Payment Reason | FARP_PAYT_RSN | FARP_PAYT_RSN | CHAR | 4 | — | |
LFB1_EEW_CC
|
Dataelement for the Extension Company Code | LFB1_EEW_CC | LFB1_EEW_CC | CHAR | 1 | — | |
ZBOKD
|
LEDGER MANAGEMENT EXPIRATION DATE | /ATL/VBOKD | DATUM | DATS | 8 | — | |
ZQSSKZ
|
Future Withholding tax code | /ATL/VQSSKZ | QSSKZ | CHAR | 2 | — | T059Q |
ZQSZDT
|
Validity date for withholding tax exemption certificate | /ATL/VQSZDT | DATUM | DATS | 8 | — | |
ZQSZNR
|
Certificate number of the withholding tax exemption | /ATL/VQSZNR | CHAR10 | CHAR | 10 | — | |
ZMINDAT
|
Certification date for minimum wage | /ATL/VMINDAT | DATS | DATS | 8 | — | |
J_SC_SUBCONTYPE
|
Subcontractor Type | /SAPNEA/J_SC_SUBCONTYPE | /SAPNEA/J_SC_SUBCONTYPE | CHAR | 1 | — | |
J_SC_COMPDATE
|
Completion Date Of Inspection | /SAPNEA/J_SC_COMPLETIONDATE | /SAPNEA/J_SC_COMPLETIONDATE | NUMC | 3 | — | |
J_SC_OFFSM
|
Offset Method | /SAPNEA/J_SC_OFFSM | /SAPNEA/J_SC_OFFSM | CHAR | 1 | — | |
J_SC_OFFSR
|
Offset Percentage | /SAPNEA/J_SC_OFFSR | /SAPNEA/J_SC_OFFSR | NUMC | 3 | — | |
BASIS_PNT
|
Average daily basis points for purchase cards | FMBASIS_POINTS | FMBASIS_POINTS | DEC | 6 | 3 | |
GMVKZK
|
Vendor is in execution | GMVKZK | XFELD | CHAR | 1 | — | |
BRSCH
|
Industry Key | BRSCH | BRSCH | CHAR | 4 | — | T016 |
WRBTR
|
Amount for Payment Program | KR_AMOUNT | AFLE13D2O16N_TO_23D2O30N | CURR | 23 | 2 | |
WAERS
|
Currency Key | WAERS | WAERS | CUKY | 5 | — | TCURC |
FORGN
|
Foreign Shareholder | FIWTKW_LOCALITY | SAP_BOOL | CHAR | 1 | — | |
SHARE_IN_FOREIGN
|
Share in Dividend Paying Company | FIWTKW_OWNED_SHARE | — | DEC | 5 | 2 | |
NOTES
|
Notes | FIWTKW_NOTES | FIWTKW_NOTE | CHAR | 200 | — | |
ACTIVE
|
Boolean Variable ('X'=Shareholder is active, ''=not active) | FIWTKW_SHR_ACTIVE | SAP_BOOL | CHAR | 1 | — | |
CATEG
|
Subcontractor's Business Type | CIS_CATEGORY | CIS_CATEGORY | CHAR | 12 | — | |
PARTNER_NAME
|
Partner's Trading Name | CIS_PARTNER_NAME | TEXT30 | CHAR | 30 | — | |
PARTNER_UTR
|
Partner's Unique Tax Reference (UTR) | CIS_PARTNER_UTR | CHAR20 | CHAR | 20 | — | |
STATUS
|
Verification Status | CIS_VFNSTATUS | CIS_VFNSTATUS | CHAR | 3 | — | |
VFNUM
|
Verification Number | GB_CIS_SC_VFNNUM | CHAR20 | CHAR | 20 | — | |
VFNID
|
Tax Status of the Verified Subcontractor | CIS_VFN_ID | CIS_VFN_ID | CHAR | 1 | — | |
CRN
|
Companies House Registration Number | GB_CIS_CRN | — | CHAR | 8 | — | |
US_REC_COUNTRY
|
Country/Region Key | LAND1 | LAND1 | CHAR | 3 | — | |
US_GIIN
|
US Recipient GIIN | FIWTUS_RECIPIENT_GIIN | — | CHAR | 19 | — | |
US_FTID
|
US Recipient Foreign Tax ID | FIWTUS_RECIPIENT_FTID | — | CHAR | 22 | — | |
US_REC_DOB
|
US Recipient Date Of Birth | FIWTUS_RECIPIENT_DOB | DATUM | DATS | 8 | — | |
US_LOB_CODE
|
LOB Treaty Code | FIWTUS_LOB_CODE | — | CHAR | 2 | — | |
US_W8_RECVDATE
|
US W8 Form Received Date | FIWTUS_W8_RECV_DATE | DATUM | DATS | 8 | — | |
US_W9_RECVDATE
|
US W8 Form Received Date | FIWTUS_W9_RECV_DATE | DATUM | DATS | 8 | — | |
US_TIN_NOTICE
|
Second TIN Notice from IRS | FIWTUS_SECOND_TIN_NOTICE | BOOLEAN | CHAR | 1 | — | |
US_PARTNERSHIP_IND
|
Partnership Interest Indicator | FIWTUS_PARTNERSHIP_IND | BOOLEAN | CHAR | 1 | — | |
US_FATCA_IND
|
US FATCA Indicator | FIWTUS_FATCA_IND | BOOLEAN | CHAR | 1 | — | |
US_CHAP4_STATUS_CODE
|
US Chapter 4 Status Code | FIWTUS_CHAP4_STATUS_CODE | — | CHAR | 2 | — | |
PREPAY_RELEVANT
|
Prepayment Relevance (Supplier Master) | WRF_PREPAY_RELEVANT | WRF_PREPAY_RELEVANT | CHAR | 1 | — | |
ASSIGN_TEST
|
Assignment Test Group | WRF_MRM_ASSIGN_GROUP | WRF_MRM_ASSIGN_GROUP | CHAR | 4 | — | WRF_ASSIGN_GRP |
No fields match the selected filters.
SAP LFB1 Table Availability
| SAP product | Verified release/system | Table availability | Verified on |
|---|---|---|---|
| SAP S/4HANA | 2023 - On-Premise - Initial Shipment Stack | Available |
Related SAP Tables
| Table | Description | Common Key Fields with LFB1 |
|---|---|---|
| SKB1 | G/L account master (company code) | MANDT, BUKRS |
| T001 | Company Codes | MANDT, BUKRS |
| T052 | Terms of Payment | MANDT |
| LFA1 | Supplier Master (General Section) | MANDT, LIFNR |
| LFBW | Vendor master record (withholding tax types) X | MANDT, LIFNR, BUKRS |
Fields marked as primary keys in both tables. Additional fields or filters may be needed when joining records.
Editorial and verification
- Content editor
- ERPSAP Content Team
- Technical reviewer
- ERPSAP Technical Review Team
- Verified against
- SAP S/4HANA 2023 On-Premise system
- Last updated
- October 7, 2026
The information on this SAP LFB1 table page is based on the verified SAP S/4HANA 2023 on-premise system identified above. Table definitions, fields, and availability may differ across SAP releases and customer-specific systems.