Update price list fields in SAPB1 HANA to stop integration events

Update price list fields in SAPB1 HANA to stop integration events

** Internal Purpose 

Environment : 

iVend 6.6 with SAPB1 HANA

Problem Statement : 

​
Customer has many price list in SAPB1 which are already integrated with iVend . but after initializing, there is need to stop the Integration Events of particular Price Lists in SAP B1 HANA

Symptoms :


 Customer has many price list in SAPB1 which are already integrated with iVend . but after initializing, there is need to stop the
  

Resolution : 

In the Price List Master of SAP B1, There is field called as "Retail Price List".
If the "Retail Price List" value to is set to 'N', then Integration will not consider that price list.

However, value cannot be changed from the User Interface so it has to be updated through SQL.

select U_CXS_RPCL, * from OPLN

So need to update the field "U_CXS_RPCL" to 'N' for the corresponding UDF for which Integration events are to be stopped