AC610_EN_Col52_FV_Part_A4 (第9页) | ERP软件技术分享

第 300 页 / 共 339 页

Unit7: InformationSystem AC610

2. Definethegeneralselectionsoftheformbeforetheactuallayout:

Field Name Values

From Period LocalvariableFROMPER

To Period LocalvariableTOPER

Fiscal Year LocalvariableYEAR

Controlling Area 1000

Confirm the general selections.

3. Gotothevariabledefinitionandnamethevariablesasfollows:

Name Description

FROMPER From Period

YEAR Fiscal Year

TOPER To Period

Define the ACTUAL column as the key figure costs/revenues in profit

centerlocalcurrencyrestrictedtothecharacteristicplan/actualindicator0

(actual values).

DefinethePLANcolumnasthekeyfigurecosts/revenuesinprofitcenter

local currencyrestrictedto thecharacteristicplan/actualindicator 1(plan

values) and version 0.

DefinetheVARABScolumnastheformulaACTUAL–PLAN.

Delete column 4.

Definethefirstrowasthecharacteristiclinewithaccountnumber800000

domesticrevenues. Therowtext shouldbesales.

Definethesecondrowasthecharacteristicrowwithaccountnumber893015

Costofgoodssold. TherowtextshouldbeCOGS.

DefinethethirdrowastheformulaSales+COGS.Thisisnecessarybecause

salesarepostedwithanegativesigninProfitCenterAccounting. Therow

text should be contribution margin I.

DefinethefourthrowasthecharacteristicrowwiththeSET3060000.INT

personnelexpense. Therowtextshouldbepersonnel.

DefinethefifthrowastheformulacontributionmarginI+personnel. The

row text should be contribution margin II.

Save the form.

Continued on next page

292

Field Name	Values
From Period	LocalvariableFROMPER
To Period	LocalvariableTOPER
Fiscal Year	LocalvariableYEAR
Controlling Area	1000

Name	Description
FROMPER	From Period
YEAR	Fiscal Year
TOPER	To Period

第 301 页 / 共 339 页

AC610 Lesson: Reporting with Drilldown Reporting

4. Define the ACTUAL column as the key figure costs/revenues in profit

centerlocalcurrencyrestrictedtothecharacteristicplan/actualindicator0

(actual values).

5. DefinethePLANcolumnasthekeyfigurecosts/revenuesinprofitcenter

local currency restrictedto thecharacteristicplan/actual indicator 1(plan

values) and version 0.

6. DefinetheVARABScolumnastheformulaACTUAL–PLAN.

7. Delete column 4.

8. Definethefirstrowasthecharacteristiclinewithaccountnumber800000

domesticrevenues. Therowtext shouldbesales.

9. Definethesecondrowasthecharacteristicrowwithaccountnumber893015

Costofgoodssold. TherowtextshouldbeCOGS.

10. DefinethethirdrowastheformulaSales+COGS.Thisisnecessarybecause

salesarepostedwithanegativesigninProfitCenterAccounting. Therow

text should be contribution margin I.

11. DefinethefourthrowasthecharacteristicrowwiththeSET3060000.INT

personnelexpense. Therowtextshouldbepersonnel.

12. DefinethefifthrowastheformulacontributionmarginI+personnel. The

row text should becontribution margin II.

13. Save the form.

Task 4:

1. Create the report AC610FORM## Coverage Group ## with form

AC610FORM##.

2. Define ledger and profit center as the navigation characteristics. Do not

make any further entries.

3. Fillthevariableswiththedataofthecurrentperiodofthecurrentfiscalyear.

Makesurethatallthevariablescanbeenteredatexecution. Fortheoutput

choosethegraphicaloutputwiththeoutputareasinformation,navigation,

drilldown and detail.

4. Save the report.

5. ExecutereportAC610FORM##forthecurrentperiodofthecurrentfiscal

year.

Continued on next page

293

第 302 页 / 共 339 页

Unit7: InformationSystem AC610

6. Wheredoyouseethelayoutdefinitionfromtheform?

294

第 303 页 / 共 339 页

AC610 Lesson: Reporting with Drilldown Reporting

Solution 15: Reporting with Drilldown

Reporting

Task 1:

You define a basic report.

1. DefinethebasicreportAC610##BasicReportGroup##whichallowsyouto

navigate with the following characteristics:

Field Name Values

ControllingArea 1000

Profit Center CanbeselectedwithlocalvariablePRCTR

Ledger No entry

Company Code No entry

Accountnumber No entry

Origin object No entry

Costsandrevenuesshouldonlybedisplayedinprofitcenterlocalcurrency.

Itshouldbepossibletoenterallvariablesonexecutionofthereport. Forthe

graphicaloutput,thescreenshouldbedividedintoaninformationwindow,a

