ESH_N_KNA1_KNB1_KNB1_CUSTOMER

Node KNB1_CUSTOMER of search model KNA1_KNB1_H | view: ESH_L_KNB1_CUST | Extraction: Not supported | Component: Accounts Receivable

Tables used: KNB1

🔑 Keys (2)
💰 Amounts (2)
∑ Quantities
📅 Dates (6)
☰ Categorical (16)
Other (23)
🔗 Relations (28)

Column Name	Description
kunnr FK	Customer Number
bukrs FK	Company Code

Column Name	Description
vlibb	Amount Insured
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
verdt	Insurance Validity Date
datlz	Date of Last Interest Calculation Run
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
zamim	Indicator: Payment Notice to Customer (with Cleared Items)?	Show values
zamiv	Indicator: Payment Notice to Sales Department?	Show values
zamir	Indicator: Payment Notice to Legal Department?	Show values
zamib	Indicator: Payment Notice to the Accounting Department?	Show values
zamio	Indicator: Payment Notice to Customer (W/o Cleared Items)?	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
xzver	Indicator: Record Payment History ?	Show values
xpore	Indicator: Pay All Items Separately?	Show values
xedip	Indicator: Send Payment Advices by EDI	Show values
xknzb	Indicator: Alternative Payer 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

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
wakon	Terms of Payment Key for Bill of Exchange Charges	ZTERM
eikto	Our account number at customer	CHAR12
zsabe	User at customer	TEXT15
kverm	Memo	TEXT30
vrbkz	Export Credit Insurance Institution Number	VRBKZ
vrszl	Insurance Lead Months	PACK2
vrspr	Deductible Percentage Rate	PACK2
vrsnr	Insurance Number	CHAR10
perkz	Collective Invoice Variant	PERKZ_KNB1
kultg	Probable Time Until Check Is Paid	PACK2
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 Reconciliation Account in General Ledger Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.BUKRS == SKB1.BUKRS` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.AKONT == SKB1.SAKNR` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == SKB1.MANDT`
Company Code Company Code Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.BUKRS == T001.BUKRS` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == T001.MANDT`
Accounting Clerk Abbreviation Company Code Accounting Clerk Abbreviation Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.BUKRS == T001S.BUKRS` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.BUSAB == T001S.BUSAB` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == T001S.MANDT`
Accounts Receivable Pledging Indicator Accounts Receivable Pledging Indicator Company Code Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.CESSION_KZ == TCESSION.CESSION_KZ` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.BUKRS == TCESSION.COMPANY` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == TCESSION.CLIENT`
Account Number of Buying Group Account Number of Buying Group Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.EKVBD == KNA1.KUNNR` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == KNA1.MANDT`
Planning Group Planning Group Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.FDGRV == T035.GRUPP` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == T035.MANDT`
Release Approval Group Release Approval Group Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.FRGRP == VBWF08.FRGRP` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == VBWF08.MANDT`
Activity Code for Gross Income Tax Activity Code for Gross Income Tax ? Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.GRICD == J_1AGICD.J_1AGICD` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.[column in domain "LAND1"] == J_1AGICD.LAND1` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == J_1AGICD.MANDT`
Distrib. Types for Employment Tax Company Code Distribution Type for Employment Tax Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.BUKRS == J_1ADTYP.BUKRS` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.GRIDT == J_1ADTYP.J_1ADTYP` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == J_1ADTYP.MANDT`
Short Key for a House Bank Short Key for a House Bank ? Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.HBKID == T012.HBKID` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.[column in domain "BUKRS"] == T012.BUKRS` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == T012.MANDT`
Account number of an alternative payer Account number of an alternative payer Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.KNRZB == KNA1.KUNNR` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == KNA1.MANDT`
Head Office Account Number (in branch accounts) Head Office Account Number (in branch accounts) Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.KNRZE == KNA1.KUNNR` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == KNA1.MANDT`
Customer Number Customer Number Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.KUNNR == KNA1.KUNNR` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == KNA1.MANDT`
Key for Dunning Notice Grouping Key for Dunning Notice Grouping Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MGRUP == T047R.MGRUP` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == T047R.MANDT`
Withholding Tax Country/Region Key Withholding Tax Country/Region Key ? Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.QLAND == T005Q.QLAND` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.[column in domain "LAND1"] == T005Q.LAND1` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == T005Q.MANDT`
Next payee Next payee Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.REMIT == KNA1.KUNNR` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == KNA1.MANDT`
Selection Rule for Payment Advices Client Selection Rule for Payment Advices	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == T053A.MANDT` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.SREGL == T053A.SREGL`
Tolerance Group for Business Partner/G/L Account Company Code Tolerance Group for Business Partner/G/L Account Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.BUKRS == T043G.BUKRS` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.TOGRU == T043G.TOGRU` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == T043G.MANDT`
Short Key for Known/Negotiated Leave Client Short Key for Known/Negotiated Leave	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == T052A.MANDT` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.URLID == T052A.URLID`
Payment method supplement Client Payment method supplement	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == T042F.MANDT` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.UZAWE == T042F.UZAWE`
Reason Code Conversion Version Reason Code Conversion Version Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.VRSDG == T053V.VRSDG` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == T053V.MANDT`
Interest Indicator Interest Indicator Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.VZSKZ == T056.VZSKZ` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == T056.MANDT`
Value Adjustment Key ? ? ? ? Client Value Adjustment Key	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.[column in domain "FFUTURE"] == T044G.FUTURE` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.[column in domain "LAND1"] == T044G.LAND1` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.[column in domain "OVDUE"] == T044G.OVDUE` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.[column in domain "BWBER"] == T044G.BWBER` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == T044G.MANDT` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.WBRSL == T044G.WBRSL`
Indicator for Periodic Account Statements Indicator for Periodic Account Statements Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.XAUSZ == T048K.XAUSZ` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == T048K.MANDT`
Block Key for Payment Block Key for Payment Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.ZAHLS == T008.ZAHLS` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == T008.MANDT`
Key for Payment Grouping	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.ZGRUP == TZGR.ZGRUP`
Key for sorting according to assignment numbers	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.ZUAWA == TZUN.ZUAWA`

Other Relations \| to Master Data Relations ↑	Join Conditions
Key of the Lockbox to Which the Customer Is to Pay Company Code Key of the Lockbox to Which the Customer Is to Pay Client	`ESH_N_KNA1_KNB1_KNB1_CUSTOMER.BUKRS == T049L.BUKRS` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.LOCKB == T049L.LOCKB` `ESH_N_KNA1_KNB1_KNB1_CUSTOMER.MANDT == T049L.MANDT`