Search for CDS Views

[#1]

Hey Experts,

is there an option to search for existing CDS views?

I would like to expose materials and their short texts as OData via gateway. Of course i can model a own CDS on top of the both tables MARA and MAKT but i'm sure that there is already a CDS delivered by SAP. But how to find this view?

Btw. for materials the DDL Source "I_MATERIAL" exists.

But this is a typical use case for me over the last few days to find a existing standard cds entity or model a own one.

System: NW 7.50

Regards

Simon

[simon_collet · Accepted solution]

Hi Simon,

in ADT do a "Where used"-query on your table - in your case MARA and MAKT.  When you get the result you could filter it by clicking on the filter icon in the upper right corner of the view:

in SAP Gui you could directly set the filter to "DDL Sources" when hitting "Where used".

For further read:

Best regards,

Simon

[former_member194549 · Accepted solution]

Hey Simon,

thanks for your reply.

The where used query is a good hint, but f. e. I_Material is not displayed for mara...

Regards

Simon

[simon_collet · Accepted solution]

Hi Simon,

interesting I_Material was the first hit for mara in my system..

Best Regards,

Simon

[ThFiedler]

Hi Simon,

in eclipse you can use the shortcut CTRL-SHIFT-A to search for existing development objects in the system. It opens a popup where you can enter your search string. In my example here I restricted the search to CDS views only via the filter: TYPE:DDLS.

Regards,

Thomas.

[Former Member]

Hi Simon,

When a CDS is activated there are 3 types of objects created in TADIR:

1. VIEW (Visible in SE11, defined using annotation)

2. STOB (Name mentioned just after Define View syntax)

3. DDLS (The Name you enter in CDS creation wizard at first point)

You can try search in TADIR with object type STOB(if you are planning to consume CDS in ABAP).

Thanks,

Sumit

[Former Member]

Hi Simon,

I use se11 or se16n to search for existing CDS views I've created or stand ones that come with SAP.

Curtis