AC605_EN_Col92_FV_Part_A4 (第2页)

第 41 页 / 共 483 页

AC605 Test Your Knowledge

6. The choice of one of the accounting methods is often determined by the

country-specific legal requirements.

Answer: True

Companiesmustchoosetouseoneoftheaccountingmethodsforgenerating

their legal financial statements. The choice is often determined by the

country-specific legal requirements.

7. The emphasis of the cost-of-sales accounting method is on matching the

revenues for goods or services provided against the related expenses for

the items.

Answer: cost-of-sales

8. Brieflyexplaintheviewof responsibilityreporting.

Answer: YoucanuseEC-PCAtoanalyzeinternalprofitandlossforprofit

centers. Thisallowsyoutoevaluatethedifferentareasorunitswithinyour

company. Youcanstructuretheprofitcentersofyourcompanyaccording

toregion(branchoffices, plants), function (production, sales), or product

(product ranges, divisions).

9. The business purpose of profitability analysis is to provide

profitability-orientedperformanceinformationonthemarketsegmentsor

sales channels of a company.

Answer: profitability analysis

10. Ifanorganizationdividesaccountingintointernalandexternalviewpoints,

which viewpoint does CO represent?

Answer: If an organizationdividesaccountinginto internal andexternal

viewpoints, CO represents internal accounting because it provides

informationforthemanager,whichmeanstotheindividualswhoareinside

an organization and who are charged with directing and controlling its

operations.

11. Actual postings represent the most important source of information in

CO-PA.

Answer: Actual postings

33

2009 © 2009 SAP AG. All rights reserved.

第 42 页 / 共 483 页

TestYourKnowledge AC605

12. EC-PCA allows you to calculate the internal operating results for profit

centers.

Answer: EC-PCA

13. COincludescostandrevenueaccountingandtogetherwiththecomponent,

ProfitCenterAccounting(EC-PCA),itoffersallthecontrollingopportunities

withoutbeinglimitedtothelegalstructuresusedinFinancialAccounting.

Answer: Financial Accounting

14. ProfitCenterAccounting(EC-PCA)isaFinancialAccountingcomponent.

Answer: False

ProfitCenterAccounting(EC-PCA)isastatisticalaccountingcomponent.

15. What are profitability segments?

Answer: Profitabilitysegmentsarethemarketsegmentsorstrategicbusiness

units that are to be analyzed in the profitability analysis. They represent

combinationsofproduct,customerandsalesstructureinformationandcan

containinformationoncompanycodes,businessunitsandprofitcenters.

16. Whichofthefollowingisanindependentaccountingunitwithinaclient?

Answer: C

Companycodeisanindependentaccountingunitwithinaclient.

17. What are profit centers?

Answer: Profitcentersaretheareasofresponsibilitywithinacorporation.

Theseareresponsibleforrevenuesandexpenses,aswellasforcertainassets

andliabilitiesinsomecases. Allprofitcentersarearrangedintoastandard

hierarchy representing the entireorganization.

18. Account-basedCO-PAstoresalltransactionsinthreecurrencies,transaction

currency,localcurrency,andcontrollingareacurrency.

Answer: controlling area

34

©2009SAPAG.Allrightsreserved. 2009

第 43 页 / 共 483 页

第 44 页 / 共 483 页

第 45 页 / 共 483 页

Unit 2

Structures

Unit Overview

This unit introduces you to the organizational structures from a Profitability

Analysis perspective. It helps you to know the data structures used within

ProfitabilityAnalysis. ItexplainstheCO-PAcharacteristicsandvaluefieldsand

thepossibilitiesthatthesystemofferstodefinethesedatastructures.

Unit Objectives

After completing thisunit, you will beableto:

• Describe the various organizational units

• Understand the basic concepts, characteristics and value fields, of an

operating concern

• Defineanoperating concern and itsattributes

• Define data structures

• Identify transaction data structures

• DescribetheCO-PAdatabasestructuresandtheoperatingconcerntemplates

Unit Contents

Lesson: Overview of Operating Concern.....................................36

Exercise 1: Operating Concerns ..........................................45

Lesson: Data Structures........................................................50

Exercise 2: Data Structures................................................59

Exercise 3: Maintain the Operating Concern............................65

35

2009 © 2009 SAP AG. All rights reserved.

第 46 页 / 共 483 页

Unit2: Structures AC605

Lesson: Overview of Operating Concern

Lesson Overview

Thislessondescribesthevariousorganizationalunits. Inaddition, itcoversthe

concepts,characteristics,andvaluefieldsofanoperatingconcern. Italsodefines

an operating concern and its attributes.

Lesson Objectives

After completingthislesson, you will beable to:

• Describe the variousorganizational units

• Understand the basic concepts, characteristics and value fields, of an

operating concern

• Defineanoperating concern andits attributes

Business Example

Themanagementofyourcompanywantstoimplementaprofitabilityaccounting

applicationintheSAPsystem. Asamemberoftheprojectteam,youaresupposed

toadviseonthequestionofwhethertoimplementCO-PAorEC-PCAintheSAP

system. You then will be responsible to implement the selected applications.

Bothcross-companyandcompany-specificreportingofcontributionmarginsis

requiredinmultiplecurrencies. Multidimensionalanalysisofsalesinformation,

cost-of-salesinformation, productionvariances, and period cost informationis

requiredfor thevariousmarket segments. Estimated costs are required for the

actualcostspostedonlyatthemonth-end. Actualperiodcosts(S,G,andA)for

thevariousorganizationalentitiesaretobereflectedatthemonth-end. Analytics

byvaluecategoryandbyincomestatementaccountisrequired.

Forthispurpose,youneedtoidentifytheoperatingconcern,whichrepresentsa

salesandmarketingreportingunitforacorporation. Youalsoneedtounderstand

the concept of characteristicsand value fields.

36

©2009SAPAG.Allrightsreserved. 2009

