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

[Former Member]

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

[former_member497847]

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

[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

[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

[Former Member]

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

[P561888]

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.

[Former Member]

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

[former_member186399]

Hello,

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

Gajesh