Skip to Content
0

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

Nov 16, 2017 at 05:17 PM

39

avatar image
Former Member


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 .

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

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

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

Share
10 |10000 characters needed characters left characters exceeded
Arun Sasi Nov 17, 2017 at 09:36 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded