AC660_EN_Col51_FV_Part_A4 (第10页)

第 341 页 / 共 429 页

AC660 Lesson: Execution of Carry Forward

Field/Data Type Value

Min. Int. -Ret. Earn. -CurrentYear 241200

Min. Int. - Ret. Earn. - CY Prior to First 241300

Consolidation

241350

Min. Int. -Ret. Earn. -ANIPriortoProportion

Change 241400

Min. Int. -Ret. Earn. -AppropriationTransfers 241500

Min. Int. - Ret. Earn. - Appropriation 241600

Deductions

241620

Min. Int. -Ret. Earn. -DividendsPaid

241630

Min. Int. -Ret. Earn. -DividendsPaidClearing

241800

Min. Int. -Ret. Earn. -BonusManagement

Min. Int. -Ret. Earn. -Appropriations

Statistical items:

Usethesameprocedureforthestatisticalitems. Reviewthatthefollowing

entries exist.

TheseitemsarecarriedforwardtotheitemStat: RetainedEarnings-Prior

Years (951100).

Continued on next page

333

Field/Data Type	Value
Min. Int. -Ret. Earn. -CurrentYear Min. Int. - Ret. Earn. - CY Prior to First Consolidation Min. Int. -Ret. Earn. -ANIPriortoProportion Change Min. Int. -Ret. Earn. -AppropriationTransfers Min. Int. - Ret. Earn. - Appropriation Deductions Min. Int. -Ret. Earn. -DividendsPaid Min. Int. -Ret. Earn. -DividendsPaidClearing Min. Int. -Ret. Earn. -BonusManagement Min. Int. -Ret. Earn. -Appropriations	241200 241300 241350 241400 241500 241600 241620 241630 241800

第 342 页 / 共 429 页

Unit6: BalanceCarryForward AC660

Field/Data Type Value

Stat. - Ret. Earn. - Current Year 951200

Stat. -Ret. Earn. -CYPriortoFirstConsolidation 951300

Stat. -Ret. Earn. -ANIPriortoProportionChange 951350

Stat. -Ret. Earn. -AppropriationTransfers 951400

Stat. -Ret. Earn. -AppropriationDeductions 951500

Stat. -Ret. Earn. - DividendsPaid 951600

Stat. -Ret. Earn. -DividendsPaidClearing 951620

Stat. -Ret. Earn. –BonusManagement 951630

Stat. – Ret. Earn. – Consolidation of Investments 951700

Clearing

951800

Stat. - Ret. Earn. –Appropriations

Task 2:

Defining a task:

1. Define task CARRY FWD.

CopythetaskgroupDATAforthedatamonitortoDATA2“Datamonitor

with carry forward”.

AddthetaskCARRYFWDtothetaskgroupDATA2.

Finally,assignthetaskgroupDATA2toyourdimensionforthefiscalyear

2003/003, for the period category 3.

Task 3:

Modify global parameters

1. Change the global parameters to year 2003/003 and run a balance carry

forwardforconsgroupG1fromthedatamonitor.

UseadatabaselistingintheInfoSystemtocheckthat thecontentsofthe

totals database are correct.

Continued on next page

334

Field/Data Type	Value
Stat. - Ret. Earn. - Current Year Stat. -Ret. Earn. -CYPriortoFirstConsolidation Stat. -Ret. Earn. -ANIPriortoProportionChange Stat. -Ret. Earn. -AppropriationTransfers Stat. -Ret. Earn. -AppropriationDeductions Stat. -Ret. Earn. - DividendsPaid Stat. -Ret. Earn. -DividendsPaidClearing Stat. -Ret. Earn. –BonusManagement Stat. – Ret. Earn. – Consolidation of Investments Clearing Stat. - Ret. Earn. –Appropriations	951200 951300 951350 951400 951500 951600 951620 951630 951700 951800

Field/Data Type

Value

Stat. - Ret. Earn. - Current Year Stat. -Ret. Earn. -CYPriortoFirstConsolidation Stat. -Ret. Earn. -ANIPriortoProportionChange Stat. -Ret. Earn. -AppropriationTransfers Stat. -Ret. Earn. -AppropriationDeductions Stat. -Ret. Earn. - DividendsPaid Stat. -Ret. Earn. -DividendsPaidClearing Stat. -Ret. Earn. –BonusManagement Stat. – Ret. Earn. – Consolidation of Investments Clearing Stat. - Ret. Earn. –Appropriations

951200 951300 951350 951400 951500 951600 951620 951630 951700 951800

第 343 页 / 共 429 页

AC660 Lesson: Execution of Carry Forward

Then block the task.

Changetheparametersbackto year2002/012.

Task 4:

Carry forward

1. Adding missing items:

Youdeterminedthat an item for the appropriation of retained earnings is

missinginyour consolidationchartof accounts.

Createtheitem aswell astheotheritemsthat need to be assigned. Then

make the necessary settings in the IMG.

2. Entering further activities:

Settheglobalperiod/yearto003/2003,executethetaskDATAINPUT,and

enter additional activities:

Increase/Capitalization

Investment A B 170100 120 + 0% 400USD 400USD

Stock B 250100 120 500USD 500USD

Capital

Step Acquisition

Investment B C 170100 120 + 20% USD240 USD240

Partial Div.

Investment B C 170100 140 - 30% -465USD -465USD

3. Sorting activities:

Check and adjust the order of the activities:

Show the increase in capitalization for B prior to the amortization of

goodwill.

4. Assigningthetaskgrouptothedimension;executingthetask:

