JSTPLZPRO SAP (IS-M: Postal Codes) Table details

Dictionary Type: Table
Description: IS-M: Postal Codes




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




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

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

The JSTPLZPRO table consists of various fields, each holding specific information or linking keys about IS-M: Postal Codes data available in SAP. These include PLZNEU (IS-M: Postal code), PLZLFDNR (IS-M/SD: Sequence number for postal code (for history)), X_ZUSTELL (IS-M: Postal code for home delivery), X_POSTFACH (IS-M: Postal code for P.O.box).. 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: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP JSTPLZPRO 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
LAND1Country Key LAND1CHAR3T005LAND1LND
PLZNEUIS-M: Postal code PLZNEUCHAR10NPSTLZJSP
PLZLFDNRIS-M/SD: Sequence number for postal code (for history) PLZLFDNRNUMC3NUMC3
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 JSTPLZPRO using ABAP code

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

SELECT SINGLE *
FROM JSTPLZPRO
INTO CORRESPONDING FIELDS OF WA_JSTPLZPRO
WHERE...

How to access SAP table JSTPLZPRO

Within an ECC or HANA version of SAP you can also view further information about JSTPLZPRO 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!