SAP Table BIW_LFB1_S (Provider Structure: Vendor Master Data from LFB1)
SAP table BIW_LFB1_S 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 | * | MANDT | |||||||||||||||||||||||
| LIFNR | Account Number of Supplier | CHAR | 10 | 0 | * | LIFNR | |||||||||||||||||||||||
| BUKRS | Company Code | CHAR | 4 | 0 | * | 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 | * | DZUAWA | |||||||||||||||||||||||
| AKONT | Reconciliation Account in General Ledger | CHAR | 10 | 0 | * | AKONT | |||||||||||||||||||||||
| BEGRU | Authorization Group | CHAR | 4 | 0 | * | BRGRU | |||||||||||||||||||||||
| VZSKZ | Interest Indicator | CHAR | 2 | 0 | * | 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 | * | 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 | * | FDGRV | |||||||||||||||||||||||
| BUSAB | Accounting Clerk Abbreviation | CHAR | 2 | 0 | * | BUSAB | |||||||||||||||||||||||
| LNRZE | Head office account number | CHAR | 10 | 0 | * | LNRZE | |||||||||||||||||||||||
| LNRZB | Account number of the alternative payee | CHAR | 10 | 0 | * | 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 | ||||||||||||||||||||||||
| 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 | * | TOGRU | |||||||||||||||||||||||
| HBKID | Short Key for a House Bank | CHAR | 5 | 0 | * | 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 | * | MINDK | |||||||||||||||||||||||
| ALTKN | Previous Master Record Number | CHAR | 10 | 0 | ALTKN | ||||||||||||||||||||||||
| ZGRUP | Key for Payment Grouping | CHAR | 2 | 0 | * | DZGRUP | |||||||||||||||||||||||
| MGRUP | Key for Dunning Notice Grouping | CHAR | 2 | 0 | * | MGRUP | |||||||||||||||||||||||
| UZAWE | Payment method supplement | CHAR | 2 | 0 | * | UZAWE | |||||||||||||||||||||||
| QSREC | Vendor Recipient Type | CHAR | 2 | 0 | * | QSREC | |||||||||||||||||||||||
| QSBGR | Authority for Exemption from Withholding Tax | CHAR | 1 | 0 | QSBGR |
|
|||||||||||||||||||||||
| QLAND | Withholding Tax Country/Region Key | CHAR | 3 | 0 | * | QLAND | |||||||||||||||||||||||
| XEDIP | Indicator: Send Payment Advices by EDI | CHAR | 1 | 0 | XEDIP | ||||||||||||||||||||||||
| FRGRP | Release Approval Group | CHAR | 4 | 0 | * | FRGRP | |||||||||||||||||||||||
| TOGRR | Tolerance Group in Invoice Verification | CHAR | 4 | 0 | * | 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_D | |||||||||||||||||||||||
| GRIDT | Distribution Type for Employment Tax | CHAR | 2 | 0 | * | J_1ADTYP_D | |||||||||||||||||||||||
| XAUSZ | Indicator for Periodic Account Statements | CHAR | 1 | 0 | * | 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 |