There are lots of possibilities but a lot depends upon on your exact requirement and needs.One way is that you can go ahead and use Java Connector also known as JCo. JCo is a prevalent option to do similar requirements as of yours. It has a lot of support available online as well.Also, as you said Web service is by default the web standard and can be opted too. SAP functions are readily available and can be tuned effortlessly to be available as web services.

Yes, it is  possible to use a view in Business one client and you can use it too. Please find below a sample format that you should be using to query the view in business one environment −SELECT FROM [dbo].[]I have done the same and it is working for me.

Basically you need to exploit the beforeSend function of JQuery AJAX to sort out your requirement.Here is a basic code snippet −function AddToHeader(xhr) {     var pwd = // get the password;     xhr.setRequestHeader("Authorization", "Basic " + btoa(user + ":" + pwd)); } $.ajax({    type: "GET",    url: ,    dataType: "JSON",    beforeSend: function(xhr) {       AddToHeader (xhr);    } }).done(function(data) { /* do success logic */ }You can add further details to the header as explained in the AddToHeader method.

It’s a very basic operation that you do in database. You can try using DateAdd function available and use the date overload of the function. You need to pass one date as negative so in actual the difference is calculatedSELECT DATEADD(d,-[dateTwo], [dateOne]) AS 'Difference in Dates' FROM [TABLE]Here‘d’ refers to the day.

The simple answer to your question is NO. Because, this is SAP standard behavior and if you want to restrict the number of columns to be returned then it will require you to change the original source code of SAP implementation.The change will be quite exhaustive and it will also mean that you are violating the contract and hence, no support from SAP on any issue encountered later.As you said you are filtering data that means the number of rows will not be huge and hence the number of columns will not have much implication on the performance of the ... Read More

I have not tried it but it does not seem feasible. The reason being if you are planning to use JCo library, you will require a native library but that is still not available for Android environment.You can try an alternative for it. You can create a Web Service either a SOAP or REST which communicates to SAP via JCo. Then, you can use the service to do two way communication with SAP.The result of communication can then be shared to Android environment in either JSON or XML format as per requirement.

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.