Skip to Content
author's profile photo Former Member
0
Former Member

Reference Table and field for currency field?

Posted on Oct 26, 2006 at 01:17 PM 175 Views

Hi All,

whats the purpose of giving a Reference Table and reference field while adding a currency field in a table?

Thanks,

Rakesh.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 26, 2006 at 01:21 PM
    2

    Hi

    The reference field is used for the output, the output/input format of a currency field depends on the value of its reference field.

    For example if you create a screen using the field KONV-KBETR :

    the reference field is RV61A-AWEI1:

    if you set RV61A-AWEI1 = 3

    the value in KONV-KBETR is beeing shown with 3 decimals

    So you could see 3,000 but this value is automatically stored as 30.00

    if you set RV61A-AWEI1 = 2

    the value in KONV-KBETR is beeing shown with 2 decimals

    All this convertions are automatically made in according to the value setted in reference field.

    You can see this using the statament WRITE with options CURRENCY, try this:

    PARAMETERS P_KBETR LIKE KONV-KBETR.

    WRITE: P_KBETR CURRENCY '3'.

    WRITE: / P_KBETR CURRENCY '2'.

    WRITE: / P_KBETR CURRENCY '1'.

    Max

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Ravikanth Talagana
    Ravikanth Talagana
    Posted on Oct 26, 2006 at 01:20 PM
    0

    Hi rakesh,

    Based on the Currency field that we specify there, the input/output formatting(What character is to be used for thousands separator and decimals separator etc) would be decided for that amount field.

    Regards,

    Ravi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 26, 2006 at 01:27 PM
    0

    H i Rakesh,

    this takes care of the particular currency format ..

    suppose say

    in india the format is 1,000.00 rs ..

    we know that its true and our format is like that .

    usa system has 1.000,00

    now how are u going to differentiate between the two ..

    and how the system understands that ..

    so this is the reason we refer to the table when giving currency ..

    hope this helps

    regards,

    Vijay

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.