KNA1_ACT - Master Data Consolidation: Best Record Table for KNA1

Master Data Consolidation: Best Record Table for KNA1 information is stored in SAP table KNA1_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 KNA1_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
ASSIGNMENT_ID	Multiple Assignment ID (Number)	X	MDG_BP_ASSIGNMENT_ID	NUMC	24
KUNNR	Customer Number		KUNNR	CHAR	20
LAND1	Country/Region Key		LAND1_GP	CHAR	6
NAME1	Name 1		NAME1_GP	CHAR	70
NAME2	Name 2		NAME2_GP	CHAR	70
ORT01	City		ORT01_GP	CHAR	70
PSTLZ	Postal Code		PSTLZ	CHAR	20
REGIO	Region (State, Province, County)		REGIO	CHAR	6
SORTL	Sort field		SORTL	CHAR	20
STRAS	Street and House Number		STRAS_GP	CHAR	70
TELF1	First telephone number		TELF1	CHAR	32
TELFX	Fax Number		TELFX	CHAR	62
XCPDK	Indicator: Is the account a one-time account?		XCPDK	CHAR	2
ADRNR	Address		ADRNR	CHAR	20
MCOD1	Search term for matchcode search		MCDD1	CHAR	50
MCOD2	Search Term for Matchcode Search		MCDD2	CHAR	50
MCOD3	Search term for matchcode search		MCDD3	CHAR	50
.INCLUDE				SI_KNA1	0
ANRED	Title		ANRED	CHAR	30
AUFSD	Central order block for customer		AUFSD_X	CHAR	4	TVAST
BAHNE	Express train station		BAHNE	CHAR	50
BAHNS	Train station		BAHNS	CHAR	50
BBBNR	International location number (part 1)		BBBNR	NUMC	14
BBSNR	International location number (Part 2)		BBSNR	NUMC	10
BEGRU	Authorization Group		BRGRU	CHAR	8	*
BRSCH	Industry key		BRSCH	CHAR	8	T016
BUBKZ	Check digit for the international location number		BUBKZ	NUMC	2
DATLT	Data communication line no.		DATLT	CHAR	28
ERDAT	Date on which the Record Was Created		ERDAT_RF	DATS	16
ERNAM	Name of Person who Created the Object		ERNAM_RF	CHAR	24
EXABL	Indicator: Unloading points exist		EXABL	CHAR	2
FAKSD	Central billing block for customer		FAKSD_X	CHAR	4	TVFS
FISKN	Account number of the master record with the fiscal address		FISKN_D	CHAR	20	KNA1
KNAZK	Working Time Calendar		KNAZK	CHAR	4	TFACD
KNRZA	Account Number of an Alternative Payer		KNRZA	CHAR	20	KNA1
KONZS	Group key		KONZS	CHAR	20
KTOKD	Customer Account Group		KTOKD	CHAR	8	T077D
KUKLA	Customer Classification		KUKLA	CHAR	4	TKUKL
LIFNR	Account Number of Supplier		LIFNR	CHAR	20	LFA1
LIFSD	Central delivery block for the customer		LIFSD_X	CHAR	4	TVLS
LOCCO	City Coordinates		LOCCO	CHAR	20
LOEVM	Central Deletion Flag for Master Record		LOEVM_X	CHAR	2
NAME3	Name 3		NAME3_GP	CHAR	70
NAME4	Name 4		NAME4_GP	CHAR	70
NIELS	Nielsen ID		NIELS	CHAR	4	TNLS
ORT02	District		ORT02_GP	CHAR	70
PFACH	PO Box		PFACH	CHAR	20
PSTL2	P.O. Box Postal Code		PSTL2	CHAR	20
COUNC	County Code		COUNC	CHAR	6	T005E
CITYC	City Code		CITYC	CHAR	8	T005G
RPMKR	Regional market		RPMKR	CHAR	10
SPERR	Central posting block		SPERB_X	CHAR	2
SPRAS	Language Key		SPRAS	LANG	2	T002
STCD1	Tax Number 1		STCD1	CHAR	32
STCD2	Tax Number 2		STCD2	CHAR	22
STKZA	Indicator: Business Partner Subject to Equalization Tax?		STKZA	CHAR	2
STKZU	Liable for VAT		STKZU	CHAR	2
TELBX	Telebox number		TELBX	CHAR	30
TELF2	Second telephone number		TELF2	CHAR	32
TELTX	Teletex number		TELTX	CHAR	60
TELX1	Telex number		TELX1	CHAR	60
LZONE	Transportation zone to or from which the goods are delivered		LZONE	CHAR	20	TZONE
XZEMP	Indicator: Is an alternative payer allowed in document?		XREGU	CHAR	2
VBUND	Company ID of Trading Partner		RASSC	CHAR	12	T880
STCEG	VAT Registration Number		STCEG	CHAR	40
DEAR1	Indicator: Competitor		DEAR1	CHAR	2
DEAR2	Indicator: Sales partner		DEAR2	CHAR	2
DEAR3	Indicator: Sales prospect		DEAR3	CHAR	2
DEAR4	Indicator for customer type 4		DEAR4	CHAR	2
DEAR5	ID for default sold-to party		DEAR5	CHAR	2
GFORM	Legal status		GFORM	CHAR	4	TVGF
BRAN1	Industry code 1		BRAN1_D	CHAR	20	TBRC
BRAN2	Industry code 2		BRAN2	CHAR	20	TBRC
BRAN3	Industry code 3		BRAN3	CHAR	20	TBRC
BRAN4	Industry code 4		BRAN4	CHAR	20	TBRC
BRAN5	Industry code 5		BRAN5	CHAR	20	TBRC
EKONT	Initial contact		EKONT	CHAR	20
UMSAT	Annual sales		UMSAT	CURR	5
UMJAH	Year For Which Sales are Given		UMJAH	NUMC	8
UWAER	Currency of sales figure		UWAER	CUKY	10	TCURC
JMZAH	Yearly number of employees		JMZAH	NUMC	12
JMJAH	Year for which the number of employees is given		JMJAH	NUMC	8
KATR1	Attribute 1		KATR1	CHAR	4	TVK1
KATR2	Attribute 2		KATR2	CHAR	4	TVK2
KATR3	Attribute 3		KATR3	CHAR	4	TVK3
KATR4	Attribute 4		KATR4	CHAR	4	TVK4
KATR5	Attribute 5		KATR5	CHAR	4	TVK5
KATR6	Attribute 6		KATR6	CHAR	6	TVK6
KATR7	Attribute 7		KATR7	CHAR	6	TVK7
KATR8	Attribute 8		KATR8	CHAR	6	TVK8
KATR9	Attribute 9		KATR9	CHAR	6	TVK9
KATR10	Attribute 10		KATR10	CHAR	6	TVK0
STKZN	Natural Person		STKZN	CHAR	2
UMSA1	Annual sales		UMSA1	CURR	8
TXJCD	Tax Jurisdiction		TXJCD	CHAR	30	TTXJ
PERIV	Fiscal Year Variant		PERIV	CHAR	4	T009
ABRVW	Usage Indicator		ABRVW	CHAR	6	TVLV
INSPBYDEBI	Inspection Carried Out By Customer (No Inspection Lot)		QINSPBYDEB	CHAR	2
INSPATDEBI	Inspection for a Delivery Note After Outbound Delivery		QINSPATDEB	CHAR	2
KTOCD	Reference Account Group for One-Time Account (Customer)		KTOCD	CHAR	8	T077D
PFORT	PO Box city		PFORT_GP	CHAR	70
WERKS	Plant		WERKS_D	CHAR	8	T001W
DTAMS	Report key for data medium exchange		DTAMS	CHAR	2
DTAWS	Instruction Key for Data Medium Exchange		DTAWS	CHAR	4	*
DUEFL	Status of Data Transfer into Subsequent Release		DUEFL_BKPF	CHAR	2
HZUOR	Assignment to Hierarchy		HZUOR	NUMC	4
SPERZ	Payment Block		SPERZ	CHAR	2
ETIKG	IS-R Labeling: customer/plant group		ETIKG	CHAR	20	TWEK
CIVVE	ID for mainly non-military use		CIVVE	CHAR	2
MILVE	ID for mainly military use		MILVE	CHAR	2
KDKG1	Customer condition group 1		KDKG1	CHAR	4	TVKGG
KDKG2	Customer condition group 2		KDKG2	CHAR	4	TVKGG
KDKG3	Customer condition group 3		KDKG3	CHAR	4	TVKGG
KDKG4	Customer condition group 4		KDKG4	CHAR	4	TVKGG
KDKG5	Customer condition group 5		KDKG5	CHAR	4	TVKGG
XKNZA	Indicator: Alternative payer using account number		XKNZA	CHAR	2
FITYP	Tax type		J_1AFITP_D	CHAR	4	J_1AFITP
STCDT	Tax Number Type		J_1ATOID	CHAR	4	J_1ATODC
STCD3	Tax Number 3		STCD3	CHAR	36
STCD4	Tax Number 4		STCD4	CHAR	36
STCD5	Tax Number 5		STCD5	CHAR	120
STCD6	Tax Number 6		STCD6	CHAR	40
XICMS	Customer is ICMS-exempt		J_1BTCICMS	CHAR	2
XXIPI	Customer is IPI-exempt		J_1BTCIPI	CHAR	2
XSUBT	Customer group for Substitui�ao Tribut�ria calculation		J_1BTCST	CHAR	6	J_1BTXSTG
CFOPC	Customer's CFOP category		J_1BINDUS1	CHAR	4
TXLW1	Tax law: ICMS		J_1BTAXLW1	CHAR	6	J_1BATL1
TXLW2	Tax law: IPI		J_1BTAXLW2	CHAR	6	J_1BATL2
CCC01	Indicator for biochemical warfare for legal control		CCC01	CHAR	2
CCC02	Indicator for nuclear nonproliferation for legal control		CCC02	CHAR	2
CCC03	Indicator for national security for legal control		CCC03	CHAR	2
CCC04	Indicator for missile technology for legal control		CCC04	CHAR	2
.INCLUDE				TWTAX_S_KNA1	0
BONDED_AREA_CONFIRM	TW: Bonded Area Confirm in Business Partner Extension		TWVAT_BONDED_AREA_CONF	CHAR	2
DONATE_MARK	TW: Donate Mark in Business Partner Extension		TWVAT_DONATE_MARK	CHAR	2
CONSOLIDATE_INVOICE	Consolidated Invoicing for Taiwan		TWGUI_CONSOLIDATE_INVOICE	CHAR	2
ALLOWANCE_TYPE	TW: Allowance Type in Business Partner Extension		TWVAT_ALLOWANCE_TYPE	CHAR	2
EINVOICE_MODE	Taiwan, China: Mode in Business Partner Extension		TWVAT_EINVOICE_MODE	CHAR	2
CASSD	Central sales block for customer		CASSD_X	CHAR	4
KNURL	Uniform resource locator		URL	CHAR	264
J_1KFREPRE	Name of Representative		REPRES	CHAR	20
J_1KFTBUS	Type of Business		GESTYP	CHAR	60	BUSTYPE
J_1KFTIND	Type of Industry		INDTYP	CHAR	60	INDUSTYPE
CONFS	Status of Change Authorization (Central)		CONFS_X	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	Central deletion block for master record		NODEL_X	CHAR	2
DEAR6	Indicator: Consumer		DEAR6	CHAR	2
DELIVERY_DATE_RULE	Delivery Date Rule		SD_DELIVERY_DATE_TYPE_RULE	CHAR	2
CVP_XBLCK	Business Purpose Completed Flag		CVP_XBLCK	CHAR	2
.INCLUDE				KNA1BRAZIL	0
SUFRAMA	Suframa Code		J_1BSUFRAMA	CHAR	18
RG	RG Number		J_1BRG	CHAR	22
EXP	Issued by		J_1BEXP	CHAR	6
UF	State		J_1BUF	CHAR	4
RGDATE	RG Issuing Date		J_1BRGDATE	DATS	16
RIC	RIC Number		J_1BRIC	NUMC	22
RNE	Foreign National Registration		J_1BRNE	CHAR	20
RNEDATE	RNE Issuing Date		J_1BRNEDATE	DATS	16
CNAE	CNAE		J_1BCNAE	CHAR	14	J_1BTCNAE
LEGALNAT	Legal Nature		J_1BLEGALNAT	NUMC	8	J_1BTLEGALNAT
CRTN	CRT Number		J_1BCRTN	CHAR	2
ICMSTAXPAY	ICMS Taxpayer		J_1BICMSTAXPAY	CHAR	4	J_1BTICMSTAXPAY
INDTYP	Industry Main Type		J_1BINDTYP	CHAR	4	J_1BTINDTYP
TDT	Tax Declaration Type		J_1BTDT	CHAR	4	J_1BTTDT
COMSIZE	Company Size		J_1BCOMSIZE	CHAR	4	J_1BTCOMSIZE
DECREGPC	Declaration Regimen for PIS/COFINS		J_1BDECREGPC	CHAR	4	J_1BTDECREGPC
.INCLUDE				PHI_KNA1_I	0
PH_BIZ_STYLE	PH Business Style Text		PH_BIZ_STYLE	CHAR	280
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