SAP TB_EVALUATION_FOREX Function Module for Treasury: Foreign Exchange Valuation (Single Transaction)









TB_EVALUATION_FOREX is a standard tb evaluation forex SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used for Treasury: Foreign Exchange Valuation (Single Transaction) processing and below is the pattern details for this FM, showing its interface including any import and export parameters, exceptions etc. there is also a full "cut and paste" ABAP pattern code example, along with implementation ABAP coding, documentation and contribution comments specific to this or related objects.


See here to view full function module documentation and code listing for tb evaluation forex FM, simply by entering the name TB_EVALUATION_FOREX into the relevant SAP transaction such as SE37 or SE38.

Function Group: TB16
Program Name: SAPLTB16
Main Program: SAPLTB16
Appliation area: F
Release date: N/A
Mode(Normal, Remote etc): Normal Function Module
Update:



Function TB_EVALUATION_FOREX pattern details

In-order to call this FM within your sap programs, simply using the below ABAP pattern details to trigger the function call...or see the full ABAP code listing at the end of this article. You can simply cut and paste this code into your ABAP progrom as it is, including variable declarations.
CALL FUNCTION 'TB_EVALUATION_FOREX'"Treasury: Foreign Exchange Valuation (Single Transaction)
  EXPORTING
   DEAL =  "
*  INCL_EXCL = '1' "Inklusivkennzeichen für den Endetermin eines Zeitraums
   TERMINKURS =  "
   KASSAKURS =  "
   LEITWAEHRUNG =  "
   FOLGEWAEHRUNG =  "
   DEALDATE =  "
   STICHTAG =  "
*  KURSTYP =  "
*  KURSFINDUNG =  "

 IMPORTING
   ANSCHAFFUNGSWERT_FW_KAUF =  "
   ERFOLG_AKTUELL =  "
   ERFOLG_GEBUCHT =  "
   RESTSWAPSATZ =  "
   BEWERTUNGSSWAP =  "
   SW_ERFOLG_AKTUELL =  "
   SW_ERFOLG_GEBUCHT =  "
   FLG_CROSS_GESCHAEFT =  "
   FREMDWAEHRUNG_KAUF =  "
   FREMDWAEHRUNG_VERKAUF =  "
   HAUSWAEHRUNG =  "
   ANSCHAFFUNGSWERT_FW_VERKAUF =  "
   STICHTAGSWERT_KAUF =  "
   STICHTAGSWERT_VERKAUF =  "
   REST_SWP_BETRAG =  "
   STICHTAGS_SWP_BETRAG =  "
   KURSFINDUNG =  "
   ANSCHAFFUNGSWERT_HW_KAUF =  "Payment Amount in LC
   ANSCHAFFUNGSKURS_HW_KAUF =  "
   ANSCHAFFUNGSWERT_HW_VERKAUF =  "Payment Amount in LC
   ANSCHAFFUNGSKURS_HW_VERKAUF =  "Local Currency Rate
   ANSCHAFFUNGSWERT_HW =  "Payment Amount in LC
   BEWERTUNGSKURS_KAUF =  "
   BEWERTUNGSKURS_VERKAUF =  "

TABLES
   BESTEHENDE_BEWEGUNGEN =  "
   ERZEUGTE_BEWEGUNGEN =  "

EXCEPTIONS
   ERROR_DEAL = 1    MORE_THAN_ONE_DEAL = 2    WRONG_KEY_DATE = 3    NO_FLOWTYPE = 4    DEAL_ALREADY_POSTED = 5    EVALUATION_RATE_MISSING = 6
.



IMPORTING Parameters details for TB_EVALUATION_FOREX

DEAL -

Data type: VTBFHA
Optional: No
Call by Reference: No ( called with pass by value option)

INCL_EXCL - Inklusivkennzeichen für den Endetermin eines Zeitraums

Data type: VTBFHAPO-SINCLBIS
Default: '1'
Optional: Yes
Call by Reference: No ( called with pass by value option)

TERMINKURS -

Data type: VTBFHAZU-KKURS
Optional: No
Call by Reference: No ( called with pass by value option)

KASSAKURS -

Data type: VTBFHAZU-KKASSA
Optional: No
Call by Reference: No ( called with pass by value option)

