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

第 144 页 / 共 529 页

Unit3: DataCollection AC660

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

using a different naming convention.

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

Continued on next page

134

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

第 145 页 / 共 529 页

AC660 Lesson: Data Entry

CU FS SubitePmart- Trans Trans LC GC Item

item nerCU Curcy Curcy text

Key

A 191500100 USD 600 600 600 Mach.

Equip.

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

135

CU	FS item	Subit	ePmart- nerCU	Trans Curcy Key	Trans Curcy	LC	GC	Item text
A	19150	0100		USD	600	600	600	Mach. & Equip.
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.

第 146 页 / 共 529 页

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

136

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

第 147 页 / 共 529 页

AC660 Lesson: Data Entry

Task 5:

1. NowusetheDataMonitortoenterdataforconsolidationunitA.Runthe

appropriatetaskinthemonitorandenterthefinancialdataprovidedinTask2.

137

第 148 页 / 共 529 页

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

138

第 149 页 / 共 529 页

AC660 Lesson: Data Entry

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.

Becauseyouwanttouseuniformlayoutnamingforthepresentation,copy

theselayoutsusingtheCopyfunctionandchangethelayout namesinthe

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

Continued on next page

139

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

第 150 页 / 共 529 页

Unit3: DataCollection AC660

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.

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

Continued on next page

140

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.
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

第 151 页 / 共 529 页

AC660 Lesson: Data Entry

CU FS SubitePmart- Trans Trans LC GC Item

item nerCU Curcy Curcy text

Key

A 3101000001 USD 4520 4520 4520 Raw

mate-

rials.

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.

a) Layouts:

To define data entry layouts, choose:

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

SAP Reference IMG → Enterprise Controlling→ Consolidation

→ Data → Data Collection → Online and Offline Data Entry →

Settings forOnlineand Offline Data Entry → Define Data Entry

Layouts → Create Data Entry Layout

1. Enterthenameanddescriptionforthebalancesheetlayout,and

choose Create.

Name: LXY-0001Description: Balancesheet

(XY = 50 + your group number)

2. To specify characteristics for the layout header, choose Edit

→ Gen. data selection → Gen. data selection in the layout

definition screen.

Continued on next page

141

CU	FS item	Subit	ePmart- nerCU	Trans Curcy Key	Trans Curcy	LC	GC	Item text
A	31010	00001		USD	4520	4520	4520	Raw mate- rials.
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

第 152 页 / 共 529 页

Unit3: DataCollection AC660

3. Select all the characteristics except FS item from Available

Characteristicsbyclickingontheboxtotheleftofeachname

and press the left arrow icon to move them to the Selected

characteristics table.

4. Define avariable for all characteristicsexceptDimension and

Cons chart/acct by checking the Variable on/off box (third

column)

5. Enteryourowndimension(XY)andchartofaccounts(XY)in

theFromcolumn. Confirmyour entries.

Check and Confirm.

6. IntheReportPainterscreenforlayoutdefinition,double-clickon

the first column (lead column).

7. SelectthecharacteristicFSitemfromAvailableCharacteristics

and press the left arrow icon to move it to the Selected

characteristics table.

8. Enter the item range 100000 to 299999 in the From and To

columns.

9. Enteratextforthisleadcolumn(forexample,FSitem). Choose

texticonatbottomofdialogbox. Selectconfirm.

10. Intheleadcolumnstructure,selectCharacteristicvalueandname.

Specifyalengthof8forthecharacteristicvalue,andatextlength

of30andconfirmyourselection. ChooseLeadColumniconat

bottom of dialog box. Select Confirm.

Check and Confirm.

11. Double-clickonColumn1. SelectthekeyfigureLocalcurrency.

Usekeyfiguredrop-downmenu. Entershort,medium,andlong

texts. Texticonisatthebottomofentrybox. SelectConfirm.

Check and Confirm.

12. To add the debit/credit sign you put the cursor on the column

header Local currency. Choosethemenu Edit → Element→

Insert Element Select Element type Attribute. Press Enter to

confirm.In the pop-up window press Confirm to confirm the

elementdefinitionofdebit/creditsign.Confirmyourentriesand

save the layout.

b)Usethesameproceduretodefineanassethistorysheetlayout.

