Could you please let me know a way to join ESTDH table with ESTMJ table

[surajhny]

I have a requirement where I need to create a report

Wherein I need to find records in ESTDH table with report status as 'W7' and check if the materials associated to a specific is extended to a plant or not

So I'm planning to join ESTDH table with ESTMJ ..kindly let me know if this is the right method and also how do I join ESTDH with ESTMJ

[christoph_bergemann]

Hello

there is no direct relationship between ESTDH and ESTMJ.

Any "report" (either of type "IBD" or of type "SBR") is managed in ESTDH. ESTDH is linked to ESTRH. Linked to ESTRH is ESTMJ

Normally any user uses the SAP transaction Cg54 / Gg50. As soon as the user has generated the so called "report tree" the user can switch between "specification view" and "material view".

In the material view you can see the "related report" (as managed in ESTDH

C.B.

PS: for details: Please check online help (how to use CG54 and CG50)