KNB1_ACT - Master Data Consolidation: Best Record Table for KNB1

Master Data Consolidation: Best Record Table for KNB1 information is stored in SAP table KNB1_ACT.
It is part of development package MDC_BP_MODEL in software component CA-MDG-CMP-BP. This development package consists of objects that can be grouped under "Master Data Consolidation: Business Partner Data Model".

Fields for table KNB1_ACT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
PARTNER	Business Partner Number	X	BU_PARTNER	CHAR	20
BUKRS	Company Code	X	BUKRS	CHAR	8
ASSIGNMENT_ID	Multiple Assignment ID (Number)	X	MDG_BP_ASSIGNMENT_ID	NUMC	24
PERNR	Personnel Number		PERNR_D	NUMC	16
.INCLUDE				SI_KNB1	0
ERDAT	Date on which the Record Was Created		ERDAT_RF	DATS	16
ERNAM	Name of Person who Created the Object		ERNAM_RF	CHAR	24
SPERR	Posting block for company code		SPERB_B	CHAR	2
LOEVM	Deletion Flag for Master Record (Company Code Level)		LOEVM_B	CHAR	2
BUSAB	Accounting Clerk Abbreviation		BUSAB	CHAR	4	T001S
AKONT	Reconciliation Account in General Ledger		AKONT	CHAR	20	SKB1
BEGRU	Authorization Group		BRGRU	CHAR	8	*
KNRZE	Head Office Account Number (in branch accounts)		KNRZE	CHAR	20	KNA1
KNRZB	Account number of an alternative payer		KNRZB	CHAR	20	KNA1
XVERR	Indicator: Clearing between customer and vendor ?		XVERR_KNB1	CHAR	2
WAKON	Terms of Payment Key for Bill of Exchange Charges		WAKON	CHAR	8
VZSKZ	Interest Indicator		VZSKZ	CHAR	4	T056
EIKTO	Our account number at customer		EIKTO_D	CHAR	24
KVERM	Memo		KVERM	CHAR	60
FDGRV	Planning Group		FDGRV	CHAR	20	T035
VRBKZ	Export Credit Insurance Institution Number		VRBKZ	CHAR	4
VLIBB	Amount Insured		VLIBB_CS	CURR	7
VRSZL	Insurance Lead Months		VRSZL	DEC	2
VRSPR	Deductible Percentage Rate		VRSPR	DEC	2
VRSNR	Insurance Number		VRSNR	CHAR	20
VERDT	Insurance Validity Date		VERDT	DATS	16
PERKZ	Collective Invoice Variant		PERKZ_KNB1	CHAR	2
XDEZV	Indicator: Local Processing?		XDEZV	CHAR	2
XAUSZ	Indicator for Periodic Account Statements		XAUSZ	CHAR	2	T048K
WEBTR	Bill of Exchange Limit (in Local Currency)		WEBTR_CS	CURR	7
REMIT	Next payee		REMIT	CHAR	20	KNA1
DATLZ	Date of Last Interest Calculation Run		DATLZ	DATS	16
XZVER	Indicator: Record Payment History ?		XZVER	CHAR	2
TOGRU	Tolerance Group for Business Partner/G/L Account		TOGRU	CHAR	8	T043G
KULTG	Probable Time Until Check Is Paid		KULTG	DEC	2
HBKID	Short Key for a House Bank		HBKID	CHAR	10	T012
XPORE	Indicator: Pay All Items Separately?		XPORE	CHAR	2
BLNKZ	(Obsolete) Subsidy Ind. for Determining the Reduction Rate		BLNKZ	CHAR	4	*
ALTKN	Previous Master Record Number		ALTKN	CHAR	20
URLID	Short Key for Known/Negotiated Leave		URLID	CHAR	8	T052A
MGRUP	Key for Dunning Notice Grouping		MGRUP	CHAR	4	T047R
LOCKB	Key of the Lockbox to Which the Customer Is to Pay		LOCKB	CHAR	14	T049L
UZAWE	Payment method supplement		UZAWE	CHAR	4	T042F
EKVBD	Account Number of Buying Group		EKVBD	CHAR	20	KNA1
SREGL	Selection Rule for Payment Advices		SREGL	CHAR	6	T053A
XEDIP	Indicator: Send Payment Advices by EDI		XEDIP	CHAR	2
FRGRP	Release Approval Group		FRGRP	CHAR	8	VBWF08
VRSDG	Reason Code Conversion Version		VRSDG	CHAR	6	T053V
TLFXS	Accounting clerk's fax number at the customer/vendor		TLFXS	CHAR	62
INTAD	Internet address of partner company clerk		INTAD	CHAR	260
XKNZB	Indicator: Alternative Payer Using Account Number		XKNZB	CHAR	2
GUZTE	Payment Terms Key for Credit Memos		GUZTE	CHAR	8
GRICD	Activity Code for Gross Income Tax		J_1AGICD_D	CHAR	4	J_1AGICD
GRIDT	Distribution Type for Employment Tax		J_1ADTYP_D	CHAR	4	J_1ADTYP
WBRSL	Value Adjustment Key		WBRSL	CHAR	4	T044G
CONFS	Status of Change Authorization (Company Code Level)		CONFS_B	CHAR	2
UPDAT	Date on Which the Changes Were Confirmed		UPDAT_RF	DATS	16
UPTIM	Time of Last Change Confirmation		UPTIM_RF	TIMS	12
NODEL	Deletion bock for master record (company code level)		NODEL_B	CHAR	2
TLFNS	Accounting clerk's telephone number at business partner		TLFNS	CHAR	60
CESSION_KZ	Accounts Receivable Pledging Indicator		CESSION_KZ	CHAR	4	TCESSION
AVSND	Indicator: Send Payment Advice by XML		AVSND	CHAR	2
AD_HASH	E-Mail Address for Avis: Hash Value		ADHASH	CHAR	20
QLAND	Withholding Tax Country/Region Key		QLAND	CHAR	6	T005Q
CVP_XBLCK_B	Business Purpose Completed Flag		CVP_XBLCK	CHAR	2
CIIUCODE	Main economic activity		CIIUCODE	NUMC	8
PAYMENTCLEARINGGRPID	Payment Clearing Group ID		FAR_PAYMENT_CLEARING_GROUP	CHAR	16	FAR_PYMT_CLG_GRP
PAYTRSN	Payment Reason		FARP_PAYT_RSN	CHAR	8	*
RECENCY	Master Data Consolidation: Recency		MDC_RECENCY	DEC	8
SOURCE_RECENCY	Master Data Consolidation: Recency		MDC_RECENCY	DEC	8
TARGET_ASSIGNMENT_ID	Multiple Assignment ID (Number)		MDG_BP_ASSIGNMENT_ID	NUMC	24