SAP Reports / Programs
RFBBEW00 SAP ABAP Report - Foreign Currency Valuation (Banks) on Key Date DD.MM.YY
RFBBEW00 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This program is used for foreign currency valuation at credit institutions...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 RFBBEW00 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 RFBBEW00. "Basic submit
SUBMIT RFBBEW00 AND RETURN. "Return to original report after report execution complete
SUBMIT RFBBEW00 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: B-INPUT = Create batch input session
Selection Text: AKONTO = Reconciliation account number
Selection Text: SKONTO = G/L account
Selection Text: SG-TEXT = Segment text for posting
Selection Text: P_ERTRAG = Revenue acct spec.cover
Selection Text: P_AUFW = Expense acct spec.cover
Selection Text: KONTOART = Account type
Selection Text: KKONTO = Vendor account
Selection Text: ST-BUDAT = Reverse posting date
Selection Text: X_DARW1 = With loans (Darwin)
Selection Text: XSORTW = Sorting by currency
Selection Text: WAEHRUNG = Currency
Selection Text: TITLE = Additional header
Selection Text: STICHTAG = Key date
Selection Text: ST-BUPEM = Reverse posting period
Selection Text: GSBER = Business area
Selection Text: BUKRS = Company code
Selection Text: BUDAT = Posting date
Selection Text: BLDAT = Document date
Selection Text: BLART = Document type
Selection Text: BELNR = Document number
Selection Text: B-NAME = Batch input session name
Selection Text: BUPEM = Posting period
Selection Text: DKONTO = Customer account
Selection Text: BWMET60 = Method for global comp.curr.
Selection Text: BWMET50 = Index-based currency method
Selection Text: BWMET40 = Hard currency method
Selection Text: BWMET30 = Group currency method
Selection Text: BWMET10 = Company code currency method
Title: Foreign Currency Valuation (Banks) on Key Date DD.MM.YY
Text Symbol: 504 = Expense
Text Symbol: 505 = Rev.
Text Symbol: 506 = from hedging
Text Symbol: 501 = number Act/Doc.no. It T Loan
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: 500 = CoCd Hedging hedging amount Curr. Due date A Account no. Name
Text Symbol: 410 = Valuation in company code crcy
Text Symbol: 121 = Number of postings
Text Symbol: 120 = Generated BI session
Text Symbol: 113 = exists for zero balance. Correct your entry.
Text Symbol: 112 = Special cover
Text Symbol: 012 = Curr. BusA Po.Dt Doc.no. Itm Amount in FC Book value amount difference
Text Symbol: 010 = CoCd G/L no. A Accnt no. Name Valuated Valuation
Text Symbol: 123 = Errors
Text Symbol: 402 = PK missing
Text Symbol: 401 = missing
Text Symbol: 205 = account Curr. BusA Foreign curr. Local curr. amount difference Debit act Credit act
Text Symbol: 204 = CoCd Cover Gen.Ledger Curr. BusA Amount Amount Valuated Valuation Posting generated
Text Symbol: 202 = Curr. BusA Amount in FC Amount in LC Valuated amount Expense valuation Revenue valuation Valuation difference
Text Symbol: 201 = Company code totals:
INCLUDES used within this REPORT RFBBEW00
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:
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.
POSTING_INTERFACE_END CALL FUNCTION 'POSTING_INTERFACE_END'.
CONVERT_TO_LOCAL_CURRENCY CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY' EXPORTING date = stichtag foreign_amount = konto_tab-wrshb foreign_currency = extract-waers local_currency = haus_waers type_of_rate = kurs IMPORTING exchange_rate = tcurr-ukurs local_amount = bsaldhw EXCEPTIONS no_rate_found = 01 overflow = 02.
POSTING_INTERFACE_START CALL FUNCTION 'POSTING_INTERFACE_START' EXPORTING i_function = 'B' i_group = b-name i_keep = keep i_mode = 'N' i_user = user.
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 account_missing = 1 posting_key_missing = 2 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_range_rbusa = lt_gsber IMPORTING et_glt0 = it_glt0.
READ_HAUPTBUCH CALL FUNCTION 'READ_HAUPTBUCH' EXPORTING buchungskreis = bsis-bukrs sachkonto = bsis-hkont IMPORTING sachkonto_wa = skb1.
READ_HAUPTBUCH CALL FUNCTION 'READ_HAUPTBUCH' EXPORTING buchungskreis = bsis-bukrs sachkonto = bsis-hkont IMPORTING sachkonto_wa = skb1.
FI_DARWIN_BEW * call function 'FI_DARWIN_BEW' * exporting * art = 1 * bukrs = t001-bukrs * stichtag = stichtag * importing * e_subrc = sy-subrc * tables * t_bbewtab = t_bbewtab.
CALCULATE_EXCHANGE_RATE CALL FUNCTION 'CALCULATE_EXCHANGE_RATE' EXPORTING date = stichtag foreign_amount = document-wrbtr foreign_currency = extract-waers local_amount = bsaldhw local_currency = t001-waers type_of_rate = 'M' IMPORTING exchange_rate = tcurr-ukurs * FOREIGN_FACTOR = I02 * LOCAL_FACTOR = I03 EXCEPTIONS no_rate_computable = 01 no_rate_found = 02 rate_too_big = 03.
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 RFBBEW00 or its description.
RFBBEW00 - Foreign Currency Valuation (Banks) on Key Date DD.MM.YY RFBBEW00 - Foreign Currency Valuation (Banks) on Key Date DD.MM.YY RFBBBNR1 - Convert 8-Char. Company Number to International Location Number RFBBBNR1 - Convert 8-Char. Company Number to International Location Number RFBASM00 - ABAP/4 Program Directory RFBASM00 - ABAP/4 Program Directory