Name: LXY-0003Description: Assethistorysheet

(XY = 50 + your group number)

1. ChooseEdit→Gen. dataselection→Gen. dataselectionand

maintain same as with the first layout.

Continued on next page

142

第 153 页 / 共 529 页

AC660 Lesson: Data Entry

2. ForthefirstleadcolumnselectFSitem. Donotspecifyanitem

range; insteadentertheitems170100and191500individually.

Enter 170100 in the From column; press the More arrow, and

enter 191500 on the next line.

3. EnteratextusingtheTexticonatthebottomofentrybox. Using

the Lead column structure icon at the bottom of box, select

Characteristicvalueandname, andspecifyalengthof8places

forthecharacteristicvalue,andatextlengthof20. Confirm.

4. Youalsoneedtodefinetwofurtherleadcolumnsinthislayout.

ChooseEdit→Columns→Newleadcolumn

ThefirstleadcolumnisforthecharacteristicSubitem(transaction

type), with the range 100 - 299, text Subitem, a characteristic

valuelengthof5andatextlengthof10places. Confirm.

ThesecondleadcolumnisforthecharacteristicPartnerunit,with

therangeAtoE,textPartner,andacharacteristicvaluelengthof

3places. Nameisnot needed. Confirm.

5. SorttheleadcolumnsbygoingtoEdit→Columns→Sortlead

columns.

PlaceFSItemfirst;Subitemsecond;andPartnerUnitthird.

Definethelocalcurrencycolumnandthedebit/creditsignasyou

did for the balancesheet layout. Save.

c)Youcancreatealltheotherlayoutsusingthecopyfunction.

To do this, stay at:

MenuPath: Tools→Customizing→IMG→ExecuteProject→SAP

ReferenceIMG→EnterpriseControlling→Consolidation→Data

→DataCollection→OnlineandOfflineDataEntry→Settingsfor

OnlineandOfflineDataEntry→Define/CreateDataEntryLayouts

Enterthename(e.g. LXY-0004)and descriptionofthenewlayout,

andthenameofanexistinglayoutwhichyouwanttouseasatemplate

(e.g. L50-0004) intheCopyfrom section.

Choose Create and then Edit → Gen. data selection→ Gen. data

selection in order tochange the chart of accountsand dimension to

that of your group

Caution: You must define the dimension and the chart

ofaccountsasbeinggroup-specific, andyoumaynotuse

variables.

Then save the layout.

Continued on next page

143

第 154 页 / 共 529 页

Unit3: DataCollection AC660

Repeatthisproceduretocreatetheremaining5layouts.

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.

a) Data entry group:

To define a data entry group, choose:

Menu Path: Tools→Customizing→IMG→ ExecuteProject→

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Data→DataCollection→OnlineandOfflineDataEntry→Settings

forOnlineandOfflineDataEntry→DefineDataEntryGroups

ChooseNewentriesandenteranameforyourgroup(50+yourgroup

number)andadescription,forexampleGroup##Layouts.

ChoosethegroupyoujustcreatedandselecttheAssignmentofdata

entry layouts folder and choose New entries. Provide a sequence

number (e.g. 010,020,030,etc.) and assign all the layouts that you

havedefined, includingthosefor which youused atemplate, tothis

group. DonotchecktheIntegratedExcel box; youwillnotusethis

option at this time.

Save your entries.

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.

Continued on next page

144

第 155 页 / 共 529 页

AC660 Lesson: Data Entry

Caution: Useyourownfinancialdatatype!

a) Data entry profile:

To define a data entry profile, choose:

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

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Data→DataCollection→OnlineandOfflineDataEntry→Settings

forOnlineandOfflineDataEntry→DefineDataEntryProfiles

ChooseNewentries,andenteryourfinancialdatatype(Aforgroup1

toRforgroup18),theperiodcategory2(period12dataentry),andthe

dataentrygroupthatyoudefinedinsection1-3. Makeasecondentry,

enteringyourfinancialdatatype,theperiodcategory3(periods3,6,9),

andyourdataentrygroup. Saveyourentries.

The period categories 2 and 3 already exist. Period categories are

defined at:

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

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Data→DataCollection→OnlineorOfflineDataEntry→Settings

