JST_ORT_CONS SAP (IS-M: Table for City Consolidation) Table details

Dictionary Type: Table
Description: IS-M: Table for City Consolidation




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




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

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

The JST_ORT_CONS table consists of various fields, each holding specific information or linking keys about IS-M: Table for City Consolidation data available in SAP. These include LAND1_ALT (Country Key), ALORT_ALT (IS-M: City Number (Unique)), LAND1 (Country Key), ALORT (IS-M: City Number (Unique)).. 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: 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_ORT_CONS 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
REC_ID Record ID0
LAND1_ALTCountry Key LAND1CHAR3Assigned to domainLAND1LND
ALORT_ALTIS-M: City Number (Unique) JALORTCHAR8Assigned to domainALPHAALORTJSO
LAND1Country Key LAND1CHAR3Assigned to domainLAND1LND
ALORTIS-M: City Number (Unique) JALORTCHAR8Assigned to domainALPHAALORTJSO
VERSION Version0
ORT_STATUS Record Status0
SUCHFELDOSearch field for accessing postal structures w/o matchcode SUCHFELDCHAR40CHAR40
ORT_NAME_KIS-M: City Name (Short Text) ORT_NAME_KCHAR25TEXT25
ORT_NAME_LIS-M: City name (long text) ORT_NAME_LCHAR50TEXT50
ORT_NAME_GIS-M: City name in block capitals ORT_NAME_GCHAR50JYTNFJCHAR50_GJSM
ORT_NAME_SIS-M: City Name (Long Text, No Special Characters) ORT_NAME_SCHAR50CHAR50
ORTZUSAIS-M: Affix for City Name ORTZUSACHAR30TEXT30
KREISG_SCHIS-M: District Municipality Key KREISG_SCHCHAR15Assigned to domainALPHAKREISG_SCH
HERKKZORTIS-M: Origin Indicator for City HERKZORTCHAR1TJS31HERKUNFTKZ
HERKKZSTRIS-M: Origin Indicator for Street File HERKZSTRCHAR1TJS31HERKUNFTKZ
XSTRMANUELIS-M: Additional Streets were Entered Manually XSTRMANUELCHAR1XFELD
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_NRCHAR5TJS00ALPHAVERSION_NR
GUELTIGABValid-From Date GUELTIGVONDATS8DATUMJSA
GUELTIGBISValid-To Date GUELTIGBISDATS8DATUMJSB
LOESCH_VMDeletion Flag for Master Data in Media Sales & Distribution LOEVM_ISPCHAR1XFELD
CITYSTATEFACCODEType of Location Defined by the City Name CITYSTATEFACCODECHAR1CITYSTATEFACCODE
PREFCITYSTATEKEYPreferred city number from city state product file PREFCITYSTATEKEYCHAR6CHAR06
PREFCITYSTNAMEPreferred city name PREFCITYSTNAMECHAR28TEXT28
CITYDELINDIndicates Whether Carrier Routes Defined CITYDELINDCHAR1CHAR01
CARRRTESORTINDIndicates Whether Price Reduction Possible for Letter Post CARRRTESORTINDCHAR1CHAR01
UNIQUEZIPINDIndicates Whether or not ZIP Code is Unique UNIQUEZIPINDCHAR1CHAR01
FINANCENOFinance Number; Required by USPS FINANCENOCHAR6CHAR06
STATEABBREVSTATE (State, Province, County) REGIOCHAR3T005SREGIO
COUNTYNOCounty Code COUNCCHAR3T005ECOUNC
ORT_NAME_ALIS-M: Alternative City Name ORT_NAME_ALCHAR50TEXT50
.INCLU--AP 0
CEBUCOCODECebuco Code CEBUCOCODECHAR3Assigned to domainCEBUCOCODE
CITYNAME_NENCity Name (NEN Standard) CITYNAME_NENCHAR24CHAR24
ORTNAMEALTIS-M: City name (long text) ORT_NAME_LCHAR50TEXT50

Key field Non-key field



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

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

SELECT SINGLE *
FROM JST_ORT_CONS
INTO CORRESPONDING FIELDS OF WA_JST_ORT_CONS
WHERE...

How to access SAP table JST_ORT_CONS

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


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!