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

第 82 页 / 共 429 页

Unit3: DataCollection AC660

Data collection from SAP systems:

• Real-timeupdatefromotherapplicationcomponentswithinthesameSAP

system

• Rollup from an Special ledger

• Rollupfrom another Consolidation component

• 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

Financial Data in Consolidation

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.

第 83 页 / 共 429 页

AC660 Lesson: Overview of Data Collection

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.

第 84 页 / 共 429 页

Unit3: DataCollection AC660

第 85 页 / 共 429 页

AC660 Lesson: Overview of Data Collection

Exercise 3: Exercise for Entering Data in

Financial Tables

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

第 86 页 / 共 429 页

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.

第 87 页 / 共 429 页

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

第 88 页 / 共 429 页

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.

第 89 页 / 共 429 页

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

第 90 页 / 共 429 页

Unit3: DataCollection AC660

Lesson: Status Management

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

Business Example

ThegroupG1planstointroducetheSAPConsolidationbytheendofthisyear.

Youarerequiredtomonitorthestatusoftheconsolidationprocessandexecute

tasks directly from within thestatus monitor.

Status Monitor

Figure 27: Status Monitor

The data monitor and the consolidation monitor control the status of the

consolidationprocess,andtaskscanbestarteddirectlyfromwithinthemonitor.

Eachmonitorcanaccommodateasmanytasksasrequired.

第 91 页 / 共 429 页

AC660 Lesson: Status Management

Tasks are user-defined. They are grouped into task groups, which carry

informationabouttheirsequence. Taskgroupsareassignedtodimensions.

Overallstatusof consolidation unitsand groups:

• Initial stage / open / error(s) / complete

Detailed status per task:

• Initial stage / incomplete / errors / error-free / provisional / blocked /

unblocked / irrelevant

• Date last changed/ user responsible for last change / number of errorsor

warnings

Taskscanberunintestorupdatemode. Theycanberunsuccessivelyuptothe

next milestone or without stop.

Period can be opened or closed.

Youcancallupthelastlogfortheselectedconsolidationgroupand/ortheselected

unit and the tasks. This function is only available for a task, when you have

activated log archiving in Customizing. Note that this new function does not

yet support all task categories.

Data Monitor

Figure 28: Customizing the Data Monitor

All tasks assigned to a task group must be executed for all the consolidation

units. Exceptionsaretasksformanualposting,datacollection,andthosethatyou

specify irrelevant for a unit.

第 92 页 / 共 429 页

Unit3: DataCollection AC660

Once you have started consolidation processing for a period, you should not

change the task groups that you are using.

Note: Thesystemregardsallmanualpostingtasksasmilestones

Group-dependent taskgroups: Whenyou assignagroup-dependent taskgroup

toaconsolidationgroup,thenthemonitoronlydisplaysthetasksoftherelevant

group-dependenttask groups. Normally sucha task groupdoesnot includeall

tasks,whichareassignedtotheglobal(dimensionlevel)taskgroup.

Note the following rules:

• Agroup-dependenttaskgroupmustalwaysbeapartialnumberoftheglobal

task number.

• Itmustalwaysstartwiththefirsttaskoftheglobaltaskgroup.

• Therecanbenogapsintheglobaltasksequence.

Figure 29: Sequence of Tasks in the Data Monitor

Ataskfor thevalidationof standardizedfinancial datamustbeincludedinthe

datamonitortaskgroup. Allothertasksareoptional.

Thefollowingtaskscanonlybeenteredonceinthetaskgroup,althoughtheyare

assignedtomorethanoneblock: Itemsubstitution/retainedearnings,Rollupto

consolidation groups.

The following tasks can also only be entered once in the task group: Balance

carry forward, Data collection, Validation of reported financial data, Currency

translation,Apportionment,Validationofstandardizeddata.

第 93 页 / 共 429 页

AC660 Lesson: Status Management

ThetasksManualpostingandReclassificationcanbeenteredseveraltimesinthe

taskgroup. Butthentheymustdifferentiatebytheassigneddocumenttype.

Statusmanagementalsoletsyouexecutecustomtasksatanypointintime. You

can insert customtasksintoany of these 7blocks.

第 94 页 / 共 429 页

Unit3: DataCollection AC660

第 95 页 / 共 429 页

AC660 Lesson: Status Management

