SMARTFORM CRM - access to PCAT item - UPDATED

[Former Member]

Hi,

I need to be able to access some details from the pcat area on a smartform. We are using CRM 5.0.

I am looking for an example of how you would config the smartform to connect to the pcat area and return a customised description. We need to do this as we are only displaying the TEXT_0002 on the webshop not sales text or material text.

Basically I need to do the following.

I run the smartform from the order creation process - the smartform is triggered by an output of the order.

What I need to do is the following

1. go to table COMM_PRODUCT and run an ABAP query something like

select PRODUCT_GUID from COMM_PRODUCT where PRODUCT_ID = ORDERLINE_PRODUCT

2. Then I need to use the value from above to run the following code from table COMM_PCAT_ITM

select GUID from COMM_PCAT_ITM where OBJECT = RESULT_FROM_1_ABOVE

3. Then I need to pass the result of 2 to an RFC called COM_PCAT_ITM_GETDESCRIPTION_0

return TEXT_0002 where IV_ITEMGUID = RESULT_FROM_2_ABOVE

would appreciate anybodies thoughts on this as it is puzzling me.

Cheers, Paul

[Former Member]

going to perform the update from the sales order exits - see other question