Scrol

SAP Trainings contact sap.sreeram@gmail.com or 091-9916083157, 001-210-399-8414

Up loading of master in SAP (Tr code is LSMW)



Up loading of master in SAP (Tr code is LSMW)
           
Note: LSMW used for create  No. of GL accounts at a time.

Ignore the message press enter

Project                        :AML
Subproject                 :FI
Object                                     :GLMaster
Select create entry button
Description                :AML Project
Enter
Sub project description FI Area
Enter
Object name                         :GL master up loading
Enter
Select continue button (F8)
Select double click Display click change button (Shift +F7)
Select execute button
Select batch in put recording radio button
From the menu select Goto recording à Overview
Select create recording button (Ctrl +F1)
Give the recording name    :AMLGL
Description                            :GL Master uploading
Enter

FS00

Give the GL Account                       :100305
Company code                     :AML
From the menu select GL Account create
Account group select secured loans
Select balance sheet account radio button
Short text and GL account long text :IDBI rupee term loan
Select control data tab
Select only balances in local currency check box
Select line display check box
Sort key                                              :001    Posting date
Select create 1 bank /Interest tab
Field status group                            :G005  Bank Accounts
Save
Keep the cursor on FS00
Select default all button
Save
Select back arrow two times
Give the recording name                :AMLGL
Enter and save
Select back arrow
Execute

Select create a structure button
Source structure                              :AMLSTR
Description                                        :AML GL Structure
Enter and save
Select back arrow
Execute
Keep the cursor on AMLSTR
Select table maintain button
Copy from
AML excel component column in SAP field name column
Copy from excel
AML excel data type column in SAP type column
Copy AML excel length column in SAP length column
Verify the copies data some data not copied copy to next page
Save

Select back arrow
Select back arrow once again
Select save button or Ctrl+S
Execute

Select back arrow
Execute
Kept the cursor on AMLGL
Save
Back arrow
Execute
From the menu select –Extras-Auto field mapping
Press enter
Go on select accept proposal button (Press Accept proposal button many times)
Till we get the message
Auto field mapping completed
Enter and save
Select back arrow
Skip maintain fixed values, transactions user defined routines
Select specify files radio button
Execute
Keep the cursor on the PC (Fronted)
Select add entry button
Select file                  :AML text
Name                                     :GL Master uploading
Select tabulator radio button
Enter & Save
Select back arrow
Execute
Save
Select back arrow
Execute
Execute once again
Select back arrow two times
Skip display read data
Select convert data radio button
Execute
Execute once again
Select back arrow two times
SKIP Display converted data
Select create batch input folder session
Execute
Execute once again
We get a message /batch input folder
With 4 transactions created
Ignore the message press enter
Execute
Select session name GL master
Select process button
Select display errors only button
Select process button
We get a message processing of batch input session completed
Select exit batch input button

To view accounts created  (Tr code is FS00)

Selected drop down button for GL A/c No.
Company code         :AML
Enter

(Note: check it uploaded GL Accounts 100001, 200125,300005,400101)