Skip to Content
0
Nov 01, 2012 at 01:53 PM

FMS help with empty value on OSCN

199 Views

Hi,

I have created an query which should give me a result.

Problem that i have is when there is NO data on OSCN fior the specific ItemCode then they query does not give me a result. I then would actually see the result T0.SalPackMsr.

This is the query:

SELECT

CASE

WHEN (T1.U_custpack <> NULL or T1.U_custpack <> ' ')

THEN T1.U_custpack

ELSE T0.SalPackMsr

END

FROM OITM T0

RIGHT OUTER JOIN OSCN T1 ON T0.ItemCode = T1.ItemCode

Where T0.CardCode = $[$4.0.0] AND T1.ItemCode = $[$38.1.0]

Kind Regards

Mark