AssignthetaskgroupCONStoyourdimensionforthenewfiscalyear(003/

2003).

Intheconsolidationmonitor,executethetaskC/Iintestmodeandexamine

alloftheactivitiesfortheconsolidationgroupsG2andG1.

5. Resetting the parameters:

Changebacktheglobalperiod/fiscalyearto012/2002.

335

Increase/Capitalization
Investment	A	B	170100	120	+	0%	400USD	400USD
Stock Capital		B	250100	120			500USD	500USD

Step Acquisition
Investment	B	C	170100	120	+	20%	USD240	USD240

Partial Div.
Investment	B	C	170100	140	-	30%	-465USD	-465USD

第 344 页 / 共 429 页

Unit6: BalanceCarryForward AC660

Solution 16: Executing Carry Forward

Task 1:

Carry forward

1. Retained earnings items:

Specify/review that thefollowing retained earnings items are not carried

forwardontothemselves,buttotheitem251100RetainedEarnings-Prior

Years:

Field/Data Type Value

RetainedEarnings-CurrentYear 251200

Retained Earnings - CY Prior to First 251300

Consolidation

251350

Retained Earnings - ANI Prior to Proportion

Change 251400

RetainedEarnings-AppropriationTransfers 251500

RetainedEarnings-AppropriationDeductions 251600

RetainedEarnings-DividendsPaid 251620

RetainedEarnings-ClearingofDividendsPaid 251630

RetainedEarnings-BonusManagement 251700

RetainedEarnings-ClearingConsofInvestments 251800

RetainedEarnings-Appropriations

Minority interest items:

Use the same procedure for the minority interest items. Review that the

following entries exist. These items are carried forward to item 241100

Minorityinterest, retainedearnings–prioryears.

Continued on next page

336

Field/Data Type	Value
RetainedEarnings-CurrentYear Retained Earnings - CY Prior to First Consolidation Retained Earnings - ANI Prior to Proportion Change RetainedEarnings-AppropriationTransfers RetainedEarnings-AppropriationDeductions RetainedEarnings-DividendsPaid RetainedEarnings-ClearingofDividendsPaid RetainedEarnings-BonusManagement RetainedEarnings-ClearingConsofInvestments RetainedEarnings-Appropriations	251200 251300 251350 251400 251500 251600 251620 251630 251700 251800

第 345 页 / 共 429 页

AC660 Lesson: Execution of Carry Forward

Field/Data Type Value

Min. Int. -Ret. Earn. -CurrentYear 241200

Min. Int. - Ret. Earn. - CY Prior to First 241300

Consolidation

241350

Min. Int. -Ret. Earn. -ANIPriortoProportion

Change 241400

Min. Int. -Ret. Earn. -AppropriationTransfers 241500

Min. Int. - Ret. Earn. - Appropriation 241600

Deductions

241620

Min. Int. -Ret. Earn. -DividendsPaid

241630

Min. Int. -Ret. Earn. -DividendsPaidClearing

241800

Min. Int. -Ret. Earn. -BonusManagement

Min. Int. -Ret. Earn. -Appropriations

Statistical items:

Usethesameprocedureforthestatisticalitems. Reviewthatthefollowing

entries exist.

TheseitemsarecarriedforwardtotheitemStat: RetainedEarnings-Prior

Years (951100).

Continued on next page

337

Field/Data Type	Value
Min. Int. -Ret. Earn. -CurrentYear Min. Int. - Ret. Earn. - CY Prior to First Consolidation Min. Int. -Ret. Earn. -ANIPriortoProportion Change Min. Int. -Ret. Earn. -AppropriationTransfers Min. Int. - Ret. Earn. - Appropriation Deductions Min. Int. -Ret. Earn. -DividendsPaid Min. Int. -Ret. Earn. -DividendsPaidClearing Min. Int. -Ret. Earn. -BonusManagement Min. Int. -Ret. Earn. -Appropriations	241200 241300 241350 241400 241500 241600 241620 241630 241800

第 346 页 / 共 429 页

Unit6: BalanceCarryForward AC660

Field/Data Type Value

Stat. - Ret. Earn. - Current Year 951200

Stat. -Ret. Earn. -CYPriortoFirstConsolidation 951300

Stat. -Ret. Earn. -ANIPriortoProportionChange 951350

Stat. -Ret. Earn. -AppropriationTransfers 951400

Stat. -Ret. Earn. -AppropriationDeductions 951500

Stat. -Ret. Earn. - DividendsPaid 951600

Stat. -Ret. Earn. -DividendsPaidClearing 951620

Stat. -Ret. Earn. –BonusManagement 951630

Stat. – Ret. Earn. – Consolidation of Investments 951700

Clearing

951800

Stat. - Ret. Earn. –Appropriations

a) Items: Retainedearnings,MinorityInterestandStatistical

Thissolutioncoversexerciseallthequestionsinthestepstatement.

Menu Path:Tools: Accelerated SAP → Customizing → Exceute

Project → SAP Referenz IMG →Enterprise Controlling →

Consolidation → Data → Carrying forward Balances → Specify

FS Items to be Carried Forward

• Select New Entries

• Createanentryforeachitemtobecarriedforward. Theseentries

canbefoundintheexercisequestionabove. Ifentriesalready

exist, review that all required entries have been made in the

exercise

• Entereachitemastheitemintheoldfiscalyear,andmakethe

genericentry*forthesubitem, sothat allsubitemsarecarried

forward.

• Thedebitandcredititemsforthenewyearareidentical.

Continued on next page

338

Field/Data Type	Value
Stat. - Ret. Earn. - Current Year Stat. -Ret. Earn. -CYPriortoFirstConsolidation Stat. -Ret. Earn. -ANIPriortoProportionChange Stat. -Ret. Earn. -AppropriationTransfers Stat. -Ret. Earn. -AppropriationDeductions Stat. -Ret. Earn. - DividendsPaid Stat. -Ret. Earn. -DividendsPaidClearing Stat. -Ret. Earn. –BonusManagement Stat. – Ret. Earn. – Consolidation of Investments Clearing Stat. - Ret. Earn. –Appropriations	951200 951300 951350 951400 951500 951600 951620 951630 951700 951800

Field/Data Type

Value

951200 951300 951350 951400 951500 951600 951620 951630 951700 951800

第 347 页 / 共 429 页

AC660 Lesson: Execution of Carry Forward

• Enteritem251100inthefirstsection,item241100inthesection

minorityinterest items,and 951100 in sectionstatistical items.

Enter subitem 100 in all sections.

Save your entries.

Task 2:

Defining a task:

1. Define task CARRY FWD.

CopythetaskgroupDATAforthedatamonitortoDATA2“Datamonitor

with carry forward”.

AddthetaskCARRYFWDtothetaskgroupDATA2.

Continued on next page

339

第 348 页 / 共 429 页

Unit6: BalanceCarryForward AC660

Finally,assignthetaskgroupDATA2toyourdimensionforthefiscalyear

2003/003, for the period category 3.

a) DefinetaskCARRYFWDforcarryingforwardbalances.

MenuPath: Tools→AcceleratedSAP→Customizing→Execute

Project → SAP Reference IMG → Enterprise Controlling →

Consolidation→Data→Carryingforwardbalances→DefineTask

Select New Entries. Enter task name and texts. Task category is

Balance carry forward. Save.

SelecttaskgroupDATAandcopyitalongwithallsubentriestoDATA2.

MenuPath: Tools→AcceleratedSAP→Customizing→Execute

Project → SAP Reference IMG → Enterprise Controlling →

Consolidation→Data→DataMonitor→Definetaskgroup

Select task group DATA. Choose Copy as icon. Change name to

DATA2.

SelectCopyallwhenquestionedinthedialogbox.

Select task groupDATA2 and double-click theAssign tasks to task

group detail folder.

Then,addthetaskCARRYFWDasanewentry. Save.

Createanewentryforeffectiveyearcurrentyear+1,effectiveperiod

003,andperiodcategory3,andassigntaskgroupDATA2.

MenuPath: Tools→AcceleratedSAP→Customizing→Execute

Project → SAP Reference IMG → Enterprise Controlling →

Consolidation → Data →Data Monitor →Assign Task Group to

Dimension

SelectNewEntries. EnterFYeffect2003,Periodeff. 003,Periodcat.

3, Data mon. task group DATA2.

Save.

Task 3:

Modify global parameters

1. Change the global parameters to year 2003/003 and run a balance carry

forwardforconsgroupG1fromthedatamonitor.

UseadatabaselistingintheInfoSystemtocheckthat thecontentsofthe

totals database are correct.

Then block the task.

Continued on next page

340

第 349 页 / 共 429 页

AC660 Lesson: Execution of Carry Forward

Changetheparametersbackto year2002/012.

a) Global parameters:

MenuPath: Tools→AcceleratedSAP→Customizing→Execute

Project → SAP Reference IMG → Enterprise Controlling →

Consolidation →DefineGlobalParameters

Changethefiscalyearandtheperiodto2003,period003.

Runthebalancecarryforwardfromthedatamonitor(whichyouaccess

fromtheinitialConsolidationapplicationscreen). Putyourcursorat

theintersectionbetweengroupG1andthetask,andchooseUpdaterun.

MenuPath:Accounting→EnterpriseControlling→Consolidation

→ Data Collection → Monitor

ToReviewDatabaselistingofTotalsRecords: FromwithintheData

Monitor:

MenuPath:Goto→Databaselistingoftotalsrecords

Task 4:

Carry forward

1. Adding missing items:

Youdeterminedthat an item for the appropriation of retained earnings is

missinginyour consolidationchartof accounts.

Createtheitem aswell astheotheritemsthat need to be assigned. Then

make the necessary settings in the IMG.

a) Adding missing items:

MenuPath: Tools→AcceleratedSAP→Customizing→Execute

Project → SAP Reference IMG → Enterprise Controlling →

Consolidation→MasterData→FSItems→User-definedChartof

Accounts→MaintainHierarchiesofChartofAccounts→Edititem

Create the following items:

Continued on next page

341

第 350 页 / 共 429 页

Unit6: BalanceCarryForward AC660

Field/Data Type Value

withinstockholders’equity 250750Appropriations

FS item Value item

FS item type -

Debit/credit sign Liabilities/equity(B)

Where-applied indicator Breakdown 6000

categoryFS item

240750MinorityInterest

Breakdown category –Appropriations

FS item 6000

Where-applied indicator 950750 Stat.

Appropriations

Breakdown category

Statistical item

Carryforwardthenetbalance

6100

Check box

• Assign item 240750to item250750.

Menu Path: Tools → Accelerated SAP → Customizing

→ Execute Project → SAP Reference IMG → Enterprise

Controlling→Consolidation→ConsolidationFunctions→

AutomaticPostings→ConsolidationofInvestments→Selected

Items→SpecifyMinorityInterest Items

Inthiscase,noassignmentsneedtobemadetotheappropriation

itemsbecausetheretainedearningsarerecordedinthebalance

sheet.

• Assignstatisticalitem950750toitem250750.

Menu Path: Tools → Accelerated SAP → Customizing

→ Execute Project → SAP Reference IMG → Enterprise

Controlling→Consolidation→ConsolidationFunctions→

AutomaticPostings→Consolidationofinvestments→Selected

Items→DefineItemsforStatisticalEquityPostings

2. Entering further activities:

Continued on next page

342

Field/Data Type	Value
withinstockholders’equity FS item FS item type Debit/credit sign Where-applied indicator Breakdown categoryFS item Breakdown category FS item Where-applied indicator Breakdown category Carryforwardthenetbalance	250750Appropriations Value item - Liabilities/equity(B) 6000 240750MinorityInterest –Appropriations 6000 950750 Stat. Appropriations Statistical item 6100 Check box

第 351 页 / 共 429 页

AC660 Lesson: Execution of Carry Forward

Settheglobalperiod/yearto003/2003,executethetaskDATAINPUT,and

enter additional activities:

Increase/Capitalization

Investment A B 170100 120 + 0% 400USD 400USD

Stock B 250100 120 500USD 500USD

Capital

Step Acquisition

Investment B C 170100 120 + 20% USD240 USD240

Partial Div.

Investment B C 170100 140 - 30% -465USD -465USD

a) Entering further activities:

Change the global parameters and enter the activities in the data

monitor as described.

3. Sorting activities:

Check and adjust the order of the activities:

Show the increase in capitalization for B prior to the amortization of

goodwill.

a) Sorting activities:

Modifythesequenceoftheactivitiesasfollows:

1. In the additional financial data choose Activities for Investee

Units.

Menu Path: Accounting → Enterprise Controlling →

Consolidation→DataCollection→Additionalfinancialdata

→Enter→Activities: InvesteeUnits

2. Goto GlobalSequencein changemode.

3. Selectanincreaseincapitalization for B.

4. PlacethecursorattheactivityAmortizationofgoodwill.

5. Choose Move activities.

6. Save the sequence.

4. Assigningthetaskgrouptothedimension;executingthetask:

AssignthetaskgroupCONStoyourdimensionforthenewfiscalyear(003/

2003).

Continued on next page

343

Increase/Capitalization
Investment	A	B	170100	120	+	0%	400USD	400USD
Stock Capital		B	250100	120			500USD	500USD

Step Acquisition
Investment	B	C	170100	120	+	20%	USD240	USD240

Partial Div.
Investment	B	C	170100	140	-	30%	-465USD	-465USD

第 352 页 / 共 429 页

Unit6: BalanceCarryForward AC660

Intheconsolidationmonitor,executethetaskC/Iintestmodeandexamine

alloftheactivitiesfortheconsolidationgroupsG2andG1.

a) Assigningthetaskgrouptothedimension;executingthetask:

MenuPath: Tools→AcceleratedSAP→Customizing→Execute

Project → SAP Reference IMG → Enterprise Controlling →

Consolidation→ConsolidationFunctions→ConsolidationMonitor

→ Assign task group to dimension

Onceagain,assignthetaskgroupCONStoyourdimensionfor003/

current year + 1.

Youstarttheconsolidationofinvestmentsintheconsolidationmonitor.

5. Resetting the parameters:

Changebacktheglobalperiod/fiscalyearto012/2002.

a) Resetting the parameters:

Changebacktheglobalperiod/fiscalyearto012/2002.

344

第 353 页 / 共 429 页

AC660 Lesson: Execution of Carry Forward

Lesson Summary

You should now be able to:

• Statehowbalancecarry forward is executed

• Arrangethebalancecarryforwardanddefineselectedfinancialstatement

items

Related Information

•

345

第 354 页 / 共 429 页

Unit6: BalanceCarryForward AC660

Lesson: Appropriation of Carry Forward

Lesson Overview

The lesson covers how the appropriation of retained earnings in the balance

sheetrequirescustomizingsettingsforthesubitemsoftheretainedearningsthat

arecarriedforwardtodifferentfinancialstatementitemsthanthemselves. You

willlearnhowtoidentifytheprocedurestomanagetheappropriationofretained

earnings in the balance sheet and the income statement. In addition, you will

beabletodifferentiatebetweenthetwoprocedurestomanageappropriationof

retainedearningsinthebalancesheetandintheincomestatement.

Lesson Objectives

After completingthislesson, you will beable to:

• Identifytheprocedurestomanagetheappropriationofretainedearningsin

thebalancesheet andin theincomestatement

• Differentiatebetween the two proceduresto manage the appropriationof

retainedearningsinthebalancesheetandintheincomestatement

Business Example

Thegroup,G1,planstointroducetheSAPConsolidationbytheendofthisyear.

Youhavetocheckwhethertheappropriationofretainedearningsisreflectedin

thebalancesheetand,ifapplicable,carryforwardtheretainedearningssubitems

to theFS item, previousyear’sretained earnings.

Appropriation of Balance Sheet

Figure 120: Balance carryforward(Appropriationsin B/S)

346

第 355 页 / 共 429 页

AC660 Lesson: Appropriation of Carry Forward

Items: All appropriations items must be carried forward to the item,

Unappropriatedretainedearnings. Duetothefactthatbalancesheetitemscanonly

becarriedforwardtoidenticalitems,youneedtomakefurthersettingsinthiscase.

