Skip to Content
0
J B
Dec 01, 2020 at 10:40 PM

How to use built in condition TYPE_OF syntax in selection condition to check pattern of value

57 Views

Hi experts,

I have a query in writing the syntax for selection condition using built in TYPE_OF condition. My requirement is to select the BOM items if a characteristic value is having the expected pattern in its 1st 4 characters like example if my characteristic value of ATNIN is 123GH901010..then in my selection condition I need to check if the value has the 1st 4 characters as '123G' if it matches then I will fetch the BOM item. But I am unable to form the syntax for this scenario as there is no object key defined for tables CABN or CAWN in SPRO classification. Request for inputs