what is data take over and how to do in sap

DATA TAKEOVER 

Master uploading

Balance uploading

Master uploading:

GS Master                 :FS00

Vendor masters        :XK01

Customer masters    :XD01

Asset masters                       :AS01

Material master         :MM01

Create an excel file à conversion to text file à Up loading to SAP

Legacy System Migration Work bench (LSMW)

Batch data Communication (BDC)

Computer aided testing tool (CATT)

ABAP :They teach all 3 methods

LSMW:Job of functional consultant

Open an excel file and note down for which fields values are to be uploaded

GL Account no.	Company code	Account Group	P & L Statement A/c	Balance Sheet A/c	Short Text	Long Text	Account currency	Only Balance in local currency	Line item display	Sort key	Field status group
100001	AML	SCPL		X	PREF –Share cap.	PREF Share Cap.	INR	X	X	001	G001
200125	AML	CAST		X	Inventory –Stores	Inventory –Stores	INR	X	X	001	G001
300005	AML	SALE	X		Sales trading	Sales Trading	INR	X	X	001	G001
400101	AML	PRSN	X		Wages account	Wages account	INR	X	X	001	G001

Delete above column headings

Delete other sheets (like sheet 2 , sheet 3)

Select complete sheet

Press right mouse button

Select format cells

Select number à Category à Text

Select ok button

From the menu select file save as

Save type                  :select Text (tab delimited)

File name                  :AML Text

Select save button

Select no button

Select cancel button

From the menu select file à close

Select no button

1. Open an excel file and not down technical name of  each filed technical name shall be noted down as per step one order

Open an excel file

Component              Data type                  length

Open SAP FS00

Give the GL No.100000 Equity share capital

Company code         :AML

Enter

Keep the cursor on GL A/c press F1

Select technical information button

Double click field name SAKNR

Copy component SAKNR in excel 1 component column

Data type                   :C

Length                       :10

Copy component BUKRS that is company code in excel component column

Data type                   :C

Length                       :4

Select back arrow in SAP

Keep the cursor on account group

Press F1

Select technical information button

Double click on filed name KTOKS

Copy component KTOKS that is account group in excel component column

Data type                   :C

Length                                   :4

Copy component XPLACCT That is P & L statement account in excel component column

Data type                   :C

Length                       :1

Copy component XBILK that is I Balance Sheet A/c in excel component column

Data type                   :C

Length                       :1

Copy TXT20-ML That is GL A/c short text in excel component column

Data type                   :C

Length                       :20

Copy component TXT50_ML That is GL long text in excel component column

Data type                   :C

Length                       :50

Select back arrow

Select control data tab

Keep the cursor on account currency press F1

Select technical information button

Double click on filed name WAERS

Copy component WAERS that is account currency in excel component column

Data type                   :C

Length                       :5

Copy XSALH that is only balance in local currency in excel component column

Data type                   :C

Length                       :1

Line item display      :copy component XKRES that is line item display in excel component column

Data type                   :C

Length                       :1

Sort key:  copy component ZUAWA that is sort key in excel component column

Data type                   :C

Length                       :3

Copy component FSTAG that is field status group in excel component

Data type                   :C

Length                       :4

Save the file an ex file, file AML

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)