SAP ABAP Table JSVSTRUPDA (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	LAND1_ALT	☑	LAND1	LAND1	CHAR	3	0	Country Key	T005
3	ALORT_ALT	☑	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	JSTORTPRO
4	STRNR_ALT	☑	STRASSENNR	STRASSENNR	CHAR	10	0	IS-M: Street Number	JSTSTRPRO
5	LAND1	☑	LAND1	LAND1	CHAR	3	0	Country Key	T005
6	ALORT	☑	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	JSTORTPRO
7	STRASSENNR	☑	STRASSENNR	STRASSENNR	CHAR	10	0	IS-M: Street Number	JSTSTRPRO
8	STR_NAME_L	☐	STR_NAME_L	TEXT50	CHAR	50	0	IS-M: Street Name (long)
9	OTL_KEY	☐	OTL_KEY	OTL_KEY	CHAR	3	0	IS-M: City District Number	JSTOTLPRO
10	KREISG_SCH	☐	KREISG_SCH	KREISG_SCH	CHAR	15	0	IS-M: District Municipality Key	JSTKGSPRO
11	HNRKENN	☐	HNRKENN	HAUSNRKENN	CHAR	1	0	IS-M: Identifier for House Number Range
12	HNR1VON	☐	HNR1VON	HAUSNUMMER	CHAR	10	0	IS-M: House Number From (Numerical)
13	HNR2VON	☐	HNR2VON	HNRZUSATZ	CHAR	8	0	IS-M/SD: Affix to First House Number (Alphanumeric)
14	HNR1BIS	☐	HNR1BIS	HAUSNUMMER	CHAR	10	0	IS-M: House Numbers To (Numerical)
15	HNR2BIS	☐	HNR2BIS	HNRZUSATZ	CHAR	8	0	IS-M/SD: Affix for Last House Number (Alphanumeric)
16	PLZ_ZSTR	☐	PLZ_ZSTR	NPSTLZ	CHAR	10	0	IS-M: Postal Code of Street Section for Home Delivery	JSTPLZPRO
17	STR_NRPOST	☐	STR_NRPOST	STR_NRPOST	CHAR	15	0	IS-M: Street number from German postal service
18	DBCODE_ALT	☐	DBCODE	DBCODE	CHAR	1	0	DB Code for Structural Changes
19	DBCODE_NEU	☐	DBCODE	DBCODE	CHAR	1	0	DB Code for Structural Changes
20	SUCHFELDS	☐	SUCHFELD	CHAR40	CHAR	40	0	Search field for accessing postal structures w/o matchcode
21	STR_NAME_K	☐	STR_NAME_K	TEXT25	CHAR	25	0	IS-M: Street Name (Short)
22	STR_NAME_G	☐	STR_NAME_G	JCHAR50_G	CHAR	50	0	IS-M: Street name - upper case for matchcode
23	STR_NAME_S	☐	STR_NAME_S	CHAR50	CHAR	50	0	IS-M: Street Name (Long Without Special Characters)
24	STRHNR1000	☐	STRHNR1000	STRHNR1000	CHAR	1	0	IS-M: 1000 column in house number interval
25	STR_CODE	☐	STR_CODE	STR_CODE	CHAR	3	0	IS-M: Street code for coding street sections
26	X_FEHLER	☐	X_FEHLER	ANKREUZ	CHAR	1	0	IS-M: Incorrect data record
27	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
28	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
29	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
30	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
31	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
32	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
33	VERSION_J	☐	VERSION_J	JAHR	NUMC	4	0	IS-M: Version year
34	VERSION_M	☐	VERSION_M	AM_MONAT	NUMC	2	0	IS-M: Version month
35	VERSION_T	☐	VERSION_T	AM_TAG	NUMC	2	0	IS-M: Version day
36	VERSION_NR	☐	VERSION_NR	VERSION_NR	CHAR	5	0	IS-M: Version number
37	LOESCH_VM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
38	ST_NAMEALT	☐	STR_NAME_L	TEXT50	CHAR	50	0	IS-M: Street Name (long)
39	STR_NRPALT	☐	STR_NRPOST	STR_NRPOST	CHAR	15	0	IS-M: Street number from German postal service
40	HNRKENNALT	☐	HNRKENN	HAUSNRKENN	CHAR	1	0	IS-M: Identifier for House Number Range
41	HNR1000ALT	☐	STRHNR1000	STRHNR1000	CHAR	1	0	IS-M: 1000 column in house number interval
42	HNR1VONALT	☐	HNR1VON	HAUSNUMMER	CHAR	10	0	IS-M: House Number From (Numerical)
43	HNR2VONALT	☐	HNR2VON	HNRZUSATZ	CHAR	8	0	IS-M/SD: Affix to First House Number (Alphanumeric)
44	HNR1BISALT	☐	HNR1BIS	HAUSNUMMER	CHAR	10	0	IS-M: House Numbers To (Numerical)
45	HNR2BISALT	☐	HNR2BIS	HNRZUSATZ	CHAR	8	0	IS-M/SD: Affix for Last House Number (Alphanumeric)
46	X_ADRESSEN	☐	X_ADRESSEN	XFELD	CHAR	1	0	IS-M: Update indicator: relevant addresses revised
47	X_STRUKTUR	☐	X_STRUKTUR	XFELD	CHAR	1	0	IS-M: Update indicator, related structures revised
48	X_POST_DB	☐	X_POST_DB	XFELD	CHAR	1	0	IS-M: Update indicator, postal DB edited

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JSVSTRUPDA	ALORT	JSTORTPRO	ALORT	KEY	1	CN
2	JSVSTRUPDA	ALORT_ALT	JSTORTPRO	ALORT	KEY	1	CN
3	JSVSTRUPDA	KREISG_SCH	JSTKGSPRO	KREISG_SCH	KEY	1	CN
4	JSVSTRUPDA	LAND1	T005	LAND1	KEY	1	CN
5	JSVSTRUPDA	LAND1_ALT	T005	LAND1	KEY	1	CN
6	JSVSTRUPDA	MANDT	T000	MANDT	KEY	1	CN
7	JSVSTRUPDA	OTL_KEY	JSTOTLPRO	OTL_KEY	KEY	1	CN
8	JSVSTRUPDA	PLZ_ZSTR	JSTPLZPRO	PLZNEU	KEY	1	CN
9	JSVSTRUPDA	STRASSENNR	JSTSTRPRO	STRASSENNR	KEY	1	CN
10	JSVSTRUPDA	STRNR_ALT	JSTSTRPRO	STRASSENNR	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in