Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to run an SAP Report using the SAP Report Connector. This particular report have some selections that are mandatory. We tried with variants, and it works fine. But when we try to use the "Select Options", we get the following error:-
Based on the error, it seems the date format is not correct. But the format that we are using is exactly the same as what we input in SAP GUI. (DD.MM.YYYY)
Anyone know what else that can I try?
Hi,
In the connector script the date is normally given in the format YYYYMMDD or 'YYYYMMDD'.
It does not matter how the date is displayed in the SAP GUI or what date format setting the SAP user has.
Regards,
Håkan
Hi,
You can repeat a line many times with different values, for one SELNAME like for S_BLART below:
Select SAPREPORT (REPORT (SDORDE01), ROWS_PER_RECORD (1), FIELD_AUTO_COLUMNS (8),
OPTIONS (
(SELNAME S_BLART, KIND S, SIGN I, OPTION EQ, LOW TAV),
(SELNAME S_BLART, KIND S, SIGN I, OPTION EQ, LOW YPO),
(SELNAME S_ERDAT, KIND S, SIGN I, OPTION BT, LOW 20000925, HIGH 20100101)
));
Regards,
Håkan
Hi,
In the connector script the date is normally given in the format YYYYMMDD or 'YYYYMMDD'.
It does not matter how the date is displayed in the SAP GUI or what date format setting the SAP user has.
Regards,
Håkan
Hi,
You can repeat a line many times with different values, for one SELNAME like for S_BLART below:
Select SAPREPORT (REPORT (SDORDE01), ROWS_PER_RECORD (1), FIELD_AUTO_COLUMNS (8),
OPTIONS (
(SELNAME S_BLART, KIND S, SIGN I, OPTION EQ, LOW TAV),
(SELNAME S_BLART, KIND S, SIGN I, OPTION EQ, LOW YPO),
(SELNAME S_ERDAT, KIND S, SIGN I, OPTION BT, LOW 20000925, HIGH 20100101)
));
Regards,
Håkan
Got it, thanks!!