cancel
Showing results for 
Search instead for 
Did you mean: 

Uploading physical inventory count using spreadsheet

Former Member
0 Kudos

We are having requirement to upload physical inventory count for multiple materials using spreadsheet.

Please recommend any SAP transaction to accomplish this.

Helpful answers will be awarded with points ASAP.

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

JL23
Active Contributor
0 Kudos

MI34, MI38, MI40 and MIMD are designed for that purpose.

Read the docu behind the blue info button at the selection screens.

Former Member
0 Kudos

Hi Jurgen,

Can you give me details steps in MI34 or any other solution to this?

I want to enter Inventory count as Batch Input session.

former_member335885
Active Contributor
0 Kudos

HI,

Description:

This report generates a batch input session (BI session) which, when processed, enters the inventory count results with reference to a physical inventory document.

Requirements:

Entering counting results via a batch input session requires that the corresponding physical inventory document has been created in the system. If you try to enter a counting result for which no physical

inventory document exists, an error will occur during the BI session, which will interrupt processing.

Any errors are recorded in the log file for the corresponding BI session.

Before the sequential file is read, you should perform a test run. For this purpose, you have to maintain the corresponding test data in table T159I. For the sequential file data to be read and and for test data in

table T159I, please note the following:

The name of the report has to be specified only in table T159I. The name to be specified is RM07II34.

The name of the BI session is optional.

The name of the transaction Enter inventory count to be specified is MI04.

The following data must be entered into the system:

Count date

Fiscal year

Number of physical inventory document

Item in physical inventory document

Quantity of stock counted

Output:

The system generates a batch input session which you can process via

options System -> Services -> Batch input -> Sessions.

When processing the batch input session for testing purposes, you should

set the Display errors only indicator.

When importing the actual productive data, you should always use the

Background indicator.

If data expected by the system (required-entry fields) does not exist,

an error will occur during the batch input session which will interrupt

processing.

An error will also occur during the batch input session if you try to

maintain data not expected by the system (fields not ready for input).

However, processing will not be interrupted. The system writes a comment

in the session log.

Thanks & Regards,

Kiran

Former Member
0 Kudos

Dear, Can you provide some detailed instruction on MI34? The SAP's description is not easy to be understood.

Regarsd

Answers (2)

Answers (2)

Former Member
0 Kudos

*

srinivasa_maruvada
Active Contributor
0 Kudos

Hi

Use TCode LSMW and create a xl file and then upload your data. You may need Abaper's assistance to make it as foolproof.

Cheers

Srinivas