within. A possibility to determine the source currency can be through a infoobject characteristic. . Maintain exchange rate types. (each infoobject can only have one). Once we have the translation type ZAM_USD defined, we can use the same in the query designer. Exchange rate types forex swift code are stored in table tcurv and can be maintained through transaction OB07. Maintain currency translation ratios. The currency translation type ZAM_USD is now created. Exchange rate types are standard exchange rates available in the SAP system.
A translation type is a combination of different parameters that establish how the exchange rate for the translation is determined. The parameters that determine the exchange rate are the source and target currencies, exchange rate type and the time reference for the translation. Hi, My requirements with regards. BW report are on, currency Translation.When a user executes the report, At selection screen of the reportUser want any.
Currency translation type sap bw
Steps for currency conversion in the data load. From a business users view, exchange rates/Currency translation ratios, to exchange currencies there is a exchange rate respective a currency translation ratio necessary. Kindly advise how I can get this. In the currency drop down, select fixed target currency as USD and select from conversion. Type target currency as USD, save the query. Even if generic datasources are used. At the time of the exchange, during the query runtime, this InfoObject which contains the exchange rate type must be present. Exchange rates are related to a exchange rate type meaning each exchange rate is stored to one or more exchange rate types which allows to translate by the bid rate, ask rate or middle rate. The variable key date is dependent on a date that is derived from a standard infoobject or a special infobject. Say for example, zamnt_USD. Maintain a conversion type, exchange Rate Type, this setting determines to what exchange rate type the exchange shall happen. Define a target info object say zamnt_LC for this field in the BW system with amount type key figure and unit as local currency.