SAP ABAP Reports and Programs

Share |

RFCASH00 SAP Report - Cash Journal

RFCASH00 is a standard ABAP report available within your SAP system (depending on your version and release level). Below is the standard documentation available for this report and a few details of other objects it interacts with such as tables, function modules, includes etc. If you would like to see the full code listing simply enter RFCASH00 into the relevant SAP transaction such as SE38 or SE80

Although this basic information may have limited use other that for reference, within the comments section below there is also an opportunity for anyone to add useful hints, information and links to existing content specific to this abap report. This page will therfore over time start to contain a useful amount of information that can be found quickly, simply by searching on the object name, RFCASH00.


SAP Documentation for program RFCASH00

Transaction Code:

N/A

DESCRIPTION
The program lists all account transactions in the selected posting period. Additionally, it lists the opening balance, the closing balance, and the balance carried forward if the report contains more than one page. If more than one currency is being kept for an account, the list is done per account and currency.
The report can be set alone or in connection with the cash journal transaction. If it is used with the cash journal transaction, as well as the information from the G/L accounts and FI documents, data from the cash journal transaction tables is also made available.

PRECONDITION
The basis settings in Customizing must be set for the list (display variant and texts).

OUTPUT
You can easily adjust the ouput and sorting of the line items as well as the balance and the signature line texts. Here, you can adjust the output to meet the requirements of a specific country.

