cancel
Showing results for 
Search instead for 
Did you mean: 

Validation of Stock Between ECC and BI

former_member202718
Active Contributor
0 Kudos
172

Dear All,

We compare the material quantity in MB5B or MMBE ,however i would like to do a compairson at Company code level/Plant with the Aggregated totals.

I would like to know what is the Total stock avaliable for this plant ,irrespective of material.

Is there any way to do that.

rgds

SVU123

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello ,

You can use tcode SQVI to create a SQL query to base tables.

But ensure you restrict on the Plant/Company code and Dates.

SQVI can be view only by you if you create it.

Thanks

Sarat

Answers (1)

Answers (1)

former_member210724
Contributor
0 Kudos

Hi,

Try this,

"MC.9" is one ECC report to check the total stock.

Hope in BI, plant wise total stock is available for you.

regards,

anand.

srikanthbwbw
Active Participant
0 Kudos

Hi

Also try MB59.

Thanks

Srikanth

former_member202718
Active Contributor
0 Kudos

I will try out and update you....but not sure whether the data will match.

Have u matched the quantity in your project.

rgds

SVU123

former_member210724
Contributor
0 Kudos

For miss match issues, I always refer respective base tables in ECC.

I did not match but it is also a standard report for total stock in R3.

Regards,

Anand

former_member202718
Active Contributor
0 Kudos

Dear All,

I am still unable to find the solution for this.Is there any TCode /Table where i can compare My BI data with ECC or is there any Blog where i can refer to or any standards we have to to compare the data.

Can anyone throw some light on this.

rgds

SVU123