SAP ABAP View JSVSTR_TREX (IS-M: View for TREX Search Help for Streets)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷
IS-M (Application Component) SAP Media
⤷
JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System
IS-M (Software Component) SAP MEDIA⤷
IS-M (Application Component) SAP Media⤷
JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System
Basic Data
| View Type | D | Database View |
| Database View | JSVSTR_TREX | |
| Short Description | IS-M: View for TREX Search Help for Streets | |
| Root table | JSTSTRPRO | IS-M/SD: Street File (Post) |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | JSTSTRPRO |
JSTSTRPRO | ||
| 2 | JSTORTPRO |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | JSTORTPRO |
LAND1 | JL | EQ | 0 | 0 | ||||
| 2 | JSTSTRPRO |
LAND1 | JR | EQ | AND | 0 | 0 | |||
| 3 | JSTORTPRO |
ALORT | JL | EQ | 0 | 0 | ||||
| 4 | JSTSTRPRO |
ALORT | JR | EQ | 0 | 0 | ||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  LAND1 |
JSTSTRPRO |
LAND1 | LAND1 | Country Key | |||
| 2 | ALORT |
JSTSTRPRO |
ALORT | JALORT | IS-M: City Number (Unique) | |||
| 3 | STRASSENNR |
JSTSTRPRO |
STRASSENNR | STRASSENNR | IS-M: Street Number | |||
| 4 | STR_NAME_K |
JSTSTRPRO |
STR_NAME_K | STR_NAME_K | IS-M: Street Name (Short) | |||
| 5 | STR_NAME_L |
JSTSTRPRO |
STR_NAME_L | STR_NAME_L | IS-M: Street Name (long) | |||
| 6 | KREISG_SCH |
JSTSTRPRO |
KREISG_SCH | KREISG_SCH | IS-M: District Municipality Key | |||
| 7 | HNRKENN |
JSTSTRPRO |
HNRKENN | HNRKENN | IS-M: Identifier for House Number Range | |||
| 8 | HNR1VON |
JSTSTRPRO |
HNR1VON | HNR1VON | IS-M: House Number From (Numerical) | |||
| 9 | HNR2VON |
JSTSTRPRO |
HNR2VON | HNR2VON | IS-M/SD: Affix to First House Number (Alphanumeric) | |||
| 10 | HNR1BIS |
JSTSTRPRO |
HNR1BIS | HNR1BIS | IS-M: House Numbers To (Numerical) | |||
| 11 | HNR2BIS |
JSTSTRPRO |
HNR2BIS | HNR2BIS | IS-M/SD: Affix for Last House Number (Alphanumeric) | |||
| 12 | STRHNR1000 |
JSTSTRPRO |
STRHNR1000 | STRHNR1000 | IS-M: 1000 column in house number interval | |||
| 13 | GUELTIGAB |
JSTSTRPRO |
GUELTIGAB | GUELTIGVON | Valid-From Date | |||
| 14 | GUELTIGBIS |
JSTSTRPRO |
GUELTIGBIS | GUELTIGBIS | Valid-To Date | |||
| 15 | LOESCH_VM |
JSTSTRPRO |
LOESCH_VM | LOEVM_ISP | Deletion Flag for Master Data in Media Sales & Distribution | |||
| 16 | ORT_NAME_K |
JSTORTPRO |
ORT_NAME_K | ORT_NAME_K | IS-M: City Name (Short Text) | |||
| 17 | ORT_NAME_L |
JSTORTPRO |
ORT_NAME_L | ORT_NAME_L | IS-M: City name (long text) | |||
| 18 | ORTZUSA |
JSTORTPRO |
ORTZUSA | ORTZUSA | IS-M: Affix for City Name | |||
Maintenance Status
| read only |
| read and change |
| Time-dependent views: like U, validity data like ' ' |
| read, change, delete and insert |
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in | 600 |