forOnlineorOfflineDataEntry→DefinePeriodCategories

Task 5:

1. NowusetheDataMonitortoenterdataforconsolidationunitA.Runthe

appropriatetaskinthemonitorandenterthefinancialdataprovidedinTask2.

a) MenuPath: Accounting→EnterpriseControlling→Consolidation

→ Data Collection → Monitor

PlacethecursoronthecrosssectionofConsolidationUnitAandthe

DataEntryTask. ChooseUpdateRun. Selectthelayoutsinturnfrom

the Reported Financial DataSection and enter thedatafrom Task2

for Consolidation Unit A.

N.B.Someitemswillappearastotalsinsomeofthelayouts. Thedetail

will haveto beentered inanother layout.

Whenyouhavefinishedenteringthedata,gobacktotheBalanceSheet

Layout and checkthat it balancesto zero.

145

第 156 页 / 共 529 页

Unit3: DataCollection AC660

146

第 157 页 / 共 529 页

AC660 Lesson: Data Entry

Exercise 6: Flexible Upload

119

Exercise Duration: 30 Minutes

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Enterindividualfinancialstatementdatabymeansofaflexibleupload

Business Example

Your presentationexampleincludesaunitontheconsolidationof investments.

Forthisreason,youneedtocollectadditionalfinancialdata,whichisusedbythe

consolidationtask. Inpractice, subsidiariessupply thisinformation along with

theotherreportedfinancialstatementdata. Thisiswhyyoupopulatethesetables

inthecourseofthedatacollection. Youneedtoundertaketwostepsbeforeyou

cancollecttheadditionalfinancialdatafortheconsolidationofinvestments. You

needtodefinethesystemutilizationfortheconsolidationofinvestmentsandyou

must define the global settings.

Task:

Defining an upload method:

1. Accordingtothesteeringcommittee,alltheremainingconsunits,B,C,D,

andE,useMicrosoftExceltoreporttheirindividualfinancialstatements.

YourcolleaguehasalreadyenteredthedatafortheconsolidationunitsB,C,

D,andEinanExcelworksheetextractfile(.TXT).Thedataistransferredto

Consolidation using a flexible upload.

DefinetheuploadmethodUPLXY(XY=50+yourgroupnumber)withthe

following properties:

a. Column width: variable

b. FieldseparatorT:filetype“Text(Tabsdelimited)”

c. Row Type Indicators: Do not use

d. Comment character: “*”

e. Digit separators: "1.000,00"

f. Debit/creditsigns: Copyfromuploadfilewithoutchanges

g. Update mode: Delete all items

h. Input type: Cumulative

i. Dialogbox: enterthedimensionandconsolidationchartofaccounts

Continued on next page

147

第 158 页 / 共 529 页

Unit3: DataCollection AC660

j. Header row: enter the fields (in this order): consversion, fiscal year,

period, and ledger

k. Datarows: enterthefields(inthisorder): consolidationunit, FS item,

subitem, partner unit, transactioncurrency, value intransaction currency,

valueinlocalcurrency,valueingroupcurrency,user-definedfield

2. Assigntheuploadmethodyoujustcreatedtothemasterdataofalltheunits

inconsolidationgroupG2byusinghierarchymaintenance.

3. CreatetheExcelfileforuploadandthenuploadittoSAPConsolidation

4. CheckthecontentsoftheTotalsDatabasethenblockthetask.

148

第 159 页 / 共 529 页

AC660 Lesson: Data Entry

Solution 6: Flexible Upload

Task:

Defining an upload method:

1. Accordingtothesteeringcommittee,alltheremainingconsunits,B,C,D,

andE,useMicrosoftExceltoreporttheirindividualfinancialstatements.

YourcolleaguehasalreadyenteredthedatafortheconsolidationunitsB,C,

D,andEinanExcelworksheetextractfile(.TXT).Thedataistransferredto

Consolidation using a flexible upload.

DefinetheuploadmethodUPLXY(XY=50+yourgroupnumber)withthe

following properties:

a. Column width: variable

b. FieldseparatorT:filetype“Text(Tabsdelimited)”

c. Row Type Indicators: Do not use

d. Comment character: “*”

e. Digit separators: "1.000,00"

f. Debit/creditsigns: Copyfromuploadfilewithoutchanges

