Ansicht
Dokumentation

FML_CHECK_CONSISTENCY_ML_FI - Materials Inventory Value Consistency Check

Addresses (Business Address Services)   CPI1466 during Backup  
This documentation is copyright by SAP AG.

Purpose

This report compares inventory total values from Material Ledger (ML) with the balances of the assigned inventory accounts (FI) at end of selected Fiscal Year Period. Only inventory accounts ever posted with automatic account determination are shown in report results. No customizing check for current automatic inventory account determination configuration is performed.

In its static output(default), it shows ML-FI comparison of balances per Company Code, Ledger, checked period and either General Ledger(G/L) inventory account or G/L inventory account and Valuation Area or G/L inventory account, Transaction key and Valuation Area.

In its dynamic output(interactive), material inventory values from ML and FI are aggregated at level of material Cost Estimate number. Report layout can be defined and stored with aggregation level required for data selection. User can drill down through the aggregation layers in the report results interactively.

This report helps identifying manual postings to inventory accounts and postings to inventory accounts with other transaction keys, but those relevant for automatic inventory account postings (transaction key BSX).

Integration

No materials are blocked when you run the report. The system continues to update inventory values and quantities and the G/L accounts checked continue to be posted to. For periods to which posting is no longer allowed (past periods), report aggregates data posted in those periods and provides cumulated inventory results, as required.

Prerequisites

You need the following authorizations for display:

- Display of accounting documents

- Display accounting document: authorization for account types

- Display G/L account: authorization for company codes

Features

The function overview in detail:

Selection

Company code (mandatory)

Ledger in the Company Code

Period/Year representing Fiscal Year Period (mandatory)

G/L account

Layout to be used for results display - applicable to both static as well as dynamic output result

Standard Variants

Output

Perform comparison of inventory value balances for selection.

The report creates totals for the Material Ledger data belonging to the selected Company Code and compares these totals with the balances of the assigned inventory accounts. Totals for Material Ledger inventory value and G/L accounts inventory value are determined based on one database table - ACDOCA. Should these totals be zero in all Material Ledger relevant currency types, zero lines are not displayed in report results.

Inventory values consistency check is performed for Material Ledger relevant currency types in selected Material Ledger relevant ledgers.

We recommend running this report with static output results and only if differences are determined, use dynamic(interactive) output to get more details about the root cause.

Zero inventory account balances are not shown in the report results.

Dynamic output can't be used in background processing.

Activities

We recommend running this report at regular intervals (for example, monthly or at the end of the year). Static output requires less runtime than checking the results in dynamic(interactive) mode.

General Material Data   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by SAP AG.

Length: 3682 Date: 20240520 Time: 060510     sap01-206 ( 80 ms )