cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Inventory History tables (MBEWH) in HANA

0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

jmoralescalvo
Explorer
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Aron,

how to calculate

MBEWH table

current month opening stock would be LBKUM for max of LFGJA -  LFMON

I am new to SAP..please aneone can help me....

0 Kudos

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.