第 47 页 / 共 483 页

AC605 Lesson: Overview of Operating Concern

Introduction to Organizational Units

Figure 23: Organizational Units

TheoperatingconcernisthekeyorganizationalunitwithinCO-PA.Itdefinesthe

extentofthemarketingandsalesinformationthatcanbereportedincombination

bythiscomponent. Oneor morecontrollingareasareassignedto anoperating

concernwhenorganizationalstructuresaredefined. Inmostcases,corporations

have only a single operating concern, which is recommended for the sake of

simplicityandconvenienceifallcontrollingareasandcompanycodessharethe

same fiscal calendar.

The controllingarea isanorganizational unit delimiting theindependent cost

accounting operations of the organization, such as cost center accounting,

profit center accounting, and order accounting. Company codes are assigned

to controlling areas when organizational structures are defined. Mostly, a 1:1

relationshipexistsbetweenthecompany codeandthecontrollingarea. Notice

that a controlling area can also incorporate several company codes to take

cross-company cost allocations into account.

Thecompanycodeisanindependentaccountingunitwithinaclient. Thelegal

requirementsofabalancesheetoraprofitandlossstatementarefulfilledonthe

companycodelevel. Plantsareassignedtocompanycodeswhenorganizational

structures are defined.

Theplantrepresentsaproductioncenter. Itistheprimaryorganizationalunitin

operations and manufacturing.

37

2009 © 2009 SAP AG. All rights reserved.

第 48 页 / 共 483 页

Unit2: Structures AC605

Basic Concepts: Characteristics and Value Fields

Figure 24: Basic Concepts of CO-PA

Characteristics

• Answerthequestion: WhatdoIwanttoreport on?

• Examples: Divisions,Regions, Products,Customers.

Characteristic Values

• Answerthequestion: WhatvaluescanIhaveforthesecharacteristics?

• Examples: Region South; Region North.

Profitability Segments

• Answerthequestion: Whatisthetechnicaldefinitionofmysaleschannel?

• Examples: CombinationofRegionNorth,ProductProd1,SalesRepMiller.

Value Fields

• Answerthequestion: What performancemeasuresdoIwanttotrackand

analyze?

• Examples: GrossSales,Surcharges,Discounts,Cost-of-Sales.

38

©2009SAPAG.Allrightsreserved. 2009

第 49 页 / 共 483 页

AC605 Lesson: Overview of Operating Concern

Figure 25: Categories of Characteristics

Meaning of Characteristics

Characteristicsare the analyticdimensions of theProfitability Analysis. They

definewhatitemsorobjectstheusercanevaluate. Severalcharacteristics,suchas

salesorganization,customer,andproduct,arepredefinedautomaticallyforevery

operatingconcern. Theseareknownasfixedcharacteristics.

Inadditiontothefixedcharacteristics,upto50non-fixednonfixedcharacteristics

can be added to an operating concern.

Characteristicmaintenanceinthefieldcatalog: Thesenon-fixedcharacteristics

mustbeaddedtothefieldcatalogbeforetheycanbeusedtodefineanewoperating

concern. Thecharacteristicsinthefieldcatalogcanbeaccessedinanyclient.

Thefieldcatalogoriginallycontainssomesuggestedcharacteristicswhichmight

beusedinanewoperatingconcerndefinition. Therearetwowaystoaddother

characteristics to the field catalog:

• Choose an existing field from certain SAP tables, which must be five

characters long or less.

• Createacharacteristicindependently,whichshouldbeginwithWWandbe

four to five characters total.

Behind every characteristic, there is potentially a check table with the valid

characteristicvaluesforCO-PA.Inthisway,thedatathatflowsintoCO-PAare

checked. Whenmanuallycreatinganewcharacteristicinthefieldcatalog, you

candecidewhetherthesystemshouldgenerateachecktableforthis.

39

2009 © 2009 SAP AG. All rights reserved.

第 50 页 / 共 483 页

Unit2: Structures AC605

Figure 26: Categories of Characteristics in Detail

Characteristicscanbecategorizedaccordingtohowandwhentheyaredefined:

• CharacteristicstransferredfromSAPtables: Youcanusecharacteristics

that already exist in other applications when you define your operating

concerns. For example, you can copy the fields from the tables for the

customermasterrecords,materialmasterrecords,andsalesdocuments. You

canalsocopythepartnerrolesdefinedinthestructure,PAPARTNER,inthe

Sales and Distribution, SD, application as characteristics in Profitability

Analysis.

• Newlydefinedcharacteristics: Youcancreateonesthatareonlyrequired

inProfitabilityAnalysis. Toderivethevaluesforthesecharacteristics,you

need todefine your own derivation strategy.

• Predefined characteristics: In addition to the fixed characteristics, a

numberofotherpredefinedcharacteristicsareavailableinthefieldcatalog

andcanbeaddedtoyouroperatingconcern,ifrequired. Theseincludethe

customergroup,customerdistrict,andcountrycharacteristics.

• Fixed characteristics: A number of fundamental characteristics are

automatically predefined in every operating concern. These include the

productnumber,companycode,billingtype,businessarea,andsalesorder

characteristics.

40

©2009SAPAG.Allrightsreserved. 2009

第 51 页 / 共 483 页

AC605 Lesson: Overview of Operating Concern

Figure 27: Categories of Value Fields

Meaning of Value Fields

• Incosting-basedProfitabilityAnalysis,valuefieldsstorethebasequantities

andamountsfor reporting. Valuefieldscaneitherbehighlysummarized,

suchasrepresentingasummaryofcostelementbalances,orhighlydetailed,

suchasrepresentingjustonepartofasinglecostelementbalance.

• Thesales-relatedkeyfigures(e.g. revenuetypes,discounts,surcharges)are

normally presented in a very detailed way. By comparison, items based

on periodiccosts(for example, periodcosttypes) areaggregated. Unlike

