SAP Table JSTSTRPRO
IS-M/SD: Street File (Post)
JSTSTRPRO (IS-M/SD: Street File (Post)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link JSTSTRPRO to other SAP tables.
JSTSTRPRO table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
LAND1
Country Key
|
LAND1 | T005 |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||
|
ALORT
IS-M: City Number (Unique)
|
JALORT | JSTORTPRO |
CHAR
|
8 | 0 | |||||||||||||||||||||||||||
|
STRASSENNR
IS-M: Street Number
|
STRASSENNR |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||
|
STRNRPTT
IS-M: PTT street number (CH)
|
J_1SSTRPTT |
NUMC
|
6 | 0 | ||||||||||||||||||||||||||||
|
SUCHFELDS
Search field for accessing postal structures w/o matchcode
|
SUCHFELD |
CHAR
|
40 | 0 | ||||||||||||||||||||||||||||
|
STR_NAME_K
IS-M: Street Name (Short)
|
STR_NAME_K |
CHAR
|
25 | 0 | ||||||||||||||||||||||||||||
|
STR_NAME_L
IS-M: Street Name (long)
|
STR_NAME_L |
CHAR
|
50 | 0 | ||||||||||||||||||||||||||||
|
STR_NAME_G
IS-M: Street name - upper case for matchcode
|
STR_NAME_G |
CHAR
|
50 | 0 | ||||||||||||||||||||||||||||
|
STR_NAME_S
IS-M: Street Name (Long Without Special Characters)
|
STR_NAME_S |
CHAR
|
50 | 0 | ||||||||||||||||||||||||||||
|
OTL_KEY
IS-M: City District Number
|
OTL_KEY | JSTOTLPRO |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||
|
KREISG_SCH
IS-M: District Municipality Key
|
KREISG_SCH | JSTKGSPRO |
CHAR
|
15 | 0 | |||||||||||||||||||||||||||
|
HNRKENN
IS-M: Identifier for House Number Range
|
HNRKENN |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
HNR1VON
IS-M: House Number From (Numerical)
|
HNR1VON |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||
|
HNR2VON
IS-M/SD: Affix to First House Number (Alphanumeric)
|
HNR2VON |
CHAR
|
8 | 0 | ||||||||||||||||||||||||||||
|
HNR1BIS
IS-M: House Numbers To (Numerical)
|
HNR1BIS |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||
|
HNR2BIS
IS-M/SD: Affix for Last House Number (Alphanumeric)
|
HNR2BIS |
CHAR
|
8 | 0 | ||||||||||||||||||||||||||||
|
PLZ_ZSTR
IS-M: Postal Code of Street Section for Home Delivery
|
PLZ_ZSTR | JSTPLZPRO |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||
|
STR_NRPOST
IS-M: Street number from German postal service
|
STR_NRPOST |
CHAR
|
15 | 0 | ||||||||||||||||||||||||||||
|
STRHNR1000
IS-M: 1000 column in house number interval
|
STRHNR1000 |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
STR_CODE
IS-M: Street code for coding street sections
|
STR_CODE |
CHAR
|
3 | 0 | ||||||||||||||||||||||||||||
|
X_FEHLER
IS-M: Incorrect data record
|
X_FEHLER |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
ERFUSER
Created By
|
ERFUSER |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||
|
ERFDATE
Created On
|
ERFDATE |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||
|
ERFTIME
Time Created
|
ERFTIME |
TIMS
|
6 | 0 | ||||||||||||||||||||||||||||
|
AENUSER
Last Changed By
|
AENUSER |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||
|
AENDATE
Date of Last Change
|
AENDATE |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||
|
AENTIME
Time of Last Change
|
AENTIME |
TIMS
|
6 | 0 | ||||||||||||||||||||||||||||
|
VERSION_J
IS-M: Version year
|
VERSION_J |
NUMC
|
4 | 0 | ||||||||||||||||||||||||||||
|
VERSION_M
IS-M: Version month
|
VERSION_M |
NUMC
|
2 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
VERSION_T
IS-M: Version day
|
VERSION_T |
NUMC
|
2 | 0 | ||||||||||||||||||||||||||||
|
VERSION_NR
IS-M: Version number
|
VERSION_NR |
CHAR
|
5 | 0 | ||||||||||||||||||||||||||||
|
GUELTIGAB
Valid-From Date
|
GUELTIGVON |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||
|
GUELTIGBIS
Valid-To Date
|
GUELTIGBIS |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||
|
LOESCH_VM
Deletion Flag for Master Data in Media Sales & Distribution
|
LOEVM_ISP |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
PREDIRECTIONAL
Predirectional
|
PREDIRECTIONAL | TJS41 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||
|
SUFFIXABBREV
Suffix to Street Name According to USPS
|
SUFFIXABBREV |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||||
|
POSTDIRECTIONAL
Postdirectional
|
POSTDIRECTIONAL | TJS41 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||
|
RECORDTYPECODE
Record Type in ZIP+4 File
|
RECORDTYPECODE |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
CARRIERROUTEID
Indicates Whether Truck Routes are for Drop-Off or Delivery
|
CARRIERROUTEID |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||||
|
BUILDINGFIRMNAME
Building or Company Name
|
BUILDINGFIRMNAME |
CHAR
|
40 | 0 | ||||||||||||||||||||||||||||
|
ADDRSECABBREV
IS-M: Secondary Address Text
|
ADDRSECABBREV | TJS43 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
|
ADDRSECNUMLOW
IS-M: Secondary Address Number (Lower Limit)
|
ADDRSECNUMLOW |
CHAR
|
8 | 0 | ||||||||||||||||||||||||||||
|
ADDRSECNUMHIGH
IS-M: Secondary Address Number
|
ADDRSECNUMHIGH |
CHAR
|
8 | 0 | ||||||||||||||||||||||||||||
|
ADDRSECODDEVEN
IS-M: Odd/Even Indicator for Secondary Address Number
|
ADDRSECODDEVEN |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
ZIPADDONLOW
IS-M: Extension of 5-digit ZIP code (lower limit)
|
JZIPADDONLOW |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||||
|
ZIPADDONHIGH
IS-M: Extension of 5-digit ZIP code (upper limit)
|
JZIPADDONHIGH |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||||
|
LACSSTATUSIND
Locatable Address Conversion Service (LACS) indicator
|
LACSSTATUSIND |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
GOVTBLDGIND
Building Type
|
GOVTBLDGIND |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
FINANCENO
Finance Number; Required by USPS
|
FINANCENO |
CHAR
|
6 | 0 | ||||||||||||||||||||||||||||
|
STATEABBREV
Region (State, Province, County)
|
REGIO | T005S |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||
|
COUNTYNO
County Code
|
COUNC | T005E |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||
|
CONGRDISTRICTNO
Code for District in a Geographical Area
|
CONGRDISTRICTNO |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||
|
PREFCITYSTATEKEY
City Number from City State Product File
|
CITYSTATEKEY |
CHAR
|
6 | 0 | ||||||||||||||||||||||||||||
|
STREETNAME_NEN
Street Name (NEN Standard)
|
STREETNAME_NEN |
CHAR
|
24 | 0 | ||||||||||||||||||||||||||||
|
STREETNAME_PTT
Street Name (PTT Standard)
|
STREETNAME_PTT |
CHAR
|
17 | 0 | ||||||||||||||||||||||||||||
|
SERIESINDICATOR
Indicator in PTT Postal Data: Street, Houseboat or Trailer
|
SERIESINDICATOR |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
STRART
IS-M: CH/S: Street Type
|
J_1SSTRART |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||
|
PRAEPCODE
IS-M: CH/S: Preposition Code
|
J_1SPRPCOD |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||
|
SPRCODE
IS-M: CH: Language Code
|
J_1SSPRCOD |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
GRUNDPLZ
IS-M: CH: 4-Digit Basic Postal Code CH
|
J_1SGPLZ |
NUMC
|
4 | 0 | ||||||||||||||||||||||||||||
|
ERWPLZ
2-Digit Postal Code Extension CH
|
ERWPLZ |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||
|
STRSTAMM
IS-M: CH/S: Street Master
|
J_1SSTRSTA |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||
JSTSTRPRO foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| JSTSTRPRO | ADDRSECABBREV | * |
TJS43
IS-M: Abbreviations for Secondary Address Texts
|
LAND1 | |
| JSTSTRPRO | ADDRSECABBREV | JSTSTRPRO | ADDRSECABBREV |
TJS43
IS-M: Abbreviations for Secondary Address Texts
|
ADDRSECABBREV |
| JSTSTRPRO | ALORT | JSTSTRPRO | LAND1 |
JSTORTPRO
IS-M/SD: City File (Post)
|
LAND1 |
| JSTSTRPRO | ALORT | JSTSTRPRO | ALORT |
JSTORTPRO
IS-M/SD: City File (Post)
|
ALORT |
| JSTSTRPRO | COUNTYNO | JSTSTRPRO | COUNTYNO |
T005E
County
|
COUNC |
| JSTSTRPRO | COUNTYNO | * |
T005E
County
|
MANDT | |
| JSTSTRPRO | COUNTYNO | * |
T005E
County
|
LAND1 | |
| JSTSTRPRO | COUNTYNO | JSTSTRPRO | STATEABBREV |
T005E
County
|
REGIO |
| JSTSTRPRO | KREISG_SCH | JSTSTRPRO | LAND1 |
JSTKGSPRO
IS-M/SD: District Municipality File
|
LAND1 |
| JSTSTRPRO | KREISG_SCH | JSTSTRPRO | KREISG_SCH |
JSTKGSPRO
IS-M/SD: District Municipality File
|
KREISG_SCH |
| JSTSTRPRO | KREISG_SCH | JYTKGSGEM | KG_SATZART |
JSTKGSPRO
IS-M/SD: District Municipality File
|
KG_SATZART |
| JSTSTRPRO | LAND1 | SY | MANDT |
T005
Countries
|
MANDT |
| JSTSTRPRO | LAND1 | JSTSTRPRO | LAND1 |
T005
Countries
|
LAND1 |
| JSTSTRPRO | OTL_KEY | JSTSTRPRO | ALORT |
JSTOTLPRO
IS-M: City District File
|
ALORT |
| JSTSTRPRO | OTL_KEY | JSTSTRPRO | OTL_KEY |
JSTOTLPRO
IS-M: City District File
|
OTL_KEY |
| JSTSTRPRO | OTL_KEY | JSTSTRPRO | LAND1 |
JSTOTLPRO
IS-M: City District File
|
LAND1 |
| JSTSTRPRO | PLZ_ZSTR | JSTSTRPRO | LAND1 |
JSTPLZPRO
IS-M: Postal Codes
|
LAND1 |
| JSTSTRPRO | PLZ_ZSTR | JSTSTRPRO | PLZ_ZSTR |
JSTPLZPRO
IS-M: Postal Codes
|
PLZNEU |
| JSTSTRPRO | PLZ_ZSTR | * |
JSTPLZPRO
IS-M: Postal Codes
|
PLZLFDNR | |
| JSTSTRPRO | POSTDIRECTIONAL | JSTSTRPRO | LAND1 |
TJS41
IS-M: Direction Data for Street Names
|
LAND1 |
| JSTSTRPRO | POSTDIRECTIONAL | JSTSTRPRO | POSTDIRECTIONAL |
TJS41
IS-M: Direction Data for Street Names
|
DIRECTIONAL |
| JSTSTRPRO | PREDIRECTIONAL | JSTSTRPRO | LAND1 |
TJS41
IS-M: Direction Data for Street Names
|
LAND1 |
| JSTSTRPRO | PREDIRECTIONAL | JSTSTRPRO | PREDIRECTIONAL |
TJS41
IS-M: Direction Data for Street Names
|
DIRECTIONAL |
| JSTSTRPRO | STATEABBREV | * |
T005S
Taxes: Region (Province) Key
|
MANDT | |
| JSTSTRPRO | STATEABBREV | * |
T005S
Taxes: Region (Province) Key
|
LAND1 | |
| JSTSTRPRO | STATEABBREV | JSTSTRPRO | STATEABBREV |
T005S
Taxes: Region (Province) Key
|
BLAND |