SAP ABAP Table V_KNA1ADR1 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_KNA1ADR1	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster	KNA1
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	KUNNR	☑	KUNNR	KUNNR	CHAR	10	0	Customer Number
3	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
4	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
5	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
6	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
7	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
8	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
9	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
10	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
11	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
12	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
13	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address
14	MCOD1	☐	MCDD1	CHAR25	CHAR	25	0	Search term for matchcode search
15	MCOD2	☐	MCDD2	CHAR25	CHAR	25	0	Search Term for Matchcode Search
16	MCOD3	☐	MCDD3	CHAR25	CHAR	25	0	Search term for matchcode search
17	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
18	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
19	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
20	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
21	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
22	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
23	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
24	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
25	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
26	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
27	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
28	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
29	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
30	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
31	PFORT	☐	PFORT_GP	TEXT35	CHAR	35	0	PO Box city
32	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
33	DUEFL	☐	DUEFL_BKPF	DUEFL_BKPF	CHAR	1	0	Status of Data Transfer into Subsequent Release
34	KNURL	☐	URL	TEXT132	CHAR	132	0	Uniform resource locator
35	PSOHS	☐	PSOHS	CHAR06	CHAR	6	0	House number: is no longer used from Release 4.6B
36	PSOST	☐	PSOST	PSOST	CHAR	28	0	Street: No longer used from Release 4.6B

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_KNA1ADR1	LAND1	T005	LAND1	REF	C	CN
2	V_KNA1ADR1	LZONE	TZONE	ZONE1	REF	C	CN
3	V_KNA1ADR1	MANDT	T000	MANDT	KEY	1	CN
4	V_KNA1ADR1	REGIO	T005S	BLAND	REF	C	CN
5	V_KNA1ADR1	SPRAS	T002	SPRAS	REF	1	CN
6	V_KNA1ADR1	TXJCD	TTXJ	TXJCD	REF	C	CN
7	V_KNA1ADR1	WERKS	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20140122
SAP Release Created in