Skip to Content
0

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

Oct 13, 2017 at 07:55 AM

298

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

SeethaRamaiah Bharani Oct 16, 2017 at 12:41 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Gajesh Nagesh Oct 16, 2017 at 11:15 AM
0

Hello,

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

Gajesh

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 16, 2017 at 12:36 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 16, 2017 at 04:57 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 17, 2017 at 05:38 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Nanda Anantha Oct 16, 2017 at 06:39 PM
0

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

Show 1 Share
10 |10000 characters needed characters left 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

0