SAP Reports / Programs
RFKKET00 SAP ABAP Report - Extract for Accumulated Open Item Balance Audit Trail
RFKKET00 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Program RFKKET00 creates the extract (balance audit trail dataset) for the balance audit trail of customers, vendors and G/L accounts managed on an open item basis...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 RFKKET00 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 RFKKET00. "Basic submit
SUBMIT RFKKET00 AND RETURN. "Return to original report after report execution complete
SUBMIT RFKKET00 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: AKONTO = Reconciliation account
Selection Text: AUTOSEL = Automatic selection
Selection Text: BELMAX = Maximum number of documents
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: IBUKRS = Archive company code
Selection Text: ICLEARY = Archive up to and incl.fisc.yr
Selection Text: IKOART = Archive account type
Selection Text: IRESET = Reset database tables
Selection Text: I_ONLY = Only archive dataset tape
Selection Text: KKONTO = Vendor account
Selection Text: KONTOART = Account type
Selection Text: LOWDATE = Lower limit (CPU date)
Selection Text: MAX_10 = D File Size in MB
Selection Text: MERGE_F = Create first tape
Selection Text: MERGE_N = Create new tape
Selection Text: PAR_GKON = Offsetting acct determination
Selection Text: PA_WORK = Work file name
Selection Text: P_DS_IN = Phys. file of old dataset
Selection Text: P_DS_OUT = Phys. file of new dataset
Selection Text: P_TABIN = D From database table
Selection Text: P_TABOUT = D In database table
Selection Text: SKONTO = G/L account
Selection Text: XWORK = Extract in work file
Selection Text: XWORKR = Read extract from work file
Title: Extract for Accumulated Open Item Balance Audit Trail
Text Symbol: 463 = Work file does not exist
Text Symbol: 462 = Name of Work Files Recds
Text Symbol: 461 = No work file was opened. Termination!
Text Symbol: 460 = Error opening work file
Text Symbol: 452 = Error: old and new datasets are identical!
Text Symbol: 451 = Specify new dataset
Text Symbol: 450 = Specify old dataset
Text Symbol: 416 = Error during transf.
Text Symbol: 415 = Error during first reading: EOF found
Text Symbol: 414 = Sort field:
Text Symbol: 413 = Ignore indicator:
Text Symbol: 412 = Report to be generated:
Text Symbol: 411 = Client:
Text Symbol: 410 = Dataset parameters:
Text Symbol: 140 = Number of records in work file
Text Symbol: 001 = Selection by
Text Symbol: 003 = Documents cancelled
Text Symbol: 004 = Last document
Text Symbol: 005 = Start next run with this document number
Text Symbol: 010 = Incorrect period selection
Text Symbol: 012 = Only one evaluation is allowed.
Text Symbol: 013 = Incorrect entry of fiscal years to be archived (default = 1900)
Text Symbol: 014 = Either read or write to work file
Text Symbol: 015 = Work file name must be specified
Text Symbol: 017 = Current selection period:
Text Symbol: 018 = Period lower limit:
Text Symbol: 019 = Period upper limit:
Text Symbol: 020 = Selection statistics Master records Items
Text Symbol: 021 = Total number of extracted records:
Text Symbol: 022 = of which
Text Symbol: 023 = replaced master tape records with additional records
Text Symbol: 024 = from balance audit trail dataset:
Text Symbol: 025 = from the document/master record data base:
Text Symbol: 026 = Total number of archived items:
Text Symbol: 027 = Forgotten records from the master tape (open items):
Text Symbol: 028 = Selected records from document/master record data base:
Text Symbol: 029 = Selected records from the balance audit trail dataset:
Text Symbol: 030 = Abnormal termination: Incorrect master tape indicator
Text Symbol: 032 = Abnormal termination: First record of the dataset is not a master record
Text Symbol: 035 = last record
Text Symbol: 036 = curr. record
Text Symbol: 058 = PARAM1
Text Symbol: 059 = Logical name of old dataset
Text Symbol: 060 = Cust.: General Part
Text Symbol: 061 = Cust.: CoCode Part
Text Symbol: 065 = Vendor: General Part
Text Symbol: 066 = Vendor: CoCode Part
Text Symbol: 068 = Company code
Text Symbol: 069 = not found
Text Symbol: 070 = Total number of deleted cleared items:
Text Symbol: 125 = Specify old dataset
Text Symbol: 126 = New dataset may not be called the same as the old dataset
Text Symbol: 130 = Old balance:
Text Symbol: 131 = New balance:
Text Symbol: 132 = Balance from database tables
Text Symbol: 133 = Balance in database tables
Text Symbol: 134 = Number of master records/items:
Text Symbol: 135 = Reset DB table
INCLUDES used within this REPORT RFKKET00
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:
GET_GKONT_2 CALL FUNCTION 'GET_GKONT_2' EXPORTING gknkz = par_gkon TABLES xbseg = xbseg xbsegz = xbsegz EXCEPTIONS OTHERS = 0.
READ_KNA1 CALL FUNCTION 'READ_KNA1' EXPORTING xkunnr = xx-konto IMPORTING xkna1 = kna1 EXCEPTIONS key_incomplete = 04 not_authorized = 04 not_found = 04.
READ_KNB1 CALL FUNCTION 'READ_KNB1' EXPORTING xkunnr = xx-konto xbukrs = xx-bukrs IMPORTING xknb1 = knb1 EXCEPTIONS key_incomplete = 04 not_authorized = 04 not_found = 04.
READ_LFA1 CALL FUNCTION 'READ_LFA1' EXPORTING xlifnr = xx-konto IMPORTING xlfa1 = lfa1 EXCEPTIONS key_incomplete = 04 not_authorized = 04 not_found = 04.
READ_LFB1 CALL FUNCTION 'READ_LFB1' EXPORTING xlifnr = xx-konto xbukrs = xx-bukrs IMPORTING xlfb1 = lfb1 EXCEPTIONS key_incomplete = 04 not_authorized = 04 not_found = 04.
READ_SKA1 CALL FUNCTION 'READ_SKA1' EXPORTING xktopl = t001-ktopl xsaknr = xx-konto IMPORTING xska1 = ska1 xskat = skat EXCEPTIONS key_incomplete = 04 not_authorized = 04 not_found = 04.
READ_SKB1 CALL FUNCTION 'READ_SKB1' EXPORTING xsaknr = xx-konto xbukrs = xx-bukrs IMPORTING xskb1 = skb1 EXCEPTIONS key_incomplete = 04 not_authorized = 04 not_found = 04.
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.
GET_CURRENT_YEAR CALL FUNCTION 'GET_CURRENT_YEAR' EXPORTING bukrs = x-bukrs date = x-augdt IMPORTING curry = wf_cleary.
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'.
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.
FILE_GET_NAME CALL FUNCTION 'FILE_GET_NAME' EXPORTING logical_filename = workfiles-workfile IMPORTING file_name = workfiles-output EXCEPTIONS OTHERS = 4.
FILE_GET_NAME CALL FUNCTION 'FILE_GET_NAME' EXPORTING logical_filename = pa_work IMPORTING file_name = workfiles-output EXCEPTIONS OTHERS = 4.
DB_COMMIT CALL FUNCTION 'DB_COMMIT'.
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 EXCEPTIONS not_found = 1 put_failure = 2 OTHERS = 3.
DB_COMMIT CALL FUNCTION 'DB_COMMIT'.
DB_COMMIT CALL FUNCTION 'DB_COMMIT'.
DB_COMMIT CALL FUNCTION 'DB_COMMIT'.
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 RFKKET00 or its description.
RFKKET00 - Extract for Accumulated Open Item Balance Audit Trail RFKKET00 - Extract for Accumulated Open Item Balance Audit Trail RFKKES_SAL2 - Annual Sales Report (Spain), According to Legal Change 2008 RFKKES_SAL2 - Annual Sales Report (Spain), According to Legal Change 2008 RFKKES_SAL1 - Annual Tax Return (Spain) RFKKES_SAL1 - Annual Tax Return (Spain)