Skip to Content

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

Stored Procedure to set required value in UDF

Hi,

For the purpose of an external application I need to have following information in Item Master Data UDF. The UDF is [U_StockStatus] in OITM table.

If stock status is 0 then value 0

If stock status is greater than 0 then value 1

Something like in following query:

SELECT CASE WHEN T1.[OnHand] <= 0 THEN '0' ELSE '1' END FROM OITM T0  INNER JOIN OITW T1 ON T0.[ItemCode] = T1.[ItemCode] WHERE T1.[WhsCode] = '01'

My question is:

Is it possible to achieve it by Stored Procedure to set automatically mentioned values in [U_StockStatus] field when [OnHand] field from OITW changes.

If Yes

What code should I insert to SBO_SP_TransactionNotification ?

Regards

Wojtek

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question