SAP ABAP Table JSTPLZORT (IS-M/SD: Assignment of Postal Codes to 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	TRANSP	Transparent table
Transparent table	JSTPLZORT	Table Relationship Diagram
Short Description	IS-M/SD: Assignment of Postal Codes to Cities

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	LAND1	☑	LAND1	LAND1	CHAR	3	0	Country Key	T005
2	PLZNEU	☑	PLZNEU	NPSTLZ	CHAR	10	0	IS-M: Postal code	JSTPLZPRO
3	PLZLFDNR	☑	PLZLFDNR	NUMC3	NUMC	3	0	IS-M/SD: Sequence number for postal code (for history)
4	ALORT	☑	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	JSTORTPRO
5	.INCLUDE	☐				0	0	IS-M/SD: Table for Upgrade of Table JSTPLZORT
6	X_FEHLER	☐	X_FEHLER	ANKREUZ	CHAR	1	0	IS-M: Incorrect data record
7	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
8	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
9	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
10	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
11	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
12	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
13	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
14	.INCLUDE	☐				0	0	Version (for upgrade procedures for postal data)
15	VERSION_J	☐	VERSION_J	JAHR	NUMC	4	0	IS-M: Version year
16	VERSION_M	☐	VERSION_M	AM_MONAT	NUMC	2	0	IS-M: Version month
17	VERSION_T	☐	VERSION_T	AM_TAG	NUMC	2	0	IS-M: Version day
18	VERSION_NR	☐	VERSION_NR	VERSION_NR	CHAR	5	0	IS-M: Version number	*
19	GUELTIGAB	☐	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
20	GUELTIGBIS	☐	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
21	LOESCH_VM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
22	ERWPLZ	☐	ERWPLZ	ERW_PLZ	CHAR	2	0	2-Digit Postal Code Extension CH

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JSTPLZORT	ALORT	JSTORTPRO	ALORT	KEY	1	CN
2	JSTPLZORT	LAND1	T005	LAND1	KEY	1	CN
3	JSTPLZORT	PLZNEU	JSTPLZPRO	PLZNEU	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in