AC660_EN_Col51_FV_Inst_A4 (第3页) | ERP软件技术分享

第 75 页 / 共 529 页

AC660 Lesson: Consolidation Chart of Accounts

sub-assignmentyouwantrepresented(forexample,thevalue“functionalarea”).

Using the breakdown category, youassign thisvalueto theitemsto be broken

downbythesub-assignment.Theactualvaluesforthesub-assignment(forexample

thevariousfunctionalareas)arethenstoredintheindependentcharacteristic.

Default Values

For every sub-assignment that you add, you can decide whether you want to

maintain default values.

On one hand these default values can make entry and posting easier: In the

breakdown category you can specify that the default value is written to a

sub-assignment,ifnovalueisenteredforthischaracteristic.

Ontheotherhandthedefaultvaluescanalsobeusedinautomaticposting. Iffor

exampleinadifferentialitem, thevalueofasub-assignmentcannotbederived

fromanotherdocumentlineitem,thenthedefaultvaluecanbeupdated. Youcan

defineadefaultvalueforeveryindependentcharacteristic.

Fordependentcharacteristicsofacompound,youcanenteradefaultvalueforthe

dependentcharacteristicforeveryvalueoftheindependentcharacteristic.

Note: Forthepartnerunit,thatpreviouslytheconsolidationunit99...99

(numberofplacesequalsthelengthoftheconsolidationunit)wasusedas

the system default.

Characteristic Maintenance

You define new subasssignments in Characteristic Maintenance. There you

can refer to existing entities, by entering the data element belonging to it, the

domainoranexistingcharacteristic. Oryoucancreatecompletelynewentities

withtheirownchecktableorwithoutachecktable. Thecharacteristicsmustbe

alphanumeric(CHAR)ornumeric(NUMC);theycanbeanylength.

You enter the following attributes:

• The compound of characteristics

• Whetherthefixedvalueisenteredinthebreakdowncategory

• Whetheryouwanttomaintainthedefaultvalueforthecharacteristic

• The display attributesin drilldown reporting

If you create a new entity, then the complete environment (Data Dictionary,

programs, maintenanceinterface)isgeneratedbythesystem. Noprogramming

is necessary.

YoualsocreateattributesinCharacteristicMaintenance.

第 76 页 / 共 529 页

Unit2: MasterData AC660

You can extend the master data of the consolidation unit to include as many

user-defined attributesas youwant. These attributescanthen be used insome

consolidation functionsand in reporting. The customattributeshavethesame

status as the standard attributes of the consolidation unit (country, company,

business area, controllingarea andprofit center).

Hierarchies

You can maintainhierarchies manually for everycustom characteristic. These

hierarchiescanbedisplayedinInteractiveExcelandindrilldownreporting. Itis

also possibleto uploadhierarchiesintothesystem.

Figure 21: Structuring Data - Characteristics

In the Consolidation database, SAP delivers a large number of predefined

characteristics. They are used for structuring your data, above all transaction

data. Forthatreasonthemostimportantcharacteristicsarethekeyfieldsinthe

transaction databases. If you require further sub-assignments, you can create

your own characteristics.

Asattributes,thecharacteristicscandescribetheconsolidationunitinmoredetail.

Youcancreatecharacteristicstobreakdownitems,whichstructurethetransaction

data. You can define your own characteristic hierarchiesand evaluatethem in

drilldownreporting/Excelreports. Forexample,youcanreproduceahierarchy

of products for the item net sales.

第 77 页 / 共 529 页

AC660 Lesson: Consolidation Chart of Accounts

Definition of custom characteristics:

• In the Consolidation database, you can add characteristics, which are

based on structures that already exist in the SAP system (for example,

region). Thenyoureceive alist of components, that let youmaintain the

characteristic values, and you can go to these IMG activities. For every

customsub-assignment,thatyoucreatewithanewvalidationtable,youcan

loadthevaluesintothesystembymeansofflexibleupload.

• Youcanadd characteristics, whosestructureshavetoberegenerated(for

exampletypeofcompany). ThesystemthengeneratesthenecessaryABAP

Dictionary objects and maintenance views.

Figure 22: Characteristic Consolidation Unit -Attributes

Youcanuseattributestodefineadditionalinformationabout theconsolidation

unit. This characteristic summarizes the consolidation units in reporting in

different groupings.

SAPdeliversthecharacteristicscountry, company,consolidationbusinessarea,

profit center and controllingarea asattributes for theconsolidationunit. They

are useful when you transfer the reported financial data of your integrated

consolidation units.

Youcan add navigation attributes to the characteristic consolidation unit. The

systemautomaticallyassignsthecharacteristicspartnerunitandinvesteeunitto

the attribute.

第 78 页 / 共 529 页

Unit2: MasterData AC660

Interunit elimination: You could restrict the values to be selected to certain

consolidationandpartnerunits. Forexamplewhenyoudivideyourconsolidation

un itsinto manufacturing companiesand financial institutions, then you could

restrict theelimination to a type of company, in order to study the elimination

differences separately.

Figure23: sub-assignments oftheFinancialStatementItem

Along with the standard sub-assignments you can define your own

sub-assignmentsascharacteristicsandassignanitem.

For every account assignment you can define a breakdown type within a

