DATA TAKEOVER

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