How To's

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.

EXPORT "SBODEMOUS"."*" AS BINARY INTO '/usr/sap/HDB/HDB00/backups/SBODEMOUS' WITH REPLACE THREADS 10

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:

tar -cvzf sbodemous.tar.gz /usr/sap/HDB/HDB00/backups/SBODEMOUS

First copy the exported archive onto the target server.

Then extract the archive:

cd /usr/sap/HDB/HDB00/import/SBODEMOUS
tar -zxvf sbodemous.tar.gz

Finally, execute the following command in SAP HANA Studio in order to import the schema onto the database server instance:

IMPORT "SBODEMOUS"."*" AS BINARY FROM '/usr/sap/HDB/HDB00/import/SBODEMOUS' WITH REPLACE

If you need to import the schema with another name, you have to use the following command to rename it during the import:

IMPORT "SBODEMOUS"."*" AS BINARY FROM '/usr/sap/HDB/HDB00/import/SBODEMOUS' WITH REPLACE RENAME SCHEMA "SBODEMOUS" TO "SBODEMOUS_COPY"

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.

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.

• 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.

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

Financial / Financial Reports / Accounting / General Ledger

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

You can export this to excel