Skip to main content

Posts

Showing posts from May, 2022

BAPI for currency conversion and exchange rate calculation

Below is the BAPI to be used for converting from one currency to another currency based on the exchange rate on a specific date. Below are the parameters to be passed to fetch the required information.   CALL  FUNCTION  'BAPI_EXCHANGERATE_GETDETAIL'        EXPORTING         rate_type   = <Exchange rate type >         from_curr   = <From Currency>         to_currncy  = < 'Currency'>          date        = < Date >        IMPORTING         exch_rate   =  < >          return      = < >     

[SAP SD] Storage location determination at sales order level

 As per standard SAP, storage location cannot be determined automatically at the sales order level. At times, there will be a requirement where businesses want storage location to be determined automatically at the sales order level. Follow the below steps to accomplish the requirement. 1. Create a new custom table to maintain the combination or parameters of storage location determination 2. write the logic in the Include MV45AFZB, EXIT : USEREXIT_CHECK_VBAP to call at sales order level

SQVI Query

At times, businesses will ask for a report based on the table extract of single or multiple tables. As this is a direct table extract, we need not take the help of a developer to extract the data from the tables. SAP has given a provision to generate this kind of report by functional consultants rather than taking the help of the technical team. This report extracts by the functional team will be done with the help of SQVI and SQ01 queries. SQVI query created by a user cannot be accessed by another user ( User Dependent) SQ01 query created by a user can be accessed by other users based on the user group ( User Independent) SQVI queries in general will be generated by the business and consultants will mostly assist business users. But at times, consultants use the SQVI query to extract specific data in a quick way as per business needs and then subsequently extract them to excel and provide the required information to business users. If business insists on the query access for the SQVI,