1. Home
  2. Resources
  3. SAP Tables
  4. JSTSTRPRO - IS-M/SD: Street File (Post)

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
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
0 All
1 Odd
2 Even
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
0 Interval from 1 to 999
1 Interval from 1000 to 1999
2 Interval from 2000 to 2999
3 Interval from 3000 to 3999
4 Interval from 4000 to 4999
5 Interval from 5000 to 5999
6 Interval from 6000 to 6999
7 Interval from 7000 to 7999
8 Interval from 8000 to 8999
9 Interval from 9000 to 9999
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
X Yes
. No
NULL No
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
01 January
02 February
03 March
04 April
05 May
06 June
07 July
08 August
09 September
10 October
11 November
12 December
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
X Yes
NULL No
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
F Company
G General delivery
H High-rise
P P.O.box (do not use)
R Rural truck route (do not use)
S Street
M Multi-carrier (do not use)
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
0 All
1 Odd
2 Even
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
A City administrative offices
B Federal government offices
C State government offices
D Company offices
E City government and company offices
F Federal government and company offices
G State government and company offices
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
0 Street (even or odd house number range)
2 Houseboat
3 Trailer
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 * T005E County LAND1
JSTSTRPRO COUNTYNO JSTSTRPRO STATEABBREV T005E County REGIO
JSTSTRPRO COUNTYNO JSTSTRPRO COUNTYNO T005E County COUNC
JSTSTRPRO COUNTYNO * T005E County MANDT
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 LAND1 JSTOTLPRO IS-M: City District File 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 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 JSTSTRPRO STATEABBREV T005S Taxes: Region (Province) Key BLAND
JSTSTRPRO STATEABBREV * T005S Taxes: Region (Province) Key MANDT
JSTSTRPRO STATEABBREV * T005S Taxes: Region (Province) Key LAND1