characteristics,therearenofixedvaluefieldsforanewoperatingconcern.

ValueField Maintenancein theField Catalog

• All valuefields must exist in the field catalogbefore they can beusedto

defineanewoperatingconcern. Thevaluefieldsinthefieldcatalogcanbe

accessedinanyclient. Thefieldcatalogoriginallycontainssomesuggested

valuefields,whichmightbeusedinanewoperatingconcern. Valuefields

can also be defined independently. These should begin with VV..., and

should be four to five characters in total.

• Youdonotneedtocreatethevaluefieldsforcalculateditems,suchasnet

salesandcontributionmargin. Theseitemsarenormallycalculatedfromthe

basevaluesstoredinthevaluefieldsduringthereportexecutionprogress.

Thisminimizesthenecessarydatastoragerequirements.

FixedBasicKeyFigures(Account-BasedCO-PAonly)

• Inaccount-basedProfitabilityAnalysis,allvaluesareupdatedtoaccounts.

Eachamountisstoredinuptothreedifferentcurrenciesunderfixedbasic

keyfigures, which areaccessed inreporting.

41

2009 © 2009 SAP AG. All rights reserved.

第 52 页 / 共 483 页

Unit2: Structures AC605

Figure 28: Value FieldsWith NewTimeAggregationRules

Youcanusevaluefieldswiththeaggregationrules,AVG(average)andLAS(last)

in CO-PA drill-down reports.

YoudefinethesevaluefieldswhenyoudefinethedatastructuresforProfitability

Analysis.

Defining an Operating Concern and its Attributes

Figure 29: Steps in Defining an Operating Concern

42

©2009SAPAG.Allrightsreserved. 2009

第 53 页 / 共 483 页

AC605 Lesson: Overview of Operating Concern

Youdefinethestructureofyouroperatingconcernwhenyousetupyoursystem.

Thisisdonebyselectingthecharacteristicsyouwanttouseinthedatastructures

of the operating concern.

Incosting-basedProfitabilityAnalysis, youalsoneedtoselect thevaluefields

you want to use.

Thestructureofanoperatingconcernisvalidinallclients.

Figure 30: Defining Operating Concern and Attributes

Theattributesareclient-specificparametersofanoperatingconcern. Theyhave

differenteffects,dependingonthetypeofProfitabilityAnalysisyouareworking

in.

Currency types

Operatingconcerncurrency-Incosting-basedProfitabilityAnalysis,theactual

datais alwaysupdated in theoperating concern currency. You can changethe

operating concerncurrencyaslongasnodatahasbeenpostedintheoperating

concern.

Companycodecurrency-Inadditiontotheoperatingconcerncurrency,youhave

theoptionofstoringalldatainthecurrencyoftherelevantcompanycode. This

makessenseifyourorganizationoperatesinternationallyandisconcernedwith

exchangeratesthatchangedaily. Itallowsyoutoavoiddifferencesduetodifferent

exchangeratesandenablesyoutoreconcileyourCO-PAdatadirectlywithFI.

ProfitcentervaluationInadditiontostoringdatainthesetwocurrenciesusing

thelegalcompanycode,valuationview,youcanalsostoredatainbothofthese

currenciesvaluatedfromtheviewpointofindividualprofitcenters.

Fiscal year variant

43

2009 © 2009 SAP AG. All rights reserved.

第 54 页 / 共 483 页

Unit2: Structures AC605

Thefiscalyearvariantdeterminesthenumberofpostingperiodsforeachfiscal

year. Becauseeachcontrollingareaassignedtotheoperatingconcern,andeach

companycodeassignedtoeachofthecontrollingareas,canhaveitsownfiscal

year variant, the variant you choose for theoperating concern must agreewith

that for the other areas.

44

©2009SAPAG.Allrightsreserved. 2009

第 55 页 / 共 483 页

AC605 Lesson: Overview of Operating Concern

Exercise 1: Operating Concerns

Exercise Objectives

After completingthisexercise, youwillbeableto:

• DescribetheorganizationalstructuresrelevantforProfitabilityAnalysis

• SummarizethetypesofProfitabilityAnalysisintheSAPsystem

Business Example

The group has legal entities in Germany, Italy, and the United States. For this

reason,itmustbeabletoreportsalesandprofitabilitybothacrossthecorporation

in a group currency and in each of the legal entity’s local currency. The sales

managers require summarized sales performance figures, such as revenue,

discounts, andsurchargesbothalongandacrossthelinesofthesalesstructure,

productlines,andcustomers. Theyalsoneedtoviewsalesandmarketingcosts

alongtheselines. Describetheoptionsavailablefortheorganizationalstructures

for CO-PA.

Task 1:

1. Check the basic settings and organizational assignments for the IDEA

operatingconcernusingtheCustomizingMonitor.

Isthecontrollingarea1000assignedtotheIDEAoperatingconcern?

Does the IDEA operating concern have the same fiscal year variants as

the controlling area 1000?

Does the assigned Company Code 1000 also have the same fiscal year

variant?

WhatchartofaccountsdothecontrollingareaandtheCompanyCodehave?

Task 2:

CalltheprofitabilityreportAC605-ORDER(orderanalysis)inthecosting-based

ProfitabilityAnalysis. Selectthereportingdateforthepreviousyear.

1. Obtainanoverviewoftheordersituationwithregardtosalescharacteristics.

Continued on next page

45

2009 © 2009 SAP AG. All rights reserved.

第 56 页 / 共 483 页

Unit2: Structures AC605

Task 3:

CalltheprofitabilityreportAC605-ECPCA(ProfitCenter)inthecosting-based

ProfitabilityAnalysis. Selectthereportingdateforthepreviousyearwithaplan

version.

1. Obtainanoverviewoftheactualdatawithregardtosalescharacteristics.

Profit Center

Strategic Business Unit

Company Code

46

©2009SAPAG.Allrightsreserved. 2009

