Process chain time stamp

[Former Member]

hi, I'm just starting to use SAP and was setup to do process chain monitoring. We are getting ready to add some new chains to the loads, and I was looking at the RSPCPROCESSLOG for time stamps on which chains were running longer. the problem is the time stamps are confusing and don't seem to make too much sense. Can anyone help me decipher these two?

20.140.623.153.008,5908200(start time stamp)
20.140.623.153.241,6544130(end time stamp)

I get the parts that its 2014/06/23 and the next digits are to be HH/MM/SS, if so, these numbers are wrong, because this job starts ~10:30 am.

any assistance would be greatly appreciated

[Former Member · Accepted solution]

Thanks a lot for the answers guys! i stumbled upon the answer while trying to solve another issue!

you can use t-code ST13(Analysis & Monitoring Tool Collection)

- use the "BW-TOOLS" tool

-Process Chain Analysis

-Process Chains

-when the box comes up, you can search for chains, log-id's, date's, time, and restrict status

[Former Member]

Hi

we will achive your requirement using  RSPCLOGCHAIN,RSPCPROCESSLOG ,tables

please write a program like as a below

types: begin of ty_rspc,

       log_id type rspc_logid,

       starttimestamp type rstimestmpl,

       endtimestamp type rstimestmpl,

       end of ty_rspc.

Data: lt_pclog type standard table of rspclogchain,

      wa_pclog like line of lt_pclog,

     rspc type table of ty_rspc,

       wa_rspc type ty_rspc,

       e_status1 type char10,

       i_chain1 type rspc_chain,

       logid type rspc_logid.

parameters: chain type rspc_chain.

select-options : dat for date  no intervals ,

select * from rspclogchain

               into table  lt_pclog

              where chain_id = CHAIN

                and datum in dat.

if sy-subrc = 0.

        sort lt_pclog by datum zeit.



        loop at lt_pclog into wa_pclog.

          if sy-subrc eq 0.

            logid = wa_pclog-log_id.

            i_chain = wa_pclog-chain_id.

          endif.



          select log_id  min( starttimestamp ) max( endtimestamp )

            from  rspcprocesslog

            into table rspc

           where log_id = logid group by log_id .

          if logid is not initial and i_chain is not initial.


            call function 'RSPC_API_CHAIN_GET_STATUS'

              exporting

                i_chain  = i_chain

                i_logid  = logid

              importing

                e_status = e_status.

          endif.



          if e_status = 'G' ....... R ,J, X,A,F

   *we have to calculate the start date&time and enddate& time

loop at rspc into wa_rspc .
              if sy-tabix = 1.

                time_end = wa_rspc-endtimestamp.

                exit.

              endif.

            endloop.



            loop at rspc into wa_rspc .



              time_start = wa_rspc-starttimestamp.



            endloop.

           hh = time_end+10(2).

            min = time_end+12(2).

            ss = time_end+14(2).

            concatenate hh min ss into  time_e .

            concatenate hh min ss into  time_ed separated by ':'.



            hh = time_start+10(2).

            min = time_start+12(2).

            ss = time_start+14(2).

            concatenate   hh min ss into time_s .

            concatenate hh min ss into time_st separated by ':' .



            date_end = time_end+2(8).

            date_start = time_start+2(8).

i have write some idea program , ask ur ABAper to fine tune .

Regrds,

polu.

[RamanKorrapati]

Hi,

Actually there is no table which shows process chain start and end times at once.

above table will shows process time which take to to finish one step(info pack load or DTP or etc) only.

While seeing data you need to see for which step(process type) your checking.

Assuming this is your chain design.

Start variant-->info pack-->dtp to DSO-->dso data activation--->delete index--->dtp to cube--->create index--->rollup.

If you want see how much time taken by your chain then do like this.

Go to your chaiin at RSPCM or RSPC

Click on your chain, select start variant--> display ,message--> see here start time.

later go to same chain, last step, example as roll up --> rigth click-->display message, see the end time.

Thanks