LEITWAEHRUNG -

Data type: VTBFHAZU-WLWAERS
Optional: No
Call by Reference: No ( called with pass by value option)

FOLGEWAEHRUNG -

Data type: VTBFHAZU-WFWAERS
Optional: No
Call by Reference: No ( called with pass by value option)

DEALDATE -

Data type: VTBFHAZU-DVTRAB
Optional: No
Call by Reference: No ( called with pass by value option)

STICHTAG -

Data type: SY-DATUM
Optional: No
Call by Reference: No ( called with pass by value option)

KURSTYP -

Data type: AT10B-KTYPSK
Optional: Yes
Call by Reference: No ( called with pass by value option)

KURSFINDUNG -

Data type: AT10B-SFWKURS
Optional: Yes
Call by Reference: No ( called with pass by value option)

EXPORTING Parameters details for TB_EVALUATION_FOREX

ANSCHAFFUNGSWERT_FW_KAUF -

Data type: VTBFHAPO-BZBETR
Optional: No
Call by Reference: No ( called with pass by value option)

ERFOLG_AKTUELL -

Data type: VTBFHAPO-BHWBETR
Optional: No
Call by Reference: No ( called with pass by value option)

ERFOLG_GEBUCHT -

Data type: VTBFHAPO-BHWBETR
Optional: No
Call by Reference: No ( called with pass by value option)

RESTSWAPSATZ -

Data type: VTBFHAZU-KSWAP
Optional: No
Call by Reference: No ( called with pass by value option)

BEWERTUNGSSWAP -

Data type: VTBFHAZU-KSWAP
Optional: No
Call by Reference: No ( called with pass by value option)

SW_ERFOLG_AKTUELL -

Data type: VTBFHAPO-BHWBETR
Optional: No
Call by Reference: No ( called with pass by value option)

SW_ERFOLG_GEBUCHT -

Data type: VTBFHAPO-BHWBETR
Optional: No
Call by Reference: No ( called with pass by value option)

FLG_CROSS_GESCHAEFT -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

FREMDWAEHRUNG_KAUF -

Data type: TCURC-WAERS
Optional: No
Call by Reference: No ( called with pass by value option)

FREMDWAEHRUNG_VERKAUF -

Data type: TCURC-WAERS
Optional: No
Call by Reference: No ( called with pass by value option)

HAUSWAEHRUNG -

Data type: TCURC-WAERS
Optional: No
Call by Reference: No ( called with pass by value option)

ANSCHAFFUNGSWERT_FW_VERKAUF -

Data type: VTBFHAPO-BZBETR
Optional: No
Call by Reference: No ( called with pass by value option)

STICHTAGSWERT_KAUF -

Data type: VTBFHAPO-BHWBETR
Optional: No
Call by Reference: No ( called with pass by value option)

STICHTAGSWERT_VERKAUF -

Data type: VTBFHAPO-BHWBETR
Optional: No
Call by Reference: No ( called with pass by value option)

REST_SWP_BETRAG -

Data type: VTBFHAPO-BHWBETR
Optional: No
Call by Reference: No ( called with pass by value option)

STICHTAGS_SWP_BETRAG -

Data type: VTBFHAPO-BHWBETR
Optional: No
Call by Reference: No ( called with pass by value option)

KURSFINDUNG -

Data type: AT10B-SFWKURS
Optional: No
Call by Reference: No ( called with pass by value option)

ANSCHAFFUNGSWERT_HW_KAUF - Payment Amount in LC

Data type: VTBFHAPO-BHWBETR
Optional: No
Call by Reference: No ( called with pass by value option)

ANSCHAFFUNGSKURS_HW_KAUF -

Data type: VTBFHAPO-KHWKURS
Optional: No
Call by Reference: Yes

ANSCHAFFUNGSWERT_HW_VERKAUF - Payment Amount in LC

Data type: VTBFHAPO-BHWBETR
Optional: No
Call by Reference: No ( called with pass by value option)

ANSCHAFFUNGSKURS_HW_VERKAUF - Local Currency Rate

Data type: VTBFHAPO-KHWKURS
Optional: No
Call by Reference: Yes