navigation windowanda drilldown window.

SavereportAC610##. DonotenterahierarchyforthecharacteristicsProfit

Center and Account Number.

a) PCA: Information System → Tools → Drilldown Reporting →

Create Report

Enter AC610## Basic Report Group 01

Click Basic Report as the report type.

Choose the Create pushbutton.

Field Name Values

ControllingArea 1000

Profit Center CanbeselectedwithlocalvariablePRCTR

Ledger No entry

Continued on next page

295

Field Name	Values
ControllingArea	1000
Profit Center	CanbeselectedwithlocalvariablePRCTR
Ledger	No entry
Company Code	No entry
Accountnumber	No entry
Origin object	No entry

Field Name	Values
ControllingArea	1000
Profit Center	CanbeselectedwithlocalvariablePRCTR
Ledger	No entry

第 304 页 / 共 339 页

Unit7: InformationSystem AC610

Field Name Values

CompanyCode No entry

Accountnumber No entry

Origin object No entry

Enterthevalue1000forthecharacteristicControllingArea.

ClicktheVariableon/offindicatorforthecharacteristicProfitCenter.

ThesystemdisplaystheVariableselectionwindow.

EnterPRCTR asthelocal variableandconfirm. VariablePRCTRis

thus only known in report AC610##.

Select the characteristics Company Code, Account Number, and

OriginObject in thelist ofavailablecharacteristics. Click theAdd

characteristic icon.

Costs and revenues should only be displayed in profit center local

currency.

Click the Key figures tab page.

SelectthekeyfigureCosts/revsin PCLCinthelistofavailablekey

figures.

Click the Add key figure icon.

Itshouldbepossibletoenterallvariablesonexecutionofthereport.

ClicktheVariablestabpage. MakesurethattheEntryatExecution

indicator is set for all variables.

Alternatively, you can specify default values at execution for every

variable.

For the graphical output, the screen should be divided into an

informationwindow,anavigationwindowandadrilldownwindow.

Click the Output Type tab page.

Click Graphical report-output.

Choosethecombination Infocontrol, navigation control, drilldown

control under output areas.

SavereportAC610##. Donotenterahierarchyforthecharacteristics

Profit Center and Account Number.

Click Save.

Continued on next page

296

Field Name	Values
CompanyCode	No entry
Accountnumber	No entry
Origin object	No entry

第 305 页 / 共 339 页

AC610 Lesson: Reporting with Drilldown Reporting

Confirmthehierarchyselection. Makesurethatnohierarchyisentered

forthecharacteristicsProfitCenterandAccountNumber.

2. ExecutereportAC610##withthefollowingparameters:

Field Name Values

Profit Center 91##

Period 1 – 12

Fiscal Year Current fiscal year

Plan/ActualIndicator 0

Version 0

a) PCA: Information System → Tools → Drilldown Reporting →

Execute Report

Select report AC610##.

Run the report.

Enter the following parameters:

Field Name Values

Profit Center 91##

Period 1 – 12

Fiscal Year Current fiscal year

Plan/ActualIndicator 0

Version 0

Run the report.

3. Whichcharacteristicsaredisplayedintheinformationoutputarea?

Answer: The characteristic values for controlling area 1000 and profit

center 91## are fixed characteristic values. This is the reason why they

aredisplayedintheinformationoutputarea. Nonavigationispossiblevia

these characteristics.

4. Break down the report by account number. Has an amount been posted

to account 800000?

Answer: Double-click on the characteristic Account Number in the

navigation output area.

Account 800000 has been posted to.

Continued on next page

297

Field Name	Values
Profit Center	91##
Period	1 – 12
Fiscal Year	Current fiscal year
Plan/ActualIndicator	0
Version	0

Field Name	Values
Profit Center	91##
Period	1 – 12
Fiscal Year	Current fiscal year
Plan/ActualIndicator	0
Version	0

第 306 页 / 共 339 页

Unit7: InformationSystem AC610

5. Whichoriginobjectscanyouidentifyforaccount800000?

Answer: Moveaccount800000usingdragand drop tothe characteristic

OriginObjectinthenavigationoutputarea. Profitcenter91##waspostedin

account800000withtheoriginobjectsProfitCenter,BillingDocumentand

Accounting Profitability Segment.

Task 2:

The profit center managers often also want to know the source document for

certain postings.

1. ChangethebasicreportAC610##. AddTransactionKE5Z“ProfitCenter:

Actual LineItems”tothereport/reportinterface.

Save the document.

a) PCA: Information System → Tools → Drilldown Reporting →

Change Report

Double-click report AC610##.

Select the Options tab page.

Click theReport assignmentpushbutton.

ThesystemdisplaystheAssignReportswindow.

