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

第 119 页 / 共 429 页

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

111

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

第 120 页 / 共 429 页

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

112

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

第 121 页 / 共 429 页

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

113

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

第 122 页 / 共 429 页

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

114

第 123 页 / 共 429 页

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

115

第 124 页 / 共 429 页

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

116

第 125 页 / 共 429 页

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.

117

第 126 页 / 共 429 页

Unit3: DataCollection AC660

118

第 127 页 / 共 429 页

AC660 Lesson: Data Entry

Exercise 6: Flexible Upload

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

119

第 128 页 / 共 429 页

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.

120

第 129 页 / 共 429 页

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

121

第 130 页 / 共 429 页

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

122

第 131 页 / 共 429 页

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

123

第 132 页 / 共 429 页

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.

124

第 133 页 / 共 429 页

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

125

第 134 页 / 共 429 页

Unit3: DataCollection AC660

Lesson: Validation and Postings

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

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.

User-defined Validations

Figure 38: Validation

Theconceptofuser-definedvalidationisemployedinmanySAPapplications.

126

第 135 页 / 共 429 页

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.

127

第 136 页 / 共 429 页

Unit3: DataCollection AC660

Ifthecheckcontainsan error, you candecidewhetheryouwant toreacttothe

errorwithanerror messageor awarning message.

Youcanstorethetextsfortheerrororwarningmessagesinmessageclasses. The

message classes bring similar messagestogether.

Postings and Document Types

Figure 40: Postings and Document Types

Twotypesofentriesarepostedduringconsolidation,adjustingorconsolidation

entries.

Thesystempostsautomaticentries totheselecteditemsthat you specify, such

as retained earnings in the balance sheet and incomestatement, provisionsfor

taxationinthebalancesheet,andincometaxexpensesintheincomestatement.

Postingsare differentiatedbythedocument type.

Eachdocumenttypeisassignedtoasinglenumberrangeforaparticularversion.

Apostinglevelandothercontrolparametersareassignedtoeachdocumenttype.

Note: Youshoulduseadocumenttypeforonetaskonly,toenableyou

to repeatandreversepostings. Thesystemneedstobeabletoidentify

the documents posted for a task.

128

第 137 页 / 共 429 页

AC660 Lesson: Validation and Postings

Figure 41: Document Types

SAPConsolidationsupportsawiderangeofautomaticpostings. Youcanalsopost

standardizingandconsolidationentriesmanually. Postingsareclassifiedbymeans

ofdocumenttypes. Thisenablesyoutoperformasimpleanalysisandoutlinethe

distinction between different businessfunctions.

Thesystemautomaticallygeneratesjournalentries, suchasfinancialstatement

balancingadjustmentsanddeferredincometaxes. Inthisway,youcancontrolthe

specialitemsfordeferredtaxesindependentlyoftherespectivedocumenttype. In

addition,withdocumenttypesthatarelargerthanorequalto20,youcandefinea

clearingitemforcross-consolidationunitspostings. Across-consolidationunit

postingcantakeplaceonlyfor thesepostinglevels.

Toindicateselecteditemsforthedocumenttype,enteranitemforthedebitand

credit postings.

You need to use different document types to distinguish between manual and

automaticpostings. Youcanuseidenticalordifferentnumberrangesforposting.

Theaccount assignmenttakesplacebytheitemnumberandasrequiredbythe

sub-assignmentpossibilities,whichyoucanspecifyindividually.

Areversalfunctionandamassreversalfunctionisavailableforsingledocuments.

129

第 138 页 / 共 429 页

Unit3: DataCollection AC660

Figure 42: Posting Levels I

The posting level standardizes the postings in the Consolidation system. For

example:

• Adjustments to reported financial data

• Standardizing Entries

Further posting levels:

• Space: Financial data fromreal-timeupdate

• 08: Itemsubstitutionbasedonlevels“space”,00,and01

• 23: Two-sided elimination (special logic), particularly for eliminating