breakdown category. When a sub-assignment is missing, the breakdown type

determineswhetheradefaultvalueisset. Youcandefinedefaultvaluesforthe

followingcharacteristics: partnerunit,subitem,customcharacteristic,forwhich

youhavesetadefaultvaluewhendefiningtheindicator. Example: Enterwhich

defaultpartnerunitshouldbeset,whentheaccountassignmentinformationonthe

partnerunitismissing,forexamplewiththerealtimeupdateofreporteddata.

Compoundofcharacteristics: Aregion,forexample,canonlybemaintainedor

interpretedtogetherwithacountry’sdata. Insuchacaseyouwouldcreatetwo

customsub-assignmentsandassignthemtoeachother.

CustomcharacteristicsextendthedatabaseofConsolidation. SAPrecommends

thatyouactivateandgeneratethenewcharacteristics,whenyouhavecompleted

creatingthecharacteristics,andaresurethatyouwanttoworkwiththisdatabase.

In this way, you avoid time-consuming deletion actions. Note that deleting a

characteristicisnolongerpossible,whenyouhavealreadyposteddatawiththis

characteristic.

第 79 页 / 共 529 页

AC660 Lesson: Consolidation Chart of Accounts

Consolidation Database Structure

Structure of the Consolidation Database

Use the graphic to provide an overview.

Figure 24: Consolidation Database - Structure

ThesearethemostimportantfieldsintheConsolidationtotalsdatabase.

Thefirst5fieldsinblockAstorethebusinessunit whosedataiscollectedand

processed(dimension,consolidationunit),thecollectionperiod(year,accounting

period), the data category (version) and the consolidation group currency

(indirectly from the ledger field).

YoucanusemultipleledgersinSAPConsolidationtoachievegreaterflexibilityin

your use of group currencies.

The fields in blocks B1 and B2 store the consolidation chart of accounts, the

financialstatementitemandalladditionalaccountassignmentsthatcanoccurin

the data collected in SAP Consolidation. The fieldsDocument type and Cons

groupinblockCareonlyusedforpostingtransactionswithinConsolidation.

Thelast4fields(blockD)storeuptothreecurrencyamountsandaquantityfor

totalsrecords. Inaddition,thedatabasecontainsabalancecarriedforwardfield

and 16 period fields.

The totals database is flexible. You can add fields to the additional account

assignments (block B2) predefined by SAP.

第 80 页 / 共 529 页

Unit2: MasterData AC660

第 81 页 / 共 529 页

AC660 Lesson: Consolidation Chart of Accounts

Exercise 2: Exercises for Financial

Statement Chart of Accounts, Financial

Statement Items

Exercise Duration: 15 Minutes

Exercise Objectives

After completingthisexercise, youwillbeableto:

• UsefinancialstatementitemsandFSitemhierarchies

Business Example

Thegroup,G1,planstointroducetheSAPConsolidationbytheendofthisyear.

Corporate management wantsto prepareconsolidated financial statements for

December 2003 using the SAP system.

GroupG1,requiressupportfromexperiencedSAPconsultants. Themanagement

of your company creates a prototype for a presentation to be presented to the

steering committee of group, G1.

The competitors will be judged on the outcome of this presentation, and the

contractforimplementationofSAPConsolidationawardedaccordingly.

You have been asked by the management of your consulting firm to build a

prototypewithacolleaguewithinthenextfivedays. Structureofcorporategroup,

G1:

Task 1:

Masterdatafor theconsolidationchartof accounts:

1. Check the definition of the master data for chart of accounts XY (XY =

50 + your group number).

Task 2:

Changing item 311200:

1. Correct the totals item:

While checking the master record of the item Insurance Expense, you

discoveredthattheitemisnotdefinedasatotalsitem.

2. Creating value items:

Continued on next page

第 82 页 / 共 529 页

Unit2: MasterData AC660

Create the related value items, Building Insurance Expense and Other

Insurance Expenses.

Note: Findthisitembynavigatinginthehierarchy.

Task 3:

Maintaining financial statement (FS) items:

1. Whenpresentingyourprototype,youwilloutlinetheFSitemhierarchyand

thecontentofanFS itemmasterrecord(191500).

Explain the following termsusing theitem Machineryand Equipmentas

an example:

a). Breakdown category

b). Subitem category

c). Default subitem

d). Subitems

WhenyouexittheFSitemhierarchy, generatesets.

Theexampleincludesthefollowingselecteditemsusedforpostings:

a. Creation of automatic lineitems; for example, themodification of the

annualnetincomeiteminthebalancesheetandtheincomestatementwhen

financial statement imbalances occur.

b. Posting of deferred income taxes

Yourcolleaguewasnotawarethatthisfunctionexisted.

Task 4:

Define the following selected items:

1. Definethefollowingselecteditemsandexplainthematthesametime.

What you enter:

ANI, B/S item

FS Item Debit and Credit 251200

Sub Item Category 6

SubItem 120

ANI I/S Tab

FS Item 390000

Continued on next page

What you enter:
ANI, B/S item FS Item Debit and Credit Sub Item Category SubItem	251200 6 120
ANI I/S Tab FS Item	390000

第 83 页 / 共 529 页

AC660 Lesson: Consolidation Chart of Accounts

What you enter:

Def. Tax, B/S tab

FS Item Debit 150100

FS Item Credit 225100

Def. Tax, I/S tab

FS Item Debit & Credit 350100

Other items tab

FSBalancingadjustmentitem 239999

Item-debit andItem-credit 251100

Subitem category 6

Subitem 120

What you enter:
Def. Tax, B/S tab FS Item Debit FS Item Credit	150100 225100
Def. Tax, I/S tab FS Item Debit & Credit	350100
Other items tab FSBalancingadjustmentitem Item-debit andItem-credit Subitem category Subitem	239999 251100 6 120

第 84 页 / 共 529 页

Unit2: MasterData AC660

Solution 2: Exercises for Financial

Statement Chart of Accounts, Financial

Statement Items

Task 1:

Masterdatafor theconsolidationchart ofaccounts:

1. Check the definition of the master data for chart of accounts XY (XY =

50 + your group number).

a) Masterdatafortheconsolidationchartofaccounts:

Todisplayconschartofaccountsmasterdata,youchoose:

Menu Path: Tools→Customizing→IMG→ ExecuteProject→

SAP Reference IMG → Enterprise Controlling → Consolidation

→ Master Data → Financial Statement Items → User-Defined

consolidationChartofAccounts→MaintainItemHierarchiesfor

consChartofAccounts→EditItemHierarchies→Choose

Gotothechartofaccountsmasterdatabydouble-clickingonthechart

of accountsatthetopof thehierarchydisplay

EnterthedescriptionGroup##ChartofAccounts.

Save.

Youcanseethatyourchartofaccountsallowsforanoutputlengthof6

charactersforitsFSitems,andthatretainedearningsarerecordedin

thebalancesheet. SelectBacktoreturntothehierarchy.

Task 2:

Changing item 311200:

1. Correct the totals item:

While checking the master record of the item Insurance Expense, you

discoveredthattheitemisnotdefinedasatotalsitem.

2. Creating value items:

Continued on next page

第 85 页 / 共 529 页

AC660 Lesson: Consolidation Chart of Accounts

Create the related value items, Building Insurance Expense and Other

Insurance Expenses.

Note: Findthisitembynavigatinginthehierarchy.

a) Changing item 311200:

Intheitemhierarchy,youcangototheitem’smasterdatabyselecting

theincomestatementitemInsuranceExpense(311200).

MenuPath: NodeIS→NetIncome→NetIncomebeforeminority

interest → Income from continuing operations → Income before

taxes→OperatingIncome→Operatingexpenses

Double-click311200. OnAttributestab,insteadofFSitemtypeValue

item,chooseitemtypeTotalsitem,andsaveyourchange.

Execute the consistency check.

Leaveyourcursoronthetotalsitem311200andchooseCreate.

Enter the two new items, for example 311201 and 311202 with the

itemtexts: BuildingInsuranceExpenseandOtherInsuranceExpense,

respectively.

MaintainFSitemmasterdatafor311201and311202.

ChooseFS Item type: ValueItem, where-appliedindicator: Income

StatementItem,SignforEntry: Debit,BreakdownCat2000,functional

area.

Saveyourentries,executetheconsistencycheckandgeneratesets(by

choosingtheGeneratesetsicon)whenyouexitthehierarchy.

Task 3:

Maintaining financial statement (FS) items:

1. Whenpresentingyourprototype,youwilloutlinetheFSitemhierarchyand

thecontentofanFS itemmasterrecord(191500).

Explain thefollowing termsusingtheitemMachineryandEquipmentas

an example:

a). Breakdown category

b). Subitem category

c). Default subitem

d). Subitems

WhenyouexittheFSitemhierarchy,generatesets.

Continued on next page

第 86 页 / 共 529 页

Unit2: MasterData AC660

Theexampleincludesthefollowingselecteditemsusedforpostings:

a. Creation of automatic lineitems; for example, themodification of the

annualnetincomeiteminthebalancesheetandtheincomestatementwhen

financial statement imbalances occur.

b. Posting of deferred income taxes

Continued on next page

第 87 页 / 共 529 页

AC660 Lesson: Consolidation Chart of Accounts

Yourcolleaguewasnotawarethatthisfunctionexisted.

a) Maintaining financial statement(FS) items:

In the item hierarchy go to node BS:

MenuPath: BS→TotalAssets→TotalFixedAssets→Property,

Plant & Equipment, Net → Property, Plant & Equipment →

Machinery and Equipment (191500). Or

Edit → Find 191500

Thebreakdowncategory1000(transactiontype)hasbeenassignedto

theitemon theAttributestaband thebreakdowntype“3”(required

breakdown)hasbeenassignedtothesubitemonthesubassignmenttab.

ThesetofsubitemsCS01-1000hasbeenassigned.

1. The breakdown category classifies subassignments that are

required for performing consolidation tasks.The following

subassignments are supported

• Partner unit

• Transaction currency

• Year of acq, period of acq

• Subitem

• Customsubassignments

For each financial statement item, the breakdown category

determineswhichsubassignmentsmusteentered

2. Thesubitemscategoryenablesyoutoclassifyyoursubitems. A

subitemcategoryisassignedtoeachFSItem,thusallocatingall

of theassociated subitemsof thecategorytotheFS item. E.g.

