JSTPLZUPDA SAP (IS-M/SD: Table for Upgrade of Table JSTPLZPRO) Table details

Dictionary Type: Table
Description: IS-M/SD: Table for Upgrade of Table JSTPLZPRO




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




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

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

The JSTPLZUPDA table consists of various fields, each holding specific information or linking keys about IS-M/SD: Table for Upgrade of Table JSTPLZPRO 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP JSTPLZUPDA 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
MANDTClient MANDTCLNT3T000MANDT
LAND1_ALTCountry Key LAND1CHAR3T005LAND1LND
PLZNEU_ALTIS-M: Postal code PLZNEUCHAR10JSTPLZPRONPSTLZJSP
PLZLFD_ALTIS-M/SD: Sequence number for postal code (for history) PLZLFDNRNUMC3NUMC3
LAND1Country Key LAND1CHAR3T005LAND1LND
PLZNEUIS-M: Postal code PLZNEUCHAR10JSTPLZPRONPSTLZJSP
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
DBCODE_ALTDB Code for Structural Changes DBCODECHAR1DBCODE
DBCODE_NEUDB Code for Structural Changes DBCODECHAR1DBCODE
X_ADRESSENIS-M: Update indicator: relevant addresses revised X_ADRESSENCHAR1XFELD
X_STRUKTURIS-M: Update indicator, related structures revised X_STRUKTURCHAR1XFELD
X_POST_DBIS-M: Update indicator, postal DB edited X_POST_DBCHAR1XFELD
AENDNRBISChange Number for To-Date of Structural Change AENDNRBISCHAR9JSTAENDERALPHAAENDNR
AENDNRBISDDate of Change Number Used to Change To-Date AENDNRBISDCHAR1AENDNRARTD
AENDNRABChange Number for From-Date of Structure Change AENDNRABCHAR9JSTAENDERALPHAAENDNR
AENDNRABDDate of Change Number Used to Change From-Date AENDNRABDCHAR1AENDNRARTD
AENDNRINITInitiating Change Number AENDNRINITCHAR9JSTAENDERALPHAAENDNR
AENDLFDNRISequence Number of Initiating Change Number AENDLFDNRINUMC4AENDLFDNR
AENDNRAKTChange Number in Process AENDNRAKTCHAR9JSTAENDERALPHAAENDNR
AENDLFDNRASequence Number of Currently Operative Change Number AENDLFDNRANUMC4AENDLFDNR
XAENDERStructure information being changed on other change number XAENDERCHAR1XFELD
XSTRUAKTIVStructure information inactive XSTRUAKTIVCHAR1XSTRUAKTIV
FCCODEFunction Control Code for Structure Changes FCCODECHAR2FCCODE
DBCODEFREIDB Code for Structural Changes DBCODECHAR1DBCODE
AENDNRVONChange Number Used for Transfer FROM Another Assignment AENDNRVONCHAR9JSTAENDERALPHAAENDNR
AENDLFDNRVSequence Number of Change Number Used for Transfer AENDLFDNRVNUMC4AENDLFDNR
AENDNRNACHChange Number Used to Transfer to Another Assignment AENDNRNACHCHAR9JSTAENDERALPHAAENDNR
AENDLFDNRNSequence Number of Change Number Used for Transfer AENDLFDNRNNUMC4AENDLFDNR

Key field Non-key field



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

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

SELECT SINGLE *
FROM JSTPLZUPDA
INTO CORRESPONDING FIELDS OF WA_JSTPLZUPDA
WHERE...

How to access SAP table JSTPLZUPDA

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