EXAMPLE
  • The standard texts for balances, balances carried forward, and the signature line have to be maintained in the country and language in which the cash journal is to be created.

  • Standard texts with text ID ST are included in the standard system for certain countries. The text names are created from the following characters and a country abbreviation, for example, DE:
    FI_CASH_BB_* Text for the opening balance
    FI_CASH_CF_* Text for the balance carried forward
    FI_CASH_EB_* Text for the closing balance
    FI_CASH_SI_* Text for the signature line
    You have to copy the standard texts from client 000 into your current client.
    If you want to adapt a text, you should copy the original text and then make changes to the copy. You can use the Standard text
    function to do this.
    You can use the variables of the RFCASH structure in the text modules. The number of debit postings is output in the SPELL structure and the credit postings in the *SPELL structure, both written in words.
  • Country-specific report variants are delivered.

  • The variant names consist of the indicator CASH and a country abbreviation, for example, DE.
  • You have to maintain the corresponding display variant for the output of the line items.

  • Variants with numbers, for example, 1 and 2 are delivered with the standard system. You can import these from client 000 into your current client if necessary.
    Documentation extract taken from SAP system, Copyright (c) SAP AG

    Includes used within report:

    No INCLUDES are used within this report code!


    Tables used within report and the associated select statement:

    TCJ_C_JOURNALS SELECT * FROM TCJ_C_JOURNALS WHERE COMP_CODE = BELEGE-BUKRS AND GL_ACCOUNT = BELEGE-HKONT AND CURRENCY = BELEGE-WAERS.

    TCJ_CJ_NAMES SELECT SINGLE * FROM TCJ_CJ_NAMES WHERE LANGU = SY-LANGU AND COMP_CODE = BELEGE-BUKRS AND CAJO_NUMBER = TCJ_C_JOURNALS-CAJO_NUMBER.

    T001 SELECT SINGLE * FROM T001 WHERE BUKRS = BELEGE-BUKRS.

    TCURT SELECT SINGLE * FROM TCURT WHERE SPRAS = SY-LANGU AND WAERS = BELEGE-WAERS .

    SKB1 SELECT SINGLE * FROM SKB1 WHERE BUKRS = BELEGE-BUKRS AND SAKNR = BELEGE-HKONT.

    BSIS SELECT * FROM BSis APPENDING TABLE XBSis WHERE BUKRS = SKB1-BUKRS AND HKONT = SKB1-SAKNR AND BUDAT GE BDATE.

    BSAS Select * from bsas appending corresponding fields of table xbsis WHERE BUKRS = SKB1-BUKRS AND HKONT = SKB1-SAKNR AND BUDAT GE BDATE.

    BKPF SELECT SINGLE * FROM BKPF WHERE BUKRS = BSIS-BUKRS AND BELNR = BSIS-BELNR AND GJAHR = BSIS-GJAHR.

    V_VBSEGS SELECT * FROM v_Vbsegs WHERE ausbk = SKB1-BUKRS AND saknr = SKB1-SAKNR AND BUDAT GE BDATE.

    BKPF SELECT SINGLE * FROM BKPF WHERE BUKRS = v_vbsegs-BUKRS AND BELNR = v_Vbsegs-BELNR AND GJAHR = v_Vbsegs-GJAHR.

    TCJ_DOCUMENTS SELECT SINGLE * FROM TCJ_DOCUMENTS WHERE COMP_CODE = BELEGE-BUKRS AND CAJO_NUMBER = BELEGE-CAJON AND POSTING_NUMBER = BELEGE-DOCNR.

    KNA1 SELECT SINGLE * FROM KNA1 WHERE KUNNR = GKONT.

    LFA1 SELECT SINGLE * FROM LFA1 WHERE LIFNR = GKONT.

    BSEG SELECT * FROM BSEG WHERE BUKRS = YBSEG-BUKRS AND BELNR = YBSEG-BELNR AND GJAHR = YBSEG-GJAHR AND BUZEI NE YBSEG-BUZEI.

    BSIS SELECT * FROM BSis APPENDING TABLE XBSis WHERE BUKRS = SKB1-BUKRS AND HKONT = SKB1-SAKNR AND BUDAT GE BDATE.

    BSAS Select * from bsas appending corresponding fields of table xbsis WHERE BUKRS = SKB1-BUKRS AND HKONT = SKB1-SAKNR AND BUDAT GE BDATE.

    BKPF SELECT SINGLE * FROM BKPF WHERE BUKRS = BSIS-BUKRS AND BELNR = BSIS-BELNR AND GJAHR = BSIS-GJAHR.

    V_VBSEGS SELECT * FROM v_Vbsegs WHERE ausbk = SKB1-BUKRS AND saknr = SKB1-SAKNR AND BUDAT GE BDATE.

    BKPF SELECT SINGLE * FROM BKPF WHERE BUKRS = v_vbsegs-BUKRS AND BELNR = v_Vbsegs-BELNR AND GJAHR = v_Vbsegs-GJAHR.


    Function Modules used within report and the associated call statement:

    FI_CURRENCY_INFORMATION CALL FUNCTION 'FI_CURRENCY_INFORMATION' EXPORTING I_BUKRS = SKB1-BUKRS IMPORTING E_X001 = X001.

    FI_PERIOD_DETERMINE CALL FUNCTION 'FI_PERIOD_DETERMINE' EXPORTING I_BUDAT = DATE-LOW I_BUKRS = SKB1-BUKRS I_PERIV = T001-PERIV IMPORTING E_GJAHR = GJAHR E_MONAT = MONAT E_POPER = PERIOD EXCEPTIONS FISCAL_YEAR = 1 PERIOD = 2 PERIOD_VERSION = 3 POSTING_PERIOD = 4 SPECIAL_PERIOD = 5 VERSION = 6 POSTING_DATE = 7 OTHERS = 8.

    PERIODENANFANG_ERMITTELN CALL FUNCTION 'PERIODENANFANG_ERMITTELN' EXPORTING EPERIV = T001-PERIV EPERJJ = GJAHR EPOPER = PERIOD IMPORTING IVONTG = BDATE EXCEPTIONS PERIODE_NICHT_VORHANDEN = 1 T009_NICHT_GEFUNDEN = 2 OTHERS = 3.

    REUSE_ALV_LIST_DISPLAY CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY' EXPORTING I_CALLBACK_PROGRAM = G_REPID I_CALLBACK_PF_STATUS_SET = G_STATUS I_CALLBACK_USER_COMMAND = G_USER_COMMAND IT_SORT = GT_SORT[] I_SAVE = G_SAVE IS_VARIANT = G_VARIANT IS_LAYOUT = GS_LAYOUT IS_PRINT = GS_PRINT IT_FIELDCAT = GT_FIELDCAT[] IT_EVENTS = GT_EVENTS[] TABLES T_OUTTAB = BELEGE.

    READ_HAUPTBUCH_TEXT CALL FUNCTION 'READ_HAUPTBUCH_TEXT' EXPORTING KONTENPLAN = T001-Ktopl SACHKONTO = Belege-hkont SPRACHE = SY-Langu IMPORTING TEXT_WA = skat EXCEPTIONS TEXT_NOT_FOUND = 1 OTHERS = 2.

    SPELL_AMOUNT CALL FUNCTION 'SPELL_AMOUNT' EXPORTING AMOUNT = RFCASH-ANZSB * CURRENCY = ' ' * FILLER = ' ' * LANGUAGE = SY-LANGU IMPORTING IN_WORDS = SPELL EXCEPTIONS * NOT_FOUND = 1 * TOO_LARGE = 2 OTHERS = 3.

    SPELL_AMOUNT CALL FUNCTION 'SPELL_AMOUNT' EXPORTING AMOUNT = RFCASH-ANZHB * CURRENCY = ' ' * FILLER = ' ' * LANGUAGE = SY-LANGU IMPORTING IN_WORDS = *SPELL EXCEPTIONS * NOT_FOUND = 1 * TOO_LARGE = 2 OTHERS = 3.

    CORRESPONDENCE_REQUEST CALL FUNCTION 'CORRESPONDENCE_REQUEST' EXPORTING * I_ACCOUNT = ' ' * I_ACCOUNT_TYPE = ' ' I_COMPANY_CODE = BELEGE-BUKRS I_DBUPDATE = 'X' I_DOCUMENT = BELEGE-BELNR I_MESSAGE = 'X' * I_OVERWRITE_ACC = ' ' * I_OVERWRITE_DOC = ' ' I_PROCESS = '* ' I_YEAR = BELEGE-GJAHR I_EVENT = EVENT IMPORTING E_BKORM = BKORM * E_TEXT = EXCEPTIONS * NO_EVENT_FOUND = 1 * NO_EVENT_SELECTED = 2 OTHERS = 3 .

    CORRESPONDENCE_SHOW_REQUEST CALL FUNCTION 'CORRESPONDENCE_SHOW_REQUEST' EXPORTING I_BKORM = XBKORM EXCEPTIONS * INVALID_ALLOCATION = 1 * INVALID_EVENT = 2 * NO_ALLOCATION = 3 * NO_EVENT = 4 OTHERS = 5 .

    READ_STDTEXT CALL FUNCTION 'READ_STDTEXT' EXPORTING ID = 'ST' LANGUAGE = SY-LANGU NAME = NAME * USE_AUX_LANGUAGE = ' ' * USE_THRUCLIENT = ' ' IMPORTING HEADER = HTHEAD TABLES LINES = EDTEXT.

    READ_TEXT * CALL FUNCTION 'READ_TEXT' * EXPORTING * id = 'ST' * language = sy-langu * name = name * object = 'TEXT' * IMPORTING * header = hthead * TABLES * lines = edtext * EXCEPTIONS * not_found = 4 * OTHERS = 8.

    PRINT_TEXT * CALL FUNCTION 'PRINT_TEXT' * EXPORTING ** APPLICATION = 'TX' ** ARCHIVE_INDEX = ' ' ** ARCHIVE_PARAMS = ' ' ** DEVICE = 'PRINTER' * dialog = ' ' * header = hthead * options = itcpo ** IMPORTING ** NEW_ARCHIVE_PARAMS = ** RESULT = * TABLES * lines = edtext * otfdata = edtotf.

    CONVERT_OTF * CALL FUNCTION 'CONVERT_OTF' ** EXPORTING ** FORMAT = 'ASCII' ** MAX_LINEWIDTH = 132 ** IMPORTING ** BIN_FILESIZE = * TABLES * otf = edtotf * lines = edtext.

    CONVERT_TEXT CALL FUNCTION 'CONVERT_TEXT' EXPORTING * CODEPAGE = '0000' * DIRECTION = 'EXPORT' FORMAT_TYPE = 'ASCII' FORMATWIDTH = '132' HEADER = HTHEAD * SSHEET = ' ' * WITH_TAB = ' ' * WORD_LANGU = SY-LANGU * TABLETYPE = 'ASC' * TAB_SUBSTITUTE = 'X09 ' * LF_SUBSTITUTE = ' ' * IMPORTING * NEWHEADER = * WITH_TAB_E = * FORMATWIDTH_E = TABLES FOREIGN = EDTEXT ITF_LINES = EDTEXT * LINKS_TO_CONVERT = .

    READ_STDTEXT CALL FUNCTION 'READ_STDTEXT' EXPORTING ID = 'ST' LANGUAGE = SY-LANGU NAME = TEXT * USE_AUX_LANGUAGE = ' ' * USE_THRUCLIENT = ' ' * IMPORTING * header = hthead TABLES LINES = EDTEXT EXCEPTIONS * ID = 1 * LANGUAGE = 2 * NAME = 3 * NOT_FOUND = 4 * REFERENCE_CHECK = 5 OTHERS = 1.

    REUSE_ALV_VARIANT_F4 CALL FUNCTION 'REUSE_ALV_VARIANT_F4' EXPORTING IS_VARIANT = I_VARIANT I_SAVE = 'A' IMPORTING E_EXIT = EXIT ES_VARIANT = E_VARIANT EXCEPTIONS PROGRAM_ERROR = 3 OTHERS = 3.

    GET_GKONT CALL FUNCTION 'GET_GKONT' EXPORTING BELNR = YBSEG-BELNR BUKRS = YBSEG-BUKRS BUZEI = YBSEG-BUZEI GJAHR = YBSEG-GJAHR GKNKZ = GKONTO IMPORTING GKONT = GKONT KOART = GKART ghkon = ghkon EXCEPTIONS BELNR_NOT_FOUND = 1 BUZEI_NOT_FOUND = 2 GKNKZ_NOT_FOUND = 3 OTHERS = 4.

    READ_HAUPTBUCH_TEXT CALL FUNCTION 'READ_HAUPTBUCH_TEXT' EXPORTING KONTENPLAN = T001-Ktopl SACHKONTO = GKONT SPRACHE = SY-Langu IMPORTING TEXT_WA = skat EXCEPTIONS TEXT_NOT_FOUND = 1 OTHERS = 2.


    Text pool values


    Selection Text: ASALDO = Opening balance text
    Selection Text: DATE = Key dates
    Selection Text: ESALDO = Closing balance text
    Selection Text: EVENT = Correspondence type
    Selection Text: GKONTO = Offsetting acct determination
    Selection Text: LASTM = Last day of month
    Selection Text: LASTY = Last day of year
    Selection Text: NUMBER = Last sequential number: Docs
    Selection Text: N_BELEGE = Standard documents
    Selection Text: PAGEM = Last page of month
    Selection Text: PAGEY = Last Page of Year
    Selection Text: P_LVAR = List variant
    Selection Text: SIGNAT = Title text
    Selection Text: TITLE = Additional heading
    Selection Text: USALDO = Transfer text
    Selection Text: VBEL = Parked documents
    Selection Text: WAERS = Currency
    Selection Text: XKBEL = Cash documents
    Selection Text: XMWST = Taxes on sales/purchases
    Selection Text: XOBEL = Output also Without Items
    Title: Cash Journal
    Text Symbol: 137 = Amount
    Text Symbol: 138 = Amount
    Text Symbol: 139 = Amount
    Text Symbol: 140 = LC tax
    Text Symbol: 141 = LC tax
    Text Symbol: 142 = LC tax amount
    Text Symbol: 143 = LC tax amount
    Text Symbol: 144 = Tax
    Text Symbol: 145 = Tax amount
    Text Symbol: 146 = Tax amount
    Text Symbol: 147 = Tax amount
    Text Symbol: 148 = OffsetAcct
    Text Symbol: 149 = G/L offsetting acct
    Text Symbol: 150 = No Pstings in Display Period
    Text Symbol: 151 = Currency
    Text Symbol: 136 = Amount
    Text Symbol: 100 = No
    Text Symbol: 101 = Text
    Text Symbol: 102 = O/acct text
    Text Symbol: 103 = Total
    Text Symbol: 104 = Total LC
    Text Symbol: 105 = Carryfwd
    Text Symbol: 106 = Carryfds LC
    Text Symbol: 107 = Amount
    Text Symbol: 108 = Amount +/-
    Text Symbol: 109 = FC amount
    Text Symbol: 110 = LC amount
    Text Symbol: 111 = Incom.pmnt
    Text Symbol: 112 = Incom.pmnt FC
    Text Symbol: 113 = Incom.pmnt LC
    Text Symbol: 114 = Payment
    Text Symbol: 115 = Out.pmnt FC
    Text Symbol: 116 = Out.pmnt LC
    Text Symbol: 117 = DT
    Text Symbol: 118 = Beg.balance
    Text Symbol: 119 = ClsgBal.
    Text Symbol: 120 = Carryfwd
    Text Symbol: 121 = Wage pmnt
    Text Symbol: 122 = Tax
    Text Symbol: 123 = Tax +/-
    Text Symbol: 124 = Tax inc.pyt
    Text Symbol: 125 = Tax inc.pyt FC
    Text Symbol: 126 = Tax inc.pyt LC
    Text Symbol: 127 = Tax outg.pyt
    Text Symbol: 128 = Tax outg.pyt FC
    Text Symbol: 129 = Tax outg.pyt LC
    Text Symbol: 130 = Tax FC +/-
    Text Symbol: 131 = Tax LC +/-
    Text Symbol: 132 = LC amount
    Text Symbol: 133 = LC amount
    Text Symbol: 134 = Amt (loc. crcy)
    Text Symbol: 135 = Amt (loc. crcy)






    Terms of Service     Contact Us     Privacy Policy     Useful SAP related sites