you candefinesubitem categoriesfor

• Transaction types

• Product groups

• Divisions

The subitems are grouped into subitem categories in order to

distinguishbetweentransactiontypesinFixedAssetsfromthose

in Equity for example

3. Thedefaultsub-itemisusedwhennovaluehasbeenspecified

for the sub-assignment

4. Asub-itemisasub-assignmentofafinancialstatementitem,i.e.

thevalueassignedfortheparticulartransaction.

Continued on next page

第 88 页 / 共 529 页

Unit2: MasterData AC660

Task 4:

Define the following selected items:

1. Definethefollowingselecteditemsandexplainthematthesametime.

What you enter:

ANI, B/S item

FS Item Debit and Credit 251200

Sub Item Category 6

SubItem 120

ANI I/S Tab

FS Item 390000

Def. Tax, B/S tab

FS Item Debit 150100

FS Item Credit 225100

Def. Tax, I/S tab

FS Item Debit & Credit 350100

Other items tab

FSBalancingadjustmentitem 239999

Item-debitand Item-credit 251100

Subitem category 6

Subitem 120

a) Selected items for posting:

SelecteditemsaremaintainedinCustomizing.

Menu Path: Tools→Customizing→IMG→ ExecuteProject→

SAPReferenceIMG→EnterpriseControlling→Consolidation→

MasterData→Financialstatementitems→Specifyselecteditems

for posting

Iftherearenoselecteditemsspecifiedforyourexample,chooseNew

entries and enter selected itemsaslisted inthe Exercisessection of

this unit.

Otherwisereviewthattheselecteditemsarethesameasthoselistedin

theExercisessection. Checkthatallsubitemsareproperlyassigned.

SelectFSitemsareusedtocreateautomaticpostings.

What you enter:
ANI, B/S item FS Item Debit and Credit Sub Item Category SubItem	251200 6 120
ANI I/S Tab FS Item	390000
Def. Tax, B/S tab FS Item Debit FS Item Credit	150100 225100
Def. Tax, I/S tab FS Item Debit & Credit	350100
Other items tab FSBalancingadjustmentitem Item-debitand Item-credit Subitem category Subitem	239999 251100 6 120

第 89 页 / 共 529 页

AC660 Lesson: Consolidation Chart of Accounts

Lesson Summary

You should now be able to:

• Specifythepurposeanduseofconsolidationchartsofaccounts

• Describe the financial statements items

• Explain the breakdowncategoryand subitems

• Explainhowcharacteristicsstructurethetransactiondataofconsolidation

• Describe the function of user-definedattributes for providing additional

information about the consolidation unit

• Create customer-specific sub-assignments as custom characteristics and

assign an item

第 90 页 / 共 529 页

UnitSummary AC660

Unit Summary

You should now be able to:

• Explainhowglobalsessionparametersenableauser-friendlyenvironment

• DescribetheuseofhierarchicaldisplaysintheSAPConsolidationinterface

• ExplainthefunctionoflistprocessorintheConsolidationinterface

• State the role of the SAP standard functions and multilevel customizing

for a user-friendly interface

• Describethepurpose and useof Dimension

• Explain how dimension can be used

• Explainhowtoworkwithaledgerforaconsolidationgroup

• Evaluateandstatetheadvantageofusingaversionforconsolidation

• Describeaconsolidationunitandaconsolidationgroup

• Specifythepurposeanduseofconsolidationchartsofaccounts

• Describe the financial statements items

• Explain the breakdown categoryand subitems

• Explainhowcharacteristicsstructurethetransactiondataofconsolidation

• Describe the function of user-defined attributes for providing additional

information about the consolidation unit

• Create customer-specific sub-assignments as custom characteristics and

assign an item

第 91 页 / 共 529 页

AC660 Test Your Knowledge

Test Your Knowledge

1. GlobalparametersareimportantsettingsforSAPConsolidationthatremain

same for a work session.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

2. Whatarethefunctionsthatcanbeperformedwithhierarchies?

3. Whatarethemaincomponentsofthelistprocessor?

4. Whatisthefunctionofmulti-level customizing?

5. Dimensionsarespecificviewsongroupreporting.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

6. The master data created for the consolidation groups is valid only in the

relevant dimension.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

第 92 页 / 共 529 页

TestYourKnowledge AC660

7. Aconsolidationversioniscomposedofspecialversions.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

8. In adimension, hierarchiesare structured setsof consolidation units and

consolidation groups. With regard to the above statement, which of the

following is NOT correct?

Choosethecorrectanswer(s).

□ A Thetop-mostconsolidationgroupdefinesthehierarchies.

□ B Agivendimensioncannotrepresentmorethanoneconsolidation

type.

□ C Youcancreateanynumberofhierarchylevels.

□ D The number of hierarchy levelscan vary indifferentbranches

of the same hierarchy.

9. Namethe currenciesin which the datain theECMCT totalstable canbe

managed.

10. In the consolidation charts of accounts, all financial statement items are

arranged logically in an item hierarchy.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

11. TheFSitemtypeputsthe ofaniteminconcrete

terms,withregardtodataentry,postingandprocessinginevaluations.

Fillintheblankstocompletethesentence.

12. keepthenumberofitemsinconsolidation

