Hello Team
Example:
1. My Method has a select query which is inner join between exciting CDS View and a Database Table, (Something like below example)
SELECT cds~aktnr, cds~matnr, werks, max_troc, vkdab, vkdbi
FROM ZEXAMPLECDS1 AS cds
INNER JOIN ZTESTTABLE1 AS stores
ON cds~aktnr = stores~aktnr
AND cds~matnr = stores~matnr
AND cds~werks = stores~filnr
WHERE cds~aktnr IS NOT INITIAL
INTO TABLE @DATA(lt_temptable1).
2. Select statement is on Database tables (Something like below example) :
SELECT t001w~werks,
t001w~fabkl
FROM t001w
FOR ALL ENTRIES IN @lt_table2
WHERE werks = @lt_table2-werks
INTO TABLE @DATA(lt_calender_key).
3. Select on CDS View
SELECT cds~aktnr, cds~matnr, werks, max_troc, vkdab, vkdbi
FROM ZEXAMPLECDS2 AS cds WHERE cds~aktnr IS NOT INITIAL
INTO TABLE @DATA(lt_temptable2).
So, In this case, my method is combination of Selects on Database and different CDS Views.
Now, I have below questions on creating test environment for Test Driven Development for my Method: