Skip to Content
avatar image
Former Member

How to find the specific value in Z table without knowing the column name

Hi Experts,

I need your help to fix the following scenario.

Scenario: I have more than 10 table and each table has different column names (column number also different). I need to check specific value is present in the 10 table. Its like a similar kind of find option.

Picture represent:

Ztable_01

Source_ 1 Source_2 Source_3 1 X B 2 A C 3 V D

Ztable_02

Source_ 1 Source_ 2 Source_3 Source_ 4 B M K N C Y J B D Z L A

For Example: I need to display the table Name if the table contains 'A' in any column. (Note we don't know the column name)

Please help me to fix this.

Note:

    

- I have tried where condition but for the where condition we need to know the column name.

- Just want to display the table name if contains specific value, no further action is required.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 21, 2015 at 07:38 AM

    Hello Siva,

    use the dictionary-tables DD02L and DD03L, I think you find what you Need.

    Greeting Peter

    Add comment
    10|10000 characters needed characters exceeded