Using the menu option “Determine items to be carried forward”, maintain all

appropriations items and assign them to the item “Unappropriated retained

earnings”.

• Both the source and target items are balance sheet items. Notice that the

treatmentisdifferent. Thismeansthatthebalancesheetitemisnotcarried

forwardtoitself,butratheronlytothebalancesheetitemyouspecified.

• Incomestatementitemsarenotcarriedforwardbydefault.

Annualnetincomeinthebalancesheetandincomestatementmustbeidentical

bothbeforeandafterthecarryforward. Afterthecarryforward,thesumofallthe

income statement items must be zero.

Appropriation of Income Statement

Figure 121: Balance carryforward (Appropriationsin I/S)

Forsubsequentappropriationofretainedearningstotheincomestatement,you

also need to make certain settings for the items to be carried forward. In this

case, youassignanon-balancesheetitem, Unappropriatedretainedearningsin

I/S, to the balance sheet item, Retained earnings. This, in turn, meansthat the

balancesheetitemiscarriedforwardtothesameitem,(1),andadditionallytothe

assigned income statement item, (2).

Youmustalsomakeanassignmentintheincomestatementforthebalancesheet

retainedearnings. Thisisalsotobecarriedforwardtothesameitem,(3). This

ensuresthattheretainedearningsareidentical inthebalancesheetandincome

statement.

347

第 356 页 / 共 429 页

Unit6: BalanceCarryForward AC660

Lesson Summary

You should now be able to:

• Identifytheprocedurestomanagetheappropriationofretainedearningsin

thebalancesheet andin theincomestatement

• Differentiatebetween the two proceduresto manage the appropriationof

retainedearningsinthebalancesheetandintheincomestatement

348

第 357 页 / 共 429 页

AC660 Unit Summary

Unit Summary

You should now be able to:

• Statehowbalancecarry forward is executed

• Arrangethebalancecarryforwardanddefineselectedfinancialstatement

items

• Identifytheprocedurestomanagetheappropriationofretainedearningsin

the balancesheet and intheincome statement

• Differentiatebetween thetwo proceduresto managethe appropriation of

retainedearningsinthebalancesheetandintheincomestatement

349

第 358 页 / 共 429 页

UnitSummary AC660

350

第 359 页 / 共 429 页

AC660 Test Your Knowledge

Test Your Knowledge

1. Balancesheetitemsarenotcarriedforwardtothemselvesbydefault.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

2. How would you ensure that in a fixed-asset movement schedule, all the

current year’s transactions are carried forward to the subitem “Opening

balance”?

3. Howcanyouensurethatretainedearningsareidenticalinthebalancesheet

and in the income statement?

4. Whyisitrequiredtoassignanon-balancesheetitemtothebalancesheet

item “Retained earnings” for appropriation of retained earnings to the

income statement?

351

第 360 页 / 共 429 页

TestYourKnowledge AC660

Answers

1. Balancesheetitemsarenotcarriedforwardtothemselvesbydefault.

Answer: False

All balance sheet items are automatically carried forward to themselves

by default.

2. How would you ensure that in a fixed-asset movement schedule, all the

current year’s transactions are carried forward to the subitem “Opening

balance”?

Answer: Assigning a carry forward subitem to each subitem and then

making the carry forward in the next year ensures that in a fixed-asset

movementschedule,allthecurrentyear’stransactionsarecarriedforward

to the subitem “Opening balance”.

3. Howcanyouensurethatretainedearningsareidenticalinthebalancesheet

and in the income statement?

Answer: Youcanensurethatearningsareidenticalinthebalancesheetand

intheincomestatementbymakinganassignmentintheincomestatement

forbalancesheetretainedearningsandcarryingforwardthisassignmentto

the same time.

4. Whyisitrequiredtoassignanon-balancesheetitemtothebalancesheet

item “Retained earnings” for appropriation of retained earnings to the

income statement?

Answer: Theassignmentofanon-balancesheetitemtothebalancesheet

item“Retainedearnings”forappropriationofretainedearningstotheincome

statementmeansthatthebalancesheetitemiscarriedforwardtothesame

itemandadditionallytotheassignedincomestatementitem.

352

第 361 页 / 共 429 页

Unit 7

Information System

Unit Overview

This unit provides an overview of the different reporting options in SAP

Consolidation: Journalentryreports,Drilldownreporting,andInteractiveExcel

Unit Objectives

After completing thisunit, you will beableto:

• Call upandevaluatereportsfromtheSAP system

• Usejournalentrylayoutsforjournalentryreporting

• State the principles of drilldown reporting

• Describethe architectureof drilldownreporting

• Identify the types of drilldown reports

• Describehowreport execution iscarried out

• Design drilldownreportsin ahierarchy display

Unit Contents

Lesson: Reports for Consolidation ...........................................354

Exercise 17: Journal Entry Reporting....................................357

Lesson: Drilldown Reporting ..................................................363

Exercise 18: Drilldown Reporting ........................................377

353

第 362 页 / 共 429 页

Unit7: InformationSystem AC660

Lesson: Reports for Consolidation

Lesson Overview

ThislessonprovidesanoverviewoftheSAPreporting. Youwilllearnhowtocall

upandevaluatereportsfromtheSAPConsolidationreporttree. Inaddition,you

willlearnhowtousejournalentrylayoutstostructurethejournalentryreports

differently.

Lesson Objectives

After completingthislesson, you will beable to:

• CallupandevaluatereportsfromtheSAPsystem

