Skip to Content
avatar image
Former Member

WWI Generation is creating thousands of records in DRAO

Hi All,

We are experiencing an opportunity right now where our DRAO table is growing at an alarming rate. We went live on EHS last October and in the last 8 months our DRAO table has had over 13.5 million records generated. When I create a single WWI report, there are over 2,000 records being generated in that table. Has anyone else run into this? We realize that doc types SBE and SBR are not set to KPRO and we're considering that change, but we're concerned the same problem will occur in the content server. Any help would be appreciated.

Thanks,
Jason

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 17, 2013 at 10:18 PM

    Just as an update to anyone reading this post, the reason for all the records in the DRAO table is that SAP stores SBR records in this table in chunks of 25 KB, therefore a 7 MB report will be around 2,000 - 3,000 records. If your graphics are large, the records could be large. We've decided to convert all records in this table to our DMS via DMS_KPRO_COVERT. We've also changed the configuration in our SBR doc type and EH&S to store the newly created SBR docs using KPRO. There are several notes that can be found by searching KPRO in the SAP Notes search to get your config correct for using KPRO.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 03, 2013 at 08:02 PM

    Dear Jason

    can you kindly check "DRAO"? I assume that the problem is related to reports of typE "SBE" and not "SBR". This topic is independent of use or not use of KPRO and similar tools.

    I assume topic is related to "SBE" once. Check your customizing set up . There is a customizing paramter which you can use to decided if or if not SBE need to be stored. Normally you do not store SBEs. If you use tools as KPRo etc. then you "move" only the document.

    C.B.

    PS: check e.g. http://scn.sap.com/message/8090182 or similar threads.

    Add comment
    10|10000 characters needed characters exceeded