Follow us on LinkedIn for your next SAP project

SAP Table JGTSADR

IS-M: Extended Address Management

JGTSADR (IS-M: Extended Address Management) 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 JGTSADR to other SAP tables.

JGTSADR table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
MANDT T000
CLNT
3 0
ADRNR
IS-M: Address Number
JADRNR
CHAR
10 0
UVADR_ST
IS-M: Coding Status of Address
UVADR_AD
CHAR
1 0
UVADR_PF
IS-M: Coding Status of Address
UVADR_AD
CHAR
1 0
UVADR_GK
IS-M: Coding Status of Address
UVADR_AD
CHAR
1 0
HERK
IS-M: Use of Address
HERK
CHAR
1 0
XADRLOE
IS-M: Deletion Flag for Address
XLOES
CHAR
1 0
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
ANRED
Form of Address Key
JANRED TJG43
CHAR
2 0
NAME1
IS-M: Business Partner Name
NAME1_ISP
CHAR
35 0
NAME2
IS-M: First Name of Business Partner
NAME2_ISP
CHAR
35 0
NAME3
IS-M: Further Name Field for Business Partner
NAME3_ISP
CHAR
35 0
NAME4
IS-M: Further Name Field for Business Partner
NAME4_ISP
CHAR
35 0
TITEL
IS-M: Title
TITEL_ISP T535N
CHAR
15 0
NAMZU
IS-M: Name Affix
NAMZU_ISP T535N
CHAR
15 0
VORSW
IS-M: Name Prefix
VORSW_ISP T535N
CHAR
15 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
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
SUCHFELDALIAS
Search field for accessing postal structures w/o matchcode
SUCHFELD
CHAR
40 0
POSTEINORT
IS-M: City Number (Unique)
JALORT JSTORTPRO
CHAR
8 0
ERSTADR
IS-M: Address Proposal for Alternatives
ERSTADR
CHAR
1 0
POSTEINSTR
IS-M: Street Number
STRASSENNR JSTSTRPRO
CHAR
10 0
PEINORTPF
IS-M: Postal Unit of City for PO Box
ALORT2 JSTORTPRO
CHAR
8 0
LOCCO
City Coordinates
LOCCO
CHAR
10 0
NIELS
Nielsen ID
NIELS TNLS
CHAR
2 0
COUNC
County Code
COUNC T005E
CHAR
3 0
CITYC
City Code
CITYC T005G
CHAR
4 0
RPMKR
Regional Market
RPMKR
CHAR
5 0
SORTL
Sort field
SORTL
CHAR
10 0
SORT2
IS-M: Sort Field 2 (for Internal Use)
SORTL2
CHAR
20 0
SORT3
IS-M: Sort field 3 (internal)
SORTL3
CHAR
30 0
BU_SORT1
Search term 1 for business partner
BU_SORT1
CHAR
20 0
SPRAS
Language Key
SPRAS T002
LANG
1 0
REGIO
Region (State, Province, County)
REGIO T005S
CHAR
3 0
TELFP
IS-M: Home Phone Number
TELFP
CHAR
16 0
TELFD
IS-M: Telephone Number at Work
TELFD
CHAR
16 0
TELW1
IS-M: Additional Telephone Number
TELWT
CHAR
16 0
TELW2
IS-M: Additional Telephone Number
TELWT
CHAR
16 0
TELW3
IS-M: Additional Telephone Number
TELWT
CHAR
16 0
TELW4
IS-M: Mobile Phone Number
TELWF
CHAR
20 0
TELW5
IS-M: Mobile Phone Number
TELWF
CHAR
20 0
TELFX
Fax Number
TELFX
CHAR
31 0
TELF1
IS-M: Additional Fax Number
TELFT
CHAR
16 0
TELF2
IS-M: Additional Fax Number
TELFT
CHAR
16 0
TELF3
IS-M: Additional Fax Number
TELFT
CHAR
16 0
TELTX
Teletex number
TELTX
CHAR
30 0
TELX1
Telex number
TELX1
CHAR
30 0
TELBX
Telebox number
TELBX
CHAR
15 0
DATLT
Data communication line no.
DATLT
CHAR
14 0
STDKO
Default communications service
STDKO_D
CHAR
1 0
GPHERK
IS-M: Business Partner Origin
GPHERK TJG41
CHAR
2 0
GP_REF
IS-M: Business Partner Key
GPNR JGTGPNR
CHAR
10 0
VBELN_REF
IS-M/SD: Publishing Sales Order
AVNR JKAK
CHAR
10 0
POSNR_REF
Sales Order Item
APNR JKAP
NUMC
6 0
JPARVW_REF
IS-M: Business Partner Role
JPARVW TJG39
CHAR
2 0
BEABLS_REF
IS-M: Unloading Point
BEABLST JRTBEABST
CHAR
10 0
TELFP_COD
IS-M: Home Phone Number
TELFP
CHAR
16 0
TELFD_COD
IS-M: Telephone Number at Work
TELFD
CHAR
16 0
NAME1_MACO
IS-M: Business Partner Name (Upper Case for Matchcode)
NAME1_ISPM
CHAR
35 0
NAME2_MACO
IS-M: Bus.Partner's First Name (Upper Case for Matchcode)
NAME2_ISPM
CHAR
35 0
STRAS_MACO
IS-M: Street Name
STRAS_ISPM
CHAR
35 0
ORT01_MACO
IS-M/SD: City Name (Upper Case for Matchcode)
ORT01_ISPM
CHAR
35 0
ISPTELVWP
IS-M: Area Code (Home)
ISPTELVWP
CHAR
10 0
ISPTELP
IS-M: Telephone Number
ISPTELP
CHAR
20 0
ISPTELVWD
IS-M: Area Code - Work
ISPTELVWD
CHAR
10 0
ISPTELD
IS-M: Telephone Number
ISPTELD
CHAR
20 0
ISPHANDY
IS-M: Mobile Phone Number
ISPHANDY
CHAR
30 0
ISPEMAIL
IS-M: E-Mail Address
ISPEMAIL
CHAR
50 0
ISPADRBSND
IS-M/SD: Note for Home Delivery to Ship-to Party
ISPADRBSND
CHAR
50 0
TECHNUMZUG
IS-M: Technical Relocation Due to Postal Data Change
TECHNUMZUG
CHAR
1 0
XNOMESS
IS-M: Indicator - Do Not Perform Output Determination
XNOMESS
CHAR
1 0
ALIASLFDNR
IS-M: Sequence Number for Alias Table (Key)
ALIASLFDNR JSTALIAS
NUMC
10 0
XNOCARPERMESS
IS-M: No Change of Carrier When Address Changes
XNOCARPERMESS
CHAR
1 0
TXJCD
Tax Jurisdiction
TXJCD TTXJ
CHAR
15 0
ANI_TELNRP
Telephone number for determining caller
AD_TELNRCL
CHAR
30 0
ANI_TELNRD
Telephone number for determining caller
AD_TELNRCL
CHAR
30 0
ANI_ISPHANDY
Telephone number for determining caller
AD_TELNRCL
CHAR
30 0
HH_REF
IS-M: Business Partner Number of Household
GPNR_HH JGTHH
CHAR
10 0
HH_EXCLUDE
IS-M: Indicator: Exclude Household Assignment
HH_EXCLUDE
CHAR
1 0
PRIVACY_STATUS
IS-M: Status of Address As Regards Data Protection
ADDRESS_PRIVACY_STATUS
CHAR
1 0
ADDRNUMBER
Address number
AD_ADDRNUM
CHAR
10 0
PERSNUMBER
Person number
AD_PERSNUM
CHAR
10 0