• Usejournalentrylayoutsforjournalentryreporting

Business Example

ThegroupG1planstointroducetheSAPConsolidationbytheendofthisyear.

Youneedtochecktheconfiguration. Youhavetoanalyzetheconsolidateddata

bothinstandardreportsandinuser-defineddrilldownandReportPainterreports.

Tools for Reporting

Figure 122: Information System

354

第 363 页 / 共 429 页

AC660 Lesson: Reports for Consolidation

Report Writer and Report Painter:

• Easytouse,powerfulstandardSAPtoolstodesignreports

• Special treatment of the version and time-dependency of consolidation

groups

Interactive drilldowns:

• InteractivenavigationwithintheConsolidationdatacube

• Reportingofexceptions,ABCanalyses,comments,e-mail,andintegration

with Microsoft Office

Journal entry reports:

• Flexibleselectionandhierarchicaldisplaysofallconsolidationdocuments

• Master data

– ConsUnits, ConsGroups, where-used list

– FS items, subitems

• Control data

– Versions, tasks

– Data entry layouts, upload methods

– Currency translation

– Interunit elimination

– Consolidation of investments

– Reclassification

• Additional financial data

– - Stocks, deliveries, current assets

• Journal entry reporting

• Use of ABAP List Viewer

Thecross-applicationABAPListViewerisusedformasterandcontroldata

355

第 364 页 / 共 429 页

Unit7: InformationSystem AC660

Figure 123: Journal Entry Reporting

Withthehelpofjournalentrylayouts,youcanstructurethejournalentryreports

differently.

Youspecifythestructureofthereportinthelayout,asfollows:

• You determine the characteristics, such as the document type, document

number,financialstatementitem,andsubitem,accordingtohowthejournal

entriesshouldbeevaluated,andthesequenceinwhichtheyaretobelisted.

• Enter the currenciesor quantitythat areto be listed in the value columns

of the report.

356

第 365 页 / 共 429 页

AC660 Lesson: Reports for Consolidation

Exercise 17: Journal Entry Reporting

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Define a journal entry layout

Business Example

Youhavetodefineajournalentrylayoutandpresentittoyourmanagement.

Task:

1. Defining a layout:

In this part of your presentation, you define a journal entry layout

LXY-00001(XY=yourdimension)withthefollowingstructure:

Document number

Entry date

Time of entry

User name

Line item

Consolidation unit

FS item

Subitem

Partner unit

Value in local currency

Value in group currency

Specifythatyouwanttocalculatetotalsinthelineitemfield

Have the text of theitem be printed aswell

Startthejournalentryreportforyourconsolidationgroup,runthedrilldown,

and analyze the documents

2. Defining a further layout:

Define journal entry layout LXY-00002 (XY = your dimension) with a

different structure:

Document type, FS item, consolidation unit, partner unit, and value in

group currency.

Continued on next page

357

第 366 页 / 共 429 页

Unit7: InformationSystem AC660

TotalsshouldbecalculatedforconsolidationunitsandFSitems.

AtextshouldbedisplayedfordocumenttypesandFSitems.

358

第 367 页 / 共 429 页

AC660 Lesson: Reports for Consolidation

Solution 17: Journal Entry Reporting

Task:

1. Defining a layout:

In this part of your presentation, you define a journal entry layout

LXY-00001(XY=yourdimension)withthefollowingstructure:

Document number

Entry date

Time of entry

User name

Line item

Consolidation unit

FS item

Subitem

Partner unit

Value in local currency

Value in group currency

Specifythatyouwanttocalculatetotalsinthelineitemfield

Have the text of theitem be printed aswell

Startthejournalentryreportforyourconsolidationgroup,runthedrilldown,

and analyze the documents

a) Defining a layout:

SAPMenu→Tools→Customizing→IMG→ExecuteProject→

SAPReferenceIMG→EnterpriseControlling→Consolidation→

InformationSystem→DefineJournalEntryLayouts

Select new entries.

J/E Layout LXY-00001

Description Group ## Layout

Selectyourlayoutanddouble-clickonJournalEntryLayoutStructure.

Hint: Usethepossibleentriesfunction(F4functionkey)to

select thetechnicalnamesforthefields:

Continued on next page

359

第 368 页 / 共 429 页

Unit7: InformationSystem AC660

Forexample, chooseDOCNRdocumentnumber,specifythe

position1forthisfieldsothatthedocumentnumberislisted

first

ClickonNewentries. Enetrthefollowingfields

Field/Data Type Value

Layout LXY-00001

DOCNRdocumentnumber Position 1

CPUDT entry date Position 2

CPUTM timeof entry Position 3

USNAM user name Position 4

DOCLNLineitem;selectTotals Position 5

RBUNITconsolidationunit Position 6

RITEMFSitem,selectFld.text Position 7

SUBIT subitem Position 8

RBUPTR partnerunit Position 9

HSL local currency Position 10

KSL groupcurrency Position 11

Save your entries.

Startthejournalentrylayoutforyourconsolidationgroup:

SAPMenu→Accounting→EnterpriseControlling→Consolidation

→InformationSystem→Tools→Journalentries

Field/ Data Type Value

Dimension XY

Consolidation Group G1

Version 100

Continued on next page

360

Field/Data Type	Value
Layout DOCNRdocumentnumber CPUDT entry date CPUTM timeof entry USNAM user name DOCLNLineitem;selectTotals RBUNITconsolidationunit RITEMFSitem,selectFld.text SUBIT subitem RBUPTR partnerunit HSL local currency KSL groupcurrency	LXY-00001 Position 1 Position 2 Position 3 Position 4 Position 5 Position 6 Position 7 Position 8 Position 9 Position 10 Position 11

