SAP RELATION_ADDRESS Data for a Relationship Address Table data and field list

RELATION_ADDRESS 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 "Data for a Relationship Address" 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_RELATION_ADDRESS TYPE RELATION_ADDRESS.

The RELATION_ADDRESS table consists of various fields, each holding specific information or linking keys about Data for a Relationship Address data available in SAP. These include TASK_CODE (Change Indicator Role (I = Insert, D=Delete etc. )), ADDRESS_DATA_KEY (), CONTROLLER (), ADDRESS_KEY_GUID ()... 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. .

RELATION_ADDRESS structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP RELATION_ADDRESS structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the RELATION_ADDRESS table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CONTROLLER 0
TASK_CODEChange Indicator Role (I = Insert, D=Delete etc. ) PARTY_TASK_CODECHAR1
ADDRESS_DATA_KEY 0
CONTROLLER 0
ADDRESS_KEY_GUID 0
ADDRESS_DATA 0
CONTROLLER 0
POSTAL_ADDRESS 0
CONTROLLER 0
POSTAL_ADDRESS_DATA 0
CONTROLLER 0
STANDARD_ADDRESS_INDICATOR 0
CONTROLLER 0
UPDATE_INDICATORIndicator whether an element carries an updated value or not UPDATE_INDICATORCHAR5
VALUE 0
BUILDING_ID 0
CONTROLLER 0
UPDATE_INDICATORIndicator whether an element carries an updated value or not UPDATE_INDICATORCHAR5
VALUEBuilding (Number or Code) PARTY_RELATION_BUILDING_IDCONCHAR10
FLOOR_ID 0
CONTROLLER 0
UPDATE_INDICATORIndicator whether an element carries an updated value or not UPDATE_INDICATORCHAR5
VALUEFloor number in building PARTY_FLOOR_IDCONTENTCHAR10
ROOM_ID 0
CONTROLLER 0
UPDATE_INDICATORIndicator whether an element carries an updated value or not UPDATE_INDICATORCHAR5
VALUERoom or Appartment Number in building PARTY_ROOM_IDCONTENTCHAR10
CORRESPONDANCE_SHORT_NAME 0
CONTROLLER 0
UPDATE_INDICATORIndicator whether an element carries an updated value or not UPDATE_INDICATORCHAR5
VALUEShort name for correspondence PARTY_SHORT_NAME_CONTENTCHAR10
INHOUSE_MAIL_ID 0
CONTROLLER 0
UPDATE_INDICATORIndicator whether an element carries an updated value or not UPDATE_INDICATORCHAR5
VALUEInhouse mail postal code PARTY_INHOUSE_MAIL_IDCONTENTCHAR10
COMMUNICATION_TYPE_CODE 0
CONTROLLER 0
UPDATE_INDICATORIndicator whether an element carries an updated value or not UPDATE_INDICATORCHAR5
VALUECommunication Method (Key, Business Address Service) PARTY_COMMUNICATION_TYPE_CODECHAR3
DEPARTMENT_NAME 0
CONTROLLER 0
UPDATE_INDICATORIndicator whether an element carries an updated value or not UPDATE_INDICATORCHAR5
VALUEObject name within business partner data PARTY_NAME_CONTENTCHAR40
FUNCTIONAL_TITLE_NAME 0
CONTROLLER 0
UPDATE_INDICATORIndicator whether an element carries an updated value or not UPDATE_INDICATORCHAR5
VALUEObject name within business partner data PARTY_NAME_CONTENTCHAR40
COMMUNICATION_INFORMATION 0
CONTROLLER 0
TELEPHONE_INFORMATION 0
CONTROLLER 0
COMPLETE_DATA_INDICATOR 0
TELEPHONE 0
FACSIMILE_INFORMATION 0
CONTROLLER 0
COMPLETE_DATA_INDICATOR 0
FACSIMILE 0
TELETEX_INFORMATION 0
CONTROLLER 0
COMPLETE_DATA_INDICATOR 0
TELETEX 0
TELEX_INFORMATION 0
CONTROLLER 0
COMPLETE_DATA_INDICATOR 0
TELEX 0
SMTPINFORMATION 0
CONTROLLER 0
COMPLETE_DATA_INDICATOR 0
SMTP 0
RMLINFORMATION 0
CONTROLLER 0
COMPLETE_DATA_INDICATOR 0
RML 0
X400INFORMATION 0
CONTROLLER 0
COMPLETE_DATA_INDICATOR 0
X400 0
RFCINFORMATION 0
CONTROLLER 0
COMPLETE_DATA_INDICATOR 0
RFC 0
PRINTER_INFORMATION 0
CONTROLLER 0
COMPLETE_DATA_INDICATOR 0
PRINTER 0
SSFINFORMATION 0
CONTROLLER 0
COMPLETE_DATA_INDICATOR 0
SSF 0
URIINFORMATION 0
CONTROLLER 0
COMPLETE_DATA_INDICATOR 0
URI 0
PAGER_INFORMATION 0
CONTROLLER 0
COMPLETE_DATA_INDICATOR 0
PAGER 0
TIME_DEPENDENTPartnerTimeDependent PARTNER_TIME_DEPENDENTCHAR1
ADDRESS_VERSION_INFORMATION 0
CONTROLLER 0
COMPLETE_DATA_INDICATOR 0
ADDRESS_VERSION 0

Key field Non-key field



How do I retrieve data from SAP structure RELATION_ADDRESS using ABAP code?

As RELATION_ADDRESS 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 RELATION_ADDRESS as there is no data to select.

How to access SAP table RELATION_ADDRESS

Within an ECC or HANA version of SAP you can also view further information about RELATION_ADDRESS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).