Use the associated entity "ZS4DEMO_CDS".

[former_member203215]

I created a cds view like below

SPAN { font-family: "Consolas"; font-size: 10pt; color: #000000; background: #FFFFFF; }

@AbapCatalog.sqlViewName: 'ZS4DEMOCDS'

@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Inner Join'
define view ZS4DEMO_CDS

as select from sbook as b
inner join spfli as p on b.carrid = p.carrid
and b.connid = p.connid
inner join scustom as c on c.id = b.customid
{
b.customid,
b.bookid,
c.name,
b.fldate,
p.cityfrom,
p.cityto
}

and used in report program(se38) like below

SELECT * FROM zs4hcds_selv25 INTO TABLE @DATA(lt_demo)

i'm getting a warning like this

Use the associated entity "ZS4DEMO_CDS".

please tell me why i'm getting this.

and the performance is slower to below statement which is written directly in se38 report program.

SELECT b~customid,b~bookid,c~name,b~fldate,p~cityfrom,p~cityto INTO TABLE @DATA(lt_data)
FROM ( sbook AS b INNER JOIN spfli AS p ON b~carrid = p~carrid
AND b~connid = p~connid
INNER JOIN scustom AS c ON c~id = b~customid ).

[Former Member]

Hi Ravichand S,

I would like to answer your ask about your message "Use the associated entity "ZS4DEMO_CDS"."

It's because you don't use right table.

You must use ZS4DEMO_CDS as table and not zs4hcds_selv25.

Example:

SELECT * FROM ZS4DEMO_CDS INTO TABLE @DATA(lt_demo) Correct

SELECT * FROM zs4hcds_selv25 INTO TABLE @DATA(lt_demo) Wrong

Regards,

Maurizio.

[former_member203215]

Thank You

[retired_member]

Where does that zs4hcds_selv25 come from?

[retired_member]

https://help.sap.com/http.svc/rc/abapdocu_752_index_htm/7.52/en-US/index.htm?file=abenopen_sql_cds_o...

[former_member203215]

Thank You.!