3 Replies Latest reply: Aug 25, 2017 9:12 AM by Atsushi Saijo RSS

    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.