cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BUSINESS ONE - LANDED COST PARAMETER - MANDATORY

former_member185296
Active Participant
0 Kudos

Hi experts,

Is it possible to make certain landed cost parameters a mandatory on in landed cost documents.

Regards,

Vinoth

Accepted Solutions (1)

Accepted Solutions (1)

narayanis
Active Contributor
0 Kudos

Hi,

You can write stored procedure under the following path

Database --> Programmability --> Stored Procedure --> SBO_SP_TransactionNotification

Right click SBO_SP_TransactionNotification and select modify.

You will get a template wherein you can frame the logic.

https://blogs.sap.com/2009/05/22/the-sptransactionnotification-stored-procedure/

Above link will help you for the same.

Regards

Narayani

Answers (3)

Answers (3)

narayanis
Active Contributor
0 Kudos

Hi,

I just had a simple currency check on the landed cost document. The currency should not be INR.

if @object_type = 69 and @transaction_type in ('A' , 'U')

Begin

if exists(select * from oipf where oipf.docentry = @list_of_cols_val_tab_del and oipf.doccur = 'INR')

Begin

Set @error = -51

Set @error_message = 'Incorrect Currency'

End

End

when tried to add the document with INR as a document level currency, SPTN flashed 'Incorrect Currency' message.

hope this will give you an idea to frame the logic.

Regards

Pradnya

former_member185296
Active Participant
0 Kudos

Hi,

I want to make some 3 to 4 landed cost parameter as mandatory, can you share the stored procedure for the same.

Regards,

Vinoth

narayanis
Active Contributor
0 Kudos

Hi,

Frame your logic in SPTN on landed cost's document. SAP will validate it before saving.

If the conditions mentioned therein are satisfied, the document will get saved else it will warn the user with appropriate message.

Regards

Narayani