SAP RSD_TNAMES_GET_FOR_CUBE Function Module for BW Namespace: Gets All Table/View Names for InfoCube
RSD_TNAMES_GET_FOR_CUBE is a standard rsd tnames get for cube SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used for BW Namespace: Gets All Table/View Names for InfoCube 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 rsd tnames get for cube FM, simply by entering the name RSD_TNAMES_GET_FOR_CUBE into the relevant SAP transaction such as SE37 or SE38.
Function Group: RSDN_CUBE
Program Name: SAPLRSDN_CUBE
Main Program: SAPLRSDN_CUBE
Appliation area: B
Release date: N/A
Mode(Normal, Remote etc): Normal Function Module
Update:
Function RSD_TNAMES_GET_FOR_CUBE 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 'RSD_TNAMES_GET_FOR_CUBE'"BW Namespace: Gets All Table/View Names for InfoCube.
EXPORTING
I_INFOCUBE = "InfoCube
IMPORTING
E_FACTTAB = "Name of Fact Table
E_VIEWNAVATR = "Name of Structure (Only Navigation Attributes)
E_VIEWIIOBJNM = "Name of Structure (Only InfoObjects with InfoObject Names)
E_VIEWTIOBJNM = "Name of Structure (All Objects with InfoObject Names)
E_VIEWTIOBJNM2 = "Name of Structure (All Objects with InfoObject Names) (2)
E_VIEWHIOBJNM = "Name of Structure (All InfoObjects, Navigation Attributes, and Hierarchies)
E_VIEW_COMP_DELTA = "Summarization: Delta Data Records
E_VIEW_COMP_NCUM = "Summarization: Reference Points
E_VIEW_ELIM_NULL = "Elimination of Zero Data Records
E_FACTTAB_CNV = "Temp. Fact Table (for Conversion)
E_FACTVIEW = "Name of View for Fact Table
E_COMPTAB = "Name of Compressed Fact Table
E_COMPTAB_CNV = "Temp. Compressed Fact Table (Conversion)
E_STAGETAB = "Name of Staging Table
E_NCUMVALTAB = "Name of Validity Table for Non-Cumulative
E_VIEWTOTAL = "Name of Structure of All Objects
E_VIEWIOBJ = "Name of Structure (Only InfoObjects)
EXCEPTIONS
NAME_ERROR = 1
IMPORTING Parameters details for RSD_TNAMES_GET_FOR_CUBE
I_INFOCUBE - InfoCube
Data type: RSD_INFOCUBEOptional: No
Call by Reference: No ( called with pass by value option)
EXPORTING Parameters details for RSD_TNAMES_GET_FOR_CUBE
E_FACTTAB - Name of Fact Table
Data type: RSD_S_CUBE-FACTTABOptional: No
Call by Reference: Yes
E_VIEWNAVATR - Name of Structure (Only Navigation Attributes)
Data type: RSD_S_CUBE-VIEWNAVATROptional: No
Call by Reference: Yes
E_VIEWIIOBJNM - Name of Structure (Only InfoObjects with InfoObject Names)
Data type: RSD_S_CUBE-VIEWIIOBJNMOptional: No
Call by Reference: Yes
E_VIEWTIOBJNM - Name of Structure (All Objects with InfoObject Names)
Data type: RSD_S_CUBE-VIEWTIOBJNMOptional: No
Call by Reference: Yes
E_VIEWTIOBJNM2 - Name of Structure (All Objects with InfoObject Names) (2)
Data type: RSD_S_CUBE-VIEWTIOBJNM2Optional: No
Call by Reference: Yes
E_VIEWHIOBJNM - Name of Structure (All InfoObjects, Navigation Attributes, and Hierarchies)
Data type: RSD_S_CUBE-VIEWHIOBJNMOptional: No
Call by Reference: Yes
E_VIEW_COMP_DELTA - Summarization: Delta Data Records
Data type: TABNAMEOptional: No
Call by Reference: Yes
E_VIEW_COMP_NCUM - Summarization: Reference Points
Data type: TABNAMEOptional: No
Call by Reference: Yes
E_VIEW_ELIM_NULL - Elimination of Zero Data Records
Data type: TABNAMEOptional: No
Call by Reference: Yes
E_FACTTAB_CNV - Temp. Fact Table (for Conversion)
Data type: RSD_S_CUBE-FACTTABOptional: No
Call by Reference: Yes
E_FACTVIEW - Name of View for Fact Table
Data type: RSD_S_CUBE-FACTVIEWOptional: No
Call by Reference: Yes
E_COMPTAB - Name of Compressed Fact Table
Data type: RSD_S_CUBE-COMPTABOptional: No
Call by Reference: Yes
E_COMPTAB_CNV - Temp. Compressed Fact Table (Conversion)
Data type: RSD_S_CUBE-COMPTABOptional: No
Call by Reference: Yes
E_STAGETAB - Name of Staging Table
Data type: RSD_S_CUBE-FACTTABOptional: No
Call by Reference: Yes
E_NCUMVALTAB - Name of Validity Table for Non-Cumulative
Data type: RSD_S_CUBE-NCUMVALTABOptional: No
Call by Reference: Yes
E_VIEWTOTAL - Name of Structure of All Objects
Data type: RSD_S_CUBE-VIEWTOTALOptional: No
Call by Reference: Yes
E_VIEWIOBJ - Name of Structure (Only InfoObjects)
Data type: RSD_S_CUBE-VIEWIOBJOptional: No
Call by Reference: Yes
EXCEPTIONS details
NAME_ERROR - InfoCube name is blank or too long
Data type:Optional: No
Call by Reference: No ( called with pass by value option)
Copy and paste ABAP code example for RSD_TNAMES_GET_FOR_CUBE 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: | ||||
lv_e_facttab | TYPE RSD_S_CUBE-FACTTAB, " | |||
lv_i_infocube | TYPE RSD_INFOCUBE, " | |||
lv_name_error | TYPE RSD_INFOCUBE, " | |||
lv_e_viewnavatr | TYPE RSD_S_CUBE-VIEWNAVATR, " | |||
lv_e_viewiiobjnm | TYPE RSD_S_CUBE-VIEWIIOBJNM, " | |||
lv_e_viewtiobjnm | TYPE RSD_S_CUBE-VIEWTIOBJNM, " | |||
lv_e_viewtiobjnm2 | TYPE RSD_S_CUBE-VIEWTIOBJNM2, " | |||
lv_e_viewhiobjnm | TYPE RSD_S_CUBE-VIEWHIOBJNM, " | |||
lv_e_view_comp_delta | TYPE TABNAME, " | |||
lv_e_view_comp_ncum | TYPE TABNAME, " | |||
lv_e_view_elim_null | TYPE TABNAME, " | |||
lv_e_facttab_cnv | TYPE RSD_S_CUBE-FACTTAB, " | |||
lv_e_factview | TYPE RSD_S_CUBE-FACTVIEW, " | |||
lv_e_comptab | TYPE RSD_S_CUBE-COMPTAB, " | |||
lv_e_comptab_cnv | TYPE RSD_S_CUBE-COMPTAB, " | |||
lv_e_stagetab | TYPE RSD_S_CUBE-FACTTAB, " | |||
lv_e_ncumvaltab | TYPE RSD_S_CUBE-NCUMVALTAB, " | |||
lv_e_viewtotal | TYPE RSD_S_CUBE-VIEWTOTAL, " | |||
lv_e_viewiobj | TYPE RSD_S_CUBE-VIEWIOBJ. " |
  CALL FUNCTION 'RSD_TNAMES_GET_FOR_CUBE' "BW Namespace: Gets All Table/View Names for InfoCube |
