Skip to Content
avatar image
Former Member

Standard Table to view Record count of Active Table of a DSO

Hello,

Do we have any Standard table that displays the record count of data present in Active table of a DSO? I came across lot of DSO Tables which shows the number of records that are loaded to the DSO i.e the Transferred and Added records displaying in Manage of DSO. But i need a Table that shows the total number of records present in Active Table of the DSO.

Helpful answers will be highly appreciated.

Regards,

Aravindhan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Oct 16, 2017 at 12:41 PM

    Hello ,

    Since it is Std DSO, You can directly write the Select Count to know the number of active records on Active table of std DSO.

    BR,

    Bharani.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 16, 2017 at 11:15 AM

    Hello,

    You can use DB02 for that. It lists all the tables with memory and record count details.

    Gajesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2017 at 12:36 PM

    Thanks for your response Gajesh. My requirement is, I have to write a code in one of my Master data End routine to pick the record count of Active Table of a DSO. I cannot use DB02 for that. Please let me know any other standard table that can be used for this requirement.

    Regards,

    Aravindhan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2017 at 04:57 PM

    Thanks for your response SeethaRamaiah. If it is for one or two DSO's, I can write Select statement to calculate the Count but this is for around 60 DSO's. In such a case, I have to write Select for 60 DSO's which will affect my data load performance. If I could have a Table that has active records of all DSO's, then I can write one select statement within loop and populate the values.

    Regards,

    Aravindhan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2017 at 05:38 AM

    Hello Nanda,

    Thanks for your response. As I mentioned earlier, I do not need Transferred and Added Records, I need the record count of active table of a DSO.

    For example, let us consider a DSO has 3 active requests.

    Request No. Transferred Rec. Added Rec.

    1 1000 500

    2 100 10

    3 400 40

    The sum up of added records for this DSO is 550 (500+10+40). But the record count of the Active table of this DSO is, say 500 (since some records with same key got overlapped).

    When I check the table 'RSSTATMANPART', I get the 550 count only. But what I actually want to see is a table which will display the record count of 500.

    Thanks & Regards,

    Aravindhan

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 16, 2017 at 06:39 PM

    Hi Aravindhan,

    You can use standard table RSSTATMANPART to find active table count.

    DTA : DSO Tech name

    ANZ_RECS : Transferred records

    INSERT_RECS: Added records.

    Regards

    Nanda

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Nanda,

      Thanks for your response. As I mentioned earlier, I do not need Transferred and Added Records, I need the record count of active table of a DSO.

      For example, let us consider a DSO has 3 active requests.

      Request No. Transferred Rec. Added Rec.

      1 1000 500

      2 100 10

      3 400 40

      The sum up of added records for this DSO is 550 (500+10+40). But the record count of the Active table of this DSO is, say 500 (since some records with same key got overlapped).

      When I check the table 'RSSTATMANPART', I get the 550 count only. But what I actually want to see is a table which will display the record count of 500.

      Thanks & Regards,

      Aravindhan