AC305_EN_Col92_FV_Part_A4 (第8页) | ERP软件技术分享

第 261 页 / 共 343 页

AC305 Lesson: Report Selection

This,inturn,isembeddedintheAssetAccountingareamenu(=>ASMN).

The area menus can be displayed and changed in area menu maintenance

(transaction SE43).

Figure 81: SAP List Viewer

Assetreports(sincerelease4.6)usetheABAPListViewer(=>ALV):Thistool

isusedtostandardizeandsimplifyusingreportsintheSAPSystem.

There is a new graphical design, which makes it even simpler to process and

displaylistsandreportsusingtheALV GridControl.

Important List Viewer functions:

• Deleting and inserting columns

• Arrangingthevaluesincolumnsinascendingordescendingorder

• Calculatingtotalsorsubtotalsacrossoneormorecolumnswithinalist

• Usinglayoutstosaveanindividual report structuresothat youcanuse it

again later

• Set filter: You can choose to have only those lines displayed that meet

certain criteria.

• YoucanaddanynumberofassetinputfieldstoALVreportsinFI-AAusing

“FIAA_SALVTAB_* structures”.

245

第 262 页 / 共 343 页

Unit5: InformationSystem AC305

Figure 82: Sort Criteria

All reports allowyou tosort/total data in different ways using freelydefinable

sort criteria.

A sort variant consistsof amaximum of fivesort levelswhicharedetermined

via ABAP Dictionary fields.

Thereportcanoutputatotaland,insomecases,astatisticforeachsortlevel.

• In the Total column, you can specify the levels at which you want totals

to be output.

• Youcanseeamoredetailedbreakdownofthetotalofagrouplevelinsome

lists by selecting the Statistics indicator.

YoucanuseasortvariantwithanyFI-AAreport/program.

246

第 263 页 / 共 343 页

AC305 Lesson: Report Selection

Exercise 13: Report Selection

Exercise Objectives

After completingthisexercise, youwillbeableto:

• ... Execute a report

• ... Use a sort version

• ... Navigate in a list

Business Example

The Cost Accounting department wants the Asset Accounting department to

providealistofpostedassets,sortedandtotaledaccordingtocostcenter.

Task 1:

Complete the following tasks.

1. TheCostAccountingdepartmentwouldlikeyoutodothefollowing: They

wouldlikealistofall(posted)assetsofyourcompanycodeAA##,sorted

andtotaledaccordingtocostcenter. Forthisreason,youshouldstartan

assetreport(=>programRABEST_ALV01)withtheappropriatesortvariant.

2. Optional: Use “SAP Mail”to send this list to theuser sitting in front of

or behind you.

Task 2:

Complete the following tasks.

1. YouwanttochangeanassetreportofyourcompanycodeAA##sothatthe

assetsofyourcompanycodearelistedbyacquisitionvalueindescending

order.

2. Savethesesettingsina(user-specific)displayvariant / a(user-specific)

layoutand thentry to callupthevariant again.

Task 3:

Complete the following task.

1. NowtesttheDynamicSelectionsfunction. Inyour company codeAA##,

search for all (posted) assets that contain your group number## in the

Description master record field.

247

第 264 页 / 共 343 页

Unit5: InformationSystem AC305

Solution 13: Report Selection

Task 1:

Complete the following tasks.

1. TheCostAccountingdepartmentwouldlikeyoutodothefollowing: They

wouldlikealistofall(posted)assetsofyourcompanycodeAA##,sorted

andtotaledaccordingtocostcenter. Forthisreason,youshouldstartan

assetreport(=>programRABEST_ALV01)withtheappropriatesortvariant.

a) In the Asset Accounting application, select Information System →

ReportsonAssetAccounting→AssetBalances→BalanceLists→

Asset Balances→ ... byAsset Number.

Enter the following values:

Fieldnameordatatype Values

Company code AA##

Report date Dec 31 CY

Sort version 0014

List assets Select

ChooseProgram→Executefrom themenu.

2. Optional: Use “SAP Mail”to sendthis list to theuser sitting in front of

or behind you.

a) Have you completed exercise 1? – OK

ThenselecttheList→MailRecipientmenubar.

Entertherelevantusername(=>typicallyAC305-##)astherecipient.

Select the Document→Send menu bar.

Continued on next page

248

Fieldnameordatatype	Values
Company code	AA##
Report date	Dec 31 CY
Sort version	0014
List assets	Select

第 265 页 / 共 343 页

AC305 Lesson: Report Selection

Task 2:

Complete the following tasks.

1. YouwanttochangeanassetreportofyourcompanycodeAA##sothatthe

assetsofyourcompanycodearelistedbyacquisitionvalueindescending

order.

a) In the Asset Accounting application, select Information System →

Reportson Asset Accounting →Asset Balance →Balance Lists →

Asset Balance → ... by Asset Number.

Enter the following values:

Fieldnameordatatype Values

Company code AA##

Report date 31.12.CY

Sort version 0013

List assets Set

ChooseProgram→Executefromthemenu.

Select the Acquis. Value column.

SelecttheSortin DescendingOrderbutton.

2. Savethesesettingsina(user-specific)displayvariant / a(user-specific)

layoutand thentry to callupthevariant again.

a) Have you completed exercise 1? Good.

SelecttheSettings →Layout→Savemenubar.

Give the variant a name, for example VAR## (=> ## = your group

number), and set theUser-specificindicator.

Tocallupthevariantagain,youmustfirstexecutethereport.

SelecttheSettings→Layout→Choosemenubar.

SelectyourvariantVAR##withamouseclick.

