How to Get only an Active Products by web service (QueryMaterialIn) from SAP C4C?

[Former Member]

Hi Experts,

In C4C there are 2 kinds of Products 1) Active Products 2)Blocked (Obsolete Products)

I am able to get overall products by queryMaterialIn Service in Soap UI tool.

But I am getting blocked (OBSOLETE) Products also.

How do I restrict that.

could you please suggest me how to sort it out this issue.

Thanks and Regards

Santosh K

[HorstSchaude · Accepted solution]

Hello Santosh,

As the selection parameter do not contain the "ProductStatusCode/LifeCycleStatusCode" it is not possible to restrict the selection.

Sorry,
. Horst

[Former Member · Accepted solution]

Oh I see.

Thank you Horst.

Then Can we delete/remove obsolete product?

[HorstSchaude · Accepted solution]

Hello Santosh,

AFAIK you can only call the action "Block" which sets the status in such a way that this product can no longer be used in any process.

For more details please have a look into the Repository Browser or ask the Product guys.

HTH,
. Horst

[Former Member · Accepted solution]

Thank you Horst.