EXPORTING | ||
I_INFOCUBE | = lv_i_infocube | |
IMPORTING | ||
E_FACTTAB | = lv_e_facttab | |
E_VIEWNAVATR | = lv_e_viewnavatr | |
E_VIEWIIOBJNM | = lv_e_viewiiobjnm | |
E_VIEWTIOBJNM | = lv_e_viewtiobjnm | |
E_VIEWTIOBJNM2 | = lv_e_viewtiobjnm2 | |
E_VIEWHIOBJNM | = lv_e_viewhiobjnm | |
E_VIEW_COMP_DELTA | = lv_e_view_comp_delta | |
E_VIEW_COMP_NCUM | = lv_e_view_comp_ncum | |
E_VIEW_ELIM_NULL | = lv_e_view_elim_null | |
E_FACTTAB_CNV | = lv_e_facttab_cnv | |
E_FACTVIEW | = lv_e_factview | |
E_COMPTAB | = lv_e_comptab | |
E_COMPTAB_CNV | = lv_e_comptab_cnv | |
E_STAGETAB | = lv_e_stagetab | |
E_NCUMVALTAB | = lv_e_ncumvaltab | |
E_VIEWTOTAL | = lv_e_viewtotal | |
E_VIEWIOBJ | = lv_e_viewiobj | |
EXCEPTIONS | ||
NAME_ERROR = 1 | ||
. " RSD_TNAMES_GET_FOR_CUBE |
ABAP code using 7.40 inline data declarations to call FM RSD_TNAMES_GET_FOR_CUBE
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."SELECT single FACTTAB FROM RSD_S_CUBE INTO @DATA(ld_e_facttab). | ||||
"SELECT single VIEWNAVATR FROM RSD_S_CUBE INTO @DATA(ld_e_viewnavatr). | ||||
"SELECT single VIEWIIOBJNM FROM RSD_S_CUBE INTO @DATA(ld_e_viewiiobjnm). | ||||
"SELECT single VIEWTIOBJNM FROM RSD_S_CUBE INTO @DATA(ld_e_viewtiobjnm). | ||||
"SELECT single VIEWTIOBJNM2 FROM RSD_S_CUBE INTO @DATA(ld_e_viewtiobjnm2). | ||||
"SELECT single VIEWHIOBJNM FROM RSD_S_CUBE INTO @DATA(ld_e_viewhiobjnm). | ||||
"SELECT single FACTTAB FROM RSD_S_CUBE INTO @DATA(ld_e_facttab_cnv). | ||||
"SELECT single FACTVIEW FROM RSD_S_CUBE INTO @DATA(ld_e_factview). | ||||
"SELECT single COMPTAB FROM RSD_S_CUBE INTO @DATA(ld_e_comptab). | ||||
"SELECT single COMPTAB FROM RSD_S_CUBE INTO @DATA(ld_e_comptab_cnv). | ||||
"SELECT single FACTTAB FROM RSD_S_CUBE INTO @DATA(ld_e_stagetab). | ||||
"SELECT single NCUMVALTAB FROM RSD_S_CUBE INTO @DATA(ld_e_ncumvaltab). | ||||
"SELECT single VIEWTOTAL FROM RSD_S_CUBE INTO @DATA(ld_e_viewtotal). | ||||
"SELECT single VIEWIOBJ FROM RSD_S_CUBE INTO @DATA(ld_e_viewiobj). | ||||
Search for further information about these or an SAP related objects