material type in R3 to SRM

[Former Member]

Hi,

Is there any FM which return material type of material in SRM?

I tried to fetch data from table COMM_PRPRDCATR, which stores link between material and product group, I have created a internal table with fields <b><b>product_guid category_id</b></b> but select query is giving dump though the fields in internal table are defined with relevent data type required.

[Former Member]

answered.

[Former Member]

Hi

Which sRM version are you using ? What is the detailed requirement ? Are you making any report ?

<b>Anyways, Either use this Select statement to fetch the required details or go for the following Standard Function modules -></b>

<u>Here is sample code for Select statement (Inner join on standard SRM tables COMM_PRCAT and COMM_CATEGORY)</u>

DATA : iv_max_rows             TYPE bapimaxrow
              iv_filter_on_template   TYPE comt_boolean
              it_category_id_range    TYPE comt_pr_category_range_tab
              it_product_type_range   TYPE comt_product_type_range_tab
              it_object_family_range  TYPE comt_pr_obj_fam_range_t
              it_logsys_range         TYPE comt_product_logsys_range_tab
              it_non_assignable_range TYPE comt_boolean_range_tab
              ct_category             TYPE comt_category_selection_tab.

  IF iv_filter_on_template IS INITIAL.

    SELECT
        c~category_guid
        c~category_id
        c~hierarchy_guid
        c~logsys
        p~object_family
        p~product_type

      FROM comm_category AS c

        INNER JOIN comm_prcat AS p

          ON c~client        = p~client AND
             c~category_guid = p~category_guid

      INTO CORRESPONDING FIELDS OF TABLE ct_category

        UP TO iv_max_rows ROWS

      WHERE
        c~category_id    IN it_category_id_range   AND
        p~product_type   IN it_product_type_range  AND
        p~object_family  IN it_object_family_range AND
        p~logsys         IN it_logsys_range        AND
        c~non_assignable IN it_non_assignable_range.

ENDIF.

<u>Standard Function modules</u>

<b>COM_PR_CFG_CATEGORY_GETLIST</b>

<b>COM_PRODUCT_CATEGORY_GETLIST</b>

Hope this will definitely help.

Regards

- Atul

[Former Member]

Hi,

See in the T.code - commpr01 and comm_hierarchy.

All the best,

Award the point for the help.

BR,

Vijay Mittal