0IC_C03 Total Issue & receipts mismatch

[functionalconsu]

We've created a query from 0IC_C03 cube which shows the total receipts & total issues.

But if we try to match with ECC respesctively, we get the results vis-versa i.e., the issues are coming in receipts column in BW & also the reverse with receipts.

Please help.

Points shall be awarded for all replies.

Kind Regards,

Jas

BW team

[Former Member · Accepted solution]

Hi,

Just make sure that techinal names of the source system field you are looking are coming in picture in mapping say transfer rules and trace the actual key figure you have to use.

Do check mappings in transfer ,update or transformation .

Regards

Rahul Bindroo

[functionalconsu · Accepted solution]

Hi Rahul,

The mappings are all standard in 0IC_C03.

We've not modified any mappings.

Regards,

[Former Member · Accepted solution]

Hi

Since it is a Z query and as you have already mentioned the standard delivered model has not been changed. As Rahul as already suggested take a look at your query definitions. Maybe take that break and have a cup of coffee beforehand

[Former Member · Accepted solution]

Hi,

Please take the drill down with movement types and check how data is getting populated as per movement types. This might give you some break thro'

Regards,

Rohit

[functionalconsu · Accepted solution]

Hi Rohit,

I've tried drilling down the movement types.

But the main issue is, if we compare with MB5B & our zquery;

the Qty Issue in MB5B comes in Receipts(BW) & the Qty Receipt in MB5B comes in Issues in BW.

Pls. guide .

Kind Regards,

Jas

[Former Member · Accepted solution]

Dear Jas,

Did you solve this issue? We encountered the same problem and can't find any consistent documentation or solution for this.

Thanks in advanced.

Best regards,

Angel Zamora.

[Former Member]

Hi

Is the query that you are using delivered (part of business content) or something that you have defined?

If the latter just check you are using the correct key figures in each case

[functionalconsu]

Yes, we are using correct key figures & the query is Z query not Business content query.

Key Fig are : 0ISSTOTSTCK (Issue Quantity Total Stock)

and 0RECTOTSTCK (Receipt Quantity Total Stock)