SAP Reports / Programs

comments icon Comments

RFSZIS00 SAP ABAP Report - G/L Account Interest Scale







RFSZIS00 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Program RFSZIS00 generates an interest scale (account balance interest calculation) for G/L accounts in local currency , and outputs a list...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 RFSZIS00 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 RFSZIS00. "Basic submit
SUBMIT RFSZIS00 AND RETURN. "Return to original report after report execution complete
SUBMIT RFSZIS00 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: BANKVZ = Standard interest calculation
Selection Text: BI-BAHAB = Movement Type - Credit
Selection Text: BI-BASOL = Movement Type - Debit
Selection Text: BI-BLDAT = Document date of session
Selection Text: BI-BUCH = Post interest settlements
Selection Text: BI-BUDAT = Posting date of session
Selection Text: BI-BUPER = Posting period
Selection Text: BI-GSBER = Posting to business area
Selection Text: BI-KEEP = Hold Processed Session
Selection Text: BI-NAME = Session name
Selection Text: BI-RVAL = Post also if val. date in past
Selection Text: BI-SGTXT = Posting segment text
Selection Text: BI-STAMM = Update master record
Selection Text: BI-VALUT = Value date of session
Selection Text: BI-XBLNR = Reference data
Selection Text: BI-ZUONR = Assignment number
Selection Text: BISZEIT = To period
Selection Text: ZINSSPLI = Interest splitting
Selection Text: ZINSSAUE = Interest rate overview
Selection Text: ZINS-KZ = Interest calculation indicator
Selection Text: WAEHRUNG = Currency
Selection Text: VONZEIT = From period
Selection Text: VD-STUFE = Summarization level (0-3)
Selection Text: VAL-TYP = Reference date (1,2,3)
Selection Text: SCHALTJR = Leap year
Selection Text: SALDENZZ = Additional balance line
Selection Text: HEADKTO = Header account
Selection Text: HEADBUKR = Header company code
Selection Text: GESCHBER = Business area
Selection Text: DEBUGMOD = Additional log
Selection Text: DEBKONTO = Accounts for additional log
Selection Text: DATLTZZL = Date of last interest run
Selection Text: DAT2TYP = Additional date
Selection Text: CASHPOOL = Cash pooling
Title: G/L Account Interest Scale
Text Symbol: 257 = No valid entry for currency &WAERS found.
Text Symbol: 258 = &SCNTR documents selected for account &KTNRA in company code &BUKRS
Text Symbol: 259 = Exporting item data to INDX file (&INDEX index)





Text Symbol: 260 = Number of items: &PCNTR
Text Symbol: 261 = Error during export. Enlarge INDX file.
Text Symbol: 262 = Error during import from INDX.
Text Symbol: 263 = Importing item data from INDX file (&INDEX index)
Text Symbol: 264 = Selecting items that are before int calc lower limit &VZUNT and
Text Symbol: 265 = after or on the earliest value date &AELRV in the past
Text Symbol: 266 = Selecting interest rate changes
Text Symbol: 268 = Determining date of last interest run
Text Symbol: 269 = Date of last interest run maintained in master record: &DATLZ
Text Symbol: 270 = Date of last interest run not maintained in master record: ->
Text Symbol: 256 = Interest rate cannot be determined
Text Symbol: 255 = No valid entry for interest indicator &VZSKZ found.
Text Symbol: 254 = No batch input for account &KTNRA in company code &BUKRS
Text Symbol: 252 = Account &KTNRA has value dates in the past
Text Symbol: 251 = No posting records generated
Text Symbol: 250 = Int ID &VZSKZ does not allow any credit interest payment (&WAERS &ZINBE)
Text Symbol: 249 = Min/max amount &BETRA is greater than interest amount &ZINBE
Text Symbol: 246 = Processing account &KTNRA in company code &BUKRS
Text Symbol: 244 = Interest rate change on &DATUM
Text Symbol: 243 = Item has earliest value date in the past: &VALUT
Text Symbol: 242 = Master record information of account &KTNRA selected
Text Symbol: 241 = Account &KTNRA in company code &BUKRS skipped
Text Symbol: 237 = Item &BELNR &BUZEI in company code &BUKRS selected
Text Symbol: 236 = Balance carried forward corrected, since value date in past affects last year
Text Symbol: 271 = Date of last interest run per parameter: &DATLZ
Text Symbol: 983 = Set Negative Interest Rates to Zero
Text Symbol: 982 = Negative int. rates allowed
Text Symbol: 981 = Negative int. rates not allowed
Text Symbol: 980 = Negative Interest Rates
Text Symbol: 916 = Value Date Balance
Text Symbol: 915 = Days
Text Symbol: 914 = Amount
Text Symbol: 913 = Post Date
Text Symbol: 912 = Doc. Date
Text Symbol: 911 = Doc. No.
Text Symbol: 910 = Val.date
Text Symbol: 904 = Cash pooling
Text Symbol: 903 = Additional log
Text Symbol: 902 = Posting control





