Data not updated in table MARDH

[former_member1174881]

Hi , All In December, We did some update for meterial 179258665, like movement type: 101/102/311/321, it was supposed to generate historical data in table MARDH for period November, but actually, no data find in table MARDH for meterial 179258665.

Any reply is appreciated. thanks in advance.

Best regards,

Evan

[former_member1174881]

Hi, 3a9e4ce873a94034b33dc62b0ce600ee

Thanks for you quickly reply, I will check the notes you mentioned and also the enhancement.

By the way, we did a system migration, it is happening in the target system but every thing looks fine in the source system.

Best regards,

Evan

[former_member1174881]

And not for all materials but only about 10 items.

[DominikTylczyn]

Hello minaswan

Refer to the following notes on the logic of MARDH and other historical stock tables updates:

193554 - Stock/valuation data of previous periods

2708675 - MBEWH/MARDH/MCHBH doesn't contain entry for certain periods.

Also see the note 2600024 - Create a Material, updates History Tables, MCHBH, MARCH and MARDH, with past Years (LFGJA)... that explains the difference in the stock history tables handling between ERP and S/4HANA.

Assuming that you don't have any custom enhancement that messes up the stock history tables updates - see note 92550 - Stock inconsistency due to customer enhancement (exit, BAdI) - you should've gotten MARDH records in November, after the goods receipt posting in December.

One point to be careful about here is that LFMON in MARDH is a posting period not a calendar month. That might be misleading if your fiscal year doesn't follow calendar year. They don't have to be the same! So you'd need to check that.

If your fiscal year = calendar year and no custom enhancement, I'd raise a incident to SAP support about that.

Best regards

Dominik Tylczynski

[BijayKumarBarik]

You uploaded data in month of December which is current period 12 but why you are checking data on previous period 11( which is November)!

Just try checking your posting data in current period 12

[DominikTylczyn]

minaswan is checking pervious period because MARDH hold historic stock not current stock.

[former_member1174881]

Hi biju.k

An entry is not written in this history table for every period. If stock-relevant or valuation-relevant data change, the system might generate an entry in the history table.

Below is an example in note 2708675:

1. Material 4711 has a stock of 10 pieces at the end of period 01
2. In period 02, a goods receipt of 5 pieces occurs.
3. Now, an entry is added in the history table for period 01 with a stock of 10 pieces. Simultaneously, the current stock is increased to 15 pieces and the 'Current Period' field (LFMON) is set to 02.
4. In period 02, an additional goods receipt occurs with 2 pieces.
5. The history table is not affected by this operation since an entry already exists for period 01. The current stock is increased to 17 pieces.
6. In period 04, a goods issue of 4 pieces occurs.
7. Now, the system adds an entry for period 03 with a stock of 17 pieces in the history table. Simultaneously, the current stock is decreased to 13 pieces and the 'Current Period' field (LFMON) is changed from 02 to 04.
8. Since no goods movement has occurred in period 03, there is no entry for period 02 in the history table.