Continued on next page

249

Fieldnameordatatype	Values
Company code	AA##
Report date	31.12.CY
Sort version	0013
List assets	Set

第 266 页 / 共 343 页

Unit5: InformationSystem AC305

Task 3:

Complete the following task.

1. Nowtest theDynamicSelectionsfunction. In your company codeAA##,

search for all (posted) assets that contain your group number## in the

Description master record field.

a) Thebestwaytodothisistouseanassetlist: IntheAssetAccounting

application,selectInformationSystem→ReportsonAssetAccounting

→ Asset Balance→ BalanceLists→Asset Balance →... byAsset

Number.

Enter the following values:

Fieldnameordatatype Values

Company code AA##

Report date 31.12.CY

Sort version 0013

List assets Set

Do not execute this program yet.

SelecttheEdit→DynamicSelections menubar.

Inthe“frame”thatisdisplayed,opentheGeneralDatafolder.

Double click on Description.

Onthe“right-hand”sideofthescreen,enter*##*intheDescription

field.

ChooseProgram→Executefrom themenu.

250

Fieldnameordatatype	Values
Company code	AA##
Report date	31.12.CY
Sort version	0013
List assets	Set

第 267 页 / 共 343 页

AC305 Lesson: Report Selection

Lesson Summary

You should now be able to:

• ... ChooseandexecutethevariousAssetAccountingreports

• ... Setupvariablesortingandtotalingforassetreporting

251

第 268 页 / 共 343 页

Unit5: InformationSystem AC305

Lesson: Value Simulation

Lesson Overview

Depreciation and transaction simulation

Lesson Objectives

After completingthislesson, you will beable to:

• ... Generateadepreciation(and/ortransaction)forecastforanassetfromthe

Asset Explorer

• ... Generate a depreciation forecast for various assets using program

RASIMU02

Business Example

Whenyouwerediscussingthepreparationsforyear-endclosingwiththeproject

team, your colleagues in Financial Accounting wondered if it was possible to

adjusttheasset portfoliotothegoalsof balancesheetpolicybeforetheclosing

takes place.

YouexploretheFI-AAinformationsystemanddiscoverfunctionsandprograms

to simulatedifferentvaluationsforthefixedassets.

Figure 83: Simulation with the Asset Explorer

TheAssetExploreroffersextensivepossibilitiesforevaluatingindividualasset

master records.

252

第 269 页 / 共 343 页

AC305 Lesson: Value Simulation

By entering an asterisk “*” in the subnumber field, you can (even) request

combinedreportingforamainnumberandthesubnumbersbelongingtoit.

ChoosetheDisplaydep. calc. functiontoseeadetaileddisplayofthecalculation

of depreciation in the system.

ThePostedValuestabpagedisplaysnotonlytheplanneddataforafiscalyear,but

also the amounts actually posted to date.

FromSAPR/34.7,youcanalsousetheAssetExplorertocreateapreviewofhow

thevaluesforindividualassetswilldevelopbymeansofsimulatedtransactions

and/or simulated depreciation terms.

YoucanstartvariousotherassetreportsfromtheAssetExplorer. AsofRelease

4.7, you can createyour ownreport variants for these reports: Menu barGoto

→ Maintain Reports.

Figure 84: Depreciation Simulation

Simulation, in this context, refers to an experimental change to depreciation

parametersaffectingthevaluationof assets. Thischangecanapply toa single

asset, the entire asset portfolio, or parts of it.

Our example describes the standard report for depreciation simulations -

report RASIMU02.

253

第 270 页 / 共 343 页

Unit5: InformationSystem AC305

When you simulate the development of asset values, you can change all the

important depreciation terms using a simulation version and simulate the

depreciationforfuturefiscalyears; seenextgraphic.

Note: Youhavethe optionof including depreciation for your planned

capital investments in the forecast. In order to take advantage of this

option, you have to be managing the planned investment amounts as

planned costs onan order or project in CO. By assigning depreciation

terms and a planned start-up date to the order or project, you make it

possibleforthefuturedepreciationtobedisplayed.

Figure 85: simulation versions

Simulationversionsallowyoutosimulateachangeofdepreciationlogic.

Foreacharea,assetclass, anddepreciationkey,specifywhichdepreciationkey

and useful life should be chosen as alternatives for simulation. The validity

intervalexcludesassetswithacapitalizationdatethatliesoutsidethatrange.

254

第 271 页 / 共 343 页

AC305 Lesson: Value Simulation

Exercise 14: Value Simulation

Exercise Objectives

After completingthisexercise, youwillbeableto:

• ... Forecast future depreciation amounts

Business Example

Youwanttosimulatedepreciationforassetsinthedepreciationforecast.

Task 1:

Complete the following tasks.

1. Post an acquisition to thelast, unposted company carmasterrecord*.

Post a value of € 50,000 on Jan 10 CY.

*Ifyoudonothaveanymoremasterrecordsthathavenotbeenpostedto,

simply create a new one in class 3100.

2. Whatisthequickestwaytolookatthechangesinvalueofthis(one)asset

for the next five years?

3. Howhighisthestraight-lineannualdepreciationamount?

4. Fortaxreasons,youareconsideringreducingtheusefullifeinarea01AND

area02from5to4years.. SimulatethischangeintheAssetExplorer.

5. Howhighwouldtheannualdepreciationamountbe?

6. Simulate a subsequent acquisition of € 20,000 for the above asset Jun

30 CY.

Continued on next page

255

第 272 页 / 共 343 页

Unit5: InformationSystem AC305

Task 2:

Complete the following tasks.

1. Youarenowinterestedinthefuture,annualchangesinvaluenotjustof

oneasset,butofmanyassets,forexample,awholeassetclass. Therefore,

callthedepreciationsimulationreport(=>programRASIMU02)foryour

companycodeAA## andclass3100, anddisplaythevaluesup toDec31

CY+2..

2. Inthereport,canyoufindyourcompanycarfromtask1ofthisexercise

blockandtheannualdepreciationamountthatyoudiscoveredthere?

3. What would you do if you wanted to display the monthly depreciation

amountsofthecurrentyear,ratherthantheannual,planneddepreciation

amounts, using program RASIMU?

4. You now want to display the depreciation with alternativedepreciation

termsforseveralassets. Which“object”doyouneedtouse?

Task 3:

Optional:Optional: Simulate your (complete) asset class 3100 (again) up to

CY+2,butthistime,notwiththedepreciationdefaultvaluefromtheassetclass

LINR but with depreciation keyDG30 instead.

Hint: Ofcourse,depreciationDG30iscurrentlynot(nolonger)allowed

inGermany(atthemoment)... butthisisonlyaboutunderstandingthe

logic of the simulation versions.

1. Todothis, firstcreateasimulationversion##(=>##=groupnumber),

whichreflectstheabovescenario,atleastfordepreciationareas01and

02. Achangetotheplannedusefullifeisnotexpected.

2. Nowstart RASIMU02 for your company codeAA## and class 3100, and

display the values up toDec 31 CY+2.

However, also use your new simulation version ##.What you do you

notice,ifyoulookatthevaluesforthecompanycarassetfrompreceding

exercises?

Answer: No values are simulated.

Question: Why is that?

Go (back) to the selection screen of RASIMU02 and choose the All

Selections pushbutton.

ScrolldowntotheTreatmentofcapitalizationsincurrentfisc.yr(orders/WBS

elements) box/group frame.

Continued on next page

256

第 273 页 / 共 343 页

AC305 Lesson: Value Simulation

Here, you see that (all) asset values are simulated on January 01, CY.

However, at thispoint in time, thecompanycar in question hasnot been

capitalizedand,therefore,thereportdoesnotdisplayanyvaluesforthisasset.

SettheradiobuttonReducethebasisfordeprec. simulationofplaninv.

bycapitalization andstartRASIMU02 again.

Youshouldnowbeabletoseethe“alternativevalues”.

Forclarificationofthis,pleaseseeSAPnote333818–hereisanexcerpt:

Theuse of theasset valuesasat the fiscalyear start dateisto ensurethat

partsofplannedcapitalinvestmentswhichhavebeenrealizedalreadyarenot

countedtwice(onceasplanorbudgetvalueofaplannedcapitalinvestment

andonceasacapitalizationpostingtoanalreadyactivefixedasset). Ifyou

onlycarryoutadepreciationsimulationforactivefixedassets,settingthe

UseassetvaluesasofFYstartindicatorgenerallydoesnotmakesense(and

isthereforeignored by the program) and ...

Hint: As you can see from the note, the simulation report (=>

programRASIMU02)isnot relevant forAssetAccounting, but is

relevant for colleagueswhocarryout major investment measures

(=> usually in the IN component).

257

第 274 页 / 共 343 页

Unit5: InformationSystem AC305

Solution 14: Value Simulation

Task 1:

Complete the following tasks.

1. Post an acquisition to the last, unposted company car master record*.

Post a valueof € 50,000 on Jan 10 CY.

*Ifyoudonothaveanymoremasterrecordsthathavenotbeenpostedto,

simply create a new one in class 3100.

a) IntheAssetAccountingapplication,choosePosting→Acquisition→

ExternalAcquisition→Acquis. w/Autom. OffsettingEntry

Enter thedataasspecifiedin the exercise.

2. Whatisthequickestwaytolookatthechangesinvalueofthis(one)asset

for the next five years?

a) IntheAssetAccountingapplication,chooseAsset→AssetExplorer.

Choose the Comparisons tab page.

3. Howhighisthestraight-lineannualdepreciationamount?

Answer: 10.000,– €

4. Fortaxreasons,youareconsideringreducingtheusefullifeinarea01AND

area02from5to4years.. SimulatethischangeintheAssetExplorer.

a) IntheAssetExplorer,choosethe(Switchon)Simulationpushbutton.

Choose the Parameters tab page.

Overwritetheusefullifeof005(years)inarea01with004(years)and

then do the same in area 02.

Confirm your entries.

Choose the Planned values tab page.

5. Howhighwouldtheannualdepreciationamountbe?

Answer: 12.500,– €

Continued on next page

258

第 275 页 / 共 343 页

AC305 Lesson: Value Simulation

6. Simulate a subsequent acquisition of € 20,000 for the above asset Jun

30 CY.

a) IntheAssetExplorer,choosethePlannedValuestabpage.

IntheSimulationTransact. screenarea,chooseTrans. Simulation.

OntheSimulateAssetTransactionscreen,enterthefollowingvalues:

Field nameor data type Values

Documentdate,postingdateandassetvalue June 30, CY

date

Document type AA

Amount posted 20.000

Trans. type 100

Confirm your entries.

ChooseTransaction→Copy fromthemenu.

Task 2:

Complete the following tasks.

1. Youarenowinterestedinthefuture, annualchangesinvaluenotjustof

oneasset,butofmanyassets,forexample,awholeassetclass. Therefore,

callthedepreciationsimulationreport(=>programRASIMU02)foryour

