SAP Reports / Programs
RFKLET00 SAP ABAP Report - Extract for the Accumulated Historical Balance Audit Trail
RFKLET00 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Program RFKLET00 creates the extract (balance audit trail data set) for the historical balance audit trail...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 RFKLET00 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 RFKLET00. "Basic submit
SUBMIT RFKLET00 AND RETURN. "Return to original report after report execution complete
SUBMIT RFKLET00 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: ACCTYPE = Account Type
Selection Text: AUTOSEL = Automatic Selection
Selection Text: BA_BUPER = Reconcile a Period
Selection Text: BA_CHECK = Suppress Reconciliation
Selection Text: DKONTO = Customer Account
Selection Text: DS_INL = Old Dataset Logical Name
Selection Text: DS_OUTL = New Dataset Logical Name
Selection Text: HIGHDATE = Upper Limit (CPU Date)
Selection Text: IACC = Archive Account
Selection Text: IBAREA = Archive Business Area
Selection Text: IBUKRS = Archive Company Code
Selection Text: ICLEARY = Archive up to and incl.fisc.yr
Selection Text: IKOART = Archive Account Type
Selection Text: IRESET = Reset Tables
Selection Text: XWORKR = Read Extract from Work File
Selection Text: XWORK = Extract in Work File
Selection Text: SKONTO = G/L Account
Selection Text: P_TABOUT = In Database Table
Selection Text: P_TABIN = From Database Table
Selection Text: POSTEN = Accounts w/o Items
Selection Text: PA_WORK = Work File Logical Name
Selection Text: PAR_GKON = Offsetting Acct Determination
Selection Text: MERGE_N = Create New Dataset
Selection Text: MERGE_F = Create Initial Dataset
Selection Text: MAX_10 = File Size in MB
Selection Text: LOWDATE = Lower Limit (CPU Date)
Selection Text: KKONTO = Vendor Account
Selection Text: I_ONLY = Archive only
Title: Extract for the Accumulated Historical Balance Audit Trail
Text Symbol: 214 = Debit balance
Text Symbol: 216 = Credit balance
Text Symbol: 217 = ...Total Items ....Total Master .........Balance
Text Symbol: 218 = Special G/L balance
Text Symbol: 300 = Termination: incorrect sort indicator (not HKONT)
Text Symbol: 410 = Dataset parameters:
Text Symbol: 411 = Client:
Text Symbol: 412 = Report to be generated:
Text Symbol: 413 = Ignore indicator:
Text Symbol: 414 = Sort field:
Text Symbol: 450 = Specify old dataset
Text Symbol: 451 = Specify new dataset
Text Symbol: 452 = Error: old and new datasets are identical!
Text Symbol: 460 = Error opening work file
Text Symbol: 461 = There are no work files opened. Termination!
Text Symbol: 462 = Name of Work Files Recds
Text Symbol: F10 = Processing
Text Symbol: 213 = --------------------------------------------------------------------
Text Symbol: 040 = Start of selection
Text Symbol: 035 = current data set
Text Symbol: 034 = Sort error: Final d/set
Text Symbol: 032 = Processing terminated!
Text Symbol: 031 = Error reading data:
Text Symbol: 030 = Error during transfer:
Text Symbol: 020 = Selection statistics Master records Items
Text Symbol: 019 = Period upper limit:
Text Symbol: 018 = Period lower limit:
Text Symbol: 017 = Current selection period:
Text Symbol: 016 = Work file does not exist
Text Symbol: 015 = Work file name must be specified
Text Symbol: 014 = Either read or write to work file
Text Symbol: 013 = Mark at least one evaluation with an 'X'.
Text Symbol: 012 = Only one evaluation is allowed.
Text Symbol: 010 = Incorrect period selection.
Text Symbol: 007 = Parameter BELMAX Permits Only One Company Code
Text Symbol: 006 = List of items without master record information:
Text Symbol: 005 = Start next run with this document number
Text Symbol: 004 = last document
Text Symbol: 003 = Documents cancelled
Text Symbol: 002 = Doc.no. LI DD A CoCd G/L acct FY BA
Text Symbol: 001 = Selection by
Text Symbol: 212 = V CoCd .....Acct Year BArea ...Total Items ....Total Master .........Balance
Text Symbol: 210 = Master record balances not equal to item balances:
Text Symbol: 140 = No.of records in work file:
Text Symbol: 135 = Reset DB table
Text Symbol: 134 = Number of master records/items
Text Symbol: 133 = Balance in database tables
Text Symbol: 132 = Balance from database tables
Text Symbol: 131 = New dataset:
Text Symbol: 130 = Old balance:
Text Symbol: 128 = Total of records replaced:
Text Symbol: 127 = Total of records archived:
Text Symbol: 126 = From balance audit trail dataset: customers
Text Symbol: 125 = GL accounts
Text Symbol: 124 = Vendors
Text Symbol: 123 = From Databases: Customers
Text Symbol: 122 = Total number of records issued:
Text Symbol: 121 = Total of records selected:
Text Symbol: 120 = Statistics for records issued:
Text Symbol: 100 = Check documents/items in database
Text Symbol: 091 = Upper limit not current date, reconciliation suppressed.
Text Symbol: 043 = Extract processed
Text Symbol: 042 = End sorting
Text Symbol: 041 = End selection
INCLUDES used within this REPORT RFKLET00
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:
UNICODE_REQUIRED CALL FUNCTION 'UNICODE_REQUIRED' IMPORTING unicode_required = l_unicode_required.
READ_SKC1C CALL FUNCTION 'READ_SKC1C' EXPORTING xbukrs = skc1a-bukrs xgjahr = skc1a-gjahr xgsber = skc1a-gsber xrtcur = skb1-waers xsaknr = skc1a-saknr IMPORTING xskc1c = skc1c EXCEPTIONS not_found = 4.
GET_GKONT_2 CALL FUNCTION 'GET_GKONT_2' EXPORTING gknkz = par_gkon TABLES xbseg = xbseg xbsegz = xbsegz EXCEPTIONS OTHERS = 0.
TABLE_COMPRESS CALL FUNCTION 'TABLE_COMPRESS' TABLES in = comp_in out = comp_out.
RKZ_TRANSFER_RECORD CALL FUNCTION 'RKZ_TRANSFER_RECORD' EXPORTING name = ds_out length = cwa-length wa =
EXCEPTIONS cb_not_open = 01 length_zero = 02.
RKZ_READ_RECORD CALL FUNCTION 'RKZ_READ_RECORD' EXPORTING name = ds_in IMPORTING wa = wa EXCEPTIONS eof = 01 ioerr = 02.
TABLE_DECOMPRESS CALL FUNCTION 'TABLE_DECOMPRESS' TABLES in = comp_out out = comp_in.
RKZ_TRANSFER_RECORD CALL FUNCTION 'RKZ_TRANSFER_RECORD' EXPORTING name = ds_out length = hd-length wa = hd EXCEPTIONS cb_not_open = 01 length_zero = 02.
RKZ_READ_RECORD CALL FUNCTION 'RKZ_READ_RECORD' EXPORTING name = ds_in IMPORTING wa = hd EXCEPTIONS eof = 01 ioerr = 02.
RKZ_OPEN_SEQ_FILE CALL FUNCTION 'RKZ_OPEN_SEQ_FILE' EXPORTING name = dsn maxlen = max_10 option = option.
RKZ_CLOSE_SEQ_FILE CALL FUNCTION 'RKZ_CLOSE_SEQ_FILE'.
FILE_GET_NAME CALL FUNCTION 'FILE_GET_NAME' EXPORTING logical_filename = workfiles-workfile IMPORTING file_name = workfiles-output EXCEPTIONS OTHERS = 0.
DB_COMMIT CALL FUNCTION 'DB_COMMIT'.
DD_DROP_TABLE CALL FUNCTION 'DD_DROP_TABLE' EXPORTING tabname = itab EXCEPTIONS OTHERS = 0.
DDIF_TABL_ACTIVATE CALL FUNCTION 'DDIF_TABL_ACTIVATE' EXPORTING name = itab auth_chk = ' ' * PRID = -1 * IMPORTING * RC = EXCEPTIONS not_found = 1 put_failure = 2 OTHERS = 3 .
DB_COMMIT CALL FUNCTION 'DB_COMMIT'.
FILE_GET_NAME CALL FUNCTION 'FILE_GET_NAME' EXPORTING logical_filename = logname IMPORTING file_name = pname EXCEPTIONS OTHERS = 4.
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 RFKLET00 or its description.
RFKLET00 - Extract for the Accumulated Historical Balance Audit Trail RFKLET00 - Extract for the Accumulated Historical Balance Audit Trail RFKLBU10_NACC - Account Details from Historical Accumulated Balance Audit Trail RFKLBU10_NACC - Account Details from Historical Accumulated Balance Audit Trail RFKLBU10 - Account Details from Historical Accumulated Balance Audit Trail RFKLBU10 - Account Details from Historical Accumulated Balance Audit Trail