Name: Customer Master Table in SAP | KNA1 Field Definitions and Relationships
Creator: QueryViz.io

fields (21)

field	type	length	key	description
`KUNNR`	char	10	pk	customer number
`MANDT`	clnt	3	pk	client
`ADRNR`	char	10		address number
`AUFSD`	char	2		central order block
`ERDAT`	dats	8		created on
`ERNAM`	char	12		created by
`KONZS`	char	10		group key
`KTOKD`	char	4		customer account group
`LAND1`	char	3		country key
`LOEVM`	char	1		deletion flag (central)
`NAME1`	char	35		name 1
`NAME2`	char	35		name 2
`ORT01`	char	35		city
`PSTLZ`	char	10		postal code
`SPERR`	char	1		central posting block
`SPRAS`	lang	1		language key
`STCD1`	char	16		tax number 1
`STCEG`	char	20		vat registration number
`STRAS`	char	35		street address
`TELF1`	char	16		telephone 1
`TELFX`	char	31		fax number

relationships (24)

field	type	length	key	description
`KUNNR`	char	10	pk	customer number
`MANDT`	clnt	3	pk	client
`ADRNR`	char	10		address number
`AUFSD`	char	2		central order block
`ERDAT`	dats	8		created on
`ERNAM`	char	12		created by
`KONZS`	char	10		group key
`KTOKD`	char	4		customer account group
`LAND1`	char	3		country key
`LOEVM`	char	1		deletion flag (central)
`NAME1`	char	35		name 1
`NAME2`	char	35		name 2
`ORT01`	char	35		city
`PSTLZ`	char	10		postal code
`SPERR`	char	1		central posting block
`SPRAS`	lang	1		language key
`STCD1`	char	16		tax number 1
`STCEG`	char	20		vat registration number
`STRAS`	char	35		street address
`TELF1`	char	16		telephone 1
`TELFX`	char	31		fax number