SAP Table JSTORTPRO
IS-M/SD: City File (Post)
JSTORTPRO (IS-M/SD: City 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 JSTORTPRO to other SAP tables.
JSTORTPRO table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
LAND1
Country Key
|
LAND1 | T005 |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||||
|
ALORT
IS-M: City Number (Unique)
|
JALORT |
CHAR
|
8 | 0 | ||||||||||||||||||||||||||||||
|
SUCHFELDO
Search field for accessing postal structures w/o matchcode
|
SUCHFELD |
CHAR
|
40 | 0 | ||||||||||||||||||||||||||||||
|
ORT_NAME_K
IS-M: City Name (Short Text)
|
ORT_NAME_K |
CHAR
|
25 | 0 | ||||||||||||||||||||||||||||||
|
ORT_NAME_L
IS-M: City name (long text)
|
ORT_NAME_L |
CHAR
|
50 | 0 | ||||||||||||||||||||||||||||||
|
ORT_NAME_G
IS-M: City name in block capitals
|
ORT_NAME_G |
CHAR
|
50 | 0 | ||||||||||||||||||||||||||||||
|
ORT_NAME_S
IS-M: City Name (Long Text, No Special Characters)
|
ORT_NAME_S |
CHAR
|
50 | 0 | ||||||||||||||||||||||||||||||
|
ORTZUSA
IS-M: Affix for City Name
|
ORTZUSA |
CHAR
|
30 | 0 | ||||||||||||||||||||||||||||||
|
KREISG_SCH
IS-M: District Municipality Key
|
KREISG_SCH | JSTKGSPRO |
CHAR
|
15 | 0 | |||||||||||||||||||||||||||||
|
HERKKZORT
IS-M: Origin Indicator for City
|
HERKZORT | TJS31 |
CHAR
|
1 | 0 | |||||||||||||||||||||||||||||
|
HERKKZSTR
IS-M: Origin Indicator for Street File
|
HERKZSTR | TJS31 |
CHAR
|
1 | 0 | |||||||||||||||||||||||||||||
|
XSTRMANUEL
IS-M: Additional Streets were Entered Manually
|
XSTRMANUEL |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||
|
X_FEHLER
IS-M: Incorrect data record
|
X_FEHLER |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||
|
CITYSTATEFACCODE
Type of Location Defined by the City Name
|
CITYSTATEFACCODE |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||
|
PREFCITYSTATEKEY
Preferred city number from city state product file
|
PREFCITYSTATEKEY |
CHAR
|
6 | 0 | ||||||||||||||||||||||||||||||
|
PREFCITYSTNAME
Preferred city name
|
PREFCITYSTNAME |
CHAR
|
28 | 0 | ||||||||||||||||||||||||||||||
|
CITYDELIND
Indicates Whether Carrier Routes Defined
|
CITYDELIND |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||
|
CARRRTESORTIND
Indicates Whether Price Reduction Possible for Letter Post
|
CARRRTESORTIND |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||
|
UNIQUEZIPIND
Indicates Whether or not ZIP Code is Unique
|
UNIQUEZIPIND |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||
|
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 | |||||||||||||||||||||||||||||
|
ORT_NAME_AL
IS-M: Alternative City Name
|
ORT_NAME_AL |
CHAR
|
50 | 0 | ||||||||||||||||||||||||||||||
|
CEBUCOCODE
Cebuco Code
|
CEBUCOCODE |
CHAR
|
3 | 0 | ||||||||||||||||||||||||||||||
|
CITYNAME_NEN
City Name (NEN Standard)
|
CITYNAME_NEN |
CHAR
|
24 | 0 | ||||||||||||||||||||||||||||||
JSTORTPRO foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| JSTORTPRO | COUNTYNO | * |
T005E
County
|
LAND1 | |
| JSTORTPRO | COUNTYNO | JSTORTPRO | STATEABBREV |
T005E
County
|
REGIO |
| JSTORTPRO | COUNTYNO | JSTORTPRO | COUNTYNO |
T005E
County
|
COUNC |
| JSTORTPRO | COUNTYNO | * |
T005E
County
|
MANDT | |
| JSTORTPRO | HERKKZORT | SYST | MANDT |
TJS31
IS-M/SD: Origin Indicator for Postal Units
|
MANDT |
| JSTORTPRO | HERKKZORT | JSTORTPRO | HERKKZORT |
TJS31
IS-M/SD: Origin Indicator for Postal Units
|
HERKUNFTKZ |
| JSTORTPRO | HERKKZSTR | SYST | MANDT |
TJS31
IS-M/SD: Origin Indicator for Postal Units
|
MANDT |
| JSTORTPRO | HERKKZSTR | JSTORTPRO | HERKKZSTR |
TJS31
IS-M/SD: Origin Indicator for Postal Units
|
HERKUNFTKZ |
| JSTORTPRO | KREISG_SCH | JSTORTPRO | LAND1 |
JSTKGSPRO
IS-M/SD: District Municipality File
|
LAND1 |
| JSTORTPRO | KREISG_SCH | JSTORTPRO | KREISG_SCH |
JSTKGSPRO
IS-M/SD: District Municipality File
|
KREISG_SCH |
| JSTORTPRO | KREISG_SCH | JYTKGSGEM | KG_SATZART |
JSTKGSPRO
IS-M/SD: District Municipality File
|
KG_SATZART |
| JSTORTPRO | LAND1 | SYST | MANDANT |
T005
Countries
|
MANDT |
| JSTORTPRO | LAND1 | JSTORTPRO | LAND1 |
T005
Countries
|
LAND1 |
| JSTORTPRO | STATEABBREV | JSTORTPRO | STATEABBREV |
T005S
Taxes: Region (Province) Key
|
BLAND |
| JSTORTPRO | STATEABBREV | * |
T005S
Taxes: Region (Province) Key
|
MANDT | |
| JSTORTPRO | STATEABBREV | JSTORTPRO | LAND1 |
T005S
Taxes: Region (Province) Key
|
LAND1 |