companycodeAA##andclass3100, anddisplaythevaluesuptoDec31

CY+2..

a) IntheAssetAccounting application, chooseInformationSystem→

ReportsonAssetAccounting→DepreciationForecast→Depreciation

onCapitalizedAssets(DepreciationSimulation)

Enterthefollowingdataandexecutethereport:

Fieldnameordatatype Values

Company code AA##

Asset Class 3100

Report date December31, CY+2

2. Inthereport, canyoufindyourcompanycarfromtask1ofthisexercise

blockandtheannualdepreciationamountthatyoudiscoveredthere?

a) Solution: Ifyousimulatecorrectly,themasterrecordmust(ofcourse)

be displayed in this report as well.

Continued on next page

259

Field nameor data type	Values
Documentdate,postingdateandassetvalue date	June 30, CY
Document type	AA
Amount posted	20.000
Trans. type	100

Fieldnameordatatype	Values
Company code	AA##
Asset Class	3100
Report date	December31, CY+2

第 276 页 / 共 343 页

Unit5: InformationSystem AC305

3. What would you do if you wanted to display the monthly depreciation

amountsofthecurrentyear,ratherthantheannual,planneddepreciation

amounts, using program RASIMU?

a) Inthereportscreen,youhavetoselectadifferentevaluationperiod.

IntheAsset Accounting application, chooseInformation System→

ReportsonAssetAccounting→DepreciationForecast→Depreciation

onCapitalizedAssets(DepreciationSimulation).

EnterDecember 31, CYas thereport date.

ChooseEdit→AllSelectionsfromthemenu.

ScrolldowntotheEvaluationPeriodfieldgroup.

Choose the Month radio button.

Execute the report.

Note: If thereistoomuch information, youcan restrict the

selectionto asset class 3100 again.

4. You now want to display the depreciation with alternativedepreciation

termsforseveralassets. Which“object”doyouneedtouse?

a) Answer: Use a simulation version.

Continued on next page

260

第 277 页 / 共 343 页

AC305 Lesson: Value Simulation

Task 3:

Optional:Optional: Simulate your (complete) asset class 3100 (again) up to

CY+2,butthistime,notwiththedepreciationdefaultvaluefromtheassetclass

LINR but withdepreciation keyDG30 instead.

Hint: Ofcourse,depreciationDG30iscurrentlynot(nolonger)allowed

inGermany(atthemoment)... butthisisonlyaboutunderstandingthe

logic of the simulation versions.

1. Todothis,firstcreateasimulationversion##(=>##=groupnumber),

whichreflectstheabovescenario,atleastfordepreciationareas01and

02. Achangetotheplannedusefullifeisnotexpected.

a) IntheAssetAccounting application, chooseInformationSystem→

Tools → Simulation Versions

ChooseNewEntriesandcreatesimulationversion##.

Confirm your entries.

Select the new variant.

Inthedialogstructure,chooseSimulationRulesbydouble-clicking.

Choose New Entries.

Create a substitution rule (in table form) to reflect the scenario

described in the exercise.

2. Nowstart RASIMU02 for your company codeAA## and class3100, and

display the values up to Dec 31 CY+2.

However, also use your new simulation version ##.What you do you

notice,ifyoulookatthevaluesforthecompanycarassetfrompreceding

exercises?

Answer: No values are simulated.

Question: Why is that?

Go (back) to the selection screen of RASIMU02 and choose the All

Selections pushbutton.

ScrolldowntotheTreatmentofcapitalizationsincurrentfisc.yr(orders/WBS

elements) box/group frame.

Here, you see that (all) asset values are simulated on January 01, CY.

However, at thispoint in time, thecompanycar in question hasnot been

capitalizedand,therefore,thereportdoesnotdisplayanyvaluesforthisasset.

Continued on next page

261

第 278 页 / 共 343 页

Unit5: InformationSystem AC305

SettheradiobuttonReducethebasisfordeprec. simulationofplaninv.

bycapitalization and start RASIMU02again.

Youshouldnowbeabletoseethe“alternativevalues”.

Forclarificationofthis,pleaseseeSAPnote333818–hereisanexcerpt:

Theuseof theasset valuesasat thefiscalyearstart dateisto ensurethat

partsofplannedcapitalinvestmentswhichhavebeenrealizedalreadyarenot

countedtwice(onceasplanorbudgetvalueofaplannedcapitalinvestment

andonceasacapitalizationpostingtoanalreadyactivefixedasset). Ifyou

onlycarryoutadepreciationsimulationforactivefixedassets, settingthe

UseassetvaluesasofFYstartindicatorgenerallydoesnotmakesense(and

is thereforeignored bythe program) and ...

Hint: As you can see from the note, the simulation report (=>

program RASIMU02) isnot relevant for Asset Accounting, but is

relevantforcolleagueswhocarryoutmajorinvestmentmeasures

(=> usually in the IN component).

a) Solution: Refertotheexerciseforthesolution...

262

第 279 页 / 共 343 页

AC305 Lesson: Value Simulation

Lesson Summary

You should now be able to:

• ... Generateadepreciation(and/ortransaction)forecastforanassetfromthe

Asset Explorer

• ... Generate a depreciation forecast for various assets using program

RASIMU02

263

第 280 页 / 共 343 页

Unit5: InformationSystem AC305

Lesson: Asset History Sheet

Lesson Overview

Calling up and setting up an asset history sheet

Lesson Objectives

After completingthislesson, you will beable to:

• ... Execute the asset history sheet

• ... Understandthelayout of anassethistorysheet

• ... Configureyourownassethistorysheetifnecessary

