can anyone help on this:-
my internal table is :- DATA : BEGIN OF TBL_FINAL OCCURS 0,
BTRTL LIKE PA0001-BTRTL,
ABWTG LIKE PA2001-ABWTG,
BTEXT TYPE T001P-BTEXT,
NO_OF_OCC(4) TYPE C,
NO_OF_WORKERS TYPE I,
HOURS_WORK TYPE P DECIMALS 2,
WORK_DAYS_LOST TYPE I,
INC_RATE TYPE P DECIMALS 2,
INC_ROLL TYPE P DECIMALS 2,
FREQ_RATE TYPE P DECIMALS 2,
FREQ_ROLL TYPE P DECIMALS 2,
TIME_LOST TYPE P DECIMALS 2,
TIME_ROLL TYPE P DECIMALS 2,
END OF TBL_FINAL.
using this query i am getting personal text and no. of workers:- SELECT BTRTL COUNT(*) INTO (TBL_FINAL-BTRTL,
TBL_FINAL-NO_OF_WORKERS)
FROM PA0000 INNER JOIN PA0001 ON PA0000PERNR = PA0001PERNR
WHERE PA0000ENDDA = '99991231' AND PA0000STAT2 = '3'
AND PA0001~BTRTL IN S_BTRTL
GROUP BY BTRTL.
APPEND TBL_FINAL.
ENDSELECT.
now i want to add no.of work days lost to this internal table:-
eg:- select count(*)from pa2001-abwtg
can any one help me..