Incoming Payment FMS error "Internal error (3006) occurred [Message 131-183]"

[former_member232354]

Dear Experts,

We are using SAP 9.2 PL05 and have created a UDF field (nvarchar(10)) in RCT2. In this UDF field, we would like to get a value from OINV (UDF). So, in every line we would have the values (01, 02, 03 or 04).

The used FMS is

"DECLARE @DocNum INT

SET @DocNum = $[$ORCT.DocNum]

DECLARE @DocEntry INT

SET @DocEntry = (SELECT DocEntry FROM RCT2 WHERE DocNum = @DocNum)

SELECT U_Activity FROM OINV WHERE DocEntry = @DocEntry"

and receive the message "Internal error (3006) occurred [Message 131-183]".

Could you please advice?

Kind Regards,

Alexandros Karadimitropoulos

[former_member185682 · Accepted solution]

Hi Alexandros,

Try use the query below:

SELECT U_Activity FROM OINV WHERE DocEntry = $[$20.1] AND $[$20.45] = 13

Hope it helps.

Kind Regards,

Diego Lother

[former_member232354 · Accepted solution]

Hi Diego,

Thanks! I have just changed the DocEntry to DocNum and works!

Kind Regards,

Alexandros Karadimitropoulos