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 | Possible values | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
LOEVM
Deletion Flag for Master Record (Company Code Level)
|
LOEVM_B |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
DATLZ
Date of the last interest calculation run
|
DATLZ |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||
|
XDEZV
Indicator: Local processing?
|
XDEZV |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
QLAND
Withholding Tax Country Key
|
QLAND | T005Q |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||
|
XEDIP
Indicator: Send Payment Advices by EDI
|
XEDIP |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
TLFNS
Accounting clerk's telephone number at business partner
|
TLFNS |
CHAR
|
30 | 0 | ||||||||||||||||||||||||||||
|
AVSND
Indicator: Send Payment Advice by XML
|
AVSND |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
INTERCOCD
Intercompany code
|
OIU_INTERCOCD | T001 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
|
RSTR_CHG_FL
Restricted Mass-transaction flag
|
OIU_RSTR_CHG_FL |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
CHECK_FLAG
ID that the owner's check needs to be printed 1st.
|
OIU_CHECK_FLAG |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
OVRD_RCPMT
Override Recoupment Flag
|
OIU_OVRD_RCPMT |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
MIN_PAY
Mininum Payment Amount
|
OIU_MIN_PAY |
CURR
|
6 | 2 | ||||||||||||||||||||||||||||
|
PAY_FRQ_CD
Payment Frequency Code
|
OIU_PAY_FRQ_CD |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
RECOUP_PC
Recoupment Percentage
|
OIU_RECOUP_PC |
DEC
|
5 | 2 | ||||||||||||||||||||||||||||
|
ALLOT_MTH_CD
Allotee Payment Method Code
|
OIU_ALLOT_MTH_CD |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
ESCH_CD
Escheat Code
|
OIU_ESCH_CD |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
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 | SYST | MANDT |
WRF_ASSIGN_GRP
Assignment Test Group
|
MANDT |
| LFB1 | ASSIGN_TEST | * |
WRF_ASSIGN_GRP
Assignment Test Group
|
BUKRS | |
| LFB1 | ASSIGN_TEST | LFB1 | ASSIGN_TEST |
WRF_ASSIGN_GRP
Assignment Test Group
|
ASSIGN_GROUP |
| LFB1 | BUKRS | LFB1 | MANDT |
T001
Company Codes
|
MANDT |
| LFB1 | BUKRS | LFB1 | BUKRS |
T001
Company Codes
|
BUKRS |
| LFB1 | BUSAB | LFB1 | BUSAB |
T001S
Accounting Clerks
|
BUSAB |
| LFB1 | BUSAB | LFB1 | MANDT |
T001S
Accounting Clerks
|
MANDT |
| LFB1 | BUSAB | LFB1 | BUKRS |
T001S
Accounting Clerks
|
BUKRS |
| LFB1 | FDGRV | LFB1 | FDGRV |
T035
Planning groups
|
GRUPP |
| LFB1 | FDGRV | LFB1 | MANDT |
T035
Planning groups
|
MANDT |
| LFB1 | FRGRP | LFB1 | MANDT |
VBWF08
Release Groups
|
MANDT |
| LFB1 | FRGRP | LFB1 | FRGRP |
VBWF08
Release Groups
|
FRGRP |
| LFB1 | GRICD | LFB1 | MANDT |
J_1AGICD
Activity codes for gross income tax declaration
|
MANDT |
| 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 | 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 | LNRZE |
LFA1
Vendor Master (General Section)
|
LIFNR |
| LFB1 | LNRZE | LFB1 | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| 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 | MINDK |
T059M
Minority Indicators
|
MINDK |
| LFB1 | MINDK | LFB1 | MANDT |
T059M
Minority Indicators
|
MANDT |
| 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 | MANDT |
T043G
Tolerances for Groups of Customers/Vendors
|
MANDT |
| 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 | UZAWE | LFB1 | MANDT |
T042F
Payment method supplements
|
MANDT |
| LFB1 | UZAWE | LFB1 | UZAWE |
T042F
Payment method supplements
|
UZAWE |
| LFB1 | VZSKZ | LFB1 | VZSKZ |
T056
Interest settlement
|
VZSKZ |
| LFB1 | VZSKZ | LFB1 | MANDT |
T056
Interest settlement
|
MANDT |
| 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 | ZAHLS |
T008
Blocking Reasons for Automatic Payment Transcations
|
ZAHLS |
| LFB1 | ZAHLS | LFB1 | MANDT |
T008
Blocking Reasons for Automatic Payment Transcations
|
MANDT |
| LFB1 | ZGRUP | LFB1 | ZGRUP |
TZGR
Grouping rules for automatic payments
|
ZGRUP |
| LFB1 | ZUAWA | LFB1 | ZUAWA |
TZUN
Rules for 'Allocation' Field Layout
|
ZUAWA |