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

[yogananda]

surajhny

Yes, it is the right approach to join the ESTDH and ESTMJ tables in order to find out if a specific material is extended to a plant or not.

To join the tables, you can use the plant, material, and material type columns as the common fields between the two tables.

You can join using a left join from ESTDH to ESTMJ, where ESTDH's plant = ESTMJ's plant, ESTDH's material = ESTMJ's material, and ESTDH's material type = ESTMJ's material type. This will allow you to keep all of the records from ESTDH and any matching records from ESTMJ.

Once you have joined the tables, you can filter on ESTDH's report status field to ensure the records have a status of 'W7' before checking if the material is extended to a plant or not on the ESTMJ table.

[surajhny]

ESTDH table does not have Plant and Material fields to join with ESTMJ? Could your please clarify on this?