RFVDSALC SAP ABAP Report - LOANS: Reconcile Balances (Subledger vs. General Ledger)

SAP T-Codes / Example ABAP code
ABAP OO / SAP Function Modules
ABAP reports / SAP Error Messages
SAP Tables / SAP Video Training

RFVDSALC is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This report ("balance reconciliation list") reconciles the balances between the subsidiary ledger for loans and the general FI ledger...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 RFVDSALC into the relevant SAP transactions such as SE38 or SE80

Transaction Code(s):

Below is a list of transaction codes which are relevant to this SAP report

FNSL - Balance reconciliation list

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 RFVDSALC. "Basic submit
SUBMIT RFVDSALC AND RETURN. "Return to original report after report execution complete
SUBMIT RFVDSALC 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: SO_BUKRS = Company Code
Selection Text: R_STUFE3 = and document data
Selection Text: R_STUFE2 = and balances per loan
Selection Text: R_STUFE1 = and balances per pos. currency
Selection Text: R_STUFE0 = Balances per account
Selection Text: R_DIFF = Accounts With Bal. Difference
Selection Text: R_ALL = All Accounts
Selection Text: KONTO = Account
Selection Text: GJAHR = Fiscal Year
Selection Text: B_MONATE = Reporting Periods
Title: LOANS: Reconcile Balances (Subledger vs. General Ledger)
Text Symbol: 054 = Contract No.
Text Symbol: 055 = G/L Acct
Text Symbol: 100 = No data records were found for the selection criteria
Text Symbol: 110 = (No account ID defined)
Text Symbol: 300 = LOANS: Reconcile Balances (subledger vs. G/L)
Text Symbol: 400 = There are archived docs in the reporting period so a balance reconciliation is only partially meaningful
Text Symbol: 401 = Do you want to continue anyway?
Text Symbol: 500 = Y
Text Symbol: 501 = No
Text Symbol: S01 = Report Selections
Text Symbol: S02 = Display Options
Text Symbol: S03 = Acct Select.
Text Symbol: S04 = Form of List Display
Text Symbol: 053 = Company Code
Text Symbol: 001 = Company Code:
Text Symbol: 002 = G/L Acct
Text Symbol: 003 = CoCd
Text Symbol: 004 = Local Curr.:
Text Symbol: 005 = Loc.Crcy
Text Symbol: 006 = Source
Text Symbol: 009 = Difference
Text Symbol: 010 = Contr. No.
Text Symbol: 012 = Pos.Cur.
Text Symbol: 013 = Opening Balance
Text Symbol: 014 = Flow (Debit)
Text Symbol: 015 = Flow (Credit)
Text Symbol: 016 = Balance

Text Symbol: 017 = Closing Balance
Text Symbol: 018 = Doc. No.
Text Symbol: 020 = Fiscal year variant for the company code is missing
Text Symbol: 023 = Subledger:
Text Symbol: 024 = G/L:
Text Symbol: 030 = G/L account
Text Symbol: 031 = could not be found in the general ledger
Text Symbol: 040 = No postings
Text Symbol: 041 = have been made to the G/L account in the posting period
Text Symbol: 051 = Fiscal Year
Text Symbol: 052 = Rep. Periods

INCLUDES used within this REPORT RFVDSALC

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:

BUILD_DEFAULT_YEAR CALL FUNCTION 'BUILD_DEFAULT_YEAR' TABLES xgjahr = xgjahr.

BUILD_DEFAULT_PERIOD CALL FUNCTION 'BUILD_DEFAULT_PERIOD' TABLES xmonat = b_monate.

LOAN_MESSAGES_INITIALIZE CALL FUNCTION 'LOAN_MESSAGES_INITIALIZE'.

LOAN_MESSAGES_STORE CALL FUNCTION 'LOAN_MESSAGES_STORE' EXPORTING is_mesg = l_msg EXCEPTIONS OTHERS = 1.

POPUP_TO_CONFIRM CALL FUNCTION 'POPUP_TO_CONFIRM' EXPORTING * TITLEBAR = ' ' * DIAGNOSE_OBJECT = 'B ' text_question = text-019 TEXT_BUTTON_1 = text-021 ICON_BUTTON_1 = 'ICON_CHECKED' TEXT_BUTTON_2 = text-022 ICON_BUTTON_2 = 'ICON_INCOMPLETE' * DEFAULT_BUTTON = '1' DISPLAY_CANCEL_BUTTON = SPACE * POPUP_TYPE = IMPORTING ANSWER = l_answer * TABLES * PARAMETER = EXCEPTIONS TEXT_NOT_FOUND = 1 OTHERS = 2 .