ANSCHAFFUNGSWERT_HW - Payment Amount in LC

Data type: VTBFHAPO-BHWBETR
Optional: No
Call by Reference: Yes

BEWERTUNGSKURS_KAUF -

Data type: TCURR-UKURS
Optional: No
Call by Reference: No ( called with pass by value option)

BEWERTUNGSKURS_VERKAUF -

Data type: TCURR-UKURS
Optional: No
Call by Reference: No ( called with pass by value option)

TABLES Parameters details for TB_EVALUATION_FOREX

BESTEHENDE_BEWEGUNGEN -

Data type: VTBFHAPO
Optional: No
Call by Reference: No ( called with pass by value option)

ERZEUGTE_BEWEGUNGEN -

Data type: VTBFHAPO
Optional: No
Call by Reference: No ( called with pass by value option)

EXCEPTIONS details

ERROR_DEAL -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

MORE_THAN_ONE_DEAL -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

WRONG_KEY_DATE -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

NO_FLOWTYPE -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

DEAL_ALREADY_POSTED -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

EVALUATION_RATE_MISSING -

Data type:
Optional: No
Call by Reference: Yes

Copy and paste ABAP code example for TB_EVALUATION_FOREX Function Module

The ABAP code below is a full code listing to execute function module POPUP_TO_CONFIRM including all data declarations. The code uses the original data declarations rather than the latest in-line data DECLARATION SYNTAX but I have included an ABAP code snippet at the end to show how declarations would look using the newer method of declaring data variables on the fly. This will allow you to compare and fully understand the new inline method. Please note some of the newer syntax such as the @DATA is not available until a later 4.70 service pack (SP8), which i why i have stuck to the origianl for this example.

