Skip to Content

SAP Inventory History tables (MBEWH) in HANA

Dear all,

From SAP Release 4.5, SAP comes with inventory history tables such as MBEWH and MCHBH. However SAP has a specific routine in updating these tables as described previously by Juergen L in http://scn.sap.com/docs/DOC-42476. Also 'previous period' in MBEW has been replaced by the H-tables.

SAP seems to have specific function modules _EXTEND to use the table in an ABAP environment.

However, I am trying to make sense of these H-tables in HANA through normal SLT load (right now with no transformations) in a simple Analytic View. Exactly though because of the specific logic of updating the logic in SAP, this seems not to be easy at all. When certain months have no material movements for a specific material/plant, there is no record at month/year for that plant/material in the H-table, the inventory gets only updated in the month, previous to the month of the next movement in time, causing serious reconciliation issues.

Does anyone have experience in using the inventory history tables in Hana? Is the solution SLT transformations? Or to use SQL based Calculation Views? There is no HANA Live Content for this.

Thanks a lot,

Stefaan Dochy.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2013 at 02:38 PM

    Hi Stefaan,

    Sounds nasty if the ECC tables aren't storing the data correctly at the table level and need ABAP functions to interpret them and display correctly.

    Sounds like the ABAP logic will need to be replicated in SQL based CV. 😠

    Hopefully the SAP team working on the HANA Live content will come up with the solution and share it with you before you have to reinvent the wheel. 😉

    Cheers

    Aron

    Add a comment
    10|10000 characters needed characters exceeded

    • hi Kannuri,

      We debugged t: MB5B (RM07MLBD) earlier to see how SAP is doing it. MB5B is somewhat the standard transaction to report opening/closing stock at some point in time.

      SAP standard takes current stock from MARD I believe and sums all movements from MSEG up to the opening and closing stock as per selections on the program. It then calculates backwards opening / closing stock from that. So it is not using the History tables! The transaction in ECC is therefore understandably very slow, but in SAP HANA, it could be a reasonably simple design.

      Hope this helps,

      Stefaan Dochy.

  • Posted on Oct 30, 2019 at 05:12 PM

    Stefaan, I know it has been years, but did you solve the issue?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.