C.04 - Billing Auto Postings

This workflow identifies billing accounts that have been configured for automatic posting 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 SKB1 table is accessed to obtain the auto posting indicator setting for each account for accounts that have the specified company codes. The SKAT table is accessed to obtain account description details.

The sales revenue account results are stored in the Results_C04a 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	Account key.
SAKN1	G/L account number.
SAKN2	G/L account number.
BUKRS	Company code.
XINTB	Auto positing indicator.
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 A/R account results are stored in the Results_C04b table dataset, which has the following columns:

Column	Description
MANDT	Client.
KUNNR	Customer number.
BUKRS	Company code.
AKONT	Reconciliation account in general ledger.
XINTB	Auto posting indicator.
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.04 - Billing Auto Postings 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:

Select the System to Audit parameter and choose ‘Edit RFC Destination’ from its context menu to display the RFC Destination dialog.
Select the RFC Destination for the system to analyze, then click ‘Save’.

To specify a range of company codes:

Select the Define Company Code parameter and choose ‘Edit Select List’ from its context menu to display the Select List Editor dialog.
Modify the selection criteria to create your own specifications for the BUKRS field. See the Select List Parameters help topic for details.

To specify the language for which to retrieve account descriptions:

Select the Define COA and SPRAS parameter and choose ‘Edit Select List’ from its context menu to display the Select List Editor dialog.
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.04 - Billing Auto Postings 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_C04a and Results_C04b datasets, and choose ‘View Details’ from the context menu to display the result tables.