Symptom
- We have a Custom table in CPQ and we are using a combination of CTX tag and Table tag to get and match the result.
- When we use the standard [IN] conditional operator it is resulting incorrect result.
For example:
Using <*CTX ( Quote.CustomField(<CustomFieldName>).AttributeValueCode )*> we are getting A1 as a value.
Using <* TABLE ( SELECT ColumnName1 FROM TableName WHERE ColumnName2= 'Value' ) *> we are getting values as A0,A1,A2 from the custom table.
- But when we use the below formula we get incorrect result:
[IN](<*CTX ( Quote.CustomField(<CustomFieldName>).AttributeValueCode )*>,<* TABLE ( SELECT ColumnName1 FROM TableName WHERE ColumnName2= 'Value' ) *>) is returning 0 instead of returning 1.
- When we use the same formula using the below formula,
[IN](A1,A0,A1,A2) we are getting the correct result as 1.
Read more...
Environment
SAP SALES CLOUD CPQ
Product
SAP CPQ 2020
Keywords
[IN] operator, IN operator, IN, CPQ, TABLE tag, CTX tag, definition, value, formula, True, False, 1, 0, [IN](value, value1, value2, value3, ...) , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.