Field/ Data Type	Value
Dimension	XY
Consolidation Group	G1
Version	100

第 369 页 / 共 429 页

AC660 Lesson: Reports for Consolidation

Field/ Data Type Value

Fiscal Year Current Year

Period 12

Journal Entry Layout LXY-00001

Execute

2. Defining a further layout:

Define journal entry layout LXY-00002 (XY = your dimension) with a

different structure:

Document type, FS item, consolidation unit, partner unit, and value in

group currency.

TotalsshouldbecalculatedforconsolidationunitsandFSitems.

AtextshouldbedisplayedfordocumenttypesandFSitems.

Field/Data Type Value

DOCTYDocumenttype,selectFld.text Position 1

RITEMFSitem,selectTotalsandFld.text Position 2

RBUNITConsunit,selectTotals Position 3

RBUPTR partner unit Position 4

KSLValueingroupcurrency Position 5

Save your entries.

Analyzethechangeinannualnetincomeasaresultoftheelimination

of interunit payables and receivables.

Runthejournalentryreportandexpanddocumenttype21“Elim. ofIU

payables/receivables”Expanddocumenttype23.

PutyourcursorontheFSitem251200andseehowannualnetincome

haschanged for your consolidation units.

361

Field/ Data Type	Value
Fiscal Year	Current Year
Period	12
Journal Entry Layout	LXY-00001

Field/Data Type	Value
DOCTYDocumenttype,selectFld.text RITEMFSitem,selectTotalsandFld.text RBUNITConsunit,selectTotals RBUPTR partner unit KSLValueingroupcurrency	Position 1 Position 2 Position 3 Position 4 Position 5

第 370 页 / 共 429 页

Unit7: InformationSystem AC660

Lesson Summary

You should now be able to:

• CallupandevaluatereportsfromtheSAPsystem

• Usejournalentrylayoutsforjournalentryreporting

362

第 371 页 / 共 429 页

AC660 Lesson: Drilldown Reporting

Lesson: Drilldown Reporting

Lesson Overview

Thislessonwillprovideanoverviewofdrilldownreporting. Youwilllearnthe

architectureofdrilldownreportingandthetypesofdrilldownreports. Youwillsee

howthecharacteristicsspecifytheoptionstoclassifythedataset. Youwilllearn

aboutthethreetypesof formsusedtocreateformreports. Inadditionyouwill

examinehowtousethedifferenttypesofvariablestoconfigureformsandreports.

Further,youwilllearnaboutreportexecutionandexternalconsgrouphierarchies.

Lesson Objectives

After completingthislesson, youwillbeable to:

• State the principles of drilldown reporting

• Describethe architectureof drilldownreporting

• Identify the types of drilldown reports

• Describehowreport execution iscarried out

• Design drilldownreportsin ahierarchy display

Business Example

ThegroupG1planstointroducetheSAPConsolidationbytheendofthisyear.

You have been asked to define drilldown reports and project the data set in a

logical hierarchical format.

363

第 372 页 / 共 429 页

Unit7: InformationSystem AC660

Principles

Figure 124: The Principles of Drilldown Reporting

Characteristicsdeterminehowthedatasetisclassified. Consolidationunit,item,

andpostinglevelaresomeexamplesofcharacteristics. Noticethattimecategories,

suchasfiscalyearandperiod,arealsoregardedascharacteristicsinthiscontext.

Themasterdataincludesthepermitted valuesof acharacteristic, whichmeans

thecharacteristicvalues. Combinationsofcharacteristicsorcharacteristicvalues

areoftenreferred tointhedocumentationasobjects.

Iftherearethreecharacteristics,therelationshipbetweenthemcanbeshownusing

theabovefigure. Acubeiscreated. Thesidesrepresentthevariouscharacteristics,

such as consolidation unit, item, and posting level. Each characteristic is

subdividedintoseveralcharacteristicvalues. Theslicesrepresentcombinationsof

characteristicvalues. Onepossibleevaluationobjectmightbetheconsolidation

unit,Germany,itemSales,andthepostinglevelReporteddata.

There are many key figures in your application that might be relevant to the

evaluationprocess. The keyfiguresin SAP Consolidation arethevaluesfrom

transaction, local, and group currencies, and quantity calculations, based on

formulae that you have defined.

364

第 373 页 / 共 429 页

AC660 Lesson: Drilldown Reporting

Architecture

Figure 125: The Architecture of Drilldown Reporting

Asyoucanseeintheabovefigure,youcanincludecharacteristics,keyfigures,

and formsin your report definitions. The end result of a report isa number of

onlineaccessiblereportlistsandgraphicsthatappearonthescreen.

Drilldownreportingitselfcontainseasy-to-usefunctionstonavigatethroughthe

dataset. Forexample,thenextstep,thenextobjectwithinastep,hideastep,detail

list, andthedrilldownlist, arealleasytoperform. Italsocontainsanumberof

interactivereport-editingfunctions,suchastosortdata,defineconditions,orrank

lists. Youcanalsosendreportlists,suchasfax,orpostthemontheInternet,or

transfer them as a file to Word and Excel.

Inadditiontotheonlinereport-displayfunctions,therearevariousreport-printing

functionsin drilldownreportingthatenableyoutostructureyour report’sprint