第 57 页 / 共 483 页

AC605 Lesson: Overview of Operating Concern

Solution 1: Operating Concerns

Task 1:

1. Check the basic settings and organizational assignments for the IDEA

operatingconcernusingtheCustomizingMonitor.

Isthecontrollingarea1000assignedtotheIDEAoperatingconcern?

Does the IDEA operating concern have the same fiscal year variants as

the controlling area 1000?

Does the assigned Company Code 1000 also have the same fiscal year

variant?

WhatchartofaccountsdothecontrollingareaandtheCompanyCodehave?

a) UsethefollowingshortcuttodisplaytheIMG:

IMG–Controlling–ProfitabilityAnalysis–Tools–Analysis–Check

Customizing Settings.

Expand to the IDEA operating concern. Controlling area 1000 is

assigned. TheCompanyCode1000isalsoassignedtothecontrolling

area 1000.

Allhavethesamefiscalyearvariant. ControllingAreaandCompany

Code have the same chart of accounts.

All assigned organizational units are listed in the overview of

the organizational structures of the operational concern; detailed

informationfromtherespectivemasterdataarealsodisplayed.

Continued on next page

47

2009 © 2009 SAP AG. All rights reserved.

第 58 页 / 共 483 页

Unit2: Structures AC605

Task 2:

CalltheprofitabilityreportAC605-ORDER(orderanalysis)inthecosting-based

ProfitabilityAnalysis. Selectthereportingdateforthepreviousyear.

1. Obtainanoverviewoftheordersituationwithregardtosalescharacteristics.

a) SAPmenu→Accounting→Controlling→ProfitabilityAnalysis→

Information System→ Execute Report

Ifrequired,setthecosting-basedProfitabilityAnalysisviaSAPmenu

→Accounting→Controlling→ProfitabilityAnalysis→Environment

→ Set Operating Concern.

ExecuteAC605–ORDERorderusingF8orviaReport–Execute. The

report contains the data on incoming sales orders or revenue. The

differencerepresentstheincomingsalesorders=orderbalancestillto

be processed.

You can evaluate the prorated incoming sales orders or turnover,

differentiatedaccordingtostrategicbusinessunits,salesorganizations,

distributionchannelsanddivisionsusingtheassignedcharacteristics.

Task 3:

CalltheprofitabilityreportAC605-ECPCA(ProfitCenter)inthecosting-based

ProfitabilityAnalysis. Selectthereportingdateforthepreviousyearwithaplan

version.

1. Obtainanoverviewoftheactualdatawithregardtosalescharacteristics.

Profit Center

Strategic Business Unit

Company Code

a) SAPMenu→Accounting→Controlling→ProfitabilityAnalysis→

Information System→ Execute Report

ExecutetheAC605–ECPCAreportusingF8orviaReport–Execute.

ThereportcontainsthedataaccumulatedaccordingtoProfitCenter.

However,reportingisdonehereaccordingtocostofsalesaccounting,

positionvaluesarenot presented inCO-PA.

48

©2009SAPAG.Allrightsreserved. 2009

第 59 页 / 共 483 页

AC605 Lesson: Overview of Operating Concern

Lesson Summary

You should now be able to:

• Describe the various organizational units

• Understand the basic concepts, characteristics and value fields, of an

operating concern

• Defineanoperating concern and itsattributes

49

2009 © 2009 SAP AG. All rights reserved.

第 60 页 / 共 483 页

Unit2: Structures AC605

Lesson: Data Structures

Lesson Overview

Thislessondefinesdatastructuresandidentifiesthetransactiondatastructures. It

alsocoverstheCO-PAdatabasestructuresandtheoperatingconcerntemplates.

Lesson Objectives

After completingthislesson, you will beable to:

• Define data structures

• Identify transaction data structures

• DescribetheCO-PAdatabasestructuresandtheoperatingconcerntemplates

Business Example

Themanagementofyourcompanywantstoimplementaprofitabilityaccounting

applicationintheSAPsystem. Asamemberoftheprojectteamofyourcompany,

youaresupposedtoadviseonthequestionof whether toimplementCO-PAor

EC-PCAintheSAPsystem. Youwillberesponsibletoimplementtheselected

applications. Bothcross-companyandcompany-specificreportingofcontribution

margins is required in multiple currencies. The multidimensional analysis of

sales information, cost-of-sales information, production variances, and period

cost information isrequired for various market segments. Estimated costs are

requiredfortheactualcostspostedonlyatthemonth-end. Actualperiodcosts(S,

G,andA)forvariousorganizationalentitiesaretobereflectedatthemonth-end.

Reportingbyvaluecategoryand byincomestatement accountisrequired. For

thispurpose,youneedtounderstandtheoperatingconcern,datastructures,and

segmentlevel andnonsegmentlevelcharacteristics.

50

©2009SAPAG.Allrightsreserved. 2009

第 61 页 / 共 483 页

AC605 Lesson: Data Structures

Defining Data Structures

Figure 31: Operating Concern Data Structures

Defining Data Structures

To define data structures, copy the required characteristics and value fields to

the operating concern and save them.

ActivatingtheEnvironment(upto4.6BGeneration)

Afteryouhavedefinedtheattributesanddatastructuresofanoperatingconcern,

youmustactivatethemandgeneratetheoperatingenvironment.

Thisprocessgeneratesallthetables,programs,andtechnicalobjectsrequiredto

support the operatingconcernyouhave defined.

After you generate the operating concern and before you activate Profitability

Analysis for data entry, add the valid characteristic values to the check tables

generated for the new characteristics.

Changing the Data Structures

Youmust reactivatetheenvironmentafter youchangethedatastructuresofan

operatingconcern. Forexample,reactivatetheenvironmentafteryouaddanew

characteristic or a value field.

Theregenerationprocessdoesnotaffectanyexistingtransactiondata. Noticethat

italsodoesnotautomaticallyback-populateanynewfieldsforexistingtransaction

dataalthoughthissometimesmaybecarriedoutusingtheCO-PArealignmentor

periodic valuation functions.

51

2009 © 2009 SAP AG. All rights reserved.

第 62 页 / 共 483 页

Unit2: Structures AC605

Theregenerationprocesswillnotaffectanycharacteristicvaluesthathavealready

beenenteredinchecktablesforuser-definedcharacteristics.

Transaction Data Structures

Figure 32: CO-PA Transaction Data Structures (1)

Costing-basedCO-PAstoresitstransactiondatainitsowndatatables,whichare

createdwhenactivatingandgeneratingtheoperatingconcern. Thismeansthatits

datawillneveraffecttheexecutionspeedofareportinanotherCOapplication.

Account-basedCO-PAstoresitstransactiondatainthetransactiondatatablesfor

Overhead CostManagement. Thismeansthatitsdatawillaffect theexecution

speed of reportsfor other COapplicationsthat share thesametransactiondata

tables.

ThedefinitionsofprofitabilitysegmentsforbothCO-PAsubmodulesarestored

in thesametable, CE4XXXX, whereXXXX=operating concern. Thesystem

alwaysaccessesthissegmentdefinitiontablewhenpostingthetransactiondatafor

costing-based or account-based CO-PA.

Profitability segments, which represent the account assignment objects for

profitabilityanalysis, are uniquecombinationsof characteristicvaluesthat the

systemcreatesandnumbersautomaticallyfromtheinformationintheoriginating

transactions.

52

©2009SAPAG.Allrightsreserved. 2009

第 63 页 / 共 483 页

AC605 Lesson: Data Structures

Figure 33: CO-PA Transaction Data Structures (2)

TheCE3... andCE4... tablesworkeffectivelytogethertostorethesummarized

transaction information, both actual and plan, for costing-based Profitability

Analysis.

TheCO-PAdrill-downreportingtoolaccessesthedataintheCE3... andCE4...

tables. LineitemdataandtheinformationfromtheCE1... andCE2... tablescan

be accessedthrough lineitemdisplay features.

53

2009 © 2009 SAP AG. All rights reserved.

第 64 页 / 共 483 页

Unit2: Structures AC605

CO-PA Database Structures

Figure 34: CO-PA Database Structures

The data of CO-PA is divided into characteristics and value fields. The

characteristicsarestoredinthedatadivisionofthetable, CE4xxxx. Thekeyof

theCE4xxxxbasicallyconsistsoftheprofitabilitysegmentnumberthatisusedas

ajoinfieldforthetable, CE3xxxx. Thekeyofthetable, CE3xxxx, consistsof

theprofitabilitysegmentnumberandtheposting-periodandsomeothertechnical

fieldsthatarenotlisted. Thevaluefieldsarespecifiedinthedatadivision.

Thetable,CE4xxxx, representstheprofitabilitysegments,createdbasedonthe

businessconsiderationsthataredefinedwhenanoperatingconcerniscreated. The

table,CE3xxxx,containsthevaluespostedtotheprofitabilitysegmentsthatare

additionallyavailablebrokendownintothepostingperiod. Typicalrecordlengths:

CE4xxxx = 250 bytes, CE3xxxx = 2000 bytes.

54

©2009SAPAG.Allrightsreserved. 2009

第 65 页 / 共 483 页

AC605 Lesson: Data Structures

Segment Level and Non-Segment Level Characteristics

Figure 35: Segment-Level Characteristics

For reasons of performance, we recommend that the number of profitability

segments be kept as low as possible so that the quantity of the totals records

requiredintheprofitabilitysegmentalsoremainslow. Youcanachievethisby

restrictingtheselectionofcharacteristicsfortheprofitabilitysegment.

You can to configure the system so that certain characteristics are not used in

defining profitability segments. The impact of this is that the values for these

non-segment-levelcharacteristicswillappearonCO-PAlineitemsbutwillnotbe

availableforreportingwiththeCO-PAdrill-downreportingtool.

Forexample,youmusthaveaccesstothenumberoftheorderthathasoccurredin

SDineveryCO-PAlineitem(CE1). However,itisnotnecessarytosaveanew

totalsrecordintheobjectlevel(CE3)foreverylineitemthatiscreatedduringthe

transferfromtheSD.Thiswouldcreateasmanysummaryrecordsaslineitems.

Youcanindividuallyadjustthecharacteristicsthathavebeenusedornotusedat

objectlevelandmakedifferentsettingsforthecosting-basedandaccount-based

profitabilityanalysis. Certainfixedcharacteristicsaregenerallynotusedatobject

level. However, thiscan be changed if required.

SAPrecommendsthatdatabesummarizedonahigherlevel,somethingotherthan

thecustomerorproductlevel,foraccount-basedCO-PAtominimizethenumber

ofsummaryrecords. Thisisbecauseitstransactiondataisstoredinthetablesthat

aresharedwithotherManagementAccountingapplications.

55

2009 © 2009 SAP AG. All rights reserved.

第 66 页 / 共 483 页

Unit2: Structures AC605

Operating Concern Templates

Figure 36: Operating Concern Templates

CO-PA provides you with operating concern templates, predefined sample

operatingconcerns,anenvironmentinwhichtodisplaytheCustomizingforthese

operatingconcern,makechangestotheCustomizingsettings,andcopythem.

S_AL: Template for Route Profitability.

S_GO: Cross Industry Template.

S_CP: Consumer Goods Industry Template.

Operatingconcerntemplatesofferthefollowingadvantages:

TheyenableyoutogainaninsightintoProfitabilityAnalysisasademonstration,

withoutyourhavingtoperformextensiveCustomizing. Thismeansthatyoucan

usethetemplatesasabasisforquicklycallingupreports.

The operating concern templatessimplify the Customizing in the profitability

analysis. Ifnecessary,youcanadjustyourCustomizingsettingsforanoperating

concern templateasrequired, copytheseand then use thecopied and adjusted

operating concern productively.

56

©2009SAPAG.Allrightsreserved. 2009

第 67 页 / 共 483 页

AC605 Lesson: Data Structures

Figure 37: Quickstart

Use SAP Operating Concern Templates.

ThisiswhereyoucangainaninitialoverviewofProfitabilityAnalysiswithout

the need to have any specialist knowledge and without the need to have made

any settings previously. Further, operating concerns that have already been

presetareavailable,allowingProfitabilityAnalysistobequicklyintegratedinto

yourproductivesystem. Todothis, youcancustomizetheseoperatingconcern

templates. Atanytime,youcanresetthetemplatestotheiroriginalsettings.

Start the transaction for operating concern templates. The template for the

consumer industry is loaded automatically.

Thedetailsviewprovidesyouwithanoverviewofthedeliveredsettingsandof

themodificationsthatyoucanmake. BychoosingApplicationexamples,youcan

viewreportsandplanning layouts. Thesystemfillsthemwithexampledatato

demonstratemoreclearlyhowtheapplicationworks. Youcandeletetheexample

data later.

Ifyouwanttouseanoperatingconcerntemplateforyourprofitabilityanalysis,

youfirsthavetocopyit. Youcanfindthisfunctionunder“Tools”. Thisisalso

whereyoucanchoosetoresetanoperatingconcerntemplatebackto itsinitial

state.

57

2009 © 2009 SAP AG. All rights reserved.

第 68 页 / 共 483 页

Unit2: Structures AC605

58

©2009SAPAG.Allrightsreserved. 2009

第 69 页 / 共 483 页

AC605 Lesson: Data Structures

Exercise 2: Data Structures

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Understandtheconceptsofvaluefieldsandcharacteristics

• Evaluatethe differentsourcesofcharacteristics

• Explain thesettingsavailablefor value fields

Business Example

Thefollowingrequirementsapplyforthevaluefieldsandcharacteristicsneeded

for profitability reporting in your organization:

Yoursalesmanagerrequiressummarizedsalesperformancefigures,suchasgross

revenue, discounts, andsurchargesbothalongaswellasacrossthelinesofthe

salesstructure,productlines,andcustomersofthecompany. Thesalesmanager

alsowantstoviewsalesandmarketingcostsalongtheselines.

Task 1:

IntheCO-PAsettingsmenu,displayalldefinedcharacteristics.

1. WhatisthetableoforiginfortheCustomerClasscharacteristic?

2. WhatisthechecktablefortheSalesDistrictcharacteristic?

Task 2:

Basedontherequirementsofyourprojectteamdefinedinthecompanyscenario,

youdeterminethatthefollowingcharacteristicsandvaluefieldsarerequiredfor

reporting. In the data structures of the operating concern, determine which of

thefollowingitemsarevaluefields, non-fixedcharacteristics, fixed(delivered)

characteristics, and technical fields:

Customer, Customer Group, Material Group, Controlling Area, Cost

Element,Revenue,CustomerDiscount,ProfitCenter,PriceReduction,Sales

Organization,VariableProductionCosts,SalesDistrict,PostingDate,Fiscal

Year, and Number of Employees.

Note: Theoverviewlistcontainsalluser-definedcharacteristics,default

characteristics,andthecharacteristicsselectedfromthereferencetables.

Itdoesnotincludefixedcharacteristicsortechnicalfields.

Assignthelistofitemsin2-2tothefollowinggroups:

1. Whichcharacteristicsarenon-fixedcharacteristics?

Continued on next page

59

2009 © 2009 SAP AG. All rights reserved.

第 70 页 / 共 483 页

Unit2: Structures AC605

2. Whichcharacteristicsarefixedcharacteristics?

3. Which fields are technical fields?

4. Which fields are value fields?

5. WhataretheaggregationsettingsfortheNumberofEmployeesvaluefield?

Why may you decide to use this field?

6. Display the Strategic Business Unit characteristic. What type of

characteristic istheStrategicBusinessUnit?

7. Display theREGIO(Region) characteristic. Isthecharacteristicgrouped

with another characteristic?

Why and with what consequences?

60

©2009SAPAG.Allrightsreserved. 2009

第 71 页 / 共 483 页

AC605 Lesson: Data Structures

Solution 2: Data Structures

Task 1:

IntheCO-PAsettingsmenu,displayalldefinedcharacteristics.

1. WhatisthetableoforiginfortheCustomerClasscharacteristic?

a) IMG→Controlling→ProfitabilityAnalysis→Structures→Define

OperatingConcern →MaintainCharacteristics

Set theindicator for “all characteristics”.

Searchforthecharacteristic“KUKLA”(customerclassification)

2. WhatisthechecktablefortheSalesDistrictcharacteristic?

a) Select: BZIRKandDetails. ThechecktableisT171.

Task 2:

Basedontherequirementsofyourprojectteamdefinedinthecompanyscenario,

youdeterminethatthefollowingcharacteristicsandvaluefieldsarerequiredfor

reporting. In the data structures of the operating concern, determine which of

thefollowingitemsarevaluefields, non-fixedcharacteristics, fixed(delivered)

characteristics, and technical fields:

Customer, Customer Group, Material Group, Controlling Area, Cost

Element,Revenue,CustomerDiscount,ProfitCenter,PriceReduction,Sales

Organization,VariableProductionCosts,SalesDistrict,PostingDate,Fiscal

Year, and Number of Employees.

Note: Theoverviewlistcontainsalluser-definedcharacteristics,default

characteristics,andthecharacteristicsselectedfromthereferencetables.

Itdoesnotincludefixedcharacteristicsortechnicalfields.

Assignthelistofitemsin2-2tothefollowinggroups:

1. Whichcharacteristicsarenon-fixedcharacteristics?

