Skip to Content
0
Former Member
Oct 21, 2005 at 02:07 PM

prob. in getting data in internal table(Urgent)

29 Views

my internal table look like this:-

DATA : BEGIN OF TBL_FINAL OCCURS 0,

BTEXT LIKE T001P-BTEXT,

NO_OF_WORKERS TYPE I,

WORK_DAYS_LOST TYPE I,

END OF TBL_FINAL.

i am getting BTEXT into the report output based on sel screen as:-PARAMETERS : S_MONTH LIKE ISELLIST-MONTH.

SELECT-OPTIONS : S_BTRTL FOR PA0001-BTRTL.

i used select query like this for getting BTEXT.

SELECT BTEXT INTO TABLE TBL_FINAL FROM T001P WHERE BTRTL IN S_BTRTL.

<b>I have select queries to get no. of workeers and work_days_lost. But I am unable to display in the report output.

Can anyone help on this?</b>

my select queries are like this:-

1)to count no. of workers:-

SELECT COUNT(*) INTO TBL_BTEXT-NO_OF_WORKERS

*FROM PA0000 AS A INNER JOIN PA2001 AS B ON APERNR = BPERNR INNER JOIN PA0001 AS C ON APERNR = CPERNR

WHERE AENDDA = '99991231' AND ASTAT2 = '3'

AND C~BTRTL = S_BTRTL.

2)work days lost:-

SELECT COUNT(*) INTO TBL_TEXT-WORK_DAYS_LOST FROM PA2001 AS A INNER JOIN PA0001 AS B ON APERNR = BPERNR

WHERE ABWTG = PA2001-ABWTG AND

B~BTRTL = S_BTRTL.

Please help on this. very urgent.

your help is appreciated with points.