g. Update mode: Delete all items

h. Input type: Cumulative

i. Dialogbox: enterthedimensionandconsolidationchartofaccounts

j. Header row: enter the fields (in this order): consversion, fiscal year,

period, and ledger

k. Datarows: enter thefields(inthisorder): consolidationunit, FSitem,

subitem, partner unit, transaction currency, valueintransaction currency,

valueinlocalcurrency,valueingroupcurrency,user-definedfield

a) Defining an upload method:

To define an upload method, choose:

MenuPath: Tools→AcceleratedSAP→Customizing→Execute

Project → SAP Reference IMG → Enterprise Controlling →

Consolidation→Data→DataCollection→DataCollectionfrom

Non-SAPSystems→DefineMethodforuploadingreportedfinancial

data→Maintainmethodsforuploadingfinancialdata→Choose

ChooseNewentriesandenterthenameofyouruploadUPLXYanda

description(forexample, Uploadgroup ##).

Adetailscreenappearsinwhichyoudefineyourupload.

Continued on next page

149

第 160 页 / 共 529 页

Unit3: DataCollection AC660

In the top half of the screen, define the upload method with the

following properties:

1. Column width: variable

2. Field separator: “Tabulator”

3. Row Type Indicators: “Do not use”

4. Comment character: “*”

5. Digit separators: “1.000,00”

6. Debit/creditsigns: Copyfromuploadfilewithoutchanges

7. Update mode: Delete (all items)

8. Input type: Cumulative

UsetheiconsatthetopofthescreentochangethefieldseparatortoT,

thedigitseparatorto1.000,00,andthecommentcharacterto*.

Definethedialogboxandfilerowsasfollowsandintheexactorder:

1. Dialogbox: entertheDimensionandConschartofaccounts

2. Header row: enter the ConsVersion, Fiscal year, Period, and

Ledger

3. Data rows: enter the fields Consolidation unit, FS item,

Subitem,Partnerunit,Transactioncurrency,Valueintransaction

currency,Valueinlocalcurrency,andValueingroupcurrency

Toselectafield,doubleclickorpositionthecursoronitandclick

on the select icon at the top of the screen. Position the cursor

onDialogBox/HeaderRow/DataRowsandclickonthemove

icon at the top of the screen

Save your settings.

2. Assigntheuploadmethodyoujustcreatedtothemasterdataofalltheunits

inconsolidationgroupG2byusinghierarchymaintenance.

a) MenuPath: Accounting→EnterpriseControlling→Consolidation

→MasterData→ConsolidationGroups→Hierarchy→Maintain

Expandthehierarchy. DoubleclickB,C,DandEinturnandonthe

DataCollectiontabofeach,enterthenameoftheuploadmethodyou

have just defined.

Save your changes

Continued on next page

150

第 161 页 / 共 529 页

AC660 Lesson: Data Entry

3. CreatetheExcelfileforuploadandthenuploadittoSAPConsolidation

a) To create the upload file:

MenuPath: Office→WorkplaceNavigatethroughthemenus:Shared

Folders →EC → EC-CS → Training

FromthecontentswindoeontherightdoubleclickontheExcelfile

upload_B_E

Changetheyear inCellB2tothecurrentyear. In columnE change

any UNI to EUR.

SavetotheC:driveofthemachineasa.txtfile.

Now upload using the Data Monitor

MenuPath: Accounting→EnterpriseControlling→Consolidation

→ Data Collection → Monitor

Expand the hierarchy.

PutyourcursoronthecrosssectionofConsolidationGroupG2andthe

Data Entry task. Choose Update Run.

Onthenextscreen,starttheuploadbyclickingontheimporticonto

therightofConsolidationGroupG2. EnterUploadMethodUPLXY.

ClickonthebrowserbuttontotherightofthePhysicalfilenamefield

and navigate to your file.

FileformatisASCII.Selectpresentationserver.

Execute

Continued on next page

151

第 162 页 / 共 529 页

Unit3: DataCollection AC660

4. CheckthecontentsoftheTotalsDatabasethenblockthetask.

a) From within the Data Monitor

MenuPath: Goto→DatabaseListingofTotalsRecords

Enter the following parameters

Dimension XY

Consolidation Group G1

Version 100

Fiscal Year 2002

Period 12

Cons Chart XY

Execute

Verifythat theLCValueiszerofor eachunit.

Tolockthetask, clickontheintersectionofconsolidationgroupG1

andtheData Entry taskand select the lock iconfrom the topof the

screen. Thedataentrycolumnshouldturntoaseriesofpadlocks.

152

第 163 页 / 共 529 页

AC660 Lesson: Data Entry

Lesson Summary

You should now be able to:

• Describe the settings for online dataentry

• Define data entry layouts

• DescribeofflinedataentrywithMicrosoftAccess/Excel

• Explain flexible upload

153

第 164 页 / 共 529 页

Unit3: DataCollection AC660

Lesson: Validation and Postings

Lesson Duration: 40 Minutes

126

Lesson Overview

Thislessonprovidesanoverviewofvalidationandpostings. Youwilllearnhow

to define validation rules with the formula builder. In addition, you will learn

howto usethevariousdocument typesfor postings. You will alsolearn about

posting levels.

Lesson Objectives

After completingthislesson, you will beable to:

• Explain the concept of validations

• Describe postings and document types

Explain that validation rules can be used at different times, such as after data

collectionandacrossconsolidationunits. BringouttheuseofFormulaBuilderfor

definingrules. Describehowpostingsdifferfromreported data. Point out that

documenttypeshaveavarietyofcharacteristicsandcontrolfunctionsthatusers

canconfigure. Discussseveralconsolidationentriesandexplaintheneedtoassign

different posting levels to these entries.

Business Example

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

year. Financial statement data of the individual consolidation units has been

transferredintotheSAPsystem. Youneedtodefinethevalidationrulestocheck

thetransferredvaluesandpreparethesystemforstandardizingandconsolidation

entries.

154

第 165 页 / 共 529 页

AC660 Lesson: Validation and Postings

User-defined Validations

Validation

Validation rulescan beused at different times:

1. sub-assignments: Whenpostingthe businesstransaction in the operative

system

2. After data collection: Are the totals of assets and liabilities and owner’s

equity identical in the financial statement data of a consolidation unit?

Doesthetotalofthedetailedvalues(incomestatement)fromtheindividual

consolidationunitscorrespondtothebookvalue?

3. Acrossconsolidationunits: Isthetotalofselectedfinancialstatementitems

fromseveralconsolidationunitsidenticaltothevalueofthecorresponding

financialstatementitemintheconsolidationgroup?

4. Acrossviewsandhierarchies: Arevaluesfromselectedfinancialstatement

itemsbetweentotallydifferentapplications–suchasinternalandexternal

reporting – identical?

To check this, equivalence relationships can be maintained in the

corresponding consolidation units in the validations for report data and

adjusted report data (for example: Dimension 01, consolidation unit

A corresponds to consolidation unit X in dimension 02, Business area

consolidation).

If the data was transferred with MS Access, then the data is validated with

the same rules before the export to SAP Consolidation (which ensuresthat no

inconsistencies occur in SAP Consolidation).

The checks that involvetheconsolidationunitsare not onlyperformed for the

report data, but also later in the consolidation process, after the standardizing

entries, the currency translation, and in the level consolidation group (that is,

subgroup).

Hint: Training system data:

The course example does not contain any validation rules for items 3

and 4.

Formula Builder for Defining Rules

The illustrated rule means:

Whenthevalueof financial statement item realestate, subitemdepreciationis

notzero,thenanerrormessageshouldbegeneratedwithtext: “Nodepreciation

allowed”.

155

第 166 页 / 共 529 页

Unit3: DataCollection AC660

The severity of the check (warning or error message) can be defined for each

validation rule.

The incorrect values can be corrected by changing the values manually in the

planningprocessororthroughmanualadjustmentpostings.

TheuseoftheFormulaBuilderisemphasizedinthefollowingdemonstration.

Hint: Systemdocumentation: Validation:

Theprocessofverifyingvaluesandcombinationsofvalueswhenthese

valuesandcombinationsofvaluesareenteredinSAPsystem.

Theenteredvaluesarecheckedagainstauser-definedBooleanexpression

(requirement). Whenthisstatementistrue,thevaluesarecheckedagainst