Business Example

Asamandatorypartoftheyear-endclosing,youhavetopresentyourassetsin

anassethistorysheet. Bydefault,SAPsuppliesprogramRAGITT_ALV01forthat

purpose. The Asset Accounting department wants to know how this program

works.

Asset History Sheet

Figure 86: Structure of an Asset History Sheet

Theassethistorysheetisaveryimportantandcomprehensiveyear-endreport

or intermediate report.

Youcancreateitusingvarioussortversionsandtotalsatanygrouplevel,just

like any other report.

264

第 281 页 / 共 343 页

AC305 Lesson: Asset History Sheet

You can create a compact totals list that does not contain information on the

individual assets.

From thetotalsdisplay of theasset historysheet, you cancallthesheet for the

individualassets. YoucangototheAssetExplorerfromthere.

YoucanalsousetheRRI(=>reportreportinterface)tostartotherFI-AAreporting

programs.

SAP suppliescountry-specific(historysheet) versions. Thesemeet thelegal

requirementsinthegiven country. Youcanalsodefineyour own history sheet

versions:

• Size: Nomorethan 10 rowsand 8 columns

• Store theheadersof the history sheet items

• Definehowthevaluesaresuppliedtothehistorysheetitems

265

第 282 页 / 共 343 页

Unit5: InformationSystem AC305

266

第 283 页 / 共 343 页

AC305 Lesson: Asset History Sheet

Exercise 15: Asset History Sheet

Exercise Objectives

After completingthisexercise, youwillbeableto:

• ... Executeand interpret the asset history sheet

Business Example

Asamandatorypartoftheyear-endclosing,youhavetopresentyourassetsin

anassethistorysheet. Bydefault,SAPsuppliesprogramRAGITT_ALV01forthat

purpose. The Asset Accounting department wants to know how this program

works.

Task:

Complete the following task.

1. Requesttheassetsheethistory(=>programRAGITT_ALV01)and,using

sortvariant13andassethistorysheetversion0001,displayallassetsof

yourcompanycodeAA##,firstindividually,andthenasagrouptotal.

267

第 284 页 / 共 343 页

Unit5: InformationSystem AC305

Solution 15: Asset History Sheet

Task:

Complete the following task.

1. Requesttheassetsheethistory(=>programRAGITT_ALV01)and,using

sortvariant13andassethistorysheetversion0001,displayallassetsof

yourcompanycodeAA##,firstindividually,andthenasagrouptotal.

a) In the Asset Accounting application, select Information System →

Reports on Asset Accounting → Notes to Financial Statements →

International → Asset History Sheet.

Enter thedataasspecifiedin the exercise.

Double-clicktheaggregatedcompanycoderowtodisplaythesheet

for each asset.

268

第 285 页 / 共 343 页

AC305 Lesson: Asset History Sheet

Lesson Summary

You should now be able to:

• ... Execute the asset history sheet

• ... Understand thelayout of anassethistorysheet

• ... Configureyourownassethistorysheetifnecessary

269

第 286 页 / 共 343 页

UnitSummary AC305

Unit Summary

You should now be able to:

• ... ChooseandexecutethevariousAssetAccountingreports

• ... Setupvariablesortingandtotalingforassetreporting

• ... Generateadepreciation(and/ortransaction)forecastforanassetfromthe

Asset Explorer

• ... Generate a depreciation forecast for various assets using program

RASIMU02

• ... Execute the asset history sheet

• ... Understandthelayout of anassethistorysheet

• ... Configureyourownassethistorysheetifnecessary

270

第 287 页 / 共 343 页

第 288 页 / 共 343 页

第 289 页 / 共 343 页

Unit 6

Legacy Data Transfer

Unit Overview

The Legacy Data Transfer unit presents the possibilities and options for

transferring legacy data, differentiating between manual and automatic data

transfer,andpayingparticularattentiontotheitemsthatneedtobeconsideredin

preparing for the go live.

Unit Objectives

After completing thisunit, you will beableto:

• ... Enter legacy data manually

• ... Maketherequiredsettingsfortheautomatictransferoflegacydata

• ... Understand, when, how, and why reconciliation with Financial

Accounting is required.

• ... Check whether the system is configured correctly before the

implementation phase is completed.

• ... Workthroughato-dolistwithallthenecessarypreparations.

Unit Contents

Lesson: Legacy Data Transfer................................................272

Exercise 16: Legacy Data Transfer......................................283

Lesson: Preparations for Productive Operation.............................286

271

第 290 页 / 共 343 页

Unit6: LegacyDataTransfer AC305

Lesson: Legacy Data Transfer

Lesson Overview

This lesson will teach you about manual legacy data transfer and automatic

legacy data transfer.

Lesson Objectives

After completingthislesson, you will beable to:

• ... Enter legacy data manually

• ... Maketherequiredsettingsfortheautomatictransferoflegacydata

• ... Understand, when, how, and why reconciliation with Financial

Accounting is required.

Business Example

The legacy asset must beassigned toanasset class. Dependingon the time of

transferandotheroptionsthataredefined,valuesandpossiblyalsotransactions

mustbetransferredtothesystem. Whichvaluesandtransactionsaretransferred

dependsonthedateoftransferandonotheroptionsyouspecify.

AutomaticdatatransferisoftencarriedoutusingthetransferprogramRAALTD01.

Alternatives are (seldom used) program RAALTD11 or the (also seldom used)

transferusingMicrosoftExcel,orthe(nowcommon)transferusingaBAPI.

Figure 87: Legacy Data Transfer

272

第 291 页 / 共 343 页

