Skip to Content
author's profile photo Former Member
Former Member

Material List for which TL is not assigned

Dear All,

Can anybody tell me a way how to find the list of materials for which the reference operation set is not assigned.

Thanks to all in advance.

Manisha

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 15, 2009 at 08:03 AM

    you can check table MAPL which gives the list of all materials to which task list is assigned. you can compare this with the list of all materials and know for which all materials TL not assigned.

    task list type would be S

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 15, 2009 at 08:14 AM

    Hi,

    You can build a SAP query in SQ01 / SQVI to meet your reqt.

    Use the relevant fields from tables MAPL and MARC.

    Ex : Task list Type

    Execute the query with the materials with the field ref operation set and then execute the same query not equal to Ref optn set and compare both the results.

    regards

    radhak mk

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      You can create your SAP query in SQVI to meet your reqt.

      Give a name and click New

      Select table join and add tables MAPL and MARC.

      Select from list both selection screen fields & Report screen fields

      Ex : Task list Type

      Execute the query with the materials with the field ref operation set and then execute the same query not equal to Ref optn set and compare both the results.

      Regards

      Jayshankar.A

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.