DS4K900793 --> TRM: FY25#SP-FX-Oracle report

​

ZFSTRMR_0001_F01

​

DS4K900762 --> TRM : FY25 Bank Lines Report Changes for 45A

​

ZFSTRMR_0019_F01

ZFSTRMR_0019_TOP

​

DS4K900781 --> ECB SOFR CONFIG 13.09.2024

DS4K900363 --> TRM: ALM Repayment changes 19.12.2023

    Report Source Code

​

    ZFSTRMR_0020

    ZFSTRMR_0020_F

    ZFSTRMR_0020_T

​

Report Texts

​

    ZFSTRMR_0020

    h~name_org1 AS bank_name,

*        h~count3 as count

         i~nordext,                 " Added by Vaishnavi/Jainam on 05.08.2024

         i~delfz AS end_date

         INNER JOIN but000 AS h ON a~kontrh = h~partner

         AND a~sgsart IN ('10A' , '10B' , '10C' ,  '99A', '20A' , '24A', '24B', '20B', '45A')", '10D') " Changed by Rakshit Shetty on 19.06.2024 " '45A' Added by Vaishnavi/Jainam on 05.08.2024  "'10D' Added by Vaishnavi/Jainam on 16.09.2024

"Commented/Added by Vaishnavi/Jainam to add 45A Logic based on VTBFHAZU end_date on 05.08.2024

*    AND  a~delfz GE @p_date

    AND  i~delfz GE @p_date

      " Added by Vaishnavi/Jainam on 16.09.2024 to add 10D facility logic for 45A

  LOOP AT it_vtb ASSIGNING FIELD-SYMBOL(<fs_vtb>) WHERE sgsart = '45A'.

    lv_rfha = |{ <fs_vtb>-nordext ALPHA = IN }|.

    SELECT SINGLE facilitynr FROM vtbfha INTO <fs_vtb>-facilitynr WHERE bukrs = p_bukrs AND rfha = lv_rfha.

  ENDLOOP.

  " End of addition)

​

    " Added by Vaishnavi/Jainam on 05.08.2024 to add 45A logic (

    IF <fs_vtb>-sgsart = '45A'.

      CLEAR : gs_final-out_balance, gv_rfha.

      " Modified by Vaishnavi/Jainam to display 10D as Product Variant on 29.08.2024(

      gs_final-sgsart = '10D'."<fs_vtb>-sgsart. " End of Modification)

      SELECT SINGLE ltx FROM tzpat INTO gs_final-ltx WHERE spras = 'EN' AND gsart = gs_final-sgsart. " Added by Vaishnavi/Jainam on 12.09.2024 to add the 10d variant name for 45A prd type

      gs_final-mat_date = <fs_vtb>-end_date.

      gs_final-nxt_prin_rep_date = <fs_vtb>-end_date.

​

      gv_rfha = <fs_vtb>-nordext.

      gv_rfha = |{ gv_rfha ALPHA = IN }|.

​

      " Added by Vaishnavi/Jainam on 05.08.2024 to add 45A Logic (

      SELECT *

        FROM trlv_trans_pos

        INTO TABLE @DATA(gt_tpm13_2)

        WHERE company_code = @p_bukrs

        AND deal_number = @gv_rfha

        AND ( flowtype = 'MM1104+' )

        AND booking_state NE 6.

      SORT gt_tpm13_2 BY trldate ASCENDING.

      " End of Addition )

​

      READ TABLE gt_tpm13_2 ASSIGNING FIELD-SYMBOL(<fs_tpm13_2>) WITH KEY company_code = <fs_vtb>-bukrs deal_number = gv_rfha .

      IF sy-subrc = 0.

        gs_final-out_balance = <fs_tpm13_2>-valuation_amt.

*        gs_final-og_lim_amt = <fs_tpm13_2>-valuation_amt.

      ENDIF.

    ENDIF.

​

          b~sfhaart

          *    AND b~rfhazu = 2 " Commented by Vaishnavi/Jainam on 26.09.2024

          txn_type    = <fs>-zsfhaart )

            " Added by Vaishnavi/Jainam on 26.09.2024 to delete the 10D prd_type based on txn_type(

  DELETE gt_final WHERE sgsart = '10D' AND txn_type = '200'.

  " End of Addition)

​