Sitemap

Amicuk Programming Answers

Report painter question regarding amounts in different currencies

2015-10-11   Views:1

Advertisement

Hi, I have a report created in GRR2 using library 1VK. We display the total costs SWOG here but have the request to see in addition these costs in USD simulteanously. For that I included the basic key figure SWZG. When executing the report there is n

Hi,
I have a report created in GRR2 using library 1VK. We display the total costs SWOG here but have the request to see in addition these costs in USD simulteanously. For that I included the basic key figure SWZG. When executing the report there is now a new selection parameter Target currency, Exchange rate date and Exchange rate type. I can see a new column with USD values, so far so good. But when I check the calculation I find that it can't be right, it differs from what it should calculate.
If I execute the report and select currency tranlsation of the key figure SWOG with exactly the same exchange parameters as above I'm getting different values in USD which match my manual calculation.
Any idea why this happens? What do you recommend to have both currencies ate the same time on the screen?
Thank you
Exberliner

The replay answer
Advertisement
hii sanjeev.
try this,
FM - > spell_amount
OR
data: words(50) type c.
call function 'HR_IN_CHG_INR_WRDS'
     exporting
          amt_in_num   = '100000'
     importing
          amt_in_words = words.
write:/ words.
OR
RF_SPELL
rgds
anver

Go to See the other 6 answers

Report painter question regarding amounts in different currencies

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have a report created in GRR2 using library 1VK. We display the total costs SWOG here but have the request to see in addition these costs in USD simulteanously. For that I included the basic key figure SWZG. When executing the report there is n[More]

Report Painter question (FGI1) How to limit output up to a specified period

Category:DefaultRelease time:-0001-11-30Views:130

Hello I have a report painter question. I am trying to create a BS report using tcode FGI1 (FALGFLEXT), that lists out the BS values by month (Jan - Dec). But the problem I am coming across is, if I specify selection parameter 01 2008, the report als[More]

Report Painter - new Basic Key Figure for Currency Translation

Category:DefaultRelease time:2015-10-11Views:130

Hi, I need a report painter report which allows to translate the company code currency HSL in GLPCT into several target currencies. Theoretically I need to translate each month with an own translation rate and possible different translation keys. In[More]

Report painter question FI-GL or FI-SL?

Category:DefaultRelease time:-0001-11-30Views:130

Hello I have a general question on reports created via report painter. I want to create a BS & PL report to see balances by month, and am trying to determine considerations to take into account. Creation of a report where I can see the balance of an[More]

Report Painter Questions

Category:DefaultRelease time:-0001-11-30Views:130

Hello, I am new to SAP and this forum and have been put in charge of report development for Finance for our organization.  I have been delving into report painter on my own with no official training on it and have a few questions I can't seem to find[More]

Report painter question

Category:DefaultRelease time:-0001-11-30Views:130

Hi In our old reports , when I  double click the column (GRR2), I see a pop up for selecting the characteristics’ see some characteristics attached to the column. The mystery to me is there "Record Type" char is selected twice and have different[More]

Including Second Local currency in Report Painter

Category:DefaultRelease time:2015-10-11Views:130

Hi there, My client is using parallel currency and their LC2 is USD.  I am trying to create a Cost centre report using report painter and want to add LC2 amounts in this report.  Is it possible to add LC2 using report painter? The following is some a[More]

Parallel currency in Report painter

Category:DefaultRelease time:2015-10-11Views:130

Hi I need help around the Report Painter report. One of our company code is located in Hong Kong and there are three currencies set-up for this entity. Local currency is CNY, Group currency is in USD, and Third currency is in HKD. Our report painter[More]

Display the values in Docment Currency in Report Painter-FDI4

Category:DefaultRelease time:2015-10-11Views:130

Hi, Am new to report painter. i created report painter in FDI4. this report is to display the due amount. when i click on table cell, which is amount field . Am chosen cell type as 'Select with Key figure' option . After then i try to select key figu[More]

Currency in Report painter

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have a question about report painter. Is it possible to create a report with report painter that displays the information in a currency different from operating concern currency? For example, in KE24 I can display the value fields in the entry[More]

Report painter- Amount in Document currecy instead of LC

Category:DefaultRelease time:2015-10-11Views:130

Hi,    Am new to report painter. i created report painter in FDI4. this report is to display the due amount.    when i click on table cell, which is amount field . Am chosen cell type as  'Select with Key figure' option .    After then i try to selec[More]

Hot
Hi, I am using a Pixma iP4200 printer and have no problem printing borderless but now I want to brint WITH borders. In iPhoto I go to page setup and choose my iP4200 and 4X6. However, when I got to print I get an error message as the preview picture. [More]
So I have a quick question... I've been using my external HD to house my iTunes library for over a year now. No issues, it's been working great. When I add new music to my library on my computer, it copies the files to my HD, or just reorganizes the [More]
can anyone please write up a program that uses an array of random numbers from 0-100 and sort them out... if anyone can help me that would be great...i tried but i cannot figure it out... please just write the program so I just have to copy and paste [More]
Greetings, I am writing an interface to a product using OCI API's. I have a question about designing this interface. If we are able to successfully establish connection with Oracle databae and the query takes long time to execute/OCIStmtExecute(), is [More]
i nedd convert a type Date to Calendar or how can increment a Date value in relation with the int value? Help me pleaseCalendar has a setTime(Date) method, I think. You could look it up, I'm just going from memory. So create a new Calendar object and [More]
I am currently working with a client based in Berkshire who are looking for 7 In Dev Test Engineers to join their growing team. They are looking to hire 100 new staff by the end of the year. They are working on one of the most exciting projects in th [More]
Hi, I imported a catalog from my laptop into a catalog that I have on an external hard drive. This has now resulted in two images of the external drive under the folder list in the Library view. You can see there are two folders called Oxford (which [More]
greetings Flash gurus, anytime i rotate a bitmap image, it gets VERY crunchy. the edges are especially noticeable (although it is clear that the entire image gets affected). this happens even with high quality mode set for the resulting swf. the resu [More]
I have iPhoto 6. Is there any way I can lock / secure / password protect 1. film rolls within the Library 2. Specific Albums and Slideshows I have created? Thank you, HDPHDP, There is a Mac 101 tutorial that may help. Try this page first, then scroll [More]
I have used avi video in Premiere CS4 and had no issues. Now that I have upgraded to Premiere CS5 my avi videos are shakey/jumpy before and after rendering them. What is wierd is when I nest an avi video from an old CS4 project and imort it into my C [More]