SAP Reports / Programs | Financial Accounting | General Ledger Accounting | Information System(FI-GL-IS) SAP FI
RFGBEW00 SAP ABAP Report - Flexible Valuation of Foreign Curr.Bank Accts at the Key Date
RFGBEW00 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for The program carries out a rolling revaluation of the foreign currency balances of those bank accounts not managed on an open item basis at a given key date and then displays the gains and losses from exchange rate differences...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.
If you would like to execute this report or see the full code listing simply enter RFGBEW00 into the relevant SAP transactions such as SE38 or SE80
ABAP code to call this SAP report using the submit statement
This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.
SUBMIT RFGBEW00. "Basic submit
SUBMIT RFGBEW00 AND RETURN. "Return to original report after report execution complete
SUBMIT RFGBEW00 VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Selection Text: BLDAT = Document date
Selection Text: BUDAT = Posting date
Selection Text: BUPEM = Posting period
Selection Text: BWMET10 = Company code currency method
Selection Text: BWMET30 = Group currency method
Selection Text: BWMET40 = Hard currency method
Selection Text: BWMET50 = Index-based currency method
Selection Text: BWMET60 = Global company currency method
Selection Text: GSBER = Business area
Selection Text: KDFSL = Exchange rate difference key
Selection Text: LISTSEP = Separate list
Selection Text: MIKFICHE = Print microfiche line
Selection Text: STICHTAG = Key date
Selection Text: TITLE = Additional heading
Selection Text: WAEHRUNG = Currency
Selection Text: B-NAME = Batch input session name
Selection Text: B-INPUT = Create batch input session
Selection Text: AB_MONAT = From month
Selection Text: AB_GJAHR = From year
Title: Flexible Valuation of Foreign Curr.Bank Accts at the Key Date
Text Symbol: 012 = .....bal. in LC ...difference .........loss .............profit ...........bal.
Text Symbol: 011 = BusA ...Currency balance...Balance in LC.....Evaluated Valuation ......Realized .......Realized .....Realized
Text Symbol: 010 = CoCd G/L acct BuAr Name Curr.
Text Symbol: 009 = CoCd G/L account name Curr.
Text Symbol: 003 = No gains or losses have been posted.
Text Symbol: 220 = --- Parameters for the procedure-------------------------------------------
Text Symbol: 323 = L
Text Symbol: 322 = Loss posting
Text Symbol: 321 = Total loss:
Text Symbol: 320 = already realized loss:
Text Symbol: 313 = C
Text Symbol: 312 = Profit posting:
Text Symbol: 311 = Total profit:
Text Symbol: 240 = I CoCd I PstgDate I Debit acct I BusA I Credit acctI BusA I Curr. I Amount in LC I Text
Text Symbol: 241 = Postings generated in session:
Text Symbol: 288 = Post.key not defined in T030B - termination
Text Symbol: 300 = Evaluated on key date:
Text Symbol: 303 = Bal.:
Text Symbol: 306 = Realized balance:
Text Symbol: 307 = Valuation:
Text Symbol: 310 = already realized profit:
Text Symbol: 015 = Total across all company codes selected:
Text Symbol: 030 = Error Reading Table
Text Symbol: 034 = TCURR
Text Symbol: 035 = FCrcy LCrcy RteType at
Text Symbol: 036 = T030
Text Symbol: 037 = Pln ExRtD
Text Symbol: 044 = Error log :
Text Symbol: 050 = Exchange rate difference key
Text Symbol: 055 = ..Doc.no. .......Currency ...Trans ..Local currency......Balance in ...Same .... position in ...realized ...realized I
Text Symbol: 056 = .........amount .....rate ........amount foreign curr. ..rate ....Local curr. ......... quantity .profit/loss n
Text Symbol: 330 = Valuation postings
Text Symbol: 401 = Error opening the BI session
Text Symbol: 402 = Posting error
Text Symbol: 410 = Valuation in company code crcy
Text Symbol: 430 = Valuation in group currency
Text Symbol: 440 = Valuation in hard currency
Text Symbol: 444 = Reversal
Text Symbol: 450 = Valaution in index-based currency
Text Symbol: 460 = Valuation in global comp.currency
Text Symbol: 501 = Real.ERD profit
Text Symbol: 502 = Real.ERD loss
Text Symbol: 504 = RFGBEW00 - Eval.bank acct
INCLUDES used within this REPORT RFGBEW00
No INCLUDES are used within this REPORT code!
TABLES used within REPORT and the associated SELECT statement:
No SAP DATABASE tables are accessed within this REPORT code!
Function Modules used within report and the associated call statement:
FI_MESSAGE_INIT CALL FUNCTION 'FI_MESSAGE_INIT'.
GET_CURRENT_YEAR CALL FUNCTION 'GET_CURRENT_YEAR' EXPORTING bukrs = skb1-bukrs date = stichtag IMPORTING currm = monat curry = jahr.
G_GIVE_LEDGERS_FOR_GLT0 CALL FUNCTION 'G_GIVE_LEDGERS_FOR_GLT0' EXPORTING bukrs = skb1-bukrs curtp = extract-curt TABLES ledtab = xgledtab.
CONVERT_TO_LOCAL_CURRENCY * call function 'CONVERT_TO_LOCAL_CURRENCY' * exporting foreign_amount = wrbest * foreign_currency = extract-waers * local_currency = haus_waers * rate = kurs * date = stichtag * importing local_amount = hwbest * foreign_factor = tcurr-ffact * local_factor = tcurr-tfact * exceptions others = 1.
CONVERT_TO_LOCAL_CURRENCY * call function 'CONVERT_TO_LOCAL_CURRENCY' * exporting foreign_amount = wrmenge * foreign_currency = extract-waers * local_currency = haus_waers * rate = kurst * date = stichtag * importing local_amount = hwreal * foreign_factor = tcurr-ffact * local_factor = tcurr-tfact * EXCHANGE_RATE = VERK-KURS "verw.Kurs
* call function 'CONVERT_TO_LOCAL_CURRENCY' * exporting foreign_amount = wrmenge * foreign_currency = extract-waers * local_currency = haus_waers * rate = kursa * date = stichtag * importing local_amount = hwreal1 * foreign_factor = tcurr-ffact * local_factor = tcurr-tfact * exceptions others = 1.
CONVERT_TO_LOCAL_CURRENCY CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY' EXPORTING foreign_amount = saldofw foreign_currency = extract-waers local_currency = haus_waers type_of_rate = tcurr-kurst date = stichtag IMPORTING local_amount = verk-bewsalhw foreign_factor = tcurr-ffact local_factor = tcurr-tfact exchange_rate = verk-kurs "verw.Kurs
FI_MESSAGE_COLLECT CALL FUNCTION 'FI_MESSAGE_COLLECT' EXPORTING i_fimsg = fimsg i_xappn = 'X' EXCEPTIONS OTHERS = 1.
FI_MESSAGE_CHECK CALL FUNCTION 'FI_MESSAGE_CHECK' EXCEPTIONS no_message = 04.
FI_MESSAGE_SORT CALL FUNCTION 'FI_MESSAGE_SORT'.
FI_MESSAGE_PRINT CALL FUNCTION 'FI_MESSAGE_PRINT' EXPORTING i_msort = ' ' i_xausn = 'X' i_xeaus = ' ' i_xskip = 'X'.
POSTING_INTERFACE_END CALL FUNCTION 'POSTING_INTERFACE_END'.
CALCULATE_EXCHANGE_RATE CALL FUNCTION 'CALCULATE_EXCHANGE_RATE' EXPORTING date = stichtag foreign_amount = foreign_amount foreign_currency = extract-waers local_amount = local_amount local_currency = haus_waers type_of_rate = tcurr-kurst IMPORTING exchange_rate = rate5 foreign_factor = tcurr-ffact local_factor = tcurr-tfact EXCEPTIONS error_message = 01 OTHERS = 02.
FI_MESSAGE_COLLECT CALL FUNCTION 'FI_MESSAGE_COLLECT' EXPORTING i_fimsg = fimsg i_xappn = 'X' EXCEPTIONS OTHERS = 1.
POSTING_INTERFACE_START CALL FUNCTION 'POSTING_INTERFACE_START' EXPORTING i_function = 'B' i_group = b-name * I_HOLDDATE = DATUM ?? i_keep = keep i_mode = 'N' i_user = sy-uname.
POSTING_INTERFACE_DOCUMENT CALL FUNCTION 'POSTING_INTERFACE_DOCUMENT' EXPORTING i_tcode = 'FBB1' IMPORTING e_subrc = subrc e_msgid = sy-msgid e_msgty = sy-msgty e_msgno = sy-msgno e_msgv1 = sy-msgv1 e_msgv2 = sy-msgv2 e_msgv3 = sy-msgv3 e_msgv4 = sy-msgv4 TABLES t_ftpost = ftpost t_blntab = xblntab t_fttax = xfttax EXCEPTIONS OTHERS = 4.
FAGL_GET_GLT0 CALL FUNCTION 'FAGL_GET_GLT0' EXPORTING i_glt0_rldnr = glkey-rldnr i_rrcty = glkey-rrcty " Satztyp fix '0' i_rvers = glkey-rvers " Version fix '001' i_bukrs = glkey-bukrs " Bukreis aus SKB1-BUKRS i_ryear = jahr i_racct = glkey-racct " Konto aus SKA1-SAKNR i_rbusa = skc1c-gsber i_rtcur = skc1c-fwaer "TEST BAUSTELLE IMPORTING et_glt0 = it_glt0.
FI_CURRENCY_INFORMATION CALL FUNCTION 'FI_CURRENCY_INFORMATION' EXPORTING i_bukrs = bukrs IMPORTING e_x001 = x001 EXCEPTIONS currency_2_not_defined = 1 currency_3_not_defined = 2 OTHERS = 6.
Contribute (Add Comments)
Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.
The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.
This will then be available for everyone to easily find by simply searching on the report name RFGBEW00 or its description.
RFGBEW00 - Flexible Valuation of Foreign Curr.Bank Accts at the Key Date RFGBEW00 - Flexible Valuation of Foreign Curr.Bank Accts at the Key Date RFG04TOP - Top-Include Writing Off Trivial Amounts RFFWSOP2 - Display Special Items acc.to Article 43 of the GCC Introductory Act RFFWSOP2 - Display Special Items acc.to Article 43 of the GCC Introductory Act RFFWSOP1 - Save Special Items from Foreign Currency Valuation