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

[former_member679919]

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 .

[former_member198401]

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

[former_member521031]

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