Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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_ 1Source_2Source_3
1XB
2AC
3VD

Ztable_02

Source_ 1Source_ 2Source_3Source_ 4
BMKN
CYJB
DZLA

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.

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question