investmentrevenueduringmutualstockconsolidation

• R0toR3 Reporting ReportWriter (roll-up only)

Standardizingentriesarevalidinalltheconsolidationgroups,whichcontainthe

consolidation unit that is posted against.

Two-sided consolidation entries are valid only for the consolidation groups in

whichtheconsunitandthepartnerunitareconsolidatedusingthepurchase, or

proportional, ormutualstockmethod(levels23and24).

Postings that are dependent on the consolidation group are valid only for the

relevant consolidation unit (levels 02, 12, 22, and 24) or for the consolidation

groupandalltheother groupsinwhichitisincluded.

130

第 139 页 / 共 429 页

AC660 Lesson: Validation and Postings

Figure 43: Posting Levels II

Youspecifyapostinglevelwhenyoudefinedocumenttypes.

Journal entries are stored in the database with a respective posting level. In

reporting, theycanbesubdividedbythepostinglevel.

Intheaboveexample,documentsareportrayedfordifferenttasks:

• Activity 1:

ThestandardizingentrytoconsunitConlyaffectsthisunit. Thedocument

is valid in all the cons groups (CG).

• Activity 2:

TheeliminationofIUpayablesandreceivablesbetweenAandBisvalid

in the cons groups 1 and 2.

• Activity 3:

TheeliminationofIUpayablesandreceivablesbetweenAandBisvalid

intheconsgroup1,asbothcompaniesareonlyaffiliatedtocompaniesat

the group level.

• Activity 4:

The taskconsolidationof investmentsis started inCG1, the document is

createdinthelowestaffectedconsgroupCG3andisalsovalidinCG1.

131

第 140 页 / 共 429 页

Unit3: DataCollection AC660

132

第 141 页 / 共 429 页

AC660 Lesson: Validation and Postings

Exercise 7: Validation

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Definesimplevalidationrulesusingtheformulabuilder

Business Example

You have now entered in the individual financial statement data of all the

consolidation units in your prototype example.

This datanow needsto be validated, in order toprovidea correct basisfor the

following tasks.

Task:

Defining and running a validation:

1. DefinevalidationVXY(whereXY=50+yourgroupnumber).

The validation containstwo simplesteps:

1st check:

EnsuresthatthesumofassetFSitemsisequaltothesumofliability/equity

FS items.

2nd check:

Checkswhether depreciation ofmachineryand equipment inthebalance

sheet isequaltothedepreciationexpenseofmachineryand equipmentin

the income statement.

Hint: Specifythestandardmessages601and607,andusethelocal

currency fields for message output.

2. Assignthevalidationruletoallconsolidationunits.

3. Runthetaskthatvalidatesthelocalcurrencydata. Thesystemautomatically

blocksthetaskifitissuccessfullycompletedforthewholegroupG1.

Youhavealreadymadetheappropriatesettingintheprevioussection

133

第 142 页 / 共 429 页

Unit3: DataCollection AC660

Solution 7: Validation

Task:

Defining and running a validation:

1. DefinevalidationVXY(whereXY=50+yourgroupnumber).

The validation containstwo simple steps:

1st check:

EnsuresthatthesumofassetFSitemsisequaltothesumofliability/equity

FS items.

2nd check:

Checkswhether depreciation of machineryand equipment inthebalance

sheet isequal tothedepreciationexpenseofmachineryandequipment in

the income statement.

Hint: Specifythestandardmessages601and607,andusethelocal

currency fieldsfor message output.

a) To define a validation, choose:

Menu Path: Tools→Customizing→IMG→ ExecuteProject→

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Data →Validations for Reported Data and Standardized Data →

Definevalidations→Createvalidation→Choose

EnterVXYasthenameofyourvalidation(whereXY=50+yourgroup

number)anddescriptionGroup##Validation. Enter.

Put cursor on VXY folder . Then choose Insert step icon. Edit the

stepsPrerequisite,Check,Messagesuccessivelybyplacingcursoron

each and double-clicking.

Make the following settings for the validation using the Formula