Click the Insert row icon. The system displays the Add Drilldown

Report window.

Click theOtherreport type pushbutton.

Select TR Transaction.

Entertransaction codeKE5Z andconfirm.

Save the report assignment.

Save report AC610##.

2. ExecutereportAC610##withthefollowingparameters:

Field Name Values

Profit Center 91##

Period 1 – 12

Fiscal Year Current fiscal year

Plan/ActualIndicator 0

Version 0

Continued on next page

298

Field Name	Values
Profit Center	91##
Period	1 – 12
Fiscal Year	Current fiscal year
Plan/ActualIndicator	0
Version	0

第 307 页 / 共 339 页

AC610 Lesson: Reporting with Drilldown Reporting

Break down the report by account number.

a) PCA: Information System → Tools → Drilldown Reporting →

Execute Report

Select report AC610##.

Runthereport. Enterthefollowingparameters:

Field Name Values

Profit Center 91##

Period 1 – 12

Fiscal Year Current fiscal year

Plan/ActualIndicator 0

Version 0

Breakdownthereport byaccount number.

Double-clickonthecharacteristicAccountNumberinthenavigation

output area.

3. Display the line items for account 430000. Go to the original document

of any line item.

Answer: Clicktheactualcostswiththeaccount430000.

ClicktheCallupreporticon. Theassigneditemreportisstartedimmediately.

Double-click on the line items.

ThesystemdisplaystheoriginalG/Laccountdocument.

Task 3:

Create a form report for plan/actual/comparisons. Management requires two

management-orientatedcostamountstolaydowntheperformance-relatedbonus

payments for the profit center managers.

1. Definetheformonwhichthereportisbased. Firstthesystemdisplaysthe

following overview:

Lead column Actual PLAN VARABS

Sales Account Account ACTUAL -

800000 800000 PLAN

COGS Account Account Actual-Plan

893015 893015

Continued on next page

299

Field Name	Values
Profit Center	91##
Period	1 – 12
Fiscal Year	Current fiscal year
Plan/ActualIndicator	0
Version	0

Lead column	Actual	PLAN	VARABS
Sales	Account 800000	Account 800000	ACTUAL - PLAN
COGS	Account 893015	Account 893015	Actual-Plan

第 308 页 / 共 339 页

Unit7: InformationSystem AC610

Leadcolumn Actual PLAN VARABS

Contribution margin Sales+COGS Sales+COGS Actual-Plan

I

Personnel SET SET Actual-Plan

3060000.INT 3060000.INT

Contribution margin Contribution Contribution ACTUAL -

II margin I + margin I + PLAN

Personnel Personnel

CreateformAC610FORM##FormGroup##asamatrix.

a) PCA: Information System → Tools → Drilldown Reporting →

Create Form

EnterAC610FORM##DescriptionFormGroup##.

Choose "Two axes (matrix)".

Click the Create pushbutton.

ThesystemdisplaystheReportPainterinterfacefordefiningforms.

2. Definethegeneralselectionsoftheformbeforetheactuallayout:

Field Name Values

From Period LocalvariableFROMPER

To Period LocalvariableTOPER

Fiscal Year LocalvariableYEAR

Controlling Area 1000

Continued on next page

300

Leadcolumn	Actual	PLAN	VARABS
Contribution margin I	Sales+COGS	Sales+COGS	Actual-Plan
Personnel	SET 3060000.INT	SET 3060000.INT	Actual-Plan
Contribution margin II	Contribution margin I + Personnel	Contribution margin I + Personnel	ACTUAL - PLAN

Field Name	Values
From Period	LocalvariableFROMPER
To Period	LocalvariableTOPER
Fiscal Year	LocalvariableYEAR
Controlling Area	1000

第 309 页 / 共 339 页

AC610 Lesson: Reporting with Drilldown Reporting

Confirm the general selections.

a) ChooseEdit→Gen. dataselection→Gen. dataselection

SelectthecharacteristicsFiscalYear,Period,andCOAreainthelistof

available characteristics.

Click the Move Selected to Left icon.

ClicktheVariableon/offindicatorfortheFiscalYearcharacteristic.

EnterYEARintheLocalvariablefieldandconfirm.

ClicktheVariableon/offindicatorforcharacteristicPeriod.

EnterFROMPERintheLocalVariablefieldandconfirm.

ClicktheVariableon/offindicatorforcharacteristicPeriodintheTo

column.

EnterTOPERintheLocalVariablefieldandconfirm.

Enterthevalue1000forthecharacteristicControllingArea.

Confirm the general selections.

Click the Confirm pushbutton.

3. Gotothevariabledefinitionandnamethevariablesasfollows:

Name Description

FROMPER From Period

YEAR Fiscal Year

TOPER To Period

