topic ABAP CDS View with dynamic table specification in Application Development and Automation Discussions

ABAP CDS View with dynamic table specification

former_member314455 — Tue, 08 Dec 2015 21:18:33 GMT

Hello,

Just wondering if dynamic table specification is possible with CDS view?

My requirement is to represent the below in a CDS view-

parameters: p_region type char5.

SELECT table_name

FROM Ztable_names

INTO @data(lv_table)

WHERE region = @p_region.

SELECT col1,

col2

FROM (lv_table)

INTO TABLE @DATA(lv_result).

Thanks,

Ajith

Re: ABAP CDS View with dynamic table specification

pfefferf — Wed, 09 Dec 2015 05:18:18 GMT

Hello Ajith,

within a CDS view declaration the names must be specified. No dynamic placeholders can be used.

Regards,

Florian

Re: ABAP CDS View with dynamic table specification

former_member314455 — Wed, 09 Dec 2015 12:34:25 GMT

Hi Florian,

Thanks for the clarification.

Is there any other way to achieve this (AMDP etc) ?

Thanks,

Ajith

Re: ABAP CDS View with dynamic table specification

pfefferf — Wed, 09 Dec 2015 13:19:27 GMT

Hello Ajith,

within SQLScript you can use dynamic sql (e.g. EXEC command). But you should avoid this because of different reasons, for instance SQL injection vulnerability, decreased performance ...

Best Regards,

Florian

Re: ABAP CDS View with dynamic table specification

former_member314455 — Wed, 09 Dec 2015 15:12:40 GMT

Thanks ! I think I'll create a RFC function module so that it can be called from external system.