S_P99_41000062 / RKKBMLMAT tables and logic

[former_member766120]

Hi,

Is there any way to reverse engineer the logic / table joins performed by S_P99_41000062 a.k.a RKKBMLMAT?

I need to pull some data from SAP and perform some calculations over inventory on hand for different periods.

I have come up with this idea of mimicking tcode S_P99_41000062 which runs the underlying report RKKBMLMAT and serves the exact purpose of knowing stock on hand and value as of a given period.

To achieve that, I have played around with tables MBEW, MBEWH, MARD, MARDH for days, with only partial accurate results. My logic breaks down eventually and will not match 100% with S_P99_41000062 for certain periods.

The goal is to pull the data to a staging database, do the calculations and post results onto another table, in a database server of our own.

Again, all needs to be done at table level, which are my only building blocks. I don't have access to any other resources at this point.

That means we don't have access to inspect ABAP code, query objects other than tables and we even have very limited access as end-users on the Client. We do have, however, access to extract most SAP tables into our database.

Kind regards.

[drbharucha]

Hi marcelo_pe

This is very much possible and I have been using this for a long time, Please refer to the given link, this will not only gives all Cl. stock for month-end inventory on Standard price and PUP price but also given the entire CCS for further analysis

Please understand the logic first, for price control S and V for a given period and need to SQVI right.

https://blogs.sap.com/2016/06/12/multiple-material-cost-components-report-with-sqvi/

The summation all cost field for price control "S" is a standard price and the summation of "V" is PUP.

good luck

- Divyesh Bharucha