FAQ: How to open the document Crystal report on SAP HANA

  • Updated

Due to a few limitations in the SQL Script on SAP HANA, we are not able to build dynamic SQL as we do on MSSQL.
When trying to edit the documents report you are prompted with entering two additional values:

The parameter $[BOY_TABLE] is for telling the report the main table it should use (LIKE OINV) the $[BOY_TABLE_IDENTIFIER] is then INV.
This allows us to write "dynamic" SQL based on what kind of window the report is run from in SAP.
So as an example:
Invoice - OINV, INV
Sales order - ORDR, RDR

Was this article helpful?

1 out of 1 found this helpful

Comments

0 comments

Please sign in to leave a comment.