topic Re: help needed in Application Development and Automation Discussions

help needed

Former Member — Tue, 29 Aug 2006 18:36:51 GMT

hi experts,

plz help me how to code for the below given description.

items counted:

count the entries using the selection from LAGP where LAGP-IDATU >= start date, LAGP-IDATU <= finish date, LINV-LGNUM=LAGP-LGNUM and LINV-LGTYP=LAGP-LGTYP (for all selected storage types).

regards,

siri.

Re: help needed

Former Member — Tue, 29 Aug 2006 18:38:41 GMT

DATA: L_CNT TYPE I,

L_START_DATE LIKE LAGP-IDATU,

L_END_DATE LIKE LAGP-IDATU.

SELECT COUNT( * ) INTO L_CNT

FROM LAGP WHERE LGNUM = LINV-LGNUM

AND LGTYP = LINV-LGTYP

AND IDATU >= L_START_DATE

AND IDATU <= L_END_DATE

Re: help needed

Former Member — Tue, 29 Aug 2006 18:40:43 GMT

data: i_lagp type standard table of lagp,

data: ws_count type i.

select * from lagp into i_lagp

for all entries in i_storage

where LGNUM = i_storage-LGNUM

idatu >= start_date and idatu <= finish_date.

describe table i_lagp lines ws_count.

Regards,

Prakash.

Re: help needed

abdul_hakim — Tue, 29 Aug 2006 18:42:57 GMT

Use SELECT COUNT(*) variant for achiving your o/p..

Cheers,

Abdul Hakim

Re: help needed

Former Member — Tue, 29 Aug 2006 18:43:14 GMT

If you need the data from LAGP for later use, then use the method proposed by Prakash. If you only want a count then use the aggregate function SELECT COUNT( * ) for performance reasons.

Re: help needed

Former Member — Tue, 29 Aug 2006 18:44:13 GMT

thankx friens,

siri

Re: help needed

abdul_hakim — Tue, 29 Aug 2006 18:53:08 GMT

plz close the thread if your question has been answered..

Thanks,

Abdul Hakim

Re: help needed

Former Member — Tue, 29 Aug 2006 20:36:46 GMT

I think from the description there is a INNER JOIN on LAGP and LINV that needs to be done..

select a~lgnum into table itab1

from LAGP as a INNER JOIN LINV as b

on a_{lgnum = b}lgnum and

a_{lgtyp = b}lgtyp

where a~idatu >= start_date and

a~idatu <= finish_date.

describe itab1 lines l_lines.