Builder

Validationstep001: Totalassets=Totalliabilities+stockholders’

equity

Continued on next page

134

第 143 页 / 共 429 页

AC660 Lesson: Validation and Postings

Field/DataType Value

Prerequisite: TRUE

Check: SUM(ECCSDAT-HSLYD)whereT100000

= SUM (ECCSDAT-HSLYD) where

T200000

Message: Usetheexistingmessage601

T100000and T200000 areRules. You accessthembyselecting the

Rules tab.

Clickonthebuttonsintheformulabuildertoselectthem.

Youcan display thetechnical namesin thetop section ofthe screen

bychoosingSettings→TechnicalnamesorbyselectingtheDisplay

TechnicalNameicon(3rdicon)totherightofthefieldnamelistings.

When choosing Table fields, first select Data structure for CS

validation,thenyouwillseethefielddescriptions,forexample,local

currency YTD.

Hint: Notethatthecheckisstructuredasfollows:

SUM(*Tablefield*)WHERE*Rule**Operator*SUM

(*Table field*) WHERE *Rule*

Ifthetrafficlightisnotgreen,thesyntaxisincorrect.

WithcursoronVXYonleftsideofscreen,chooseInsertstepicon.

Validation step 002 : Depreciation of machineryandequipment in

thebalancesheet=depreciationofmachinery andequipment inthe

income statement

Field/DataType Value

Prerequisite: TRUE

Check: SUM (ECCSDAT-HSLYD) where

T191500 + SUM (ECCSDAT-HSLYD)

whereT311950 = ‘0.00’

Message: Usetheexistingmessage607

Hint: UsetheexistingrulesT191500_220andT311950.

ChoosetheCONSTANTbuttontoentertheconstantvalue0.

Continued on next page

135

Field/DataType	Value
Prerequisite:	TRUE
Check:	SUM(ECCSDAT-HSLYD)whereT100000 = SUM (ECCSDAT-HSLYD) where T200000
Message:	Usetheexistingmessage601

Field/DataType	Value
Prerequisite:	TRUE
Check:	SUM (ECCSDAT-HSLYD) where T191500 + SUM (ECCSDAT-HSLYD) whereT311950 = ‘0.00’
Message:	Usetheexistingmessage607

第 144 页 / 共 429 页

Unit3: DataCollection AC660

Save your definition.

2. Assignthevalidationruletoallconsolidationunits.

a) Assignthevalidationtoyourconsunitsbychoosing:

Menu Path: Tools→Customizing→IMG→ ExecuteProject→

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Data →Validations for Reported Data and Standardized Data →

Assign Validationsto ConsolidationUnits

SelectNewEntries. Maketheassignmentforperiodcategory2and3.

EnteryourvalidationinthecolumnsVal. rptdandVal. stdforeach

of your cons units.Save.

3. Runthetaskthatvalidatesthelocalcurrencydata. Thesystemautomatically

blocksthetaskifitissuccessfullycompletedforthewholegroupG1.

Youhavealreadymadetheappropriatesettingintheprevioussection

a) Sinceyouhavealreadydefinedvalidationtasksandassignedthemto

thetaskgroup, youonly need toensurethat theAutomaticblocking

indicator issetforbothofthevalidationtasks.

Menu Path: Tools→Customizing→IMG→ ExecuteProject→

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Data→DataMonitor→DefineTaskGroup

Selectyourtaskgroupanddoubleclickonassigntaskstotaskgroup.

Nowgototheapplicationandrunthedatamonitor. Executethelocal

currency vaidation task for consolidation group G1 by placing the

cursoratthecrosssectionbetweenunitG1andtheLOCALVALtask,

and choosing Update run.

MenuPath: Accounting→Enterprisecontrolling→Consolidation

→ Data Collection → Monitor

Open up the hierarchy.Position the cursor on the intersection of

consolidationgroupG1andthetaskVALIDLC.SelectUpdateRun.

Open up the results table. You should see green lights for the

