JST_PLZ_CONS SAP (IS-M: Table for Postal Code Consolidation) Table details

Dictionary Type: Table
Description: IS-M: Table for Postal Code Consolidation




ABAP Code to SELECT data from JST_PLZ_CONS
Related tables to JST_PLZ_CONS
Access table JST_PLZ_CONS




Table field list including key, data, relationships and ABAP select examples

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.

The JST_PLZ_CONS table consists of various fields, each holding specific information or linking keys about IS-M: Table for Postal Code Consolidation data available in SAP. These include LAND1_ALT (Country Key), PLZNEU_ALT (IS-M: Postal code), PLZLFD_ALT (IS-M/SD: Sequence number for postal code (for history)), LAND1 (Country Key).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP JST_PLZ_CONS table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
REC_ID Record ID0
LAND1_ALTCountry Key LAND1CHAR3T005LAND1LND
PLZNEU_ALTIS-M: Postal code PLZNEUCHAR10Assigned to domainNPSTLZJSP
PLZLFD_ALTIS-M/SD: Sequence number for postal code (for history) PLZLFDNRNUMC3NUMC3
LAND1Country Key LAND1CHAR3T005LAND1LND
PLZNEUIS-M: Postal code PLZNEUCHAR10Assigned to domainNPSTLZJSP
PLZLFDNRIS-M/SD: Sequence number for postal code (for history) PLZLFDNRNUMC3NUMC3
VERSION Version0
X_ZUSTELLIS-M: Postal code for home delivery X_ZUSTELLCHAR1XFELD
X_POSTFACHIS-M: Postal code for P.O.box X_POSTFACHCHAR1XFELD
X_GRKUNDEIS-M: Postal code for major customer X_GRKUNDECHAR1XFELD
X_GKGRUPPEIS-M: Postal code for major customer group X_GKGRUPPECHAR1XFELD
X_AKTIONIndicator: Sales Promotion Postal Code X_AKTIONCHAR1XFELD
X_SCHALTERIndicator: Postal code for counter collection X_SCHALTERCHAR1XFELD
X_MILITARYMilitary ZIP code X_MILITARYCHAR1XFELD
X_FEHLERIS-M: Incorrect data record X_FEHLERCHAR1ANKREUZ
ERFUSERCreated By ERFUSERCHAR12USNAM
ERFDATECreated On ERFDATEDATS8DATUM
ERFTIMETime Created ERFTIMETIMS6UZEIT
AENUSERLast Changed By AENUSERCHAR12USNAM
AENDATEDate of Last Change AENDATEDATS8DATUM
AENTIMETime of Last Change AENTIMETIMS6UZEIT
VERSION_JIS-M: Version year VERSION_JNUMC4JAHR
VERSION_MIS-M: Version month VERSION_MNUMC2AM_MONAT
VERSION_TIS-M: Version day VERSION_TNUMC2AM_TAG
VERSION_NRIS-M: Version number VERSION_NRCHAR5Assigned to domainALPHAVERSION_NR
GUELTIGABValid-From Date GUELTIGVONDATS8DATUMJSA
GUELTIGBISValid-To Date GUELTIGBISDATS8DATUMJSB
LOESCH_VMDeletion Flag for Master Data in Media Sales & Distribution LOEVM_ISPCHAR1XFELD
ADDRSECABBREVIS-M: Secondary Address Text ADDRSECABBREVCHAR4TJS43ADDRSECABBREV
ADDRSECNUMLOWIS-M: Secondary Address Number (Lower Limit) ADDRSECNUMLOWCHAR8ALPHAADDRSECNUMBER
ADDRSECNUMHIGHIS-M: Secondary Address Number ADDRSECNUMHIGHCHAR8ALPHAADDRSECNUMBER
ADDRSECODDEVENIS-M: Odd/Even Indicator for Secondary Address Number ADDRSECODDEVENCHAR1ODDEVENCODE
ZIPADDONLOWIS-M: Extension of 5-digit ZIP code (lower limit) JZIPADDONLOWCHAR4CHAR4
ZIPADDONHIGHIS-M: Extension of 5-digit ZIP code (upper limit) JZIPADDONHIGHCHAR4CHAR4
COUNTYNOCounty Code COUNCCHAR3T005ECOUNC
STATEABBREVSTATE (State, Province, County) REGIOCHAR3T005SREGIO
PLZ_FZ_NRDestination Freight Depot Number PLZ_FZ_NRCHAR2CHAR02
PLZ_BZ_NRDestination Sorting Office Number PLZ_BZ_NRCHAR2CHAR02

Key field Non-key field



How do I retrieve data from SAP table JST_PLZ_CONS using ABAP code

The following ABAP code Example will allow you to do a basic selection on JST_PLZ_CONS to SELECT all data from the table
DATA: WA_JST_PLZ_CONS TYPE JST_PLZ_CONS.

SELECT SINGLE *
FROM JST_PLZ_CONS
INTO CORRESPONDING FIELDS OF WA_JST_PLZ_CONS
WHERE...

How to access SAP table JST_PLZ_CONS

Within an ECC or HANA version of SAP you can also view further information about JST_PLZ_CONS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!