KONV~KDATU field selection via SAP Connector

[atsushi_saijo]

I have been trying to select KONV record based on KDATU, but it appears this does not work:

SQL SELECT KNUMV KPOSN KSCHL KAWRT KBETR KPEIN KKURS

WAERS KWERT KINAK KDATU

FROM KONV

WHERE KDATU EQ '20160708'

;

Only the way to extract is when we use SUBSELECT with other tables, by conditioning with KNUMV., such as VBAP or VBRP. But this will lose record either non-billing or non-order related.

*I suspected if inverted date is used, but it seems not working: KDATU EQ '79839291'

**Inverted date = 99999999 - 20160708

I get an impression that current SAP connector cannot condition dates if it were clustered table, and always need SUUBSELECT with transparent table. But is it true?

Would you advise how we can condition in where close with KONV~KDATU? I should appreciate for your support in advance.

[Hakan_Ronningberg · Accepted solution]

Hi Atsushi,

I executed this statement without problems:

SQL SELECT KNUMV KPOSN KSCHL KAWRT KBETR KPEIN KKURS

WAERS KWERT KINAK KDATU

FROM KONV

WHERE KDATU EQ '20020515';

Maybe you can attach the SQL connector log?

Regards,

Hakan

[neha_shirsath]

Hi,

Try using Script builder where condition.

It should work.

What is your exact requirement? you want to filter on particular date only?

[atsushi_saijo]

THank you Hakan, indeed it worked. It was just that KONV table was too huge at current SAP instance, so it did not responded after waiting 10 minutes. However, if I SUBSELECT, it starts immediately. Probably this is SAP-SQL server indexing stuff, where we have no control. Thank you for the verification.