JSTORTPRO SAP (IS-M/SD: City File (Post)) Table details

Dictionary Type: Table
Description: IS-M/SD: City File (Post)




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




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

JSTORTPRO is a standard SAP Table which is used to store IS-M/SD: City File (Post) data and is available within R/3 SAP systems depending on the version and release level.

The JSTORTPRO table consists of various fields, each holding specific information or linking keys about IS-M/SD: City File (Post) data available in SAP. These include ALORT (IS-M: City Number (Unique)), SUCHFELDO (Search field for accessing postal structures w/o matchcode), ORT_NAME_K (IS-M: City Name (Short Text)), ORT_NAME_L (IS-M: City name (long text)).. 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: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP JSTORTPRO 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
LAND1Country Key LAND1CHAR3T005LAND1LND
ALORTIS-M: City Number (Unique) JALORTCHAR8ALPHAALORTJSO
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_SCHCHAR15JSTKGSPROALPHAKREISG_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_NRCHAR5Assigned to domainALPHAVERSION_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

Key field Non-key field



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

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

SELECT SINGLE *
FROM JSTORTPRO
INTO CORRESPONDING FIELDS OF WA_JSTORTPRO
WHERE...

How to access SAP table JSTORTPRO

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