JSTSTRUPDA SAP (IS-M/SD: Table for Upgrading Table JSTSTRPRO) Table details

Dictionary Type: Table
Description: IS-M/SD: Table for Upgrading Table JSTSTRPRO




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




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

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

The JSTSTRUPDA table consists of various fields, each holding specific information or linking keys about IS-M/SD: Table for Upgrading Table JSTSTRPRO data available in SAP. These include LAND1_ALT (Country Key), ALORT_ALT (IS-M: City Number (Unique)), STRNR_ALT (IS-M: Street Number), 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 JSTSTRUPDA 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
ALORT_ALTIS-M: City Number (Unique) JALORTCHAR8JSTORTPROALPHAALORTJSO
STRNR_ALTIS-M: Street Number STRASSENNRCHAR10JSTSTRPROALPHASTRASSENNRJSS
LAND1Country Key LAND1CHAR3T005LAND1LND
ALORTIS-M: City Number (Unique) JALORTCHAR8JSTORTPROALPHAALORTJSO
STRASSENNRIS-M: Street Number STRASSENNRCHAR10JSTSTRPROALPHASTRASSENNRJSS
SUCHFELDSSearch field for accessing postal structures w/o matchcode SUCHFELDCHAR40CHAR40
STR_NAME_KIS-M: Street Name (Short) STR_NAME_KCHAR25TEXT25
STR_NAME_LIS-M: Street Name (long) STR_NAME_LCHAR50TEXT50JSN
STR_NAME_GIS-M: Street name - upper case for matchcode STR_NAME_GCHAR50JYTNFJCHAR50_GJSN
STR_NAME_SIS-M: Street Name (Long Without Special Characters) STR_NAME_SCHAR50CHAR50
OTL_KEYIS-M: City District Number OTL_KEYCHAR3JSTOTLPROALPHAOTL_KEY
KREISG_SCHIS-M: District Municipality Key KREISG_SCHCHAR15JSTKGSPROALPHAKREISG_SCH
HNRKENNIS-M: Identifier for House Number Range HNRKENNCHAR1HAUSNRKENN
HNR1VONIS-M: House Number From (Numerical) HNR1VONCHAR10HAUSNUMMER
HNR2VONIS-M/SD: Affix to First House Number (Alphanumeric) HNR2VONCHAR8HNRZUSATZ
HNR1BISIS-M: House Numbers To (Numerical) HNR1BISCHAR10HAUSNUMMER
HNR2BISIS-M/SD: Affix for Last House Number (Alphanumeric) HNR2BISCHAR8HNRZUSATZ
PLZ_ZSTRIS-M: Postal Code of Street Section for Home Delivery PLZ_ZSTRCHAR10JSTPLZPRONPSTLZ
STR_NRPOSTIS-M: Street number from German postal service STR_NRPOSTCHAR15ALPHASTR_NRPOST
STRHNR1000IS-M: 1000 column in house number interval STRHNR1000CHAR1STRHNR1000
STR_CODEIS-M: Street code for coding street sections STR_CODECHAR3ALPHASTR_CODE
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
PREDIRECTIONALPredirectional PREDIRECTIONALCHAR10TJS41DIRECTIONAL
SUFFIXABBREVSuffix to Street Name According to USPS SUFFIXABBREVCHAR4CHAR04
POSTDIRECTIONALPostdirectional POSTDIRECTIONALCHAR10TJS41DIRECTIONAL
RECORDTYPECODERecord Type in ZIP+4 File RECORDTYPECODECHAR1RECORDTYPECODE
CARRIERROUTEIDIndicates Whether Truck Routes are for Drop-Off or Delivery CARRIERROUTEIDCHAR4CHAR04
BUILDINGFIRMNAMEBuilding or Company Name BUILDINGFIRMNAMECHAR40TEXT40
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
LACSSTATUSINDLocatable Address Conversion Service (LACS) indicator LACSSTATUSINDCHAR1CHAR01
GOVTBLDGINDBuilding Type GOVTBLDGINDCHAR1GOVTBLDGINDICATOR
FINANCENOFinance Number; Required by USPS FINANCENOCHAR6CHAR06
STATEABBREVSTATE (State, Province, County) REGIOCHAR3T005SREGIO
COUNTYNOCounty Code COUNCCHAR3T005ECOUNC
CONGRDISTRICTNOCode for District in a Geographical Area CONGRDISTRICTNOCHAR2CHAR02
PREFCITYSTATEKEYCity Number from City State Product File CITYSTATEKEYCHAR6CHAR06
.INCLU--AP 0
STREETNAME_NENStreet Name (NEN Standard) STREETNAME_NENCHAR24TEXT24
STREETNAME_PTTStreet Name (PTT Standard) STREETNAME_PTTCHAR17CHAR17
SERIESINDICATORIndicator in PTT Postal Data: Street, Houseboat or Trailer SERIESINDICATORCHAR1SERIESINDICATOR
ST_NAMEALTIS-M: Street Name (long) STR_NAME_LCHAR50TEXT50JSN
STR_NRPALTIS-M: Street number from German postal service STR_NRPOSTCHAR15ALPHASTR_NRPOST
HNRKENNALTIS-M: Identifier for House Number Range HNRKENNCHAR1HAUSNRKENN
HNR1000ALTIS-M: 1000 column in house number interval STRHNR1000CHAR1STRHNR1000
HNR1VONALTIS-M: House Number From (Numerical) HNR1VONCHAR10HAUSNUMMER
HNR2VONALTIS-M/SD: Affix to First House Number (Alphanumeric) HNR2VONCHAR8HNRZUSATZ
HNR1BISALTIS-M: House Numbers To (Numerical) HNR1BISCHAR10HAUSNUMMER
HNR2BISALTIS-M/SD: Affix for Last House Number (Alphanumeric) HNR2BISCHAR8HNRZUSATZ
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
HNR1VON_ZUSIS-M: House Number From (Numerical) HNR1VONCHAR10HAUSNUMMER
HNR2VON_ZUSIS-M/SD: Affix to First House Number (Alphanumeric) HNR2VONCHAR8HNRZUSATZ
HNR1BIS_ZUSIS-M: House Numbers To (Numerical) HNR1BISCHAR10HAUSNUMMER
HNR2BIS_ZUSIS-M/SD: Affix for Last House Number (Alphanumeric) HNR2BISCHAR8HNRZUSATZ
.INCLU--AP 0
STRNRPTTIS-M: PTT street number (CH) J_1SSTRPTTNUMC6NUM06
STRARTIS-M: CH/S: Street Type J_1SSTRARTCHAR2Assigned to domainJ_1SSTRART
PRAEPCODEIS-M: CH/S: Preposition Code J_1SPRPCODCHAR2Assigned to domainJ_1SPRPCOD
SPRCODEIS-M: CH: Language Code J_1SSPRCODCHAR1J_1SC1
GRUNDPLZIS-M: CH: 4-Digit Basic Postal Code CH J_1SGPLZNUMC4Assigned to domainJ_1SGPLZ
ERWPLZ2-Digit Postal Code Extension CH ERWPLZCHAR2ERW_PLZ
STRSTAMMIS-M: CH/S: Street Master J_1SSTRSTACHAR10J_1SC10

Key field Non-key field



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

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

SELECT SINGLE *
FROM JSTSTRUPDA
INTO CORRESPONDING FIELDS OF WA_JSTSTRUPDA
WHERE...

How to access SAP table JSTSTRUPDA

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