SAP ABAP Table JSTALIAS (IS-M: Alias Table for Streets)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷
IS-M-MD (Application Component) Master Data
⤷
JMDGEN (Package) Generic Master Data Media

⤷

⤷

Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | JSTALIAS |
![]() |
Short Description | IS-M: Alias Table for Streets |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | C | Customizing table, maintenance only by cust., not SAP import |
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 | ![]() |
ALIASLFDNR | NUMC10 | NUMC | 10 | 0 | IS-M: Sequence Number for Alias Table (Key) | ||
2 | ![]() |
0 | 0 | Include Structure for Alias (Direction, Area, Search Field) | |||||
3 | ![]() |
DIRECTIONAL | DIRECTIONAL | CHAR | 10 | 0 | IS-M: Direction for Street | * | |
4 | ![]() |
DIRECTIONAL | DIRECTIONAL | CHAR | 10 | 0 | IS-M: Direction for Street | * | |
5 | ![]() |
ADDRPRIMLOW | HAUSNUMMER | CHAR | 10 | 0 | IS-M: Primary House Number (Lower Limit) | ||
6 | ![]() |
ADDRPRIMHIGH | HAUSNUMMER | CHAR | 10 | 0 | IS-M: Primary House Number (Upper Limit) | ||
7 | ![]() |
ODDEVENCODE | ODDEVENCODE | CHAR | 1 | 0 | IS-M: Indicator - Even/Odd/All | ||
8 | ![]() |
SUCHFELD | CHAR40 | CHAR | 40 | 0 | Search field for accessing postal structures w/o matchcode | ||
9 | ![]() |
0 | 0 | Core address data | |||||
10 | ![]() |
PLZ_ISP | PSTLZ | CHAR | 10 | 0 | IS-M: Postal Code | ||
11 | ![]() |
PSTLZ_ADDON | CHAR4 | CHAR | 4 | 0 | IS-M: Extension to 5-Character ZIP Code | ||
12 | ![]() |
ORT01_ISP | TEXT35 | CHAR | 35 | 0 | IS-M: City | ||
13 | ![]() |
ORT02_ISP | TEXT35 | CHAR | 35 | 0 | IS-M: City District | ||
14 | ![]() |
PLZPF | PSTLZ | CHAR | 10 | 0 | IS-M: Postal Code for PO Box | ||
15 | ![]() |
PSTL2_ADDON | CHAR4 | CHAR | 4 | 0 | IS-M: Extension to 5-Character ZIP Code (PO Box) | ||
16 | ![]() |
PSTL3 | PSTLZ | CHAR | 10 | 0 | IS-M: Company Postal Code | ||
17 | ![]() |
PSTL3_ADDON | CHAR4 | CHAR | 4 | 0 | IS-M: Extension to 5-Character ZIP Code (Company) | ||
18 | ![]() |
PFACH_ISP | PFACH_ISP | CHAR | 10 | 0 | IS-M: Post Office Box | ||
19 | ![]() |
ORTPF | TEXT35 | CHAR | 35 | 0 | IS-M: City for PO Box | ||
20 | ![]() |
STRAS_ISP | TEXT35 | CHAR | 35 | 0 | IS-M: Street Name | ||
21 | ![]() |
HSNMR1 | HAUSNUMMER | CHAR | 10 | 0 | IS-M: House Number | ||
22 | ![]() |
HSNMR2 | CHAR8 | CHAR | 8 | 0 | IS-M: House Number Affix | ||
23 | ![]() |
ADRZUS2 | ADRZUS | CHAR | 6 | 0 | Classification Using a Further Address Affix | ||
24 | ![]() |
STOCK | STOCK | CHAR | 6 | 0 | Floor | ||
25 | ![]() |
LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
26 | ![]() |
DIRECTIONAL | DIRECTIONAL | CHAR | 10 | 0 | IS-M: Direction for Street | TJS41 | |
27 | ![]() |
DIRECTIONAL | DIRECTIONAL | CHAR | 10 | 0 | IS-M: Direction for Street | TJS41 | |
28 | ![]() |
ADDRSECABBREV | ADDRSECABBREV | CHAR | 4 | 0 | IS-M: Secondary Address Text | TJS43 | |
29 | ![]() |
ADDRSECNUMBER | ADDRSECNUMBER | CHAR | 8 | 0 | IS-M: Secondary Address Number | ||
30 | ![]() |
STREET2_ISM | TEXT35 | CHAR | 35 | 0 | IS-M: Second street line | ||
31 | ![]() |
0 | 0 | Include Structure for Alias (Alias Name) | |||||
32 | ![]() |
ALIASNAME | TEXT50 | CHAR | 50 | 0 | IS-M: Alias Text (Street Name + Suffix) | ||
33 | ![]() |
JALORT | ALORT | CHAR | 8 | 0 | IS-M: City Number (Unique) | * | |
34 | ![]() |
STRASSENNR | STRASSENNR | CHAR | 10 | 0 | IS-M: Street Number | * | |
35 | ![]() |
GUELTIGVON | DATUM | DATS | 8 | 0 | Valid-From Date | ||
36 | ![]() |
GUELTIGBIS | DATUM | DATS | 8 | 0 | Valid-To Date | ||
37 | ![]() |
LOEVM_ISP | XFELD | CHAR | 1 | 0 | Deletion Flag for Master Data in Media Sales & Distribution | ||
38 | ![]() |
0 | 0 | Created-By Data (Medium Scope) | |||||
39 | ![]() |
ERFUSER | USNAM | CHAR | 12 | 0 | Created By | ||
40 | ![]() |
ERFDATE | DATUM | DATS | 8 | 0 | Created On | ||
41 | ![]() |
ERFTIME | UZEIT | TIMS | 6 | 0 | Time Created | ||
42 | ![]() |
AENUSER | USNAM | CHAR | 12 | 0 | Last Changed By | ||
43 | ![]() |
AENDATE | DATUM | DATS | 8 | 0 | Date of Last Change | ||
44 | ![]() |
AENTIME | UZEIT | TIMS | 6 | 0 | Time of Last Change | ||
45 | ![]() |
0 | 0 | Version (for upgrade procedures for postal data) | |||||
46 | ![]() |
VERSION_J | JAHR | NUMC | 4 | 0 | IS-M: Version year | ||
47 | ![]() |
VERSION_M | AM_MONAT | NUMC | 2 | 0 | IS-M: Version month | ||
48 | ![]() |
VERSION_T | AM_TAG | NUMC | 2 | 0 | IS-M: Version day | ||
49 | ![]() |
VERSION_NR | VERSION_NR | CHAR | 5 | 0 | IS-M: Version number |
Foreign Keys
![]() |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
---|---|---|---|---|---|---|---|
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
1 | JSTALIAS | ADDRSECABBREV | ![]() |
![]() |
KEY | 1 | CN |
2 | JSTALIAS | LAND1 | ![]() |
![]() |
REF | C | CN |
3 | JSTALIAS | POSTDIRECTIONAL | ![]() |
![]() |
KEY | 1 | CN |
4 | JSTALIAS | PREDIRECTIONAL | ![]() |
![]() |
KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |