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 |
Possible values
|
||||||||||||||||||||||||||
LOEVM | Deletion Flag for Master Record (Company Code Level) | LOEVM_B | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||||||||||
DATLZ | Date of the last interest calculation run | DATLZ | DATS | 8 | 0 | |||||||||||||||||||||||||||
XDEZV | Indicator: Local processing? | XDEZV | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||||||||||
QLAND | Withholding Tax Country Key | QLAND | T005Q | CHAR | 3 | 0 | ||||||||||||||||||||||||||
XEDIP | Indicator: Send Payment Advices by EDI | XEDIP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||||||||||
TLFNS | Accounting clerk's telephone number at business partner | TLFNS | CHAR | 30 | 0 | |||||||||||||||||||||||||||
AVSND | Indicator: Send Payment Advice by XML | AVSND | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||||||||||
INTERCOCD | Intercompany code | OIU_INTERCOCD | T001 | CHAR | 4 | 0 | ||||||||||||||||||||||||||
RSTR_CHG_FL | Restricted Mass-transaction flag | OIU_RSTR_CHG_FL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
CHECK_FLAG | ID that the owner's check needs to be printed 1st. | OIU_CHECK_FLAG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
OVRD_RCPMT | Override Recoupment Flag | OIU_OVRD_RCPMT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
MIN_PAY | Mininum Payment Amount | OIU_MIN_PAY | CURR | 6 | 2 | |||||||||||||||||||||||||||
PAY_FRQ_CD | Payment Frequency Code | OIU_PAY_FRQ_CD | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||||||||||||
RECOUP_PC | Recoupment Percentage | OIU_RECOUP_PC | DEC | 5 | 2 | |||||||||||||||||||||||||||
ALLOT_MTH_CD | Allotee Payment Method Code | OIU_ALLOT_MTH_CD | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||||||||||||
ESCH_CD | Escheat Code | OIU_ESCH_CD | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||||||||||
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 |