SAP JST_STR_CONS IS-M: Table for Street Consolidation Table data and field list

JST_STR_CONS is a standard SAP Table which is used to store IS-M: Table for Street Consolidation data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The JST_STR_CONS table consists of various fields, each holding specific information or linking keys about IS-M: Table for Street Consolidation 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. .

JST_STR_CONS table Technical Details:

Delivery Class: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)

SAP JST_STR_CONS table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the JST_STR_CONS table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
REC_ID	Record ID			0
LAND1_ALT	Country Key	LAND1	CHAR	3	Assigned to domain		LAND1	LND
ALORT_ALT	IS-M: City Number (Unique)	JALORT	CHAR	8	Assigned to domain	ALPHA	ALORT	JSO
STRNR_ALT	IS-M: Street Number	STRASSENNR	CHAR	10	Assigned to domain	ALPHA	STRASSENNR	JSS
LAND1	Country Key	LAND1	CHAR	3	Assigned to domain		LAND1	LND
ALORT	IS-M: City Number (Unique)	JALORT	CHAR	8	Assigned to domain	ALPHA	ALORT	JSO
STRASSENNR	IS-M: Street Number	STRASSENNR	CHAR	10	JSTSTRPRO	ALPHA	STRASSENNR	JSS
VERSION	Version			0
STR_STATUS	Status			0
SUCHFELDS	Search field for accessing postal structures w/o matchcode	SUCHFELD	CHAR	40			CHAR40
STR_NAME_K	IS-M: Street Name (Short)	STR_NAME_K	CHAR	25			TEXT25
STR_NAME_L	IS-M: Street Name (long)	STR_NAME_L	CHAR	50			TEXT50	JSN
STR_NAME_G	IS-M: Street name - upper case for matchcode	STR_NAME_G	CHAR	50		JYTNF	JCHAR50_G	JSN
STR_NAME_S	IS-M: Street Name (Long Without Special Characters)	STR_NAME_S	CHAR	50			CHAR50
OTL_KEY	IS-M: City District Number	OTL_KEY	CHAR	3	JSTOTLPRO	ALPHA	OTL_KEY
KREISG_SCH	IS-M: District Municipality Key	KREISG_SCH	CHAR	15	JSTKGSPRO	ALPHA	KREISG_SCH
HNRKENN	IS-M: Identifier for House Number Range	HNRKENN	CHAR	1			HAUSNRKENN
HNR1VON	IS-M: House Number From (Numerical)	HNR1VON	CHAR	10			HAUSNUMMER
HNR2VON	IS-M/SD: Affix to First House Number (Alphanumeric)	HNR2VON	CHAR	8			HNRZUSATZ
HNR1BIS	IS-M: House Numbers To (Numerical)	HNR1BIS	CHAR	10			HAUSNUMMER
HNR2BIS	IS-M/SD: Affix for Last House Number (Alphanumeric)	HNR2BIS	CHAR	8			HNRZUSATZ
PLZ_ZSTR	IS-M: Postal Code of Street Section for Home Delivery	PLZ_ZSTR	CHAR	10	JSTPLZPRO		NPSTLZ
STR_NRPOST	IS-M: Street number from German postal service	STR_NRPOST	CHAR	15		ALPHA	STR_NRPOST
STRHNR1000	IS-M: 1000 column in house number interval	STRHNR1000	CHAR	1			STRHNR1000
STR_CODE	IS-M: Street code for coding street sections	STR_CODE	CHAR	3		ALPHA	STR_CODE
X_FEHLER	IS-M: Incorrect data record	X_FEHLER	CHAR	1			ANKREUZ
ERFUSER	Created By	ERFUSER	CHAR	12			USNAM
ERFDATE	Created On	ERFDATE	DATS	8			DATUM
ERFTIME	Time Created	ERFTIME	TIMS	6			UZEIT
AENUSER	Last Changed By	AENUSER	CHAR	12			USNAM
AENDATE	Date of Last Change	AENDATE	DATS	8			DATUM
AENTIME	Time of Last Change	AENTIME	TIMS	6			UZEIT
VERSION_J	IS-M: Version year	VERSION_J	NUMC	4			JAHR
VERSION_M	IS-M: Version month	VERSION_M	NUMC	2			AM_MONAT
VERSION_T	IS-M: Version day	VERSION_T	NUMC	2			AM_TAG
VERSION_NR	IS-M: Version number	VERSION_NR	CHAR	5	Assigned to domain	ALPHA	VERSION_NR
GUELTIGAB	Valid-From Date	GUELTIGVON	DATS	8			DATUM	JSA
GUELTIGBIS	Valid-To Date	GUELTIGBIS	DATS	8			DATUM	JSB
LOESCH_VM	Deletion Flag for Master Data in Media Sales & Distribution	LOEVM_ISP	CHAR	1			XFELD
PREDIRECTIONAL	Predirectional	PREDIRECTIONAL	CHAR	10	TJS41		DIRECTIONAL
SUFFIXABBREV	Suffix to Street Name According to USPS	SUFFIXABBREV	CHAR	4			CHAR04
POSTDIRECTIONAL	Postdirectional	POSTDIRECTIONAL	CHAR	10	TJS41		DIRECTIONAL
RECORDTYPECODE	Record Type in ZIP+4 File	RECORDTYPECODE	CHAR	1			RECORDTYPECODE
CARRIERROUTEID	Indicates Whether Truck Routes are for Drop-Off or Delivery	CARRIERROUTEID	CHAR	4			CHAR04
BUILDINGFIRMNAME	Building or Company Name	BUILDINGFIRMNAME	CHAR	40			TEXT40
ADDRSECABBREV	IS-M: Secondary Address Text	ADDRSECABBREV	CHAR	4	TJS43		ADDRSECABBREV
ADDRSECNUMLOW	IS-M: Secondary Address Number (Lower Limit)	ADDRSECNUMLOW	CHAR	8		ALPHA	ADDRSECNUMBER
ADDRSECNUMHIGH	IS-M: Secondary Address Number	ADDRSECNUMHIGH	CHAR	8		ALPHA	ADDRSECNUMBER
ADDRSECODDEVEN	IS-M: Odd/Even Indicator for Secondary Address Number	ADDRSECODDEVEN	CHAR	1			ODDEVENCODE
ZIPADDONLOW	IS-M: Extension of 5-digit ZIP code (lower limit)	JZIPADDONLOW	CHAR	4			CHAR4
ZIPADDONHIGH	IS-M: Extension of 5-digit ZIP code (upper limit)	JZIPADDONHIGH	CHAR	4			CHAR4
LACSSTATUSIND	Locatable Address Conversion Service (LACS) indicator	LACSSTATUSIND	CHAR	1			CHAR01
GOVTBLDGIND	Building Type	GOVTBLDGIND	CHAR	1			GOVTBLDGINDICATOR
FINANCENO	Finance Number; Required by USPS	FINANCENO	CHAR	6			CHAR06
STATEABBREV	STATE (State, Province, County)	REGIO	CHAR	3	T005S		REGIO
COUNTYNO	County Code	COUNC	CHAR	3	T005E		COUNC
CONGRDISTRICTNO	Code for District in a Geographical Area	CONGRDISTRICTNO	CHAR	2			CHAR02
PREFCITYSTATEKEY	City Number from City State Product File	CITYSTATEKEY	CHAR	6			CHAR06
.INCLU--AP				0
STREETNAME_NEN	Street Name (NEN Standard)	STREETNAME_NEN	CHAR	24			TEXT24
STREETNAME_PTT	Street Name (PTT Standard)	STREETNAME_PTT	CHAR	17			CHAR17
SERIESINDICATOR	Indicator in PTT Postal Data: Street, Houseboat or Trailer	SERIESINDICATOR	CHAR	1			SERIESINDICATOR
ST_NAMEALT	IS-M: Street Name (long)	STR_NAME_L	CHAR	50			TEXT50	JSN
STR_NRPALT	IS-M: Street number from German postal service	STR_NRPOST	CHAR	15		ALPHA	STR_NRPOST
HNRKENNALT	IS-M: Identifier for House Number Range	HNRKENN	CHAR	1			HAUSNRKENN
HNR1000ALT	IS-M: 1000 column in house number interval	STRHNR1000	CHAR	1			STRHNR1000
HNR1VONALT	IS-M: House Number From (Numerical)	HNR1VON	CHAR	10			HAUSNUMMER
HNR2VONALT	IS-M/SD: Affix to First House Number (Alphanumeric)	HNR2VON	CHAR	8			HNRZUSATZ
HNR1BISALT	IS-M: House Numbers To (Numerical)	HNR1BIS	CHAR	10			HAUSNUMMER
HNR2BISALT	IS-M/SD: Affix for Last House Number (Alphanumeric)	HNR2BIS	CHAR	8			HNRZUSATZ
STRNRPTT	IS-M: PTT street number (CH)	J_1SSTRPTT	NUMC	6			NUM06
STRART	IS-M: CH/S: Street Type	J_1SSTRART	CHAR	2	Assigned to domain		J_1SSTRART
PRAEPCODE	IS-M: CH/S: Preposition Code	J_1SPRPCOD	CHAR	2	Assigned to domain		J_1SPRPCOD
SPRCODE	IS-M: CH: Language Code	J_1SSPRCOD	CHAR	1			J_1SC1
GRUNDPLZ	IS-M: CH: 4-Digit Basic Postal Code CH	J_1SGPLZ	NUMC	4	Assigned to domain		J_1SGPLZ
ERWPLZ	2-Digit Postal Code Extension CH	ERWPLZ	CHAR	2			ERW_PLZ
STRSTAMM	IS-M: CH/S: Street Master	J_1SSTRSTA	CHAR	10			J_1SC10

Key field

Non-key field

< JST_POF_STATE - Status of PO Box Checks JST_STR_RAW - PDU Raw Data for Streets >

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

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

SELECT SINGLE *
FROM JST_STR_CONS
INTO CORRESPONDING FIELDS OF WA_JST_STR_CONS
WHERE...

How to access SAP table JST_STR_CONS

Within an ECC or HANA version of SAP you can also view further information about JST_STR_CONS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).