AC305 Lesson: Legacy Data Transfer

Datatransferfromalegacysystemisusuallythefirstactivityyouneedtoperform

inanewproductionsystemafterconfigurationandassetclassification.

Youcaneithertransferdataautomaticallyfromalegacysystem, or(=>witha

smaller number of assets) youcan manually enter thedatausing atransaction

for legacy asset data.

Inadditiontothemanualtransaction(=>TCodeAS91),therearefourmethodsfor

transferring legacy data automatically:

1. Large quantity of legacy data: Batch input procedure (=> program

RAALTD01).

2. Very large quantity of legacy data: Direct data import (=> program

RAALTD11).

3. Largeto very large quantity of legacy data: Legacy datatransfer using a

BAPI interface.

4. Several hundred assets: Legacy datatransfer using Microsoft Excel (=>

TCode AS100).

NotethatinallcasesonlytherelevantassetmasterdataandlineitemsinAsset

Accounting are updated and not the general ledger accounts (in Financial

Accounting).

The balance reconciliation with the respective general ledger accounts must

therefore always take place in a separate step.

You start the legacy data transfer by setting thecompany code toLegacy data

transfernotyetcompletedstatus. Withthisstatusyoucantransferlegacydatain

FI-AA, but not post “normal” transactions.

273

第 292 页 / 共 343 页

Unit6: LegacyDataTransfer AC305

Figure 88: Legacy Data Transfer: Transfer Date

Youcantransferlegacydatafromalegacysystemforanydateinthepast. You

cannot createany legacydatain the SAPsystem beforethetransfer date. This

ensures that the data transferred from the legacy system is consistent on the

transfer date.

The transfer date can either be:

• ... Attheend ofthelast closed fiscal year, or

• Inthefiscalyearfollowingthelastclosedfiscalyear(=>duringtheyear)

What data can be transferred?

• Year-endtransferandtransferduringfiscalyear: Masterdata,historical

APC,accumulateddepreciationastheystoodatthelastclosedfiscalyear.

• Legacydatatransferduringfiscalyear: Includingdepreciationandasset

transactions postedduring the current year.

The transfer of the balances for FI (reconciliation) accounts always has to be

done separately.

Asset transactions occurring during the legacy data transfer must be posted

separatelyintheSAPsystemafterthelegacydatatransferhasbeencompleted.

274

第 293 页 / 共 343 页

AC305 Lesson: Legacy Data Transfer

Figure89: (Manual)LegacyData TransferatFiscalYearEnd

Ifthetransfertimeisattheendofthelastclosedfiscalyear,transferthemaster

data, the acquisition costs and production costs as well as the accumulated

depreciationastheystoodattheendofthelastclosedfiscalyear.

Transactions on line item managed AUCs are posted using special transaction

typesforlegacydata(=>transactiontypes900and910).

Thismethodensuresthatthelineitemsareidentifiedasacquisitionsfromprevious

years (=> prior-year acquisitions) even though the system sets the asset value

dates to January 1 of the current year.

LegacydatatransferdoesnotupdatethebalancesoftheG/Laccounts. Youmust

transfer the balances in a separate step as they stood at the time of the legacy

transfer (that is, at the end of the fiscal year).

GeneralLedgerAccountingusuallytakescareofthistask.

In order to verify the reconciliation, use the FI balance list (=> program

RFSSLD00) and appropriate FI-AA reports with the report date transfer date

+ 1 day.

Please note the following special considerations if you are using an already

productiveR/3FinancialAccountingsystem. Allbalancesheetandaccumulated

depreciationaccountsareup-to-dateinaproductiveSAPR/3FIsystem. Hence,

you do not need to transfer the G/L account balances, but a reconciliation is

required.

275

第 294 页 / 共 343 页

Unit6: LegacyDataTransfer AC305

Figure 90: Legacy Data TransferDuring Fiscal Year

Ifthetransferdataisaftertheendofthelastclosedfiscalyear,thisisreferredto

as transfer during fiscal year.

Inthiscase,youtransferthegeneralmasterdataandtheaccumulatedvaluesatthe

startofthefiscalyear. Youalsohavetotransferthetransactionsanddepreciation

posted during the current year.

Therearetwowaysoftransferringthedepreciationpostedduringthecurrentyear:

• Transfer the depreciation for the current year posted up to the time of

transfer. InCustomizingforAssetAccounting, youthenhavetoenterthe

last depreciation period posted (in the legacy system) before the time of

transfer for each depreciation area.

• If you do not want to transfer any posted depreciation, you can instead

executeanunplanneddepreciationpostingrunintheSAPsystemafterthe

datatransferforthecompletedepreciationforthecurrentfiscalyearupto

the time of transfer. In this case, the depreciation calculated by the SAP

system/FI-AAfor thisperiod would be posted.

Transactions: When performing a legacy data transfer during thefiscal year,

youcanalsoenterthetransactionsfromtheendofthelastclosedfiscalyearup

to the time of transfer.

Example: Asset acquisition of €10,000 in Year - 2 // useful life 10 years,

straight-linedepreciation€2,000//subsequentacquisitionincurrentyear€1,000

// allposteddepreciationfor thefirst 3months: €275.

276

第 295 页 / 共 343 页

AC305 Lesson: Legacy Data Transfer

Figure91: SetReconciliationAccounts,ifFI-AA(Only)is“Used”...

Set/reset reconciliationaccountsInthisstep, youdefinetheG/Laccountsfor

FI-AA as reconciliation accounts using a report. This program changes the

