RNADRGPA SAP (IS-H: Structure with address data for business partners) Structure details
Description: IS-H: Structure with address data for business partners
Structure field list including key, data, relationships and ABAP select examples
RNADRGPA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "IS-H: Structure with address data for business partners" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_RNADRGPA TYPE RNADRGPA.
The RNADRGPA table consists of various fields, each holding specific information or linking keys about IS-H: Structure with address data for business partners data available in SAP. These include MANDT (Client), GPART (IS-H: Business Partner), INSTN (IS-H: Institute Indicator), NAME1 (IS-H: Last Name/ 1st Name).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP RNADRGPA structure 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 | |||
GPART | IS-H: Business Partner | GPARTNER | CHAR | 10 | Assigned to domain | ALPHA | RI_KUNNR | NGP | |
INSTN | IS-H: Institute Indicator | INSTNR | CHAR | 10 | ALPHA | INSTNR | |||
NAME1 | IS-H: Last Name/ 1st Name | GPNAM1 | CHAR | 35 | NAME | NA1 | |||
NAM1S | IS-H: Standardized Last Name of Business Partner | GPNAM1S | CHAR | 35 | NAM35 | ||||
NAME2 | First Name / Second Name | GPNAM2 | CHAR | 35 | NAME | ||||
NAM2S | Standardized First Name/2nd Name of Business Partner | GPNAM2S | CHAR | 35 | NAM35 | ||||
NAME3 | Third Name | GPNAM3 | CHAR | 35 | NAME | ||||
KNAME | IS-H: Short Name of Business Partner | KZNAME | CHAR | 12 | ISH_C12 | ||||
NPKZ | IS-H: Indicator for Natural Person (for Address Control) | NATPERKZ | CHAR | 1 | XFELD | ||||
SPRAS | IS-H: Language of Business Partner | SPRAS_GP | LANG | 1 | T002 | ISOLA | SPRAS | ||
ANRED | IS-H: Form-of-Address Key | RI_ANRDS | CHAR | 2 | Assigned to domain | RI_ANRDS | |||
TITEL | IS-H: Title | RI_TITEL | CHAR | 15 | Assigned to domain | TITEL | |||
NAMZU | IS-H: Name Affix | RI_NAMZU | CHAR | 15 | Assigned to domain | TITEL | |||
VORSW | IS-H: Name Prefix | RI_VORSW | CHAR | 15 | Assigned to domain | TITEL | |||
GSCHL | IS-H: Sex Indicator - Internal | GSCHL | CHAR | 1 | GSCHL | ||||
LAND | IS-H: Country of Business Partner | LAND_GP | CHAR | 3 | T005 | LAND1 | |||
REGIO | IS-H: Region (Federal State, Province, County) | ISH_REGION | CHAR | 3 | T005S | REGIO | |||
PSTLZ | IS-H: Postal Code of Business Partner | PSTLZ_GP | CHAR | 10 | PSTLZ | ||||
PFACH | IS-H: PO Box of Business Partner | PFACH_GP | CHAR | 10 | ISH_PFACH | ||||
PLZPF | IS-H: Postal Code for PO Box of Business Partner | PLZPF_GP | CHAR | 10 | ISH_PLZPF | ||||
ORT | IS-H: City of Business Partner | ORT_GP | CHAR | 25 | TEXT25 | ||||
ORTS | Standardized Name of City where Business Partner is Located | ORTS_GP | CHAR | 30 | ISH30 | ||||
ORT2 | District of Business Partner | ORT2_GP | CHAR | 25 | TEXT25 | ||||
STRAS | IS-H: Street Name and Street Number of Business Partner | STRASSE_GP | CHAR | 30 | STRAS | ||||
TELFN | IS-H: Telephone Number of Business Partner | TELEFON_GP | CHAR | 16 | TEXT16 | ||||
TELFX | Fax Number of Business Partner | TELEFAX_GP | CHAR | 31 | TEXT31 | ||||
TELEX | Telex Number of Business Partner | TELEX_GP | CHAR | 30 | TEXT30 | ||||
KZTXT | IS-H: Comment on Business Partner | TEXT_GPA | CHAR | 50 | TEXT50 | ||||
LGTXT | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
LOEKZ | Deletion Flag/Indicator | RI_LOEKZ | CHAR | 1 | XFELD | ||||
LOUSR | User Who Deleted Record | RI_LOUSR | CHAR | 12 | USNAM | ||||
LODAT | Date of Deletion | RI_LODAT | DATS | 8 | RI_DATUM | ||||
SPVON | Blocking Date From (Entry Block) | ISH_SPERRV | DATS | 8 | RI_DATUM | ||||
SPBIS | IS-H: Blocking Date To (Entry Block To) | ISH_SPERRB | DATS | 8 | RI_DATUM | ||||
ERDAT | IS-H: Date when Record Created | RI_ERDAT | DATS | 8 | RI_DATUM | ||||
ERUSR | IS-H: Name of Employee who Created Record | RI_ERNAM | CHAR | 12 | USNAM | ||||
UPDAT | IS-H: Date of Last Change | RI_UPDAT | DATS | 8 | RI_DATUM | ||||
UPUSR | IS-H: Name of Person who Last Changed Data | RI_UPNAM | CHAR | 12 | USNAM | ||||
GPAR | IS-H: Text Designating the General Business Partner Function | GPART | CHAR | 1 | RI_ROLLE | ||||
PERS | IS-H: Text Designating the EMPLOYEE Function | PERS_D | CHAR | 1 | RI_ROLLE | ||||
KOSTR | IS-H: Text Designating the INSURANCE PROVIDER Function | KOSTR | CHAR | 1 | RI_ROLLE | ||||
DEBIT | Text Designating the CUSTOMER Function | DEBIT | CHAR | 1 | RI_ROLLE | ||||
ARBTG | IS-H: Text Designating the EMPLOYER Function | ARBTG | CHAR | 1 | RI_ROLLE | ||||
KRKHS | IS-H: Text Designating the HOSPITAL Function | KRKHS | CHAR | 1 | RI_ROLLE | ||||
KNAMS | Standard Short Name for Search | KZNAMS | CHAR | 12 | ISH_C12 | ||||
SPTXT | Reason for Blocking | ISH_SPTEXT | CHAR | 50 | TEXT50 | ||||
SPTKZ | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
ADRNR | IS-H: Address Number | ISH_ADRNR | CHAR | 10 | NADR | ALPHA | ISH_ADRNR | ||
ADROB | IS-H: Address Object | ISH_ADROBJ | CHAR | 4 | ISH_ADROBJ | ||||
STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
PNUMB | IS-H: External Partner Number | ISH_PNUMB | CHAR | 15 | CHAR15 | ||||
PARTNER_GUID | IS-H: GUID of Business Partner | ISH_PARTNER_GUID | RAW | 16 | SYSUUID | ||||
TITEL1 | IS-H: Title | RI_TITEL | CHAR | 15 | Assigned to domain | TITEL | |||
MIG_DONE | Indicator Specifying Record Is Migrated to BP Table | ISH_BPMIG_DONE | CHAR | 1 | ISH_BPMIG_DONE | ||||
.INCLU-ADR | 0 | ||||||||
MANDTADR | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
ADRNRADR | IS-H: Address Number | ISH_ADRNR | CHAR | 10 | Assigned to domain | ALPHA | ISH_ADRNR | ||
ADROBADR | IS-H: Address Object | ISH_ADROBJ | CHAR | 4 | ISH_ADROBJ | ||||
PSTLZADR | IS-H: Postal Code of City | ISH_PSTLZO | CHAR | 10 | PSTLZ | ||||
LANDADR | IS-H: Country | ISH_LAND | CHAR | 3 | T005 | LAND1 | |||
REGIOADR | IS-H: Region (Federal State, Province, County) | ISH_REGION | CHAR | 3 | T005S | REGIO | |||
ORTADR | IS-H: City | ISH_CITY1 | CHAR | 40 | TEXT40 | ||||
ORT2ADR | IS-H: District | ISH_CITY2 | CHAR | 40 | TEXT40 | ||||
STRASADR | IS-H: Street | ISH_STRASS | CHAR | 40 | TEXT40 | ||||
STRAZADR | IS-H: Other Designation Qualifying the Address | ISH_STRASZ | CHAR | 40 | TEXT40 | ||||
EINZGADR | IS-H: Geographical Area | EINZGEBIET | CHAR | 9 | EINZGEBIET | ||||
PSTLPADR | IS-H: Postal Code of P.O. Box | ISH_PSTLZP | CHAR | 10 | PSTLZ | ||||
PFACHADR | IS-H: Post Office Box | ISH_POBOX | CHAR | 10 | ISH_PFACH | ||||
LANPFADR | Country of Post Office Box | ISH_LANDPB | CHAR | 3 | T005 | LAND1 | |||
ORTPFADR | IS-H: PO Box City | ISH_CITYPB | CHAR | 40 | TEXT40 | ||||
PSTLFADR | IS-H: Postal Code of Company (for Major Accounts) | ISH_PSTLZF | CHAR | 10 | PSTLZ | ||||
TELNRADR | IS-H: Telephone Number | ISH_TELNR | CHAR | 30 | CHAR30 | ||||
TELXTADR | Telephone Number - Extension | ISH_TELEXT | CHAR | 10 | CHAR10 | ||||
FAXNRADR | Fax Number | ISH_FAXNR | CHAR | 30 | CHAR30 | ||||
FAXXTADR | IS-H: Fax Number - Extension | ISH_FAXEXT | CHAR | 10 | CHAR10 | ||||
TEXNRADR | IS-H: Telex Number | ISH_TELETX | CHAR | 30 | TEXT30 | ||||
BUILDADR | IS-H: Block/House | ISH_BUILD | CHAR | 10 | TEXT10 | ||||
FLOORADR | IS-H: Block/House Level | ISH_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOMADR | IS-H: Unit Number | ISH_ROOM | CHAR | 10 | TEXT10 | ||||
STORTADR | Standardized City Name | ISH_STCITY | CHAR | 40 | CHAR40 | ||||
STOTTADR | Standardized District | ISH_STCIT2 | CHAR | 40 | CHAR40 | ||||
STSTRADR | Standardized Street | ISH_STSTR | CHAR | 40 | CHAR40 | ||||
STSTZADR | IS-H: Standardized Street Supplement | ISH_STSTRZ | CHAR | 40 | CHAR40 | ||||
STORPADR | Standardized City Name of P.O. Box | ISH_STCITP | CHAR | 40 | CHAR40 | ||||
TELKZADR | IS-H: Indicator that More Tel. Nos. Exist for Address | ISH_WTELKZ | CHAR | 1 | XFELD | ||||
EMAILADR | IS-H: Internet Mail (SMTP) Address | ISH_SMTPADR | CHAR | 241 | SXIDN | AD_SMTPADR |
Key field | Non-key field |
How do I retrieve data from SAP structure RNADRGPA using ABAP code?
As RNADRGPA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on RNADRGPA as there is no data to select.How to access SAP table RNADRGPA
Within an ECC or HANA version of SAP you can also view further information about RNADRGPA 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