SAP RMSTS_XCL_RANGE Range in an Excel Table Table data and field list

RMSTS_XCL_RANGE 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 "Range in an Excel Table" 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_RMSTS_XCL_RANGE TYPE RMSTS_XCL_RANGE.

The RMSTS_XCL_RANGE table consists of various fields, each holding specific information or linking keys about Range in an Excel Table data available in SAP. These include RANGE_NAME (Microsoft Excel Table Range), ROW (Y Position of a Cell in the Microsoft Excel Table), COLUMN (X Position of a Cell in the Microsoft Excel Table), ROWS (Y Extension of a Range in the Microsoft Excel Table)... 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. .

RMSTS_XCL_RANGE structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP RMSTS_XCL_RANGE 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 RMSTS_XCL_RANGE 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
SHEET_NAMEWorksheet in Microsoft Excel RMSTE_XCL_SHEET_NAMECHAR31RMSTD_XCL_SHEET_NAME
RANGE_NAMEMicrosoft Excel Table Range RMSTE_XCL_RANGE_NAMECHAR128RMSTD_XCL_RANGE_NAME
ROWY Position of a Cell in the Microsoft Excel Table RMSTE_XCL_ROWINT410RMSTD_XCL_ROW
COLUMNX Position of a Cell in the Microsoft Excel Table RMSTE_XCL_COLUMNINT410RMSTD_XCL_COLUMN
ROWSY Extension of a Range in the Microsoft Excel Table RMSTE_XCL_ROWSINT410RMSTD_XCL_ROWS
COLUMNSX Extension of a Range in the Microsoft Excel Table RMSTE_XCL_COLUMNSINT410RMSTD_XCL_COLUMNS

Key field Non-key field



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

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

How to access SAP table RMSTS_XCL_RANGE

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

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