Skip to Content
avatar image
Former Member

Hi . Please help me how to implement this piece of code in SAP BODS


if IsNull(INPUT.ZINB_OUTB) then ((if Not(IsNull(INPUT.DELIV_NUMB)) then (if Not(IsNull(INPUT.DOC_NUMBER)) then 'OUT' else 'INT')
else (if Not(IsNull(INPUT.DOC_NUM)) then 'INB' else 'INT'))) else (INPUT.ZINB_OUTB)

Please help me how to code this piece in SAP BODS .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 17, 2017 at 06:24 AM

    Hi,

    This will work.

    ifthenelse( nvl(INPUT.ZINB_OUTB,'') ='',

    ifthenelse( nvl(INPUT.DELIV_NUMB,'') <> '',

    ifthenelse( nvl(INPUT.DOC_NUMBER,'') <>'', 'OUT', 'INT'),

    ifthenelse( nvl(INPUT.DOC_NUM,'') <>'', 'INB','INT')),

    INPUT.ZINB_OUTB)

    Thanks,

    Rk

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 17, 2017 at 09:36 AM

    Check below ifthenelse logic. You can also use decode() function

    ifthenelse(INPUT.ZINB_OUTB IS NULL,ifthenelse(INPUT.DELIV_NUMB IS NOT NULL,ifthenelse(INPUT.DOC_NUMBER IS NOT NULL,'OUT','INT'), ifthenelse(INPUT.DOC_NUM IS NOT NULL, 'INB','INT')),INPUT.ZINB_OUTB)

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded