Skip to Content
avatar image
ram nath

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

Apr 11 at 07:21 AM | 24 Views

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

SAP Data Services
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Rajan Burad
    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