topic Re: currency field in Application Development and Automation Discussions

currency field

Former Member — Tue, 29 Jan 2008 03:43:38 GMT

Hi,

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

please help me..

Re: currency field

Former Member — Tue, 29 Jan 2008 03:51:15 GMT

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 ->

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.

Re: currency field

Former Member — Tue, 29 Jan 2008 04:08:24 GMT

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.

Re: currency field

Former Member — Tue, 29 Jan 2008 04:48:01 GMT

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..