Exercise 4: Data Monitor

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Define tasks and task groups

Business Example

Your presentationexampleincludesaunitontheconsolidationof investments.

For thisreason, you need to collect additional financial data, whichis used by

the consolidation task.

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

financialstatementdata. Thisiswhyyoupopulatethesetablesinthecourseof

the data collection.

You need to perform two steps before you can collect the additional financial

datafor theconsolidation of investments. First, you need todefine the system

utilizationfortheconsolidationofinvestments. Then,youmustdefinetheglobal

settings.

Task 1:

Global system settings

1. Define the following global system settings:

Activate statusmanagement to ensure that individual consolidation steps

are carried out in the correct order.

Tosimplifyyourpresentation,specifythatnewperiodsareopenbydefault.

Task 2:

Usethedatamonitorandtheconsolidationmonitortovisuallykeeptrackofthe

status of your various tasks.

Data monitor:

1. Runthe following tasksin thedata monitor:

Continued on next page

第 96 页 / 共 429 页

Unit3: DataCollection AC660

Task Task category Shorttext Mediumtxt

DATA Datacollection Dataentry OnlineDateEntry

INPUT

LOCAL Validation of reported ValidLC Validationinlocal

VAL Financial Data currency

GROUP Validation of ValidGC Validation in

VAL Standardized Financial groupcurrency

Data

CreatethetaskfordataentryandtwovalidationstepsintheImplementation

Guide (IMG).

AssignthemtothetaskgroupDATAwiththedescriptionDataMonitor.

Inthedefinitionofthetaskgroup,specifythatyouwantthevalidationtasks

tobeautomaticallyblockedaftercompletionwithouterrors.

Assignthetaskgrouptoyourdimensionusingtheperiodcategory2and3.

Task 3:

Entry of activitiesfor theadditional financialdata:

1. Entryofactivitiesfortheadditionalfinancialdata:

• ExecutetheDATAINPUTtaskforconsolidationgroupG1.

• Entertheactivitieslistedbelow, makinganoteofeachoftheactivity

numbersforthedifferentstepsinyourforthcomingpresentation.

Changes in Investments

A) First consolidation:

ConsIn- FS SubInc/Change Book Book

Unit vestee Item ItemDecinShare ValueLC Value

Unit GC

Invest- A B 170100 120 + 80 USD USD

ment 1000 1000

Capital B 250100 100 + USD USD

Stock 1000 1000

B) First consolidation:

Continued on next page

Task	Task category	Shorttext	Mediumtxt
DATA INPUT	Datacollection	Dataentry	OnlineDateEntry
LOCAL VAL	Validation of reported Financial Data	ValidLC	Validationinlocal currency
GROUP VAL	Validation of Standardized Financial Data	ValidGC	Validation in groupcurrency

	Con Unit	sIn- vestee Unit	FS Item	Sub Ite	Inc mDe	/Change cinShare	Book ValueLC	Book Value GC
Invest- ment	A	B	170100	120	+	80	USD 1000	USD 1000
Capital Stock		B	250100	100	+		USD 1000	USD 1000

第 97 页 / 共 429 页

AC660 Lesson: Status Management

ConsIn- FS Sub Inc/ Change Book Book

Unit vestee Item Item Dec inShare Value Value

Unit LC GC

Invest- A C 170100 120 + 16 USD USD

ment 260 260

Invest- B C 170100 120 + 60 USD USD

ment 1000 1000

Capital C 250100 100 + USD USD

Stock 1000 1000

C) First consolidation:

ConsIn- FS SubInc/ Change Book Book

Unit vestee Item ItemDecinShare ValueLC ValueGC

Unit

Invest- B D 170100120+ 75 USD USD1050

ment 1050

Capital D 250100100+ UNI USD1000

Stock 2500

D) First consolidation:

ConsIn- FS SubInc/ Change Book Book

Unit vestee Item ItemDecinShare ValueLC ValueGC

Unit

Invest- B E 170300120+ 40 USD800 USD800

ment

Capital E 250100100+ USD USD

Stock 1000 1000

	Con Unit	sIn- vestee Unit	FS Item	Sub Item	Inc/ Dec	Change inShare	Book Value LC	Book Value GC