Define the ACTUAL column as the key figure costs/revenues in profit

centerlocalcurrencyrestrictedtothecharacteristicplan/actualindicator0

(actual values).

DefinethePLANcolumnasthekeyfigurecosts/revenuesinprofitcenter

local currency restrictedto thecharacteristicplan/actual indicator 1(plan

values) and version 0.

DefinetheVARABScolumnastheformulaACTUAL–PLAN.

Delete column 4.

Definethefirstrowasthecharacteristiclinewithaccountnumber800000

domesticrevenues. Therowtext shouldbesales.

Definethesecondrowasthecharacteristicrowwithaccountnumber893015

Costofgoodssold. TherowtextshouldbeCOGS.

Continued on next page

301

Name	Description
FROMPER	From Period
YEAR	Fiscal Year
TOPER	To Period

第 310 页 / 共 339 页

Unit7: InformationSystem AC610

DefinethethirdrowastheformulaSales+COGS.Thisisnecessarybecause

salesarepostedwithanegativesigninProfitCenterAccounting. Therow

text should be contribution margin I.

DefinethefourthrowasthecharacteristicrowwiththeSET3060000.INT

personnelexpense. Therowtextshouldbepersonnel.

DefinethefifthrowastheformulacontributionmarginI+personnel. The

row text should be contribution margin II.

Save the form.

a) Choose Extras → Variables → Variables Definition and enter the

following descriptions for thevariables:

Name Description

FROMPER From Period

YEAR Fiscal Year

TOPER To Period

Confirm.

4. Define the ACTUAL column as the key figure costs/revenues in profit

centerlocalcurrencyrestrictedtothecharacteristicplan/actualindicator0

(actual values).

a) Double-click column 1.

Choose Characteristics.

Ifnotalreadyselected,selectthecharacteristicplan/actual/indicatorin

the list of available characteristics.

Click the Move Selected to Left icon.

Enterthevalue0foractualvaluesfortheselectedplan/actualindicator.

ClicktheChangeshort,middleandlongtextsicon.

Enter ACTUAL as the short text.

ClicktheCopyshorttextpushbuttonandconfirm.

ClicktheConfirmpushbuttontocompletethecolumndefinition.

Continued on next page

302

Name	Description
FROMPER	From Period
YEAR	Fiscal Year
TOPER	To Period

第 311 页 / 共 339 页

AC610 Lesson: Reporting with Drilldown Reporting

5. DefinethePLANcolumnasthekeyfigurecosts/revenuesinprofitcenter

local currency restrictedto thecharacteristicplan/actual indicator 1(plan

values) and version 0.

a) Double-click column 2.

Choose Characteristics.

Ifnotalreadyselected,selectthecharacteristicplan/actual/indicatorin

the list of available characteristics.

Click the Move Selected to Left icon.

Enterthevalue1forplanvaluesfortheselectedplan/actualindicator.

Selectthecharacteristicversioninthelistofavailablecharacteristics.

Click the Move Selected to Left icon.

Enterthevalue0fortheselectedcharacteristicVersion.

ClicktheChangeshort,middleandlongtextsicon.

Enter PLAN as the short text.

ClicktheCopyshorttextpushbuttonandconfirm.

ClicktheConfirmpushbuttontocompletethecolumndefinition.

6. DefinetheVARABScolumnastheformulaACTUAL–PLAN.

a) Double-click on column 3.

Select Formula.

ClicktheX001pushbuttontoselecttheactualcolumn.

Click thepushbuttonfor the minus sign.

ClicktheX002pushbuttontoselecttheplancolumn.

Confirm the formula.

EnterVARABSastheshorttextforthecolumn.

Click the Copy short text pushbutton.

Confirm.

7. Delete column 4.

a) Position your cursor on column 4.

Click the Delete Element icon.

Continued on next page

303

第 312 页 / 共 339 页

Unit7: InformationSystem AC610

8. Definethefirstrowasthecharacteristiclinewithaccountnumber800000

domesticrevenues. Therowtext shouldbesales.

a) Double-click row 1.

Choose Keyfigure with characteristics.

SelectCosts/revsinprofitcenterlocalcurr. intheKeyFigurefield.

Ifnotalreadyselected,selectthecharacteristicAccountNumberinthe

list of available characteristics.

Click the Move Selected to Left icon.

Enterthevalue800000fortheselectedcharacteristicAccountNumber.

ClicktheChangeshort,middleandlongtextsicon.

Enter Sales as the short text.

ClicktheCopyshorttextpushbuttonandconfirm.

ClicktheConfirmpushbuttoninordertocompletetherowdefinition.

9. Definethesecondrowasthecharacteristicrowwithaccountnumber893015

Costofgoodssold. TherowtextshouldbeCOGS.

