Skip to Content
0
Former Member
Oct 23, 2005 at 09:02 AM

prob in gettting output..urgent

29 Views

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..