topic Re: logic in Application Development and Automation Discussions

logic

Former Member — Wed, 13 Jun 2007 10:31:25 GMT

hi experts,

i have a internal table with 90000 enteries,it has got details of background jobs. itab will have currently only details of jobname and runtime, other fields are blank.

JOB1 | 28 | | | |

JOB1 | 14 | | | |

JOB2 | 10 | | | |

JOB2 | 5 | | | |

JOB3 | 8 | | | |

required is:

JOB1 | 28 | 21 | 14 | 28 | 2

JOB1 | 14 | 21 | 14 | 28 | 2

JOB2 | 10 | 7.5 | 5 | 10 | 2

JOB2 | 5 | 7.5 | 5 | 10 | 2

JOB3 | 8 | 8 | 8 | 8 | 1

Kindly suggest the code.

Thanks in advance

Bijal

Re: logic

former_member784222 — Wed, 13 Jun 2007 10:45:57 GMT

Hi,

You can get and populate other data from table TBTCO.

Thanks and regards,

S. Chandra Mouli.

Re: logic

santhosh_patil — Wed, 13 Jun 2007 10:48:57 GMT

Hi,

try this logic.

take another itab itab2

loop at itab1.

clear: i, sumruntime, maxruntime, minruntime.

loop at itab2 where jobname =itab1-jobname.

i = i + 1.

if i = 1.

minruntime = itab2-runtime.

maxruntime = itab2-runtime.

endif.

if itab2-runtime GT maxruntime.

maxruntime = itab2-runtime.

endif.

if itab2-runtime LT minruntime.

minruntime = itab2-runtime.

endif.

sumruntime = sumruntime + itab2-runtime.

endloop.

itab1-minruntime = minruntime.

itab1-maxruntime = maxruntime.

itab1-count = i.

itab1-averageruntime = sumruntime / i.

modify itab1.

endloop.

---patil

Message was edited by:

Santhosh Patil

Message was edited by:

Santhosh Patil

Re: logic

Former Member — Wed, 13 Jun 2007 10:50:46 GMT

HI ..

Thanks

But TBTCO table does not give avg runtime, min , max

i found out runtime by subtracting strttime from endtime.

i have to calculate it

Re: logic

Former Member — Thu, 14 Jun 2007 05:45:30 GMT

Hi Bijal,

Do you remember the construct called At New ... EndAt.

It works like this -

1. The fields you are using in AT NEW clause show be inorder in table declaration.

2. The table should be sorted as per the field order, either sort table explicitly using SORT statement or modify your SELECT query itself to fetch sorted records.

Rest follow this code -


DATA: BEGIN OF gt_jobs OCCURS 0,  "Assume appropriate declaration here
        jobname    TYPE char01,
        runtime    TYPE i,
        averageruntime     TYPE i,
        minruntime         TYPE i,
        maxruntime         TYPE i,
        count              TYPE i,
      END OF gt_jobs.
DATA:
  gv_totruntime         TYPE i,
  gs_job                LIKE LINE OF gt_jobs.

* I assume sorted records as per job name here

LOOP AT gt_jobs.
  gs_job-runtime = gt_jobs-runtime.

  AT NEW jobname.
    gs_job-count = 0.
    gv_totruntime = 0.
    gs_job-maxruntime = 0.
    gs_job-minruntime = gs_job-runtime.
  ENDAT.

  IF gs_job-minruntime > gt_jobs-runtime.
    gs_job-minruntime = gt_jobs-runtime.
  ENDIF.
  IF gs_job-maxruntime < gt_jobs-runtime.
    gs_job-maxruntime = gt_jobs-runtime.
  ENDIF.
  ADD 1 TO gs_job-count.
  ADD gt_jobs-runtime TO gv_totruntime.

  AT END OF jobname.
    gs_job-averageruntime = gv_totruntime / gs_job-count.
    MODIFY gt_jobs FROM gs_job
           TRANSPORTING averageruntime
                        minruntime
                        maxruntime
                        count
           WHERE jobname = gt_jobs-jobname.
  ENDAT.
ENDLOOP.

You can also view zirt_table_control_events at .91 / .83 server

Tell me if your problem is solved.

Regards,

Manish Joshi