How to write if and if then else in Dataservices in the field level validation

[Former Member]

Hi Experts,

Any suggestions how to write the field Validation

if (Table.fieldname is not null and Table.fieldname <>'U')

if (table.fieldname is not null then EKKN.KNTTP

elseif(Table.fieldname is not null then

EKKN.GSEBR,'')

[rajan_burad]

Hello Ram,

Your requirement is not clear but still I tried to comprehend it.

Please try below code, using decode:

decode (Table.fieldname is not null and Table.fieldname <>'U', EKKN.GSEBR,

table.fieldname is not null, EKKN.KNTTP,

'' )

Let us know if it helps to achieve the requirement!

Thanks 🙂