validations you created.

136

第 145 页 / 共 429 页

AC660 Lesson: Validation and Postings

Exercise 8: Posting

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Post a standardizing entry.

Business Example

• Youwanttopresentamanualadjustmententry.

You assume that consolidation unit A recorded a useful life of 10 years

foranasset,whereasthegroupwilldepreciatetheassetonlyoveraperiod

of 5 years.

This posting, which has aneffect on earnings, automatically triggersan

allocationofdeferredtaxesandanadjustmentofannualnetincome.

Thetaxrateof40%appliestoallconsolidationunits.

Youalreadycreatedthenecessaryselecteditemsinapreviousstep.

• Youalsoexplainhowtopostareversalofagenerateddocument.

Youaddone moreassumption toyour example:

Theinformationregardingthedifferenceinthedepreciablelifewaswrong.

Theoriginaldepreciationof consolidationunit Awascorrect, and should

notbeadjustedforthecorporategroup. Youthereforepostareversaltothe

document that was posted.

Task:

Depreciation adjustment:

1. Depreciation adjustment:

1)Defineataxrateof40%forallconsolidationunitsforpostingdeferred

taxes.

Hint: UsethefunctionCarryoutMassChange.

2) Define document type 10 for postings in local currency (LC) in

conjunction with deferred taxes.

For this document type create a new number range 10 with document

numbersfrom1000000000through1999999999.

3) Create a new task called STD POST :

Continued on next page

137

第 146 页 / 共 429 页

Unit3: DataCollection AC660

a)Shorttext: Adj.Entry; mediumtext: AdjustmentEntry·

b)Assignthenewdocumenttype10tothetask,makingiteffectivefromlast

year and period 12.

4)AddtaskSTDPOSTtothetasksinyourtaskgroup.

5) Posttheadjustmententryin thedatamonitor.

Makeanoteofthedocumentnumberanddisplaythedocument.

In the Information System, display a list of the totalsrecordsand journal

entries.

2. Reversethe document created beforehand.

1)Displaythedocumentandmakesurethatthereversaldocumentnumberis

recordedintheoriginaldocument,andtheorganizationdocumentnumberis

recorded in the reversal document.

2) Block the taskSTD POST in the data monitor for the entire corporate

group G1.

138

第 147 页 / 共 429 页

AC660 Lesson: Validation and Postings

Solution 8: Posting

Task:

Depreciation adjustment:

1. Depreciation adjustment:

1)Defineataxrateof40%forallconsolidationunitsforpostingdeferred

taxes.

Hint: UsethefunctionCarryoutMassChange.

2) Define document type 10 for postings in local currency (LC) in

conjunction with deferred taxes.

For this document type create a new number range 10 with document

numbersfrom1000000000through1999999999.

3) Create a new task called STD POST :

a)Shorttext: Adj.Entry; mediumtext: AdjustmentEntry·

b)Assignthenewdocumenttype10tothetask,makingiteffectivefromlast

year and period 12.

4)AddtaskSTDPOSTtothetasksinyourtaskgroup.

5) Posttheadjustmententry inthedatamonitor.

Makeanoteofthedocumentnumberanddisplaythedocument.

In the Information System, display a list of the totals records and journal

entries.

a) Depreciation adjustments:

1) Add the percentage rate for posting deferred taxes in the master

records of the consolidation units.

Since this change is the same for all units, use the Mass Changes

function.

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

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Master Data → Organizational Units → Consolidation Units →

Carry out a mass change

Enter the following values:

Continued on next page

139

第 148 页 / 共 429 页

Unit3: DataCollection AC660

Field/Data Type Value

Dimension XY

Consolidation group G1

Consolidation units A through E

Version 100

Year Current Year

Period 12

Newvalues→saveasnewvalue 40 % tax rate

Test run No

Execute program.

2) Define the new document type 10.

Menu Path: Tools→Customizing→IMG→ ExecuteProject→

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Data→ManualPosting→Definedocumenttypes