Invest- ment	A	C	170100	120	+	16	USD 260	USD 260
Invest- ment	B	C	170100	120	+	60	USD 1000	USD 1000
Capital Stock		C	250100	100	+		USD 1000	USD 1000

	Con Unit	sIn- vestee Unit	FS Item	Su Ite	bInc mDec	/ Change inShare	Book ValueLC	Book ValueGC
Invest- ment	B	D	17010	012	0+	75	USD 1050	USD1050
Capital Stock		D	25010	010	0+		UNI 2500	USD1000

	Con Unit	sIn- vestee Unit	FS Item	Su Ite	bInc mDe	/ Change cinShare	Book ValueLC	Book ValueGC
Invest- ment	B	E	17030	012	0+	40	USD800	USD800
Capital Stock		E	25010	010	0+		USD 1000	USD 1000

第 98 页 / 共 429 页

Unit3: DataCollection AC660

Solution 4: Data Monitor

Task 1:

Global system settings

1. Definethe following global systemsettings:

Activate statusmanagement to ensurethat individual consolidation steps

are carried out in the correct order.

Tosimplifyyourpresentation,specifythatnewperiodsareopenbydefault.

a) Global system settings:

Tochangetheglobalsystemsettings,choose: MenuPath: Tools→

Customizing→IMG→ExecuteProject→SAPReferenceIMG→

EnterpriseControlling→Consolidation →Check Global System

Settings .

Select Status management activated.

Caution: DoNOTselectOpenperiodsexplicitly

Task 2:

Usethedatamonitorandtheconsolidationmonitortovisuallykeeptrackofthe

status of your various tasks.

Data monitor:

1. Run thefollowingtasksin thedata monitor:

Task Task category Shorttext Mediumtxt

DATA Datacollection Dataentry OnlineDateEntry

INPUT

LOCAL Validation of reported ValidLC Validationinlocal

VAL Financial Data currency

GROUP Validation of ValidGC Validation in

VAL Standardized Financial groupcurrency

Data

CreatethetaskfordataentryandtwovalidationstepsintheImplementation

Guide (IMG).

AssignthemtothetaskgroupDATAwiththedescriptionDataMonitor.

Inthedefinitionofthetaskgroup,specifythatyouwantthevalidationtasks

tobeautomaticallyblockedaftercompletionwithouterrors.

Continued on next page

Task	Task category	Shorttext	Mediumtxt
DATA INPUT	Datacollection	Dataentry	OnlineDateEntry
LOCAL VAL	Validation of reported Financial Data	ValidLC	Validationinlocal currency
GROUP VAL	Validation of Standardized Financial Data	ValidGC	Validation in groupcurrency

第 99 页 / 共 429 页

AC660 Lesson: Status Management

Assignthetaskgrouptoyourdimensionusingtheperiodcategory2and3.

a) Tasks:

TodefinethedatacollectiontaskDATAINPUT,choose:

Menu Path: Tools→Customizing→IMG→ExecuteProject→

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Data→ Data Collection→DefineTask

Choose New Entries. Enter task name, task category and texts as

listed in the table.

TodefinethevalidationtaskLOCALVAL,choose:

Menu Path: Tools→Customizing→IMG→ExecuteProject→

SAP Reference IMG → Enterprise Controlling→ Consolidation

→Data → Validationsfor Reported Data and Standardized Data

→ Define Task

Choose New Entries. Enter task name, task category and texts as

listed in the table.

Save your entry.

TodefinethevalidationtaskGROUPVAL,choose:

Menu Path: Tools→Customizing→IMG→ExecuteProject→

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Data→ValidationsforReportedDataandStandardizedReported

Data → Define Task

ChooseNewEntries. Entertaskname,taskcategoryandtextsaslisted

in Exercises section.

Save your entry.

To definethetask group DATA, choose:

Menu Path: Tools→Customizing→IMG→ExecuteProject→

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Data→DataMonitor→DefineTaskGroup

ChooseNewentries,andenterthenameDATAanddescriptionData

Monitor for the task group. Select the task group you just created

anddouble-clicktheAssigntaskstotaskgroupfolder. ChooseNew

Entriesandassign thetasksthat youhavedefinedto thistaskgroup

(withoutspecifyingprecedingtasks). Autoblockthevalidationtasks.

Save your entries.

Toassignthetaskgrouptoadimension, choose:

Continued on next page

第 100 页 / 共 429 页

Unit3: DataCollection AC660

