Deriving COUNT for how many times a user run a tcode in day

dataservices job design
1

Hi

Can you please tell me how can i loop the below source records and find the count for how many times a particular user run a t-code for a particular day.

For example, in the below source records, the User U1 executed the SE36 tcode 3 times, so the count for User U1 is 3.

Date User Machine Tcode
20160823 U1 M1 SE36
20160823 U1 M2 SE36
20160823 U1 M3 SE36

20160823 U1 M1 SE16
20160823 U1 M2 SE16

Im looking the output records like below

Date User TCode COUNT
20160823 U1 SE36 3
20160823 U2 SE16 2

How can i get the COUNT like above out put records in SAP BODS

Thanks
Mubeen

abdmubeen8 (BOB member since 2016-09-15)

2

select date, user, tcode, count(*) from tablename
group by date, user, tcode

eganjp :us: (BOB member since 2007-09-12)