第 239 页 / 共 529 页
AC660 Lesson: Translation and Rounding Differences
Field/Data Type Value
Exchange RateIndicator 5
Translation Key 1
Translation differences:
Item (debit/credit) 250940
Subitem category 6
Subitem 120
Transaction Currency Checkthedefaultbox
Translation Entry 060:
From300000to389999
FS Item set:
X-389999IncomeStatement
Exchange rateindicator 6
Translation key 5
Translation differences:
Item (debit/credit) 250930
Subitem category 6
Subitem 120
Translation Entry 070:
From: 390000
FS Item Set
X-299999 BS-Investments-MachEquip-
Common Stock
Exchange rateindicator 6
Translation key 5
Translation differences:
Continued on next page
229
03-12-2004 © 2004 SAP AG. All rights reserved.
| Field/Data Type | Value |
|---|---|
| Exchange RateIndicator | 5 |
| Translation Key | 1 |
| Translation differences: | |
| Item (debit/credit) | 250940 |
| Subitem category | 6 |
| Subitem | 120 |
| Transaction Currency | Checkthedefaultbox |
| Translation Entry 060: | |
| FS Item set: X-389999IncomeStatement | From300000to389999 |
| Exchange rateindicator | 6 |
| Translation key | 5 |
| Translation differences: | |
| Item (debit/credit) | 250930 |
| Subitem category | 6 |
| Subitem | 120 |
| Translation Entry 070: | |
| FS Item Set X-299999 BS-Investments-MachEquip- Common Stock | From: 390000 |
| Exchange rateindicator | 6 |
| Translation key | 5 |
| Translation differences: |
第 240 页 / 共 529 页
Unit4: CurrencyTranslation AC660
Field/Data Type Value
Item (debit/credit) 251200
Subitem category 6
Subitem 120
3. Assignment:
Assign the translation method XY-01 (where XY stands for the chart of
accounts)toconsolidationunitDinthemasterrecord.
- You will use the data monitor to carry out currency translation for
consolidationunitD.Youthereforeneedtodefineonemoretask.
4. Defining tasks:
CallthecurrencytranslationtaskCURRTRANandassignittotaskgroup
DATA.
Make sure that currency translation is automatically blocked after it is
executed successfully.
5. RuncurrencytranslationforconsolidationunitDinthedatamonitor,and
examine the audit trail.
230
©2004SAPAG.Allrightsreserved. 03-12-2004
| Field/Data Type | Value |
|---|---|
| Item (debit/credit) | 251200 |
| Subitem category | 6 |
| Subitem | 120 |
第 241 页 / 共 529 页
AC660 Lesson: Translation and Rounding Differences
Solution 9: Currency Translation
Task:
Translation method
1. Translation entries
Define the translation method XY-01 (where XY stands for the chart of
accounts)usingreferenceexchangerateindicator5(=currentrate).
Hint: Thesetsyouneedbeginwiththeletterforyourgroup(Afor
group 01, etc.) and ahyphen (X-...).
Example:
Group 01: Set A-
Group 10: Set J-
Group 18: Set R-
ThesuffixconsistsoftheFSitemnumber,thesubitem,orthefrom
FS item number.
Makethefollowingsettingsinthemethod: Enterthefollowing:
Field/Data Type Value
Translation entry 010:
FS Item Set: From: 191500
X-191500FixedAssets
Subitem set: From: 100
X-100OpeningBalances
Translation key 6
Translation differences:
Item (debit/credit) 250910
Subitem category 6
Subitem 120
Translation entry 020:
Continued on next page
231
03-12-2004 © 2004 SAP AG. All rights reserved.
| Field/Data Type | Value |
|---|---|
| Translation entry 010: | |
| FS Item Set: X-191500FixedAssets | From: 191500 |
| Subitem set: X-100OpeningBalances | From: 100 |
| Translation key | 6 |
| Translation differences: | |
| Item (debit/credit) | 250910 |
| Subitem category | 6 |
| Subitem | 120 |
| Translation entry 020: |
第 242 页 / 共 529 页
Unit4: CurrencyTranslation AC660
Field/Data Type Value
FS Item Set:
X-191500FixedAssets
Subitem Set: From120to299
X-999FixedAssetMovements
Exchangerateindicator 5
Translation key 1
Translationdifferences:
Item (debit/credit) 250910
Subitem category 6
Subitem 120
Translation entry 030:
FS Item Set: From170100to170400
X-170100Investments
Translation key 3
Translationdifferences:
Item (debit/credit) 250920
Subitem category 6
Subitem 120
Translation entry 040:
FS Item set: From: 250100
X-250100CommonStock
Translation key 4
Translationdifferences:
Item (debit/credit) 250930
Subitem category 6
Subitem 120
Continued on next page
232
©2004SAPAG.Allrightsreserved. 03-12-2004
| Field/Data Type | Value |
|---|---|
| FS Item Set: X-191500FixedAssets | |
| Subitem Set: X-999FixedAssetMovements | From120to299 |
| Exchangerateindicator | 5 |
| Translation key | 1 |
| Translationdifferences: | |
| Item (debit/credit) | 250910 |
| Subitem category | 6 |
| Subitem | 120 |
| Translation entry 030: | |
| FS Item Set: X-170100Investments | From170100to170400 |
| Translation key | 3 |
| Translationdifferences: | |
| Item (debit/credit) | 250920 |
| Subitem category | 6 |
| Subitem | 120 |
| Translation entry 040: | |
| FS Item set: X-250100CommonStock | From: 250100 |
| Translation key | 4 |
| Translationdifferences: | |
| Item (debit/credit) | 250930 |
| Subitem category | 6 |
| Subitem | 120 |
第 243 页 / 共 529 页
AC660 Lesson: Translation and Rounding Differences
Field/Data Type Value
Translation entry 050:
FS Item Set From100000to170099
X-299999 BS-Investments- From170401to191499
MachEquip-CommonStock
From191501to250099
From250101to299999
Exchange rateindicator 5
Translation Key 1
Translation differences:
Item (debit/credit) 250940
Subitem category 6
Subitem 120
Transaction Currency Checkthedefaultbox
Translation entry 060:
FS Item set: From300000to389999
X-389999IncomeStatement
Exchange rateindicator 6
Translation key 5
Translation differences:
Item (debit/credit) 250930
Subitem category 6
Subitem 120
Translation entry 070:
FS Item Set From: 390000
X-299999 BS-Investments-
MachEquip-CommonStock
Exchange rateindicator 6
Continued on next page
233
03-12-2004 © 2004 SAP AG. All rights reserved.
| Field/Data Type | Value |
|---|---|
| Translation entry 050: | |
| FS Item Set X-299999 BS-Investments- MachEquip-CommonStock | From100000to170099 From170401to191499 From191501to250099 From250101to299999 |
| Exchange rateindicator | 5 |
| Translation Key | 1 |
| Translation differences: | |
| Item (debit/credit) | 250940 |
| Subitem category | 6 |
| Subitem | 120 |
| Transaction Currency | Checkthedefaultbox |
| Translation entry 060: | |
| FS Item set: X-389999IncomeStatement | From300000to389999 |
| Exchange rateindicator | 6 |
| Translation key | 5 |
| Translation differences: | |
| Item (debit/credit) | 250930 |
| Subitem category | 6 |
| Subitem | 120 |
| Translation entry 070: | |
| FS Item Set X-299999 BS-Investments- MachEquip-CommonStock | From: 390000 |
| Exchange rateindicator | 6 |
第 244 页 / 共 529 页
Unit4: CurrencyTranslation AC660
Field/Data Type Value
Translation key 5
Translationdifferences:
Item (debit/credit) 251200
Subitem category 6
Subitem 120
a) Todefineatranslation method, youchoose:
Menu Path: Tools→Customizing→IMG→ ExecuteProject→
SAPReferenceIMG→EnterpriseControlling→Consolidation→
Data→AutomaticPosting→CurrencyTranslation→Translation
Methods→DefineCurrencyTranslationMethods
1. Choose and make New entries
Field/Data Type Value
Translationmethod XY-01(XY=chartofaccounts)
Description TranslationmethodGr. ##
Reference exchange rate 5
ind.
Save your entries.
2. Double-click Method Entries folder.
• ChooseNewentriestodefinetheindividualmethodentries.
• Assignthenumber 010to thefirstentry.
Numberallsubsequententriessequentiallyinfurtherincrementsof10.
3. Usethedata for translation entry 010.
IntheFSitemsetblock, nameitem set 1X-191500 (whereX=the
letterforyourgroup(Aforgroup01,Eforgroup05,etc.)).
IntheRestricttoSubitemsblockenterthesetnameX-100(whereX
= theletter for yourgroup)and pressEnter.
ClickonItemSet1andchooseMaintainsetstogotothesetdefinition.
Continued on next page
234
©2004SAPAG.Allrightsreserved. 03-12-2004
| Field/Data Type | Value |
|---|---|
| Translation key | 5 |
| Translationdifferences: | |
| Item (debit/credit) | 251200 |
| Subitem category | 6 |
| Subitem | 120 |
| Field/Data Type | Value |
|---|---|
| Translationmethod | XY-01(XY=chartofaccounts) |
| Description | TranslationmethodGr. ## |
| Reference exchange rate ind. | 5 |
第 245 页 / 共 529 页
AC660 Lesson: Translation and Rounding Differences
This set should only contain the item “Fixed Assets”, restricted to
the opening balance.
Enter a description e.g. Fixed Assets.
Entertheitem191500intheFromvaluecolumn,andsavethisentry.
Place the cursor in the field Subitem Set in the frame for selecting
subitems.
ChooseMaintainSetstogotothesetdefinition
Enter name Opening Balance.
Enterthesubitem100intheFromvaluecolumn. Saveyourentries.
4. In the Type of translation frame, specify the currencytranslation
key 6.
In the Translation differences frame enter the item 250910 forboth
debitsandcreditsandpressEnter. Entersubitem120forbothdebits
and credits.
Savetheentries for thefirstmethodentry.
Usethesameprocedurefortheotherentries. ChoosetheNextEntry
iconatthetopofthepagetocreatethenextmethodentry.
Thedatatobeenteredislistedonthenextpage.
Note: Youhavealreadyentereddataforentry010.
Field/Data Type Value
Translation Entry 010:
FS Item Set: From: 191500
X-191500Fixed Assets
Subitem set: From: 100
X-100OpeningBalances
Translation key 6
Translation differences:
FS Item (debit/credit) 250910
Subitem category 6
Continued on next page
235
03-12-2004 © 2004 SAP AG. All rights reserved.
| Field/Data Type | Value |
|---|---|
| Translation Entry 010: | |
| FS Item Set: X-191500Fixed Assets | From: 191500 |
| Subitem set: X-100OpeningBalances | From: 100 |
| Translation key | 6 |
| Translation differences: | |
| FS Item (debit/credit) | 250910 |
| Subitem category | 6 |
第 246 页 / 共 529 页
Unit4: CurrencyTranslation AC660
Field/Data Type Value
Subitem 120
Translation Entry 020:
FS Item Set:
X-191500Fixed Assets
Subitem Set: From120to299
X-999FixedAssetMovements
Exchange rateindicator 5
Translation key 1
Translation differences:
Item (debit/credit) 250910
Subitem category 6
Subitem 120
Translation Entry 030:
FS Item Set: From170100to170400
X-170100Investments
Translation key 3
Translation differences:
Item (debit/credit) 250920
Subitem category 6
Subitem 120
Translation Entry 040:
FS Item set: From: 250100
X-250100CommonStock
Translation key 4
Translation differences:
Item (debit/credit) 250930
Continued on next page
236
©2004SAPAG.Allrightsreserved. 03-12-2004
| Field/Data Type | Value |
|---|---|
| Subitem | 120 |
| Translation Entry 020: | |
| FS Item Set: X-191500Fixed Assets | |
| Subitem Set: X-999FixedAssetMovements | From120to299 |
| Exchange rateindicator | 5 |
| Translation key | 1 |
| Translation differences: | |
| Item (debit/credit) | 250910 |
| Subitem category | 6 |
| Subitem | 120 |
| Translation Entry 030: | |
| FS Item Set: X-170100Investments | From170100to170400 |
| Translation key | 3 |
| Translation differences: | |
| Item (debit/credit) | 250920 |
| Subitem category | 6 |
| Subitem | 120 |
| Translation Entry 040: | |
| FS Item set: X-250100CommonStock | From: 250100 |
| Translation key | 4 |
| Translation differences: | |
| Item (debit/credit) | 250930 |
第 247 页 / 共 529 页
AC660 Lesson: Translation and Rounding Differences
Field/Data Type Value
Subitem category 6
Subitem 120
Translation Entry 050:
FS Item Set From100000to170099
X-299999BS-Investments-MachEquip- From170401to191499
Common Stock
From191501to250099
From250101to299999
Exchange RateIndicator 5
Translation Key 1
Translation differences:
Item (debit/credit) 250940
Subitem category 6
Subitem 120
Transaction Currency Checkthedefaultbox
Translation Entry 060:
FS Item set: From300000to389999
X-389999IncomeStatement
Exchange rate indicator 6
Translation key 5
Translation differences:
Item (debit/credit) 250930
Subitem category 6
Subitem 120
Translation Entry 070:
Continued on next page
237
03-12-2004 © 2004 SAP AG. All rights reserved.
| Field/Data Type | Value |
|---|---|
| Subitem category | 6 |
| Subitem | 120 |
| Translation Entry 050: | |
| FS Item Set X-299999BS-Investments-MachEquip- Common Stock | From100000to170099 From170401to191499 From191501to250099 From250101to299999 |
| Exchange RateIndicator | 5 |
| Translation Key | 1 |
| Translation differences: | |
| Item (debit/credit) | 250940 |
| Subitem category | 6 |
| Subitem | 120 |
| Transaction Currency | Checkthedefaultbox |
| Translation Entry 060: | |
| FS Item set: X-389999IncomeStatement | From300000to389999 |
| Exchange rate indicator | 6 |
| Translation key | 5 |
| Translation differences: | |
| Item (debit/credit) | 250930 |
| Subitem category | 6 |
| Subitem | 120 |
| Translation Entry 070: |
第 248 页 / 共 529 页
Unit4: CurrencyTranslation AC660
Field/Data Type Value
FS Item Set From: 390000
X-299999BS-Investments-MachEquip-
Common Stock
Exchange rateindicator 6
Translation key 5
Translation differences:
Item (debit/credit) 251200
Subitem category 6
Subitem 120
2. Rounding rules
Definethefollowingroundingrulesinthesequencelisted:
-Annualnetincomeinthebalancesheetandincomestatement: differential
item251200RetainedEarnings-CurrentYear,subitem120Additions
- Balance sheet
-Differentialitem250950CurrencyTranslationAdjustments-Rounding,
subitem 120 Additions
- Income statement
-Differentialitem321300CurrencyTranslationDifference,I/S
Field/Data Type Value
Translation Entry 010:
From: 191500
FS Item Set:
X-191500 Fixed Assets
Continued on next page
238
©2004SAPAG.Allrightsreserved. 03-12-2004
| Field/Data Type | Value |
|---|---|
| FS Item Set X-299999BS-Investments-MachEquip- Common Stock | From: 390000 |
| Exchange rateindicator | 6 |
| Translation key | 5 |
| Translation differences: | |
| Item (debit/credit) | 251200 |
| Subitem category | 6 |
| Subitem | 120 |
| Field/Data Type | Value |
|---|---|
| Translation Entry 010: | |
| FS Item Set: X-191500 Fixed Assets | From: 191500 |
第 249 页 / 共 529 页
AC660 Lesson: Translation and Rounding Differences
Field/Data Type Value
From: 100
Subitem set:
X-100Opening Balances
Translation key 6
Translation differences:
FS Item (debit/credit) 250910
Subitem category 6
Subitem 120
Translation Entry 020:
FS Item Set:
X-191500 Fixed Assets
From 120 to 299
Subitem Set:
X-999FixedAssetMovements
Exchange rateindicator 5
Translation key 1
Translation differences:
Item (debit/credit) 250910
Subitem category 6
Subitem 120
Translation Entry 030:
Continued on next page
239
03-12-2004 © 2004 SAP AG. All rights reserved.
| Field/Data Type | Value |
|---|---|
| Subitem set: X-100Opening Balances | From: 100 |
| Translation key | 6 |
| Translation differences: | |
| FS Item (debit/credit) | 250910 |
| Subitem category | 6 |
| Subitem | 120 |
| Translation Entry 020: | |
| FS Item Set: X-191500 Fixed Assets | |
| Subitem Set: X-999FixedAssetMovements | From 120 to 299 |
| Exchange rateindicator | 5 |
| Translation key | 1 |
| Translation differences: | |
| Item (debit/credit) | 250910 |
| Subitem category | 6 |
| Subitem | 120 |
| Translation Entry 030: |
第 250 页 / 共 529 页
Unit4: CurrencyTranslation AC660
Field/Data Type Value
From170100to170400
FS Item Set:
X-170100 Investments
Translation key 3
Translation differences:
Item (debit/credit) 250920
Subitem category 6
Subitem 120
Translation Entry 040:
From: 250100
FS Item set:
X-250100CommonStock
Translation key 4
Translation differences:
Item (debit/credit) 250930
Subitem category 6
Subitem 120
Translation Entry 050:
FS Item Set From100000to170099
X-299999 BS-Investments-MachEquip- From170401to191499
Common Stock
From191501to250099
From250101to299999
Exchange RateIndicator 5
Translation Key 1
Continued on next page
240
©2004SAPAG.Allrightsreserved. 03-12-2004
| Field/Data Type | Value |
|---|---|
| FS Item Set: X-170100 Investments | From170100to170400 |
| Translation key | 3 |
| Translation differences: | |
| Item (debit/credit) | 250920 |
| Subitem category | 6 |
| Subitem | 120 |
| Translation Entry 040: | |
| FS Item set: X-250100CommonStock | From: 250100 |
| Translation key | 4 |
| Translation differences: | |
| Item (debit/credit) | 250930 |
| Subitem category | 6 |
| Subitem | 120 |
| Translation Entry 050: | |
| FS Item Set X-299999 BS-Investments-MachEquip- Common Stock | From100000to170099 From170401to191499 From191501to250099 From250101to299999 |
| Exchange RateIndicator | 5 |
| Translation Key | 1 |
第 251 页 / 共 529 页
AC660 Lesson: Translation and Rounding Differences
Field/Data Type Value
Translation differences:
Item (debit/credit) 250940
Subitem category 6
Subitem 120
Transaction Currency Checkthedefaultbox
Translation Entry 060:
From300000to389999
FS Item set:
X-389999IncomeStatement
Exchange rateindicator 6
Translation key 5
Translation differences:
Item (debit/credit) 250930
Subitem category 6
Subitem 120
Translation Entry 070:
From: 390000
FS Item Set
X-299999 BS-Investments-MachEquip-
Common Stock
Exchange rateindicator 6
Translation key 5
Translation differences:
Item (debit/credit) 251200
Subitem category 6
Subitem 120
a) Rounding rules
Continued on next page
241
03-12-2004 © 2004 SAP AG. All rights reserved.
| Field/Data Type | Value |
|---|---|
| Translation differences: | |
| Item (debit/credit) | 250940 |
| Subitem category | 6 |
| Subitem | 120 |
| Transaction Currency | Checkthedefaultbox |
| Translation Entry 060: | |
| FS Item set: X-389999IncomeStatement | From300000to389999 |
| Exchange rateindicator | 6 |
| Translation key | 5 |
| Translation differences: | |
| Item (debit/credit) | 250930 |
| Subitem category | 6 |
| Subitem | 120 |
| Translation Entry 070: | |
| FS Item Set X-299999 BS-Investments-MachEquip- Common Stock | From: 390000 |
| Exchange rateindicator | 6 |
| Translation key | 5 |
| Translation differences: | |
| Item (debit/credit) | 251200 |
| Subitem category | 6 |
| Subitem | 120 |
第 252 页 / 共 529 页
Unit4: CurrencyTranslation AC660
Roundingrulesaredefinedinthesamewayastranslationentries,but
youalsoneedtoselecttheRoundingentryindicator.
Define the following rounding entries:
Field/Data Type Value
Rounding entry 010:
FS Item Set: From 251200
X-251200-390000 From 390000
CYRetainedEarningBS&IS
RoundingDifferences:
Item (debit/credit) 251200
Subitem category 6
Subitem 120
Rounding entry 020:
FS Item Set: From100000to290000
X-200000BalanceSheet
Item (debit/credit) 250950
Subitem category 6
Subitem 120
Rounding entry 030:
FS Item srt: From: 300000to: 399999
X-300000
ISincludingRetEarnings
Item (debit/credit) 321300
3. Assignment:
Assign the translation method XY-01 (where XY stands for the chart of
accounts)toconsolidationunitDinthemasterrecord.
Continued on next page
242
©2004SAPAG.Allrightsreserved. 03-12-2004
| Field/Data Type | Value |
|---|---|
| Rounding entry 010: | |
| FS Item Set: X-251200-390000 CYRetainedEarningBS&IS | From 251200 From 390000 |
| RoundingDifferences: | |
| Item (debit/credit) | 251200 |
| Subitem category | 6 |
| Subitem | 120 |
| Rounding entry 020: | |
| FS Item Set: X-200000BalanceSheet | From100000to290000 |
| Item (debit/credit) | 250950 |
| Subitem category | 6 |
| Subitem | 120 |
| Rounding entry 030: | |
| FS Item srt: X-300000 ISincludingRetEarnings | From: 300000to: 399999 |
| Item (debit/credit) | 321300 |
第 253 页 / 共 529 页
AC660 Lesson: Translation and Rounding Differences
- You will use the data monitor to carry out currency translation for
consolidationunitD.Youthereforeneedtodefineonemoretask.
a) Assignment:
AssignthetranslationmethodsthatyoudefinedforconsolidationunitD
forversion100,effective12/CurrentYearbychoosing:
Menu Path: Tools→Customizing →IMG →Execute Project →
SAPReferenceIMG→EnterpriseControlling→Consolidation→
Data→AutomaticPosting→CurrencyTranslation→Translation
Methods→AssignTranslationMethodstoConsolidationUnits. .
Save your entries
4. Defining tasks:
CallthecurrencytranslationtaskCURRTRANandassignittotaskgroup
DATA.
Make sure that currency translation is automatically blocked after it is
executed successfully.
a) To define taskCURR TRAN, choose:
MenuPath: Tools→Customizing→IMG→ExecuteProject→SAP
ReferenceIMG→EnterpriseControlling→Consolidation→Data
→AutomaticPosting→CurrencyTranslation→DefineTask. .
ChooseNewentries,andenterCURRTRANasthenameofyourtask
andTranslationasthetaskdescription(bothshortandmediumtext).
Task category is Currency Translation.
Save your entries.
AssignthistaskwithaNewEntrytothetaskgroupDATAforthedata
monitor by choosing:
Menu Path: Tools→Customizing →IMG →Execute Project →
SAPReferenceIMG→EnterpriseControlling→Consolidation→
Data→Datamonitor→DefineTaskGroup.
GreenArrowbacktothecurrencytranslationoverviewscreen. Select
your method and the check button. Set the active flag by checking
the box.
SelectAutomaticblockingwhenyouassignthetasktothetaskgroup.
Save your entries.
Continued on next page
243
03-12-2004 © 2004 SAP AG. All rights reserved.
第 254 页 / 共 529 页
Unit4: CurrencyTranslation AC660
5. RuncurrencytranslationforconsolidationunitDinthedatamonitor,and
examine the audit trail.
a) Executing a task:
MenuPath: Accounting→EnterpriseControlling→Consolidation
→ Data Collection → Monitor
Run the task from the data monitor by placing your cursor at the
cross-sectionbetweenconsolidationunitDandthetranslationtask.
Choose Update run. Currency translation was only carried out for
consolidation unit D.
244
©2004SAPAG.Allrightsreserved. 03-12-2004
第 255 页 / 共 529 页
AC660 Lesson: Translation and Rounding Differences
Exercise 10: Validation II
193
Exercise Duration: Minutes
Exercise Objectives
After completingthisexercise, youwillbeableto:
• Runavalidationofgroupcurrencyvaluesinthedatamonitor
Business Example
The currency translation task translated the reported financial data of the
consolidationunitDintoUSD.Youwilluseavalidationtomakesurethereported
data isconsistent. You will execute the task to validate standardized financial
data in the data monitor.
Task:
Executing a validation
1. AfterthetaskValidateStandardizedDatarunswithoutfindingerrors,you
want it to be blocked automatically.
Ensurethattheappropriatesettingshavebeenmadeinthetaskgroup.
Execute the validation in the data monitor.
245
03-12-2004 © 2004 SAP AG. All rights reserved.
第 256 页 / 共 529 页
Unit4: CurrencyTranslation AC660
Solution 10: Validation II
Task:
Executing a validation
1. AfterthetaskValidateStandardizedDatarunswithoutfindingerrors,you
want it to be blocked automatically.
Ensurethattheappropriatesettingshavebeenmadeinthetaskgroup.
Executethe validation in the datamonitor.
a) Task:
Tocheckthedefinitionofthetaskgroup,choose:
MenuPath: Tools→Customizing→IMG→ExecuteProject→SAP
ReferenceIMG→EnterpriseControlling→Consolidation→Data→
Data Monitor → Define Task Group ..
SelecttaskDATAandgotothedetailscreenAssigntaskstotaskgroup.
You can see that you already defined the task GROUP VAL and
assigned it to the task group. You also already selected automatic
blockingaftersuccessfulexecutionforthistask.
Assignthevalidationruletotheconsolidationunitsforvalidatingthe
standardizedfinancialdataforperiodcategory2:
MenuPath: Tools→Customizing→IMG→ExecuteProject→SAP
ReferenceIMG→EnterpriseControlling→Consolidation→Data
→ Validationsfor ReportedData and Standardized Data→Assign
Validations to Consolidation Units ..
YourvalidationVXYisassignedtotheConsolidationUnits.
Runthetaskinthedatamonitor(application)byplacingyourcursor
atthecross-sectionbetweenconsolidationgroupG1andthetaskfor
validatinggroupcurrency(consolidatedvalues),andchoosingUpdate
run.
Oncethetaskiscompleted,itisautomaticallyblockedforallconsunits
on the cons group level.
Youshouldnowhaveagreentrafficlightfortheoverallstatus.
246
©2004SAPAG.Allrightsreserved. 03-12-2004
第 257 页 / 共 529 页
AC660 Lesson: Translation and Rounding Differences
Lesson Summary
You should now be able to:
• Examinethetranslationofindividualfinancialstatementvaluesintogroup
currency
• Managecurrencytranslationdifferencesthatdonotaffectnetincomeorthe
ones that affect net income
• Explain rounding differences
247
03-12-2004 © 2004 SAP AG. All rights reserved.
第 258 页 / 共 529 页
UnitSummary AC660
Unit Summary
You should now be able to:
• Determine the need for currencytranslation
• Evaluate currency translation methods
• Use currency translation keys
• Determine exchange rates
• Examinethetranslationofindividualfinancialstatementvaluesintogroup
currency
• Managecurrencytranslationdifferencesthatdonotaffectnetincomeorthe
ones that affect net income
• Explain rounding differences
248
©2004SAPAG.Allrightsreserved. 03-12-2004
第 259 页 / 共 529 页
AC660 Test Your Knowledge
Test Your Knowledge
197
1. Explain the use of currency translation.
2. Whatarecurrencytranslationmethodsusedfor?
3. What are currency translation keysusedfor?
4. The typeisthekeyunderwhichyoudefinethe
exchange rate in the system.
Fillintheblankstocompletethesentence.
5. Whatcausestranslationdifferencesduringcurrencytranslation?
6. Currency translationdifferencesin theincomestatement arepostedtoan
incomestatementitemand affectthenetincome.
Determinewhetherthisstatementistrueorfalse.
□ True
□ False
7. Rounding differences can be used to reconcile
statementitemsthatshouldhavethesamevaluesaftertranslation.
Fillintheblankstocompletethesentence.
249
03-12-2004 © 2004 SAP AG. All rights reserved.
第 260 页 / 共 529 页
TestYourKnowledge AC660
Answers
198
1. Explain the use of currency translation.
Answer: Thecurrencytranslationtaskenablesyoutotranslatefinancialdata
reported by consolidationsunitsin their local currency into the currency
of the consolidation group.
2. Whatarecurrencytranslationmethodsusedfor?
Answer: Currency translation methods indicate the exchange rate used
to translate certain items and explain how any subsequent translation or
rounding differences are to be handled.
3. What arecurrency translation keysused for?
Answer: Different financial statement item sets are normally translated
using different exchange rates. You can usevarious combinations of the
currencytranslationkeyandtheexchangerateindicatortodeterminethese
exchange rates.
4. The exchange rate type is the key under which you define the exchange
rate in the system.
Answer: exchange rate
5. Whatcausestranslationdifferencesduringcurrencytranslation?
Answer: Duringcurrencytranslation, ifcertainitemsaretranslatedusing
particular exchangerates, such astheincome statement usinganaverage
exchange rate, it results in translation differencesbetween the translation
usingthereferenceexchangerateandtheoneusingtheaverageexchange
rate.
6. Currencytranslationdifferencesintheincome statement arepostedtoan
incomestatement itemandaffectthenetincome.
Answer: False
Currency translation differences in the income statement are typically
postedto anincomestatement itemand affect neither thenet incomenor
the retained earnings.
250
©2004SAPAG.Allrightsreserved. 03-12-2004
第 261 页 / 共 529 页
AC660 Test Your Knowledge
7. Roundingdifferencescanbeusedtoreconcilethefinancialstatementitems
thatshouldhavethesamevaluesaftertranslation.
Answer: the financial
251
03-12-2004 © 2004 SAP AG. All rights reserved.
第 262 页 / 共 529 页
Unit4: CurrencyTranslation AC660
252
©2004SAPAG.Allrightsreserved. 03-12-2004
第 263 页 / 共 529 页
Unit 5
Interunit Elimination & Consolidation
201
of Investments
OutlinehowtoperformtheinteruniteliminationintheSAPsystem. Next,define
their own elimination. Explain the fundamental difference between interunit
elimination,whichconsistsofconsolidation-group-basedconsolidationentry,and
consolidationof investments,whichconsistsofnon-consolidation-group-based
consolidationentry. Describethefactthattheinteruniteliminationtaskeliminates
interunit business relationships resulting from goods and services supplied
between the consolidation units. In particular, the following activities are
involved: EliminationofIUpayablesandreceivablesEliminationofIUrevenue
andexpenseEliminationofinvestmentincomeHighlightthefactthattheactivities
arecharacterizedbythefactthatconsolidationunitshavetwo-sidedreceivables
andpayables,expensesandincome,orcostsandrevenueswitheachother. These
shouldbeclearedwithoneanotherfromthegroupperspective.
Unit Overview
At the end of this unit, you will be able to define and perform the interunit
elimination in the SAP system. You will also be able to define you own
elimination.
Unit Objectives
After completing thisunit, you will beableto:
• Definethetasksandmethodsforinterunitelimination
• Explain the interunit elimination method
• Examinethecausesof eliminationdifferences
• Listthebenefitsofandthestepsfordocumentreconciliation
• Compare simultaneous consolidation, step consolidation, and stepwise
simultaneous consolidation
• DescribeConsolidationofInvestmentsutilization
• Use the consolidation of investmentsmethod
253
03-12-2004 © 2004 SAP AG. All rights reserved.
第 264 页 / 共 529 页
Unit5: InterunitElimination&ConsolidationofInvestments AC660
• Explain method assignment for simultaneous consolidation and step
consolidation
• Describethe automaticconsolidationactivities
• Describetwowaystoconveytheconsolidationofinvestmentsactivitiesto
the system
• Explain the customizing settings to enable automatic consolidation of
investments postings
• Discussthepostingprocessforappropriationofretainedearnings
• Describe how dividends and bonus payments are distributed in the
customizingofselecteditemsforconsolidationofinvestments
• Explainactivityinterpretationinaconsolidationgroup
• Describe the consolidation logic in SAP
• Explain the equity method
• Describesubsequentconsolidationinequitymethod
• Compare between HGB and US GAAP/IAS for first and subsequent
consolidation
• Describe the benefits of reclassification
• Differentiatebetween types of reclassification
• Explain periodic reclassification
Unit Contents
Lesson: Interunit Elimination..................................................255
Demonstration: Interunit Elimination Tasks.............................259
Demonstration: Interunit Elimination Methods..........................260
Exercise 11: Interunit Elimination.........................................271
Lesson: Consolidation of Investment.........................................290
Demonstration: Customizing Method Assignment.....................303
Exercise 12: Consolidation of Investments – Methods................313
Exercise 13: Consolidation of Investments - Activities in the
Consolidation of Investments .............................................319
Lesson: Customizing Settings.................................................336
Demonstration: Interunit Elimination in the Consolidation Monitor...348
Lesson: Sequence of Activities ...............................................353
Demonstration: Customizing Settings...................................355
Lesson: Equity Method.........................................................361
Demonstration: Customizing Settings in the IMG......................366
Exercise 14: Consolidation of Investments – Equity Method.........371
Exercise 15: Validation ....................................................379
Lesson: Reclassification.......................................................384
254
©2004SAPAG.Allrightsreserved. 03-12-2004
第 265 页 / 共 529 页
AC660 Lesson: Interunit Elimination
Lesson: Interunit Elimination
Lesson Duration: 40 Minutes
203
Lesson Overview
Thislessonwillcovertheexecutionandmethodsforinterunitelimination. You
willlearnaboutthecausesofeliminationdifferences. Inaddition,youwilllearn
about document reconciliation.
Lesson Objectives
After completingthislesson, youwillbeable to:
• Definethetasksandmethodsforinterunitelimination
• Explain the interunit elimination method
• Examinethecausesof eliminationdifferences
• Listthebenefitsofandthestepsfordocumentreconciliation
Explain the difference between internunit elimination and consolidation of
investments. Describethepartnerrelationshipsthataredefinedinthesubitemof
thefinancialstatementitems. Provideinformationaboutthevariousdependencies
andfactorsthatinfluencetheconfigurationofinterunitelimination. Describethe
interuniteliminationmethod. Outlinethecausesofeliminationdifferences.
Business Example
The group G1 plans to consolidate with SAP by the end of this year. You are
requiredto doa presentation ontheeliminationof intercompanypayables and
receivables for the management. Youalso haveto run interunit elimination as
oneof theconsolidationtasksafter you have translatedthelocal currencydata
and posted the standardizing entries.
Execution and Method
InterunitEliminationThisisanoverviewofthevariousdependenciesandfactors
influencingtheconfigurationofinterunitelimination. Theinterunitelimination
taskisdefinedforeachdimension. Itisstartedintheconsolidationmonitorandis
assignedtoataskgroup. Thetaskcontainsthetaskversion,towhichthemethod
255
03-12-2004 © 2004 SAP AG. All rights reserved.
第 266 页 / 共 529 页
Unit5: InterunitElimination&ConsolidationofInvestments AC660
andthedocument typehasbeen assigned. The document typeis assigned to a
consolidationversion,andthedocumenttypeisassignedanumberrangewithin
this version.
Hint: Systemdocumentation: Task versionLinkbetweenthetaskfor
interunit elimination and method. Methods and document types for
interunit elimination are assigned to the tasks through task versions.
This makes it possible to perform a task differently in the different
consolidation versions.
Interunit Elimination Method
Usethemethodsforinteruniteliminationtospecifyhoweliminationshouldbe
performed.
• Determinetheitem setsthat will be addedup.
• Determinethe financial statement itemsto which any differenceswill be
posted.
• Youcanalsoselectadditionalcontroloptions(theseareonlynecessarywhen
theeliminationdiffersfromthebasicprocedure).
Example
Youmaywanttoapplythefollowingmethodsforinterunitelimination:
• A method for elimination of IU payables and receivables in which the
receivablesandpayablesitemsofconsolidationunitsareoffsetagainstone
another
• AmethodforeliminationofIUrevenueandexpenseinwhichtherevenue
andexpenseitemsofconsolidationunitsareoffsetagainstoneanother
For simplification purposes, the elimination of IU revenue and expense could
beperformedbasedonthereportedrevenues. Weassumethattherevenuesare
offset by expenses in the same amount.
Further Control Options
Youcanconfigureadditionalsettingsforinteruniteliminationforeverymethod.
Thesecontrol parametersinvolvethefollowing:
• Thestrategyforpostingtheeliminationdifferences
• Taking threshold values into account
• Splittingeliminationdifferencesintocurrency-relatedandotherdifferences
• Performing one-sided elimination
• The degreeof detail for document generation
• Posting to the initiated consolidation unit
• Thepostingofdeltadocumentsduringrepeatedinterunitelimination
256
©2004SAPAG.Allrightsreserved. 03-12-2004
第 267 页 / 共 529 页
AC660 Lesson: Interunit Elimination
Definetheadditional controloptionsasnecessary.
Hint: Other Notes
Thecontrolparametersarenotrequiredforthesimpleformofinterunit
elimination. Therefore, ifyouonlywanttooffsetthevaluesofspecific
financial statement items (and any subitems) and post the elimination
differenceswithoutsplitting,youdonothavetoconfigureanyadditional
control parameters.
Figure 60: Interunit Elimination
Interuniteliminationisbasedontheinformationaboutthepartnerconsolidation
unit.
257
03-12-2004 © 2004 SAP AG. All rights reserved.
第 268 页 / 共 529 页
Unit5: InterunitElimination&ConsolidationofInvestments AC660
Figure 61: Interunit Elimination
YoudefinethetasksandmethodsforIUeliminationsinCustomizing. Youshould
createataskforeachoftheinterunitconsolidationproceduressuchaselimination
ofinterunitpayablesandreceivablesorrevenueandexpense. Inamethod, you
specifywhichitemsaretobemutuallyeliminatedandhowyouwanttohandle
any resulting differences.
YouexecuteIUeliminationtasksfromtheconsolidationmonitor.
Figure 62: Interunit Elimination Method
258
©2004SAPAG.Allrightsreserved. 03-12-2004
第 269 页 / 共 529 页
AC660 Lesson: Interunit Elimination
You can create multiple pairs of FS item sets for each IUelimination method.
ThefirstsetinthepaircontainstheFSitemsforelimination,andthesecondset
containsthecorrespondingoffsettingitems. ThesepairsofFSitemsetsrepresent
a trading partner relationship.
To restrict the item values to be eliminated, you can specify the following
characteristicvalues: sub-assignments, consolidationor partner unitsandtheir
attributes, anddocument type. Theselectionisrestrictedto theunitsthat have
theseattributesortothedatarecordsthathavebeenpostedwiththesedocument
types.
Thefollowingstrategiesaresupportedforpostingeliminationdifferencesagainst
one of the units in a pair:
• FS itemsets: Differencesare postedagainst the unit that reportsthedata
for a selected item set.
• Lower/higher value: Differences are posted against the unit that reports
thelower/higherabsolutevalue. Ifyouenterathresholdvalue,noentryis
postedifthedifferencesareabovethespecifiedamount. Youcanonlysplit
thedifferencesintocurrency-relatedandotherdifferencesif thefinancial
dataisreportedinbothtransactionandlocalcurrency.
Demonstration: Interunit Elimination Tasks
Purpose
Todemonstratethevarioustasksininterunitelimination
System Data
System:
Client:
UserID:
Password:
Setupinstructions:
1. Define methods
2. Define document types
3. Showdocumenttype21(eliminationofIUpayablesandreceivables)and
documenttype22(eliminationofexpensesandrevenues)
4. DemonstratetheconfigurationofthetasksintheIMG
5. Document type Detail (such as an elimination posting in the transaction
currency and the group currency)
6. Version-specificcharacteristics(numberrangemaintenanceandautomatic
reversal)
259
03-12-2004 © 2004 SAP AG. All rights reserved.