Text Symbol: 901 = Output control
Text Symbol: 900 = Further selections
Text Symbol: 503 = -------------------------------------
Text Symbol: 502 = Int ID Curr. DateFROM Transaction type
Text Symbol: 501 = in the following interest transaction types:
Text Symbol: 500 = An entry for amount FROM = 0 is missing (in T056A, time-dependent terms)
Text Symbol: 285 = Used by RFDZIS00
Text Symbol: 282 = No interest calculation (and batch input) for acct &KTNRA in co. code &BUKRB
Text Symbol: 280 = Account has no items in calculation period and bal. carried forward is zero
Text Symbol: 279 = Bal.carried fwd adjusted, since predated val. date already posted last yr
Text Symbol: 278 = Evaluating business area &GEBER for calculating balance carried forward
Text Symbol: 273 = Posting made in &WAER1 to the &WAER2 account &KONTO -> items skipped.
Text Symbol: 272 = Item &BELNR &BUZEI stored temporarily (evaluate only if value dates in past)
Text Symbol: 030 = Do not use since occupied by RFSZIS10
Text Symbol: 031 = Do not use since occupied by RFSZIS10
Text Symbol: 032 = Do not use since occupied by RFSZIS10
Text Symbol: 033 = Do not use since occupied by RFSZIS10
Text Symbol: 034 = Do not use since occupied by RFSZIS10
Text Symbol: 035 = Do not use since occupied by RFSZIS10
Text Symbol: 036 = Calculation period
Text Symbol: 038 = Batch input session
Text Symbol: 039 = Int rate(%) Interest
Text Symbol: 040 = ------------------------------------
Text Symbol: 042 = Date FROM Amount FROM Int rate(%)
Text Symbol: 043 = Date FROM Amount FROM Int rate(%)
Text Symbol: 044 = -------------------------------------------
Text Symbol: 045 = Interest rate overview
Text Symbol: 046 = Terms for debit interest from
Text Symbol: 047 = Terms for credit interest from
Text Symbol: 048 = Created
Text Symbol: 049 = Error during generation of batch input session
Text Symbol: 100 = |CC IID Curr. Acct Description |
Text Symbol: 101 = |ValDte Doc no. ValDte Amount Value date bal. Days |
Text Symbol: 102 = |ValDte Debit Credit Value date bal. Days |
Text Symbol: 103 = | Amount FROM Int rate IntCalc.Numerat. |
Text Symbol: 026 = Past period with post-entered value dates
Text Symbol: 002 = to
Text Symbol: 003 = Balance Carryforward
Text Symbol: 004 = Closing balance



