Skip to Content
avatar image
Former Member

Getting list of specification and associated materials assigned to specification

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 20, 2014 at 04:04 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Feb 20, 2014 at 04:07 AM

    Not sure what you mean by not desired output. Too many lines, or not displaying the expected result. Are you using CG02 search or using ABAP/SAP query? Think you already inner join the RECN column for the two tables.

    Maybe you need also to check if you filter out those marked deleted.

    Please try to add the delete indicator in your query, and only show those not marked as "X".

    Hope this can help.

    Add comment
    10|10000 characters needed characters exceeded