a) IMG→Controlling→ProfitabilityAnalysis→Structures→Define

OperatingConcern →MaintainCharacteristics

SelectDisplayAllCharacteristicsandChooseDisplay

CustomerGroup,MaterialGroup,andSalesDistrict.

2. Whichcharacteristicsarefixed characteristics?

a) Extras → Fixed Fields

Customer,ControllingArea,ProfitCenter,andSalesOrganization.

Continued on next page

61

2009 © 2009 SAP AG. All rights reserved.

第 72 页 / 共 483 页

Unit2: Structures AC605

3. Which fields are technical fields?

a) PostingDate, Fiscal Year, andCostElement

4. Which fields are value fields?

a) IMG → Controlling → Profitability Analysis → Structures →

OperatingConcern→MaintainValueFields

Select All Value Fields → Display

Revenue, CustomerDiscount, PriceReduction, VariableProduction

Costs, Number of Employees

5. WhataretheaggregationsettingsfortheNumberofEmployeesvaluefield?

Why may you decide to use this field?

a) Select No. of Employees and Detail.

LAS (AVG and SUM also possible).

PeriodvaluesarenormallyaddedtogetherintheInformationSystem

and in Profitability Analysis (CO-PA) planning. This means the

aggregation rule is SUM. The aggregation rules, Last value and

Average, areusefulonlyforrepresentingstatistical, non-cumulative

valuesinvaluefields,whenthemostrecentoraveragevalueisrequired

instead of the sum.

6. Display the Strategic Business Unit characteristic. What type of

characteristic istheStrategicBusinessUnit?

a) IMG→Controlling→ProfitabilityAnalysis→Structures→Define

OperatingConcern→MaintainCharacteristics

SelectAll Characteristics → Display

Select the strategic business unit WWSBU and then Detail:

User-defined field with 8 characters.

7. Display theREGIO(Region) characteristic. Isthecharacteristicgrouped

with another characteristic?

Continued on next page

62

©2009SAPAG.Allrightsreserved. 2009

第 73 页 / 共 483 页

AC605 Lesson: Data Structures

Why and with what consequences?

a) IMG→Controlling→ProfitabilityAnalysis→Structures→Define

OperatingConcern →MaintainCharacteristics

Select: DisplayAllCharacteristics. SelectthecharacteristicREGIO

(notRegionbeforeRel. 4.5)and,inthedetaileddisplay,click: Show

compound characteristic

The REGIO characteristic is grouped with the COUNTRY

characteristic. This takes into consideration that the table for

maintainingthemasterdatavaluesfortheREGIOcharacteristicisalso

maintainedfortheCOUNTRYcharacteristic,becauseregionwithout

countrydoesnothaveaclear, semanticmeaning.

Bydouble-clickingthechecktableT005SfortheREGIOcharacteristic,

theassignmentofthecountrycharacteristicbecomesvisibleaspartof

the selection.

Theresultisthat,whensavingdatanexttotheregion, thecountryis

alsosaved. Whenyoucallareport,thecountryisalsodisplayed,even

ifyouhaveonlyassignedtheREGIOcharacteristictothereport.

63

2009 © 2009 SAP AG. All rights reserved.

第 74 页 / 共 483 页

Unit2: Structures AC605

64

©2009SAPAG.Allrightsreserved. 2009

第 75 页 / 共 483 页

AC605 Lesson: Data Structures

Exercise 3: Maintain the Operating

Concern

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Determinetheattributesoftheoperatingconcern

• Addcharacteristicsandvaluefieldstotheoperatingconcern

Business Example

You need reports in both the group and company currency because your

organization conductsbusinessinforeigncountries.

Your sales manager and product manager ask you which data fields you

specifically require for reporting.

Task 1:

Attributes of the Operating Concern

Youhavedecidedtousebothcompanycodeandoperatingconcerncurrenciesin

costing-based PA.

1. Displaythecurrencysettingsfortheoperatingconcern,IDEA.Whatsettings

are configured?

2. What is the fiscal year variant for IDEA?

Task 2:

Data Structures of the Operating Concern

Yoursalesmanagerhasaskedyoutocheckwhichofthefollowingcharacteristics

are active for the operating concern:

Material Group, Customer, Postal Code

1. Whichofthesecharacteristicsareselectedfortheoperatingconcern?

2. Yourproductmanagerhasrequestedthatthefollowingvaluefieldsbemade

available in the operating concern:

SalesOrderQuantity, Scrap, MarketingProjects

Whichofthesevaluefieldsareconfiguredfortheoperatingconcern?

Continued on next page

65

2009 © 2009 SAP AG. All rights reserved.

第 76 页 / 共 483 页

Unit2: Structures AC605

Task 3:

1. Areownprofitabilitysegmentsformedonthe“IDEA”operatingconcernfor

thecharacteristicsORDERorSALESORDERITEM?

2. When data are posted into the costing-based and account-based IDEA

profitabilityanalysisfor3differentproducts,howmanydatarecords

are posted in the costing-based,

account-based

profitability analysis?

Task 4:

1. What is the status of the operating concern, IDEA? Why could this

information be important?

66

©2009SAPAG.Allrightsreserved. 2009

第 77 页 / 共 483 页

AC605 Lesson: Data Structures

Solution 3: Maintain the Operating

Concern

Task 1:

Attributes of the Operating Concern

Youhavedecidedtousebothcompanycodeandoperatingconcerncurrenciesin

costing-based PA.

1. Displaythecurrencysettingsfortheoperatingconcern,IDEA.Whatsettings

are configured?

a) Youhavedecidedto useboth company code andoperating concern

currencies in costing-based PA.

Displaythecurrencysettingsfortheoperatingconcern,IDEA.What

settings are configured?

IMG→Controlling→ProfitabilityAnalysis→Structures→Define

OperatingConcern→MaintainOperatingConcern: 'Attributes'tab

Operating Concern Currency: EURO

