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

How to retrieve the following product charateristics

Hi All,

I am looking at retrieving all the product no's by giving Category or Item Category group as the selection parameters.

For Eg. I would want the system to show me the list of products created under Category - MAT_SERVICE or I would want the system to show me the list of products belonging to Item Category group DIEN.

Any clue how can I do tht?

Kind Regards

Mahesh

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2009 at 10:10 AM

    Hi Mahesh,

    in case you want to get Category ID as Search Creteria on UI.Then,

    There are a few standard fields available as the Search Criteria.These are:

    Product Description, Category ID,Category Description,Alternative ID Type,Alternative ID,Configurable,Distribution Channel ID,Product Hierarchy ID,Product Type,Sales Organization ID and Status are the Standard fields.

    To display Category ID on search Criteria,You can go to the component PRD01QR ,view PRD01QR/Search and mark CATEGORY ID as Displayed.

    Hope this is helpful.

    Vijayata

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 12, 2009 at 11:18 AM

    Hi Mahesh,

    If you are searching in CRM then use the table COMM_PRPRDCATR.

    Pass the CATEGORY_ID and you will get the PRODUCT_GUID.

    From PRODUCT_GUID you will get the product form the table COMM_PRODUCT

    Regards,

    PePe

    Add a comment
    10|10000 characters needed characters exceeded

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.