definitionsoftheG/Laccountmasterrecordthatareenteredinassetaccounting's

account determination.

Menu path: In Customizing for Asset Accounting, choose Preparing for

ProductionStartup→ProductionStartup→SetorResetReconciliationAccounts.

Youcan also reset thereconciliationaccounts if:

• ... YouhaveenteredanincorrectaccountintoanaccountallocationinAsset

Accounting.

• ... Balance corrections have to be posted to reconciliation accounts

retroactively.

Pleasekeepinmindthat,inthiscase,theconsistencybetweenFI-AAandthose

G/Lbalancesisnotensured,astheaccountscanbedirectlypostedagain.

As the company code has the status Legacy data transfer not yet completed,

youhavetobearinmindthatyoucanonlyposttransactionsintheSAPsystem

after thedateoftheactual transfer. Afterthisdateall assetaccountsand value

adjustmentaccountshavetobere-definedasreconciliationaccountsforFI-AA.

Theseaccountscanthereforenolongerbedirectlypostedtoafterthetransferdate.

277

第 296 页 / 共 343 页

Unit6: LegacyDataTransfer AC305

Figure 92: Transfer Balances

Thenextstepinpreparingfortheproductionstart-upistotransferthebalances

of the reconciliation accounts in the general ledger (see graphic Transferring

Legacy Data at Fiscal Year End).

YoualsohavetodothisifFIhaspreviouslybeenworkingwithanon-SAPsystem.

Youmusthavereconciledtheassetbalancesheetvaluesinassetaccountingwith

thebalancesoftheaffectedreconciliationaccounts. InAssetAccounting,youcan

use, for example, programRAABST02forthispurpose.

Program RABEST_ALV01 can also be useful: When you start this program,

specify the first dayof thecurrent fiscalyearasthereportdate. The system

will provide dataas of the last day of the previous fiscal year (that meansNO

depreciationfromthecurrentfiscalyearisincluded). ForthereconciliationinFI,

youcanthenusethebalancelist(=>programRFSSLD00).

You can then move the balances from any suspense accounts to the Asset

Accountingreconciliationaccounts, forexamplebychoosing: Customizingfor

Asset Accounting Preparing forProduction Startup→Production Startup →

Transfer Balances.

278

第 297 页 / 共 343 页

AC305 Lesson: Legacy Data Transfer

Figure 93: Transfer Parameters

Define theperiod fordepreciationposted (legacydatatransfer duringthe

fiscalyear): Inthiscase, youmustspecifytheperioduptowhichdepreciation

waspostedinthelegacysystem. Thisneedstobedoneforeverycompanycode.

This period is significant for the posted depreciation that is to be transferred

duringthelegacydatatransfer. The(new)SAPsystempostsdepreciationstarting

in the period after this period.

Note: As an alternative, you can execute an unplanned depreciation

postingrunandpostthetotaldepreciationaccumulatedsofartotheSAP

system.

Recalculation of accumulated depreciation: If you want to set up a new

depreciation area, you can calculate past depreciation using SAP/FI-AA

depreciationterms(=>thecompanycodehastobeintestoperation).

Calculation of replacement values/base insurable values: Thereplacement

valuesandbaseinsurablevaluesare(re-)calculated. Thisisdoneontheassumption

thattheacquisitionvaluewasacquiredcompletelyonthecapitalizationdate.

279

第 298 页 / 共 343 页

Unit6: LegacyDataTransfer AC305

Figure 94: Automatic Legacy Data Transfer

“”Convertthedataofyourlegacysystem(possiblyusingaprogramthatyouhave

written yourself or, of course, the Legacy System Migration Workbench [(=>

LSMW])andstructurethedataaccordingtotheFI-AAdatastructure.

ThisstructurecanbefoundintheDictionarytablesBALTD(=>masterdata)and

BALTB (=>transaction data).

YoumustuseyourinterfaceprogramortheLSMWtoformatthelegacydatafrom

thelegacysystemintheformofasequentialdatafile.

Using the Assets function in the Data Transfer Workbench, made available in

Release4.0,youcancheckthedatatobetransferredbeforetheactualtransferand

make any changes required.

Transfer program RAALTD01 supplies the data to a legacy data transfer

transaction,usingbackgroundprocessing. Recordsthatcontainerrorsarestored

intheformofabatchinputsession,andhavetobeprocessedlater.

The documentation for the transfer program RAALTD01 contains detailed

instructions about:

• ... Thestructure of thesequential transfer file

• ... Test options

• ... Avoidingerrorsandinterpretingerrorsthathaveoccurred

• Proceduresintheevent of program termination

280

第 299 页 / 共 343 页

AC305 Lesson: Legacy Data Transfer

Figure 95: Data Transfer Workbench: Assets

InDataTransferWorkbench: Assetsyoucanchecktheconvertedlegacydatafrom

thelegacysystem(intheSAPsystem)againandchangeitifnecessary.

TheDataTransferWorkbenchcanbeusedforAssetAccountingasofRelease4.0.

AsofSAPR/34.6,inordertoimportlegacyassets,youmustcreateacomplete

transfer project intheDataTransfer Workbench.

TransferprogramRAALTD01automaticallysuppliesthecorrectdatarecordsto

legacy data transaction AS91.

Records that contain errors are stored in a batch input session, and can be

processed later.

281

第 300 页 / 共 343 页

Unit6: LegacyDataTransfer AC305

282

第 301 页 / 共 343 页

AC305 Lesson: Legacy Data Transfer

Exercise 16: Legacy Data Transfer

Exercise Objectives

After completingthisexercise, youwillbeableto:

• ... Prepare a legacy data transfer

• ... Manuallytransferlegacydatafromalegacysystem

Business Example

You want to know how you can manually transfer your legacy assets from a

legacy system to the SAP system.

Task 1:

Complete the following task.

1. Inordertocarryoutalegacydatatransfer(eithermanuallyorautomatically),

youmustdefinealegacydatatransferdateforyourcompanycodeAA##.

SetthedatetoDecember31ofthelastclosedfiscalyear.

Task 2:

Complete the following task.

1. ManuallycreatealegacyassetinyourcompanycodeAA##.

Useassetclass3000. EnterJan19CY-3asthe(original)capitalizationdate.

You can enter any cumulated transfer values, but make sure that the

depreciationvaluesinarea01arenothigherthanthedepreciationvalues

in area 02 (with the same APC).

283

第 302 页 / 共 343 页

Unit6: LegacyDataTransfer AC305

Solution 16: Legacy Data Transfer

Task 1:

Complete the following task.

1. Inordertocarryoutalegacydatatransfer(eithermanuallyorautomatically),

youmustdefinealegacydatatransferdateforyourcompanycodeAA##.

SetthedatetoDecember31ofthelastclosedfiscalyear.

a) In Customizing for Asset Accounting, chooseAsset Data Transfer

