How to design query on cube ( 0ic_c03) VVurgent

[Former Member]

Hi,

We are using infocube 0ic_c03 for designing the query which is using

NCKF,

My cube is defined non cummulative on the basis charactristic 0plant and 0calday.

Can any body tell me is it mandatory to use eithe calday or plant during query design.

Regards

Premanshu Gupta

[Former Member]

Premanshu,

Date value plays a critical role at the moment of reporting Inventory data so I'd advise you to always include some date element (could be Calendar day, month, week, fiscal year, period, etc) to obtain accurate results on your report.

As per Plant, it's not mandatory... You can report by any other characteristics like Material , Storage Location, etc... Plant is just the classical "organization" object for Inventory.

Regards,

Luis

[Former Member]

It is not mandatory, but not using date will give you the most current inventory, which is when you did your last load. This could be what you want though... As for plant, if you only want total inventory for the whole company, that's fine too.