topic Re: Retreive data from wa structure into fields. in Application Development and Automation Discussions

Retreive data from wa structure into fields.

Former Member — Mon, 24 Sep 2007 07:58:50 GMT

Hi friends,

I am having a query regarding classical report.I want to retreive data for vendor billwise realisation report.I am getting few fields into my list screen(fields from bsis table).Remaining fields i want to retreive from table bseg(augdt,augbl....)with the condition that the belnr of both the tables should be same and Account type = 'k'(vendors).

I tried it using select queries for the bsis and bseg..but data is retreived only from one table bsis and not from bseg.so for data from bseg i used workarea(wa).data is retreived for only single doc no. and not for other documents.

If any problem in understanding this pls give me the mail id i will send in detail.

Thanks and regards,

Anand.

Re: Retreive data from wa structure into fields.

abdulazeez12 — Mon, 24 Sep 2007 08:01:24 GMT

After fetching from BSIS into internal table, say it_bsis, use

select <fields> from BSEG into table it_bseg for all entries in it_bsis

where BELNR eq it_bsis-BELNR and

account type = 'K'.

Re: Retreive data from wa structure into fields.

Former Member — Mon, 24 Sep 2007 08:03:36 GMT

Hi Anand,

You should not use Workarea, if you are exepecting N number of records. Please use internal table.

SELECT * FROM BSIS

into table i_bsis

where ....

if not i_bsis[] is initial.

sort i_bsis by belnr.

SELECT * FROM BSEG

into table i_bseg

for all entries in i_bsis

where belnr = i_bsis-belnr.

endif.

Best regards,

Prashant

Re: Retreive data from wa structure into fields.

Former Member — Mon, 24 Sep 2007 08:04:03 GMT

Bseg table is a cluster table U cannot join with other tables.

Remove join Bseg with other tables and use select single from bseg

Sreeram

Re: Retreive data from wa structure into fields.

Former Member — Mon, 24 Sep 2007 08:04:29 GMT

If u have stored datas retrieved from one table in an internal table, then use

<b>Select for all entries</b>

If u have not stored that in an internal table, then use

<b>Inner join Select query</b>

Please reward if helpful.

Re: Retreive data from wa structure into fields.

Former Member — Tue, 25 Sep 2007 05:04:53 GMT

Hiii friend,

I hope ur answer is helpful to me and send me ur mail id so that i will send u my report which is of 2 select statements......

Thanks & regards,

Anand.