Skip to Content
0

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

Apr 24, 2017 at 03:27 PM

203

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
DIEGO LOTHER Apr 24, 2017 at 04:03 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Diego,

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

Kind Regards,

Alexandros Karadimitropoulos

0