2LIS_11_VAITM mismatch values in ECC and Bw

[Former Member]

hi all,

i am getting mismatch data in ECC and BW report i am using "sales overview/delivery" cube for same data source is 2LIS_13_VDITM,2LIS_12_VCITM and for cube "sales overview/order" i am using data source as 2LIS_11_VAITM,

both cube is in same multiprovider. i am comparing sales quantity in BW with ECC, in query i have sales quantity= invoice quantity-Return invoice quantity.Can any one tell which cube should i dig for my values and for which infoobject.any guess for why values are not matching report is CSO.

point for sure.

[Former Member · Accepted solution]

Hello Ganesh,

Check with your core team member what transaction code you have to check in the ECC side. Because some companies will use the custom developed z transaction and they will be restricting some condition types.

You can also check 0SD_O06 (this is Billing Condition Data DSO). If your company is restricting any value based on condition type & Billing Type, Then you can use this DSO.

With Regards,

Balachander.S

[Former Member]

thanks it works.

[Former Member]

Hello Ganesh,

If you know the R/3 side technical names of the fields for which you want to reconcile the data in BW, I would suggest to look at those datasources in BW and follow the transformation mappings in the data flow till infocubes.

It will get you to the cube and also the infoobjects you are searching for.

and regarding the data mismatch in BW, there could be several reasons.

Check the requests in the corresponding cubes for any missed deltas or any error request. check the load history in the monitor and see if you have missed any request.

Regards

Pratap Sone