DATA:
lv_deal  TYPE VTBFHA, "   
lv_error_deal  TYPE VTBFHA, "   
lt_bestehende_bewegungen  TYPE STANDARD TABLE OF VTBFHAPO, "   
lv_anschaffungswert_fw_kauf  TYPE VTBFHAPO-BZBETR, "   
lv_incl_excl  TYPE VTBFHAPO-SINCLBIS, "   '1'
lv_erfolg_aktuell  TYPE VTBFHAPO-BHWBETR, "   
lv_erfolg_gebucht  TYPE VTBFHAPO-BHWBETR, "   
lv_restswapsatz  TYPE VTBFHAZU-KSWAP, "   
lv_bewertungsswap  TYPE VTBFHAZU-KSWAP, "   
lv_sw_erfolg_aktuell  TYPE VTBFHAPO-BHWBETR, "   
lv_sw_erfolg_gebucht  TYPE VTBFHAPO-BHWBETR, "   
lv_flg_cross_geschaeft  TYPE VTBFHAPO, "   
lv_fremdwaehrung_kauf  TYPE TCURC-WAERS, "   
lv_fremdwaehrung_verkauf  TYPE TCURC-WAERS, "   
lv_hauswaehrung  TYPE TCURC-WAERS, "   
lv_terminkurs  TYPE VTBFHAZU-KKURS, "   
lv_more_than_one_deal  TYPE VTBFHAZU, "   
lt_erzeugte_bewegungen  TYPE STANDARD TABLE OF VTBFHAPO, "   
lv_anschaffungswert_fw_verkauf  TYPE VTBFHAPO-BZBETR, "   
lv_stichtagswert_kauf  TYPE VTBFHAPO-BHWBETR, "   
lv_stichtagswert_verkauf  TYPE VTBFHAPO-BHWBETR, "   
lv_rest_swp_betrag  TYPE VTBFHAPO-BHWBETR, "   
lv_stichtags_swp_betrag  TYPE VTBFHAPO-BHWBETR, "   
lv_kursfindung  TYPE AT10B-SFWKURS, "   
lv_kassakurs  TYPE VTBFHAZU-KKASSA, "   
lv_wrong_key_date  TYPE VTBFHAZU, "   
lv_anschaffungswert_hw_kauf  TYPE VTBFHAPO-BHWBETR, "   
lv_no_flowtype  TYPE VTBFHAPO, "   
lv_leitwaehrung  TYPE VTBFHAZU-WLWAERS, "   
lv_anschaffungskurs_hw_kauf  TYPE VTBFHAPO-KHWKURS, "   
lv_folgewaehrung  TYPE VTBFHAZU-WFWAERS, "   
lv_deal_already_posted  TYPE VTBFHAZU, "   
lv_anschaffungswert_hw_verkauf  TYPE VTBFHAPO-BHWBETR, "   
lv_dealdate  TYPE VTBFHAZU-DVTRAB, "   
lv_evaluation_rate_missing  TYPE VTBFHAZU, "   
lv_anschaffungskurs_hw_verkauf  TYPE VTBFHAPO-KHWKURS, "   
lv_stichtag  TYPE SY-DATUM, "   
lv_anschaffungswert_hw  TYPE VTBFHAPO-BHWBETR, "   
lv_kurstyp  TYPE AT10B-KTYPSK, "   
lv_bewertungskurs_kauf  TYPE TCURR-UKURS, "   
lv_kursfindung  TYPE AT10B-SFWKURS, "   
lv_bewertungskurs_verkauf  TYPE TCURR-UKURS. "   

  CALL FUNCTION 'TB_EVALUATION_FOREX'  "Treasury: Foreign Exchange Valuation (Single Transaction)
    EXPORTING
         DEAL = lv_deal
         INCL_EXCL = lv_incl_excl
         TERMINKURS = lv_terminkurs
         KASSAKURS = lv_kassakurs
         LEITWAEHRUNG = lv_leitwaehrung
         FOLGEWAEHRUNG = lv_folgewaehrung
         DEALDATE = lv_dealdate
         STICHTAG = lv_stichtag
         KURSTYP = lv_kurstyp
         KURSFINDUNG = lv_kursfindung
    IMPORTING
         ANSCHAFFUNGSWERT_FW_KAUF = lv_anschaffungswert_fw_kauf
         ERFOLG_AKTUELL = lv_erfolg_aktuell
         ERFOLG_GEBUCHT = lv_erfolg_gebucht
         RESTSWAPSATZ = lv_restswapsatz
         BEWERTUNGSSWAP = lv_bewertungsswap
         SW_ERFOLG_AKTUELL = lv_sw_erfolg_aktuell
         SW_ERFOLG_GEBUCHT = lv_sw_erfolg_gebucht
         FLG_CROSS_GESCHAEFT = lv_flg_cross_geschaeft
         FREMDWAEHRUNG_KAUF = lv_fremdwaehrung_kauf
         FREMDWAEHRUNG_VERKAUF = lv_fremdwaehrung_verkauf
         HAUSWAEHRUNG = lv_hauswaehrung
         ANSCHAFFUNGSWERT_FW_VERKAUF = lv_anschaffungswert_fw_verkauf
         STICHTAGSWERT_KAUF = lv_stichtagswert_kauf
         STICHTAGSWERT_VERKAUF = lv_stichtagswert_verkauf
         REST_SWP_BETRAG = lv_rest_swp_betrag
         STICHTAGS_SWP_BETRAG = lv_stichtags_swp_betrag
         KURSFINDUNG = lv_kursfindung
         ANSCHAFFUNGSWERT_HW_KAUF = lv_anschaffungswert_hw_kauf
         ANSCHAFFUNGSKURS_HW_KAUF = lv_anschaffungskurs_hw_kauf
         ANSCHAFFUNGSWERT_HW_VERKAUF = lv_anschaffungswert_hw_verkauf
         ANSCHAFFUNGSKURS_HW_VERKAUF = lv_anschaffungskurs_hw_verkauf
         ANSCHAFFUNGSWERT_HW = lv_anschaffungswert_hw
         BEWERTUNGSKURS_KAUF = lv_bewertungskurs_kauf
         BEWERTUNGSKURS_VERKAUF = lv_bewertungskurs_verkauf
    TABLES
         BESTEHENDE_BEWEGUNGEN = lt_bestehende_bewegungen
         ERZEUGTE_BEWEGUNGEN = lt_erzeugte_bewegungen
    EXCEPTIONS
        ERROR_DEAL = 1
        MORE_THAN_ONE_DEAL = 2
        WRONG_KEY_DATE = 3
        NO_FLOWTYPE = 4
        DEAL_ALREADY_POSTED = 5
        EVALUATION_RATE_MISSING = 6
