Table Select Options BT From and To - AMDP CDS

[former_member469349]

Hi Team ,

I have a table SETLEAF where i have 2 columns ValueFrom and ValTo with SIGN option is BT. Now i need to design a CDS View having one column which constitutes of only column. I know that table functions are the way but looking to check if you have any predefined functions or SQL Code to help on it.

SETNAME SIGN OPTION VALFROM VALTO

ABC I BT 500700 500710

COLUMN1

500700

500701

500702

500703

500704

500705

500706

500707

500708

500709

500710

[pfefferf]

Can you explain, what exactly you wanna reach? At the moment that is not really clear.

[former_member469349]

Hi Florian,

Table i have is SETLEAF with BT in the SIGN OPTION. Now i want to build a CDS view on to of view to pull all the records between ValFrom and ValTo columns.

I am expecting an CDS view like below

COLUMN1

500700

500701

500702

500703

500704

500705

500706

500707

500708

500709

500710

[Sandra_Rossi]

Isn't it of no use to say that the values in the interval are to be taken from another table? (based on SETHEADER-SETCLASS as follows - Here I only show the text of the table)

Set class  Table of values                Subclass
---------  -----------------------------  -----------------
0101       Cost center group              Controlling area
0102       Cost element group             Chart of accounts
0103       Order group                    --- initial ---
0104       Statistical key figure group   Controlling area
0105       Activity type group            Controlling area
0106       Profit center group            Controlling area
0107       Business process group         Controlling area
0108       Cost object group              Controlling area
0109       Account group                  Chart of accounts
0110       PSP element group              --- initial ---
etc.

[pfefferf]

With pure ABAP CDS Views this is not possible so far. But you can create an CDS table function which determines the start and end value and uses the e.g SERIES_GENERATE_INTEGER function to create the required values.