SAP ABAP Table M_MJSSE (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	M_MJSSE	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	ORT_NAME_G	☑	ORT_NAME_G	JCHAR50_G	CHAR	50	0	IS-M: City name in block capitals
2	STR_NAME_G	☑	STR_NAME_G	JCHAR50_G	CHAR	50	0	IS-M: Street name - upper case for matchcode
3	HNRKENN	☑	HNRKENN	HAUSNRKENN	CHAR	1	0	IS-M: Identifier for House Number Range
4	HNR1VON	☑	HNR1VON	HAUSNUMMER	CHAR	10	0	IS-M: House Number From (Numerical)
5	HNR2VON	☑	HNR2VON	HNRZUSATZ	CHAR	8	0	IS-M/SD: Affix to First House Number (Alphanumeric)
6	HNR1BIS	☑	HNR1BIS	HAUSNUMMER	CHAR	10	0	IS-M: House Numbers To (Numerical)
7	HNR2BIS	☑	HNR2BIS	HNRZUSATZ	CHAR	8	0	IS-M/SD: Affix for Last House Number (Alphanumeric)
8	PLZ_ZSTR	☑	PLZ_ZSTR	NPSTLZ	CHAR	10	0	IS-M: Postal Code of Street Section for Home Delivery	JSTPLZPRO
9	STRHNR1000	☑	STRHNR1000	STRHNR1000	CHAR	1	0	IS-M: 1000 column in house number interval
10	LAND1	☑	LAND1	LAND1	CHAR	3	0	Country Key	T005
11	ALORT	☑	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	JSTORTPRO
12	STRASSENNR	☑	STRASSENNR	STRASSENNR	CHAR	10	0	IS-M: Street Number
13	ORTZUSA	☐	ORTZUSA	TEXT30	CHAR	30	0	IS-M: Affix for City Name
14	KREISG_SCH	☐	KREISG_SCH	KREISG_SCH	CHAR	15	0	IS-M: District Municipality Key	JSTKGSPRO
15	GUELTIGAB	☐	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
16	GUELTIGBIS	☐	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
17	LOESCH_VM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
18	PREDIRECTIONAL	☐	PREDIRECTIONAL	DIRECTIONAL	CHAR	10	0	Predirectional	TJS41
19	SUFFIXABBREV	☐	SUFFIXABBREV	CHAR04	CHAR	4	0	Suffix to Street Name According to USPS
20	POSTDIRECTIONAL	☐	POSTDIRECTIONAL	DIRECTIONAL	CHAR	10	0	Postdirectional	TJS41
21	RECORDTYPECODE	☐	RECORDTYPECODE	RECORDTYPECODE	CHAR	1	0	Record Type in ZIP+4 File
22	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	TJS43
23	ADDRSECNUMLOW	☐	ADDRSECNUMLOW	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number (Lower Limit)
24	ADDRSECNUMHIGH	☐	ADDRSECNUMHIGH	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
25	ADDRSECODDEVEN	☐	ADDRSECODDEVEN	ODDEVENCODE	CHAR	1	0	IS-M: Odd/Even Indicator for Secondary Address Number
26	ZIPADDONLOW	☐	JZIPADDONLOW	CHAR4	CHAR	4	0	IS-M: Extension of 5-digit ZIP code (lower limit)
27	ZIPADDONHIGH	☐	JZIPADDONHIGH	CHAR4	CHAR	4	0	IS-M: Extension of 5-digit ZIP code (upper limit)
28	ORT_NAME_L	☐	ORT_NAME_L	TEXT50	CHAR	50	0	IS-M: City name (long text)
29	STR_NAME_L	☐	STR_NAME_L	TEXT50	CHAR	50	0	IS-M: Street Name (long)
30	STATEABBREV	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	M_MJSSE	ADDRSECABBREV	TJS43	ADDRSECABBREV
2	M_MJSSE	ALORT	JSTORTPRO	ALORT	KEY	1	CN
3	M_MJSSE	KREISG_SCH	JSTKGSPRO	KREISG_SCH	KEY	1	CN
4	M_MJSSE	LAND1	T005	LAND1	KEY	1	CN
5	M_MJSSE	PLZ_ZSTR	JSTPLZPRO	PLZNEU	KEY	1	CN
6	M_MJSSE	POSTDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
7	M_MJSSE	PREDIRECTIONAL	TJS41	DIRECTIONAL		1	CN
8	M_MJSSE	STATEABBREV	T005S	BLAND

History

Last changed by/on	SAP	20130529
SAP Release Created in