SAP TABLES | SAP Media | Master Data(IS-M-MD) SAP IS

JST_ORT_CONS SAP IS-M: Table for City Consolidation Table and data







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.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP JST_ORT_CONS Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: L - Table for storing temporary data, delivered empty

Display/Maintenance via SM30: Allowed

Enhancement category i: Can be enhanced (character-type)
See here for more information about this and other SAP enhancement categories


SAP JST_ORT_CONS Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
REC_IDNUMC10 Record ID
LAND1_ALTLAND1CHAR3
*
Country Key
ALORT_ALTJALORTCHAR8
*
IS-M: City Number (Unique)ALPHA
LAND1LAND1CHAR3
*
Country Key
ALORTJALORTCHAR8
*
IS-M: City Number (Unique)ALPHA
VERSIONCHAR7 Version
ORT_STATUSCHAR1 Record Status
.INCLUDEJYTORTINCL IS-PSD: Include with Attributes of Table JSTORTPRO
SUCHFELDOSUCHFELDCHAR40 Search field for accessing postal structures w/o matchcode
ORT_NAME_KORT_NAME_KCHAR25 IS-M: City Name (Short Text)
ORT_NAME_LORT_NAME_LCHAR50 IS-M: City name (long text)
ORT_NAME_GORT_NAME_GCHAR50 IS-M: City name in block capitalsJYTNF
ORT_NAME_SORT_NAME_SCHAR50 IS-M: City Name (Long Text, No Special Characters)
ORTZUSAORTZUSACHAR30 IS-M: Affix for City Name
KREISG_SCHKREISG_SCHCHAR15
*
IS-M: District Municipality KeyALPHA
HERKKZORTHERKZORTCHAR1 TJS31IS-M: Origin Indicator for City
HERKKZSTRHERKZSTRCHAR1 TJS31IS-M: Origin Indicator for Street File
XSTRMANUELXSTRMANUELCHAR1 IS-M: Additional Streets were Entered Manually
X_FEHLERX_FEHLERCHAR1 IS-M: Incorrect data record
.INCLUDEJYTUSER Created-By Data (Medium Scope)
ERFUSERERFUSERCHAR12 Created By
ERFDATEERFDATEDATS8 Created On
ERFTIMEERFTIMETIMS6 Time Created
AENUSERAENUSERCHAR12 Last Changed By
AENDATEAENDATEDATS8 Date of Last Change
AENTIMEAENTIMETIMS6 Time of Last Change
.INCLUDEJYTVERSION Version (for upgrade procedures for postal data)
VERSION_JVERSION_JNUMC4 IS-M: Version year
VERSION_MVERSION_MNUMC2 IS-M: Version month
VERSION_TVERSION_TNUMC2 IS-M: Version day
VERSION_NRVERSION_NRCHAR5 TJS00IS-M: Version numberALPHA
GUELTIGABGUELTIGVONDATS8 Valid-From Date
GUELTIGBISGUELTIGBISDATS8 Valid-To Date
LOESCH_VMLOEVM_ISPCHAR1 Deletion Flag for Master Data in Media Sales & Distribution
.INCLUDEJYTORTFIELDS_USA IS-M: Additional Fields in JSTORTPRO for US Country Version
CITYSTATEFACCODECITYSTATEFACCODECHAR1 Type of Location Defined by the City Name
PREFCITYSTATEKEYPREFCITYSTATEKEYCHAR6 Preferred city number from city state product file
PREFCITYSTNAMEPREFCITYSTNAMECHAR28 Preferred city name
CITYDELINDCITYDELINDCHAR1 Indicates Whether Carrier Routes Defined


CARRRTESORTINDCARRRTESORTINDCHAR1 Indicates Whether Price Reduction Possible for Letter Post
UNIQUEZIPINDUNIQUEZIPINDCHAR1 Indicates Whether or not ZIP Code is Unique
FINANCENOFINANCENOCHAR6 Finance Number; Required by USPS
COUNTYNOCOUNCCHAR3 T005ECounty Code
ORT_NAME_ALORT_NAME_ALCHAR50 IS-M: Alternative City Name
.APPENDPTT_NL_ORT Structure for Additional City Fields (NL)
CEBUCOCODECEBUCOCODECHAR3
*
Cebuco Code
CITYNAME_NENCITYNAME_NENCHAR24 City Name (NEN Standard)
ORTNAMEALTORT_NAME_LCHAR50 IS-M: City name (long text)



Key field
Non-key field