JGTSADR SAP (IS-M: Extended Address Management) Table details
Dictionary Type: Table
Description: IS-M: Extended Address Management
Description: IS-M: Extended Address Management
Table field list including key, data, relationships and ABAP select examples
JGTSADR is a standard SAP Table which is used to store IS-M: Extended Address Management data and is available within R/3 SAP systems depending on the version and release level.
The JGTSADR table consists of various fields, each holding specific information or linking keys about IS-M: Extended Address Management data available in SAP. These include ADRNR (IS-M: Address Number), UVADR_ST (IS-M: Coding Status of Address), UVADR_PF (IS-M: Coding Status of Address), UVADR_GK (IS-M: Coding Status of Address).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
SAP JGTSADR table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
ADRNR | IS-M: Address Number | JADRNR | CHAR | 10 | ALPHA | JADRNR | |||
UVADR_ST | IS-M: Coding Status of Address | UVADR_AD | CHAR | 1 | UVADR_AD | ||||
UVADR_PF | IS-M: Coding Status of Address | UVADR_AD | CHAR | 1 | UVADR_AD | ||||
UVADR_GK | IS-M: Coding Status of Address | UVADR_AD | CHAR | 1 | UVADR_AD | ||||
HERK | IS-M: Use of Address | HERK | CHAR | 1 | HERK | ||||
XADRLOE | IS-M: Deletion Flag for Address | XLOES | CHAR | 1 | XFELD | ||||
ERFUSER | Created By | ERFUSER | CHAR | 12 | USNAM | ||||
ERFDATE | Created On | ERFDATE | DATS | 8 | DATUM | ||||
ERFTIME | Time Created | ERFTIME | TIMS | 6 | UZEIT | ||||
AENUSER | Last Changed By | AENUSER | CHAR | 12 | USNAM | ||||
AENDATE | Date of Last Change | AENDATE | DATS | 8 | DATUM | ||||
AENTIME | Time of Last Change | AENTIME | TIMS | 6 | UZEIT | ||||
ANRED | Form of Address Key | JANRED | CHAR | 2 | TJG43 | ALPHA | JANRED | JGA | |
NAME1 | IS-M: Business Partner Name | NAME1_ISP | CHAR | 35 | NAME | ||||
NAME2 | IS-M: First Name of Business Partner | NAME2_ISP | CHAR | 35 | NAME | ||||
NAME3 | IS-M: Further Name Field for Business Partner | NAME3_ISP | CHAR | 35 | NAME | ||||
NAME4 | IS-M: Further Name Field for Business Partner | NAME4_ISP | CHAR | 35 | NAME | ||||
TITEL | IS-M: Title | TITEL_ISP | CHAR | 15 | T535N | TITEL | |||
NAMZU | IS-M: Name Affix | NAMZU_ISP | CHAR | 15 | T535N | TITEL | |||
VORSW | IS-M: Name Prefix | VORSW_ISP | CHAR | 15 | T535N | TITEL | |||
PSTLZ | IS-M: Postal Code | PLZ_ISP | CHAR | 10 | PSTLZ | ||||
PSTLZ_ADDON | IS-M: Extension to 5-Character ZIP Code | PSTLZ_ADDON | CHAR | 4 | CHAR4 | ||||
ORT01 | IS-M: City | ORT01_ISP | CHAR | 35 | TEXT35 | ||||
ORT02 | IS-M: City District | ORT02_ISP | CHAR | 35 | TEXT35 | ||||
PSTL2 | IS-M: Postal Code for PO Box | PLZPF | CHAR | 10 | PSTLZ | ||||
PSTL2_ADDON | IS-M: Extension to 5-Character ZIP Code (PO Box) | PSTL2_ADDON | CHAR | 4 | CHAR4 | ||||
PSTL3 | IS-M: Company Postal Code | PSTL3 | CHAR | 10 | PSTLZ | ||||
PSTL3_ADDON | IS-M: Extension to 5-Character ZIP Code (Company) | PSTL3_ADDON | CHAR | 4 | CHAR4 | ||||
PFACH | IS-M: Post Office Box | PFACH_ISP | CHAR | 10 | ALPHA | PFACH_ISP | |||
ORTPF | IS-M: City for PO Box | ORTPF | CHAR | 35 | TEXT35 | ||||
STRAS | Street Name | STRAS_ISP | CHAR | 35 | TEXT35 | ||||
HAUSN | IS-M: House Number | HSNMR1 | CHAR | 10 | HAUSNUMMER | ||||
HSNMR2 | IS-M: House Number Affix | HSNMR2 | CHAR | 8 | CHAR8 | ||||
ADRZUS2 | Classification Using a Further Address Affix | ADRZUS2 | CHAR | 6 | ADRZUS | ||||
STOCK | Floor | STOCK | CHAR | 6 | STOCK | ||||
LAND1 | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
PREDIRECTIONAL | Directional for Street Name | DIRECTIONAL | CHAR | 10 | TJS41 | DIRECTIONAL | |||
POSTDIRECTIONAL | Directional for Street Name | DIRECTIONAL | CHAR | 10 | TJS41 | DIRECTIONAL | |||
ADDRSECABBREV | IS-M: Secondary Address Text | ADDRSECABBREV | CHAR | 4 | TJS43 | ADDRSECABBREV | |||
ADDRSECNUMBER | IS-M: Secondary Address Number | ADDRSECNUMBER | CHAR | 8 | ALPHA | ADDRSECNUMBER | |||
STREET2 | IS-M: Second street line | STREET2_ISM | CHAR | 35 | TEXT35 | ||||
ALIASNAME | IS-M: Alias Text (Street Name + Suffix) | ALIASNAME | CHAR | 50 | TEXT50 | ||||
ALIASPREDIRECTN | Directional for Street Name | DIRECTIONAL | CHAR | 10 | Assigned to domain | DIRECTIONAL | |||
ALIASPOSTDIRECTN | Directional for Street Name | DIRECTIONAL | CHAR | 10 | Assigned to domain | DIRECTIONAL | |||
ALIASDELADDRLOW | IS-M: Primary House Number (Lower Limit) | ADDRPRIMLOW | CHAR | 10 | HAUSNUMMER | ||||
ALIASDELADDRHIGH | IS-M: Primary House Number (Upper Limit) | ADDRPRIMHIGH | CHAR | 10 | HAUSNUMMER | ||||
ALIASDELODDEVEN | IS-M: Indicator - Even/Odd/All | ODDEVENCODE | CHAR | 1 | ODDEVENCODE | ||||
SUCHFELDALIAS | Search field for accessing postal structures w/o matchcode | SUCHFELD | CHAR | 40 | CHAR40 | ||||
POSTEINORT | IS-M: City Number (Unique) | JALORT | CHAR | 8 | JSTORTPRO | ALPHA | ALORT | JSO | |
ERSTADR | IS-M: Address Proposal for Alternatives | ERSTADR | CHAR | 1 | ERSTADR | ||||
POSTEINSTR | IS-M: Street Number | STRASSENNR | CHAR | 10 | JSTSTRPRO | ALPHA | STRASSENNR | JSS | |
PEINORTPF | IS-M: Postal Unit of City for PO Box | ALORT2 | CHAR | 8 | JSTORTPRO | ALPHA | ALORT | ||
LOCCO | City Coordinates | LOCCO | CHAR | 10 | LOCCO | ||||
NIELS | Nielsen ID | NIELS | CHAR | 2 | TNLS | NIELS | |||
COUNC | County Code | COUNC | CHAR | 3 | T005E | COUNC | |||
CITYC | City Code | CITYC | CHAR | 4 | T005G | CITYC | |||
RPMKR | Regional Market | RPMKR | CHAR | 5 | RPMKR | ||||
SORTL | Sort field | SORTL | CHAR | 10 | CHAR10 | ||||
SORT2 | IS-M: Sort Field 2 (for Internal Use) | SORTL2 | CHAR | 20 | CHAR20 | ||||
SORT3 | IS-M: Sort field 3 (internal) | SORTL3 | CHAR | 30 | TEXT30 | ||||
BU_SORT1 | Search term 1 for business partner | BU_SORT1 | CHAR | 20 | BU_SORT1 | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
TELFP | IS-M: Home Phone Number | TELFP | CHAR | 16 | TEXT16 | ||||
TELFD | IS-M: Telephone Number at Work | TELFD | CHAR | 16 | TEXT16 | ||||
TELW1 | IS-M: Additional Telephone Number | TELWT | CHAR | 16 | TEXT16 | ||||
TELW2 | IS-M: Additional Telephone Number | TELWT | CHAR | 16 | TEXT16 | ||||
TELW3 | IS-M: Additional Telephone Number | TELWT | CHAR | 16 | TEXT16 | ||||
TELW4 | IS-M: Mobile Phone Number | TELWF | CHAR | 20 | TEXT20 | ||||
TELW5 | IS-M: Mobile Phone Number | TELWF | CHAR | 20 | TEXT20 | ||||
TELFX | Fax Number | TELFX | CHAR | 31 | TEXT31 | ||||
TELF1 | IS-M: Additional Fax Number | TELFT | CHAR | 16 | TEXT16 | ||||
TELF2 | IS-M: Additional Fax Number | TELFT | CHAR | 16 | TEXT16 | ||||
TELF3 | IS-M: Additional Fax Number | TELFT | CHAR | 16 | TEXT16 | ||||
TELTX | Teletex number | TELTX | CHAR | 30 | TEXT30 | ||||
TELX1 | Telex number | TELX1 | CHAR | 30 | TEXT30 | ||||
TELBX | Telebox number | TELBX | CHAR | 15 | TEXT15 | ||||
DATLT | Data communication line no. | DATLT | CHAR | 14 | TEXT14 | ||||
STDKO | Default communications service | STDKO_D | CHAR | 1 | CHAR1 | ||||
GPHERK | IS-M: Business Partner Origin | GPHERK | CHAR | 2 | TJG41 | ALPHA | GPHERK | ||
GP_REF | IS-M: Business Partner Key | GPNR | CHAR | 10 | JGTGPNR | ALPHA | GPNR | JGP | MJG0 |
VBELN_REF | IS-M/SD: Publishing Sales Order | AVNR | CHAR | 10 | JKAK | ALPHA | AVNR | JK1 | MJK1 |
POSNR_REF | Sales Order Item | APNR | NUMC | 6 | JKAP | APNR | |||
JPARVW_REF | IS-M: Business Partner Role | JPARVW | CHAR | 2 | TJG39 | PARVW | JPARVW | JGR | |
BEABLS_REF | IS-M: Unloading Point | BEABLST | CHAR | 10 | JRTBEABST | ALPHA | BEABLST | BAS | MJV2 |
TELFP_COD | IS-M: Home Phone Number | TELFP | CHAR | 16 | TEXT16 | ||||
TELFD_COD | IS-M: Telephone Number at Work | TELFD | CHAR | 16 | TEXT16 | ||||
NAME1_MACO | IS-M: Business Partner Name (Upper Case for Matchcode) | NAME1_ISPM | CHAR | 35 | JYTNF | NAME_MACO | |||
NAME2_MACO | IS-M: Bus.Partner's First Name (Upper Case for Matchcode) | NAME2_ISPM | CHAR | 35 | JYTNF | NAME_MACO | |||
STRAS_MACO | IS-M: Street Name | STRAS_ISPM | CHAR | 35 | JYTNF | STRAS_MACO | |||
ORT01_MACO | IS-M/SD: City Name (Upper Case for Matchcode) | ORT01_ISPM | CHAR | 35 | JYTNF | ORT01_MACO | |||
ISPTELVWP | IS-M: Area Code (Home) | ISPTELVWP | CHAR | 10 | TELN2 | ISPTELVW | |||
ISPTELP | IS-M: Telephone Number | ISPTELP | CHAR | 20 | TELN1 | ISPTEL | |||
ISPTELVWD | IS-M: Area Code - Work | ISPTELVWD | CHAR | 10 | TELN2 | ISPTELVW | |||
ISPTELD | IS-M: Telephone Number | ISPTELD | CHAR | 20 | TELN1 | ISPTEL | |||
ISPHANDY | IS-M: Mobile Phone Number | ISPHANDY | CHAR | 30 | CHAR30 | ||||
ISPEMAIL | IS-M: E-Mail Address | ISPEMAIL | CHAR | 50 | CHAR50LOW | ||||
ISPADRBSND | IS-M/SD: Note for Home Delivery to Ship-to Party | ISPADRBSND | CHAR | 50 | TEXT50 | ||||
TECHNUMZUG | IS-M: Technical Relocation Due to Postal Data Change | TECHNUMZUG | CHAR | 1 | XFELD | ||||
XNOMESS | IS-M: Indicator - Do Not Perform Output Determination | XNOMESS | CHAR | 1 | XFELD | ||||
ALIASLFDNR | IS-M: Sequence Number for Alias Table (Key) | ALIASLFDNR | NUMC | 10 | JSTALIAS | NUMC10 | |||
XNOCARPERMESS | IS-M: No Change of Carrier When Address Changes | XNOCARPERMESS | CHAR | 1 | XFELD | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
ANI_TELNRP | Telephone number for determining caller | AD_TELNRCL | CHAR | 30 | CHAR30 | ||||
ANI_TELNRD | Telephone number for determining caller | AD_TELNRCL | CHAR | 30 | CHAR30 | ||||
ANI_ISPHANDY | Telephone number for determining caller | AD_TELNRCL | CHAR | 30 | CHAR30 | ||||
HH_REF | IS-M: Business Partner Number of Household | GPNR_HH | CHAR | 10 | JGTHH | ALPHA | BU_PARTNER | ||
HH_EXCLUDE | IS-M: Indicator: Exclude Household Assignment | HH_EXCLUDE | CHAR | 1 | XFELD | ||||
PRIVACY_STATUS | IS-M: Status of Address As Regards Data Protection | ADDRESS_PRIVACY_STATUS | CHAR | 1 | ADDRESS_PRIVACY_STATUS | ||||
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_PERSNUM | CDT | ADDRESS |
Key field | Non-key field |
How do I retrieve data from SAP table JGTSADR using ABAP code
The following ABAP code Example will allow you to do a basic selection on JGTSADR to SELECT all data from the tableDATA: WA_JGTSADR TYPE JGTSADR.
SELECT SINGLE *
FROM JGTSADR
INTO CORRESPONDING FIELDS OF WA_JGTSADR
WHERE...
How to access SAP table JGTSADR
Within an ECC or HANA version of SAP you can also view further information about JGTSADR and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects