SAP ABAP Table JYTPLZINCL (IS-PSD: Include with Attributes of Table JSTPLZPRO)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	INTTAB	Structure
Structure	JYTPLZINCL	Table Relationship Diagram
Short Description	IS-PSD: Include with Attributes of Table JSTPLZPRO

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	Type of postal code for usage
2	X_ZUSTELL	☐	X_ZUSTELL	XFELD	CHAR	1	0	IS-M: Postal code for home delivery
3	X_POSTFACH	☐	X_POSTFACH	XFELD	CHAR	1	0	IS-M: Postal code for P.O.box
4	X_GRKUNDE	☐	X_GRKUNDE	XFELD	CHAR	1	0	IS-M: Postal code for major customer
5	X_GKGRUPPE	☐	X_GKGRUPPE	XFELD	CHAR	1	0	IS-M: Postal code for major customer group
6	X_AKTION	☐	X_AKTION	XFELD	CHAR	1	0	Indicator: Sales Promotion Postal Code
7	X_SCHALTER	☐	X_SCHALTER	XFELD	CHAR	1	0	Indicator: Postal code for counter collection
8	X_MILITARY	☐	X_MILITARY	XFELD	CHAR	1	0	Military ZIP code
9	X_FEHLER	☐	X_FEHLER	ANKREUZ	CHAR	1	0	IS-M: Incorrect data record
10	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
11	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
12	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
13	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
14	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
15	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
16	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
17	.INCLUDE	☐				0	0	Version (for upgrade procedures for postal data)
18	VERSION_J	☐	VERSION_J	JAHR	NUMC	4	0	IS-M: Version year
19	VERSION_M	☐	VERSION_M	AM_MONAT	NUMC	2	0	IS-M: Version month
20	VERSION_T	☐	VERSION_T	AM_TAG	NUMC	2	0	IS-M: Version day
21	VERSION_NR	☐	VERSION_NR	VERSION_NR	CHAR	5	0	IS-M: Version number	*
22	GUELTIGAB	☐	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
23	GUELTIGBIS	☐	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
24	LOESCH_VM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
25	.INCLUDE	☐				0	0	IS-M: Additional Fields in JSTPLZPRO for US Country Version
26	.INCLUDE	☐				0	0	IS-M: Structure for Enhanced Address Data
27	.INCLUDE	☐				0	0	Secondary Address (Without ZIP Add-On)
28	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	TJS43
29	ADDRSECNUMLOW	☐	ADDRSECNUMLOW	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number (Lower Limit)
30	ADDRSECNUMHIGH	☐	ADDRSECNUMHIGH	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
31	ADDRSECODDEVEN	☐	ADDRSECODDEVEN	ODDEVENCODE	CHAR	1	0	IS-M: Odd/Even Indicator for Secondary Address Number
32	ZIPADDONLOW	☐	JZIPADDONLOW	CHAR4	CHAR	4	0	IS-M: Extension of 5-digit ZIP code (lower limit)
33	ZIPADDONHIGH	☐	JZIPADDONHIGH	CHAR4	CHAR	4	0	IS-M: Extension of 5-digit ZIP code (upper limit)
34	COUNTYNO	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
35	STATEABBREV	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
36	PLZ_FZ_NR	☐	PLZ_FZ_NR	CHAR02	CHAR	2	0	Destination Freight Depot Number
37	PLZ_BZ_NR	☐	PLZ_BZ_NR	CHAR02	CHAR	2	0	Destination Sorting Office Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JYTPLZINCL	ADDRSECABBREV	TJS43	ADDRSECABBREV
2	JYTPLZINCL	COUNTYNO	T005E	COUNC
3	JYTPLZINCL	STATEABBREV	T005S	BLAND

History

Last changed by/on	SAP	20110901
SAP Release Created in