SAP ABAP Table JSVORTUPDA (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JSVORTUPDA	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	LAND1	☑	LAND1	LAND1	CHAR	3	0	Country Key	T005
5	ALORT	☑	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)
6	ORT_NAME_L	☐	ORT_NAME_L	TEXT50	CHAR	50	0	IS-M: City name (long text)
7	ORTZUSA	☐	ORTZUSA	TEXT30	CHAR	30	0	IS-M: Affix for City Name
8	KREISG_SCH	☐	KREISG_SCH	KREISG_SCH	CHAR	15	0	IS-M: District Municipality Key
9	DBCODE_ALT	☐	DBCODE	DBCODE	CHAR	1	0	DB Code for Structural Changes
10	DBCODE_NEU	☐	DBCODE	DBCODE	CHAR	1	0	DB Code for Structural Changes
11	SUCHFELDO	☐	SUCHFELD	CHAR40	CHAR	40	0	Search field for accessing postal structures w/o matchcode
12	ORT_NAME_K	☐	ORT_NAME_K	TEXT25	CHAR	25	0	IS-M: City Name (Short Text)
13	ORT_NAME_G	☐	ORT_NAME_G	JCHAR50_G	CHAR	50	0	IS-M: City name in block capitals
14	ORT_NAME_S	☐	ORT_NAME_S	CHAR50	CHAR	50	0	IS-M: City Name (Long Text, No Special Characters)
15	HERKKZORT	☐	HERKZORT	HERKUNFTKZ	CHAR	1	0	IS-M: Origin Indicator for City	TJS31
16	HERKKZSTR	☐	HERKZSTR	HERKUNFTKZ	CHAR	1	0	IS-M: Origin Indicator for Street File	TJS31
17	XSTRMANUEL	☐	XSTRMANUEL	XFELD	CHAR	1	0	IS-M: Additional Streets were Entered Manually
18	X_FEHLER	☐	X_FEHLER	ANKREUZ	CHAR	1	0	IS-M: Incorrect data record
19	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
20	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
21	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
22	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
23	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
24	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
25	VERSION_J	☐	VERSION_J	JAHR	NUMC	4	0	IS-M: Version year
26	VERSION_M	☐	VERSION_M	AM_MONAT	NUMC	2	0	IS-M: Version month
27	VERSION_T	☐	VERSION_T	AM_TAG	NUMC	2	0	IS-M: Version day
28	VERSION_NR	☐	VERSION_NR	VERSION_NR	CHAR	5	0	IS-M: Version number	TJS00
29	LOESCH_VM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
30	ORTNAMEALT	☐	ORT_NAME_L	TEXT50	CHAR	50	0	IS-M: City name (long text)
31	X_ADRESSEN	☐	X_ADRESSEN	XFELD	CHAR	1	0	IS-M: Update indicator: relevant addresses revised
32	X_STRUKTUR	☐	X_STRUKTUR	XFELD	CHAR	1	0	IS-M: Update indicator, related structures revised
33	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	JSVORTUPDA	ALORT_ALT	JSTORTPRO	ALORT	KEY	1	CN
2	JSVORTUPDA	HERKKZORT	TJS31	HERKUNFTKZ	KEY	1	CN
3	JSVORTUPDA	HERKKZSTR	TJS31	HERKUNFTKZ	KEY	1	CN
4	JSVORTUPDA	LAND1	T005	LAND1	KEY	1	CN
5	JSVORTUPDA	LAND1_ALT	T005	LAND1	KEY	1	CN
6	JSVORTUPDA	MANDT	T000	MANDT	KEY	1	CN
7	JSVORTUPDA	VERSION_NR	TJS00	VERSION_T

History

Last changed by/on	SAP	20130529
SAP Release Created in