Skip to content

Instantly share code, notes, and snippets.

@wisaruthk
Created April 8, 2021 10:25
Show Gist options
  • Save wisaruthk/a9a87c5193bc7202a02d3684a6fe4ad5 to your computer and use it in GitHub Desktop.
Save wisaruthk/a9a87c5193bc7202a02d3684a6fe4ad5 to your computer and use it in GitHub Desktop.
Crystal Report Command , SAP HANA, Semantic Parameter as Date (Create DateTo@ Parameter as Date in CR)
DO BEGIN
DECLARE varDateTo VARCHAR(10);
varDateTo := {?DateTo@};
tbResult =
SELECT T0.*
FROM "_SYS_BIC"."sap.{?Package@}.ar.case/CustomerReceivableAgingFact"
(PLACEHOLDER."$$P_AgingDate$$" => :varDateTo) T0;
SELECT * FROM :tbResult;
END;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment