Getting list of specification and associated materials assigned to specification

[former_member190809]

Hi All,

I am looking at getting a output of all the specification and the material associated with the specification.

I tried to join table ESTMJ and EHTRH to do this but this somehow doesn't get the desired output.

Any help on this would be highly appreciated.

[Former Member]

Hello DM,

Please join Field RECN Root instead of RECN, this will give you desired result. You may not need any other join such as ACTN you can avoid that.

Gopi

[former_member190809]

Tried that. Still says No data was selected

[Former Member]

Hello DM,

Try following -

Go to table  ESTMJ - Enter Material number (which you looking Specification Number) - Execute -

Copy the RECN ROOT number (from Result)

Go to table ESTRH- Enter RECNROOT number under Field RECN ROOT-  execute and get the sub ID

If this process works than try in your query Joining RECNROOT for both tables and than if you still have issue than it may be missing authorization please check

Hope this helps.

Gopi