CDS VIEW Select statement with where clause

Former Member — Fri, 11 Aug 2017 11:02:30 GMT

Dear Expert,

I want to achieve the below in the CDS view.

AS ABAP

SELECT * FROM edidc INTO CORRESPONDING FIELDS OF table it_data
WHERE ( ( mestyp = 'ORDERS' AND direct = '2' ) OR
( mestyp = 'ORDCHG' AND direct = '2' ) OR
( mestyp = 'INVOIC' AND direct = '1' ) OR
( mestyp = 'WMMBXY' AND direct = '2' ) OR
( mestyp = 'PORDCH' AND direct = '2' ) OR
( mestyp = 'DESADV' AND direct = '1' ) OR
( mestyp = 'DESADV' AND direct = '2' ) OR
( mestyp = 'INVOIC' AND direct = '2' ) OR
( mestyp = 'ORDERS' AND direct = '1' ) OR
( mestyp = 'ORDCHG' AND direct = '1' ) OR
( mestyp = 'Z_INV_STAT' AND direct = '1' ) ).

CDS VIew

define view Ztest_assotiation

as select from edidc as a

association [1] to edid4 as b on $projection.docnum = b.docnum

{ a.docnum, a.mestyp, a.sndprn, a.direct, a.credat, b.counter, b.segnum, b.segnam, b.dtint2 , b.sdata }

I want to achieve multiple where conditions for same field ex. ( mestyp = 'ORDERS' AND direct = '2' ) OR

( mestyp = 'ORDCHG' AND direct = '2' ) OR
( mestyp = 'INVOIC' AND direct = '1' ) OR
( mestyp = 'WMMBXY' AND direct = '2' ) OR
( mestyp = 'PORDCH' AND direct = '2' ) OR

Kindly help.

Re: CDS VIEW Select statement with where clause

Former Member — Sat, 27 Apr 2019 09:18:02 GMT

Dear

Please do let me know, if you have succeeded in getting the value in the CDS view from the EDID4 table.

Regards

Praveen G

topic Re: CDS VIEW Select statement with where clause in Application Development and Automation Discussions

CDS VIEW Select statement with where clause

Re: CDS VIEW Select statement with where clause