on 09-11-2008 11:41 AM
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.
MI34, MI38, MI40 and MIMD are designed for that purpose.
Read the docu behind the blue info button at the selection screens.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
*
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.