item category

[Former Member]

Hello,

i am creating some report which reads purchase orders and items in them. I need to know how can i find the item category - i read PO in table crmd_orderadm_h, then i can read crmd_orderadm_i (parent = guid of po) and now i need to know the category...

thanks

JJ

[Former Member · Accepted solution]

Hi,

Try to use that these tables:

COMM_PRODUCT for product ID and GUID

COMM_PRPDACTR for map product to category

COMM_CATEGORY for category

Example:

select * from prod~comm_product
into ls_table
from comm_product as prod
inner join comm_prpdcatr as prpd
on prod~guid = prpd~product_guid
inner join comm_category as cat
on prpd~category_guid = cat~guid
where prod~product_id = lv_productid.

The category is in table BBP_PDIGP (CATEGORY and CATEGORY_ID fields) you can get this fields from FM BBP_PD_SC_GETDETAIL or BBP_PD_SC_ITEM_GETDETAIL

Regards,

Marcin Gajewski

[Former Member · Accepted solution]

Hi,.

i tried to use the tables u wrote.

But with mapping in table COMM_PRPRDCATR i have two records for one product. How is it possible? (i dont know how srm exactlz works so this question is propably simple

thanks

JJ

[Former Member · Accepted solution]

Hi,

This is because product may have hierarchy.

If you want to get category details (for example description) use only table COMM_CATEGORYT and fill CATEGORY_GUID (from SC item or PO item).

in this table SAP stores all Product Category description.

Regards,

Marcin

[Former Member]

I believe, you should use FM <b>BBP_PD_PO_GETDETAIL</b> - you can check E_ITEM - you will get all your required data (Product category too).

Regards,

Shiv