MenuPath: Tools→Customizing→IMG→ExecuteProject→

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Data→DataMonitor→AssignTaskGrouptoDimension

Choose New Entries.

Field orData Type Value

FY effect current year

Period Effect 12

Period Cat. 2 and 3

Datamontaskgroup DATA

Save your entries.

Task 3:

Entry of activitiesfor theadditional financialdata:

1. Entryofactivitiesfortheadditionalfinancialdata:

• ExecutetheDATAINPUTtaskforconsolidationgroupG1.

• Entertheactivitieslistedbelow, makinganoteofeachoftheactivity

numbersforthedifferentstepsinyourforthcomingpresentation.

Changes in Investments

A) First consolidation:

ConsIn- FS SubInc/Change Book Book

Unit vestee Item ItemDecinShare ValueLC Value

Unit GC

Invest- A B 170100 120 + 80 USD USD

ment 1000 1000

Capital B 250100 100 + USD USD

Stock 1000 1000

B) First consolidation:

Continued on next page

Field orData Type	Value
FY effect	current year
Period Effect	12
Period Cat.	2 and 3
Datamontaskgroup	DATA

	Con Unit	sIn- vestee Unit	FS Item	Sub Ite	Inc mDe	/Change cinShare	Book ValueLC	Book Value GC
Invest- ment	A	B	170100	120	+	80	USD 1000	USD 1000
Capital Stock		B	250100	100	+		USD 1000	USD 1000

第 101 页 / 共 429 页

AC660 Lesson: Status Management

ConsIn- FS Sub Inc/ Change Book Book

Unit vestee Item Item Dec inShare Value Value

Unit LC GC

Invest- A C 170100 120 + 16 USD USD

ment 260 260

Invest- B C 170100 120 + 60 USD USD

ment 1000 1000

Capital C 250100 100 + USD USD

Stock 1000 1000

C) First consolidation:

ConsIn- FS SubInc/ Change Book Book

Unit vestee Item ItemDecinShare ValueLC ValueGC

Unit

Invest- B D 170100120+ 75 USD USD1050

ment 1050

Capital D 250100100+ UNI USD1000

Stock 2500

D) First consolidation:

Continued on next page

	Con Unit	sIn- vestee Unit	FS Item	Sub Item	Inc/ Dec	Change inShare	Book Value LC	Book Value GC
Invest- ment	A	C	170100	120	+	16	USD 260	USD 260
Invest- ment	B	C	170100	120	+	60	USD 1000	USD 1000
Capital Stock		C	250100	100	+		USD 1000	USD 1000

	Con Unit	sIn- vestee Unit	FS Item	Su Ite	bInc mDe	/ Change cinShare	Book ValueLC	Book ValueGC
Invest- ment	B	D	17010	012	0+	75	USD 1050	USD1050
Capital Stock		D	25010	010	0+		UNI 2500	USD1000

第 102 页 / 共 429 页

Unit3: DataCollection AC660

ConsIn- FS SubInc/ Change Book Book

Unit vestee Item ItemDecinShare ValueLC ValueGC

Unit

Invest- B E 170300120+ 40 USD800 USD800

ment

Capital E 250100100+ USD USD

Stock 1000 1000

a) Activity entry:

• Toentertheactivities,startthedatamonitorat:

Menu Path: Accounting → Enterprise controlling →

Consolidation→DataCollection→Monitor

In the hierarchy, place the cursor on the cross section for

consolidation group G1 and the data entry task. Then choose

Update run.

• Enterthelistedactivities,aslistedintheChangesinInvestments

tablebyselecting“ChangesinInvestments“undertheAdditional

financial data folder.

Doubleclicktoselecttherelevantconsolidationunitthendouble

click on first consolidation.

Inputtheinvesteeunitandthengotothedetailstabtoinputthe

rest of the data.

Writedowneachassignedactivitynumber.

• Save your entries.

	Con Unit	sIn- vestee Unit	FS Item	Su Ite	bInc mDec	/ Change inShare	Book ValueLC	Book ValueGC
Invest- ment	B	E	17030	012	0+	40	USD800	USD800
Capital Stock		E	25010	010	0+		USD 1000	USD 1000

第 103 页 / 共 429 页

AC660 Lesson: Status Management

Lesson Summary

You should now be able to:

• Describe the features of the status monitor

• Customize data monitor

• Assign tasks in the data monitor

第 104 页 / 共 429 页

Unit3: DataCollection AC660

Lesson: Data Entry

Lesson Overview

Thislessonprovidesanoverviewofonlinedataentryandofflinedataentrywith

MicrosoftAccess/Excel. Youwilllearnhowtousedataentrylayoutsforonline

data entry. In addition, you will learn the benefits of flexible upload for data

collection.

Lesson Objectives

After completingthislesson, you will beable to:

• Describethe settings for onlinedataentry

• Define data entry layouts

• DescribeofflinedataentrywithMicrosoftAccess/Excel

• Explain flexible upload

Business Example

Thegroup,G1,planstointroducetheSAPConsolidationbytheendofthisyear.

Youarerequiredtoprepareandcustomizetheelementsfordataentry.

Online Data Entry

Figure 30: Customizing Online Data Entry

第 105 页 / 共 429 页

AC660 Lesson: Data Entry

Figure 31: Settings for Online Data Entry

Companies in a group often have different requirements concerning reported

financial data. For this reason, you can formulate different rules for each

consolidation unit in the data entry version.

A data entry profile consists of the assignment of a data entry group to a

combination of special version for data entry, financial data type, and period

category. Thedataentryprofilevalidforaconsolidationunit/groupdetermines

the data entry layouts that can be used to enter its financial data. Data entry

groups,periodcategories,andfinancialdatatypesarevalidinalldimensionsand

versions. Dataentrylayoutsarevalidforaspecifiedchartofaccounts. Whenyou

startthedataentrytaskinthedatamonitor,onlylayoutscanbeusedfromthedata

entrygroupwhosechartofaccountsmatchesthatintheglobalparameters. You

canassignadataentrylayouttomorethanonedataentrygroup.

Intheperiodcategory,youspecifyalltheperiodsinthefiscalyearinwhichyou

enter the same category of financial data.

You use financial datatypes to categorize thedetail level of the financial data

reportedbyaunitandalsothecategoryofdatathatitreports. Forexample,you

couldassignonefinancialdatatypetounitsthat,duetotheirsizeandimportance,

enterhighlydetaileddatapossiblymorefrequently, andadifferentdatatypeto

units of less importance.

第 106 页 / 共 429 页

Unit3: DataCollection AC660

Figure 32: Variable Scope of Reported Data

The scope of data to be reported by each consolidation unit can be flexibly

defined. In the example above, company 1 must enter the balance sheet and

income statement data in the period 6. Conversely, company 2 only needs to

enter the income statement data.

ThefollowingCustomizingelementsdeterminethescopeofreporteddata:

• Dataentrygroups-Acollectionofanynumberofdataentrylayouts.

• Period category-Encompassesperiodsthatrequirethesameprocessing

in Consolidation.

• Financialdatatype-Indicatestheunitsthathavethesamerequirementsfor

reporting data.

• Afterdefiningtheabove, youspecifywhichconsolidationunitsbelongto

whichfinancialdatatype. Youalsospecifywhichdataentrygroupisvalid

forwhichcombinationoffinancialdatatypeandperiodcategory.

第 107 页 / 共 429 页

AC660 Lesson: Data Entry

Figure 33: Online Data Entry with Flexible Layouts

User-definabledataentrylayoutsareusedtoenterreportedfinancialdataonlinein

theSAPsystem. Theycanalsobeusedtoenterdataoffline. MicrosoftExcelcan

bestartedwithintheSAPGUIandservesasanentryscreenand/ordisplayscreen.

Eachlayoutcanhaveitsownuniquestructure. Youdefinetherowstructureand

specifythecurrenciesand/orquantityunitsofmeasurethatyouwanttoenter.

The rowstructure isnormally based on thefinancial statement itemsand their

breakdowns by partner unit, subitem, transaction currency, and/or year of

acquisition.

To display the comparison values from other versions, years or periods, you

can create value columns, which are not ready for input. You specify the

characteristics version, year or period in these columns, or you refer to other

variablesand/ortheglobalparameter. Asanalternativetothedefinitionoflead

columns, you can define individual rows. By doing this, you have additional

possibilitiestocreatelayoutstofurther meetyourindividualrequirements. For

example,bydefiningemptyrows,youcancreateadditionallayouts. Youcanuse

