SAP ABAP Table M_MJSPA (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	M_MJSPA	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	ORTZUSA	☑	ORTZUSA	TEXT30	CHAR	30	0	IS-M: Affix for City Name
3	X_ZUSTELL	☑	X_ZUSTELL	XFELD	CHAR	1	0	IS-M: Postal code for home delivery
4	X_POSTFACH	☑	X_POSTFACH	XFELD	CHAR	1	0	IS-M: Postal code for P.O.box
5	X_GRKUNDE	☑	X_GRKUNDE	XFELD	CHAR	1	0	IS-M: Postal code for major customer
6	X_GKGRUPPE	☑	X_GKGRUPPE	XFELD	CHAR	1	0	IS-M: Postal code for major customer group
7	X_SCHALTER	☑	X_SCHALTER	XFELD	CHAR	1	0	Indicator: Postal code for counter collection
8	X_AKTION	☑	X_AKTION	XFELD	CHAR	1	0	Indicator: Sales Promotion Postal Code
9	ALORT	☑	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	JSTORTPRO
10	PLZNEU	☑	PLZNEU	NPSTLZ	CHAR	10	0	IS-M: Postal code
11	GUELTIGAB	☑	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
12	GUELTIGBIS	☑	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
13	LAND1	☑	LAND1	LAND1	CHAR	3	0	Country Key	T005
14	STATEABBREV	☑	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
15	ORT_NAME_L	☑	ORT_NAME_L	TEXT50	CHAR	50	0	IS-M: City name (long text)
16	X_MILITARY	☑	X_MILITARY	XFELD	CHAR	1	0	Military ZIP code

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	M_MJSPA	ALORT	JSTORTPRO	ALORT	KEY	1	CN
2	M_MJSPA	LAND1	T005	LAND1	KEY	1	CN
3	M_MJSPA	STATEABBREV	T005S	BLAND

History

Last changed by/on	SAP	20130529
SAP Release Created in