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

currency field

Hi,

By default SAP is maintaining one currency field. I want to know which field is that & table name etc.

please help me..

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 Jan 29, 2008 at 04:08 AM

    Hi,

    it may help u.

    You must specify a reference table for fields containing quantities (data type QUAN) or currency amounts (data type CURR).

    This reference table must contain a field with the format for the currency key (data type CUKY) or unit of measure (data type UNIT). This field is called the reference field of the output field. The reference field can also reside in the table itself.

    A field is only assigned to the reference field at program runtime. For example, if a field is filled with currency amounts, the corresponding currency is determined from the assigned reference field, that is the value entered in this field at the moment defines the currency.

    Table SBOOK in the flight model contains all the flight bookings made by customers. Field FORCURAM contains the price of the booking in the customer’s currency. Field FORCURKEY of table SBOOK contains the corresponding currency key for this price. SBOOK is therefore the reference table for field FORCURAM and FORCURKEY is the reference field for field FORCURAM.

    Regards,

    vasavi.

    kindly reward if helpful.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 04:48 AM

    hi shriya,

    In an SAP System, a currency amount field can only be used when accompanied by a currency code. Only then can the decimal point be set correctly. A currency code field must be assigned to each currency amount field. For example, two yen are stored as 0.02 in the field of data type CURR in the database. Non-SAP systems will not understand this syntax.

    All SAP currency data types have two digits after the decimal point, even though currencies do exist with three digits after the decimal point.

    For these reasons, the data type CURR cannot be used in the BAPI interface. Adhere to the following guidelines when using currency amount fields in BAPIs:

    You must not use parameters and fields of data type CURR in the interface

    All parameters and fields for currency amounts must use the domain BAPICURR with the data element BAPICURR_D or BAPICUREXT with the data element BAPICUREXT.

    The position of the decimal point in currency amount fields must be converted correctly

    You can use two function modules for this conversion. The function module BAPI_CURRENCY_CONV_TO_EXTERNAL converts currency amounts from SAP internal data formats into external data formats. The function module BAPI_CURRENCY_CONV_TO_INTERNAL converts currency amounts from SAP external data formats into internal data formats.

    plz reward if useful..

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 03:51 AM

    Hi Shyja,

    Please check the currency in your WF starting conditions.

    Usually, the attribute CUR in your org structure is the currency used by the WF at "header level". (for example : shopping cart total value)

    Of course, if you maintain specific line item starting conditions, you have to make sure that the correct currency is mentionned else you get an issue.

    Please go through the links ->

    currency-usd-differs-from-purchase-order-currency-

    usage-of-multiple-currencies-while-creating-shoppi

    currency-usd-differs-from-purchase-order-currency-

    Also,

    You have to distinguish 2 things:

    1- Currency attribute(CUR) from PPOMA_BBP is used to calculate SC total amount. This amount & currency is used in WF starting conditions.

    2- SC item currency is handled separatly:

    Catalog items come with their price & currency code

    you can select currency for manual items. In that case, the system uses favorites logic, that stores last 5 used values. At the real start of your SRM, favorites are empty. To propose USD by default, you have to create an entry (SE16) in table BBP_CURRENCY_FAV for user ID SAP_DEF_USER.

    Furthermore, it is possible to control the favorites using four BADI:

    Define Display of Input Helps, Search Helps, and Favorites

    Restrict the Display in Input Helps and Search Helps

    Internal Temporary Storage of Favorites for Input Helps and Search Helps

    Final Saving of Favorites for Input Helps and Search Helps

    In standard, the total value of the SC is converted in the CUR attribute content.

    If your CUR is EUR, the total value is in EUR whaever other currencies you may have at line item level.

    hope this helps.

    kindly reward if found helpful.

    cheers,

    Hema.

    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.