John SAP

John SAP

88 Articles Published

Articles by John SAP

Page 9 of 9

Differentiating between row and column store table in SAP HANA database

John SAP
John SAP
Updated on 30-Jul-2019 794 Views

Yes, it is possible to differentiate between both the table types.  When you go to schema and view the newly created table, you can see vertical lines in front of table name and it confirms that this is column store table.In below pic, you can see the difference between a Row store table and Column store table.

Read More

Integrating HANA and R using RJDBC

John SAP
John SAP
Updated on 30-Jul-2019 174 Views

I think there is a typo error. Try correcting your code like classPath="Z:/SAP/hdbclient/ngdbc.jar

Read More

Using Rounding formula in SAP

SAP
John SAP
John SAP
Updated on 30-Jul-2019 506 Views

Try using below formula:Total = R(Quantity * Unit Price * (100 - Discount%) / 100)You need to take out rounding on each step and shouldn’t use Original Price-Discount

Read More

Using custom calculation views in SAP Cloud IoT

John SAP
John SAP
Updated on 30-Jul-2019 273 Views

To add a logic to show maximum value it hardly matters if you are using trial version or licensed version. Try using database views to add this logic simply.You can refer this link to know more technical capabilities of SAP Cloud IoT: https://help.sap.com/docs/SAP_IoTSAP offers a comprehensive portfolio of solutions for the Internet of Things (IoT). This in-memory IoT platform can help you quickly develop, deploy, and manage your own real-time IoT and machine-to-machine (M2M) applications. Use the platform to automate processes at the core and connect to almost anything at the edge of your network.

Read More

Getting an error invalid Object Name in SAP Business One

John SAP
John SAP
Updated on 30-Jul-2019 561 Views

It would be easy to guess if you have shared the full query. It seems you have not defined #temp_table. You might need to define temp table as global but it could sum up to other issues.

Read More

In SAP Business One SDK, filling a gridview and button saves in database

John SAP
John SAP
Updated on 30-Jul-2019 529 Views

This can be achieved in multiple ways. You can either use a SAP DI documents, an open SQL or use data transfer workbench for this purpose.You can use a direct SQL write as this is one of straight way to do this. It is also possible to use SAP-DI Documents object to iterate over the Purchase Orders.One more option is using Data Transfer Workbench (DTW), where you export it to a file and then using DTW. It also provides error handling incase any exception occurs.

Read More

SAP Crystal Report file is not opening in VS2015

John SAP
John SAP
Updated on 30-Jul-2019 395 Views

To start with I would suggest you to check SP level on Crystal Report Visual Studio. Try reinstalling Crystal Report and make sure your asp.net application is configured properly. There are various forums that you can search specific for Crystal Reports for VS like this:SAP Tags

Read More

Values are not readable while calling RFC method in .net via SAP.NET Connector 2.0

John SAP
John SAP
Updated on 30-Jul-2019 276 Views

Please check if you have same Unicode encoding in SAP and .NET Connector.

Read More
Showing 81–88 of 88 articles
« Prev 1 5 6 7 8 9 Next »
Advertisements