Skip to Content

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

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,'')

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 11 at 09:08 AM

    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 :)

    Add comment
    10|10000 characters needed characters exceeded