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

VENDORS LIST

VENDORS LIST 

Path :Accounting –Financial accounting –Accounts payable –Information system -Reports for accounts payable accounting –Mater data –Vendor list (Tr code is S_ALR_87012086)

Give the company code                  :AML

Select address and telecom check box

Execute

Vendor wise patches

Path :Up to report for account payable accounting the path is same -Vendor balances vendor business (S_ALR_87012093)

Give the company code                  :AML

Execute

Each vendor wise

Out standing lit of vendors:

Path :up to reports for accounts payable accounting the path is same

Vendor Items- List of Vendors Open item for printing (S_ALR_87012083)

Give the company code                  :AML

Execute

Age wise analysis of vendors:

Path :Up to vendors column item the path is same -Vendor payment history with open item sorted list (S_ALR_87012085)

Give the company code                  :AML

Summarization level                                   :0

Select days overdue squirted list check box

Execute

Vendor advances report

Path :Up to vendors column items the path is same –List of Down payments open on key date vendors (S_ALR_87012105)

Give the company code                  :AML

Execute

Vendor ledger:

Path :Open and cleared up to vendors: Item the path is same –List of vendor line item (S_ALR_87012103)

Give the company code      :AML

Execute

Depreciation fore cost

Path :Accounting –Financial accounting –Fixed Assets –Information system -Reports are asset accounting –Depreciation fore cost-Depreciation on Capitalized Assets (Depreciation simulation) (S_ALR_87012936)

Give the company code      :AML

Report date                           :31.03.2011 (Give the any month end date)

Execute

Fixed assets schedule as per schedule VI of Companies Act

Path :Information system –Accounting –Financial accounting –Fixed assets -Asset history sheet (Tr code is AR02)

Give the company code                  :AML

Report date                                       :31.03.2009

Select group totals only radio button

Execute

Select assets button

Double click on asset retirements

TRAIL BALANCE

TRAIL BALANCE

Path: Up to general ledger report the path is same -Account balances –Korea-Trail Balance (Tr code is (S_ALR_87012310)

Country          :Korea

Trail balance             :South Korea

Give the company code      :AML

Execute

Ignore the warning message press enter

Select current layout button

Keep the fields

GL account

GL account long text

Closing balances

Enter

To down lead to excel from the menu select list export –spread sheet

Enter

List –>Export local file

Select spread sheet radio button

Enter

See directory file name :AML.xls

Select generate button