an additional Boolean expression (check expression). If the check

expressionistrue,thedataisupdated. Ifthecheckexpressionisfalse,the

systemissuesamessagedefinedbytheuser. Whetherthepostingcanbe

updatedornotdependsonthemessagecategory(warning/error).

Validation is performed before the posting, to ensure that only valid

data is posted.

Figure 38: Validation

Theconceptofuser-definedvalidationisemployedinmanySAPapplications.

156

第 167 页 / 共 529 页

AC660 Lesson: Validation and Postings

Validationsareavailablein addition to thestandard checks in the SAP system

postingtransaction. Youcanrunvalidationwhenprocessingthefollowing:

• Document header

• Individual document line

• Complete document

Validationfor aconsolidationunit typically takesplaceafter datacollection in

localcurrencyandcurrencytranslationintogroupcurrency.

You require to perform validation across consolidation units or dimensions to

ensurereconcileddatainlegalandmanagementconsolidation.

Youcancheckthevalidationresult step-by-stepinthevalidationlog. Youcan

verify the validation rules that were interpreted in a validation step. You can

also knowhowtheresultof the step breaksdownintothepartial results of the

validation rules involved. With the help of concrete numeric values, you can

analyze the computation of the total result.

Reporting tools such as drilldown reporting or Report Writer/Painter are

recommendedtoverifythevaluesthatwerecalculatedbythevalidation.

Figure 39: Formula Builder for Defining Rules

Youcandefinevalidationruleswiththeformulabuilder.

Thefieldselectioncontains,inaccordancewiththecalluppointchosenbyyou,

thefieldsof thedocument header, theFS item, thecompletedocument, or the

Consolidationtotalsdata. Youcanalsodefinevalidationruleswiththehelpofthe

attributes that you have defined.

The available fields, logical operatorsand comparativeoperators, can only be

selectedwhenthey are meaningful in that place.

157

第 168 页 / 共 529 页

Unit3: DataCollection AC660

Ifthecheckcontainsan error, you candecidewhetheryouwant toreacttothe

errorwithanerror messageor awarning message.

Youcanstorethetextsfortheerrororwarningmessagesinmessageclasses. The

message classes bring similar messagestogether.

Demonstration: Demonstration: Formula Builder for

Defining Rules

Purpose

To define rules using formula builder

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. Defineasimplevalidationrule(assets=liabilitiesandowner’sequity)and

one that is more complex (validation income statement FS item expense

from depreciation with book value of depreciation). Theseexamplesare

contained in instructor example V50.

2. Explain:

1. The menu items

2. The icons

3. TherequirementsforsatisfyingtherulewiththeFormulaBuilder

4. Thecheck itself (with theFormulaBuilder)

3. Point out the F1 help for defining validation rules. It isavailable for the

requirements and check areas:

• DirectmaintenanceofBooleanexpressionsforrules

• Direct maintenance of Boolean expressions for validations and

substitutions

Postings and Document Types

Postingsdifferfromreporteddatainthattheindividualactivitiesareenteredinthe

formofpostingdocumentsthathavea“documentcontext”.

158

第 169 页 / 共 529 页

AC660 Lesson: Validation and Postings

Theseactivitiesaretypicallyclassifiedbydocumenttype:

• Adjustments for uniform valuation

• Elimination of IUpayablesand receivables

• Consolidation of investments

Separatedocumenttypesareusedformanualpostings.

Most documents are generated automatically, based on pre-defined methods.

Thesepostingsarelistedinselectedfinancialstatementitems,suchasaccrualof

deferredtaxesastheeffectofadepreciationadjustment.

Hint: Thedocumenttypecontrolsthefollowingcharacteristics:

Value area:

• Standardizingentriesthatareperformedforaconsolidationunit

• Two-sidedeliminatingentriesbetweentwoconsolidationunits

• Group-specificconsolidationentriesbetweenanynumberofunits

in the group.

Currency definition:

Whichcurrenciesshouldbecontainedintheconsolidationdocument?

Definition of FS item category:

Bydefault,allFSitemcategories(suchas“balancesheet”“cashflow”

or“keyfigure”)areallowedforpostinginthedefinitionofadocument

type. If you want to restrict these categories, then all the financial

