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

Search materials based on itemcategory??

Hi,

How can search materials based on item category search.

i could find sales documents with item category search(VBAP, T184), but i need some one help to find materials in the system based on item category search.

Regards

Siddiq

Message was edited by: G Lakshmipathi

Please use the subject effectively

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2013 at 12:44 PM

    Hi,

    As per my understanding,You cannot find material based on item category..

    In a sales order item category determines based on the item category determination procedure

    Sales doc type+item category+higher lev Itemcategory+item cat Usage

    Once any transaction happened like sale order.Then you can find the item category of material in that sales order.

    Raneesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Siddiq,

      As rightly mentioned other experts and you VBAP is the table for this.

      What you can do is to create a custom table and a program to populate the table from standard, table should have only desired fields and get the same populated from standard tables.

      Now provide a selection screen before running the report, which will be having item category as input field.

      This is the only workaround for giving users what they want in your case or else you can convince them otherwise for scrapping this requirement altogether 😊

      Rgds

      Sourabh

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.