topic Re: Currency in Application Development and Automation Discussions

Currency

Former Member — Fri, 23 Feb 2007 06:06:09 GMT

Hi,

I have a Ztable with company code, plant , currency fields and others.

I have to validate the currency in the Ztable against the currency in the standard table of SAP.

Is there any function module available?

regards

Re: Currency

anversha_s — Fri, 23 Feb 2007 06:10:21 GMT

hi,

1. u can validate before inserting the currency into ztable.

select single WAERS from TCURT into  wa_waers
    where waers = val_data_waers
    and SPRAS = 'EN'.

3. now chk the

sy-subrc

of above stmnt

4. if it is '0' insert, else reject

Regards

Anver

Re: Currency

Former Member — Fri, 23 Feb 2007 06:18:30 GMT

Hi,

If u r validating selection screen then do as bewlo:

SELECT SINGLE kwert 
              INTO xxx-kwert
              WHERE ... IN s_...

Is there any check table refered against the currency field, if so use taht table for validating.

If u r asking for validation in the tabel u can refer the currecy field against a check table, so it will vlaidate automatically.

For Currency key u have to see table <b>TCURC.</b>

U can refer this code for currency conversion

DATA: gd_fcurr TYPE tcurr-fcurr,
      gd_tcurr TYPE tcurr-tcurr,
      gd_date  TYPE sy-datum,
      gd_value TYPE i.

gd_fcurr = 'EUR'.
gd_tcurr = 'GBP'.
gd_date  = sy-datum.
gd_value = 10.

PERFORM currency_conversion USING gd_fcurr
                                  gd_tcurr
                                  gd_date
                         CHANGING gd_value.



* Convert value to Currency value 
*&---------------------------------------------------------------------*
*&      Form  currency_conversion
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->P_GD_FCURR  text
*      -->P_GD_TCURR  text
*      -->P_GD_DATE   text
*      <--P_GD_VALUE  text
*----------------------------------------------------------------------*
FORM currency_conversion  USING    p_fcurr
                                   p_tcurr
                                   p_date
                          CHANGING p_value.

  DATA: t_er        TYPE tcurr-ukurs,
        t_ff        TYPE tcurr-ffact,
        t_lf        TYPE tcurr-tfact,
        t_vfd       TYPE datum,
        ld_erate(12)   TYPE c.

  CALL FUNCTION 'READ_EXCHANGE_RATE'
    EXPORTING
*       CLIENT                  = SY-MANDT
      date                    = p_date
      foreign_currency        = p_fcurr
      local_currency          = p_tcurr
      TYPE_OF_RATE            = 'M'
*       EXACT_DATE              = ' '
   IMPORTING
      exchange_rate           = t_er
      foreign_factor          = t_ff
      local_factor            = t_lf
      valid_from_date         = t_vfd
*       DERIVED_RATE_TYPE       =
*       FIXED_RATE              =
*       OLDEST_RATE_FROM        =
   EXCEPTIONS
     no_rate_found           = 1
     no_factors_found        = 2
     no_spread_found         = 3
     derived_2_times         = 4
     overflow                = 5
     zero_rate               = 6
     OTHERS                  = 7
            .
  IF sy-subrc EQ 0.
    ld_erate = t_er / ( t_ff / t_lf ).
    p_value = p_value * ld_erate.
  ENDIF.
ENDFORM.                    " currency_conversion

http://www.sapdevelopment.co.uk/country/country_curr.htm

Reward if this helsp.

Message was edited by:

Judith Jessie Selvi

Re: Currency

Former Member — Fri, 23 Feb 2007 06:26:31 GMT

Hi,

You can use foll currency fm :

Get the exchange rate using the function module READ_EXCHANGE_RATE.

Convert it to local currency by using CONVERT_TO_LOCAL_CURRENCY.

CONVERT_TO_FOREIGN_CURRENCY

Please reward for the same.

Re: Currency

anversha_s — Fri, 23 Feb 2007 06:32:02 GMT

hi sachin,

how did u solve the issue with the above FM.

Regards

Anver

Re: Currency

Former Member — Fri, 23 Feb 2007 06:36:32 GMT

I dont want any currency conversions like from GBP to UDS or so..

I want to check if the currency in my Ztable is matching with the one which is maintained in standard table at the time of config or so.

If both the currencies are same, I have my logic for further processing.

Re: Currency

Former Member — Fri, 23 Feb 2007 06:41:23 GMT

Tell me the table name and field name, which field u r referring?

Also R u validating in the program? if so tell me the selection parameter.

Re: Currency

Former Member — Fri, 23 Feb 2007 06:46:00 GMT

check table

TCURC.

Regards

Prabhu