thecharacteristicsversion,yearorperiodinvaluecolumns,whicharereadyfor

input, toenter datavaluessimultaneouslyin severalversions, yearsorperiods.

Thestatusmanagementforthemonitorisreadcorrespondingly.

第 108 页 / 共 429 页

Unit3: DataCollection AC660

Figure 34: Definition of Data Entry Layouts

Data entry layouts are used to enter reported financial data online in an SAP

system or offlineina Microsoft Access database.

Thelayoutsthatyourequiredependonthelevelofdetailandthetypeofdatato

beentered. Forexample, youcouldusedifferentlayoutstoenterbalancesheet

data, income statement data, and quantities.

Youdefineadataentrylayoutforaparticularchartofaccounts.

The structure of a layout isflexible. You define the layout of therows, which

means a combination of characteristics and characteristic values in the lead

columns, such as FS items and their breakdown by partner unit, subitem,

transactioncurrency,oryearofacquisition. Youalsospecifythecurrenciesand/or

quantities that you want to enter.

Youcanenterbothcurrenciesandquantitiesinalayout.

100

第 109 页 / 共 429 页

AC660 Lesson: Data Entry

Offline Data Entry

Figure 35: Offline Data Entry with MSAccess /Excel

Youusethismethodifoneormoreunitsdonotuseanyintegration,butadminister

the reported financial data on PC. You can start the data collection both for a

single unit and for a group.

Youhavedefinedmasterdata,dataentrylayouts,andvalidationrulesintheSAP

system,whichyoucantransfertoMicrosoftAccesswiththemeansofadownload.

InAccess,youcandefinemoremasterdata,whichyoucanuploadintotheSAP

system. Further,inAccessyoucanenterdataandcarryoutavalidationcheck. In

addition,youcanexecuteacurrencytranslationalready.

WithInteractiveExcel,youhaveanotherpossibilityfordataentry. Itisincluded

inthestandardExcel asatemplate. WiththeuseofInteractiveExcel asadata

entrytoolfor an Accessdatabase, you have moreflexibilitythan intheoffline

dataentrydirectlyinAccess. Thisisbecausethestructureofadataentryform

is strictly specified in Access.

Theentereddataisloaded intotheAccessdatabase.

You can download data from the SAP system and the Access database into

Interactive Excel for report purposes.

101

第 110 页 / 共 429 页

Unit3: DataCollection AC660

Figure 36: Data Entry and Validation with MSAccess

Centraldefinitionanddownloadofcontrol parameters

• Data entry layouts

• Validation rules

ThedecentralizeddataentryinAccessiscontrolledwithdataentrylayouts. You

canchangetheconsolidationunitswithinthedataentrylayout.

Items:

• Youcandifferentiateimmediatelybetweentotalsitemsandvalueitems.

• The item breakdown by double-clicking on the amount field displays a

considerabledifferencetothelayoutsinthedatamonitor.

• Theitemlongtext canbedisplayedintheitem.

Decentralized validation in Access

• Start using consolidation unit or group

• Comparison of item values

102

第 111 页 / 共 429 页

AC660 Lesson: Data Entry

Flexible Upload

Figure 37: Flexible Upload

You use this method if one or more units does not use any integration, but

administerthereportedfinancialdataonPC.Youcanstartthedatacollectionboth

for a single unit and a group.

Reported data/standardizing entries:

Youcanstartthedatacollectiondirectlyinthedatamonitorwhenyousupplythe

masterdataoftheconsunitswiththefollowinginformation:

logical file name, server selection, uploadmethod

The system only transfers the data streams, which correspond to the global

parametersand refer to theunit to be edited. Other data streams of thefile are

not taken into account. You can upload standardizing entries. A document

is generated for each combination of ledger, consolidation chart of accounts,

dimension,version,period,andconsolidationunit. Theitembreakdowns,which

areuploaded,checkthebreakdowncategoriescorrespondingly.

Duringtheupload,youcanselectbetweendifferentupdatesessionstoensurethe

treatmentofdatastreamsthatalreadyexist. Withthis,youcanreportagainwith

thesession, Prorate, suchaspartnerspecificextensiveinformationtoFSitems,

after the correct totals are already available.

Flexibleuploadcanalsobeusedforfileuploadoforganizationalunits,FSitems,

