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
Please sign in to leave a comment.