Skip to Content
Dec 03, 2020 at 12:55 AM

Issue in inferring char. Values from Variant table via procedure


Hi experts,

I have a scenario where I need to fetch the values of few characteristcs (reference tables, fields characteristics ) based on 2 input characteristics. For example Char A, Char B are my input characteristics and char C, Char D are output characteristics for which values should be fetched from Variant table. My issue is with char B which has additional values indicated in characteristic data and will have Blank (unfortunately) and meaningful values in Variant table.

My understanding is we cannot infer the values from Variant table even if we have any one of input characteristics entry as Blank. This char B was not made as key field in Variant table because of its additional value indicator.

Now my issue is how can I create the procedure for passing the value of char B as Blank to infer the value from Variant table? I tried using NOTSPECIFIED for char B in syntax before passing input to Variant table but it is not working.. Due to my scenario I cannot even treat char B with Blank as 000..i would like to know if there is any solution for my issue or am I missing any basics here.. Please help