SAP TABLES | SAP Media | Master Data(IS-M-MD) SAP IS

JST_PLZ_CONS SAP IS-M: Table for Postal Code Consolidation Table and data







JST_PLZ_CONS is a standard SAP Table which is used to store IS-M: Table for Postal Code Consolidation data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP JST_PLZ_CONS Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: L - Table for storing temporary data, delivered empty

Display/Maintenance via SM30: Allowed

Enhancement category i: Can be enhanced (character-type)
See here for more information about this and other SAP enhancement categories


SAP JST_PLZ_CONS Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
REC_IDNUMC10 Record ID
LAND1_ALTLAND1CHAR3 T005Country Key
PLZNEU_ALTPLZNEUCHAR10
*
IS-M: Postal code
PLZLFD_ALTPLZLFDNRNUMC3 IS-M/SD: Sequence number for postal code (for history)
LAND1LAND1CHAR3 T005Country Key
PLZNEUPLZNEUCHAR10
*
IS-M: Postal code
PLZLFDNRPLZLFDNRNUMC3 IS-M/SD: Sequence number for postal code (for history)
VERSIONCHAR7 Version
.INCLUDEJYTPLZINCL IS-PSD: Include with Attributes of Table JSTPLZPRO
.INCLUDEJYTPLZART Type of postal code for usage
X_ZUSTELLX_ZUSTELLCHAR1 IS-M: Postal code for home delivery
X_POSTFACHX_POSTFACHCHAR1 IS-M: Postal code for P.O.box
X_GRKUNDEX_GRKUNDECHAR1 IS-M: Postal code for major customer
X_GKGRUPPEX_GKGRUPPECHAR1 IS-M: Postal code for major customer group
X_AKTIONX_AKTIONCHAR1 Indicator: Sales Promotion Postal Code
X_SCHALTERX_SCHALTERCHAR1 Indicator: Postal code for counter collection
X_MILITARYX_MILITARYCHAR1 Military ZIP code
X_FEHLERX_FEHLERCHAR1 IS-M: Incorrect data record
.INCLUDEJYTUSER Created-By Data (Medium Scope)
ERFUSERERFUSERCHAR12 Created By
ERFDATEERFDATEDATS8 Created On
ERFTIMEERFTIMETIMS6 Time Created
AENUSERAENUSERCHAR12 Last Changed By
AENDATEAENDATEDATS8 Date of Last Change
AENTIMEAENTIMETIMS6 Time of Last Change
.INCLUDEJYTVERSION Version (for upgrade procedures for postal data)
VERSION_JVERSION_JNUMC4 IS-M: Version year
VERSION_MVERSION_MNUMC2 IS-M: Version month
VERSION_TVERSION_TNUMC2 IS-M: Version day
VERSION_NRVERSION_NRCHAR5
*
IS-M: Version numberALPHA
GUELTIGABGUELTIGVONDATS8 Valid-From Date
GUELTIGBISGUELTIGBISDATS8 Valid-To Date
LOESCH_VMLOEVM_ISPCHAR1 Deletion Flag for Master Data in Media Sales & Distribution
.INCLUDEJYTPLZFIELDS_USA IS-M: Additional Fields in JSTPLZPRO for US Country Version
.INCLUDEADDRSECZIPADDON IS-M: Structure for Enhanced Address Data
.INCLUDEADDRSECINCL Secondary Address (Without ZIP Add-On)
ADDRSECABBREVADDRSECABBREVCHAR4 TJS43IS-M: Secondary Address Text
ADDRSECNUMLOWADDRSECNUMLOWCHAR8 IS-M: Secondary Address Number (Lower Limit)ALPHA
ADDRSECNUMHIGHADDRSECNUMHIGHCHAR8 IS-M: Secondary Address NumberALPHA


ADDRSECODDEVENADDRSECODDEVENCHAR1 IS-M: Odd/Even Indicator for Secondary Address Number
ZIPADDONLOWJZIPADDONLOWCHAR4 IS-M: Extension of 5-digit ZIP code (lower limit)
ZIPADDONHIGHJZIPADDONHIGHCHAR4 IS-M: Extension of 5-digit ZIP code (upper limit)
COUNTYNOCOUNCCHAR3 T005ECounty Code
PLZ_FZ_NRPLZ_FZ_NRCHAR2 Destination Freight Depot Number
PLZ_BZ_NRPLZ_BZ_NRCHAR2 Destination Sorting Office Number



Key field
Non-key field