C.03 - Billing Recorded to GL

This workflow identifies relevant Sales Revenue (credit) and A/R (debit) accounts on the specified SAP system.

Sales revenue account details are extracted from table C001 and stored in the Relevant Sales Revenue Accounts (credit) Table dataset. For Sales revenue (credit) accounts, field values from C001 match the following conditions:

  • The KAPPL (application) field has the value V (Sales/Distribution).

  • The KSCHL (condition type) field has the value KOFI (account determination).

  • The KTOPL (chart of accounts) field has the value CANA.

  • The VKORG (sales organization) field has a value greater than or equal to % (user defined).

  • The KTGRD (customer account assignment group) field has values 1, 2 or 3.

  • The KTGRM (material account assignment group) field has the value 1.

  • The KVSL1 (account key) has the value ERL (revenue).

The SKAT table is accessed to obtain account description details. The sales revenue account results are stored in the Results_C03a Table dataset, which has the following columns:

Column Description
MANDT Client.
KAPPL Application.
KSCHL Condition type for account determination.
KTOPL Chart of accounts.
VKORG Sales organization.
KTGRD Account assignment group for this customer.
KTGRM Account assignment group for this material.
KVSL1 G/L account number.
SAKN2 G/L account number.
TXT20 Account description.

A/R account details are extracted from table KNB1 and stored in the Relevant A/R Accounts (debit) table dataset. For credit accounts, field values from KNB1 match the following condition:

  • The BURKS (company code) field has the value 001 (user defined).

The SKAT table is accessed to obtain account description details. The A/R account results are stored in the Results_C03b Table dataset, which has the following columns:

Column Description
MANDT Client.
KUNNR Customer number.
BUKRS Company code.
AKONT Reconciliation account in general ledger.
TXT20 Account description.

Creating RFC Destinations

Before you begin, you will need to create an RFC Destination for the SAP system you wish to analyze.

Preparing the Workflow

To prepare the C.03 - Billing Recorded to GL workflow, drag its workflow template from the Templates folder into your own workspace, and modify the workflow as follows:

To specify the system to analyze:

  1. Select the System to Audit parameter and choose ‘Edit RFC Destination’ from its context menu to display the RFC Destination dialog.

  2. Select the RFC Destination for the system to analyze, then click ‘Save’.

To specify the language for which to retrieve account descriptions:

  1. Select the Define COA and SPRAS parameter and choose ‘Edit Select List’ from its context menu to display the Select List Editor dialog.

  2. Modify the selection criteria to create your own specifications for the SPRAS field. See the Select List Parameters help topic for details.

Save the workflow using the ‘Save’ toolbar button.

Running the Workflow

To run the C.03 - Billing Recorded to GL workflow, click the ‘Run’ toolbar button, choose ‘Run Now’ from the diagram’s context menu, or press F5. The currently running workflow action is marked with an animated display. When the workflow execution has completed, select each of the Results_C03a and Results_C03b datasets, and choose ‘View Details’ from the context menu to display the result tables.