How To Fix OC843 - Stock in additional qty append. table inconsistent with table MARD/MCHB

SAP Error Message - Details

• Message type: E = Error

• Message class: OC - IS-Oil: BDRP Bulk Distribution Requirement Planning messages

• Message number: 843

• Message text: Stock in additional qty append. table inconsistent with table MARD/MCHB

What causes this issue?

Stock in additional quantity appendix table inconsistent with table
MARD/MCHB.

System Response

You cannot assign a material to a tank when there is an inconsistency
in the stock between that in table MARD/MCHB and the additional
quantity appendix table (MARDO1 or MCHBO1).

How to fix this error?

Check for inconsistency between stock tables MARD/MCHB and the
additional quantity appendix table. Correct the inconsistency. Check
SAP Note 212707 for details on how to solve the inconsistencies in
stock tables.

Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message OC843 - Stock in additional qty append. table inconsistent with table MARD/MCHB ?

  The SAP error message OC843 indicates that there is an inconsistency between the stock information in the additional quantity append structure and the standard stock tables MARD (Storage Location Data for Material) and MCHB (Batch Stock). This inconsistency can occur due to various reasons, such as data corruption, incorrect updates, or issues during data migration.
  Causes:
  
  Data Corruption: The additional quantity append structure may have been corrupted due to system errors or improper updates.
  Inconsistent Updates: If stock levels are updated in the additional quantity append but not reflected in the MARD/MCHB tables, inconsistencies can arise.
  Custom Development: If there are custom developments or enhancements that manipulate stock data, they may not be correctly synchronized with the standard tables.
  Data Migration Issues: During data migration or system upgrades, if the data is not migrated correctly, it can lead to inconsistencies.
  
  Solutions:
  
  Consistency Check: Use transaction codes like MMBE (Stock Overview) or MB52 (List Warehouse Stocks on Hand) to check the stock levels and identify discrepancies.
  Reconcile Data: If discrepancies are found, you may need to reconcile the data manually or through a program that can update the additional quantity append structure to match the MARD/MCHB tables.
  Use SAP Reports: Utilize standard SAP reports or tools to identify and correct inconsistencies. You can also check for any SAP Notes related to this error message for specific fixes or recommendations.
  Custom Code Review: If there are custom developments, review the code to ensure that it correctly updates both the additional quantity append and the standard stock tables.
  Database Consistency Check: Run database consistency checks to identify and fix any underlying issues in the database that may be causing the inconsistency.
  SAP Support: If the issue persists, consider reaching out to SAP support for assistance. They may provide specific guidance or patches to resolve the issue.
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as MMBE, MB52, and SE11 (Data Dictionary) to analyze the data structures involved.
  SAP Notes: Search the SAP Support Portal for any relevant SAP Notes that address this specific error message or similar issues.
  Documentation: Review SAP documentation related to inventory management and stock management to understand how the additional quantity append structure interacts with MARD and MCHB.
  
  By following these steps, you should be able to identify the cause of the inconsistency and implement a solution to resolve the OC843 error message.