====== How To's ======


===== 1. How to migrate a SAP HANA schema between different instances =====

==== Export ====

Use the following command in SAP HANA Studio to export the schema as a binary export. The files will be saved on the SAP HANA server, in the folder specified in the command.
<code sql>EXPORT "SBODEMOUS"."*" AS BINARY INTO '/usr/sap/HDB/HDB00/backups/SBODEMOUS' WITH REPLACE THREADS 10</code>

After this, the /usr/sap/HDB/HDB00/backups/SBODEMOUS folder will contain a copy of the SBODEMOUS schema.

Use the following command to create a compressed archive of the export folder:
<code bash>tar -cvzf sbodemous.tar.gz /usr/sap/HDB/HDB00/backups/SBODEMOUS</code>

==== Import ====

First copy the exported archive onto the target server.

Then extract the archive:
<code bash>cd /usr/sap/HDB/HDB00/import/SBODEMOUS
tar -zxvf sbodemous.tar.gz</code>

Finally, execute the following command in SAP HANA Studio in order to import the schema onto the database server instance:
<code sql>IMPORT "SBODEMOUS"."*" AS BINARY FROM '/usr/sap/HDB/HDB00/import/SBODEMOUS' WITH REPLACE</code>

If you need to import the schema with another name, you have to use the following command to rename it during the import:
<code sql>IMPORT "SBODEMOUS"."*" AS BINARY FROM '/usr/sap/HDB/HDB00/import/SBODEMOUS' WITH REPLACE RENAME SCHEMA "SBODEMOUS" TO "SBODEMOUS_COPY"</code>

===== 2. How to convert a SAP delivery report to a Produmex delivery report =====

It can happen that for infrastructural reasons, SAP delivery reports cannot be printed directly from Produmex. In such cases, the SAP report needs to be converted to a Produmex report.

This only works for reports built with Crystal Reports.

==== Introduction ====

SAP document reports use 2 input parameters: ObjectID@ and DocKey@. However Produmex uses only 1 input parameter for delivery note reports, so ObjectID@ should be removed and forced to the value 15.

==== Conversion process ====

  * 1. First copy the .rpt file from the SAP report to a new report. Produmex will use a different rpt file than the standard SAP report.
  * 2. Open the PMX report in Crystal reports designer.
  * 3. Search for all references of ObjectID@, and replace it by the default value (15) at all places where it's used. Also do the same for all parameters that are not the document key. These parameters can be typically be used in formulas, in the SQL query of the report, or be found directly on the report. Examples:
    * {?ObjectID@}=15 should be replaced by true
    * {PMX_CR_HEADERS.U_ObjID}={?ObjectID@} should be replaced by {PMX_CR_HEADERS.U_ObjID}=15
    * It is also used as a parameter in the SAP SP [TmSp_DocLineTypeLayout_CPC] that is included in the default reports.
  * 4. When ObjectID@ has no reference anymore (its icon changes), remove it from the parameter fields.
  * 5. Rename DocKey@ to @salesDeliveryNoteDocEntry for MSSQL, or P_SALESDELIVERYNOTEDOCENTRY for HANA
  * 6. Save the report, and set it up as a normal Crystal Report in Produmex.


===== 3. How to get an overview of the open amount of clients/suppliers on a certain date =====

==== Introduction ====

They want to have an overview of the account balances and open amounts for all the customers/suppliers before 31/12/2015

==== solution ====

Financial / Financial Reports / Accounting / General Ledger

{{:implementation:1.png?200|}}

you get an overview of the open balance for each client/supplier

{{:implementation:2.png?200|}}

You can export this to excel

{{:implementation:3.png?200|}}