Programme SAP RFAUSZ00 - Statements for Customers / Vendors / G/L Accounts

Description
The program creates a list of items ordered by account for the accounttypes G/L account, customers, and vendors. The fixed asset accounts andmaterial accounts are printed for the G/L account statements; i.e. theG/L account statements include G/L accounts, deposit accounts, andmaterial accounts. Accounts that are just clearing accounts in the newgeneral ledger view cannot be displayed using this report because theentry view does not have any line items corresponding to the generalledger line items. The items are divided primarily into account types,that is, postings to reconciliation accounts are represented under theaccount type for the which the relevant reconciliation account isdefined.
The primary difference between this report and other item lists for theentry view (line item lists for customers, vendors, and G/L accounts) isthat it can be used to produce item lists for G/L accounts without lineitem display in the entry view.

Output
For every account with selected postings, all items of the selected typeand the distinguishable period are printed in addition to the accountdescription.
You choose the account types for which the account statement is createdby marking the desired ones: customer line item,vendor line item, G/L account line item
, material line item or assets line item.
In addition to the line item information, account-specific additionalaccount assignments are displayed if they are contained in the item.These are:

  • Document header text

  • Item text

  • If necessary, for G/L account statements, the following additionalinformation is displayed:
    • Main asset number, asset sub-number and asset transaction type

    • Material number, valuation area and valuation type

    • Cost center and plant

    • Quantity and unit of measure

    • Order number

    • Personnel number

    • Purchase order number
    • Sorting Method
      The data is sorted as follows:
      RESET N1

      • Account type

      • Company code

      • Reconciliation account (if required) or G/L account for G/L account
      • statements
        • Customer and vendor number or business area for G/L account statements

        • 1st sort indicator

        • 2nd sort indicator

        • Posting date

        • Document type

        • Document number

        • Fiscal year

        • Currency for G/L account statements

        • Line item for G/L account statements

        • Furthermore, the list can be sorted according to additional fields. Theuser determines which additional sort criteria he/she wants (up to two)via the following parameters:
          • "1st sort indicator"

          • "2nd sort indicator"

          • The field documentation informs you about the possible entries.

            Totals
            The totals set up in the list of debit and credit amounts as well asbalance amounts are indicated by a different number of asterisks (*):
            * = end of the 1st or 2nd sort criterion
            or marking of a document currency total
            ** = end of customer, vendor or business area
            *** = end of reconciliation account or G/L account
            **** = end of company code
            ***** = end of customer statement, vendor statement, or G/L accountstatements
            For **, ***,**** and *****, balances are written additionally fordocument currencies.

            Putting on Microfiche
            The variable part of the microfiche line has the following structure:

            • Account type (C/V/G) 1 character (G includes G,F,M)

            • Company code 4 characters

            • Reconciliation account or 10 characters

            • G/L account (that is, also fixed asset account and material account)
              • Open item account or 10 characters

              • Business area
                • 1st sort value 18 characters

                • 2nd sort value 18 characters

                • Posting date 8 characters
                • Examples of Item Selection
                  RESET N1
                  Posting date...... 0101191 123191 BT I
                  All items with posting date between 01/01/91 and 12/31/91 are printed.
                  Posting date........ 010191 013191 BT I
                  Open at key date... 013190
                  Item selection (1/2/3) 3
                  All open items with posting date between 01/01/92 and 01/31/92 areprinted, providing they were open to the key date 12/31/92.
                  Posting date........ 010190 123190 BT I
                  Item selection (1/2/3) 3
                  With this selection, all open items with posting date between 01/01/90and 12/31/90 are printed, which are open today.
                  Posting date........ 010191 123191 BT I
                  Open to key date... 053192
                  Item selection (1/2/3) 3
                  This selection works as in 3) except that all items with posting datebetween 01/01/91 and 12/31/91 are printed, which were still open on the05/31/92.
                  Posting date........ 010191 013191 BT I
                  Item selection (1/2/3) 2
                  All items with posting date between 01/01/91 and 01/31/91 are printed,which are (meanwhile) cleared.
                  Clearing date..... 010191 013191 BT I
                  Item selection (1/2/3) 2
                  With this selection, all items are printed, which were cleared between01/01/91 and 01/31/91.
                  Clearing date...... 010191 013191 BT I
                  Posting date........ 010190 123190 BT I
                  Item selection (1/2/3) 2
                  All items with posting date between 01/01/90 and 12/31/90 are printed,which were cleared in January 91.

                  Note
                  The selection via the clearing date only works together with itemselection 2, that is, only for cleared items. The key date selectiononly works together with item selection 3, that is, only for open items.

875571RFAUSZ00: Message if not selected and documentation
204707RFBELJ00: SPOOL_I/O_ERROR