Starting with a table and finding the dependant consumption view is not possible ?

[former_member711380]

Hello,

I got the table BKPF or COEP or many others.

I need to find in which Consumption Views the specific table is used.

The "where used" list (Eclipse oder Se11) seems to find only the first inner level if at all

(Sample for COEP):

How is this possible ?

Thank You

Martin

[pfefferf]

You can put a recursive logic on CDS view CDS_VIEW_CROSSREFERENCE. Starting from your table (ReferredObject = your table name + ReferredObjectType = TRANSP) you can search for CDS views. If for a found CDS view no additional CDS View on top is found, you have reached the top level view. Then you have a least a restricted list of views which you can check if they are used as Consumption view.

[former_member711380]

Hello,

thank You, good stuff this CDS.

Please kindly vote for

Improvement Request Details - Customer Influence SELECT Syntax for Hierarchical Queries

...this would enable a search like this nicely.

ThanXs

Martin

[Andre_Fischer]

In ADT there is the new tool "Relation Explorer" available. Please note that you have to use the button "other context" and then switch from "used objects" which is the default to "using objects".

[TammyPowlas]

Hi Martin - have you tried the options as found in this blog: https://blogs.sap.com/2018/12/05/how-to-find-a-predefined-virtual-data-model-in-s4hana/

[former_member711380]

Hi,

hahah: this is all top down search: From the CDS Views down to the table.

The challenge is:

Buttom Up: Form the table to the CDS:

In which CDS is used a certain table is the challenge.

I customizeing a table like COBK with a Z fiels: In which CDS Views will be the Z field ?

Any suggestions ?

Best Martin