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.