topic Re: SAP Report Connector - Date in Connectivity & Data Prep

SAP Report Connector - Date

KHSDM — Wed, 22 Dec 2021 14:39:28 GMT

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?

Re: SAP Report Connector - Date

Hakan_Ronningberg — Thu, 23 May 2019 09:02:27 GMT

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

Re: SAP Report Connector - Date

KHSDM — Thu, 23 May 2019 09:23:22 GMT

Thanks! Manage to get it to work after changing it to YYYYMMDD format.
I have another question, if my selection is multiple values, which option that I need to choose? Or I can just use comma to separate it? (eg AAAA, BBBB)

Re: SAP Report Connector - Date

Hakan_Ronningberg — Fri, 24 May 2019 06:31:02 GMT

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

Re: SAP Report Connector - Date

KHSDM — Tue, 28 May 2019 01:14:06 GMT

Got it, thanks!!