SAP ABAP Table JKSDVZSADR (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster
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	ADRNR	☑	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number
3	HERK	☐	HERK	HERK	CHAR	1	0	IS-M: Use of Address
4	XADRLOE	☐	XLOES	XFELD	CHAR	1	0	IS-M: Deletion Flag for Address
5	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
6	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
7	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
8	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
9	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
10	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
11	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
12	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
13	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
14	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
15	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
16	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
17	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
18	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
19	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
20	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
21	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
22	PREDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
23	POSTDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
24	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	TJS43
25	ADDRSECNUMBER	☐	ADDRSECNUMBER	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
26	STREET2	☐	STREET2_ISM	TEXT35	CHAR	35	0	IS-M: Second street line
27	ALIASNAME	☐	ALIASNAME	TEXT50	CHAR	50	0	IS-M: Alias Text (Street Name + Suffix)
28	ERSTADR	☐	ERSTADR	ERSTADR	CHAR	1	0	IS-M: Address Proposal for Alternatives
29	POSTEINSTR	☐	STRASSENNR	STRASSENNR	CHAR	10	0	IS-M: Street Number
30	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
31	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
32	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
33	GP_REF	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	JGTGPNR
34	NAME1_MACO	☐	NAME1_ISPM	NAME_MACO	CHAR	35	0	IS-M: Business Partner Name (Upper Case for Matchcode)
35	NAME2_MACO	☐	NAME2_ISPM	NAME_MACO	CHAR	35	0	IS-M: Bus.Partner's First Name (Upper Case for Matchcode)
36	STRAS_MACO	☐	STRAS_ISPM	STRAS_MACO	CHAR	35	0	IS-M: Street Name
37	ORT01_MACO	☐	ORT01_ISPM	ORT01_MACO	CHAR	35	0	IS-M/SD: City Name (Upper Case for Matchcode)
38	ISPTELVWP	☐	ISPTELVWP	ISPTELVW	CHAR	10	0	IS-M: Area Code (Home)
39	ISPTELP	☐	ISPTELP	ISPTEL	CHAR	20	0	IS-M: Telephone Number
40	ISPTELVWD	☐	ISPTELVWD	ISPTELVW	CHAR	10	0	IS-M: Area Code - Work
41	ISPTELD	☐	ISPTELD	ISPTEL	CHAR	20	0	IS-M: Telephone Number
42	ISPHANDY	☐	ISPHANDY	CHAR30	CHAR	30	0	IS-M: Mobile Phone Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JKSDVZSADR	ADDRSECABBREV	TJS43	ADDRSECABBREV	KEY	1	CN
2	JKSDVZSADR	GP_REF	JGTGPNR	GPNR	REF	C	CN
3	JKSDVZSADR	LAND1	T005	LAND1	REF	C	CN
4	JKSDVZSADR	MANDT	T000	MANDT	KEY	1	CN
5	JKSDVZSADR	POSTDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
6	JKSDVZSADR	PREDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
7	JKSDVZSADR	REGIO	T005S	BLAND	REF	C	CN
8	JKSDVZSADR	SPRAS	T002	SPRAS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in