SAP ABAP View JSVSTRUPDA (Maintain Temporary Database for Street File)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷
IS-M-MD (Application Component) Master Data
⤷
JMDGEN (Package) Generic Master Data Media
⤷
⤷
Basic Data
| View Type | C | Maintenance View |
| Maintenance View | JSVSTRUPDA | |
| Short Description | Maintain Temporary Database for Street File | |
| Root table | JSTSTRUPDA | IS-M/SD: Table for Upgrading Table JSTSTRPRO |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | JSTSTRUPDA |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 | MANDT | MANDT | Client | |||||
| 2 | LAND1_ALT | LAND1 | Country Key | |||||
| 3 | ALORT_ALT | JALORT | IS-M: City Number (Unique) | |||||
| 4 | STRNR_ALT | STRASSENNR | IS-M: Street Number | |||||
| 5 | LAND1 | LAND1 | Country Key | |||||
| 6 | ALORT | JALORT | IS-M: City Number (Unique) | |||||
| 7 | STRASSENNR | STRASSENNR | IS-M: Street Number | |||||
| 8 | STR_NAME_L | STR_NAME_L | IS-M: Street Name (long) | |||||
| 9 | OTL_KEY | OTL_KEY | IS-M: City District Number | |||||
| 10 | KREISG_SCH | KREISG_SCH | IS-M: District Municipality Key | |||||
| 11 | HNRKENN | HNRKENN | IS-M: Identifier for House Number Range | |||||
| 12 | HNR1VON | HNR1VON | IS-M: House Number From (Numerical) | |||||
| 13 | HNR2VON | HNR2VON | IS-M/SD: Affix to First House Number (Alphanumeric) | |||||
| 14 | HNR1BIS | HNR1BIS | IS-M: House Numbers To (Numerical) | |||||
| 15 | HNR2BIS | HNR2BIS | IS-M/SD: Affix for Last House Number (Alphanumeric) | |||||
| 16 | PLZ_ZSTR | PLZ_ZSTR | IS-M: Postal Code of Street Section for Home Delivery | |||||
| 17 | STR_NRPOST | STR_NRPOST | IS-M: Street number from German postal service | |||||
| 18 | DBCODE_ALT | DBCODE | DB Code for Structural Changes | |||||
| 19 | DBCODE_NEU | DBCODE | DB Code for Structural Changes | |||||
| 20 | SUCHFELDS | H | SUCHFELD | Search field for accessing postal structures w/o matchcode | ||||
| 21 | STR_NAME_K | H | STR_NAME_K | IS-M: Street Name (Short) | ||||
| 22 | STR_NAME_G | H | STR_NAME_G | IS-M: Street name - upper case for matchcode | ||||
| 23 | STR_NAME_S | H | STR_NAME_S | IS-M: Street Name (Long Without Special Characters) | ||||
| 24 | STRHNR1000 | H | STRHNR1000 | IS-M: 1000 column in house number interval | ||||
| 25 | STR_CODE | H | STR_CODE | IS-M: Street code for coding street sections | ||||
| 26 | X_FEHLER | H | X_FEHLER | IS-M: Incorrect data record | ||||
| 27 | ERFUSER | H | ERFUSER | Created By | ||||
| 28 | ERFDATE | H | ERFDATE | Created On | ||||
| 29 | ERFTIME | H | ERFTIME | Time Created | ||||
| 30 | AENUSER | H | AENUSER | Last Changed By | ||||
| 31 | AENDATE | H | AENDATE | Date of Last Change | ||||
| 32 | AENTIME | H | AENTIME | Time of Last Change | ||||
| 33 | VERSION_J | H | VERSION_J | IS-M: Version year | ||||
| 34 | VERSION_M | H | VERSION_M | IS-M: Version month | ||||
| 35 | VERSION_T | H | VERSION_T | IS-M: Version day | ||||
| 36 | VERSION_NR | S | VERSION_NR | IS-M: Version number | ||||
| 37 | LOESCH_VM | H | LOEVM_ISP | Deletion Flag for Master Data in Media Sales & Distribution | ||||
| 38 | ST_NAMEALT | H | STR_NAME_L | IS-M: Street Name (long) | ||||
| 39 | STR_NRPALT | H | STR_NRPOST | IS-M: Street number from German postal service | ||||
| 40 | HNRKENNALT | H | HNRKENN | IS-M: Identifier for House Number Range | ||||
| 41 | HNR1000ALT | H | STRHNR1000 | IS-M: 1000 column in house number interval | ||||
| 42 | HNR1VONALT | H | HNR1VON | IS-M: House Number From (Numerical) | ||||
| 43 | HNR2VONALT | H | HNR2VON | IS-M/SD: Affix to First House Number (Alphanumeric) | ||||
| 44 | HNR1BISALT | H | HNR1BIS | IS-M: House Numbers To (Numerical) | ||||
| 45 | HNR2BISALT | H | HNR2BIS | IS-M/SD: Affix for Last House Number (Alphanumeric) | ||||
| 46 | X_ADRESSEN | H | X_ADRESSEN | IS-M: Update indicator: relevant addresses revised | ||||
| 47 | X_STRUKTUR | H | X_STRUKTUR | IS-M: Update indicator, related structures revised | ||||
| 48 | X_POST_DB | H | X_POST_DB | IS-M: Update indicator, postal DB edited | ||||
Maintenance Status
| read only |
| read and change |
| Time-dependent views: like U, validity data like ' ' |
| read, change, delete and insert |
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |