save and Run SQL Queries in SAP Business one

 

Step 1: Go to Tools > Query generator >

Step 2:  Query Generator window show> Click Execute

Step 3: click on edit button and paste the query and execute

Step4: Save the Query for future.

                                                                                                                                                         

SAP HANA IMPORT AND EXPORT DB

 IMPORT "MTU_LIVE_V2"."*" AS BINARY FROM '/hana/shared/backup_service/backups/V2/'

WITH IGNORE EXISTING THREADS 10 

RENAME SCHEMA  MTU_LIVE_V2 TO MTU_TESTING_V2;

https://blogs.sap.com/2015/05/29/updating-exchange-rates-automatically-in-sap-business-one/

 Using DI API:

 https://blogs.sap.com/2015/05/29/updating-exchange-rates-automatically-in-sap-business-one/

Using B1IF:

https://blogs.sap.com/2015/06/23/how-to-import-exchange-rates-using-b1if/

Using Service Layer and HANAXS:

https://blogs.sap.com/2018/08/27/update-sap-b1-rates-using-hana-xs-and-servicelayer/

How to check automatic exchange rate difference posting in SAP Business One

 https://blogs.sap.com/2017/04/20/automatic-journal-transactions-for-exchange-rate-differences/?preview_id=478064

How does SAP Business One handle Exchange Rate Differences

 

https://blogs.sap.com/2020/07/01/how-does-sap-business-one-handle-exchange-rate-differences/

TEST GIF

 

SAP B1 HANA Crystal Report Connection Setup

 

SAP HANA Crystal Report setup required  ODBC to Setup.

ODBC:

ODBC RDO Connection String

DRIVER={B1CRHPROXY};SERVERNODE=Server IP:30013;DATABASE=SBODEMOAU;databaseName=HDB