inventory cycle count report

[Former Member]

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]

HI All,

I have a requirement where i need to find the materials which are not counted and need to display in

BIreport , i have the idea of how to show the counted Materials , for that we have table ISEG , and  we can  take IBLNR field for the same.

Thanks,
Ankit

[Former Member]

Sorry I never responded. It's really just a matter of what you need to report on. ISEG has all the basic information you need like plant, material, sloc, etc... so the other tables invovled is really a case by case type of thing. I can't think of much else you would really need for generic cycle count reporting.

Also, the previous post is a good method depending on your needs. If showing difference postings and whatnot is suitable, then go with the movement type. But if you need to dig deeper into it by showing system/counted quantities as well as the difference, then the custom extractor would be the way to go. For me, I did inventory accuracy/cycle counting type of reporting that needed to consider the actual quantities, as a difference of 2 units on an inventory of 100,000 units is a lot different that 2 units difference on a balance of 100 units. But that was just my case is all.

Hope this helps.

Thanks

[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

[Former Member]

Hi arun cs:

Please take a look at the documentation on the Inventory Turnover standard report (Technical name: 0IC_C03_Q0017).

http://help.sap.com/saphelp_nw70/helpdata/en/fd/e2b3bc39614e46b74264137105bea4/content.htm

The datasources for Inventory Management are 2LIS_03_BF, 2LIS_03_BX and 2LIS_03_UM.

Regards,

Francisco Milán.