SAP Table JSTOTLPRO
IS-M: City District File
JSTOTLPRO (IS-M: City District File) 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 JSTOTLPRO to other SAP tables.
JSTOTLPRO table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LAND1 | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||||||||||||||||||||||||||
| ALORT | IS-M: City Number (Unique) | JALORT | CHAR | 8 | 0 | |||||||||||||||||||||||||||
| OTL_KEY | IS-M: City District Number | OTL_KEY | CHAR | 3 | 0 | |||||||||||||||||||||||||||
| KREISG_SCH | IS-M: District Municipality Key | KREISG_SCH | JSTKGSPRO | CHAR | 15 | 0 | ||||||||||||||||||||||||||
| OTL_NAME | IS-M: Name of City District | OTL_NAME | CHAR | 40 | 0 | |||||||||||||||||||||||||||
| OTL_NAME_G | IS-M: City district in block capitals | OTL_NAME_G | CHAR | 40 | 0 | |||||||||||||||||||||||||||
| SUCHFELDOT | Search field for accessing postal structures w/o matchcode | SUCHFELD | CHAR | 40 | 0 | |||||||||||||||||||||||||||
| X_FEHLER | IS-M: Incorrect data record | X_FEHLER | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| 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 |
Possible values
|
||||||||||||||||||||||||||
| 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 |
Possible values
|
||||||||||||||||||||||||||
JSTOTLPRO foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| JSTOTLPRO | KREISG_SCH | JSTOTLPRO | LAND1 | JSTKGSPRO | IS-M/SD: District Municipality File | LAND1 |
| JSTOTLPRO | KREISG_SCH | JSTOTLPRO | KREISG_SCH | JSTKGSPRO | IS-M/SD: District Municipality File | KREISG_SCH |
| JSTOTLPRO | KREISG_SCH | JYTKGSGEM | KG_SATZART | JSTKGSPRO | IS-M/SD: District Municipality File | KG_SATZART |
| JSTOTLPRO | LAND1 | JSTOTLPRO | LAND1 | T005 | Countries | LAND1 |
| JSTOTLPRO | LAND1 | SYST | MANDT | T005 | Countries | MANDT |
