topic MONI table data encoding logic in Application Development and Automation Discussions

MONI table data encoding logic

Former Member — Wed, 16 Feb 2005 07:44:00 GMT

Hi All,

I want to know how the MONI table data is encoded. Where can I find this information?

For background, I want to extract transaction usage information from MONI. I do not want to use any SAP report for that. I want to pull data directly from MONI and do custom decoding of that data.

Thanks in anticipation,

Nitin

Message was edited by: Nitin M

Re: MONI table data encoding logic

Former Member — Wed, 16 Feb 2005 08:53:01 GMT

Hi Nitin,

I presume that you refer to the last field in the structure (which is a raw data field).

You must define a structure like this:

data:
  begin of statx occurs 100.
      include structure mdstats.
data: mddat like mdkp-dsdat,
      ezeit like rm61x-ezeit,
      plobj like cm61x-plobj,
      puwnr like cm61x-puwnr,
      werks like cm61x-werks,
      paral like rm61x-paral,
      versl like rm61x-versl,
      plmod like rm61x-plmod,
      trmpl like rm61x-trmpl,
      uname like umd01-uname,
      btmod like am61x-flg01.
data end of statx.
data stats like mdstats.

After this you you fill the structure with data like this:

*--> Read MONI
select * from moni where relid = 'MD'
                     and srtfd > datum
                     and srtf2 = 0.
  catch system-exceptions conne_import_wrong_comp_type = 09.
    import cm61x-plobj cm61x-puwnr cm61x-werks
           rm61x-paral rm61x-versl rm61x stats
           uname mandt btmod
           from database moni(md) id moni-srtfd.
  endcatch.
*--> Use only actual client
  check mandt eq sy-mandt          "from rel 46A
     or ( mandt eq space
          and uname is initial ).  "before
  if sy-subrc = 9.
*--> read from 30-Structure
    perform import_30 changing stats.
  endif.
*--> transfer
  mddat = moni-srtfd(8).
  move-corresponding stats to statx.
  move mddat to statx-mddat.
  move rm61x-ezeit to statx-ezeit.
  move cm61x-puwnr to statx-puwnr.
  move cm61x-werks to statx-werks.
  move rm61x-paral to statx-paral.
  move rm61x-versl to statx-versl.
  move rm61x-plmod to statx-plmod.
  move rm61x-trmpl to statx-trmpl.
  move uname       to statx-uname.
  move btmod       to statx-btmod.
  move cm61x-plobj to statx-plobj.
* Number conversion
  statx-readt = statx-readt / 1000.
  statx-lotst = statx-lotst / 1000.
  statx-explt = statx-explt / 1000.
  statx-schet = statx-schet / 1000.
  statx-arbpt = statx-arbpt / 1000.
  statx-einzt = statx-einzt / 1000.
  statx-postt = statx-postt / 1000.
  statx-mdtbt = statx-mdtbt / 1000.
  statx-rqitt = statx-rqitt / 1000.
  statx-resbt = statx-resbt / 1000.
  append statx.
endselect.
*-----------------------------------
form import_30 changing stats_40 like mdstats.
  statics:
  begin of stats,
    anzmt like mdstats-anzmt,
    rtime like sy-uzeit,
    plafi like mdstats-plafi,
    plafu like mdstats-plafu,
    plafd like mdstats-plafd,
    ebani like mdstats-ebani,
    ebanu like mdstats-ebanu,
    eband like mdstats-eband,
    ebanl like mdstats-ebanl,
    resbi like mdstats-resbi,
    resbu like mdstats-resbu,
    resbd like mdstats-resbd,
    resbl like mdstats-resbl,
    mdsmi like mdstats-mdsmi,
    mdsmu like mdstats-mdsmu,
    mdsmd like mdstats-mdsmd,
    mdlpi like mdstats-mdlpi,
    mdlpu like mdstats-mdlpu,
    mdlpd like mdstats-mdlpd,
    kbedi like mdstats-kbedi,
    kbedu like mdstats-kbedu,
    kbedd like mdstats-kbedd,
    kbkoi like mdstats-kbkoi,
    kbkou like mdstats-kbkou,
    kbkod like mdstats-kbkod,
    readt like mdstats-readt,
    lotst like mdstats-lotst,
    explt like mdstats-explt,
    schet like mdstats-schet,
    postt like mdstats-postt,
  end of stats.
  clear stats_40.
  import cm61x-plobj cm61x-werks paral stats
         from database moni(md) id moni-srtfd.
   move-corresponding stats to stats_40.
endform.

Actually this is an excerpt from form select_data in program RMMDMONI.

Hope this helps you.

Regards,

Rob.

Re: MONI table data encoding logic

Former Member — Wed, 16 Feb 2005 09:14:01 GMT

Hello Nitin,

I see that this is your first post here and would like to welcome you to SDN.

Coming to your question, there have been some discussions on this topic in the past. So I suggest that you first try to search for the inormation that you require. Here are some of the links to some of the discussions at SDN which I thought might be relevant for your purpose.

Regards,

Anand Mandalika.

P.S. : Since you are a new member here, I'd like to introduce you to the SDN Points system. Please do read the weblog https://www.sdn.sap.com/sdn/weblogs.sdn?blog=/pub/wlg/680. [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken]

Re: MONI table data encoding logic

Former Member — Wed, 16 Feb 2005 09:31:53 GMT

Thanks a lot Rob. Will see whether this helps.

Re: MONI table data encoding logic

Former Member — Wed, 16 Feb 2005 14:33:21 GMT

Hi Anand,

Thanks for the welcome.

Well I do want to give points to the answer but I cant find any star button on the page. I did read the link you had given (stuff about the points).

Regards,

Nitin

Re: MONI table data encoding logic

Former Member — Thu, 17 Feb 2005 10:23:00 GMT

Hello Nitin,

When you open a new thread, there's an option <b>Mark this topic as a question. And I promise to return and reward the answers</b>, which is selected by default.

It seems that you have unchecked this option.

1. Please edit your first message (by clicking the pencil icon) and mark the post as a question.

2. Save the message.

3. Now again get into the thread and you will find the stars.

4. Reward each answer that has helped you, as you deem appropriate.

By the way, have been able to obtain the information that you needed?

Regards,

Anand Mandalika.