Favorite Table Name

What's the table name in JDE where it stores Favorites details (App name, UBE name, Version, UserID etc...)?

Regards,
SP

That's a fun one! First you need to go to the F9000 table and enter @USERNAME in the TMTASKNM field QBE Line. Take the value in the TMTASKID field, and enter it into the TRPARNTTSK QBE Line in the F9001. Finally, take the value(s) found in the TRCHILDTSK field in the F9001, and enter into the TMTASKID QBE Line in the F9000. This will show you the Favorites details you are looking for.

Dave,

Thanks for this post of yours that I ran across today. It helped me put a favorites report together.