Skip to Content
avatar image
Former Member

Add new two columns dynamically based on Currency


Hi,

my requirement is in script form , if foreign currency is used in input i want add two new columns in layout with local currency Per Unti Price and Total Amount of local currency script is related Tax Invoice , Debit and Credit Note.

if local currency is used then only three columns are appeared those are Quantity , PerUnitPrice and Total Amount

Please help me.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jan 09, 2015 at 11:09 AM

    Hi

    You need to create 2 different text element: one for local currency and one for foreign currency


    Mac

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 10, 2015 at 06:35 AM

    Hi Max,

    Thanks to replay,

    step1: i have one window like Header to display Heading details those are Description and Price.

    now i want display Headings based on condition

    IF BKPF-WAERS NE 'MYR'.

    Description   Quantity   Per Unit Price(USD) Per Unit Price(RM)   Total(USD) Total/Price(RM)

    ELSE

    Description   Quantity   Per Unit Price Total/Price

    step2 :

    on same currency condition i want dispaly values under whcih is i given above headings

    present Description  Total/Price are printing.

    If foreign currency is used then i want display Local currency Total and Per Unit Price.

    Per Unit Price = Quantity/Amount

    Total(RM) = USD Total  * Exchange Rate

    Exchange Rate printing some where else .

    My question is can i print values based on currency condition in MAIN Window.

    If possible give me some sample examples

    Reward for all helpfull answers

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi

      you should create a text element for local currency and one for foreign currency:

      Ex:

      Description                   Quantity                PerUnitPrice

        Test Data                    100 PC                       10000

      Ex Code:

      /:500

      &gv_tdline_new&

      /: 501

      &bseg-menge&

      /:502

      &wa_itab-uprice&

      so you should have:

      /:500 &gv_tdline_new& &bseg-menge& &wa_itab-uprice&

      Max

  • avatar image
    Former Member
    Jan 24, 2015 at 12:55 PM

    Thanks you very much for your response

    Add comment
    10|10000 characters needed characters exceeded