SAP RS_VC_GET_QUERY_VIEW_DATA_FLAT Function Module for Get Data for a Query or View









RS_VC_GET_QUERY_VIEW_DATA_FLAT is a standard rs vc get query view data flat SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used for Get Data for a Query or View processing and below is the pattern details for this FM, showing its interface including any import and export parameters, exceptions etc. there is also a full "cut and paste" ABAP pattern code example, along with implementation ABAP coding, documentation and contribution comments specific to this or related objects.


See here to view full function module documentation and code listing for rs vc get query view data flat FM, simply by entering the name RS_VC_GET_QUERY_VIEW_DATA_FLAT into the relevant SAP transaction such as SE37 or SE38.

Function Group: RS_VC
Program Name: SAPLRS_VC
Main Program: SAPLRS_VC
Appliation area:
Release date: N/A
Mode(Normal, Remote etc): Remote-Enabled
Update:



Function RS_VC_GET_QUERY_VIEW_DATA_FLAT pattern details

In-order to call this FM within your sap programs, simply using the below ABAP pattern details to trigger the function call...or see the full ABAP code listing at the end of this article. You can simply cut and paste this code into your ABAP progrom as it is, including variable declarations.
CALL FUNCTION 'RS_VC_GET_QUERY_VIEW_DATA_FLAT'"Get Data for a Query or View
EXPORTING
* I_INFOPROVIDER = "Technical Name of InfoProvider
* I_QUERY = "Technical Name of Query
* I_VIEW_ID = "Technical Name of a View
* I_MAX_ROWS = -1 "Maximum Number of Lines

TABLES
* I_T_PARAMETER = "Parameter from Web API
* E_T_ATTR_DATA_COLUMNS = "Data for Attributes
* E_T_TEXT_SYMBOLS = "Text Symbols
* E_T_MESSAGES = "Message Collector
* E_T_CELL_DATA = "Data in Dataset Cell
* E_T_AXIS_INFO = "Info on a Dataset Axis
* E_T_AXIS_CHARS = "Characteristics that are directed along an axis
* E_T_AXIS_ATTRS = "Attributes for Axis Characteristics
* E_T_AXIS_DATA_COLUMNS = "Axis Data
* E_T_AXIS_DATA_ROWS = "Axis Data
* E_T_AXIS_DATA_SLICER = "Axis Data
* E_T_ATTR_DATA_ROWS = "Data for Attributes

EXCEPTIONS
NO_APPLICABLE_DATA = 1 INVALID_VARIABLE_VALUES = 2 NO_AUTHORITY = 3 ABORT = 4 INVALID_INPUT = 5 INVALID_VIEW = 6
.



IMPORTING Parameters details for RS_VC_GET_QUERY_VIEW_DATA_FLAT

I_INFOPROVIDER - Technical Name of InfoProvider

Data type: RSINFOPROV
Optional: Yes
Call by Reference: No ( called with pass by value option)

I_QUERY - Technical Name of Query

Data type: RSZCOMPID
Optional: Yes
Call by Reference: No ( called with pass by value option)

I_VIEW_ID - Technical Name of a View

Data type: RSZVIEWID
Optional: Yes
Call by Reference: No ( called with pass by value option)

I_MAX_ROWS - Maximum Number of Lines

Data type: I
Default: -1
Optional: Yes
Call by Reference: No ( called with pass by value option)

TABLES Parameters details for RS_VC_GET_QUERY_VIEW_DATA_FLAT

I_T_PARAMETER - Parameter from Web API

Data type: W3QUERY
Optional: Yes
Call by Reference: Yes

E_T_ATTR_DATA_COLUMNS - Data for Attributes

Data type: RRX_X_ATTR_DATA
Optional: Yes
Call by Reference: Yes

E_T_TEXT_SYMBOLS - Text Symbols

Data type: RRWS_S_TEXT_SYMBOLS
Optional: Yes
Call by Reference: Yes

E_T_MESSAGES - Message Collector

Data type: SMESG
Optional: Yes
Call by Reference: Yes

E_T_CELL_DATA - Data in Dataset Cell

Data type: BAPI6111CD
Optional: Yes
Call by Reference: Yes

E_T_AXIS_INFO - Info on a Dataset Axis

Data type: RRX_AXIS_INFO
Optional: Yes
Call by Reference: Yes

E_T_AXIS_CHARS - Characteristics that are directed along an axis

Data type: RRX_AXIS_CHARS
Optional: Yes
Call by Reference: Yes

E_T_AXIS_ATTRS - Attributes for Axis Characteristics

Data type: RRX_AXIS_ATTRS
Optional: Yes
Call by Reference: Yes

E_T_AXIS_DATA_COLUMNS - Axis Data

Data type: RRX_X_AXIS_DATA
Optional: Yes
Call by Reference: Yes

E_T_AXIS_DATA_ROWS - Axis Data

Data type: RRX_X_AXIS_DATA
Optional: Yes
Call by Reference: Yes

E_T_AXIS_DATA_SLICER - Axis Data

Data type: RRX_X_AXIS_DATA
Optional: Yes
Call by Reference: Yes

