Filter CDHDR data based on date in view

[former_member1004108]

Good morning,

In order to filter data from the CDHDR table in SAP Information Steward, I have created a view to decrease the number of records. However, I have an issue filtering on the UDATE field. In fact, I would like to get everyday the data created from yesterday onwards. I have tried several options like UDATE = sysdate() -1 or others found in SAP forum or Help Portal but it never worked.

Could you please help me solving this issue?

Thanks in advance.

Melanie

[former_member187605 · Accepted solution]

Note that sysdate returns date and time. Therefore equality won't return anything.

UDATE > sysdate() -2 works for me.

[former_member187605]

The filter is not pushed down to the SAP system. That means IS (actually the generated DS job) will still extract all data and only apply the filter after the transfer.

In the View Editor set the Data transfer method to ABAP. Then try again. Note that your SAP system must be open for development if you want to follow this approach.

[former_member1004108]

Thanks, the query isn't the problem then. I am probably trying to retrieve a too large amount of data as I am logged off after several minutes., as soon as I am trying to view the data.

[former_member187605]

Those aren't error messages, just warnings. You can safely ignore them.

[former_member1004108]

Thanks Dirk for your answer.

UDATE > sysdate() works but UDATE > sysdate() -2 gave me the attached error message udate.png.