Get the data from the structure OR View

[Former Member]

Hi All,

how wud i take data from the structure OR View? when i m writing the select query then its saying that its not defind in data dictionary.

I hav the requirement to develop a report for PM module..

in that i hav all structure like AFVGD,CAUFVD,PMCOEA...

Plz tel me how to write a select quary for this...

[Former Member]

Hi All,

how wud i take data from the structure OR View? when i m writing the select query then its saying that its not defind in data dictionary.

I hav the requirement to develop a report for PM module..

in that i hav all structure like AFVGD,CAUFVD,PMCOEA...

Plz tel me how to write a select quary for this...

[Former Member]

Hello,

U can't get data from the structure.

Find out the dataelement of the fields used in your structure and search for where used list.It will list number of tables from which u can find out the table from which can fetch the data of fields.

Thanks

Nitesh

[Former Member]

Hi,

You cannot select data from a structure.

A structure / work area contains data only at the run-time.

You can select data from views and tables.

The data you need to select will be in Database tables. All you need to do

is to find those table and select from there.

Let me know if you need further help.

Regards,

Rajat

[Former Member]

can i get the table name for the structure RQEVA and field is BKTXT, ineed both header and item..

i have tried that where used list ...but not able to fiend the required field..

can u help me out