1. Home
  2. Resources
  3. SAP Tables
  4. JGTSADR - IS-M: Extended Address Management

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
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
0 coded in full
1 coded in part
2 not coded
3 does not exist
4 technical change to postal data
UVADR_PF IS-M: Coding Status of Address UVADR_AD CHAR 1 0
0 coded in full
1 coded in part
2 not coded
3 does not exist
4 technical change to postal data
UVADR_GK IS-M: Coding Status of Address UVADR_AD CHAR 1 0
0 coded in full
1 coded in part
2 not coded
3 does not exist
4 technical change to postal data
HERK IS-M: Use of Address HERK CHAR 1 0
1 Business Partner
2 IS-M/SD Order
3 Loading/Unloading Pt
4 Voucher Shipping
5 Divert Address
6 Shipping Order
7 Household
A Media Order
B Media Contact Person
C Media Order (One-Time)
XADRLOE IS-M: Deletion Flag for Address XLOES 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
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
0 All
1 Odd
2 Even
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
1 Address with City/Street
2 PO Box Address
3 Major Customer Postal Code
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
X Yes
NULL No
XNOMESS IS-M: Indicator - Do Not Perform Output Determination XNOMESS CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
PRIVACY_STATUS IS-M: Status of Address As Regards Data Protection ADDRESS_PRIVACY_STATUS CHAR 1 0
NULL No Response from Customer
Y Consent from Customer
N Refusal from Customer
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 LAND1 TJS43 IS-M: Abbreviations for Secondary Address Texts LAND1
JGTSADR ADDRSECABBREV JGTSADR ADDRSECABBREV TJS43 IS-M: Abbreviations for Secondary Address Texts ADDRSECABBREV
JGTSADR ALIASLFDNR JGTSADR ALIASLFDNR JSTALIAS IS-M: Alias Table for Streets ALIASLFDNR
JGTSADR ANRED JGTSADR MANDT TJG43 IS-M: Form-of-Address Key MANDT
JGTSADR ANRED JGTSADR ANRED TJG43 IS-M: Form-of-Address Key JANRED
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 CITYC T005G City CITYC
JGTSADR CITYC JGTSADR MANDT T005G City MANDT
JGTSADR CITYC JGTSADR LAND1 T005G City LAND1
JGTSADR CITYC JGTSADR REGIO T005G City REGIO
JGTSADR COUNC JGTSADR LAND1 T005E County LAND1
JGTSADR COUNC JGTSADR REGIO T005E County REGIO
JGTSADR COUNC JGTSADR COUNC T005E County COUNC
JGTSADR COUNC JGTSADR MANDT T005E County MANDT
JGTSADR GPHERK JGTSADR GPHERK TJG41 IS-M/SD: Business Partner Origin GPHERK
JGTSADR GPHERK JGTSADR MANDT TJG41 IS-M/SD: Business Partner Origin MANDT
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 HH_REF JGTHH IS-M: Household Business Partner PARTNER
JGTSADR HH_REF JGTSADR MANDT JGTHH IS-M: Household Business Partner CLIENT
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 MANDT T005 Countries MANDT
JGTSADR LAND1 JGTSADR LAND1 T005 Countries LAND1
JGTSADR MANDT JGTSADR MANDT T000 Clients MANDT
JGTSADR NAMZU 'Z' T535N Name affixes ART
JGTSADR NAMZU JGTSADR NAMZU T535N Name affixes TITEL
JGTSADR NAMZU JGTSADR MANDT T535N Name affixes MANDT
JGTSADR NIELS JGTSADR NIELS TNLS Nielsen ID NIELS
JGTSADR NIELS JGTSADR MANDT TNLS Nielsen ID MANDT
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 POSNR_REF JKAP Sales Order - Item Data POSNR
JGTSADR POSNR_REF JGTSADR MANDT JKAP Sales Order - Item Data MANDT
JGTSADR POSNR_REF JGTSADR VBELN_REF JKAP Sales Order - Item Data VBELN
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 MANDT T005S Taxes: Region (Province) Key MANDT
JGTSADR REGIO JGTSADR LAND1 T005S Taxes: Region (Province) Key LAND1
JGTSADR REGIO JGTSADR REGIO T005S Taxes: Region (Province) Key BLAND
JGTSADR SPRAS JGTSADR SPRAS T002 Language Keys (Component BC-I18) SPRAS
JGTSADR TITEL JGTSADR MANDT T535N Name affixes MANDT
JGTSADR TITEL 'T' T535N Name affixes ART
JGTSADR TITEL JGTSADR TITEL T535N Name affixes TITEL
JGTSADR TXJCD JGTSADR MANDT TTXJ Check Table for Tax Jurisdiction MANDT
JGTSADR TXJCD T005 KALSM TTXJ Check Table for Tax Jurisdiction KALSM
JGTSADR TXJCD JGTSADR TXJCD TTXJ Check Table for Tax Jurisdiction TXJCD
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