KNA1 - General Data in Customer Master

General Data in Customer Master information is stored in SAP table KNA1.
It is part of development package VSCORE in software component LO-MD-BP-CM. This development package consists of objects that can be grouped under "Application development R/3 sales master data".

Fields for table KNA1

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
KUNNR	Customer Number	X	KUNNR	CHAR	20
LAND1	Country/Region Key		LAND1_GP	CHAR	6	T005
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	T005S
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	*
.INCLUDE				INCL_EEW_KNA1	0
KNA1_EEW_CUST	data element for customer		KNA1_EEW_CUST	CHAR	2
.INCLU--AP				CRMS4_BP_KNA1	0
RULE_EXCLUSION	Account Excluded from Rule-Based Assignment		CRMT_BUS_RULE_EXCLUSION	CHAR	2
.INCLUDE				INCL_EEW_KNA1_ADDR	0
KNA1_ADDR_EEW_CUST	Customer General addr. dep. extensibility		KNA1_ADDR_EEW_CUST	CHAR	2
.INCLU--AP				/VSO/R_KNA1_A	0
.INCLUDE				/VSO/R_KNA1_I	0
/VSO/R_PALHGT	Maximum Stacking Height of the Packaging Material (VSO)		/VSO/R_PAL_BIN_HGT	QUAN	7
/VSO/R_PAL_UL	Unit of Length for Packaging Material (VSO)		/VSO/R_PAL_UNIT_L	UNIT	6	T006
/VSO/R_PK_MAT	Customer-Related Packing for Each Packaging Material (VSO)		/VSO/M_PACK_BY_MAT	CHAR	2
/VSO/R_MATPAL	Packaging Material of the Customer in VSO		/VSO/M_MATNR_PAL	CHAR	80	MARA
/VSO/R_I_NO_LYR	Number Layers Under an Inter-Pallet (VSO)		/VSO/M_IPAL_NO_LYR	NUMC	4
/VSO/R_ONE_MAT	Packing Material-Specific for Each Packaging Material		/VSO/M_ONE_MAT	CHAR	2
/VSO/R_ONE_SORT	Pack Only One Package Type for Each PKM (VSO)		/VSO/M_ONE_SORT	CHAR	2
/VSO/R_ULD_SIDE	Side Preference of Loading/Unloading (VSO)		/VSO/M_UNLOAD_SIDE_PREF	NUMC	2
/VSO/R_LOAD_PREF	Front/Back Preference of Loading/Unloading (VSO)		/VSO/M_LOAD_PREF	NUMC	2
/VSO/R_DPOINT	Collective Unloading Point for VSO		/VSO/R_DELIVERYPOINT	CHAR	20	/VSO/R_DPOINT
.INCLU--AP				AKNA1_FMFG	0
ALC	Agency Location Code		FMFG_ALC	CHAR	16	FMFGT_ALC
PMT_OFFICE	Payment Office		FMFG_PMT_OFF	CHAR	10	FMFGT_PO
.INCLUDE				SI_FMFG_VP2	0
FEE_SCHEDULE	Fee schedule		FM_FEE_SCHED	CHAR	8
DUNS	DUNS Number		FMCCRDUNS	CHAR	18
DUNS4	DUNS+4		FMCCRDUNS4	CHAR	8
SAM_UE_ID	System for Award Management Unique Entity Identifier		FMFG_UNIQUE_ENTITY_ID	CHAR	24
SAM_EFT_IND	System for Award Management Electronic Funds Transfer Ind		FMFG_EFT_IND	CHAR	8
.INCLU--AP				AKNA1_PSO	0
PSOFG	Processor group		PSOFG	CHAR	20	PSO19
PSOIS	Subledger acct preprocessing procedure		PSOIS	CHAR	40
.INCLUDE				IADDR_PSO	0
PSON1	Name 1		NAME1_GP	CHAR	70
PSON2	Name 2		NAME2_GP	CHAR	70
PSON3	Name 3		NAME3_GP	CHAR	70
PSOVN	First Name		PSOVN	CHAR	70
PSOTL	Title		PSOTL	CHAR	40
PSOHS	House number: is no longer used from Release 4.6B		PSOHS	CHAR	12
PSOST	Street: No longer used from Release 4.6B		PSOST	CHAR	56
.INCLUDE				PSO21	0
PSOO1	Description		PSOO1	CHAR	100
PSOO2	Description		PSOO1	CHAR	100
PSOO3	Description		PSOO1	CHAR	100
PSOO4	Description		PSOO1	CHAR	100
PSOO5	Description		PSOO1	CHAR	100
.INCLU--AP				J_1IMOCUST_KNA1_A	0
J_1IEXCD	ECC Number		J_1IEXCD	CHAR	80
J_1IEXRN	Excise Registration Number		J_1IEXRN	CHAR	80
J_1IEXRG	Excise Range		J_1IEXRG	CHAR	120
J_1IEXDI	Excise Division		J_1IEXDI	CHAR	120
J_1IEXCO	Excise Commissionerate		J_1IEXCO	CHAR	120
J_1ICSTNO	Central Sales Tax Number		J_1ICSTNO	CHAR	80
J_1ILSTNO	Local Sales Tax Number		J_1ILSTNO	CHAR	80
J_1IPANNO	Permanent Account Number		J_1IPANNO	CHAR	80
J_1IEXCICU	Excise tax indicator for customer		J_1IEXCICU	CHAR	2	J_1ITAXIND
AEDAT	(Obsolete) Last Changed On � do not use		J_1IAEDAT_OBSOLETE	DATS	16
USNAM	(Obsolete) Changed by the user � do not use		J_1IUSNAM_OBSOLETE	CHAR	24
J_1ISERN	Service Tax Registration Number		J_1ISERN	CHAR	80
J_1IPANREF	PAN Reference Number		J_1IPANREF	CHAR	80
GST_TDS	GST TDS Registration		J_1IGSTTDS	CHAR	36
.INCLU--AP				J_3GKNA1A	0
.INCLUDE				J_3GKNA1S	0
J_3GETYP	Recipient Type		J_3GETYP	CHAR	4	J_3GZUETYP
J_3GREFTYP	Reference Type for Recipient		J_3GREFTYP	CHAR	4
PSPNR	WBS Element		PS_POSNR	NUMC	16	PRPS
COAUFNR	Order Number		AUFNR	CHAR	24	AUFK
J_3GAGEXT	External Sold-to Party		J_3GAGEXT	CHAR	20	KNA1
J_3GAGINT	Customer Internal Settlement		J_3GAGINT	CHAR	20	KNA1
J_3GAGDUMI	Dummy Recipient		J_3GDEMPST	CHAR	20	KNA1
J_3GAGSTDI	Standard Recipient		J_3GAGSTDI	CHAR	20	KNA1
LGORT	Storage location		LGORT_D	CHAR	8	T001L
KOKRS	Controlling Area		KOKRS	CHAR	8	TKA01
KOSTL	Cost Center		KOSTL	CHAR	20	CSKS
J_3GABGLG	Retirement Date Counts for Performance-Based Equipment		J_3GABGLG	CHAR	2
J_3GABGVG	Retirement Date Counts for Time-Based Equipment		J_3GABGVG	CHAR	2
J_3GABRART	Settlement Type		J_3GABRART	CHAR	2
J_3GSTDMON	Hours per Month		J_3GSTDMON	DEC	3
J_3GSTDTAG	Hours per Day		J_3GSTDTAG	DEC	3
J_3GTAGMON	Number of Days/Month		J_3GTAGMON	DEC	3
J_3GZUGTAG	Function for Settlement on Acquisition Date/PBE		J_3GZUGTAG	CHAR	2
J_3GMASCHB	"Fill PBE Documents" Indicator		J_3GMASCHB	CHAR	2
J_3GMEINSA	Indicator: Take Multiple Usage Periods into Account		J_3GMEINSA	CHAR	2
J_3GKEINSA	Indicator - Relevant to Short Operation Periods		J_3GKEINSA	CHAR	2
J_3GBLSPER	Blocking Indicator for Document Entry		J_3GBLSPER	CHAR	2
J_3GKLEIVO	Indicator: Calculate PBE as TBE		J_3GKLEIVO	CHAR	2
J_3GCALID	Calendar ID		J_3GCALID	CHAR	4	TFACD
J_3GVMONAT	Indicator for Complete Month		J_3GVMONAT	NUMC	2
J_3GABRKEN	Settlement Indicator		J_3GABRKEN	CHAR	2
J_3GLABRECH	Date of Last Settlement		J_3GLABRECH	DATS	16
J_3GAABRECH	Date of Current Settlement		J_3GAABRECH	DATS	16
J_3GZUTVHLG	Ind.: Acquisition Date Counts (as Daily Settlement for PBE)		J_3GZUTVHLG	CHAR	2
J_3GNEGMEN	Negative Quantities Allowed Even for Chronolog. Inv. Mgmt		J_3GNEGMEN	CHAR	2
J_3GFRISTLO	Indicator: Deadline Logic		J_3GFRISTLO	CHAR	2
J_3GEMINBE	Minimum Usage Period for Restricted Usage (Days)		J_3GEMINBE	NUMC	10
J_3GFMGUE	Release Notification Allowance for Unrestricted Usage (Days)		J_3GFMGUE	NUMC	10
J_3GZUSCHUE	Surcharge for Unrestricted Usage (Days)		J_3GZUSCHUE	NUMC	10
J_3GSCHPRS	Indicator: Shift Price		J_3GSCHPRS	CHAR	2
J_3GINVSTA	Status of Construction Site Inventory		J_3GINVSTA	CHAR	2
/SAPCEM/DBER	Planning Area		/SAPCEM/DBER	CHAR	16	/SAPCEM/DISPOBER
/SAPCEM/KVMEQ	Indicator: Settlement Qty Relevant to Equipment		/SAPCEM/KVMEQ	CHAR	2