topic Re: FETCHING DATA FROM STRUCTURE in Application Development and Automation Discussions

FETCHING DATA FROM STRUCTURE

Former Member — Tue, 07 Mar 2006 05:27:16 GMT

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.

Re: FETCHING DATA FROM STRUCTURE

Former Member — Tue, 07 Mar 2006 05:29:11 GMT

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...

Re: FETCHING DATA FROM STRUCTURE

hymavathi_oruganti — Tue, 07 Mar 2006 05:30:00 GMT

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

Re: FETCHING DATA FROM STRUCTURE

Former Member — Tue, 07 Mar 2006 05:32:11 GMT

Hi james,

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

regards

satesh

Re: FETCHING DATA FROM STRUCTURE

Former Member — Tue, 07 Mar 2006 05:36:34 GMT

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...

Re: FETCHING DATA FROM STRUCTURE

Former Member — Tue, 07 Mar 2006 05:38:04 GMT

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

Re: FETCHING DATA FROM STRUCTURE

Former Member — Tue, 07 Mar 2006 05:39:28 GMT

SELECT SINGLE *

INTO T023D

FROM table

You can use : T023D-WWGHA.

Re: FETCHING DATA FROM STRUCTURE

Former Member — Tue, 07 Mar 2006 05:39:35 GMT

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.

Re: FETCHING DATA FROM STRUCTURE

hymavathi_oruganti — Tue, 07 Mar 2006 05:40:26 GMT

hi james,

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

Re: FETCHING DATA FROM STRUCTURE

Former Member — Tue, 07 Mar 2006 05:40:34 GMT

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

Re: FETCHING DATA FROM STRUCTURE

Former Member — Tue, 07 Mar 2006 05:43:05 GMT

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

Re: FETCHING DATA FROM STRUCTURE

Former Member — Tue, 07 Mar 2006 05:45:34 GMT

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

Re: FETCHING DATA FROM STRUCTURE

Former Member — Tue, 07 Mar 2006 05:45:56 GMT

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

Re: FETCHING DATA FROM STRUCTURE

Former Member — Tue, 07 Mar 2006 05:50:43 GMT

my dear james bond...

see for T023S ur job ll be done..

Regards..Double james bond.

Re: FETCHING DATA FROM STRUCTURE

Former Member — Tue, 07 Mar 2006 05:56:13 GMT

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

Re: FETCHING DATA FROM STRUCTURE

Former Member — Tue, 07 Mar 2006 06:09:03 GMT

Hi,

retrieve the data from T023S for the field WWGPA.

Thanks

Eswar