SAP ABAP Table JSTALIAS (IS-M: Alias Table for Streets)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JSTALIAS	Table Relationship Diagram
Short Description	IS-M: Alias Table for Streets

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	ALIASLFDNR	☑	ALIASLFDNR	NUMC10	NUMC	10	0	IS-M: Sequence Number for Alias Table (Key)
2	.INCLUDE	☐				0	0	Include Structure for Alias (Direction, Area, Search Field)
3	ALIASPREDIRECTN	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	*
4	ALIASPOSTDIRECTN	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	*
5	ALIASDELADDRLOW	☐	ADDRPRIMLOW	HAUSNUMMER	CHAR	10	0	IS-M: Primary House Number (Lower Limit)
6	ALIASDELADDRHIGH	☐	ADDRPRIMHIGH	HAUSNUMMER	CHAR	10	0	IS-M: Primary House Number (Upper Limit)
7	ALIASDELODDEVEN	☐	ODDEVENCODE	ODDEVENCODE	CHAR	1	0	IS-M: Indicator - Even/Odd/All
8	SUCHFELDALIAS	☐	SUCHFELD	CHAR40	CHAR	40	0	Search field for accessing postal structures w/o matchcode
9	.INCLUDE	☐				0	0	Core address data
10	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
11	PSTLZ_ADDON	☐	PSTLZ_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code
12	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
13	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
14	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
15	PSTL2_ADDON	☐	PSTL2_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (PO Box)
16	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
17	PSTL3_ADDON	☐	PSTL3_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (Company)
18	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
19	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
20	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
21	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
22	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
23	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
24	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
25	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
26	PREDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
27	POSTDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
28	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	TJS43
29	ADDRSECNUMBER	☐	ADDRSECNUMBER	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
30	STREET2	☐	STREET2_ISM	TEXT35	CHAR	35	0	IS-M: Second street line
31	.INCLUDE	☐				0	0	Include Structure for Alias (Alias Name)
32	ALIASNAME	☐	ALIASNAME	TEXT50	CHAR	50	0	IS-M: Alias Text (Street Name + Suffix)
33	ALORT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	*
34	STRASSENNR	☐	STRASSENNR	STRASSENNR	CHAR	10	0	IS-M: Street Number	*
35	GUELTIGAB	☐	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
36	GUELTIGBIS	☐	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
37	LOESCH_VM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
38	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
39	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
40	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
41	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
42	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
43	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
44	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
45	.INCLUDE	☐				0	0	Version (for upgrade procedures for postal data)
46	VERSION_J	☐	VERSION_J	JAHR	NUMC	4	0	IS-M: Version year
47	VERSION_M	☐	VERSION_M	AM_MONAT	NUMC	2	0	IS-M: Version month
48	VERSION_T	☐	VERSION_T	AM_TAG	NUMC	2	0	IS-M: Version day
49	VERSION_NR	☐	VERSION_NR	VERSION_NR	CHAR	5	0	IS-M: Version number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JSTALIAS	ADDRSECABBREV	TJS43	ADDRSECABBREV	KEY	1	CN
2	JSTALIAS	LAND1	T005	LAND1	REF	C	CN
3	JSTALIAS	POSTDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
4	JSTALIAS	PREDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in