1. Home
  2. Resources
  3. SAP Tables
  4. JSTALIAS - IS-M: Alias Table for Streets

SAP Table JSTALIAS

IS-M: Alias Table for Streets

JSTALIAS (IS-M: Alias Table for Streets) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link JSTALIAS to other SAP tables.

JSTALIAS table fields

Field Data element Checktable Datatype Length Decimals
ALIASLFDNR IS-M: Sequence Number for Alias Table (Key) ALIASLFDNR NUMC 10 0
ALIASPREDIRECTN Directional for Street Name DIRECTIONAL CHAR 10 0
ALIASPOSTDIRECTN Directional for Street Name DIRECTIONAL CHAR 10 0
ALIASDELADDRLOW IS-M: Primary House Number (Lower Limit) ADDRPRIMLOW CHAR 10 0
ALIASDELADDRHIGH IS-M: Primary House Number (Upper Limit) ADDRPRIMHIGH CHAR 10 0
ALIASDELODDEVEN IS-M: Indicator - Even/Odd/All ODDEVENCODE CHAR 1 0
0 All
1 Odd
2 Even
SUCHFELDALIAS Search field for accessing postal structures w/o matchcode SUCHFELD CHAR 40 0
PSTLZ IS-M: Postal Code PLZ_ISP CHAR 10 0
PSTLZ_ADDON IS-M: Extension to 5-Character ZIP Code PSTLZ_ADDON CHAR 4 0
ORT01 IS-M: City ORT01_ISP CHAR 35 0
ORT02 IS-M: City District ORT02_ISP CHAR 35 0
PSTL2 IS-M: Postal Code for PO Box PLZPF CHAR 10 0
PSTL2_ADDON IS-M: Extension to 5-Character ZIP Code (PO Box) PSTL2_ADDON CHAR 4 0
PSTL3 IS-M: Company Postal Code PSTL3 CHAR 10 0
PSTL3_ADDON IS-M: Extension to 5-Character ZIP Code (Company) PSTL3_ADDON CHAR 4 0
PFACH IS-M: Post Office Box PFACH_ISP CHAR 10 0
ORTPF IS-M: City for PO Box ORTPF CHAR 35 0
STRAS Street Name STRAS_ISP CHAR 35 0
HAUSN IS-M: House Number HSNMR1 CHAR 10 0
HSNMR2 IS-M: House Number Affix HSNMR2 CHAR 8 0
ADRZUS2 Classification Using a Further Address Affix ADRZUS2 CHAR 6 0
STOCK Floor STOCK CHAR 6 0
LAND1 Country Key LAND1 T005 CHAR 3 0
PREDIRECTIONAL Directional for Street Name DIRECTIONAL TJS41 CHAR 10 0
POSTDIRECTIONAL Directional for Street Name DIRECTIONAL TJS41 CHAR 10 0
ADDRSECABBREV IS-M: Secondary Address Text ADDRSECABBREV TJS43 CHAR 4 0
ADDRSECNUMBER IS-M: Secondary Address Number ADDRSECNUMBER CHAR 8 0
STREET2 IS-M: Second street line STREET2_ISM CHAR 35 0
ALIASNAME IS-M: Alias Text (Street Name + Suffix) ALIASNAME CHAR 50 0
ALORT IS-M: City Number (Unique) JALORT CHAR 8 0
STRASSENNR IS-M: Street Number STRASSENNR CHAR 10 0
GUELTIGAB Valid-From Date GUELTIGVON DATS 8 0
GUELTIGBIS Valid-To Date GUELTIGBIS DATS 8 0
LOESCH_VM Deletion Flag for Master Data in Media Sales & Distribution LOEVM_ISP CHAR 1 0
X Yes
NULL No
ERFUSER Created By ERFUSER CHAR 12 0
ERFDATE Created On ERFDATE DATS 8 0
ERFTIME Time Created ERFTIME TIMS 6 0
AENUSER Last Changed By AENUSER CHAR 12 0
AENDATE Date of Last Change AENDATE DATS 8 0
AENTIME Time of Last Change AENTIME TIMS 6 0
VERSION_J IS-M: Version year VERSION_J NUMC 4 0
VERSION_M IS-M: Version month VERSION_M NUMC 2 0
01 January
02 February
03 March
04 April
05 May
06 June
07 July
08 August
09 September
10 October
11 November
12 December
VERSION_T IS-M: Version day VERSION_T NUMC 2 0
VERSION_NR IS-M: Version number VERSION_NR CHAR 5 0

JSTALIAS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
JSTALIAS ADDRSECABBREV JSTALIAS LAND1 TJS43 IS-M: Abbreviations for Secondary Address Texts LAND1
JSTALIAS ADDRSECABBREV JSTALIAS ADDRSECABBREV TJS43 IS-M: Abbreviations for Secondary Address Texts ADDRSECABBREV
JSTALIAS LAND1 SYST MANDT T005 Countries MANDT
JSTALIAS LAND1 JSTALIAS LAND1 T005 Countries LAND1
JSTALIAS POSTDIRECTIONAL JSTALIAS POSTDIRECTIONAL TJS41 IS-M: Direction Data for Street Names DIRECTIONAL
JSTALIAS POSTDIRECTIONAL JSTALIAS LAND1 TJS41 IS-M: Direction Data for Street Names LAND1
JSTALIAS PREDIRECTIONAL JSTALIAS LAND1 TJS41 IS-M: Direction Data for Street Names LAND1
JSTALIAS PREDIRECTIONAL JSTALIAS PREDIRECTIONAL TJS41 IS-M: Direction Data for Street Names DIRECTIONAL