Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SP_Transaction Notification for Receipt from Production !!!

Hi Experts,

Can anybody help me with Stored Procedure. On batch setup window when we perform report completion from production order to receipt from production and when we add batches we have 2 field called say A and B. What I request is when this 2 field data is not same then system should throw error message when adding.

For ex: On batch setup window field A = 425 and field B = 430 then system should throw error message and do not allow to add document(receipt from Production).

Request to please advise me the stored procedure for this please.

Please find attached image for better understanding.

Appreciate for quick solution.

Regards,

Harshal Makwana

Untitled.png (70061 B)
Tags:
Former Member
replied

Hi,

Try:

IF @transaction_type in ('A') AND (@OBJECT_TYPE='10000044')

BEGIN

If exists (SELECT t0.AbsEntry  FROM OBTN T0 WHERE T0.A <> T0.B AND

t0.AbsEntry = @list_of_cols_val_tab_del)

Begin

SET @error = 1

SET @error_message = 'A & B value should be same'

End

End

Thanks & Regards,

Nagarajan

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question