FETCHING DATA FROM STRUCTURE

[Former Member]

I HAVE A STRUCTURE T023D AND FIELD IS WWGHA ,I WANT TO FETCH DATA CORRESPONDING TO THIS FIELD HOW I CAN DO IT PLEASE TELL ME.

SUGGEST IF I CAN USE FIELD-SYMBOL.

THANKS IN ADVANCE.

[Former Member]

Hi Bond,

You are using a structure...

This structure is just a framework and does 't have any data...

You can access the structure elements like:

T023D-WWGHA.

For eg, SYST is a structure... YOu can access its elements syst-subrc...

[Former Member]

I NEED SOLUTION FOR EXTRACTING DATA FROM STRUCTURE LIKE HOW I SHOULD WRITE THE QUERY FOR FETCHING DATA FROM STRUCTURE.

[Former Member]

SELECT SINGLE *

INTO T023D

FROM table

.

You can use : T023D-WWGHA.

[hymavathi_oruganti]

hi james,

when there will be no data in a structure, how can u retrieve data from it?

[Former Member]

data: begin of itab occurs 0,

include structure name.

data: end of itab.

select * from dbtab into table itab where cond.

Message was edited by: kishan negi

Message was edited by: kishan negi

[Former Member]

Hi James,

You cannot extract data from this structure. What you can do is go to se11 and put WWGHA in the data type field and click where-used list then tick table fields. This will show you all tables that use the data type WWGHA as one of their field. I think there is only one table (T023S).

Check the table if it is of use to you.

Regards,

Kenny

[hymavathi_oruganti]

1. STRUCTURE WILL NEVER STORE DATA.

2. TABLE STORES DATA. BUT STRUCTURE NEVER STORES DATA.

TO RETRIEVE DATA FROM TABLE U CAN USE SELECT statement

[Former Member]

Hi james,

you cannot directly fetch the data from your STUCTURE.. As you do it from a table..

regards

satesh

[Former Member]

This structure is just a framework and does 't have any data...

u just make an internal table including structure and fetch the value from dbatb into internal table and use this internal table where u required...

[Former Member]

Hai james,

You cannot fetch data from a structure, as structure doesn't store any data.Only tables stores data,that is the main difference betwen a structure and a table...

Regards,

Srikanth.

[Former Member]

Hi,

you can not save/fetch data in any structure.

If it is a table then you can use

T023D-WWGHA.

No need to use field symbol.

Regards,

Shashank

[Former Member]

for which TCODE u r looking for this data....

[Former Member]

my dear james bond...

see for T023S ur job ll be done..

Regards..Double james bond.

[Former Member]

Hi James,

Like you already know by now that your structure T023D does not hold any data.

If I undrestand correctly, you have identified this structure from a screen and now want to extract the data stored behind it.

You can do so using tables T023 and T023S. In case you need any field that you are not able to locate in these two tables, please do let me know.

You can write the query as

DATA: WA_WWGPA LIKE T023S-WWGPA.

SELECT SINGLE
  B~WWGPA
INTO (WA_WWGPA)
FROM
  T023 AS A INNER JOIN
  T023S AS B ON A~MATKL = B~MATKL.

This is just an example, you may not use SINGLE or variable WA_WWGPA. Simply declare an internal table with the required fields and populate it in the same manner.

Data for WWGHA is defined in table T023S but don't let the field name confuse you. The field name in T023S is given as WWGPA. Take note of the Data Element from which it is being derived and the text of the field.

Hope this help,

Regards,

Madhur

NB: Please do award points if found helpful.

Message was edited by: Madhur Chopra

[Former Member]

Hi,

retrieve the data from T023S for the field WWGPA.

Thanks

Eswar