JSTSTRPRO SAP (IS-M/SD: Street File (Post)) Table details

Dictionary Type: Table
Description: IS-M/SD: Street File (Post)




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




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

JSTSTRPRO is a standard SAP Table which is used to store IS-M/SD: Street File (Post) data and is available within R/3 SAP systems depending on the version and release level.

The JSTSTRPRO table consists of various fields, each holding specific information or linking keys about IS-M/SD: Street File (Post) data available in SAP. These include ALORT (IS-M: City Number (Unique)), STRASSENNR (IS-M: Street Number), STRNRPTT (IS-M: PTT street number (CH)), SUCHFELDS (Search field for accessing postal structures w/o matchcode).. 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 JSTSTRPRO 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
ALORTIS-M: City Number (Unique) JALORTCHAR8JSTORTPROALPHAALORTJSO
STRASSENNRIS-M: Street Number STRASSENNRCHAR10ALPHASTRASSENNRJSS
STRNRPTTIS-M: PTT street number (CH) J_1SSTRPTTNUMC6NUM06
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
.INCLU--AP 0
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 JSTSTRPRO using ABAP code

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

SELECT SINGLE *
FROM JSTSTRPRO
INTO CORRESPONDING FIELDS OF WA_JSTSTRPRO
WHERE...

How to access SAP table JSTSTRPRO

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