Note that an Excel stores data in number format and to display in date format, you have to show it format as a date. You can also try using this formula: TEXT(31421,"YYYY-mm-dd") and the date should display correctly.

Yes, you can use Webi report in Dashboard using Web Service URL. You can use that URL in dashboard. To get URL, you need to select table in Webi report -> Right click Publish.

I think you can delete it from Windows Services. You can use below steps to delete this service. Open Central Configuration manager (CCM) and stop the Server Intelligence Agent (SIA) to be deleted. Next is to go to Windows Start > Run and type in "services. MSc" without ... Read More

You can check SAP Business One installation using below code: Public Function isSapBusinesOneClientInstalled() As Boolean Try SAP Business One Application Dim type As Type = Type.GetTypeFromCLSID(New Guid("632F4591-AA62-4219-8FB6-22BCF5F60088")) Dim ... Read More

In SAP system, you have an external BAPI that can be called to manage SAP jobs, check this FM: "BAPI_XBP_JOB". You can use BAPI_XBP_JOB* function modules to create/schedule a job to run the query. For more details, you can refer below link − BAPI_XBP_JOB There are various FM’s that can ... Read More

Note that you can’t access Pooled tables directly and it should be accessed via Application server. When a pooled table is created, it involves creation of a suitable transparent table with a suitable delivery class and then it is changed to a pooled table.A pooled table can be flagged as ... Read More

BELNR is not required however it is useful. Let us say a customer place an order and as he is not sure he place the order again. Now there are 2 orders you are not sure if there are two IDocs for same order.With BELNR, it has order number of ... Read More

As per my knowledge, SAP PI Messaging Server 7.4 AEX is compatible with JMS 1.02 and JMS 1.1. Using Java Messaging Service, you can connect messaging systems to the Integration Engine.You can refer to SAP Note: 856346 - J2EE JMS AdapterThis note says common FAQ’s about JMS and I have ... Read More

I thought it can be done using a script in SM69 T-code defined as a call to sh with parameters of -c 'cd && /path/to/command.However it doesn’t accept wildcards and && is converted to & and script is not working. As per SAP Note 401095 - Wildcards in external ... Read More

You are passing parameter in URL like this: http://XXX.com/xyz/api/sap-client=100&sap-user=username&sap-password=xxxxx"Instead of this, you should pass parameter like this: request.addProperty("sap-client", "100"); request.addProperty("sap-user", "*"); request.addProperty("sap-password", "*");