IC_c03 - Cube - Data Issue

[Former Member]

Dear All,

we are facing very strange issue in our production system. i will try to explain you our current scenario for Inventory. The Problem we are facing is in "Inventory Aging Query"

We have a copy of standard cube 0IC_C03 and we have done lots of customization in Z copy - ZIC_C03.

Inventory Aging Report - All Aging buckets do the calculation based on "Last GR date " which we have fetched from "Batch" . We have create "ZBATCH ( Not using standard data source) .

we have added few extra object in ZIC_C03 and we are getting those objects by writing Transformation routines. Objects like Sales Order , Item , Sold_to haven been fetched from Sales Cube into ZIC_C03. we are using SOLD_TO as a customer in Inventory queries.

Now Problem is :

Customer is a free char in query designer . without customer Inventory Aging report gives exact data. Now, when we drag customer in report it will give many negative values for quantity .Also, The final result is matching with the ECC but user does not want this negative values as in ECC the actual value is 0.

Please suggest.

[Former Member]

Hi,

your problem is related to the following:

The inventory got initialized by datasource 2lis_03_bx. --> here, no customer number is assigned to the data.

The movements are loaded via 2lis_03_bf. --> here usually you get a custumer number only with goods issues which are negative values.

So as the initialization as well as the receipts are coming without customer number and/or sales order there is no solution for your problem.

You might think about creating a restricted keyfigure based on the customer number and take the customer number completely off the query. But this keyfigure will also show only the negative values (may be just for some returns you get a positive value here).

regards

Siggi

[Former Member]

Hi,

I'm not clear about the ZBATCH which you have mentioned, if it is a Goods Reciept batch then how it can be related to SOLD to, can you please elaborate what exactly you are having in aging bucket.

Regards,

Chandra.

[roland_hoeller2]

Hi

Please note that you have posted into the wrong forum and I have therefore moved the thread. The Business Intelligence Solution Architecture is for SAP BusinessObjects BI Platform and SAP BusinessObjects Enterprise XI products

Thanks and Regards
Roland Hoeller
Forum Moderator

[Former Member]

Hi,

Pls execute the query in RSRT with execute+debug. And check for that object from where its getting negative values and backtrack the issue.

Thanks & Regards,

Chandra Sekhar