SAP ABAP Table JGTSADR (IS-M: Extended Adress Management)
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 JGTSADR   Table Relationship Diagram
Short Description IS-M: Extended Adress Management    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 ADRNR JADRNR JADRNR CHAR 10   0   IS-M: Address Number  
3 UVADR_ST UVADR_AD UVADR_AD CHAR 1   0   IS-M: Coding Status of Address  
4 UVADR_PF UVADR_AD UVADR_AD CHAR 1   0   IS-M: Coding Status of Address  
5 UVADR_GK UVADR_AD UVADR_AD CHAR 1   0   IS-M: Coding Status of Address  
6 HERK HERK HERK CHAR 1   0   IS-M: Use of Address  
7 XADRLOE XLOES XFELD CHAR 1   0   IS-M: Deletion Flag for Address  
8 .INCLUDE       0   0   Created-By Data (Medium Scope)  
9 ERFUSER ERFUSER USNAM CHAR 12   0   Created By  
10 ERFDATE ERFDATE DATUM DATS 8   0   Created On  
11 ERFTIME ERFTIME UZEIT TIMS 6   0   Time Created  
12 AENUSER AENUSER USNAM CHAR 12   0   Last Changed By  
13 AENDATE AENDATE DATUM DATS 8   0   Date of Last Change  
14 AENTIME AENTIME UZEIT TIMS 6   0   Time of Last Change  
15 ANRED JANRED JANRED CHAR 2   0   IS-M: Form-of-Address Key TJG43
16 NAME1 NAME1_ISP NAME CHAR 35   0   IS-M: Business Partner Name  
17 NAME2 NAME2_ISP NAME CHAR 35   0   IS-M: First Name of Business Partner  
18 NAME3 NAME3_ISP NAME CHAR 35   0   IS-M: Further Name Field for Business Partner  
19 NAME4 NAME4_ISP NAME CHAR 35   0   IS-M: Further Name Field for Business Partner  
20 TITEL TITEL_ISP TITEL CHAR 15   0   IS-M: Title T535N
21 NAMZU NAMZU_ISP TITEL CHAR 15   0   IS-M: Name Affix T535N
22 VORSW VORSW_ISP TITEL CHAR 15   0   IS-M: Name Prefix T535N
23 .INCLUDE       0   0   Core address data  
24 PSTLZ PLZ_ISP PSTLZ CHAR 10   0   IS-M: Postal Code  
25 PSTLZ_ADDON PSTLZ_ADDON CHAR4 CHAR 4   0   IS-M: Extension to 5-Character ZIP Code  
26 ORT01 ORT01_ISP TEXT35 CHAR 35   0   IS-M: City  
27 ORT02 ORT02_ISP TEXT35 CHAR 35   0   IS-M: City District  
28 PSTL2 PLZPF PSTLZ CHAR 10   0   IS-M: Postal Code for PO Box  
29 PSTL2_ADDON PSTL2_ADDON CHAR4 CHAR 4   0   IS-M: Extension to 5-Character ZIP Code (PO Box)  
30 PSTL3 PSTL3 PSTLZ CHAR 10   0   IS-M: Company Postal Code  
31 PSTL3_ADDON PSTL3_ADDON CHAR4 CHAR 4   0   IS-M: Extension to 5-Character ZIP Code (Company)  
32 PFACH PFACH_ISP PFACH_ISP CHAR 10   0   IS-M: Post Office Box  
33 ORTPF ORTPF TEXT35 CHAR 35   0   IS-M: City for PO Box  
34 STRAS STRAS_ISP TEXT35 CHAR 35   0   IS-M: Street Name  
35 HAUSN HSNMR1 HAUSNUMMER CHAR 10   0   IS-M: House Number  
36 HSNMR2 HSNMR2 CHAR8 CHAR 8   0   IS-M: House Number Affix  
37 ADRZUS2 ADRZUS2 ADRZUS CHAR 6   0   Classification Using a Further Address Affix  
38 STOCK STOCK STOCK CHAR 6   0   Floor  
39 LAND1 LAND1 LAND1 CHAR 3   0   Country Key T005
40 PREDIRECTIONAL DIRECTIONAL DIRECTIONAL CHAR 10   0   IS-M: Direction for Street TJS41
41 POSTDIRECTIONAL DIRECTIONAL DIRECTIONAL CHAR 10   0   IS-M: Direction for Street TJS41
42 ADDRSECABBREV ADDRSECABBREV ADDRSECABBREV CHAR 4   0   IS-M: Secondary Address Text TJS43
43 ADDRSECNUMBER ADDRSECNUMBER ADDRSECNUMBER CHAR 8   0   IS-M: Secondary Address Number  
44 STREET2 STREET2_ISM TEXT35 CHAR 35   0   IS-M: Second street line  
45 .INCLUDE       0   0   Include Structure for Alias (Alias Name)  
46 ALIASNAME ALIASNAME TEXT50 CHAR 50   0   IS-M: Alias Text (Street Name + Suffix)  
47 .INCLUDE       0   0   Include Structure for Alias (Direction, Area, Search Field)  
48 ALIASPREDIRECTN DIRECTIONAL DIRECTIONAL CHAR 10   0   IS-M: Direction for Street *
49 ALIASPOSTDIRECTN DIRECTIONAL DIRECTIONAL CHAR 10   0   IS-M: Direction for Street *
50 ALIASDELADDRLOW ADDRPRIMLOW HAUSNUMMER CHAR 10   0   IS-M: Primary House Number (Lower Limit)  
51 ALIASDELADDRHIGH ADDRPRIMHIGH HAUSNUMMER CHAR 10   0   IS-M: Primary House Number (Upper Limit)  
52 ALIASDELODDEVEN ODDEVENCODE ODDEVENCODE CHAR 1   0   IS-M: Indicator - Even/Odd/All  
53 SUCHFELDALIAS SUCHFELD CHAR40 CHAR 40   0   Search field for accessing postal structures w/o matchcode  
54 POSTEINORT JALORT ALORT CHAR 8   0   IS-M: City Number (Unique) JSTORTPRO
55 ERSTADR ERSTADR ERSTADR CHAR 1   0   IS-M: Address Proposal for Alternatives  
56 POSTEINSTR STRASSENNR STRASSENNR CHAR 10   0   IS-M: Street Number JSTSTRPRO
57 PEINORTPF ALORT2 ALORT CHAR 8   0   IS-M: Postal Unit of City for PO Box JSTORTPRO
58 LOCCO LOCCO LOCCO CHAR 10   0   City Coordinates  
59 NIELS NIELS NIELS CHAR 2   0   Nielsen ID TNLS
60 COUNC COUNC COUNC CHAR 3   0   County Code T005E
61 CITYC CITYC CITYC CHAR 4   0   City Code T005G
62 RPMKR RPMKR RPMKR CHAR 5   0   Regional market  
63 SORTL SORTL CHAR10 CHAR 10   0   Sort field  
64 SORT2 SORTL2 CHAR20 CHAR 20   0   IS-M: Sort Field 2 (for Internal Use)  
65 SORT3 SORTL3 TEXT30 CHAR 30   0   IS-M: Sort field 3 (internal)  
66 BU_SORT1 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
67 SPRAS SPRAS SPRAS LANG 1   0   Language Key T002
68 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
69 TELFP TELFP TEXT16 CHAR 16   0   IS-M: Home Phone Number  
70 TELFD TELFD TEXT16 CHAR 16   0   IS-M: Telephone Number at Work  
71 TELW1 TELWT TEXT16 CHAR 16   0   IS-M: Additional Telephone Number  
72 TELW2 TELWT TEXT16 CHAR 16   0   IS-M: Additional Telephone Number  
73 TELW3 TELWT TEXT16 CHAR 16   0   IS-M: Additional Telephone Number  
74 TELW4 TELWF TEXT20 CHAR 20   0   IS-M: Mobile Phone Number  
75 TELW5 TELWF TEXT20 CHAR 20   0   IS-M: Mobile Phone Number  
76 TELFX TELFX TEXT31 CHAR 31   0   Fax Number  
77 TELF1 TELFT TEXT16 CHAR 16   0   IS-M: Additional Fax Number  
78 TELF2 TELFT TEXT16 CHAR 16   0   IS-M: Additional Fax Number  
79 TELF3 TELFT TEXT16 CHAR 16   0   IS-M: Additional Fax Number  
80 TELTX TELTX TEXT30 CHAR 30   0   Teletex number  
81 TELX1 TELX1 TEXT30 CHAR 30   0   Telex number  
82 TELBX TELBX TEXT15 CHAR 15   0   Telebox number  
83 DATLT DATLT TEXT14 CHAR 14   0   Data communication line no.  
84 STDKO STDKO_D CHAR1 CHAR 1   0   Default communications service  
85 GPHERK GPHERK GPHERK CHAR 2   0   IS-M: Business Partner Origin TJG41
86 GP_REF GPNR GPNR CHAR 10   0   IS-M: Business Partner Key JGTGPNR
87 VBELN_REF AVNR AVNR CHAR 10   0   IS-M/SD: Publishing Sales Order JKAK
88 POSNR_REF APNR APNR NUMC 6   0   Sales Order Item JKAP
89 JPARVW_REF JPARVW JPARVW CHAR 2   0   IS-M: Business Partner Role TJG39
90 BEABLS_REF BEABLST BEABLST CHAR 10   0   IS-M: Unloading Point JRTBEABST
91 TELFP_COD TELFP TEXT16 CHAR 16   0   IS-M: Home Phone Number  
92 TELFD_COD TELFD TEXT16 CHAR 16   0   IS-M: Telephone Number at Work  
93 NAME1_MACO NAME1_ISPM NAME_MACO CHAR 35   0   IS-M: Business Partner Name (Upper Case for Matchcode)  
94 NAME2_MACO NAME2_ISPM NAME_MACO CHAR 35   0   IS-M: Bus.Partner's First Name (Upper Case for Matchcode)  
95 STRAS_MACO STRAS_ISPM STRAS_MACO CHAR 35   0   IS-M: Street Name  
96 ORT01_MACO ORT01_ISPM ORT01_MACO CHAR 35   0   IS-M/SD: City Name (Upper Case for Matchcode)  
97 .INCLUDE       0   0   IS-P: Home/Work Telephone Data  
98 ISPTELVWP ISPTELVWP ISPTELVW CHAR 10   0   IS-M: Area Code (Home)  
99 ISPTELP ISPTELP ISPTEL CHAR 20   0   IS-M: Telephone Number  
100 ISPTELVWD ISPTELVWD ISPTELVW CHAR 10   0   IS-M: Area Code - Work  
101 ISPTELD ISPTELD ISPTEL CHAR 20   0   IS-M: Telephone Number  
102 ISPHANDY ISPHANDY CHAR30 CHAR 30   0   IS-M: Mobile Phone Number  
103 ISPEMAIL ISPEMAIL CHAR50LOW CHAR 50   0   IS-M: E-Mail Address  
104 ISPADRBSND ISPADRBSND TEXT50 CHAR 50   0   IS-M/SD: Note for Home Delivery to Ship-to Party  
105 TECHNUMZUG TECHNUMZUG XFELD CHAR 1   0   IS-M: Technical Relocation Due to Postal Data Change  
106 XNOMESS XNOMESS XFELD CHAR 1   0   IS-M: Indicator - Do Not Perform Output Determination  
107 ALIASLFDNR ALIASLFDNR NUMC10 NUMC 10   0   IS-M: Sequence Number for Alias Table (Key) JSTALIAS
108 XNOCARPERMESS XNOCARPERMESS XFELD CHAR 1   0   IS-M: No Change of Carrier When Address Changes  
109 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction TTXJ
110 ANI_TELNRP AD_TELNRCL CHAR30 CHAR 30   0   Telephone number for determining caller  
111 ANI_TELNRD AD_TELNRCL CHAR30 CHAR 30   0   Telephone number for determining caller  
112 ANI_ISPHANDY AD_TELNRCL CHAR30 CHAR 30   0   Telephone number for determining caller  
113 HH_REF GPNR_HH BU_PARTNER CHAR 10   0   IS-M: Business Partner Number of Household JGTHH
114 HH_EXCLUDE HH_EXCLUDE XFELD CHAR 1   0   IS-M: Indicator: Exclude Household Assignment  
115 PRIVACY_STATUS ADDRESS_PRIVACY_STATUS ADDRESS_PRIVACY_STATUS CHAR 1   0   IS-M: Status of Address As Regards Data Protection  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 JGTSADR ADDRSECABBREV TJS43 ADDRSECABBREV KEY 1 CN
2 JGTSADR ALIASLFDNR JSTALIAS ALIASLFDNR KEY C CN
3 JGTSADR ANRED TJG43 JANRED REF C CN
4 JGTSADR BEABLS_REF JRTBEABST BEABLST REF C CN
5 JGTSADR CITYC T005G CITYC REF C CN
6 JGTSADR COUNC T005E COUNC REF C CN
7 JGTSADR GPHERK TJG41 GPHERK KEY 1 CN
8 JGTSADR GP_REF JGTGPNR GPNR REF C CN
9 JGTSADR HH_REF JGTHH PARTNER    
10 JGTSADR JPARVW_REF TJG39 JPARVW REF C CN
11 JGTSADR LAND1 T005 LAND1 REF C CN
12 JGTSADR MANDT T000 MANDT KEY 1 CN
13 JGTSADR NAMZU T535N TITEL    
14 JGTSADR NIELS TNLS NIELS REF C CN
15 JGTSADR PEINORTPF JSTORTPRO ALORT REF C CN
16 JGTSADR POSNR_REF JKAP POSNR REF C CN
17 JGTSADR POSTDIRECTIONAL TJS41 DIRECTIONAL KEY 1 CN
18 JGTSADR POSTEINORT JSTORTPRO ALORT REF C CN
19 JGTSADR POSTEINSTR JSTSTRPRO STRASSENNR REF C CN
20 JGTSADR PREDIRECTIONAL TJS41 DIRECTIONAL KEY 1 CN
21 JGTSADR REGIO T005S BLAND REF C CN
22 JGTSADR SPRAS T002 SPRAS REF C CN
23 JGTSADR TITEL T535N TITEL    
24 JGTSADR TXJCD TTXJ TXJCD REF C CN
25 JGTSADR VBELN_REF JKAK VBELN REF C CN
26 JGTSADR VORSW T535N TITEL    
History
Last changed by/on SAP  20130529 
SAP Release Created in