Sometimes in our requirement we need to read data dynamically based on some condition, like columns, table/ internal table name may changes as per user input. During one such requirement we need replicate se16 like transaction for Fiori application. Here we need to show table and table data based on the table name given in input field.
In this blog I would explain the steps to achieve the same. We will go through the odata creation, logic to collect table config and data and then consume odata service on SAP ui5 application.
Output would be like as below. In input field provide any table name and on submitting, application should load table data.
First of all create 2 entities for collecting table field information and data like below.
Entity sets
Primary entity: DynamicField to contain configuration information of table
And second entity: DynamicData to contain data for the table
Now create a method in DPC class to identify the table name, extract field information and data for table and save this data in entityset.
Here we have written logic to
Fetch table name coming from UI screen
Fetch Table fields
Fetch Table data
And then combine whole data in single entity
Logic to fetch table fields and description
Fetch table data
METHOD get_table_data. DATA : ld_data TYPE REF TO data, ld_where TYPE edpline, lt_where TYPE TABLE OF edpline. FIELD-SYMBOLS: TYPE ANY TABLE, TYPE ANY TABLE, TYPE zcl_zdyn_p1_mpc=>tt_dynamicfield. ASSIGN it_fields->* TO . DATA(ld_search) = me->get_search( it_filter ). CREATE DATA ld_data TYPE TABLE OF (iv_tablename). ASSIGN ld_data->* TO . ASSIGN ld_data->* TO . IF ld_search IS INITIAL. SELECT * FROM (iv_tablename) INTO TABLE . ELSE. LOOP AT ASSIGNING FIELD-SYMBOL(). IF -inttype EQ ‘P’ OR -inttype EQ ‘b’ OR -inttype EQ ‘I’. * ld_where = -abap_typekind && ‘ = ‘ && ld_search . ELSE. ld_where = -abap_typekind && ‘ =’ && | ‘| && ld_search && |’| . APPEND ld_where TO lt_where. SELECT * FROM (iv_tablename) INTO TABLE WHERE (ld_where). ENDIF. CLEAR ld_where. refresh . ENDLOOP. ENDIF. CALL METHOD me->/iwbep/if_mgw_conv_srv_runtime~copy_data_to_ref EXPORTING is_data = CHANGING cr_data = rt_data. ENDMETHOD.
Now we will combine whole data into single entity that is lt_field_data
This field is complex structure which will combine our earlier declared entity types. So we will expose data in nested structure to UI5 application
METHOD process_data. DATA : lt_field_data TYPE STANDARD TABLE OF zcl_zdyn_p1_mpc_ext=>ty_dynamicfielddata, ls_field_data TYPE zcl_zdyn_p1_mpc_ext=>ty_dynamicfielddata, ls_data TYPE LINE OF zcl_zdyn_p1_mpc_ext=>tt_dynamicdata_field, lo_sysuuid TYPE REF TO cl_system_uuid, ld_counter type char2. FIELD-SYMBOLS: TYPE table, TYPE table. ASSIGN it_fields->* TO . LOOP AT ASSIGNING FIELD-SYMBOL(). me->move_corresponding( EXPORTING id_source_data = IMPORTING ed_target_data = ls_field_data ) . ld_counter = ld_counter + 1. ls_field_data-TABNAME16 = ld_tablename. ls_field_data-position = ld_counter. APPEND ls_field_data TO lt_field_data. ENDLOOP. ASSIGN it_data->* TO . CREATE OBJECT lo_sysuuid . ld_counter = 0. LOOP AT ASSIGNING FIELD-SYMBOL(). TRY. DATA(lv_uuid) = lo_sysuuid->if_system_uuid~create_uuid_c32( ). CATCH cx_uuid_error . ENDTRY. LOOP AT lt_field_data ASSIGNING FIELD-SYMBOL(). ASSIGN COMPONENT -abap_typekind OF STRUCTURE TO FIELD-SYMBOL(). ls_data-key = lv_uuid. ls_data-fieldname = -abap_typekind. ls_data-value = . append ls_data to -dataset. ENDLOOP . ENDLOOP. CALL METHOD me->/iwbep/if_mgw_conv_srv_runtime~copy_data_to_ref EXPORTING is_data = lt_field_data CHANGING cr_data = tr_data. ENDMETHOD.
At last when you have finished with data processing call expanded entity set and call the above primary method i.e.
implement get_expanded_entityset and call get_dynamic_field_data
Now if you register and execute the service:
You will get the table structure and data returned in nested structure as below
UI5 application
Create a sapui5 project and connect your odata service to the application
Create tableview.xml as below, create table with basic attributes only
Inside tableview.controller
Load odatamodel
var oModelVariantO1 = new sap.ui.model.odata.ODataModel("/sap/opu/odata/SAP/ZDYN_P1_SRV/", true);
var oJsonModel1 = new sap.ui.model.json.JSONModel();
sap.ui.core.BusyIndicator.show(0);
On click of button or submit event of input field read data from backend as below
fetch table name frominput control and concatenate with url for reading
var url = "DynamicFieldSet?$filter=tablename eq ‘" + this.byId("tablename").getValue() + "‘ &$expand=DataSet";
oModelVariantO1.read(url, {
success: function(oData, response) {
// console.log(oData);
sap.ui.core.BusyIndicator.hide();
that.odata = oData;
that.writedata(that.odata);
},
error: function(err) {
sap.ui.core.BusyIndicator.hide();
}
});
Under function writedata we have received all the results from back end
Get rows and columns separately from results array. Bind rows and columns and then you can see the output in your screen
writedata: function(results) {
var row_array = [];
var array = results.results;
var no_of_rows = results.results[0].DataSet.results;
this.byId("count").setText(no_of_rows.length + ‘ Records’);
no_of_rows.forEach(function(entry1, j) {
var obj = {};
var j_value = j;
array.forEach(function(entry, i) {
var field = results.results[i].DataSet.results[j_value];
var fieldvalue = field.value;
//var fieldname = results.results[i].description;
var fieldname = field.name;
Object.defineProperty(obj, fieldname, {
value: fieldvalue //set data1 and data 2 accordingly
});
});
row_array.push(obj);
});
var jsonmodel = new sap.ui.model.json.JSONModel();
jsonmodel.setData({
rows: row_array,
columns: results.results
});
var oTable = this.getView().byId("tableid");
oTable.setModel(jsonmodel);
oTable.bindColumns("/columns", function(sId, oContext) {
var columnName = oContext.getObject().name;
// var columntemp = oContext.getObject().name;
return new sap.ui.table.Column({
label: columnName,
template: columnName,
sortProperty: columnName,
filterProperty: columnName
});
});
oTable.bindRows("/rows");
});
},
When we get the odata from back end system, we identify the row and column for the output table and bind the rows and column to out put table.
Output Screen