andsub-assignments. Forexample,youcantransferproductgroupsfromafile.

103

第 112 页 / 共 429 页

Unit3: DataCollection AC660

104

第 113 页 / 共 429 页

AC660 Lesson: Data Entry

Exercise 5: Online Data Entry

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Definedataentrylayoutsandusethelayoutstocollectdata

Business Example

Task 1:

Financial data types:

1. Createafinancial data type for your example.

Name: A(for group 01) ... R(for group 18)

Assignthefinancialdatatypetotheconsolidationunits.

Task 2:

Layouts:

1. According to the steering committee, the consolidation unit A is entered

manually.

Thegrouprequiresdataentrylayouts,whichyoucreateasfollows:

a)LXY-0001Balancesheet(XY=50+yourgroupnumber)

Thebalancesheetlayoutcontainsalltherelevantbalancesheetitemswith

theircharacteristicvaluesanddescription,andalsothelocalcurrency.

b)LXY-0003Assethistorysheet(XY=50+yourgroupnumber)

The asset history sheet contains all the relevant asset items and the item

InvestmentsinSubsidiaries–Purchasewiththefollowing:

• item description

• breakdownby subitem(transaction type)

• partner unit in local currency

Observe the individual financial statement data reported by cons unit A

and decide the items you require.

c) Your colleague has already created the remaining layouts for testing,

using a different naming convention.

Continued on next page

105

第 114 页 / 共 429 页

Unit3: DataCollection AC660

Becauseyouwanttouseuniformlayoutnamingforthepresentation,copy

theselayoutsusingtheCopyfunctionandchangethelayoutnamesinthe

following way:

Template Your layout

L50-0002 A/P - A/R LXY-0002 .(XY = 50 + your

group number)

L50-0004ChangesinInvesteeEquity LXY-0004

L50-0005I/SwithFunctionalArea LXY-0005

L50-0006 Income From Invest. LXY-0006

Affiliates

L50-0007SalesbyRegion LXY-0007

Hint: Makesurethatyouchangethevaluesfortheconsolidation

chartofaccountsandthedimensionunderGeneralSelections.

You must make the dimension and chart of accounts

group-specific, andyoumaynotusevariables.

Individual financial statement data for A:

Version: 100, CurrentYear, Period: 12, Ledger: US

CU FS SubitePmart- Trans Trans LC GC Item

item nerCU Curcy Curcy text

Key

A 130100 B UNI 600 400 400 IC

Trade

Rec.

A 130100 B USD 200 200 200

A 130100 C UNI 500 300 300

A 130100 C USD 300 300 300

A 170100120 B USD 1000 1000 1000 In-

vest.

Pur-

chase

A 170100120 C USD 260 260 260

A 191500100 USD 600 600 600 Mach.

Equip.

Continued on next page

106

Template	Your layout
L50-0002 A/P - A/R	LXY-0002 .(XY = 50 + your group number)
L50-0004ChangesinInvesteeEquity	LXY-0004
L50-0005I/SwithFunctionalArea	LXY-0005
L50-0006 Income From Invest. Affiliates	LXY-0006
L50-0007SalesbyRegion	LXY-0007

CU	FS item	Subit	ePmart- nerCU	Trans Curcy Key	Trans Curcy	LC	GC	Item text
A	13010	0	B	UNI	600	400	400	IC Trade Rec.
A	13010	0	B	USD	200	200	200
A	13010	0	C	UNI	500	300	300
A	13010	0	C	USD	300	300	300
A	17010	0120	B	USD	1000	1000	1000	In- vest. Pur- chase
A	17010	0120	C	USD	260	260	260
A	19150	0100		USD	600	600	600	Mach. & Equip.

第 115 页 / 共 429 页

AC660 Lesson: Data Entry

CU FS SubitePmart- Trans Trans LC GC Item

item nerCU Curcy Curcy text

Key

A 191500120 USD 300 300 300

A 191500140 USD -100 -100 -100

A 191500220 USD -100 -100 -100

A 201100 USD -60 -60 -60 Trade

Payables

A 210100 B UNI -130 -100 -100 IC

Trade

Pay.

A 210100 B USD -150 -150 -150

A 210100 C UNI -300 -200 -200

A 210100 C USD -150 -150 -150

A 250100100 USD -2000 -2000 -2000 Com-

mon

Stock