ChooseNewentries andenter thefollowing:

Field/Data Type Value

Document type 10

Description ADJUSTMENTENTRIES

Posting level 10

Balance check 0

Application 9

Manual posting Select theindicator

Postinginlocalcurrency Select theindicator

Deferred Taxes Select the indicator for debits

and credits

Number Range Maintenance:

Number range ID 10

Number range 101000000000to1999999999

Year valid until (2003)

ChooseNumberRanges/AutoReversalfolder. ChooseNewEntries.

Specifyversion100andthenumberrange(10).

Continued on next page

140

Field/Data Type	Value
Dimension	XY
Consolidation group	G1
Consolidation units	A through E
Version	100
Year	Current Year
Period	12
Newvalues→saveasnewvalue	40 % tax rate
Test run	No

Field/Data Type	Value
Document type	10
Description	ADJUSTMENTENTRIES
Posting level	10
Balance check	0
Application	9
Manual posting	Select theindicator
Postinginlocalcurrency	Select theindicator
Deferred Taxes	Select the indicator for debits and credits
Number Range Maintenance:
Number range ID	10
Number range	101000000000to1999999999
Year valid until	(2003)

第 149 页 / 共 429 页

AC660 Lesson: Validation and Postings

ChooseDefineNumberRange. ChooseInsertintervaliconandenter

dataaslistedabove. Savethenumber range.

Save your entries.

3) Define a new task for the adjustment entry and insert the task in

the existing task group.

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

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Data→ Manual Posting→Definetasks

ChooseNewentriesandcreatethetaskSTDPOST.textStdPosting)

Selectthistask anddouble-clickDocument TypeAssignmentfolder.

ChooseNewEntries andspecifythefollowing:

Field/Data Type Value

Effective year year 2002

Effective period Last year

Document type 10

4)Aftersavingtheseentries,addtaskSTDPOSTasaNewEntryto

task group DATA.

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

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Data→DataMonitor→DefineTaskGroup

Selectyourtaskgroupanddoubleclickonassigntaskstotaskgroup.

Selectnewentries. Addthetask STDPOST.

Save your entries

5)Intheapplication,runthedatamonitorandexecutetheadjustments

taskforconsolidationunitAbyplacingthecursoratthecrosssection

between unit Aand theSTDPOST task, and choosing Updaterun.

EnterdocumentheadertextandthenselectLineItemstab.

Field/Data Type Value

Item191500,Subitem220 -100

Item311950,Subitem0003 100

Saveandmakeanoteof thedocument number whenit isdisplayed

on the status line.

Todisplaythedocument,fromwithinthedatamonitor,choose:

Continued on next page

141

Field/Data Type	Value
Effective year	year 2002
Effective period	Last year
Document type	10

Field/Data Type	Value
Item191500,Subitem220	-100
Item311950,Subitem0003	100

第 150 页 / 共 429 页

Unit3: DataCollection AC660

Menu Path: Goto →Journal entries

Select the following:

Field/Data Type Value

Dimension XY

Consolidation group G1

Consolidation unit A

Version 100

Fiscal year 2002

Period 12

Document type 10

Posting level 10

Chart of accounts XY

Makesureyoudeleteanyotherentries. Afterconfirmation,theselected

document will be displayed.

An alternative way of displaying the document is to directly select

thedocumentnumberthatwasdisplayedonthestatuslinewhenthe

adjustment wasposted. Todothis, choose:

MenuPath: Accounting→Enterprisecontrolling→Consolidation

→DataCollection→Manualposting→Display

2. Reversethe document created beforehand.

1)Displaythedocumentandmakesurethatthereversaldocumentnumberis

recordedintheoriginaldocument,andtheorganizationdocumentnumberis

recorded in the reversal document.

Continued on next page

142

Field/Data Type	Value
Dimension	XY
Consolidation group	G1
Consolidation unit	A
Version	100
Fiscal year	2002
Period	12
Document type	10
Posting level	10
Chart of accounts	XY