JSPLZZUOUPDA SAP (Change Records PCd 4-/6-Digit (Postal Data CH)) Table details

Dictionary Type: Table
Description: Change Records PCd 4-/6-Digit (Postal Data CH)




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




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

JSPLZZUOUPDA is a standard SAP Table which is used to store Change Records PCd 4-/6-Digit (Postal Data CH) data and is available within R/3 SAP systems depending on the version and release level.

The JSPLZZUOUPDA table consists of various fields, each holding specific information or linking keys about Change Records PCd 4-/6-Digit (Postal Data CH) data available in SAP. These include LAND1_ALT (Country Key), PLZNEU_ALT (IS-M: Postal code), PLZPTT6_ALT (6-Digit Postal Code CH), 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: 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 or numeric)


SAP JSPLZZUOUPDA 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 MANDTCLNT3Assigned to domainMANDT
LAND1_ALTCountry Key LAND1CHAR3Assigned to domainLAND1LND
PLZNEU_ALTIS-M: Postal code PLZNEUCHAR10JSTPLZPRONPSTLZJSP
PLZPTT6_ALT6-Digit Postal Code CH PLZPTT6CHAR6PLZPTT6D
LAND1Country Key LAND1CHAR3Assigned to domainLAND1LND
PLZNEUIS-M: Postal code PLZNEUCHAR10JSTPLZPRONPSTLZJSP
PLZPTT66-Digit Postal Code CH PLZPTT6CHAR6PLZPTT6D
ORDNRPIS-M: Official number P (PTT) (CH) J_1SONRPCHAR5J_1SC5
ZDPLZIS-M: Postal code PLZNEUCHAR10JSTPLZPRONPSTLZJSP
GRUNDPLZIS-M: CH: 4-Digit Basic Postal Code CH J_1SGPLZNUMC4Assigned to domainJ_1SGPLZ
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
ZDORT Location0
KANTONIS-M: CH: Canton J_1SKANTONCHAR2J_1SC2
SPRCODE1IS-M: CH: Language Code 1 J_1SSPRCO1CHAR1J_1SC1
SPRCODE2IS-M: CH: Language Code 2 J_1SSPRCO2CHAR1J_1SC1
KZBOTENFIS-M: CH: Existing Membership in Carrier File J_1SZUBOTFCHAR1J_1SC1
GEMEINDENRIS-M: CH: Municipality Number from Federal Statistics Office J_1SGNRBFSCHAR5ALPHACHAR5KONV
GEMEINDENAIS-M: CH: Municipality Name J_1SGEMNAMCHAR18J_1SC18
AGGLOMNRIS-M: CH: Agglomeration Number J_1SAGGLNRCHAR5ALPHACHAR5KONV
KANTONPLREIS-M: Canton planning region (CH) J_1SKPLREGCHAR4J_1SC4
ERFUSERCreated By ERFUSERCHAR12USNAM
ERFDATECreated On ERFDATEDATS8DATUM
ERFTIMETime Created ERFTIMETIMS6UZEIT
AENUSERLast Changed By AENUSERCHAR12USNAM
AENDATEDate of Last Change AENDATEDATS8DATUM
AENTIMETime of Last Change AENTIMETIMS6UZEIT
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
LOESCH_VMDeletion Flag for Master Data in Media Sales & Distribution LOEVM_ISPCHAR1XFELD

Key field Non-key field



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

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

SELECT SINGLE *
FROM JSPLZZUOUPDA
INTO CORRESPONDING FIELDS OF WA_JSPLZZUOUPDA
WHERE...

How to access SAP table JSPLZZUOUPDA

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