SAP HANA Articles - Page 55 of 63

WEBI provides you a lot of functions which you can let you perform a wide range of operations ranging from fetching data to doing some complex calculations. You can get the entire list at help.sap.com.For your requirement you can use from the following functions:DocumentOwner()DocumentAuthor()These will not give you directly the name but the id’s which can be used further to get the name.You will have to utilize the User Attribute Management to get your task done. Create a new variable which you need to populate with the user attribute value basically the name.Read More

Yes, you can. You can use the available sorter property available on the List. It lets you specify all the required details. For e.g. −I have specified the employee collection to be sorted on the basis of the name of the employee and specified that the sorting should be in descending manner. It should also consider grouping while sorting the data.

The answer to your question is ‘NO’. It is not possible to map your complex JSON object (object of objects) to a list as it does not make sense.If you want you can have a model or a JSONModel which replicates your object and then you can map it otherwise as you said, you can try to use array if it suits your requirement.

It’s a straight forward way to do the same.You have to go to the transaction RZ11 for the parameter, if the dynamic field checkbox is checked it means that the parameter is a dynamic parameter otherwise it is not a dynamic parameter meaning it is a static parameter.

You need to use the function RSAQ_REMOTE_QUERY_CALL_CATALOG for fetching the list of SQVI queries for a user.

Your question seems to be uncertain. SAP stores data in database and SAP database structure is not conventional and quite complex.  You need to code separately on top of SAP to support export data to outside world and you are free to choose format of your choice.Identify the user specific SQVI queries in ABAP/BAPI. With use of QucikViewer (SQVI), it is a tool for generating reports. SAP Query offers the user a whole range of options for defining reports.Transaction Code: SQVI (Quick Viewer)You can check out this link to know more how to generate report:Create Report by usingsqviRead More

I think there can be a better option to do this. What you can try is fetch only the fields of the table which match the fields present in the table. Do not fetch all the fields of the table but the selected fields.// Here Table refers to the JCo.Table for (int j = 0; j < Table.getNumRows(); j++) {    Table.setRow(j);    Iterator iter = displayField.iterator();    // fetch columns present in the current record    while(iter.hasNext()){       String column = (String) iter.next();       String value = Table.getString(column);       // perform your logic here    } }

There are two operation LT (Less than) and GT (Greater Than) which you can use to perform basic comparisons between two variables.You can frame the logic as per your requirement whether you have a set of variables or a table. If it involves set of variables then you need to do manual comparisons.

There is nothing like standard but you need to specify all required details for a successful connection.XXXX-  H/IP Address/S/Port NumberHere H stands for Host, IP Address is the IP Address, S stands for Port Number

You can indeed achieve it. You just follow the below steps:Step 1 − Define the input parametersDATA:   table_name  TYPE string VALUE  ‘TABLE’, column_name TYPE string VALUE  'COLBNAME', name_value  TYPE string VALUE  'COLVALUE'Step 2 − Create a table type to hold the output results.DATA:   results TYPE REF TO data, TableType TYPE string FIELD-SYMBOLS TYPE STANDARD TABLEStep3 − Create a dynamic query to fill the table