SAP ABAP Table JST_OTL_CONS (IS-M: Table for City District Consolidation)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷ IS-M-MD (Application Component) Master Data
⤷ JMDGEN (Package) Generic Master Data Media
⤷ IS-M-MD (Application Component) Master Data
⤷ JMDGEN (Package) Generic Master Data Media
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | JST_OTL_CONS | Table Relationship Diagram |
Short Description | IS-M: Table for City District Consolidation |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | LAND1_ALT | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
3 | ALORT_ALT | JALORT | ALORT | CHAR | 8 | 0 | IS-M: City Number (Unique) | * | |
4 | OTL_KEYALT | OTL_KEY | OTL_KEY | CHAR | 3 | 0 | IS-M: City District Number | * | |
5 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
6 | ALORT | JALORT | ALORT | CHAR | 8 | 0 | IS-M: City Number (Unique) | * | |
7 | OTL_KEY | OTL_KEY | OTL_KEY | CHAR | 3 | 0 | IS-M: City District Number | * | |
8 | VERSION | CHAR | 7 | 0 | |||||
9 | OTL_STATUS | CHAR | 1 | 0 | |||||
10 | .INCLUDE | 0 | 0 | IS-M: INCLUDE with Attributes of Table JSTOTLPRO | |||||
11 | KREISG_SCH | KREISG_SCH | KREISG_SCH | CHAR | 15 | 0 | IS-M: District Municipality Key | JSTKGSPRO | |
12 | OTL_NAME | OTL_NAME | TEXT40 | CHAR | 40 | 0 | IS-M: Name of City District | ||
13 | OTL_NAME_G | OTL_NAME_G | JCHAR40_G | CHAR | 40 | 0 | IS-M: City district in block capitals | ||
14 | SUCHFELDOT | SUCHFELD | CHAR40 | CHAR | 40 | 0 | Search field for accessing postal structures w/o matchcode | ||
15 | X_FEHLER | X_FEHLER | ANKREUZ | CHAR | 1 | 0 | IS-M: Incorrect data record | ||
16 | .INCLUDE | 0 | 0 | Created-By Data (Medium Scope) | |||||
17 | ERFUSER | ERFUSER | USNAM | CHAR | 12 | 0 | Created By | ||
18 | ERFDATE | ERFDATE | DATUM | DATS | 8 | 0 | Created On | ||
19 | ERFTIME | ERFTIME | UZEIT | TIMS | 6 | 0 | Time Created | ||
20 | AENUSER | AENUSER | USNAM | CHAR | 12 | 0 | Last Changed By | ||
21 | AENDATE | AENDATE | DATUM | DATS | 8 | 0 | Date of Last Change | ||
22 | AENTIME | AENTIME | UZEIT | TIMS | 6 | 0 | Time of Last Change | ||
23 | .INCLUDE | 0 | 0 | Version (for upgrade procedures for postal data) | |||||
24 | VERSION_J | VERSION_J | JAHR | NUMC | 4 | 0 | IS-M: Version year | ||
25 | VERSION_M | VERSION_M | AM_MONAT | NUMC | 2 | 0 | IS-M: Version month | ||
26 | VERSION_T | VERSION_T | AM_TAG | NUMC | 2 | 0 | IS-M: Version day | ||
27 | VERSION_NR | VERSION_NR | VERSION_NR | CHAR | 5 | 0 | IS-M: Version number | * | |
28 | GUELTIGAB | GUELTIGVON | DATUM | DATS | 8 | 0 | Valid-From Date | ||
29 | GUELTIGBIS | GUELTIGBIS | DATUM | DATS | 8 | 0 | Valid-To Date | ||
30 | LOESCH_VM | LOEVM_ISP | XFELD | CHAR | 1 | 0 | Deletion Flag for Master Data in Media Sales & Distribution | ||
31 | OTLNAMEALT | OTL_NAME | TEXT40 | CHAR | 40 | 0 | IS-M: Name of City District |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | JST_OTL_CONS | KREISG_SCH | JSTKGSPRO | KREISG_SCH | KEY | 1 | CN |
2 | JST_OTL_CONS | LAND1 | T005 | LAND1 | KEY | 1 | CN |
3 | JST_OTL_CONS | LAND1_ALT | T005 | LAND1 | KEY | 1 | CN |
4 | JST_OTL_CONS | MANDT | T000 | MANDT | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 473 |