a) Double-click row 2.

Choose Keyfigure with characteristics.

SelectCosts/revsinprofitcenterlocalcurr. intheKeyFigurefield.

Ifnotalreadyselected,selectthecharacteristicAccountNumberinthe

list of available characteristics.

Click the Move Selected to Left icon.

Enterthevalue893015fortheselectedcharacteristicAccountNumber.

ClicktheChangeshort,middleandlongtextsicon.

Enter COGS astheshort text for the row.

ClicktheCopyshorttextpushbuttonandconfirm.

ClicktheConfirmpushbuttoninordertocompletetherowdefinition.

Continued on next page

304

第 313 页 / 共 339 页

AC610 Lesson: Reporting with Drilldown Reporting

10. DefinethethirdrowastheformulaSales+COGS.Thisisnecessarybecause

salesarepostedwithanegativesigninProfitCenterAccounting. Therow

text should be contribution margin I.

a) Double-click row 3.

Choose Formula.

Click the Y001 pushbuttonto select row1.

Click the pushbutton for the plus sign.

Click the Y002 pushbuttonto select row2.

Confirm the formula.

EnterContributionmarginIastheshorttextfortherow.

Click the Copy short text pushbutton.

Confirm.

11. DefinethefourthrowasthecharacteristicrowwiththeSET3060000.INT

personnelexpense. Therowtextshouldbepersonnel.

a) Double-click row 4.

Choose Key figure with characteristics.

SelectCosts/revsinprofitcenterlocalcurr. intheKeyFigurefield.

Ifnotalreadyselected,selectthecharacteristicAccountNumberinthe

list of available characteristics.

Click the Move Selected to Left icon.

Click the SET on/off indicator.

Enter the value 3060000. INT Personnel expense as the SET and

confirm.

ClicktheChangeshort,middleandlongtextsicon.

Enter Personnel as the short text.

ClicktheCopyshorttextpushbuttonandconfirm.

ClicktheConfirmpushbuttoninordertocompletetherowdefinition.

Continued on next page

305

第 314 页 / 共 339 页

Unit7: InformationSystem AC610

12. DefinethefifthrowastheformulacontributionmarginI+personnel. The

row text should be contribution margin II.

a) Double-click the fifth row.

Select Formula.

ClicktheY003pushbuttontoselectcontributionmarginI.

Click the pushbutton for the plus sign.

ClickontheY004pushbuttontoselectPersonal.

Confirm the formula.

EnterContributionmarginIIastheshorttextfortherow.

Click the Copy short text pushbutton.

Confirm.

13. Save the form.

a) Click Save.

Task 4:

1. Create the report AC610FORM## Coverage Group ## with form

AC610FORM##.

a) PCA: Information System → Tools → Drilldown Reporting →

Create Report

EnterAC610FORM## CoverageGroup ##.

ClickReportwithformandenterAC610FORM##.

Choose the Create pushbutton.

2. Define ledger and profit center as the navigation characteristics. Do not

make any further entries.

a) ThecharacteristicsLedgerandProfitCenterarepreassigned.

Continued on next page

306

第 315 页 / 共 339 页

AC610 Lesson: Reporting with Drilldown Reporting

3. Fillthevariableswiththedataofthecurrentperiodofthecurrentfiscalyear.

Makesurethatallthevariablescanbeenteredatexecution. Fortheoutput

choosethegraphicaloutputwiththeoutputareasinformation,navigation,

drilldown and detail.

a) Click the Variables tab page.

Enter the following data:

Name Description

From Period Current Period

To Period Current Period

Fiscal Year Current fiscal year

MakesurethattheEntryatExecutionindicatorisset.

Click the Output Type tab page.

Click Graphical report-output.

Choose the combinationInfo control, navigation control, drilldown

control, detail controlunder Output areas.

4. Save the report.

a) DonotenterahierarchyforthecharacteristicsProfitCenter.

5. ExecutereportAC610FORM##forthecurrentperiodofthecurrentfiscal

year.

a) PCA: Information System → Tools → Drilldown Reporting →

Execute Report

Double-click report AC610FORM01.

Enter the following data:

Name Description

From Period Current Period

To Period Current Period

Fiscal Year Current fiscal year

Run the report.

6. Wheredoyouseethelayoutdefinitionfromtheform?

Answer: ThedetailoutputareashowstheReportPainterformwiththetotal

of thevalues displayedin thedrilldown area.

307

Name	Description
From Period	Current Period
To Period	Current Period
Fiscal Year	Current fiscal year

Name	Description
From Period	Current Period
To Period	Current Period
Fiscal Year	Current fiscal year

第 316 页 / 共 339 页

Unit7: InformationSystem AC610

Lesson Summary

You should now be able to:

• defineyourownbasicandform-baseddrilldownreports

308

第 317 页 / 共 339 页

AC610 Unit Summary

Unit Summary

You should now be able to:

• usethestandardreportsanddefineyourownbasicandform-basedreports

• use a drilldown report

• defineyourownbasicandform-baseddrilldownreports

309

第 318 页 / 共 339 页

UnitSummary AC610

310

第 319 页 / 共 339 页

AC610 Test Your Knowledge

Test Your Knowledge

1. Profitability Analysisusesdrilldown reports as a reporting tool. For this

reason,profitcenterdataisanalyzedusingdrilldownreportsonly.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

2. Profit Center Accounting features both basic drilldown reports and

form-based drilldown reports.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

311

第 320 页 / 共 339 页

TestYourKnowledge AC610

Answers

1. Profitability Analysis uses drilldown reports as a reporting tool. For this

reason,profitcenterdataisanalyzedusingdrilldownreportsonly.

Answer: False

In Profit Center Accounting, you can use Report Painter reports, Report

Writerreports, ALVreports, anddrilldownreports.

2. Profit Center Accounting features both basic drilldown reports and

form-based drilldown reports.

Answer: True

312

第 321 页 / 共 339 页

AC610 Course Summary

Course Summary

You should now be able to:

• DescribethebusinesspurposesofProfitabilityAnalysisandProfitCenter

Accounting in the SAP system

• identify information which can be obtained in Profitability Analysisand

Profit Center Accounting

• ClarifytheaspectandscopeofprofitabilitymanagementintheSAPsystem

Related Information

Recommended Follow-up Activities

• GothroughtheexercisesusingIDESdataoryourowndata

• Read on-line documentation

• Read IMG documentation

• Read release notes

313

第 322 页 / 共 339 页

CourseSummary AC610

314

第 323 页 / 共 339 页

Appendix 1

Figure 101: MM Goods movement

Thegraphicillustrateshowthesystemdeterminestheprofit center for an MM

goods movement. The data in the MM document is posted in Profit Center

Accountingtotheprofitcenterdeterminedbythesystem.

Asyoucanseefromthegraphic, theprofitcenter foranMMgoodsmovement

canbedeterminedeitherdynamicallyorindirectlyviatheprecedingdocument.

Figure 102: Invoice receipt

315

第 324 页 / 共 339 页

Appendix 1: AC610

Thegraphicillustrateshowthesystem determinestheprofit centerfor an MM

goodsreceiptposting. ThedataintheMMdocumentispostedinProfitCenter

Accountingtotheprofitcenterdeterminedbythesystem.

When a goods receipt posting is made, the profit center is always determined

indirectly via the preceding document.

Figure 103: Posting in FI and in FI-AA

The graphic illustrates how the system determines the profit center for FI and

FI-AA postings. In Profit Center Accounting, the data in the FI or FI-AA

documentispostedtotheprofitcenterdeterminedbythesystem.

The profit center is always determined dynamically from the FI or FI-AA

document.

Figure 104: SD billing document

Thegraphicillustrateshowthesystemdeterminestheprofitcenterforabilling

document. InProfitCenterAccounting,thedatainthebillingdocumentisposted

to the profit center determined by the system.

For a billing document, the profit center is - with one exception - always

determinedindirectly viathepreceding document.

316

第 325 页 / 共 339 页

AC610 Appendix 1:

Theexceptiontothisruleisabillingdocumentwithvaluatedprojectstock. With

thistypeofbillingdocument,theprofitcenterisdetermineddynamicallyfromthe

WBSelementcontainedintheactualbillingdocument.

With cross-company transactions, the sales order item always contains the

supplying profit center.

Thisprofitcenterisusedbothfortheinternalsettlementandthegoodsissue(see

normal case in the graphic).

Theprofitcentermakingthesalemustbedeterminedusingasubstitutionwhen

thecustomerbilling document iscreated (see cross-company transaction in

the graphic).

ALE Scenarios in Profit Center Accounting

• Centralized Profit Center Accounting

• Decentralized Profit Center Accounting

Masterdataismaintainedcentrallyandthendistributed

AprofitcentercanbepostedtoalldecentralizedsystemswherePCA

is activated

SummarizedrecordsaretransferredperiodicallytotheCentralSystem

ApplicationLinkEnabling(ALE)isexplainedindetailinthedocumentationALE

IntroductionandOverview. Thereyouwillalsofindachapterdealingspecifically

withProfitCenter Accounting. Tolearnhowto set updistributionusing ALE,

see Customizing.

Application Link Enabling scenarios have been implemented in Profit Center

AccountingtoallowyoutodecentralizeyourProfitCenterAccounting.

Figure 105: Centralized Profit Center Accounting

