SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

ITOB table

Former Member

‎11-26-2013 7:27 AM

0 Kudos

Dear experts,

Can any help me in understanding why there are so many line items in ITOB table for a single equipment number.

in my case a single equipment number has 1.7 million entries.

Regards,

Bala.

2 REPLIES 2

Former Member

‎11-26-2013 8:10 PM

0 Kudos

If you look at it, you will notice that it is a join of several tables with the equipment table EQUI. Each of the joined tables can have multiple records for any given equipment number. For example, EQUZ is the time sliced information about the equipment, so depending on how many time slices exist for one equipment, you will have that many rows.

Former Member
In response to Former Member

‎11-27-2013 4:30 AM

0 Kudos

Dear Advani,

Thanks for your reply. I agree to your point, it can contain that many rows as number of time slice, but how could a single equipment can contain 1.7 million line items. We have definitely never changed the characteristics of this equipment number this many times. More over i ran a table analysis of this table through TAANA and the job is still running after 12 hrs.

One more point to add when i view the content of this table i am able to scroll horizontally. but for other talbes like EABL , EQUI , i can do that..

It seems system is behaving abnormally. Can i raise OSS for the same. Please advice.

Regards,

Bala.