topic Re: Table Count in Application Development and Automation Discussions

Table Count

Former Member — Fri, 25 Aug 2006 20:56:11 GMT

Hi,

I had received the following message from support team.

"We have seen stome strange anomalies in the data counts in the MARC tables. Yesterday, we counted records meeting a certain criteria in MARC in all environments:

Today, the counts are:

QAS had 498,919

DEV had 9,682,228

PRD had 504,230

We believe the counts of approx 500,000 are “correct” data.

What has happened in QAS between?Why is DEV so high?

**********************************************

I am not sure where I can find out this information and reason for this issue. If any idea please tell me.

Thanks in advance

Regards

Srini

Re: Table Count

Former Member — Fri, 25 Aug 2006 21:01:47 GMT

I don't see why this is a problem. MARC is the plant information for a material. In production you will have the latest up to date material-plant information. In QA, you may not have exact data as in production as QA is typically copied over from production periodically. This data may be what it used to be in production when they last copied. Also, during testing in QA someone might manually extend some materials to plants and that may add more records there.

Development is development and some one might have run a conversion program over and over again during unit testing and so you see so many entries.

I don't see this as a problem and in reality if your production, QA and DEV will not have similar data. I don't know why they are comparing data like this.

Re: Table Count

Former Member — Fri, 25 Aug 2006 21:16:31 GMT

Thnanks Srinivas. I just like to check the count for DEV, QA, PRD systems for table MARC. I tried with SE16, SE11 but I am not could not able to find no.of records information. Can you please tell me how we can find total no.of records. Also I would like to verify few values and compare for threee systems.

Regards

Srini

Re: Table Count

RichHeilman — Fri, 25 Aug 2006 21:25:21 GMT

Go to SE16, enter MARC for the table and continue to the next screen. Now there should be a button(Number of Entries) on the application toolbar which you can click to get the total number of records.

Regards,

Rich Heilman

Re: Table Count

Former Member — Fri, 25 Aug 2006 21:25:50 GMT

Thanks Srinivas. I just like to check the count number for DEV, QA, PRD systems for table MARC.

I tried with SE16, SE11, but I am cannot able to find no. of records option there.. Can you please tell me how we can find total no.of records.

Re: Table Count

Former Member — Fri, 25 Aug 2006 21:28:25 GMT

Thanks Rich, I was able to find Total no.of entries. I could not able to view values. I can get this information in SE16 also?

Regards

Srini

Re: Table Count

RichHeilman — Fri, 25 Aug 2006 21:30:13 GMT

Yes, on that same screen you can click the "Execute" button. This will display all the records of the table(depending on Max No Hits) at the bottom of the screen. You can enter selection here which will filter the data.

Regards,

Rich Heilman

Re: Table Count

Former Member — Fri, 25 Aug 2006 21:32:10 GMT

I am sorry, I think got values after tabl execution. Thanks Srinivas & Rich.

Regards

Srini