317

第 326 页 / 共 339 页

Appendix 1: AC610

Thelineitemsarestoredlocallyinthehomesystemoftherelevantprofitcenter.

Ifapostingismadetoaprofitcenter,whichisnotinthehomesystemoftheprofit

center,thelineitemsarepostedwithreferencetotheoriginatingdocument.

You can analyzethelineitems andtotals recordsof aprofit center initshome

system. Ifyouwanttoexecutereportsforallprofitcenters,youhavetotransfer

the line items and total records from the different local systems to the central

system after period-end closing. The data is stored there in a “rollup ledger”,

ledger 8C. This ledger is generated automatically in the logical system of the

controllingareaifyouselectedtheALEdistributionmethod“2”inCustomizing.

Thisensuresthatnodatafromthelocalsystemsisimportedmorethanonce.

If you transfer planning data from other applications, do this in the system

wherethedatawasgeneratedoriginally. Thedataisthensenttoallthesystems

concerned in the same way as actual data,

Profitcenterscanonlybeplannedmanuallyinyourhomesystem.

Figure 106: Profit Center Reporting in BW

318

第 327 页 / 共 339 页

AC610 Appendix 1:

Figure 107: Business Information WarehouseArchitecture

319

第 328 页 / 共 339 页

Appendix 1: AC610

320

第 329 页 / 共 339 页

Appendix 2

Data Structures for Report Painter and

Report Writer Reports

Figure 108: List-oriented Reports: Report Painter

TheInformationSystemoffersyoutheoptionofevaluatingposteddataaccording

to various criteria. The SAP System contains a range of standard reports. In

additiontostandardreportsyoucanalsousetools,suchasdrilldownreporting,to

define your own reports.

In the information system, you can evaluate posted transaction data online

immediatelyafter processingintheSAPsystemandfollowitsoriginsdownto

the document level.

Formoreextensivedataselectionyoucanexecuteallreportsavailableonlinein

thebackgroundatpredefinedtimesorschedulethemusingtheScheduleManager.

321

第 330 页 / 共 339 页

Appendix2: DataStructuresforReportPainterandReportWriterReports AC610

Figure 109: The Report Painter Concept:

TheReportPainterisbasedonagraphicaluserinterface. Thisinterfaceconsists

of rowsandcolumnsand displaysthereportasit will finallyappearwhenyou

execute it (WYSIWYG).

The library defines which database fields (characteristics, key figures, and

predefinedcolumns)canbeusedinReportPainterandReportWriterreports. All

ReportPainterandReportWriterreportsareassignedtoalibrary. Eachlibraryin

turnisassignedtoonedatabasetableordatastructure.

You define the report using the characteristics, key figures, and predefined

columns that you selected in the library.

Figure 110: Reporting table GLPCT

Threedatabasetables,GLPCT,GLPCAandGLPCP,arehiddenbehindreporting

tableGLPCT.ThisisfixedinthetaxtablesoftheReportWriter.

TableGLPCT containsthetotalsrecordsofProfitCenterAccounting, whereas

GLPCAcomprisestheactuallineitemsandGLPCPtheplanlineitems.

322

第 331 页 / 共 339 页

AC610 Appendix2: DataStructuresforReportPainterandReportWriterReports

Figure 111: Access Structure of the Report Writer

Characteristics and key figures from line item tables GLPCAand GLPCP are

alsoavailablewhenalibraryiscreatedforreportingtableGLPCT,andnotjust

fields from totals record table GLPCT.

UseonlycharacteristicsandkeyfiguresfromtotalsrecordtableGLPCTinreports.

Otherwiselineitemsareselectedwhichcanleadtoperformanceproblems.

Whichtableisactuallyreaddependsonthekeyfigureusedinthereport.

Library8A2 containsthe characteristicsand keyfiguresfromthetotalsrecord

tableand should becopied for in-housereports.

Library 8A3 contains characteristics and key figures from the line item tables

andshouldonlybeusedinspecialcasesandwithgoodreasonasotherwisethis

cancauseseriousperformanceproblems. Forexample, periodicallytransferred

valuesaredisplayedusingstandardreportswhichaccessthecharacteristicsand

keyfiguresfrom thelineitemtablevialibrary8A3.

Reporting table GLPCOP contains characteristics and key figures which are

requiredforreportingopenitemsandwhicharestoredinspecialdatabasetables.

Library8A4containsthesecharacteristicsandkeyfigures.

323

第 332 页 / 共 339 页

Appendix2: DataStructuresforReportPainterandReportWriterReports AC610

Figure 112: Report/Report Interface

Thereport/reportinterfaceletsyouexecuteotherReport Painterreport groups,

ABAPreports,drilldownreportsandtransactionsfromadisplayedreportlist.

