Show TOC

Background documentationDocument Concept and Audit Trail Locate this document in the navigation structure

 

For the purposes of auditing and error identification/correction, the system must support a comprehensive document concept and audit trail. This means that the system captures all inventory transactions in the form of a system document. You can then retrieve these documents for review.

Currently, many inventory transactions create system documents – article documents, accounting documents, and revaluation documents – to capture all of the details of the event. These documents can be used as an audit trail. However, some inventory transactions such as transfers, markup cancellations, markdown cancellations, promotional markdowns, local markdowns, and employee discounts, are either only partially captured in a system document, or not at all. Furthermore, these system documents reside outside of the RMA stock ledger, and each one is available in different places. For inventory transactions that are partially captured, the system creates new documents and displays them when requested in a single document. The values captured by the existing documents in SAP ERP are all based on the Cost Method of Accounting. Therefore, some of these documents (for example, article documents for transfers, retail revaluation documents) are not appropriate for the RMA, although they exist and can be displayed in SAP ERP.

The list shown below contains all inventory transactions, and descriptions of the document concept supported for each transaction. In some cases, existing documents are presented; in other cases, the system creates and displays a new document. For the new documents that need to be created when an audit trail document list is displayed, the system displays a list of single line items. The list includes an identifier for each line item. The identifiers create a single document from multiple items within the same document.

The following table displays the Audit Trail document displayed when you choose the particular bucket:

Bucket

Audit Trail Document

Beginning Inventory

No Audit trail document

Available for Sales

No Audit trail document

Ending Inventory

No Audit trail document

Gross Good Receipts

ERP Article document (transaction MIGO in ERP)

Return to Vendor

Custom built new document for Audit Trail

Transfers In

Custom built new document for Audit Trail

Transfers Out

Custom built new document for Audit Trail

Markups

Custom built new document for Audit Trail

Markup Cancellation

Custom built new document for Audit Trail

Permanent Markdowns

Custom built new document for Audit Trail

Promotional Markdowns

POS Monitor

POS Markdowns

Custom built new document for Audit Trail

Employee Discounts

Custom built new document for Audit Trail

Pre-Sale

Custom built new document for Audit Trail

Markdown Cancellations

Custom built new document for Audit Trail

Gross Sales

You can navigate to either POS Monitor or ERP Billing document (transaction VF03)

Customer Returns

You navigate to either POS Monitor or ERP Billing document (transaction VF03)

VAT Difference

POS Monitor

Physical Inventory

Physical Inventory document in ERP (transaction MB03)

Planned Rebate Variances

Planned Rebate Variances document in ERP (transaction WZR3)

Unplanned Rebates

Unplanned Rebate Variances document in ERP (transaction WZR3)

Price Differences

Logistic Invoice document in ERP (transaction MIR4)

Actual Shrinkage

ERP Article document (transaction MIGO in ERP)

Planned Shrinkage

No Audit trail document

Manual Adjustments

ERP Article document (transaction MIGO in ERP)

Reclassifications In

Custom built new document for Audit Trail

Reclassifications Out

Custom built new document for Audit Trail

The Audit Trail documents can either be accessed by drilling into the stock ledger reports 0RMA_MP01_Q0001; 0RMA_MP01_Q0002, 0RMA_MP01_Q0003, 0RMA_MP01_Q0004, or by transaction WRMA_AUDITTRAIL

Transaction WRMA_AUDITTRAIL

Use this for executing an Audit Trail document as a stand-alone application. The following input parameters are mandatory to view Audit Trail documents for a particular bucket:

Field (Parameter)

Description

Plant

Plant or Retail Location (must not be filled if Company Code is provided)

Company Code

Company Code (must not be filled if Plant is provided)

Condition Type

RMA bucket for which you want to view the Audit Trail document. To find the appropriate Condition type (in BI) check the RMA Customizing (TX:RTRMACUS) in BI.

Posting Period

Posting Period for which you want to view the document(s)

Fiscal Year

Fiscal Year for which you want to view the document(s)

Fiscal Variant

Fiscal Variant for which you want to view the document(s)

Currency

Currency

If you want to view the documents for Company Code that has Merchandise Category as Object Model, then enter one of the following depending on the Object level:

Field (Parameter)

Description

Material Group

Material group

Hierarchy Level 1

Material Group Hierarchy Level 1

Hierarchy Level 2

Material Group Hierarchy Level 2

Hierarchy Level 3

Material Group Hierarchy Level 3

Hierarchy Level 4

Material Group Hierarchy Level 4

InfoProvider

Name of the InfoCube where the Merchandise Category data is stored, for example, 0RMA_C01

If you want to view the documents for Company Code that has Article hierarchy as Object Model, then enter one of the following depending on the Object level:

Field (Parameter)

Description

Hierarchy ID

Hierarchy ID

Segment

Segment

Category

Category

Subcategory

Subcategory

Industry

Industry

InfoProvider

Name of the InfoCube where the Article hierarchy data is stored, for example, 0RMA_C02