chartsofaccountsdown toamanageablelevel.

Fillintheblankstocompletethesentence.

第 93 页 / 共 529 页

AC660 Test Your Knowledge

13. Howcancharacteristicsdescribetheconsolidationunitindetail?

14. Using characteristics,youcandefinefurthersub-assignments.

Fillintheblankstocompletethesentence.

15. It ispossible toadd attributesto thechararcteristic

consolidation unit.

Fillintheblankstocompletethesentence.

16. Customcharacteristicsextendthedatabaseofconsolidation.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

第 94 页 / 共 529 页

TestYourKnowledge AC660

Answers

1. GlobalparametersareimportantsettingsforSAPConsolidationthatremain

same for a work session.

Answer: True

Globalsessionparameterssavetheuser-specificsettingsforthedimension,

the version, the year, theperiod, the consolidation chart of accounts, and

the ledger during a system session.

2. Whatarethefunctionsthatcanbeperformedwithhierarchies?

Answer: Youcanperformmanyfunctionswithhierarchiessuchasmaintain

master data, startand monitor datacollectionandconsolidationfunctions

andgeneratereports. Manycomplexfunctionsalsousehierarchicaldisplays.

3. Whatarethemaincomponentsofthelistprocessor?

Answer: Expandandcollapsefunctions,filterfunctionandsearchfunction

aresomeofthecomponentfunctionsofthelistprocessor.

4. Whatisthefunctionofmulti-levelcustomizing?

Answer: Multi-levelcustomizingkeepsunneededfunctionsoutofsight.

5. Dimensionsarespecificviewsongroupreporting.

Answer: True

Inadimension,youdefinethegroupstructureasahierarchyofconsolidation

units and groups.

6. The master data created for the consolidation groups is valid only in the

relevant dimension.

Answer: True

Consolidation groups and consolidation units are dependent on the

dimension.

第 95 页 / 共 529 页

AC660 Test Your Knowledge

7. Aconsolidationversioniscomposedofspecialversions.

Answer: True

Special versions are methods and tasks that cover the various areas of

consolidation.

8. In a dimension, hierarchiesare structured sets of consolidation units and

consolidation groups. With regard to the above statement, which of the

following is NOT correct?

Answer: B

A given dimension can represent one or more consolidation types. As a

result,anyconsolidationunitorgroupcanexistinanynumberofhierarchies.

9. Name the currenciesin which thedata intheECMCT totalstable can be

managed.

Answer: The data in the ECMCT totals table can be managed in three

currenciessuchastransactioncurrency,currencyoftheconsolidationunit,

and ledger currency.

10. In the consolidation charts of accounts, all financial statement items are

arranged logically in an item hierarchy.

Answer: True

Theconsolidationchartsofaccountsstructurethefinancialstatementitems

inaccordancewiththeinternalandexternalrequirementsoftheconsolidated

financial statements.

11. TheFSitemtypeputsthecharacteristicsofaniteminconcreteterms,with

regardtodataentry,postingandprocessinginevaluations.

Answer: characteristics

12. sub-assignments keep the number of items in consolidation charts of

accounts down to a manageable level.

Answer: sub-assignments

第 96 页 / 共 529 页

TestYourKnowledge AC660

13. Howcancharacteristicsdescribetheconsolidationunitindetail?

Answer: Youcancreatecharacteristicstobreakdownitems,whichstructure

thetransactiondata. Alsoyoucandefineyourowncharacteristichierarchies

andevaluatethemindrilldownreporting/Excelreports.

14. Usingcustomcharacteristics,youcandefinefurthersub-assignments.

Answer: custom

15. Itispossibletoaddnavigationattributestothechararcteristicconsolidation

unit.

Answer: navigation

16. Customcharacteristicsextendthedatabaseofconsolidation.

Answer: True

Youcanactivateandgeneratenewcharacteristicsaftercompletingcreation

ofcharacteristicsandwhenyouaredefinitelygoingtoworkonthisdatabase.

第 97 页 / 共 529 页

Unit 3

Data Collection

Explain theimportant procedures for datacollection. Give an overviewof the

individualdatacollectionproceduresanddemonstratetheproceduresonlineentry,

offlineentry,andflexibleupload. Explaintheconceptofthemonitorandhowto

implementallthenecessarycustomizingsettings. Detailtherequiredsettingsfor

postingsandhowtogenerateapostingdocument. Alsodefinevalidationrules,

start validation, and interpret the error log.

Unit Overview

In this unit, you will learn about the important procedures for data collection.

You will get an overview of the individual data collection procedures and the

procedures online entry, offline entry, and flexible upload. In addition, you

will learn the concept of the monitor and how to implement all the necessary

customizingsettings. Youwilllearnabouttherequiredsettingsforpostingsand

howtogenerateapostingdocument. Youwillalsobeabletodefinevalidation

rules,startvalidation,andinterprettheerrorlog. Thefollowingpointsdetailhow

theunitfitsintotheoverallcontextofthecourse: Beforeconsolidationcantake

place,theindividualfinancialstatementsfromtheconsolidationunitshavetobe

collectedintheSAPsystem. Bothadjustmentandconsolidationentrieshavetobe

madeduringconsolidation. Toachievethis,thefollowingpreparationisrequired:

