ESH_N_LFA1_LFB1_LFB1_VENDOR

Node LFB1_VENDOR of search model LFA1_LFB1_H | view: ESH_L_LFA1_VNDR | Extraction: Not supported | Component: Information System

Tables used: LFB1

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities
📅 Dates (7)
☰ Categorical (13)
Other (19)
🔗 Relations (24)

Column Name	Description
lifnr FK	Account Number of Supplier
bukrs FK	Company Code

Column Name	Description
webtr	Bill of Exchange Limit (in Local Currency)

Column Name	Description

Column Name	Description
erdat	Date on which the Record Was Created
zindt	Key Date of Last Interest Calculation
datlz	Date of Last Interest Calculation Run
qszdt	Validity Date for Withholding Tax Exemption Certificate
cerdt	Certification Date
updat	Date on Which the Changes Were Confirmed
uptim	Time of Last Change Confirmation

Column Name	Description
sperr	Posting block for company code	Show values
loevm	Deletion Flag for Master Record (Company Code Level)	Show values
xverr	Indicator: Clearing between customer and vendor?	Show values
zinrt	Interest Calculation Frequency in Months	Show values
xdezv	Indicator: Local Processing?	Show values
reprf	Check Flag for Double Invoices or Credit Memos	Show values
xpore	Indicator: Pay All Items Separately?	Show values
qsbgr	Authority for Exemption from Withholding Tax	Show values
xedip	Indicator: Send Payment Advices by EDI	Show values
xlfzb	Indicator: Alternative Payee Using Account Number	Show values
nodel	Deletion bock for master record (company code level)	Show values
avsnd	Indicator: Send Payment Advice by XML	Show values
prepay_relevant	Prepayment Relevance (Supplier Master)	Show values

Column Name	Description	Domain name
pernr	Personnel Number	PERNR
ernam	Name of Person who Created the Object	USNAM
begru	Authorization Group	BRGRU
zwels	List of Respected Payment Methods	ZWELS
zterm	Terms of payment key	ZTERM
eikto	Our account number with the vendor	CHAR12
zsabe	Clerk at vendor	TEXT15
kverm	Memo	TEXT30
kultg	Probable Time Until Check Is Paid	PACK2
qsznr	Certificate Number of the Withholding Tax Exemption	CHAR10
qsskz	Withholding Tax Code	QSSKZ
blnkz	(Obsolete) Subsidy Ind. for Determining the Reduction Rate	BLNKZ
altkn	Previous Master Record Number	CHAR10
tlfxs	Accounting clerk's fax number at the customer/vendor	TEXT31
intad	Internet address of partner company clerk	TXT130
guzte	Payment Terms Key for Credit Memos	ZTERM
confs	Status of Change Authorization (Company Code Level)	CHAR1
tlfns	Accounting clerk's telephone number at business partner	CHAR30
ad_hash	E-Mail Address for Avis: Hash Value	ADHASH