Company Code Currency: selected

OpConCurrency, PrCtr-Valuation: selected

CompCodeCurrency, PrCtr-Valuation: selected

2. What is the fiscal year variant for IDEA?

a) What isthefiscal year variant for IDEA?

K4, CalendarYear + 4 special periods

Continued on next page

67

2009 © 2009 SAP AG. All rights reserved.

第 78 页 / 共 483 页

Unit2: Structures AC605

Task 2:

Data Structures of the Operating Concern

Yoursalesmanagerhasaskedyoutocheckwhichofthefollowingcharacteristics

are active for the operating concern:

Material Group, Customer, Postal Code

1. Whichofthesecharacteristicsareselectedfortheoperatingconcern?

a) Data Structuresof the Operating Concern

Your salesmanager has asked you to check which of the following

characteristicsareactivefortheoperatingconcern:

Material Group, Customer, and Postal Code

Whichofthesecharacteristicsareselectedfortheoperatingconcern?

IMG→Controlling→ProfitabilityAnalysis→Structures→Define

OperatingConcern→MaintainOperatingConcern

Choose → Display and then select the Characteristics tab on the

DataStructuretab. TodisplaythefixedcharacteristicsselectExtras

→ Display Fixed Fields).

MaterialGroup, Customer(fixedcharacteristic)

2. Yourproductmanagerhasrequestedthatthefollowingvaluefieldsbemade

available in the operating concern:

SalesOrderQuantity, Scrap, MarketingProjects

Whichofthesevaluefieldsareconfiguredfortheoperatingconcern?

a) Yourproductmanagerhasrequestedthatthefollowingvaluefieldsare

available in the operating concern:

OrderedQuantity,Scrap,MarketingActivities,andAnnualRebates.

Whichofthesevaluefieldsareconfiguredfortheoperatingconcern?

IMG→Controlling→ProfitabilityAnalysis→Structures→Define

OperatingConcern→MaintainOperatingConcern

ChooseDisplayandselecttheValueFieldstabontheDataStructure

tab.

SalesOrderQuantity,Scrap,andMarketingActivities.

Continued on next page

68

©2009SAPAG.Allrightsreserved. 2009

第 79 页 / 共 483 页

AC605 Lesson: Data Structures

Task 3:

1. Areownprofitabilitysegmentsformedonthe“IDEA”operatingconcernfor

thecharacteristicsORDERorSALESORDERITEM?

a) IMG→Controlling→ProfitabilityAnalysis→Structures→Define

ProfitabilitySegmentCharacteristics(Segment-LvlCharacteristics)

NoprofitabilitysegmentsareformedforthecharacteristicsOrderand

SalesOrderItem. However,thisdoesnotmeanthatthedatacannotbe

evaluatedaccordingtothesecharacteristics. Thelineitemreportand

theprofitabilityreportbasedonlineitemsareavailableforthis.

2. When data are posted into the costing-based and account-based IDEA

profitabilityanalysisfor3differentproducts,howmanydatarecords

are posted in the costing-based,

account-based

profitability analysis?

a) As the PRODUCT characteristic was only excluded for the

account-basedprofitabilityanalysis,whenupdating

• inthecosting-basedprofitabilityanalysisperproduct,

• only1totalsrecordisupdatedintheaccount-basedprofitability

analysis

by comparison. The reason may have to do with the different

information requirements of the users in the account-based or

costing-based profitability analysis.

Task 4:

1. What is the status of the operating concern, IDEA? Why could this

information be important?

a) What isthe status of the operatingconcern, IDEA?Why couldthis

information be important?

IMG→Controlling→ProfitabilityAnalysis→Structures→Define

OperatingConcern→MaintainOperatingConcern: 'Environment'

tab

Status = Active

This meansthat the environment of the operating concern hasbeen

generated,alldatatablesareactive,andattributescreated. Ifanyofthe

steps,Save,Activate,orGeneratehavebeenleftout,nopostingscan

bemadetothetablesoftheoperatingconcern. Thiswouldresultinan

errorinanydatatransactionthataffectstheoperatingconcern.

69

2009 © 2009 SAP AG. All rights reserved.

第 80 页 / 共 483 页

Unit2: Structures AC605

Lesson Summary

You should now be able to:

• Define data structures

• Identify transaction data structures

• DescribetheCO-PAdatabasestructuresandtheoperatingconcerntemplates

70

©2009SAPAG.Allrightsreserved. 2009

第 81 页 / 共 483 页

AC605 Unit Summary

Unit Summary

You should now be able to:

• Describe the various organizational units

• Understand the basic concepts, characteristics and value fields, of an

operating concern

• Defineanoperating concern and itsattributes

• Define data structures

• Identify transaction data structures

• DescribetheCO-PAdatabasestructuresandtheoperatingconcerntemplates

71

2009 © 2009 SAP AG. All rights reserved.

第 82 页 / 共 483 页

UnitSummary AC605

72

©2009SAPAG.Allrightsreserved. 2009

第 83 页 / 共 483 页

AC605 Test Your Knowledge

Test Your Knowledge

1. What does a controlling area represent?

2. In costing-based Profitability Analysis, store the

base quantities and amounts for reporting.

Fillintheblankstocompletethesentence.

3. Statetheimportanceofthefiscalyearvariantinanoperatingconcern.

4. WhichofthefollowingisthehighestreportinglevelwithinCO-PA?

Choosethecorrectanswer(s).

□ A Operating concern

□ B Controlling area

□ C Company code

□ D Plant

5. Thecharacteristics,suchas“salesorganization”,“customer”,“andproduct”,

arepredefinedautomaticallyforeveryoperatingconcernandareknownas

.

Fillintheblankstocompletethesentence.

6. Incosting-basedProfitabilityAnalysis,theactualdataisalwaysupdatedin

the company code currency.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

73

2009 © 2009 SAP AG. All rights reserved.

返回FICO参考资料列表