Skip to Content
avatar image
Former Member

How to create and display in page 2

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 17, 2006 at 02:56 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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