SAP Reports / Programs | Financial Services | Regulatory reporting for insurance companies | Switzerland(FS-SR-CH) SAP FS
RFVWCH01 SAP ABAP Report - Securities Report for Swiss Regulatory Reporting (RFVWCH01)
RFVWCH01 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.
If you would like to execute this report or see the full code listing simply enter RFVWCH01 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
FSRW - Securities Regulatory Reporting CH
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 RFVWCH01. "Basic submit
SUBMIT RFVWCH01 AND RETURN. "Return to original report after report execution complete
SUBMIT RFVWCH01 VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
BPV Report, Regulatory Reporting for Securities
Selection Text: G_BPVKAT = Detail display
Selection Text: KURSART = Security price type
Selection Text: KURSBER = Price calc. type: Market price
Selection Text: KURSBPV = Price calc. type: BPV price
Selection Text: P_AKTNK = Include capitaliz.incid.costs
Selection Text: P_AUSLD = ID: Foreign issuers
Selection Text: P_BPVKAT = BPV category of security
Selection Text: P_BRNCH = Industry
Selection Text: P_CNTRY = Country of issuer
Selection Text: P_FF = Unrestricted assets
Selection Text: P_FRWHRG = ID: Issue in foreign currency
Selection Text: P_GRP = Sort fields as group totals
Selection Text: P_MAXERR = Cancel after X errors
Selection Text: P_NACHR = ID: Secondary bonds
Selection Text: P_NOZERO = Do not display zero values
Selection Text: P_RANL = Security ID number
Selection Text: P_SANLF = Product category of security
Selection Text: P_SCUEX = Cum/ex
Selection Text: P_SUMBU = Totals rows book/current vals
Selection Text: P_WHRG = Issue currency of security
Selection Text: SO_GSART = Product type
Selection Text: STICHTAG = Key date
Selection Text: S_BPVKAT = BPV category
Title: Securities Report for Swiss Regulatory Reporting (RFVWCH01)
Text Symbol: 511 = Hedge fund
Text Symbol: 510 = Text 510
Text Symbol: 505 = Int.
Text Symbol: 504 = etc.
Text Symbol: 503 = Key date
Text Symbol: 502 = ID number:
Text Symbol: 501 = Company code:
Text Symbol: 425 = Text 425
Text Symbol: 424 = Text 424
Text Symbol: 423 = Text 423
Text Symbol: 422 = Exch. rates
Text Symbol: 421 = BPV position list without grouping:
Text Symbol: 420 = Sort group totals:
Text Symbol: 418 = BPV weighting
Text Symbol: 417 = ValCl
Text Symbol: 416 = FX rate
Text Symbol: 512 = Free values
Text Symbol: 600 = Price calc. types
Text Symbol: 601 = BPV selection crit.
Text Symbol: 901 = *** Error: Inconsistent dataset results in division by zero ***
Text Symbol: 960 = Al.Curr. Nominal/Unit Purch.price Mkt value Curr.price Old book val. New book val
Text Symbol: 961 = Alloc. Curr. Nominal/unit Purch.price Purch.rate Purch.price LC calc.FC rate Appr./deprec. in LC Depr.cos
Text Symbol: 962 = Mkt value Curr.price LC curr. val. FC rate Security
Text Symbol: 963 = Old book val. Old book price Old LC book value calc.FC rate Foreign currency FC amount
Text Symbol: 964 = New book val. New book price New LC book value FC rate Total LC amount
Text Symbol: 965 = Total
Text Symbol: 966 = Total
Text Symbol: 967 = Error translating currency
Text Symbol: BID = Incorrect valuat. ID:
Text Symbol: E01 = Period for following ID number not closed (cancel after
Text Symbol: E02 = error)
Text Symbol: S01 = No key fig. total with zero values
Text Symbol: 205 = |** Error: Execute period-end closing on key date *** |
Text Symbol: 204 = |** Error: Period-end closing already executed after key date *** |
Text Symbol: 203 = *** Error: Actual records after key date ***
Text Symbol: 113 = Text 113
Text Symbol: 111 = *** Error: No security price available - No flows created ***
Text Symbol: 110 = *** Info.: Specified valuation price was used ***
Text Symbol: 109 = *** Warning: Valuation cannot be posted - See error log for posting interface ***
Text Symbol: 108 = *** Warning: Bal.sheet account not defined in table T037X (valuation principles) - Valuation cannot be carried out ***
Text Symbol: 107 = *** Info: No valuation price on key date, previous price was used ***
Text Symbol: 106 = *** Info: Actual records after key date --> Dynamic roll-up ***
Text Symbol: 105 = *** Warning: Reversal not possible, planned recs exist before key date
Text Symbol: 104 = *** Repeated: No valuation yet exists
Text Symbol: 103 = *** Info: Actual records after key date --> Dynamic roll-up ***
Text Symbol: 102 = *** Error: Posting not possible, since planned records still exist before key date ***
Text Symbol: 101 = *** Warning: Contract was already valued on key date - No revaluation ***
Text Symbol: 100 = *** Warning: Valuation after key date exists - No valuation possible ***
Text Symbol: 073 = Exchange rate deprec. LC
Text Symbol: 072 = Proport. depreciation Proport. depr. LC
Text Symbol: 071 = Capitalized charges Capitalized chges LC
Text Symbol: 064 = Sec.appr./deprec. New book val. New book price New book val. LC FC price Total
Text Symbol: 063 = Old book val. Old book price Old book val. LC FC price For. curr.
Text Symbol: 062 = Price date Mkt val. Date Current price Mkt val. Date LC FC price Security
Text Symbol: 061 = Currency Nominal/unit Mkt val. Purch. Purch.price Mkt val. Purch.LC FC price Appr./depr.in LC
Text Symbol: 060 = Al.Curr. Nominal/unit Purch.price Mkt value Curr.price Old book val. New book val
Text Symbol: 059 = ....................................................................................................................................
Text Symbol: 050 = CoCd ID number Sec.acct Short text Valuation class
Text Symbol: 010 = Securities valuation on
Text Symbol: 000 = RF_VV: Security valuation on key date
Text Symbol: 211 = *** Error: No entry in table TCURA when FM 'EXCHANGE_RATE_SERVICE' is called
Text Symbol: 415 = Nominal/unit
Text Symbol: 413 = SecAc
Text Symbol: 412 = ID number
Text Symbol: 411 = CoCd
Text Symbol: 410 = SEC pr.
Text Symbol: 409 = Notat.
Text Symbol: 408 = FC curr.val.
Text Symbol: 407 = LC curr.val.
Text Symbol: 406 = No
Text Symbol: 405 = Y
Text Symbol: 404 = Book val.FC
Text Symbol: 403 = Book val.LC
Text Symbol: 402 = Value included FC
Text Symbol: 401 = Value included LC
Text Symbol: 309 = Listed
Text Symbol: 308 = Prod. cat.
Text Symbol: 307 = Secondary
Text Symbol: 306 = Indust./SEC class.
Text Symbol: 305 = Currncy
Text Symbol: 304 = Country key
Text Symbol: 303 = Foreign ID
Text Symbol: 302 = For. currency ID
Text Symbol: 301 = BPV category
Text Symbol: 216 = *** Error: No entry in table TCURZ when FM 'EXCHANGE_RATE_SERVICE' is called
Text Symbol: 215 = *** Error: No entry in table TCURY when FM 'EXCHANGE_RATE_SERVICE' is called
Text Symbol: 214 = *** Error: No entry in table TCURX when FM 'EXCHANGE_RATE_SERVICE' is called
Text Symbol: 213 = *** Error: No entry in table TCURC when FM 'EXCHANGE_RATE_SERVICE' is called
Text Symbol: 212 = *** Error: No entry in table TCURB when FM 'EXCHANGE_RATE_SERVICE' is called
INCLUDES used within this REPORT RFVWCH01
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:
ACCUMULATION_INIT CALL FUNCTION 'ACCUMULATION_INIT' EXPORTING FOREIGN_CURRENCY = SANLA-REWHR LOCAL_CURRENCY = T001-WAERS.
ACCUMULATION_ADD CALL FUNCTION 'ACCUMULATION_ADD' EXPORTING RLDEPO = SDEPO-RLDEPO VBEPP = VZZBEPP X_SSD = SPACE.
TRANSACTIONS_SEC_VIEW_SPLIT CALL FUNCTION 'TRANSACTIONS_SEC_VIEW_SPLIT' EXPORTING X_BEKI_OR_BEPI = 'K' TABLES TBEKI = YBEKI TBEPI = YBEPI TBEVI = IBEVI.
ACCUMULATION_RESULT CALL FUNCTION 'ACCUMULATION_RESULT' IMPORTING REVAL = GES.
PRICE_CALCULATION_LAC CALL FUNCTION 'PRICE_CALCULATION_LAC' EXPORTING I_BUKRS = SDEPO-BUKRS I_RANL = SDEPO-RANL I_REVAL = GES * i_rldepo = sdepo-rldepo "don't exist ab 40 I_STICHTAG = STICHTAG IMPORTING E_PWKURS = LAC_KURS.
B_K_BEWERTUNGS_ID CALL FUNCTION 'B_K_BEWERTUNGS_ID' EXPORTING BETRAG_BUCH = GES-BBUCHWR BETRAG_KAUF = GES-BKAUFWR BETRAG_TAG = BTAGWR SABSCHREIBUNG = TZRPR-SABSGS SZUSCHREIBUNG = TZRPR-SZUSGS IMPORTING BEWERTUNGS_ID = BEW_ID.
B_K_BEWERTUNGS_ID CALL FUNCTION 'B_K_BEWERTUNGS_ID' EXPORTING BETRAG_BUCH = GES-BBUCHWR BETRAG_KAUF = GES-BKAUFWR BETRAG_TAG = BTAGWR SABSCHREIBUNG = TZRPR-SABSFW SZUSCHREIBUNG = TZRPR-SZUSFW IMPORTING BEWERTUNGS_ID = BEW_ID.
B_K_BEWERTUNGS_ID CALL FUNCTION 'B_K_BEWERTUNGS_ID' EXPORTING BETRAG_BUCH = GES-BBUCHWR BETRAG_KAUF = GES-BKAUFWR BETRAG_TAG = BTAGWR SABSCHREIBUNG = TZRPR-SABSFW SZUSCHREIBUNG = TZRPR-SZUSFW IMPORTING BEWERTUNGS_ID = BEW_ID.
CONVERSION_GIVING_RATE_F CALL FUNCTION 'CONVERSION_GIVING_RATE_F' EXPORTING FOREIGN_AMOUNT = GES-BBUCHWR FOREIGN_CURRENCY = DEPOWAERS LOCAL_AMOUNT = GES-BBUCHHW LOCAL_CURRENCY = HW * rkursber = s_rkursber "ST40 IMPORTING RATE_F = WRK_ALT_F. "Umrechnungskurs: Buch
CONVERSION_GIVING_RATE_F CALL FUNCTION 'CONVERSION_GIVING_RATE_F' EXPORTING FOREIGN_AMOUNT = GES-BKAUFWR FOREIGN_CURRENCY = DEPOWAERS LOCAL_AMOUNT = GES-BKAUFHW LOCAL_CURRENCY = HW * rkursber = s_rkursber "st40 IMPORTING RATE_F = WRK_KAUF_F. "Umrechnungskurs: Kauf
B_K_BEWERTUNGS_ID CALL FUNCTION 'B_K_BEWERTUNGS_ID' EXPORTING BETRAG_BUCH = GES-BBUCHHW BETRAG_KAUF = GES-BKAUFHW BETRAG_TAG = BTAGHW SABSCHREIBUNG = TZRPR-SABSGS SZUSCHREIBUNG = TZRPR-SZUSGS IMPORTING BEWERTUNGS_ID = BEW_ID.
EXCHANGE_RATE_SERVICE CALL FUNCTION 'EXCHANGE_RATE_SERVICE' EXPORTING I_BETRAG = CD_WRBETR I_GDATU = CD_DATE * I_HANDELSPLATZ = S_RKURSHDL "markt /SAP45B1 I_KURS = CD_RATE I_KURSBER = S_RKURSBER "markt * I_MWAER = E07 * I_SSEEK = '1' "SAP45B1 I_WAEHRUNG_NACH = CD_HW I_WAEHRUNG_VON = CD_FW IMPORTING O_BETRAG = CD_HWBETR O_KURS = CD_RATE EXCEPTIONS * NO_RECORD_FOUND_TCURA = 01 "SAP45B1 * NO_RECORD_FOUND_TCURB = 02 "SAP45B1 * NO_RECORD_FOUND_TCURC = 03 "SAP45B1 * NO_RECORD_FOUND_TCURX = 04 "SAP45B1 * NO_RECORD_FOUND_TCURY = 05 "SAP45B1 * NO_RECORD_FOUND_TCURZ = 06 "SAP45B1 * OVERFLOW_BETRAG = 07 "SAP45B1 * OVERFLOW_KURS = 08. "SAP45B1
STOCK_RATE_SELECT CALL FUNCTION 'STOCK_RATE_SELECT' EXPORTING * anlageform = sanla-sanlf "don't exist ab 4.0
EXCHANGE_RATE_SERVICE call function 'EXCHANGE_RATE_SERVICE' exporting i_betrag = bkurs_tag i_gdatu = stichtag i_kursber = s_rkursber i_waehrung_nach = ges-sbwhr i_waehrung_von = noti_waers importing o_betrag = bkurs_tag o_faktor_nach = l_faktor_nach o_faktor_von = l_faktor_von exceptions no_rate_found = 01 no_factors_found = 02 no_spread_found = 03 overflow = 04 NO_KURSTYP_FOUND = 05 no_kursber_found = 06 derived_2_times = 07.
EVALUATION_PARA_DETERMINE CALL FUNCTION 'EVALUATION_PARA_DETERMINE' EXPORTING BUKRS = SDEPO-BUKRS RANL = SDEPO-RANL REVALUATION_RANGE = '01' RLDEPO = SDEPO-RLDEPO IMPORTING REVALUATION_AMORTICED_COST = SREVAC REVALUATION_CLASS = SREVCLS REVALUATION_PRINCIPLE = SREVPRC REVALUATION_TYPE = SREVTYP.
TRANSACTION_TYPE_SELECT CALL FUNCTION 'TRANSACTION_TYPE_SELECT' EXPORTING I_RANTYP = '2' I_SBEWZITI = SBEWZITI * 2.22F
CONVERSION_GIVING_RATE_F CALL FUNCTION 'CONVERSION_GIVING_RATE_F' EXPORTING FOREIGN_AMOUNT = BWR FOREIGN_CURRENCY = DEPOWAERS LOCAL_AMOUNT = BHW LOCAL_CURRENCY = HW IMPORTING RATE_F = KURS_F.
SINGLE_EVAL_NEVAL CALL FUNCTION 'SINGLE_EVAL_NEVAL' IMPORTING E_NEVAL_HIGH = NEVAL_HIGH TABLES I_BEPP = SINGLE_BEPP EXCEPTIONS ASSIGN_NOT_POSSIBLE = 01.
ACCUMULATION_INIT CALL FUNCTION 'ACCUMULATION_INIT' EXPORTING FOREIGN_CURRENCY = DEPOWAERS LOCAL_CURRENCY = T001-WAERS RANTYP = '2' SOLL_IST_REVAL = ' ' S_REVAL = '1' S_RLOAM = '1' S_RPROF = '1' X_STORNO_VERARBEITEN = ' '.
ACCUMULATION_ADD CALL FUNCTION 'ACCUMULATION_ADD' EXPORTING RLDEPO = SDEPO-RLDEPO VBEPP = VZZBEPP * verarb = space. "*Ä
ACCUMULATION_RESULT CALL FUNCTION 'ACCUMULATION_RESULT' IMPORTING REVAL = GES.
FTBP_READ_R_PARTNER_CHECK CALL FUNCTION 'FTBP_READ_R_PARTNER_CHECK' EXPORTING I_PARTNER = VWPANLA-REPKE IMPORTING E_BP000_ENTRY = BP000 EXCEPTIONS PARTNER = 1 PARTNER_NOT_RELEASED = 2 WRONG_PARAMETERS = 3 OTHERS = 4 .
EXCHANGE_RATE_SERVICE CALL FUNCTION 'EXCHANGE_RATE_SERVICE' EXPORTING I_BETRAG = BBNEUWR I_GDATU = STICHTAG * I_HANDELSPLATZ = HPL_BPV "SAP45B1 * I_KURS = CD_RATE I_KURSBER = KURSBPV * I_SSEEK = '1' "SAP45B1 I_WAEHRUNG_NACH = HW I_WAEHRUNG_VON = DEPOWAERS IMPORTING O_BETRAG = BBNEUHW O_KURS = SF_BPVKURS EXCEPTIONS * NO_RECORD_FOUND_TCURA = 01 "SAP45B1 * NO_RECORD_FOUND_TCURB = 02 "SAP45B1 * NO_RECORD_FOUND_TCURC = 03 "SAP45B1 * NO_RECORD_FOUND_TCURX = 04 "SAP45B1 * NO_RECORD_FOUND_TCURY = 05 "SAP45B1 * NO_RECORD_FOUND_TCURZ = 06 "SAP45B1 * OVERFLOW_BETRAG = 07 "SAP45B1 * OVERFLOW_KURS = 08. "SAP45B1
B_K_BEWERTUNGS_ID CALL FUNCTION 'B_K_BEWERTUNGS_ID' EXPORTING BETRAG_BUCH = GES-BBUCHWR BETRAG_KAUF = GES-BKAUFWR BETRAG_TAG = BTAGWR SABSCHREIBUNG = TZRPR-SABSWP SZUSCHREIBUNG = TZRPR-SZUSWP IMPORTING BEWERTUNGS_ID = BEW_ID.
B_K_BEWERTUNGS_ID CALL FUNCTION 'B_K_BEWERTUNGS_ID' EXPORTING BETRAG_BUCH = BBUCHHW BETRAG_KAUF = BKAUFHW BETRAG_TAG = HWTAG SABSCHREIBUNG = TZRPR-SABSFW SZUSCHREIBUNG = TZRPR-SZUSFW IMPORTING BEWERTUNGS_ID = BEW_ID.
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 RFVWCH01 or its description.
RFVWCH01 - Securities Report for Swiss Regulatory Reporting (RFVWCH01) RFVWCH01 - Securities Report for Swiss Regulatory Reporting (RFVWCH01) RFVWBWS1 - Securities: Reverse Foreign Exchange Valuation RFVWBWS1 - Securities: Reverse Foreign Exchange Valuation RFVWBWS0 - Securities: Reverse Rate/Price Valuation RFVWBWS0 - Securities: Reverse Rate/Price Valuation