Symptom
Not all parameter fields are available in Crystal Reports (CR)
Environment
- CR 2008
- SAP Integration Kit for Business Objects Enterprise 3.1
- SAP ECC 6.0
Reproducing the Issue
- Create an ABAP function module which contains value type SY-DATUM such as:
VALUE(IV_DATE) TYPE SY-DATUM
- From CR, create new report using 'SAP Table, Cluster or Functions'
Cause
System fields such as 'SY-*' are supported using the ‘LIKE’ clause instead of the ‘TYPE’ clause
Resolution
- Replace the 'TYPE' clause with the 'LIKE' clause as below:
VALUE(IV_DATE) LIKE SY-DATUM
- 'LIKE' should be used with system fields 'Sy-*'
- 'TYPE' should be used with data types 'Syst-*'
Keywords
KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016