Master Data Relations	Join Conditions
Reconciliation Account in General Ledger Company Code Client Reconciliation Account in General Ledger	`ESH_N_LFA1_LFB1_LFB1_VENDOR.BUKRS == SKB1.BUKRS` `ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == SKB1.MANDT` `ESH_N_LFA1_LFB1_LFB1_VENDOR.AKONT == SKB1.SAKNR`
Company Code Company Code Client	`ESH_N_LFA1_LFB1_LFB1_VENDOR.BUKRS == T001.BUKRS` `ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == T001.MANDT`
Accounting Clerk Abbreviation Company Code Client Accounting Clerk Abbreviation	`ESH_N_LFA1_LFB1_LFB1_VENDOR.BUKRS == T001S.BUKRS` `ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == T001S.MANDT` `ESH_N_LFA1_LFB1_LFB1_VENDOR.BUSAB == T001S.BUSAB`
Planning Group Planning Group Client	`ESH_N_LFA1_LFB1_LFB1_VENDOR.FDGRV == T035.GRUPP` `ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == T035.MANDT`
Release Approval Group Client Release Approval Group	`ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == VBWF08.MANDT` `ESH_N_LFA1_LFB1_LFB1_VENDOR.FRGRP == VBWF08.FRGRP`
Activity Code for Employment Tax Client Activity Code for Gross Income Tax ?	`ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == J_1AGICD.MANDT` `ESH_N_LFA1_LFB1_LFB1_VENDOR.GRICD == J_1AGICD.J_1AGICD` `ESH_N_LFA1_LFB1_LFB1_VENDOR.[column in domain "LAND1"] == J_1AGICD.LAND1`
Distrib. Types for Employment Tax Company Code Client Distribution Type for Employment Tax	`ESH_N_LFA1_LFB1_LFB1_VENDOR.BUKRS == J_1ADTYP.BUKRS` `ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == J_1ADTYP.MANDT` `ESH_N_LFA1_LFB1_LFB1_VENDOR.GRIDT == J_1ADTYP.J_1ADTYP`
Short Key for a House Bank Client ? Short Key for a House Bank	`ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == T012.MANDT` `ESH_N_LFA1_LFB1_LFB1_VENDOR.[column in domain "BUKRS"] == T012.BUKRS` `ESH_N_LFA1_LFB1_LFB1_VENDOR.HBKID == T012.HBKID`
Account Number of Supplier Client Account Number of Supplier	`ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == LFA1.MANDT` `ESH_N_LFA1_LFB1_LFB1_VENDOR.LIFNR == LFA1.LIFNR`
Account number of the alternative payee Client Account number of the alternative payee	`ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == LFA1.MANDT` `ESH_N_LFA1_LFB1_LFB1_VENDOR.LNRZB == LFA1.LIFNR`
Head office account number Client Head office account number	`ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == LFA1.MANDT` `ESH_N_LFA1_LFB1_LFB1_VENDOR.LNRZE == LFA1.LIFNR`
Key for Dunning Notice Grouping Client Key for Dunning Notice Grouping	`ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == T047R.MANDT` `ESH_N_LFA1_LFB1_LFB1_VENDOR.MGRUP == T047R.MGRUP`
Minority Indicator Client Minority Indicator	`ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == T059M.MANDT` `ESH_N_LFA1_LFB1_LFB1_VENDOR.MINDK == T059M.MINDK`
Withholding Tax Country/Region Key Client Withholding Tax Country/Region Key ?	`ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == T005Q.MANDT` `ESH_N_LFA1_LFB1_LFB1_VENDOR.QLAND == T005Q.QLAND` `ESH_N_LFA1_LFB1_LFB1_VENDOR.[column in domain "LAND1"] == T005Q.LAND1`
Vendor Recipient Type Client Vendor Recipient Type ?	`ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == T059A.MANDT` `ESH_N_LFA1_LFB1_LFB1_VENDOR.QSREC == T059A.QSREC` `ESH_N_LFA1_LFB1_LFB1_VENDOR.[column in domain "LAND1"] == T059A.LAND1`
Tolerance Group in Invoice Verification Company Code Client Tolerance Group in Invoice Verification	`ESH_N_LFA1_LFB1_LFB1_VENDOR.BUKRS == T169L.BUKRS` `ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == T169L.MANDT` `ESH_N_LFA1_LFB1_LFB1_VENDOR.TOGRR == T169L.TOGRR`
Tolerance Group for Business Partner/G/L Account Company Code Client Tolerance Group for Business Partner/G/L Account	`ESH_N_LFA1_LFB1_LFB1_VENDOR.BUKRS == T043G.BUKRS` `ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == T043G.MANDT` `ESH_N_LFA1_LFB1_LFB1_VENDOR.TOGRU == T043G.TOGRU`
Payment method supplement Client Payment method supplement	`ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == T042F.MANDT` `ESH_N_LFA1_LFB1_LFB1_VENDOR.UZAWE == T042F.UZAWE`
Interest Indicator Client Interest Indicator	`ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == T056.MANDT` `ESH_N_LFA1_LFB1_LFB1_VENDOR.VZSKZ == T056.VZSKZ`
Indicator for Periodic Account Statements Client Indicator for Periodic Account Statements	`ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == T048K.MANDT` `ESH_N_LFA1_LFB1_LFB1_VENDOR.XAUSZ == T048K.XAUSZ`
Block Key for Payment Client Block Key for Payment	`ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == T008.MANDT` `ESH_N_LFA1_LFB1_LFB1_VENDOR.ZAHLS == T008.ZAHLS`
Key for Payment Grouping	`ESH_N_LFA1_LFB1_LFB1_VENDOR.ZGRUP == TZGR.ZGRUP`
Key for sorting according to assignment numbers	`ESH_N_LFA1_LFB1_LFB1_VENDOR.ZUAWA == TZUN.ZUAWA`

Other Relations \| to Master Data Relations ↑	Join Conditions
Assignment Test Group Client ? Assignment Test Group	`ESH_N_LFA1_LFB1_LFB1_VENDOR.MANDT == WRF_ASSIGN_GRP.MANDT` `ESH_N_LFA1_LFB1_LFB1_VENDOR.[column in domain "BUKRS"] == WRF_ASSIGN_GRP.BUKRS` `ESH_N_LFA1_LFB1_LFB1_VENDOR.ASSIGN_TEST == WRF_ASSIGN_GRP.ASSIGN_GROUP`