READ_SKC1C CALL FUNCTION 'READ_SKC1C' EXPORTING xsaknr = i_ktogsber-rkonto xbukrs = i_bukrs xgjahr = gjahr xgsber = i_ktogsber-gsber xrtcur = i_sbwhr IMPORTING xskc1c = yskc1c EXCEPTIONS key_incomplete = 01 not_authorized = 02 not_found = 03.

FVD_ARC_ADM_KEYDATES_MAX_GET CALL FUNCTION 'FVD_ARC_ADM_KEYDATES_MAX_GET' EXPORTING i_tab_vdarl_key = l_tab_vdarl_key IMPORTING * E_MAX_DPARC = * E_MAX_DDARC = * E_MAX_DFARC = e_max_dvarc = l_arc_key_date EXCEPTIONS no_loan_selected = 1 OTHERS = 2.

POPUP_TO_CONFIRM CALL FUNCTION 'POPUP_TO_CONFIRM' EXPORTING * TITLEBAR = ' ' * DIAGNOSE_OBJECT = ' ' text_question = l_text text_button_1 = 'Ja'(500) * ICON_BUTTON_1 = ' ' text_button_2 = 'Nein'(501) * ICON_BUTTON_2 = ' ' * DEFAULT_BUTTON = '1' display_cancel_button = ' ' * USERDEFINED_F1_HELP = ' ' * START_COLUMN = 25 * START_ROW = 6 * POPUP_TYPE = IMPORTING answer = g_answer * TABLES * PARAMETER = EXCEPTIONS text_not_found = 1 OTHERS = 2.

PERIOD_DAY_DETERMINE CALL FUNCTION 'PERIOD_DAY_DETERMINE' EXPORTING i_gjahr = gjahr i_monat = monat i_periv = t001-periv IMPORTING e_fday = anftag e_lday = endtag.

FI_EMU_GET_CONVERSION_DATE * CALL FUNCTION 'FI_EMU_GET_CONVERSION_DATE' " NOTE 385788 * EXPORTING " NOTE 385788 * i_bukrs = wrk_vdbevi-bukrs " NOTE 385788 * IMPORTING " NOTE 385788 * e_date = d_emu_conversion " NOTE 385788 * EXCEPTIONS " NOTE 385788 * wrong_input = 1 " NOTE 385788 * companycode_not_found = 2 " NOTE 385788 * system_error = 3 " NOTE 385788 * OTHERS = 4. " NOTE 385788

GET_EWWU_WAERS_40 * CALL FUNCTION 'GET_EWWU_WAERS_40' " NOTE 385788 * EXPORTING " NOTE 385788 * confirm_cust = 'X' " NOTE 385788 * TABLES " NOTE 385788 * ewucurrs = wrk_t_emu_waers " NOTE 385788 * EXCEPTIONS " NOTE 385788 * customizing_not_found = 1 " NOTE 385788 * customizing_not_confirmed = 2 " NOTE 385788 * no_waers_found = 3 " NOTE 385788 * OTHERS = 4. " NOTE 385788

FVD_DB_VDARL_GET_SNG

CALL FUNCTION 'FVD_DB_VDARL_GET_SNG' EXPORTING i_bukrs = wrk_vdbevi-bukrs i_sarchiv = space i_ranl = wrk_vdbevi-ranl IMPORTING e_str_vdarl = l_wrk_vdarl EXCEPTIONS contract_not_found = 1 OTHERS = 2.

READ_SACHKONTO_AND_TEXT CALL FUNCTION 'READ_SACHKONTO_AND_TEXT' EXPORTING buchungskreis = gt_bevi-bukrs sachkonto = gt_bevi-rkonto sprache = sy-langu IMPORTING sachkonto_wa = yskb1 text_wa = yskat EXCEPTIONS sachkonto_not_found = 01 text_not_found = 02.

LOAN_MESSAGES_WRITE_LIST CALL FUNCTION 'LOAN_MESSAGES_WRITE_LIST' EXCEPTIONS INCONSISTENT_RANGE = 1 OTHERS = 2 .

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 RFVDSALC or its description.

RFVDSALC - LOANS: Reconcile Balances (Subledger vs. General Ledger)
RFVDSALC - LOANS: Reconcile Balances (Subledger vs. General Ledger)
RFVDSALB - LOANS: Reconcile Balances (Subledger vs. General Ledger)
RFVDSALB - LOANS: Reconcile Balances (Subledger vs. General Ledger)
RFVDREV0 - Balance Sheet Valuation of Foreign Currency Loans
RFVDREV0 - Balance Sheet Valuation of Foreign Currency Loans

RFKK_MASS_ACT_PARAMETER_UNHIDE