cancel
Showing results for 
Search instead for 
Did you mean: 

how to change the powl query objects for shopping carts

andy201969
Explorer
0 Kudos
316

version of the SRM System is 7.4

we would need to change to query Shopping carts in the section "Shopping area".

This means we want to remove all item-based columns, only the SC header infromation should be shown in the query.

some technical details:

MASTERQUERY SRMNXP_SC_01_01

TYPE SRMNXP_FEEDER_SC

APPLID SRMNXP_E_SC

the try to personalize the quiery hasn't helped because customer needs a solution fro all its users and I have been faced with duplicate rows.

Does anyone knows how to handle the issue?

Thank you very much

Andreas

Accepted Solutions (0)

Answers (1)

Answers (1)

daniel_marlen
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Andreas,

Per standard design SC POWLs are item based. You can change the columns (field catalog) in /n/SAPSRM/POWL_CUST based on Wiki page https://wiki.scn.sap.com/wiki/x/lgK1G. But even if you remove all item fields, system will handle the result at item level, so if an SC has 2 items, system will show two lines for that SC.

In case of Webdynpro SCs, there is a header-based feeder class that could be used for this purpose that you can change in POWM_TYPE transaction. The standard is /SAPSRM/CL_CLL_PWL_A_SC and the header-based in /SAPSRM/CL_CLL_PWL_A_SC_H. But there is no header-based feeder class for UI5 SCs. So the easiest way would be to remove the duplicated lines is using BAdI /SAPSRM/BD_POWL_CHNG_SELCRIT (Wiki page https://wiki.scn.sap.com/wiki/x/noWhG).

Best regards,

Daniel