SAP Program RFBELJ00 - Compact Document Journal


IF &[SWITCH]FAGL_FIN_GL_2_RS& = 'X'.

Purpose
The Compact Document Journal shows for the selected documents themost important data from document headers and line items in table form.The list can be used for a compact journal and for reconciliation withbalance lists (accounting reconciliation). If the accounting principlesapplied require that the compact journal sorts the data by entry date,you need to use either the Document Journal (accessible)(RFBELJ10) program or the Document Journal(RFBELJ10_NACC) program instead of this program.

Selection
INCLUDE FAGL_LDGRP_BRF_REPORTS OBJECT DOKU ID TX

Output

Areas in the Document Display
The information in the document display is grouped into the followingareas:

  • Document header

  • Company code
    Ledger group (if applicable)
    Document number
    Document type
    Posting date
    Reference document number (if applicable)
    Reversal document number (if applicable)
    • Postings to subledger accounts

    • Account type
      Account number
      Posting key
      Special G/L indicator
      Indicator: Negative posting
      Amount in local currency
      Local currency key
      Amount in foreign currency (if applicable)
      Foreign currency key (if applicable)
      • Tax postings

      • Tax on sales/purchases code
        Tax on sales/purchases amount
        • G/L account postings

        • Tax on sales/purchases code
          Posting key
          Indicator: Negative posting
          G/L account
          Amount in local currency

          "Ledger" and "Ledger Group" in the List Output

          • If you enter a ledger, you can show the Ledger Group
          • column in the ALV document list to see the ledger group to which thedocuments are posted. For this, choose Settings -> Layout -> Change
            in the document list and add the Ledger Group column from thecolumn set for the displayed columns.
            • If you enter a ledger group, the system automatically shoes the
            • Ledger Group column in the document list. If you have restrictedthe selection to a ledger and not to a ledger group, the system sortsthe documents in the ALV document list by ledger group.
              • If you enter neither a ledger nor a ledger group, the system displays
              • all documents without any restriction to a ledger or ledger group (seeabove). In the document list, the Ledger Group column is shownautomatically.

                Document status
                A separate list is created in accordance with the document status(normal documents, recurring entry original documents, sample documents,statistical documents). The document status can be derived from the listtitle.

                Totals sheets by company code
                For each company codes, totals sheets are appended to the compactdocument journal, showing the debit/credit totals by account type (G/Laccounts, customers, vendors) and separated by posting periods.
                If more than one company code is used, the totals sheets for the groupare output at the end of the above lists: The individual company codetotals sheets are repeated, followed by a summary of the company codeswith the same local currency (again, for each document status).
                If the totals sheets are used for the normal documents to reconcilebalance lists (accounting reconciliation), output can be restricted tothe totals report so that only the totals sheets of the group areoutput.
                Sorting in the compact document journal

                • Company code

                • Document status

                • Fiscal year

                • Document number

                • Sorting of the totals sheets

                • Document status

                • Company code or local currency

                • Posting period

                • For large data volumes, we recommend that you always use the classic
                • list for performance reasons (see the relevant indicator).

                  "Output General Ledger View Information" indicator
                  Provided that new General Ledger Accounting has been activated, you canuse the Output General Ledger View Information indicator tosummarize document information:

                  • If you do not set this indicator, the data from the line items of the
                  • entry view (table BSEG) is output.
                    • If you set this indicator, the line data of the entry view is combined
                    • with the data from the general ledger line items. This could mean thatline items from the entry view are each split into multiple lines due todocument splitting. Furthermore, this indicator influences the (default)sorting method: If the indicator is set, the general ledger documentnumber (DOCNR) is applied for sorting instead of the entry documentnumber (BELNR). In accordance with the sort setting, the general ledgerdocument number is output in the classic list instead of the entrydocument number.

                      Microfiche line
                      For the fixed part of the microfiche line, see the field help onPrint Microfiche Line.
                      The variable part of the microfiche line is structured as follows:

                      • Document status ,, 1 character

                      • Company code,, 4 characters

                      • Fiscal year,, 4 characters

                      • Document number ,,10 characters

                      • ELSE.

                        Description
                        The compact document journal displays the most important datafrom document headers and items in table form for the selecteddocuments. The list can be used as a journal and for reconciliation withthe lists of account balances (accounting reconciliation). If theaccounting principles valid in the respective country require that theland register be sorted by entry date, report RFBELJ10 needs to be usedin place of this program.

                        Output
                        The information in the document display is divided into four groups(classic list):
                        Document header
                        Company code
                        Document number
                        Document type
                        Posting date
                        Reference document number, if relevant
                        Reverse document number, if relevant
                        Customer account/vendor account postings
                        Account type
                        Account number
                        Posting key
                        Special G/L indicator
                        Indicator: negative posting
                        Amount in local currency
                        Local currency key
                        Amount in foreign currency, if relevant
                        Foreign currency key, if relevant
                        Tax postings
                        Taxes on sales/purchases code
                        Taxes on sales/purchases amount
                        G/L account postings
                        Taxes on sales/purchases code
                        Posting key
                        Indicator: negative posting
                        G/L account
                        Amount in local currency
                        The system creates an individual list for each document status (normaldocuments, recurring entry documents, sample documents, statisticaldocuments). The document status can be seen from the list heading.
                        For each company code, the system outputs totals sheets following thecompact document journal, which list the debit and credit totals peraccount type (G/L, customer, vendor accounts) separated by postingperiods.
                        The totals sheets for the corporate group are displayed after theabove-mentioned lists when there is more than one company code: firstthe individual company code totals sheets are displayed, then thecompany codes are combined with the same local currency (again perdocument status).
                        If the totals sheets for the normal documents are used forreconciliation with the account balances (accounting reconciliation),then you can limit the output to the summary report for which only thetotals sheets of the corporate group are issued.
                        For performance reasons, the classic list (selection parameters) shouldalways be used for large volumes of data.
                        When new General Ledger Accounting is active, it is possible tosummarize document information using the instruction General LedgerView. If this parameter is selected, the data from the line items ofthe entry view (table BSEG) are output, otherwise the line item datafrom the entry view is merged with the data from the general ledger lineitems. This could mean that line items from the entry view are eachsplit into multiple lines due to document splitting. Furthermore,applying the General Ledger View parameter also changed the(default) sort setting. If the parameter is not selected, the sort usesthe general ledger document number (DOCNR) instead of the entry documentnumber (BELNR). In accordance with the sort setting, the general ledgerdocument number is output in the classic list instead of the entrydocument number.

                        Sorting
                        Compact document journal

                        • Company code

                        • Document status

                        • Fiscal year

                        • Document number

                        • Totals sheets
                          • Document status

                          • Company code or local currency

                          • Posting period
                          • Microfiche line
                            The variable part of the microfiche line has the following structure:

                            • Document status,, 1 character

                            • Company code ,, 4 characters

                            • Fiscal year ,, 4 characters

                            • Document number,,10 characters

                            • ENDIF.

1418544Plus/minus sign zero balance clearing items in doc journal
1362621SAPDBBRF: Period end accrual/deferral in non-leading ledger
872302Adjusting RFBELJ00 + RFBELJ10 because of new general ledger
871770SAPDBBRF: Evaluations for ledger with alternative FY
612277RFBELJ00: IMPORT_ALIGNMENT_MISMATCH
359028Line items: Expiring currencies
204707RFBELJ00: SPOOL_I/O_ERROR