SAP ABAP Table M_MJSN (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | M_MJSN |
|
| Short Description | Generated Table for View |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
| 2 | |
OTL_KEY | OTL_KEY | CHAR | 3 | 0 | IS-M: City District Number | ||
| 3 | |
KREISG_SCH | KREISG_SCH | CHAR | 15 | 0 | IS-M: District Municipality Key | JSTKGSPRO | |
| 4 | |
HNRKENN | HAUSNRKENN | CHAR | 1 | 0 | IS-M: Identifier for House Number Range | ||
| 5 | |
HNR1VON | HAUSNUMMER | CHAR | 10 | 0 | IS-M: House Number From (Numerical) | ||
| 6 | |
HNR2VON | HNRZUSATZ | CHAR | 8 | 0 | IS-M/SD: Affix to First House Number (Alphanumeric) | ||
| 7 | |
HNR1BIS | HAUSNUMMER | CHAR | 10 | 0 | IS-M: House Numbers To (Numerical) | ||
| 8 | |
HNR2BIS | HNRZUSATZ | CHAR | 8 | 0 | IS-M/SD: Affix for Last House Number (Alphanumeric) | ||
| 9 | |
PLZ_ZSTR | NPSTLZ | CHAR | 10 | 0 | IS-M: Postal Code of Street Section for Home Delivery | JSTPLZPRO | |
| 10 | |
STR_NRPOST | STR_NRPOST | CHAR | 15 | 0 | IS-M: Street number from German postal service | ||
| 11 | |
STRHNR1000 | STRHNR1000 | CHAR | 1 | 0 | IS-M: 1000 column in house number interval | ||
| 12 | |
STR_CODE | STR_CODE | CHAR | 3 | 0 | IS-M: Street code for coding street sections | ||
| 13 | |
VERSION_NR | VERSION_NR | CHAR | 5 | 0 | IS-M: Version number | ||
| 14 | |
GUELTIGVON | DATUM | DATS | 8 | 0 | Valid-From Date | ||
| 15 | |
GUELTIGBIS | DATUM | DATS | 8 | 0 | Valid-To Date | ||
| 16 | |
LOEVM_ISP | XFELD | CHAR | 1 | 0 | Deletion Flag for Master Data in Media Sales & Distribution | ||
| 17 | |
STR_NAME_G | JCHAR50_G | CHAR | 50 | 0 | IS-M: Street name - upper case for matchcode | ||
| 18 | |
ORT_NAME_G | JCHAR50_G | CHAR | 50 | 0 | IS-M: City name in block capitals |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | M_MJSN | KREISG_SCH | |
|
KEY | 1 | CN |
| 2 | M_MJSN | LAND1 | |
|
KEY | 1 | CN |
| 3 | M_MJSN | PLZ_ZSTR | |
|
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |