How to create and display in page 2

[Former Member]

Hi,

A new requirement has come for me ... the existing form for statement of account is using RF140-WRSHB (foreign currency) to display the open items of the customer ... but when a customer is having two different currency... then the users want to display the local currency on the first page & on the second page they want to display foreign currency + local currency

for e.g ... Cust A has open item in SGD($160) & USD ($100)...

then on page 1

Foriegn currency USD - $100 <-- This is already coming ...

on page 2.

Currency | local currency

100 USD | 160 SGD <-- I need to display this... please tell me how can I do this ...

Thank You,

SB.

[gopi_narendra · Accepted solution]

CONVERT_TO_LOCAL_CURRENCY

Try this FM

call function 'CONVERT_TO_LOCAL_CURRENCY'

exporting

DATE = sy-datum

FOREIGN_AMOUNT = IS_FINAL-NETWR

FOREIGN_CURRENCY = IS_VBAP-WAERK

LOCAL_CURRENCY = 'USD'

importing

LOCAL_AMOUNT = L_AMOUNT_USD.

Regards

- Gopi

[Former Member · Accepted solution]

Hi Gopi,

I think instead of RF140-WRSHB ... I will have to use RF140-DMSHB ... field ... but I want to know how do I create page 2 ??

Thank you,

SB

[Former Member · Accepted solution]

HI SB

For creating a new page, please follow below steps:

1. Open the form in change mode via transaction SE71.

2. Select Pages from Application Toolbar.

3. Use menupath: Edit->Create Element

4. Enter details for Page and description.

With this page, now you can create page windows and print the amounts and their currencies.

Hope this helps.

Kind Regards

Eswar

[Former Member · Accepted solution]

Hi Eswar,

It is taking currency Key from BSID ... & BSID here for that customer is having 2 currency Key ... one for SGD & one for USD ... the only way to get the right currency key in page 2 is through the right BELNR ... but how do I write .. Select WAERS where

bukrs = "____ " and

kunnr = "____" and

belnr = "____".

This is what is written for Page 1...

&ULINE(71)&,,

<K>Doc.,,Doc.,,Invoice,,Text,,Amount in</>

<K>Date,,Type.,,Number,,,,&BSID-WAERS&</>

&ULINE(71)&

[Former Member · Accepted solution]

Hi,

One of the columns Text is occupying a large space ... how do I decrease the width of this column ??

-SB

[Former Member · Accepted solution]

Hi SB

Please check table BSID, if you can find any field for Local Currency. If not you can use the document number and extract the same from BSEG.

Our SAP system is currently down, so am not able to provide you the exact field.

Kind Regards

Eswar