C.02 - Inventory Auto Posting

This workflow identifies credit and debit accounts that have been configured for automatic posting on the specified SAP system.

Credit account details are extracted from table T030, and stored in the Inventory account assignment (credit) table dataset. For credit accounts, column values from table T030 match the following conditions.

The KTOPL (chart of accounts) column has the value CANA.
The KTOSL (transaction key) column has the value BSX (inventory posting).
The BCLAS (valuation class) column has a value greater than or equal to % (used defined valuation classes).

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 credit account results are stored in the Results_C02a Table dataset, which has the following columns:

Column	Description
MANDT	Client.
KTOPL	KTOPL Chart of accounts.
KTOSL	Transaction key.
BWMOD	Valuation grouping code.
KOMOK	Account modification.
BKLAS	Valuation class.
KONTS	G/L account number.
KONTH	KONTH G/L account number.
XINTB	Auto posting indicator.
TXT20	Account description.

Debit account details are extracted from table T030, and stored in the Cost of goods sold account assignment (debit) table dataset. For debit accounts, column values from table T030 match the following conditions.

The KTOPL (chart of accounts) column has the value CANA.
The KTOSL (transaction key) column has the value GBB (offsetting entry for inventory posting).
The KOMOK (account modification) column has the value VAY (costs and revenues).
The BCLAS (valuation class) column has a value greater than or equal to % (user defined valuation classes).

The debit account results are stored in the Results_C02b table dataset, which has the following columns:

Column	Description
MANDT	Client.
KTOPL	KTOPL Chart of accounts.
KTOSL	Transaction key.
BWMOD	Valuation grouping code.
KOMOK	Account modification.
BKLAS	Valuation class.
KONTS	G/L account number.
KONTH	KONTH G/L account number.
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.02 - Inventory 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.02 - Inventory Auto Postings, 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_C02a and Results_C02b datasets, and choose ‘View Details’ from the context menu to display the result tables.