. " TB_EVALUATION_FOREX




ABAP code using 7.40 inline data declarations to call FM TB_EVALUATION_FOREX

The below ABAP code uses the newer in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. Please note some of the newer syntax below, such as the @DATA is not available until 4.70 EHP 8.

 
 
 
"SELECT single BZBETR FROM VTBFHAPO INTO @DATA(ld_anschaffungswert_fw_kauf).
 
"SELECT single SINCLBIS FROM VTBFHAPO INTO @DATA(ld_incl_excl).
DATA(ld_incl_excl) = '1'.
 
"SELECT single BHWBETR FROM VTBFHAPO INTO @DATA(ld_erfolg_aktuell).
 
"SELECT single BHWBETR FROM VTBFHAPO INTO @DATA(ld_erfolg_gebucht).
 
"SELECT single KSWAP FROM VTBFHAZU INTO @DATA(ld_restswapsatz).
 
"SELECT single KSWAP FROM VTBFHAZU INTO @DATA(ld_bewertungsswap).
 
"SELECT single BHWBETR FROM VTBFHAPO INTO @DATA(ld_sw_erfolg_aktuell).
 
"SELECT single BHWBETR FROM VTBFHAPO INTO @DATA(ld_sw_erfolg_gebucht).
 
 
"SELECT single WAERS FROM TCURC INTO @DATA(ld_fremdwaehrung_kauf).
 
"SELECT single WAERS FROM TCURC INTO @DATA(ld_fremdwaehrung_verkauf).
 
"SELECT single WAERS FROM TCURC INTO @DATA(ld_hauswaehrung).
 
"SELECT single KKURS FROM VTBFHAZU INTO @DATA(ld_terminkurs).
 
 
 
"SELECT single BZBETR FROM VTBFHAPO INTO @DATA(ld_anschaffungswert_fw_verkauf).
 
"SELECT single BHWBETR FROM VTBFHAPO INTO @DATA(ld_stichtagswert_kauf).
 
"SELECT single BHWBETR FROM VTBFHAPO INTO @DATA(ld_stichtagswert_verkauf).
 
"SELECT single BHWBETR FROM VTBFHAPO INTO @DATA(ld_rest_swp_betrag).
 
"SELECT single BHWBETR FROM VTBFHAPO INTO @DATA(ld_stichtags_swp_betrag).
 
"SELECT single SFWKURS FROM AT10B INTO @DATA(ld_kursfindung).
 
"SELECT single KKASSA FROM VTBFHAZU INTO @DATA(ld_kassakurs).
 
 
"SELECT single BHWBETR FROM VTBFHAPO INTO @DATA(ld_anschaffungswert_hw_kauf).
 
 
"SELECT single WLWAERS FROM VTBFHAZU INTO @DATA(ld_leitwaehrung).
 
"SELECT single KHWKURS FROM VTBFHAPO INTO @DATA(ld_anschaffungskurs_hw_kauf).
 
"SELECT single WFWAERS FROM VTBFHAZU INTO @DATA(ld_folgewaehrung).
 
 
"SELECT single BHWBETR FROM VTBFHAPO INTO @DATA(ld_anschaffungswert_hw_verkauf).
 
"SELECT single DVTRAB FROM VTBFHAZU INTO @DATA(ld_dealdate).
 
 
"SELECT single KHWKURS FROM VTBFHAPO INTO @DATA(ld_anschaffungskurs_hw_verkauf).
 
"SELECT single DATUM FROM SY INTO @DATA(ld_stichtag).
 
"SELECT single BHWBETR FROM VTBFHAPO INTO @DATA(ld_anschaffungswert_hw).
 
"SELECT single KTYPSK FROM AT10B INTO @DATA(ld_kurstyp).
 
"SELECT single UKURS FROM TCURR INTO @DATA(ld_bewertungskurs_kauf).
 
"SELECT single SFWKURS FROM AT10B INTO @DATA(ld_kursfindung).
 
"SELECT single UKURS FROM TCURR INTO @DATA(ld_bewertungskurs_verkauf).
 


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!