inventory cycle count report

[#1]

Hi

We need to implement inventory cycle count report . Is there a standard business content data source for this ?

Thanks and Regards

Arun

[Former Member]

Hello.

I have implemented cycle counting in the past but did this through custom extractor creation. If this is cycle count data for WM, you can look at tables LINK/P/V for the extraction. For IM physical inventory I believe you can look at ISEG.

I should also mention that I am answering this from memory and at the time we implemented the cycle count reporting in BW, I did not see any standard content that would satisfy the requirements. I also have not seen any sense then either.

Thanks

[Former Member]

Thank you Siboda, I was also not able to find any BC data source for physical inventory counting. Do you remember the other important tables for MM inventory other than ISEG ?

Thanks

[former_member181964]

Hi,

You enhance teh 0IC_C03 cube and get the required things...

In My case see how I'm calculating Physical Inventory stock, I created Normal ZKeyfigure and then written code in Transformations

Physical Inventory Stock Quantity  

ZQMM_PHIS

IF     ( SOURCE_FIELDS-movetype EQ '701'  OR
         SOURCE_FIELDS-movetype EQ '702'  OR
         SOURCE_FIELDS-movetype EQ '703'  OR
         SOURCE_FIELDS-movetype EQ '704'  OR
         SOURCE_FIELDS-movetype EQ '705'  OR
         SOURCE_FIELDS-movetype EQ '706' )
      AND
         SOURCE_FIELDS-bwapplnm EQ 'MM'.

Thanks

Reddy