Table relating to Equipment number and grouping2

[former_member1284402]

hi all,

i m making a report for T-code 'IE03' and i have to display grouping2(FGRU2) in PRT data with respect to Equipment number(EQUNR), but problem is that i m not getting the table relating to both fields. can anyone please help me plz.?

regards saurabh.

[Former Member]

just start ST05 and and start the SQL trace and go to any transaction and do any activity and let the document get saved. Now again go to SQL trace screen and stop the SQL trace and then click on display SQL trace thatu2019s it. It will show you the list of all the tables which have been accessed or updated.

then check all the tables u may findout easily.

Regards,

Ajay

[Former Member]

hi,

i think ypu have not searched for it.

the Relating Tabels are:

RM63E-EQUNR

and then you can get FGRU2 from

EFHM where

EQUNR = RM63E-EQUNR

Regards,

Neha

[former_member1284402]

hi neha,

thanx for reply, actually RM63E and EFHM both are structure then how wud i take data from these structure? when i m writing the select query then its saying that its not defind in data dictionary.

please tell me ASAP.

regards saurabh.