SAP ABAP Table RJG_ADDRCHECK_ALV_CITIES (IS-M: Output List for Address Check: Cities)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M-MD (Application Component) Master Data
     ⤷ JMDGEN (Package) Generic Master Data Media

Basic Data

Table Category	INTTAB	Structure
Structure	RJG_ADDRCHECK_ALV_CITIES	Table Relationship Diagram
Short Description	IS-M: Output List for Address Check: Cities

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	.INCLUDE	☐				0	0	IS-M/SD: City File (Post)
2	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
3	ALORT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	*
4	.INCLUDE	☐				0	0	IS-PSD: Include with Attributes of Table JSTORTPRO
5	SUCHFELDO	☐	SUCHFELD	CHAR40	CHAR	40	0	Search field for accessing postal structures w/o matchcode
6	ORT_NAME_K	☐	ORT_NAME_K	TEXT25	CHAR	25	0	IS-M: City Name (Short Text)
7	ORT_NAME_L	☐	ORT_NAME_L	TEXT50	CHAR	50	0	IS-M: City name (long text)
8	ORT_NAME_G	☐	ORT_NAME_G	JCHAR50_G	CHAR	50	0	IS-M: City name in block capitals
9	ORT_NAME_S	☐	ORT_NAME_S	CHAR50	CHAR	50	0	IS-M: City Name (Long Text, No Special Characters)
10	ORTZUSA	☐	ORTZUSA	TEXT30	CHAR	30	0	IS-M: Affix for City Name
11	KREISG_SCH	☐	KREISG_SCH	KREISG_SCH	CHAR	15	0	IS-M: District Municipality Key	JSTKGSPRO
12	HERKKZORT	☐	HERKZORT	HERKUNFTKZ	CHAR	1	0	IS-M: Origin Indicator for City	TJS31
13	HERKKZSTR	☐	HERKZSTR	HERKUNFTKZ	CHAR	1	0	IS-M: Origin Indicator for Street File	TJS31
14	XSTRMANUEL	☐	XSTRMANUEL	XFELD	CHAR	1	0	IS-M: Additional Streets were Entered Manually
15	X_FEHLER	☐	X_FEHLER	ANKREUZ	CHAR	1	0	IS-M: Incorrect data record
16	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
17	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
18	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
19	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
20	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
21	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
22	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
23	.INCLUDE	☐				0	0	Version (for upgrade procedures for postal data)
24	VERSION_J	☐	VERSION_J	JAHR	NUMC	4	0	IS-M: Version year
25	VERSION_M	☐	VERSION_M	AM_MONAT	NUMC	2	0	IS-M: Version month
26	VERSION_T	☐	VERSION_T	AM_TAG	NUMC	2	0	IS-M: Version day
27	VERSION_NR	☐	VERSION_NR	VERSION_NR	CHAR	5	0	IS-M: Version number
28	GUELTIGAB	☐	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
29	GUELTIGBIS	☐	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
30	LOESCH_VM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
31	.INCLUDE	☐				0	0	IS-M: Additional Fields in JSTORTPRO for US Country Version
32	CITYSTATEFACCODE	☐	CITYSTATEFACCODE	CITYSTATEFACCODE	CHAR	1	0	Type of Location Defined by the City Name
33	PREFCITYSTATEKEY	☐	PREFCITYSTATEKEY	CHAR06	CHAR	6	0	Preferred city number from city state product file
34	PREFCITYSTNAME	☐	PREFCITYSTNAME	TEXT28	CHAR	28	0	Preferred city name
35	CITYDELIND	☐	CITYDELIND	CHAR01	CHAR	1	0	Indicates Whether Carrier Routes Defined
36	CARRRTESORTIND	☐	CARRRTESORTIND	CHAR01	CHAR	1	0	Indicates Whether Price Reduction Possible for Letter Post
37	UNIQUEZIPIND	☐	UNIQUEZIPIND	CHAR01	CHAR	1	0	Indicates Whether or not ZIP Code is Unique
38	FINANCENO	☐	FINANCENO	CHAR06	CHAR	6	0	Finance Number; Required by USPS
39	STATEABBREV	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
40	COUNTYNO	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
41	ORT_NAME_AL	☐	ORT_NAME_AL	TEXT50	CHAR	50	0	IS-M: Alternative City Name
42	.INCLU--AP	☐				0	0	Structure for Additional City Fields (NL)
43	CEBUCOCODE	☐	CEBUCOCODE	CEBUCOCODE	CHAR	3	0	Cebuco Code	*
44	CITYNAME_NEN	☐	CITYNAME_NEN	CHAR24	CHAR	24	0	City Name (NEN Standard)
45	POST_CODE	☐	PLZNEU	NPSTLZ	CHAR	10	0	IS-M: Postal code	*
46	MULTIPLE_PC	☐	JMULTIPLE_PC	XFELD	CHAR	1	0	Several Postal Codes Exist for City
47	REGIO_BEZEI	☐	ISM_REGIO_TEXT	TEXT20	CHAR	20	0	Region (State, Province, County): Text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJG_ADDRCHECK_ALV_CITIES	COUNTYNO	T005E	COUNC
2	RJG_ADDRCHECK_ALV_CITIES	HERKKZORT	TJS31	HERKUNFTKZ	KEY	1	CN
3	RJG_ADDRCHECK_ALV_CITIES	HERKKZSTR	TJS31	HERKUNFTKZ	KEY	1	CN
4	RJG_ADDRCHECK_ALV_CITIES	KREISG_SCH	JSTKGSPRO	KREISG_SCH	KEY	1	CN
5	RJG_ADDRCHECK_ALV_CITIES	LAND1	T005	LAND1	KEY	1	CN
6	RJG_ADDRCHECK_ALV_CITIES	STATEABBREV	T005S	BLAND

History

Last changed by/on	SAP	20130529
SAP Release Created in