Relationship between MBEW/MBEWH and T030

[Former Member]

Hi there,

I am building custom SAP extraction scripts to produce Inventory reports (as we have a centralised extraction approach), and as part of this process I need to be able to reconcile MBEW/MBEWH to the GLT0 at a particular point in time.

I am aware of the logic involved to produce a view as at a certain period by unioning both tables and using LFGJA and LFMON, and subsequently joining on to T030 (filtered for KTOSL = BSX) using BKLAS and grabbing KONTS/KONTH.

However, when I do this, it doesn't quite reconcile to the GLT0. Drilling down, this appears to be based on WERKS - when you filter for a certain combination of WERKS values, the report will reconcile.

Is there additional logic I need to layer in to get the account assignment correct?

Thanks,

Stephen