topic Data Extraction Using Structure_Ex Code in Application Development and Automation Discussions

Data Extraction Using Structure_Ex Code

Former Member — Thu, 24 Jul 2008 07:33:29 GMT

Hi All,

Can anyone give me the example code

for extract data Using strcture.

i tried following one, but end up with an error.

TABLES: rc29l.

DATA: BEGIN OF itab OCCURS 0.

INCLUDE STRUCTURE rc29l.

DATA: END OF itab.

SELECT * FROM rc29l into itab.

LOOP AT itab.

WRITE:/ itab-matnr, itab-idnrk.

ENDLOOP.

Regards

Hema

Edited by: hema prabakaran on Jul 24, 2008 1:04 PM

Former Member — Thu, 24 Jul 2008 07:41:32 GMT

Report zadd_struc.

data: begin of table occurs 1.

include structure <structure>.

end of table.

*****the above structure contains some fields of type lfa1.

select lifnr land1from lfa1 into corresponding fields of table table.

loop at table.

write:/ table-lifnr.

endloop.

Former Member — Thu, 24 Jul 2008 12:06:35 GMT

Hi Hema,

We cannot use select statement for a structure.Because nothing (no data) will be stored in the structure.

SELECT * FROM rc29l into itab. "this statement has no meaning.

Hope you understand...Please let me know if any issues.

Former Member — Fri, 25 Jul 2008 00:34:49 GMT

Hi Vamsi,

yes, i know that structure has no data,

but dunno what's the relation betwn

mara and stpo table.

But my query is depends on the material i want to select

data from srpo-idnrk, how can i do it.

in structure RC29L, there is a field calld matnr and idnrk.

so im trying to access the RC29L.

Regards

Hema