layouttosuityourownrequirements. Forexample,youcaninsertpagebreaks,

headers and footers, or underline text.

365

第 374 页 / 共 429 页

Unit7: InformationSystem AC660

Aformdefinesthebasiccontentandtechnicaldesignofreportlistings. Aform

canbeseenasasemifinishedcomponentofareportthatwillbecompletedlater

withcharacteristicsandkeyfigureswhenthereportisdefined. Characteristicsare

apartofboththeformandthereportitself. Keyfigurescaneitherbeselectedin

the form or the report.

• Key figure: Value-carrying figure

• Amount figure, quantity figure

– “Revenue” (currency amount)

– “Number of employees” (quantity)

• Basic key figures

– Local currency

– Group currency

– Transaction currency

– Quantity

• Calculated key figures

Key figures are not only values and quantities, but also calculations based on

formulae that you have defined.

• Theydeterminehowthedataset(characteristics)isportrayed.

• Characteristic

– Non-value-carrying figure

– Classifies the dataset

• Types

– Time reference: fiscal year, period

– Version

– Organizationalunits: consunit,partnerunit,investeeunit,consgroup

– Accountassignment: Item, subitem, andsoon

– Custom characteristics

• Characteristic groups

– Combination of characteristics to improve overview of definitions

and call-ups

Examplesfor characteristicsare the SAPorganizational unitsand master data,

such as dimension, version, item, and subitem.

366

第 375 页 / 共 429 页

AC660 Lesson: Drilldown Reporting

Timereference,suchasfiscalyearorperiod,isalsoacharacteristic.

• Characteristic group:

When defining a report form, you can indicate a characteristic group on

the characteristic selection screen. This also narrowsdown the selection

of characteristics for the report definition. In this way, you can improve

the overview of the available characteristics with the customer-defined

characteristics.

Types

Types of Variable

Figure 126: Types of Drilldown Reports

Basicreports: Usersoftenchoosethisprocedurewhentheystartaspontaneous,

ad-hoc search for a business matter in the dataset, and they do not know

beforehand where and what they are searching for. It is relatively easy to set

up this type of report.

Formreports: Thesearemorecomplicatedtosetupandaremorespecific. This

procedureisoftenchosenforofficialreportingandisparticularlysuitedtoreport

printing.

A distinction is made between reports that are defined spontaneously, such as

basicreports,andreportsbasedonpredefinedformscalledformreports. Notice

thatformreportsarebasedonformswitheitheronecoordinateortwo,depending

on their complexity.

Aformis not required for a basic report. Whenyoudefine abasic report, you

select the characteristics you want to report on, and also the key figures and

variables of interest.

367

第 376 页 / 共 429 页

Unit7: InformationSystem AC660

Figure 127: Basic Reports

Youshouldchoosethebasicreportifyouarecarryingoutaspontaneous,ad-hoc

searchfornon-specificbusinessinformationinthedataset.

Thebasicreport’sstructureissimpleandfairlygeneral.

To define a basic report, enter the variables, such as dimension, cons group,

year, period, and version, and select the characteristics and key figures you

want to view.

Thefollowingcharacteristicsarepredefinedinad-hocreports: dimension,totals

consolidation group, version, and year.

Figure 128: Different Form Types

368

第 377 页 / 共 429 页

AC660 Lesson: Drilldown Reporting

The following types of forms are available:

• Single-axisformwithoutkeyfigures: Whenyoudefinesingle-axisforms

without keyfigures, youchoosethecharacteristicsyouwantand thenset

whether they should appear in the form as columns or rows. When you

usetheBasicscreenfunction, thefirstscreenyouseeisanemptylistthat

contains only columns.

• Single-axisformwithkeyfigures: Whenyoudefinesingle-axisformswith

keyfigures,youselectthecharacteristicsandkeyfiguresyouwantandthen

setwhethertheyshouldappearintheformincolumnsorrows. Whenyou

usetheBasicscreenfunction, thefirstscreenyouseeisanemptylistthat

contains only rows.

• Dual-axisformwithkeyfigures: Whenyoudefinedual-axisformswithkey

figures,youselectthekeyfiguresandcharacteristicsyouwantanddefine

therowsandcolumnswiththem. WhenyouusetheBasicscreenfunction,

thefirstscreenyouseeisanemptylistthatcontainsrowsandcolumns. You

choosewhethertodisplaythekeyfiguresincolumnsandthecharacteristics

inrowsorvice-versa. Whatyouselectdependsonwhatyouwanttoreport

on.

Whenyoucreateaform,youdetermineitsnameandtype.

• One axis with no key figure

– Columnsdefinedwithcharacteristicsonly

– Report: Further characteristicsandkeyfigures

– Example: Planned-actual comparison

• One axis with key figure

– Columnswithcharacteristicsandkeyfigures

– Report: Further characteristics

– Example: Planned-actualcomparisoningroupcurrency

• Dual axis form (matrix)

– Paralleldisplayofvaluesby2independentdimensions.

Forexample: Assethistorysheet(assetitemxsub-item)

– Complex cell formatting, as required

– Report: Further characteristics

Inaoneaxisformwithnokeyfigures,thecolumnsaredefinedwithcharacteristics

only. You can define further characteristics within the form, with the help of

a formula (for example deviation as the difference between the current year

andtheprior year). Theselected characteristicsin the formmakethecontents

of the columns more precise. The selection of key figures and drilldown

characteristic, that means the characteristics with whose characteristic values

you want to navigate in the report, are carried out in the report definition (for

369