Onceyouhaveselectedanindividualcell,row,column,orblock,youcanbranch

directlytoanother ProfitCenterAccountingstandardreport, bychoosingGoto

→Callupreport. Thevaluesintheselectedareaofthereportserveasselection

criteria for the report you call up.

ProfitCenterAccountingReportingallowsyoutoaccessoriginalreportsofCost

CenterAccountingwhensearchingforthecauseofcertainprofitdimensions. An

example of this is shown on the slide.

Notethat,whenbranchingfromtheprofitcenterreports,theselectedvalueswill

only be passed on automatically as selection criteria if you call up a different

profitcenterreportoracostcenterreport. Otherwise,youbranchtotheselection

screen of the report you called up instead.

324

第 333 页 / 共 339 页

AC610 Appendix2: DataStructuresforReportPainterandReportWriterReports

Figure 113: Information System: Data Source

When you save reports in extracts, you can access the stored data quickly.

Extracts of reports for groups (for example, profit center groups) also support

navigationwithinthegroup. Ifyoucreateanextractforagroup,youcanuseitto

callupareportforeachindividualprofitcenterinthegroup.

You can choose to access existing extractsfor aReport Painter report, which

allows you to display a report (for a closed period, for example) with a

significantly shorter runtime.

• Youcanalsochoosetoselectdatafromthedatabase,whichallowsyouto

createabasicreportusingthelatestinformation.

Whenyouuseanextracttodisplaythelineitemsofareportrow,theSAPsystem

automaticallyaccessesthelatestrecordsfromthedatabase.

To create extracts, you can answer the dialog window query with “Yes” when

leaving thecompleted report. The selection parameters and the timeof report

creationautomatically characterizethe extract.

Inextractmanagement,youdeterminewhetherandhowthereportcall-upsaccess

existing extracts.

Hint: Anotheralternativeistoreaddatafromthearchive,usingreports

to display archived information.

325

第 334 页 / 共 339 页

Appendix2: DataStructuresforReportPainterandReportWriterReports AC610

326

第 335 页 / 共 339 页

Appendix 3

Line Item Reporting

Figure 114: Line Item Report: Selection

Theactuallineitemreportletsyouselectindividualpostingsaccordingtovarious

selection criteria (profit center, revenue/cost element, posting date). It is only

availableifyoursystemstoresactuallineitemsfortherelevantcontrollingarea

andfiscalyear. ThelineitemsarestoredintableGLPCA.

The actual line item report also functions as a list of actual costs because it

displayspostingdocuments. All theselected lineitemsareshowninlistform.

Youcandecidehowmuchdetailyourequireinthereportsinceyoucananalyze

the line itemswith varying degrees of detail.

327

第 336 页 / 共 339 页

Appendix3: LineItemReporting AC610

Relevantreportinformation,suchasselectedfieldsandtheirorder,isstoredinthe

displayvariant. SeveralstandarddisplayvariantsaredefinedintheSAPsystem.

Furtherdisplayvariantscanbedefinedinteractivelyatapplicationlevel.

Plan Line Items: You can display plan line items in Profit Center Accounting

if your system storesplan line itemsfor thedesired controlling areaand fiscal

year(definedinCustomizing). Ifthisisthecase, theplanlineitemsarestored

in table GLPCP.

Figure115: LineItem Report: MaintenanceofDisplayVariants

The SAP systemoffers several standard display variants. The displayvariants

function lets you change the column structure of the list. The field selection

includes a number of additional fields from the profit center line items (e.g.

informationaboutthecostcenter,orders),additionalcurrencies,andsoon. You

can also choose groupsof fieldsfromthefield selectionbychangingtheField

group. Fromthesetofallavailablefields(includingcustomer-specificfields)you

canchooseasmanyasyouwantforacompany-specificdisplayvariant.

Dependingonthewidthofthecolumn,theSAPsystemautomaticallydisplaysthe

shorttextorlongtextversionofthefieldname,usingyourlogonlanguage(ifthis

language is available for the report).

328

第 337 页 / 共 339 页

AC610 Appendix 3: Line Item Reporting

Onceyouhaveexecutedalineitemreport,youhavethefollowingdisplayoptions:

• Horizontal scrolling by column

• Hide/show columns

• Change order of columns

• Sort list according to certain criteria

• Totals for value columns

• Subtotals for each object in a column

• Original Document Display

• Filter Function

329

第 338 页 / 共 339 页

Appendix3: LineItemReporting AC610

330

第 339 页 / 共 339 页

Feedback

SAP AG has made every effort in the preparation of this course to ensure the

accuracy and completeness of the materials. If you have any corrections or

suggestionsforimprovement,pleaserecordthemintheappropriateplaceinthe

course evaluation.

331