on 11-01-2016 8:15 PM
Hi experts,
Is it possible to make certain landed cost parameters a mandatory on in landed cost documents.
Regards,
Vinoth
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.