JGTSADR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
JGTSADR ADDRSECABBREV JGTSADR ADDRSECABBREV TJS43
IS-M: Abbreviations for Secondary Address Texts
ADDRSECABBREV
JGTSADR ADDRSECABBREV JGTSADR LAND1 TJS43
IS-M: Abbreviations for Secondary Address Texts
LAND1
JGTSADR ALIASLFDNR JGTSADR ALIASLFDNR JSTALIAS
IS-M: Alias Table for Streets
ALIASLFDNR
JGTSADR ANRED JGTSADR ANRED TJG43
IS-M: Form-of-Address Key
JANRED
JGTSADR ANRED JGTSADR MANDT TJG43
IS-M: Form-of-Address Key
MANDT
JGTSADR BEABLS_REF JGTSADR MANDT JRTBEABST
IS-M/SD: Unloading Point
MANDT
JGTSADR BEABLS_REF JGTSADR BEABLS_REF JRTBEABST
IS-M/SD: Unloading Point
BEABLST
JGTSADR CITYC JGTSADR MANDT T005G
City
MANDT
JGTSADR CITYC JGTSADR LAND1 T005G
City
LAND1
JGTSADR CITYC JGTSADR REGIO T005G
City
REGIO
JGTSADR CITYC JGTSADR CITYC T005G
City
CITYC
JGTSADR COUNC JGTSADR MANDT T005E
County
MANDT
JGTSADR COUNC JGTSADR LAND1 T005E
County
LAND1
JGTSADR COUNC JGTSADR REGIO T005E
County
REGIO
JGTSADR COUNC JGTSADR COUNC T005E
County
COUNC
JGTSADR GPHERK JGTSADR MANDT TJG41
IS-M/SD: Business Partner Origin
MANDT
JGTSADR GPHERK JGTSADR GPHERK TJG41
IS-M/SD: Business Partner Origin
GPHERK
JGTSADR GP_REF JGTSADR MANDT JGTGPNR
IS-M: Central Business Partner Table
MANDT
JGTSADR GP_REF JGTSADR GP_REF JGTGPNR
IS-M: Central Business Partner Table
GPNR
JGTSADR HH_REF JGTSADR MANDT JGTHH
IS-M: Household Business Partner
CLIENT
JGTSADR HH_REF JGTSADR HH_REF JGTHH
IS-M: Household Business Partner
PARTNER
JGTSADR JPARVW_REF JGTSADR MANDT TJG39
IS-M/SD: Business Partner Roles
MANDT
JGTSADR JPARVW_REF JGTSADR JPARVW_REF TJG39
IS-M/SD: Business Partner Roles
JPARVW
JGTSADR LAND1 JGTSADR LAND1 T005
Countries
LAND1
JGTSADR LAND1 JGTSADR MANDT T005
Countries
MANDT
JGTSADR MANDT JGTSADR MANDT T000
Clients
MANDT
JGTSADR NAMZU JGTSADR MANDT T535N
Name affixes
MANDT
JGTSADR NAMZU 'Z' T535N
Name affixes
ART
JGTSADR NAMZU JGTSADR NAMZU T535N
Name affixes
TITEL
JGTSADR NIELS JGTSADR MANDT TNLS
Nielsen ID
MANDT
JGTSADR NIELS JGTSADR NIELS TNLS
Nielsen ID
NIELS
JGTSADR PEINORTPF JGTSADR LAND1 JSTORTPRO
IS-M/SD: City File (Post)
LAND1
JGTSADR PEINORTPF JGTSADR PEINORTPF JSTORTPRO
IS-M/SD: City File (Post)
ALORT
JGTSADR POSNR_REF JGTSADR MANDT JKAP
Sales Order - Item Data
MANDT
JGTSADR POSNR_REF JGTSADR VBELN_REF JKAP
Sales Order - Item Data
VBELN
JGTSADR POSNR_REF JGTSADR POSNR_REF JKAP
Sales Order - Item Data
POSNR
JGTSADR POSTDIRECTIONAL JGTSADR LAND1 TJS41
IS-M: Direction Data for Street Names
LAND1
JGTSADR POSTDIRECTIONAL JGTSADR POSTDIRECTIONAL TJS41
IS-M: Direction Data for Street Names
DIRECTIONAL
JGTSADR POSTEINORT JGTSADR LAND1 JSTORTPRO
IS-M/SD: City File (Post)
LAND1
JGTSADR POSTEINORT JGTSADR POSTEINORT JSTORTPRO
IS-M/SD: City File (Post)
ALORT
JGTSADR POSTEINSTR JGTSADR LAND1 JSTSTRPRO
IS-M/SD: Street File (Post)
LAND1
JGTSADR POSTEINSTR JGTSADR POSTEINORT JSTSTRPRO
IS-M/SD: Street File (Post)
ALORT
JGTSADR POSTEINSTR JGTSADR POSTEINSTR JSTSTRPRO
IS-M/SD: Street File (Post)
STRASSENNR
JGTSADR PREDIRECTIONAL JGTSADR LAND1 TJS41
IS-M: Direction Data for Street Names
LAND1
JGTSADR PREDIRECTIONAL JGTSADR PREDIRECTIONAL TJS41
IS-M: Direction Data for Street Names
DIRECTIONAL
JGTSADR REGIO JGTSADR LAND1 T005S
Taxes: Region (Province) Key
LAND1
JGTSADR REGIO JGTSADR REGIO T005S
Taxes: Region (Province) Key
BLAND
JGTSADR REGIO JGTSADR MANDT T005S
Taxes: Region (Province) Key
MANDT
JGTSADR SPRAS JGTSADR SPRAS T002
Language Keys (Component BC-I18)
SPRAS
JGTSADR TITEL 'T' T535N
Name affixes
ART
JGTSADR TITEL JGTSADR TITEL T535N
Name affixes
TITEL
JGTSADR TITEL JGTSADR MANDT T535N
Name affixes
MANDT
JGTSADR TXJCD JGTSADR TXJCD TTXJ
Check Table for Tax Jurisdiction
TXJCD
JGTSADR TXJCD JGTSADR MANDT TTXJ
Check Table for Tax Jurisdiction
MANDT
JGTSADR TXJCD T005 KALSM TTXJ
Check Table for Tax Jurisdiction
KALSM
JGTSADR VBELN_REF JGTSADR MANDT JKAK
Sales Order Header Data
MANDT
JGTSADR VBELN_REF JGTSADR VBELN_REF JKAK
Sales Order Header Data
VBELN
JGTSADR VORSW JGTSADR MANDT T535N
Name affixes
MANDT
JGTSADR VORSW 'V' T535N
Name affixes
ART
JGTSADR VORSW JGTSADR VORSW T535N
Name affixes
TITEL