→ ParametersforData Transfer →DateSpecifications→Specify

Transfer Date/Last Closed Fiscal Year.

Enter thedataasspecifiedin the exercise.

Task 2:

Complete the following task.

1. ManuallycreatealegacyassetinyourcompanycodeAA##.

Useassetclass3000. EnterJan19CY-3asthe(original)capitalizationdate.

You can enter any cumulated transfer values, but make sure that the

depreciationvaluesinarea01arenothigherthanthedepreciationvalues

in area 02 (with the same APC).

a) InCustomizingforAssetAccounting,chooseAssetDataTransfer→

ManualOnlineTransfer→Create/Change/DisplayLegacyAsset

IntheChooseActivitydialogbox,chooseCreateLegacyAsset.

Enter thedataasspecifiedin the exercise.

284

第 303 页 / 共 343 页

AC305 Lesson: Legacy Data Transfer

Lesson Summary

You should now be able to:

• ... Enter legacy data manually

• ... Maketherequiredsettingsfortheautomatictransferoflegacydata

• ... Understand, when, how, and why reconciliation with Financial

Accounting is required.

285

第 304 页 / 共 343 页

Unit6: LegacyDataTransfer AC305

Lesson: Preparations for Productive Operation

Lesson Overview

Inthislesson,youwilllearnhowtocheckthatyoursystemisproperlyconfigured

beforetransferringdata,resetcompanycodes,andresetposteddepreciation.

Lesson Objectives

After completingthislesson, you will beable to:

• ... Check whether the system is configured correctly before the

implementation phase is completed.

• ... Workthroughato-dolistwithallthenecessarypreparations.

Business Example

ItisextremelyimportantthattheFI-AAsystemisproperlyconfiguredbeforethe

datatransferiscompleted. Tothisend,youwanttocarryoutaconsistencycheck.

Figure96: PreparingforProductionStart-Up: Checkconsistency

Theconsistencycheckgivesyouasummarizedoverviewofthesystemsettings

youhavemade. Itprovidesalistofanyincorrectconfigurations.

Thisreportshouldbeusedtohighlightanysignificanterrorsintheconfiguration.

286

第 305 页 / 共 343 页

AC305 Lesson: Preparations for Productive Operation

Youcananalyzethesystemsettingsandprintthemoutasdocumentation. Youcan

usethefollowingoverviewreportstochecktheconsistencyofyousystemsettings:

• Charts of depreciation

• Company codes

• Depreciation areas

• Asset classes

You can also use a consistency report to check the reconciliation accounts for

Asset Accounting. A list is created showing the account allocations and the

correspondinggeneralledgeraccounts. Thereportprovidesacommentforany

allocations that are incorrect.

A consistency report for FI-AA Customizing is also available to check the

plausibility of your system settings.

After you have checked theconsistency of the configuration settings, you can

begin production start-up.

Figure 97: Reset Company Code

Reset company code: You can delete test application data (=> asset master

records,transactions,anddepreciation)foreachcompanycode.

Whenthecompanycodedataisreset,configurationdataisnotreset.

Conditions:

• TheresetisonlyallowedwhilethecompanycodeinFI-AAhasteststatus.

• ThecompanycodeinFImustnotbeusedinproduction.

287

第 306 页 / 共 343 页

Unit6: LegacyDataTransfer AC305

Resetposteddepreciation:Youcanreset theposteddepreciationinFI-AAfor

eachcompanycode(=>thedatafromallpostingrunsisdeletedforthecompany

code).

Inaddition,thistransactionresetsthedepreciationdataofalegacydatatransfer

duringthefiscalyear. Thedatathereforehastobetransferredagain.

Onlycompanycodesintestmodecanbereset. Aresetofthedepreciationdata

will be recorded in the system log.

Figure 98: Before the Go-Live: Overview forExperts

TheOverviewforExpertsdoesnotcontainanyadditionalfunctions.

It provides a detailed summary of the settings made at another point in the

implementationguide,sortedbyobjectsoractivities(forexample,depreciation

areas, asset classes, company codes,...).

Thisenablesyoutocheckexistingconfigurationsoptimally.

SAPcallsthisCustomizingnodethatwasaddedwithRelease4.6“Overviewfor

Experts”toindicatethatonlyadvanceduserscanuseitinameaningfulway.

288