statementitemsthathavetheseFSitemcategoriescannotbepostedwith

the document type.

Document number assignment:

Defineanumberrangeandanumberrangeintervalforeachdocument

typetoallowyoutodisplay(orreverse)thedocumentinthetransaction

figures and as a single document.

Exceptions: Simulated invoices and automatically generated postings

onlyneedabalanceupdate,nosingledocuments. Inthiscase,youcould

optionallydowithouttheupdateandthedocumentnumberassignment.

Zero balance check:

Can be activated or deactivated.

Financial statementimbalancesbetween balancesheetandincome

statement:

Arepostedactivity-specificallybythesystem,asautomaticallygenerated

posting lines without explicit input.

159

第 170 页 / 共 529 页

Unit3: DataCollection AC660

Deferred Taxes:

Depending on the definition in the document type, the system posts

deferredtaxes activity-specifically, asautomaticallygenerated posting

lineswithoutexplicitinput. Definethecorrespondingbalancesheetand

income statement FS items in the IMG.

Offsetting entries:

If necessary, specify an offsetting entry for cross consolidation group

financial statement items.

Thisfunctionisonlyavailablefordocumenttypeswhosepostinglevelis

greaterthanorequalto20(two-sidedelimination). Crossconsolidation

unitpostingsareonlyallowedforthesedocumenttypes.

Automatic reversal in the next period:

Canbedefinedasadocumenttypecharacteristic.

Consolidationeffectsbydocumenttypecanbedisplayedfromtheactivity

figures of the totals database.

Document Types

Documenttypeshaveavarietyofcharacteristicsandcontrolfunctionsthatusers

canconfigure. Theyareexplainedinmoredetailduringthedemonstration. Point

out important dependencies:

1. Document types are dimension-specific.

2. Number ranges aredependent ontheversion.

3. Clearingitemsaredependentontheconsolidationchartofaccounts.

Hint: StartinginRelease4.5,theSAPConsolidationFinalPreparation

containsadimensioncopierthatcanbeusedtocopythedimensionand

thedimension-specificconfiguration. Intheprocess,neitherthenumber

rangesnorthenumberrangeintervalsofthedocumenttypearecopied.

Posting Levels I

1. 1. Introduction

Discussseveralconsolidationentriesandexplainthenecessityforassigning

different posting levels to these entries.

Point out that successive consolidation (status monitor: push button run

successivetasks)consistsofexecutingtheprogrammedtasks;however,the

usermaynotknowexactlywhichpostingsweregenerated.

160

第 171 页 / 共 529 页

AC660 Lesson: Validation and Postings

Alsopointoutthatthemanualandautomaticpostingsinreportingcanbe

analyzed by different posting levels – for example, you can use posting

levelstoseparatetheactivitiesforaconsolidationgroupin consolidation

of investments.

The posting levels also document the various processing steps that take

placeafterthedatatransferofreportdatafromtheoperativesystemstothe

consolidation system.

2. Defining Posting Levels

Postinglevelstypifytheconsolidationactivitiesatatechnicallevel.

Group-independent posting levels:

Thestandardizingentriesareperformedattheconsolidationunitlevel. They

applytoalltheconsolidationgroupsthatcontaintheunit.

Group-specific posting levels:

Take into account the equity holding percentages between single

consolidationunits(suchasconsolidationofinvestments). Thesepostings

arevalideither onlyforthecorrespondingconsolidationgroup or for this

andallconsolidationgroupsinwhichitiscontained.

3. Posting Levels:

Blank: Direct data collection, rollup

0: Flexibleupload,periodicextract,manualdatarecording,MSAccess

01: Adjustment postings (for example, when the reported data for the

consolidation unit contained an error and you do not want to transfer the

individual financial statement again)

During the balance carry forward in the following year the adjustment

postingwithisaccumulatedwiththelevel0postings!

10: Standardizing entries (such as depreciation adjustment, valuation

adjustment for stocks)

20: Two-sidedelimination(suchaseliminationofreceivables/payables)

23: Two-sided elimination: special logic

These posting levelsaregroup-independent.

Group-specific postings:

30: Consolidationofinvestments(validfortheinvolvedconsolidationgroup

and all other consolidation groups that contain the posted consolidation

group).

Consolidation group changes.

161