How to write IF-THEN-ELSE in query (syntx)

[Former Member]

Dear Experts,

As the decode syntx is Oracel's, is there any syntx could be used for IF-THen-Else function in query generator?

Thanks.

Emily

[Former Member]

Hi

Can you explain more clearly?

Thanks and Regards

[Former Member]

Hi, Luis,

I am seeing the table-OINM, Ref1 (GR# or PL#) and TransType (15 for Out, 20 for In), how could I create query report, to show when TransType 15, then the Ref1 means PL#, and TranType 20, then the Ref1 means GR#...

Thanks.

Emily

[Former Member]

Dear Experts,

Where I can find the list of Bulit-IN Syntx for query generator?

Pls kinldy advise.

Thanks.

Emily

[Former Member]

Hi,

Did u tried case statement?

U can refer below link.

[http://www.orafaq.com/faq/how_does_one_implement_if_then_else_logic_in_a_select_statement]

-Gouri

[Former Member]

Hi, Gouri,

But, how to write case in Query of SAP? As the link also mention decode that can;t be used in SAP query??

Thanks.

Emily

[Former Member]

Morning, Gouri,

It works!! Thanks very much!

BTW, in Inventory menu, the report 'Inventory Posting List, does it pull data from table 'OINM' ?

It looks like OINM does not link with tables of ODLN (PL/delivery) and OPOR (PO), is it correct?

If I would like link OINM to ODLN and OPOR, which table interrelated between them??

Pls kinldy asdvise.

Thanks in advance.

Emily