Selectedfinancialstatement itemshavetobedefined to performtheautomatic

postings. Documenttypeswiththeappropriatenumberrangeshavetobedefined

inthesystemtodifferentiatebetweentheindividualpostings. Thepostingsare

allocatedtodifferentpostinglevelstobeabletoevaluatetheoriginalindividual

FSvalues,adjustmententries,andconsolidationentriesatalltimes.

Unit Objectives

After completing thisunit, you will beableto:

• Explain the data collection methods from both SAP systems and the

non-SAP systems

• Use financial data in consolidation

• Describe the features of the status monitor

第 98 页 / 共 529 页

Unit3: DataCollection AC660

• Customize data monitor

• Assign tasks in the data monitor

• Describethe settings for onlinedataentry

• Define data entry layouts

• DescribeofflinedataentrywithMicrosoftAccess/Excel

• Explain flexible upload

• Explain the concept of validations

• Describe postings and document types

Unit Contents

Lesson: Overview of Data Collection..........................................89

Exercise 3: Exercise for Entering Data in Financial Tables............95

Lesson: Status Management..................................................100

Demonstration: Demonstration of the Customizing Data Monitor....108

Demonstration: Demonstration of the Data Monitor ...................108

Exercise 4: Data Monitor..................................................109

Lesson: Data Entry.............................................................118

Demonstration: Variable Scope of Report Data........................130

Demonstration: Online Data Entry with Flexible Layouts .............131

Demonstration: Online Data Entry and the Data Monitor.............131

Demonstration: Flexible Upload..........................................132

Exercise 5: Online Data Entry ............................................133

Exercise 6: Flexible Upload...............................................147

Lesson: Validation and Postings..............................................154

Demonstration: Demonstration: Formula Builder for Defining Rules

................................................................................158

Demonstration: Document Types ........................................168

Exercise 7: Validation......................................................169

Exercise 8: Posting.........................................................173

第 99 页 / 共 529 页

AC660 Lesson: Overview of Data Collection

Lesson: Overview of Data Collection

Lesson Duration: 20 Minutes

Lesson Overview

Thislessonprovidesanoverviewofthedatacollectionmethods. Youwilllearn

aboutthedatacollectionmethodsfrombothSAPsystemsandnon-SAPsystems.

Inaddition,youwilllearnhowtousefinancialdatainconsolidation.

Lesson Objectives

After completingthislesson, youwillbeable to:

• Explain the data collection methods from both SAP systems and the

non-SAP systems

• Use financial data in consolidation

Explain that the groupfinancial statementsarebasedon reporteddata andany

additionalfinancialdatafromtheinvolvedconsolidationunits.

Business Example

The group, G1, plans to introduce the SAP Consolidation by the end of this

year. You arerequired totransferthefinancial statementdataof theindividual

consolidationunitsintotheSAPsystembeforetheconsolidationcantakeplace.

第 100 页 / 共 529 页

Unit3: DataCollection AC660

Data Collection Methods

SAP Consolidation Data Collection Methods

1. Dataentrylayout: Youcan manuallyenterthevaluesfromtheindividual

financialstatementsintheSAPconsolidationsystem.

2. MS Access: Youcanenter andvalidatedatainMSAccess. Youcanthen

upload the validated data to SAP system.

3. Validation with automatic data collection You can transfer data from an

external system via MS Excel to MS Access, where it is validated and

collected in the SAP system.

4. MSExcel: YoucantransferthedatafromanupstreamsystemtoMSExcel

andtransferittoERPcentralcomponentwithoutvalidationwiththeflexible

upload function.

5. Interactive Excel: Integration of the SAP Consolidation and/or FI-LC

consolidationsystemwiththeMSExcelspreadsheetprogram. Youcanusea

specialinputmasktoenterthedatainMSExcelandupdatethedatadirectly

inR/3;InteractiveExceloffersdirectaccesstotheconsolidationdatafrom

within the PC application.

Thisdatacanbeprocessedfurtherwiththespreadsheetfunctions. Whenthe

consolidationdataischanged, theExcel tablesareupdatedautomatically.

However, changestotheExceltablesarenot automaticallytransferredto

the SAP R/3 System.

Inaddition,InteractiveExcelallowsaconsolidationunittorecorditsreportdata

locallyandoffline,inuser-definedmatricesinanMSAccessdatabase,andthen

forwardittothemainSAPR/3system,orenterthereportedfinancialdatadirectly

onlineandpassitontoR/3. YoucanuseaspecialinputmaskfordataentryinMS

Excel and update the data directly in R/3.

Hint: ThereisnodocumentcollectionfromR/2toR/3.

Alternative: periodic extract

SummarydatacanbetransferredfromR/2asof4.6C.

第 101 页 / 共 529 页

AC660 Lesson: Overview of Data Collection

Figure 25: Data Collection Methods

Data collection from SAP systems:

• Real-timeupdatefromotherapplicationcomponentswithinthesameSAP

system

• Rollup from an Special ledger

• Rollup from anotherConsolidationcomponent

• Periodic extract from Financial accounting

• Periodic extract from R/2

Data collection from non-SAP systems:

• Flexibleuploadofdataextractsfromnon-SAPsystems

• Microsoft Access offline data entry using an additional Microsoft Excel

interface