A 251200120 USD -500 -500 -500 RE-Cur-

rent

Year

A 301100400 USD -5000 -5000 -5000 Sales

3rd

Party

A 3101000001 USD 4520 4520 4520 Raw

mate-

rials.

Continued on next page

107

CU	FS item	Subit	ePmart- nerCU	Trans Curcy Key	Trans Curcy	LC	GC	Item text
A	19150	0120		USD	300	300	300
A	19150	0140		USD	-100	-100	-100
A	19150	0220		USD	-100	-100	-100
A	20110	0		USD	-60	-60	-60	Trade Payable
A	21010	0	B	UNI	-130	-100	-100	IC Trade Pay.
A	21010	0	B	USD	-150	-150	-150
A	21010	0	C	UNI	-300	-200	-200
A	21010	0	C	USD	-150	-150	-150
A	25010	0100		USD	-2000	-2000	-2000	Com- mon Stock
A	25120	0120		USD	-500	-500	-500	RE-Cur rent Year
A	30110	0400		USD	-5000	-5000	-5000	Sales 3rd Party
A	31010	00001		USD	4520	4520	4520	Raw mate- rials.

第 116 页 / 共 429 页

Unit3: DataCollection AC660

CU FS SubitePmart- Trans Trans LC GC Item

item nerCU Curcy Curcy text

Key

A 3119500003 USD 100 100 100 Amor-

tiza-

tion

A 320400 B USD -120 -120 -120 In-

vest-

ment

In-

come

A 390000 USD 500 500 500 An-

nual

netin-

come

Hint: Donotentercreditsigns. Thesignwillbedeterminedbythe

definition of the FS item/subitem.

Task 3:

Data entry group:

1. You want to carry out the data entry for a unit with a specific data entry

layout on a particular date.

Define adata layout group (XY = 50 + your group number). Thisgroup

shouldcontainallthelayoutsyoucreatedinTask2.

Task 4:

Data entry profile:

1. Indicatethat all layoutsin thegroup, XY, arevalid for consunit Awhen

entering data quarterly in version 100.

Yourcolleaguehasalreadycreatedtheappropriateperiodcategories(2and

3) for the period, 12 and the periods, 3,6, and 9, respectively. Use these

in your profile.

Caution: Useyourownfinancialdatatype!

Continued on next page

108

CU	FS item	Subit	ePmart- nerCU	Trans Curcy Key	Trans Curcy	LC	GC	Item text
A	31195	00003		USD	100	100	100	Amor- tiza- tion
A	32040	0	B	USD	-120	-120	-120	In- vest- ment In- come
A	39000	0		USD	500	500	500	An- nual netin- come

第 117 页 / 共 429 页

AC660 Lesson: Data Entry

Task 5:

1. NowusetheDataMonitortoenterdataforconsolidationunitA.Runthe

appropriatetaskinthemonitorandenterthefinancialdataprovidedinTask2.

109

第 118 页 / 共 429 页

Unit3: DataCollection AC660

Solution 5: Online Data Entry

Task 1:

Financial data types:

1. Createafinancial datatypefor your example.

Name: A(for group 01) ... R(for group 18)

Assignthefinancialdatatypetotheconsolidationunits.

a) Financial data types:

To define a new financial data type in the Implementation Guide,

choose:

Menu Path: Tools→Customizing→IMG→ ExecuteProject→

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Data→DataCollection→OnlineandOfflineDataEntry→Settings

forOnlineandOfflineDataEntry→DefineFinancialDataTypes

Createafinancialdatatypeforyour example.

Datatype: A(forgroup01)... R(for group18)

Description: Group ## Data Type

Choose New Entries.

Save your entries when finished.

AssignthefinancialdatatypetoconsolidationunitsA,B,C,D,andE,

effectiveasof thecurrentyear, bychoosing:

Menu Path: Tools→Customizing→IMG→ ExecuteProject→

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Data→DataCollection→OnlineandOfflineDataEntry→Settings

forOnlineandOfflineDataEntry→AssignFinancialDataTypes

Save your entries.

Task 2:

Layouts:

1. According to the steering committee, the consolidation unit A isentered

manually.

Thegrouprequiresdataentrylayouts,whichyoucreateasfollows:

a)LXY-0001Balancesheet(XY=50+yourgroupnumber)

Continued on next page

110