Implementing cycle count

[Former Member]

Hi MM Experts,

I have to implement SAP cycle count at material(inventory)level in my organisation.

Each material is to be counted atleast once a year.

To do this I know that I have to set the cycle count indicator in the material master plant data view.

As I have about 10000 materials, I want them to be distributed equally amongst the working days of my organisation.

For example if we have 10000 materials and 250 working days - 10000 / 250 = 40

Which gives 40 materials to be counted each day.

As the base count date is set to the last counted date, is there a way that I can change the last counted manually that I'll be able to distribute the total number of materials equally amongst the total working days.

If there is a method where I can prepare an excel sheet and upload it to the system, can someone please guide me on how to do it.

Thanks in advance.

Regards,

Randi

[Former Member · Accepted solution]

Do you want to upload the documents via Excel? Try doing the ABC segmentation first.

Anyway, if you want to do it via Excel, try looking at BAPI_MATPHYSINV_COUNT.

[Former Member · Accepted solution]

Hi Paulo,

Thanks for the response.

Yes I have already done the ABC segmentation.

What I need to do is to give my own dates as the base count date for each material.

Can u pls let me know where the last counted date is maintained and a way to change it(possibly using excel upload)

Regards,

Randika

[Former Member · Accepted solution]

The system calculates the planned count date for all stock types as folllows: Date of last physical inventory of unrestricted-use stock + predefined interval

If a material needs to be counted, the inventory program will create a batch input session for creating physical inventory documents but it will be based on the last date of physical inventory.

Have you considered using MI31 instead? That will give you full flexibility on what materials you wish to count.

[Former Member · Accepted solution]

Hi Paulo,

Yes I tried this transaction and it generates the inventory document based on the current planned count date for each material.

Is there a way that I can change the default planned count date for each material.

If I can set the count date for each material my problem will be solved to a greater extent.

Regards,

Randi

[Former Member · Accepted solution]

Hi,

Can someone please guide me how to assign different "last counting dates" to a material manually and do a table update.

Regards,

Randi

[JL23]

Cycle counting is usually a methód that is used if you have a low inventory accuracy in your warehouse.

So you want count certain materials more often.

But all material with the same cycle count indicator does not make any sense, then it is better to use MI31, because then you will not have the problem that you currently have.

In cycle counting SAP determines when which material is to be counted, and this will never be an equal amount.

you can try to get it alomst equal by manipulating the last inventory count, which is especially needed if you start with a new system, which does not have a last inventory count.

But SAP has no program for this. you have to create an ABAP yourself that does a hard table update.

[Former Member]

Hi Jurgen,

Thanks for your valuable input.

Yes I'll prefer to use MI31 for the cycle count. But this transaction too generates he inventory list based on the last count date.

Therefore I need to change the last count date of each material to make it almost equal.

Can u pls let me know the tables involved and if I'm to do an ABAP program to update the tables?

Regards,

Randi

[JL23]

MI31 is not cycle counting, MI31 is anual count.

It does not consider last inventory count. It just considers if a material was already counted in the current fiscal year and will not propose it again.

But you can set an indicator to include already counted materials (and include already counted batches). by clicking the button Acc.toStock in the middle of the selection screen you get a expanded section in the selection screen to make this setting.

[Former Member]

Planned count date calculated as follows :

planned date = base date + Interval (Trans.OMCO/Tab.XT159C-ININV)

Usually, the base date is the 'date of the last physical inventory'.

Depending on the type of the stock or the batch management

requirement, this date is read from one of the following table fields:

MARD-DLINL (Normal materials)

MCHB-CHDLL (Batch materials, separately valuated materials)

If no physical inventory has been carried out yet and if this date

field is therefore empty, the system uses the creation date of the

material as basis date. The basis date then comes from one of the

following table fields:

MSTA-ERSDA (Normal materials)

MCHB-ERSDA (Batch materials, separately valuated materials)

Thanks,

Deepak