Sales Order - Item Line FMS not working in CCC

[wiz_traceremo]

Hi Experts,

We have created a Formula Manager System (FMS) in the SO_Item Line, where the data is supposed to be captured from the Item Master Data (UDF). The query works perfectly in another database, but when we tried it in a database that is in CCC, it did not function as expected. Both database is in Hana.

Here’s the query we are using:

SELECT "U_Contract" FROM OITM WHERE "ItemCode" = $[RDR1.ItemCode]

Could you please advise on why this might be happening and what adjustments might be needed for it to work in the CCC database?

Thank you for your help!

[SonTran · Accepted solution]

Hi,

Try to add " for $[RDR1.ItemCode]

$[RDR1."ItemCode"]

[wiz_traceremo · Accepted solution]

It worked. thank you so much 🙂