Tables for materials and services in SRM

[Former Member]

Hello,

In what tables can I find the information of materials and services of the COMMPR01 transaction, especially the Orderunit-field?

This field is not stored in the COMM_PRODUCT table.

Thanks,

Aart

[Former Member · Accepted solution]

Thanks Jagadish,

I looked at the tables but I can not figure out how I can get from the product GUID (product from COMM_PROD) to the correct Orderunit of the material in the COMM_PR_PUR_1 which has the ID of an order set?

Thanks,

Aart

[Former Member · Accepted solution]

Hi,

Using the Product GUID ,get the fragment GUID from table COMM_PR_FRG_REG.Then using the FRAGMENT_GUID get the ORDER_UNIT from table COMM_PR_PUR_1.

BR,

Disha.

[Former Member · Accepted solution]

Link tables COMM_PR_UNIT and COMM_PRODUCT by using PRODUCT_GUID field and read UNIT from COMM_PR_UNIT.

Otherwise use table COMM_PR_FRG_REG as mentioned by Disha.

Regards,

Jagadish

[Former Member]

Aart,

Use tables COMM_PR_PUR_1 or COMM_PR_UNIT to get order unit details.

Regards

Jagadish