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
⤷ 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 | 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 | JSTSTRUPDA | MANDT | MANDT | Client | |||
2 | LAND1_ALT | JSTSTRUPDA | LAND1_ALT | LAND1 | Country Key | |||
3 | ALORT_ALT | JSTSTRUPDA | ALORT_ALT | JALORT | IS-M: City Number (Unique) | |||
4 | STRNR_ALT | JSTSTRUPDA | STRNR_ALT | STRASSENNR | IS-M: Street Number | |||
5 | LAND1 | JSTSTRUPDA | LAND1 | LAND1 | Country Key | |||
6 | ALORT | JSTSTRUPDA | ALORT | JALORT | IS-M: City Number (Unique) | |||
7 | STRASSENNR | JSTSTRUPDA | STRASSENNR | STRASSENNR | IS-M: Street Number | |||
8 | STR_NAME_L | JSTSTRUPDA | STR_NAME_L | STR_NAME_L | IS-M: Street Name (long) | |||
9 | OTL_KEY | JSTSTRUPDA | OTL_KEY | OTL_KEY | IS-M: City District Number | |||
10 | KREISG_SCH | JSTSTRUPDA | KREISG_SCH | KREISG_SCH | IS-M: District Municipality Key | |||
11 | HNRKENN | JSTSTRUPDA | HNRKENN | HNRKENN | IS-M: Identifier for House Number Range | |||
12 | HNR1VON | JSTSTRUPDA | HNR1VON | HNR1VON | IS-M: House Number From (Numerical) | |||
13 | HNR2VON | JSTSTRUPDA | HNR2VON | HNR2VON | IS-M/SD: Affix to First House Number (Alphanumeric) | |||
14 | HNR1BIS | JSTSTRUPDA | HNR1BIS | HNR1BIS | IS-M: House Numbers To (Numerical) | |||
15 | HNR2BIS | JSTSTRUPDA | HNR2BIS | HNR2BIS | IS-M/SD: Affix for Last House Number (Alphanumeric) | |||
16 | PLZ_ZSTR | JSTSTRUPDA | PLZ_ZSTR | PLZ_ZSTR | IS-M: Postal Code of Street Section for Home Delivery | |||
17 | STR_NRPOST | JSTSTRUPDA | STR_NRPOST | STR_NRPOST | IS-M: Street number from German postal service | |||
18 | DBCODE_ALT | JSTSTRUPDA | DBCODE_ALT | DBCODE | DB Code for Structural Changes | |||
19 | DBCODE_NEU | JSTSTRUPDA | DBCODE_NEU | DBCODE | DB Code for Structural Changes | |||
20 | SUCHFELDS | JSTSTRUPDA | SUCHFELDS | H | SUCHFELD | Search field for accessing postal structures w/o matchcode | ||
21 | STR_NAME_K | JSTSTRUPDA | STR_NAME_K | H | STR_NAME_K | IS-M: Street Name (Short) | ||
22 | STR_NAME_G | JSTSTRUPDA | STR_NAME_G | H | STR_NAME_G | IS-M: Street name - upper case for matchcode | ||
23 | STR_NAME_S | JSTSTRUPDA | STR_NAME_S | H | STR_NAME_S | IS-M: Street Name (Long Without Special Characters) | ||
24 | STRHNR1000 | JSTSTRUPDA | STRHNR1000 | H | STRHNR1000 | IS-M: 1000 column in house number interval | ||
25 | STR_CODE | JSTSTRUPDA | STR_CODE | H | STR_CODE | IS-M: Street code for coding street sections | ||
26 | X_FEHLER | JSTSTRUPDA | X_FEHLER | H | X_FEHLER | IS-M: Incorrect data record | ||
27 | ERFUSER | JSTSTRUPDA | ERFUSER | H | ERFUSER | Created By | ||
28 | ERFDATE | JSTSTRUPDA | ERFDATE | H | ERFDATE | Created On | ||
29 | ERFTIME | JSTSTRUPDA | ERFTIME | H | ERFTIME | Time Created | ||
30 | AENUSER | JSTSTRUPDA | AENUSER | H | AENUSER | Last Changed By | ||
31 | AENDATE | JSTSTRUPDA | AENDATE | H | AENDATE | Date of Last Change | ||
32 | AENTIME | JSTSTRUPDA | AENTIME | H | AENTIME | Time of Last Change | ||
33 | VERSION_J | JSTSTRUPDA | VERSION_J | H | VERSION_J | IS-M: Version year | ||
34 | VERSION_M | JSTSTRUPDA | VERSION_M | H | VERSION_M | IS-M: Version month | ||
35 | VERSION_T | JSTSTRUPDA | VERSION_T | H | VERSION_T | IS-M: Version day | ||
36 | VERSION_NR | JSTSTRUPDA | VERSION_NR | S | VERSION_NR | IS-M: Version number | ||
37 | LOESCH_VM | JSTSTRUPDA | LOESCH_VM | H | LOEVM_ISP | Deletion Flag for Master Data in Media Sales & Distribution | ||
38 | ST_NAMEALT | JSTSTRUPDA | ST_NAMEALT | H | STR_NAME_L | IS-M: Street Name (long) | ||
39 | STR_NRPALT | JSTSTRUPDA | STR_NRPALT | H | STR_NRPOST | IS-M: Street number from German postal service | ||
40 | HNRKENNALT | JSTSTRUPDA | HNRKENNALT | H | HNRKENN | IS-M: Identifier for House Number Range | ||
41 | HNR1000ALT | JSTSTRUPDA | HNR1000ALT | H | STRHNR1000 | IS-M: 1000 column in house number interval | ||
42 | HNR1VONALT | JSTSTRUPDA | HNR1VONALT | H | HNR1VON | IS-M: House Number From (Numerical) | ||
43 | HNR2VONALT | JSTSTRUPDA | HNR2VONALT | H | HNR2VON | IS-M/SD: Affix to First House Number (Alphanumeric) | ||
44 | HNR1BISALT | JSTSTRUPDA | HNR1BISALT | H | HNR1BIS | IS-M: House Numbers To (Numerical) | ||
45 | HNR2BISALT | JSTSTRUPDA | HNR2BISALT | H | HNR2BIS | IS-M/SD: Affix for Last House Number (Alphanumeric) | ||
46 | X_ADRESSEN | JSTSTRUPDA | X_ADRESSEN | H | X_ADRESSEN | IS-M: Update indicator: relevant addresses revised | ||
47 | X_STRUKTUR | JSTSTRUPDA | X_STRUKTUR | H | X_STRUKTUR | IS-M: Update indicator, related structures revised | ||
48 | X_POST_DB | JSTSTRUPDA | 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 |