Skip to Content
0
Former Member
Jan 29, 2013 at 06:21 AM

FMS Query Help

439 Views

Hi

I am using SAP B1 version 8.81 PL07

Nees help in FMS Query

I created one UDF 'SerCalNo' on marketing document. FMS on this UDF and my query is

SELECT T0.callID FROM OSCL T0 where T0.customer = (Select $[$4.0.0]) and T0.Status = -3

but it does not show any call number

I tried

SELECT T0.callID FROM OSCL T0 where T0.customer = (Select $[$4.0.String]) and T0.Status = -3

this also not showing any value

but When I use

SELECT T0.callID FROM OSCL T0 where T0.customer = (Select $[ODLN.Cardcode]) and T0.Status = -3

then it shows list of call number which are open

I want to use this FMS on 4 document Delivery, Return, GRPO and Goods return

How to write FMS query.

Thanks