Text Symbol: 005 = Int.calc.numer. Int.rate (%) Interest
Text Symbol: 006 = -----------------------------------------------------------------
Text Symbol: 008 = Total interest
Text Symbol: 009 = Interest rate change
Text Symbol: 010 = G/L account interest scale
Text Symbol: 011 = Date
Text Symbol: 012 = Page
Text Symbol: 013 = Closing balance incl. interest
Text Symbol: 014 = D
Text Symbol: 015 = C
Text Symbol: 016 = |CC IID Currency D/C ind. Interest |
Text Symbol: 017 = DR/CR shift
Text Symbol: 018 = |CC IID Currency Interest |
Text Symbol: 020 = The following entries are missing in the company code table
Text Symbol: 021 = CC
Text Symbol: 022 = --
Text Symbol: 023 = D-
Text Symbol: 024 = C-
Text Symbol: 025 = Start of new calculation period
Text Symbol: 212 = Interest indicator: &VZSKZ
Text Symbol: 213 = Calculation frequency &ZINRT not in master record or general terms table
Text Symbol: 214 = Settlement day &ABRTG in general terms table invalid. "31" used.
Text Symbol: 215 = Determining interest calculation period
Text Symbol: 216 = Date of last interest calculation: &ZINDT
Text Symbol: 217 = Interest calculation lower limit: &UNTER, Upper limit: &OBERG
Text Symbol: 218 = Checking if lower limit is before upper limit
Text Symbol: 219 = Date of last int calc does not fit -> Lower and upper limit from control card
Text Symbol: 220 = Checking if calculated upper limit is not greater than that of control card
Text Symbol: 221 = Could not determine fiscal year for company code &BUKRS.
Text Symbol: 222 = Company code &BUKRS of account &KTNRA selected for interest calculation
Text Symbol: 223 = Business area &GEBER from fiscal year &GJAHR in company code &BUKRS read
Text Symbol: 225 = Checking if fiscal year is correct
Text Symbol: 226 = Index to item &BELNR &BUZEI in company code &BUKRS read
Text Symbol: 227 = Checking if document is not statistical
Text Symbol: 228 = Checking if special G/L indicator is equal to SPACE
Text Symbol: 229 = Document &BELNR has no valid value date. Posting date used.
Text Symbol: 230 = Item &BELNR &BUZEI in company code &BUKRS read
Text Symbol: 232 = Predated value date: Item value date &VALUT is after upper limit &VZOBE
Text Symbol: 233 = Item &BELNR &BUZEI in company code &BUKRS not selected
Text Symbol: 234 = Value date in the past: Item value date &VALUT is before lower limit &VZUNT
Text Symbol: 235 = and CPU date &DATUM is after date of last interest run &DATLT
Text Symbol: 211 = Checking if interest calculation type is set to "S"
Text Symbol: 104 = | Amount FROM Int rate Interest |
Text Symbol: 105 = |ValDte Doc no. Doc dte Amount Value date bal. Days |
Text Symbol: 106 = |ValDte Doc no. PostDte Amount Value date bal. Days |
Text Symbol: 107 = |DocDte Doc no. ValDte Amount Value date bal Days |
Text Symbol: 108 = |DocDte Doc no. DocDte Amount Value date bal. Days |
Text Symbol: 109 = |DocDte Doc no. PostDte Amount Value date bal. Days |
Text Symbol: 110 = |PostDte Doc no. ValDte Amount Value date bal. Days |
Text Symbol: 111 = |PostDte Doc no. DocDte Amount Value date bal. Days |
Text Symbol: 112 = |PostDte Doc no. PostDte Amount Value date bal. Days |
Text Symbol: 113 = |DocDte Debit Credit Value date bal. Days |
Text Symbol: 114 = PDate Debit Cred. Val.Date Bal. Days |
Text Symbol: 200 = Program started with additional log
Text Symbol: 201 = Record number &RCNTR read
Text Symbol: 202 = Account &KTNRA read
Text Symbol: 203 = Company code &BUKRS for account &KTNRA read
Text Symbol: 204 = Checking selection options
Text Symbol: 205 = Selection option &SELEC checked
Text Symbol: 206 = Check whether interest indicator from G/L acct master does not equal SPACE
Text Symbol: 207 = Check whether company code &BUKRS exists in table 001
Text Symbol: 208 = Company code &BUKRS does not exist in the company code table
Text Symbol: 209 = Checking if interest indicator &VZSKZ exists in interest calculation table
Text Symbol: 210 = Interest indicator &VZSKZ does not exist in interest calculation table


INCLUDES used within this REPORT RFSZIS00

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:

RS_REFRESH_FROM_DYNAMICAL_SEL
  Call function 'RS_REFRESH_FROM_DYNAMICAL_SEL'                  "915544
  exporting Curr_report        = sy-repid                        "915544
            Mode_write_or_move = 'W'                             "915544
  importing P_trange           = Gt_trange                       "915544
  exceptions Not_found = 1.                                      "915544

CONVERSION_EXIT_ALPHA_INPUT
  CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
    EXPORTING
      input  = headkto
    IMPORTING
      output = headkto
    EXCEPTIONS
      OTHERS = 1.

READ_HAUPTBUCH_AND_TEXT
    CALL FUNCTION 'READ_HAUPTBUCH_AND_TEXT'
      EXPORTING
        buchungskreis        = headbukr
        sachkonto            = headkto
        sprache              = sy-langu
      IMPORTING
        kontenplan_wa        = ska1
        sachkonto_wa         = skb1
        text_wa              = skat
      EXCEPTIONS
        kontenplan_not_found = 1
        sachkonto_not_found  = 2
        text_not_found       = 3
        OTHERS               = 4.

READ_HAUPTBUCH_AND_TEXT
    CALL FUNCTION 'READ_HAUPTBUCH_AND_TEXT'
      EXPORTING
        buchungskreis        = headbukr
        sachkonto            = headkto
        sprache              = sy-langu
      IMPORTING
        kontenplan_wa        = ska1
        sachkonto_wa         = skb1
        text_wa              = skat
      EXCEPTIONS
        kontenplan_not_found = 1
        sachkonto_not_found  = 2
        text_not_found       = 3
        OTHERS               = 4.

CONVERT_TO_LOCAL_CURRENCY
            CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY'
              EXPORTING
                date             = valutn
                foreign_amount   = gzinsen
                foreign_currency = wawaers
                local_currency   = t056s-waerschl
                type_of_rate     = 'M'
              IMPORTING
                local_amount     = wzinsen.


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


   
 

RFSZIS00 - G/L Account Interest Scale
RFSZIS00 - G/L Account Interest Scale
RFSZI005 - Include for Project Interest Calculation
RFSZI000 - Interest Scale
RFSZI000 - Interest Scale
RFSUSA00_NACC - G/L Account Balances