• Web access

第 102 页 / 共 529 页

Unit3: DataCollection AC660

Financial Data in Consolidation

The group financial statements are based on reported data and any additional

financialdatafromtheinvolvedconsolidationunits. Thisgraphicshowswhere

thedifferentconsolidation-relevant dataisstored.

1. Thetotalstable(ECMCT)storesthetotalsrecords(balancesheetandincome

statement)fromtheindividualfinancial statements.

2. Inordertoperformconsolidationstepsliketheconsolidationofinvestments

oreliminationofIUprofitandlossinthecurrentassets,moredataisrequired

thantheindividualfinancialstatementdata: theadditionalfinancialdata.

Additionalfinancialdatatablescontaindatathatisnotnecessarilyreported

in the individual financial statements, such as changes in investments,

changesininvesteeequity,changesingoodwill,changesinprofitability.

3. Document table ECMCA contains the journal entries that are generated

during the performance of consolidation tasks (such as consolidation of

investments).

These documents are stored in the document file (ECMCA) and can be

analyzed with the journal entry reports.

Thedocumentsthataregeneratedduringtheperformanceofconsolidationtasksis

alsosavedastotalsdataintotalsdatabaseECMCT,whereitcanbevalidatedwith

thereporteddatafromtheindividualfinancialstatement.

Hint:

• Thereportingtablesfortheadditionalfinancialdataaremaintained

manually or transferred through aflexibleupload. Alternatively,

youcandefineincustomizingthatsomeoftheadditionalfinancial

dataforconsolidationofinvestmentsshouldbetakendirectlyfrom

the totals database.

• Theadditionalfinancialdataissavedinitsowntables.

• Detailsofadditionalfinancialdata(changesininvestments,changes

ininvesteeequity,changesingoodwill,changesinprofitability)are

explainedintheconsolidationfunctionsunit,subject“consolidation

of investments”.

第 103 页 / 共 529 页

AC660 Lesson: Overview of Data Collection

Figure 26: Financial Data in Consolidation

ConsolidationwiththeSAPsystemisbasedontotalsdata. Thisdataisrecorded

usingvariousdatacollectionproceduresandisstoredinthetotalstableECMCT.

Additional financial data relevant for consolidation is also entered in separate

tables. Thisadditionaldataisnotnecessarilyreportedbyconsolidationunitsin

their individual financial statements.

Allpostingsmadeduringtheconsolidationprocessaresavedasdocumentsinthe

journal entry database ECMCA.

For this reason, the totals table ECMCT includes the following elements: All

datafromtheindividualfinancialstatements,changesoradditionstothisdataset

as a result of any additional financial data reported standardizing entries and

consolidation entries.

第 104 页 / 共 529 页

Unit3: DataCollection AC660

第 105 页 / 共 529 页

AC660 Lesson: Overview of Data Collection

Exercise 3: Exercise for Entering Data in

Financial Tables

Exercise Duration: 15 Minutes

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Enter data in the additional financial tables

Business Example

Your presentationexampleincludesaunitontheconsolidationof investments.

Therefore, you also need to collect additional financial data, which is used by

the consolidation task.

In practice, subsidiaries supply this information along with the other reported

financialstatementdata. Thisiswhyyoupopulatethesetablesinthecourseof

the data collection.

Twostepsarenecessarybeforeyoucancollecttheadditionalfinancialdataforthe

consolidation of investments:

Youneedtodefinethesystemutilizationfortheconsolidationofinvestments.

You must define the global settings.

Task 1:

Systemutilization of consolidation of investments:

1. Undersystemutilization,definetheconsolidationtypesthatweredecided

upon by the steering committee:

• Accounting technique:

- Almostalloftheconsolidationunitsareconsolidatedfully.

- TheexceptionisconsolidationunitE,anaffiliate,whichusesthe

equity method.

• Treatment of goodwill:

- Anypositiveornegativegoodwillresultingfromtheconsolidation

is to be amortized.

You do not have any further details, such as the amortization method, at

this point. These settings can be defined later in unit Consolidation of

Investments.

Continued on next page

第 106 页 / 共 529 页

Unit3: DataCollection AC660

Task 2:

Global settings:

1. At this point, you make a note in your presentation guide, that the IMG

settingsunderSpecifySystemUtilizationforC/Igreatlyaffectthescreen

contentsintheIMGstepMakeGlobalSettings.

Determinethefollowingglobalsettingsforyourexample, asagreedupon

with upper management:

Thedataconcerningchangesinequityaregatheredfromthetotalsdatabase

and the additional financial data.

EquityHoldingadjustmentsaregatheredfromadditionalfin_data.

Thecalculationbasearethestandardizedfinancialdata.

Pleaseassignthedocument typeto theTask.

第 107 页 / 共 529 页

AC660 Lesson: Overview of Data Collection

Solution 3: Exercise for Entering Data in

Financial Tables

Task 1:

Systemutilization of consolidation of investments:

1. Undersystemutilization,definetheconsolidationtypesthatweredecided

upon by the steering committee:

• Accounting technique:

- Almostalloftheconsolidationunitsareconsolidatedfully.

- TheexceptionisconsolidationunitE,anaffiliate,whichusesthe

equity method.

• Treatment of goodwill:

- Anypositiveornegativegoodwillresultingfromtheconsolidation

is to be amortized.

You do not have any further details, such as the amortization method, at

this point. These settings can be defined later in unit Consolidation of

Investments.

a) Systemutilizationofconsolidationofinvestments:

Define the system utilization at:

Menu Path: Tools→Customizing →IMG →Execute Project →

SAPReferenceIMG→EnterpriseControlling→Consolidation→

ConsolidationFunctions→AutomaticPosting→Consolidationof

Investments→DeterminesystemutilizationforC/I

SelectNewentries. Thedetailscreenappears.

UnderAccountingTechnique, select“purchasemethod”and“equity

method”.

Thetreatment of goodwill isdefinedin the FurtherSettingssection

of the screen.

Select the options Amortization of goodwill and Amortization of

negative goodwill.

Save your entries.

Continued on next page

第 108 页 / 共 529 页

Unit3: DataCollection AC660

Task 2:

Global settings:

1. At this point, you make a note in your presentation guide, that the IMG

settingsunderSpecifySystemUtilizationforC/Igreatlyaffectthescreen

contentsintheIMGstepMakeGlobalSettings.

Determinethefollowingglobalsettingsforyourexample, asagreedupon

with upper management:

Thedataconcerningchangesinequityaregatheredfromthetotalsdatabase

and the additional financial data.

EquityHoldingadjustmentsaregatheredfromadditionalfin_data.

Thecalculationbasearethestandardizedfinancialdata.

Pleaseassignthedocument typeto theTask.

a) To maintain the global settings, choose:

Menu Path: Tools→Customizing→IMG→ ExecuteProject→

SAPReferenceIMG→EnterpriseControlling→Consolidation→

ConsolidationFunctions→AutomaticPosting→Consolidationof

Investments → Make global settings

SelectNewentries. Thedetailscreenappears.

Save the change.

第 109 页 / 共 529 页

AC660 Lesson: Overview of Data Collection

Lesson Summary

You should now be able to:

• Explain the data collection methods from both SAP systems and the

non-SAP systems

• Use financial data in consolidation

第 110 页 / 共 529 页

Unit3: DataCollection AC660

Lesson: Status Management

Lesson Duration: 20 Minutes

Lesson Overview

This lesson provides an overview of the status monitor. You will learn how to

customizethedatamonitorandassigntaskstoataskgroup.

Lesson Objectives

After completingthislesson, you will beable to:

• Describethe featuresof the status monitor

• Customize data monitor

• Assign tasks in the data monitor

Explainthattheactivitiesfordatarecordingandperformingconsolidationsteps

inSAPConsolidationarestartedandtrackedinamonitor. Bringoutthatatask

groupisagroupofseveraltasks. Describehowthesystemspecifiesamandatory

sequence for performing the tasks.

Business Example

ThegroupG1planstointroducetheSAPConsolidationbytheendofthisyear.

Youarerequiredtomonitorthestatusoftheconsolidationprocessandexecute

tasks directly from within thestatus monitor.

Status Monitor

Explainthattheactivitiesfordatarecordingandperformingconsolidationstepsin

SAPConsolidationarestartedandtrackedinamonitor.

Thedataisprocessedandmonitoredhierarchicallyforeachconsolidationgroup

and unit.

The business activities for recording data and performing consolidation steps

are called tasks.

A task is comparable to an algorithm that is used to model the business

consolidation process in the system.

This program contains information on the consolidation steps that have to be

performed prior to thetask, andcontainsaconsolidation function, likeonefor

currency translation, for example.

100

第 111 页 / 共 529 页

AC660 Lesson: Status Management

The requirement for a precisely defined sequence of tasks guarantees that the

correct consolidation values can be determined. The sequence is defined by

defaultinthetasks,andcanalsobeconfiguredbytheuser.

The status of the tasks performed here isrepresented by icons at the different

levels of the hierarchy.

Youcanperformthetasksineitheratestrunorapostingrun.

Theoverallstatusofthetasksperformedindatarecordingandconsolidationis

represented by a traffic light.

In this example, the merged data recording and consolidation monitor are

displayed(theclearing task isaconsolidationtask).

Hint: System documentation:

Data monitor:

Thedatamonitorisusedforthefollowingpurposes:

• To check the transfer and formatting of the reported data of the

consolidation units in a dimension.

To ensure everything is calculated properly, the tasks have to be

performedinaspecificsequence. Forexample, thereporteddata

hastobevaluated beforefurther tasksthatarebasedonit canbe

performed. Youalsohavetomakesurethattasksarenotperformed

untiltheprecedingtaskshavebeenperformedcompletelyandfree

of errors.

Thischeckisperformedusingthestatusmanagementinthemonitor.

• Performing the tasks

All tasks can be performed through the monitor, either as a test

or posting run. The only requirement isthat the tasks haveto be

containedinthetaskgroupforthecorrespondingdimension.

Asanalternativetothemonitor, you canalsostarttheindividualtasks

through the task level menu.

System documentation:

Task:

Consolidationisperformedintheconsolidationsystemusingtasks.

Tasks represent the business view of the consolidation processing in

thesystem. Userscandefinedifferenttasksforthevariousprocessing,

dependingonthespecificbusinessactivitiesinvolved.

101