E_T_ATTR_DATA_ROWS - Data for Attributes

Data type: RRX_X_ATTR_DATA
Optional: Yes
Call by Reference: Yes

EXCEPTIONS details

NO_APPLICABLE_DATA - No Applicable Data

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

INVALID_VARIABLE_VALUES - Invalid Variable Values

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

NO_AUTHORITY - No Authorization for Data

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

ABORT - Cancellation

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

INVALID_INPUT - Invalid Call Parameters

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

INVALID_VIEW - Invalid View

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

Copy and paste ABAP code example for RS_VC_GET_QUERY_VIEW_DATA_FLAT Function Module

The ABAP code below is a full code listing to execute function module POPUP_TO_CONFIRM including all data declarations. The code uses the original data declarations rather than the latest in-line data DECLARATION SYNTAX but I have included an ABAP code snippet at the end to show how declarations would look using the newer method of declaring data variables on the fly. This will allow you to compare and fully understand the new inline method. Please note some of the newer syntax such as the @DATA is not available until a later 4.70 service pack (SP8), which i why i have stuck to the origianl for this example.

DATA:
lt_i_t_parameter  TYPE STANDARD TABLE OF W3QUERY, "   
lv_i_infoprovider  TYPE RSINFOPROV, "   
lv_no_applicable_data  TYPE RSINFOPROV, "   
lt_e_t_attr_data_columns  TYPE STANDARD TABLE OF RRX_X_ATTR_DATA, "   
lt_e_t_text_symbols  TYPE STANDARD TABLE OF RRWS_S_TEXT_SYMBOLS, "   
lt_e_t_messages  TYPE STANDARD TABLE OF SMESG, "   
lv_i_query  TYPE RSZCOMPID, "   
lt_e_t_cell_data  TYPE STANDARD TABLE OF BAPI6111CD, "   
lv_invalid_variable_values  TYPE BAPI6111CD, "   
lv_i_view_id  TYPE RSZVIEWID, "   
lv_no_authority  TYPE RSZVIEWID, "   
lt_e_t_axis_info  TYPE STANDARD TABLE OF RRX_AXIS_INFO, "   
lv_abort  TYPE RRX_AXIS_INFO, "   
lv_i_max_rows  TYPE I, "   -1
lt_e_t_axis_chars  TYPE STANDARD TABLE OF RRX_AXIS_CHARS, "   
lv_invalid_input  TYPE RRX_AXIS_CHARS, "   
lt_e_t_axis_attrs  TYPE STANDARD TABLE OF RRX_AXIS_ATTRS, "   
lv_invalid_view  TYPE RRX_AXIS_ATTRS, "   
lt_e_t_axis_data_columns  TYPE STANDARD TABLE OF RRX_X_AXIS_DATA, "   
lt_e_t_axis_data_rows  TYPE STANDARD TABLE OF RRX_X_AXIS_DATA, "   
lt_e_t_axis_data_slicer  TYPE STANDARD TABLE OF RRX_X_AXIS_DATA, "   
lt_e_t_attr_data_rows  TYPE STANDARD TABLE OF RRX_X_ATTR_DATA. "   

  CALL FUNCTION 'RS_VC_GET_QUERY_VIEW_DATA_FLAT'  "Get Data for a Query or View
    EXPORTING
         I_INFOPROVIDER = lv_i_infoprovider
         I_QUERY = lv_i_query
         I_VIEW_ID = lv_i_view_id
         I_MAX_ROWS = lv_i_max_rows
    TABLES
         I_T_PARAMETER = lt_i_t_parameter
         E_T_ATTR_DATA_COLUMNS = lt_e_t_attr_data_columns
         E_T_TEXT_SYMBOLS = lt_e_t_text_symbols
         E_T_MESSAGES = lt_e_t_messages
         E_T_CELL_DATA = lt_e_t_cell_data
         E_T_AXIS_INFO = lt_e_t_axis_info
         E_T_AXIS_CHARS = lt_e_t_axis_chars
         E_T_AXIS_ATTRS = lt_e_t_axis_attrs
         E_T_AXIS_DATA_COLUMNS = lt_e_t_axis_data_columns
         E_T_AXIS_DATA_ROWS = lt_e_t_axis_data_rows
         E_T_AXIS_DATA_SLICER = lt_e_t_axis_data_slicer
         E_T_ATTR_DATA_ROWS = lt_e_t_attr_data_rows
    EXCEPTIONS
        NO_APPLICABLE_DATA = 1
        INVALID_VARIABLE_VALUES = 2
        NO_AUTHORITY = 3
        ABORT = 4
        INVALID_INPUT = 5
        INVALID_VIEW = 6
. " RS_VC_GET_QUERY_VIEW_DATA_FLAT




ABAP code using 7.40 inline data declarations to call FM RS_VC_GET_QUERY_VIEW_DATA_FLAT

The below ABAP code uses the newer in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. Please note some of the newer syntax below, such as the @DATA is not available until 4.70 EHP 8.

 
 
 
 
 
 
 
 
 
 
 
 
 
DATA(ld_i_max_rows) = -1.
 
 
 
 
 
 
 
 
 


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!