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

第 314 页 / 共 509 页

Unit7: Planning AC220

Version 1/Quarter 2

Version 2/Quarter 2

(Quarter 1is defined via interval period1 to 3.)

Figure 133: Value Columns (1)

Definitionofanormalcolumnwithcharacteristicsorkeyfigures: Valuecolumns

aredefinedusingkeyfigures,suchastransactioncurrency,currency2,currency

3,quantity,oradditionalquantity. Youdeterminewhetherornotyoudisplaythe

valuefieldsintherowsorcolumnswhenyoudefinethefirstelementofthelayout.

Ifyoudefineavaluefieldinaroworcolumn, youcandefinethisfurtherusing

characteristics. Intervalsofcharacteristicvaluesarenotpermittedinacolumn.

Definitionofanattributecolumn: Thefollowingattributesareavailable:

DistributionKey: Youusethedistributionkeytodistributecumulativevaluesto

theperiodvalues. Youcan,forexample,representseasonaltrendsintheperiods

ofafiscalyearusingthedistributionkey. Ifnodistributionkeyisselected, the

systemdistributesinananalogousmanner. Inotherwords,ifnodataisavailable,

data is distributed evenly and when data is available, the data is distributed

analogous to this.

Unit: Youassignavaluefieldtoacurrencyorquantity.

If you select theattribute unit when planning iscarried out, thisfieldcontains

either thequantityortheassociatedcurrency, depending ontheassignedvalue

field. Ifyouhavedefinedvariouscharacteristicsorcharacteristicvaluesinyour

columns, youhaveto definethecharacteristicswiththerelevant characteristic

valuesagainwhiledefiningthedistributionkeyandunitattributes.

Formulainthelayout: Youcandefineformulacolumnsandrowsconsistingof

thevaluesofthecolumnsalreadydefined. Theseformulaeareautomaticallyset

to not ready for input.

296

第 315 页 / 共 509 页

AC220 Lesson: Settings in FI-SL Planning

Figure 134: Value Columns (2)

Youneedtodefinevaluecolumnsthatyouwanttodisplay(andnotfillwithplan

values)asnotreadyforinput. If,forexample, youwanttoplanthetransaction

currencyandyoudonotwanttoplancurrency2and/orcurrency3manuallybut

youwanttodisplaythetranslatedplanvalues,youflagthesecolumnsasnotready

forinput. YoucandothisbyselectingFormat→Readyforinput.

Ifyouwanttodisplaytheactualvaluesforakeyfigure,youhavetoincludethe

recordtype0forthiscolumn. Inthiscase,youhavetodeterminetherecordtype

forplandatafortheothercolumns. Ifallcolumnsaretodisplayplandata,youcan

enterrecordtype“Plan”as“commondenominator”inGeneralselections.

Planner Profile

PlannerProfile: Youcanassignanauthorizationgrouptoeachplannerprofile.

You can assign differentiated authorizations to create planning data through

the combinationof authorizationgroupsand default parametersthat cannot be

overwritten.

Youassign summary tables toeach planner profile that you want to useasthe

basis for your planning. You can store distribution keys as default values for

currency andquantityfieldsfor eachassignedtable.

You assign planning tasks to each table. The position is used to determine in

which order the planning tasks are done.

Theindicatorfordefaultparametersspecifieswhetherornotdefaultparameters

are created for your plan task. You can determinewhether or not your default

parameterscanbeoverwrittenduringplanning. Iftheindicatorisset,thedefault

valuesareproposalsthatyoucanoverwriteduringplanning. Ifthisindicatorisnot

active, the preassignment cannot bechanged.

Youcanspecifywhetherornotyourplandataisreadandsummarized.

297

第 316 页 / 共 509 页

Unit7: Planning AC220

With Excel integration, you determine whether or not Microsoft Excel can be

usedto createplandata. If Excelintegrationisactivated, youmust enter afile

name in the file description field.

You can enterthedocumenttypefor planlineitems.

Youcanspecifywhichofthefieldsincludedinyourplanninglayoutforcurrencies

andquantitiesarereadyfor input duringplanning.

Default parameters: You can assign default parameters to each planning task.

Enter the values. Thesevalues appear asdefault valuesonthe initial planning

screen. Plan Tasks for a Planner Profile.

Whenyouplan,yousetyourplannerprofileandthesummarytabletoenteryour

planningdata. Theplanninglayoutsareprovidedforyouintheorderspecifiedfor

eachplantaskforthetablespecified. Youcannavigatefromonelayouttoanother

to enter your plan values in the table.

Ifthedefaultparametersfunctionisactivatedinyour task, youcandisplaythe

defaultvaluesontheentryscreenforeachlayoutandoverwritethemifnecessary.

Withdefaultparameters,youalsohavetwooptionstoenteryourplanvalues,:Ÿ

Freeentryof recordsnot planned: Thisindicator specifieswhether ornot only

valuesfor which plan data already existsonthe database are displayed for the

characteristics. Here,newcharacteristicvaluescanbecreatedandinsertedinthe

rows. Form-basedentry: Ifyousetthisindicator,allvaluesforthecharacteristics

with valid master data are displayed. In other words, no attention is paid to

whetherornotplandataexists. Instead,thesamestructureofcharacteristicvalues

isdisplayedineachplanningsession. EnteringPlanData

Several help functions are available for you to use during planning. These

functions include changing distribution keys for each combination, ensuring

scaling for units, setting decimal places, displaying possible combinations,

branchingtoavalidcombinationofyourchoice,displayingleadcolumnswithor

withouttotals,showing/hidingheaderfields,andbranchingtolineitemdisplay.

Inaddition,youcanrevaluateselected,readyforinputdatacellswithapercentage

rate or add values to these cells. You can also enter a negative sign. During

“revaluation”, thesystem subtractsthevalue calculated from the selected cells

using the relevant percentage rate. You can also enter a negative sign when

adding. Whileyou“add”,thesystemsubtractstherelevantvaluefromtheselected

data cells.

Overview Screen and Period Screen

You can branchwithintheperiodscreentodisplay or enter individualperiods.

Copy Data to Plan.

You can use new transaction data already present in the system as a template

fornewplanning. Youcanusetheactualvaluesofthecurrentyearasthebasis

for the planning in the following year.

298

第 317 页 / 共 509 页

AC220 Lesson: Settings in FI-SL Planning

First,youenterthetemplateplan. Then,youneedspecifythelocationtowhich

youwant tocopythedatafrom the templateplan.

Thedatafromthetemplatecanbecopiedinanon-summarizedform.

Alternatively,youcanrestrictthetemplatedatausingaspecifiedset. Inthiscase,

onlythosecharacteristicsthatarecontainedinthesetarecopied. Summarization

occurs for all other characteristics.

Example: Youwanttousetheactualdataofthepreviousyearasatemplatefor

theplandataofthefollowingyear. Becausetheactualdatacontainsinformation

suchasthefunctionalareathatisnotrequiredforplanning,youuseasettocopy

thedatathatincludesthe“Account”and“Businessarea”characteristicsonly. In

thisway, whiletheactual dataoftheprevious year iscopied, asummarization

of all functional areas occurs.

You can revaluate selected template data with reference to currencies and

quantities. Youneedto define revaluationfactorsto do this. If the revaluation

factorsarenotsufficientforthecurrenciesandquantities,youcanusetheuserexit.

Asaresult,youcandefinetherevaluationprocesstomeetyourrequirements. You

canalsodefinewhetherornotyouwanttooverwriteoraddexistingtargetdata.

Figure 135: Organization of Planning View

Aplannerprofilecontrolstheplanningschedule. Inaplannerprofile,youspecify

whichplanningtasksareusedwithwhichdefaultparametersforeachtable.

Youcancreateasmanyplanningtasksasyouwantforeachtable. Youcanalso

assignthesameplanningtasktoaplannerprofilemorethanonceonlyifdifferent

default parameters are used on each occasion.

299

第 318 页 / 共 509 页

Unit7: Planning AC220

The structureof planner profilesishierarchical:

• General planner profiles

• Planned tables

• Planning tasks for the table

• Planning layouts with default parameters

Figure 136: Planner Profile

You canassign an authorizationgroup toeachplanner profile. You can assign

differentiatedauthorizationstocreateplanningdatabycombiningauthorization

groupsanddefaultparametersthatcannotbeoverwritten.

You assign summarytablesto each planner profilethat you want to use as the

basis for your planning. You can store distribution keys as default values for

currencyand quantityfieldsforeachassigned table.

You assign planning tasks to each table. The position is used to determine in

which order the planning tasks areexecuted.

The indicator for default parameters specifies whether or not the default

parametersarecreatedforyourplantask. Youcandeterminewhetherornotyour

default parameters can be overwritten during planning. If the indicator is set,

thedefault valuesareproposalsthat youcanoverwriteduringplanning. Ifthis

indicatorisnotactive,thepreassignmentcannotbechanged.

Youcanspecifywhetherornotyourplandataisreadandsummarized.

With Excel integration, you determine whether or not Microsoft Excel can be

usedto createplandata. If Excelintegrationisactivated, youmust enter afile

name in the file description field.

You can enterthedocumenttypefor planlineitems.

300

第 319 页 / 共 509 页

AC220 Lesson: Settings in FI-SL Planning

Youcanspecifywhichofthefieldsincludedinyourplanninglayoutforcurrencies

andquantitiesare readyfor input duringplanning.

Defaultparameters: Youcanassigndefaultparameterstoeachplanningtask. Enter

thevalues. Thesevaluesappearasdefaultvaluesontheinitialplanningscreen.

Figure 137: Plan Tasks for a Planner Profile

Whenyoucarryoutplanning,yousetyourplannerprofileandthesummarytable

toenteryourplanningdata. Theplanninglayoutsareprovidedforyouintheorder

specifiedfor eachplan task forthetablespecified. Youcannavigatefromone

layouttoanothertoenter yourplanvaluesinthetable.

Ifthedefault parametersfunctionisactivatedinyour task, youcandisplaythe

defaultvaluesontheentryscreenforeachlayoutandoverwritethemifnecessary.

Withdefaultparameters,youalsohavetwooptionstoenteryourplanvalues:

Freeentryof recordsnot planned: Thisindicator specifieswhether ornotonly

values for which plan data already exists in the database are displayed for the

characteristics. Newcharacteristicvaluescanbecreatedandinsertedintherows.

Form-basedentry: Ifyousetthisindicator,allvaluesforthecharacteristicswith

validmaster dataaredisplayed. Inotherwords, noattentionispaidtowhether

or not plan data exists. Instead, the same structure of characteristic values is

displayed in each planning session.

301

第 320 页 / 共 509 页

Unit7: Planning AC220

Entering Plan Values

Entering Plan Data

Several help functions are available for you to use during planning. These

functionsincludechangingthedistributionkeysforeachcombination,ensuring

scaling for units, setting decimal places, displaying possible combinations,

branchingtoavalidcombinationofyourchoice,displayingleadcolumnswithor

withouttotals,showing/hidingheaderfields,andbranchingtolineitemdisplay.

Inaddition,youcanrevaluateselected,readyforinputdatacellswithapercentage

rate or add values to the cells. You can also enter a negative sign. During

“revaluation”, thesystem subtractsthevalue calculated from the selected cells

using the relevant percentage rate. You can also enter a negative sign when

adding. While“adding”,thesystemsubtractstherelevantvaluefromtheselected

data cells.

OverviewScreenandPeriodScreen: Youcanbranchwithintheperiodscreen

to display or enter individual periods.

Copy Data to Plan

You can use new transaction data already present in the system as a template

fornewplanning. Youcanusetheactualvaluesofthecurrentyearasthebasis

for the planning in the following year.

First,youenterthetemplateplan.Then,youneedtospecifythelocationinwhich

youwant to copythedatafrom thetemplate plan.

Thedatafromthetemplatecanbecopiedinanon-summarizedform.

Alternatively,youcanrestrictthetemplatedatausingaspecifiedset. Inthiscase,

onlythosecharacteristicsthatarecontainedinthesetarecopied. Summarization

occurs for all other characteristics.

Example: Youwanttousetheactualdataofthepreviousyearasatemplatefor

theplandataofthefollowingyear. Becausetheactualdatacontainsinformation

suchasthefunctionalareathatisnotrequiredforplanning,youuseasettocopy

thedatathatincludesthe“Account”and“Businessarea”characteristicsonly. In

thisway, whiletheactualdata of thepreviousyear iscopied, a summarization

of all functional areas occurs.

You can revaluate selected template data with reference to currencies and

quantities. You need to define revaluationfactorstodo this. If the revaluation

factorsarenot sufficient for thecurrenciesandquantities, youcanusetheuser

exit. Asaresult,youcandefinetherevaluationprocesstomeetyourrequirements.

Youcanalsodefinewhetherornotyouwanttooverwriteoraddexistingtarget

data.

302

第 321 页 / 共 509 页

AC220 Lesson: Settings in FI-SL Planning

Figure 138: Entering Plan Data

Severalhelpfunctionsareavailableforyoutouseduringplanning. Theseinclude

changing distribution keys for each combination, scaling for units, setting of

decimalplaces,displayofpossiblecombinations,branchingtoavalidcombination

ofyourchoice,displayofleadcolumnswithorwithouttotals,showing/hidingof

headerfields, branchingtolineitemdisplay, andsoon.

Inaddition,youcanrevaluateselected,readyforinputdatacellswithapercentage

rate or alternatively add values. You can also enter a negative sign. During

“revaluation” the system subtracts the value calculated using the relevant

percentageratefromtheselectedcells. Youcanalsoenteranegativesignwhen

adding. During“adding”thesystem thensubtractsthe relevant value from the

selected data cells.

303

第 322 页 / 共 509 页

Unit7: Planning AC220

Figure 139: Overview Screen and Period Screen

Youcanbranchwithintheperiodscreentodisplayorenterindividualperiods.

Figure 140: Copy Data to Plan

Youcanusenewtransactiondataalreadypresentinthesystemasatemplatefor

anewplanning. Itcanmakesense, forexample, tousetheactual valuesofthe

currentyearasthebasisfortheplanninginthefollowingyear.

304

第 323 页 / 共 509 页

AC220 Lesson: Settings in FI-SL Planning

First, youenterthetemplateplan. Next, specifytowhereyouwanttocopythe

data from the template plan.

Thedatafromthetemplatecanbecopiedinanon-summarizedform.

Alternatively,youcanrestrictthetemplatedatausingaspecifiedset. Inthiscase,

onlythosecharacteristicsarecopiedthatarecontainedintheset. Summarization

occurs for all other characteristics.

Example: Youwanttousetheactualdataofthepreviousyearastemplateforthe

plandataofthefollowingyear. Asactualdatacontainsdetailinformationsuchas

thefunctionalareathatisnotrequiredforplanning,youuseasettocopythedata

thatincludesthecharacteristics“Account”and“Businessarea”only. Inthisway,

at thesametimeasactual dataof thepreviousyeariscopied, asummarization

of all functional areas occurs.

Youcanrevaluateselectedtemplatedatawithregardtocurrenciesandquantities.

Youneedtodefinerevaluationfactorstodothis. Iftherevaluationfactorsarenot

sufficientforthecurrenciesandquantities,youcanusetheuserexit. Inthisway,

youcandefinetherevaluationprocesstosuityourrequirements.

Youcanalsodefinewhether or not youwishtooverwriteor cumulateexisting

target data.

Demonstration: Settings in FI-SL Customizing

Purpose

To demonstratesettings in FI-SL customizing

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. Displayplanningperiods: variant1000: InFICustomizing-globalsettings

forcompanycodes: Show“variant”;controlofthevalidperiods. Example

AC002. LedgerZZ,version: forexample,version001

Version parameters: ledger ZZ, version 001, CCode AC00, year current

fiscal year

Document type for the plan lineitems: P0: Display document types and

number ranges ( for CCode AC00 )

Activate lineitems for Versionsparameter

Distributionkey: Createyourownkey(suchasSOME)inthealternative

modeandincludeitlaterforacertaincombinationtoshowtheeffect.

305

第 324 页 / 共 509 页

Unit7: Planning AC220

Exchange rate type: P; show the respective exchange rate determination

categoryandexchangerates: PathIMG→GlobalSettings→Currencies.

Planning layout: You can follow the same steps as in the participants’

exercises. G99-LYOUT1

Asafurtherexample(G99-LYOUT2),youcantakethisasareferencefor

asecondlayout. AddanewcolumnwithKW-IST.Remembertotakeout

therecordtypefromthegeneralselection. Therecordtype(1: Plan)will

thenhavetobeinsertedalongwithKWforthecolumnsspecifiedwiththe

exceptionoftheactualcolumn(whichwilljustbedisplayed). Inthelatter

case,therecordtypetoinsertis0(=Actual). YoucanreplacetheSetfor

the Regions in the first Key column by the Zones Set and include a Set

forBusinessAreas(0001,1500,8000,and9000)intheGeneralSelection.

This will enable you to navigate online while planning to the respective

business area.

Plannerprofile. DefineanewprofileG99-PRO1TableisZSLTABT.Default

DistributionKeyforcurrencyis1. Enteraplanningtask(1)withyourlayout

G99-LYOUT1withthesettings: canbeoverwritten,summarize,document

typeP0,andonly3rdCurrencyasmanualinput. Defaultparameters: Period

1 to 12.

2. GobacktotheFI-SLapplicationmenu,setyourprofileG99-LYOUT1tothe

tableZSLTABTandshowhowtoenterplandata,switchfromoverviewto

periodview,updateyourplanningandshowtheresultswithsummaryrecord

display and drill down to the single items.

3. Go back to your planner profile and add a second planning task (2) with

layout G99-LYOUT2: samesettingsasbefore.

4. After you have updated your planer profile, you can start your planning

sessionagainandthistime,showhowtoswitchfromthefirsttothesecond

taskandback. Whileinthesecondtask,showhowtonavigatetoabusiness

area. Other things to show are scaling, decimal point change, KW plan

column revaluation (e.g. by 50%) and in the first task switch to single

itemdisplay. Toshowcurrencyconversion,youcoulddefineanewlayout

G99-LYOUT3forthesameleadcolumns(ore.g. justaccounts)withTW,

HW und KW. Remember to enter the record type (1) explicitly for each

column. Becauseyouareonlygoingtoenterthetransactioncurrency,the

columnsforHWandKWwillhavetobesetunderFormattingtoReadyfor

input number. For ExchangerateP, ensure that you havethe appropriate

exchangerates,forexample,EUR(GBP..) toUSD.Youcandefineaseparate

Profile(e.g. G99-PRO2)withonetaskandyourlayout. TWshouldbethe

only currency to be manually planned.

306

第 325 页 / 共 509 页

AC220 Lesson: Settings in FI-SL Planning

Exercise 12: FI-SL Planning

241

Exercise Duration: 75 Minutes

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Definedefaultsettingsandplantheparametersfortheplan. Entertheplan

data and check the results.

Business Example

Regionalmanagersmustsubmitrevenueplansfortheirregions.

Task 1:

Exercise: Plan the revenues (accounts 810200, 810300, and 810400) for the

zones,NORTH,SOUTH,EAST,andWESTinversion1foryourcompanycode

ACXX(where XX is your group number) only in the 3rd currency USD. You

needtoplantherevenuefromJanuarytoDecemberandsettheplannedrevenue

foraccount810300tobe10%higherfromJulytoSeptemberthanfortheother

months. Createthedistributionkey,GRXX(whereXXisyourgroupnumber)for

weightingthesummermonths,andusethisdistributionkeyforthecorresponding

combinations when you enter theplan data.

When you record the plan data, determine the periods (from/to) on the initial

screen.

Youneedplanlineitemsforyourplannedtotals. DocumenttypeP0determines

the number assignment.

Note: Youneedtoplaneachcombinationofzoneandrevenueaccountas

negativeamountsbetweenUSD–96000andUSD–150000.

Default Settings

1. Createversion parametersfor your company code, ledger, version 1, and

the current year.

IMG:FinancialAccounting→SpecialPurposeLedger→Planning→

Plan Settings → Maintain Plan Versions

IMG: Financial Accounting → Special Purpose Ledger → Planning

→ Plan Settings → Version Parameters → Maintain Local Version

Parameters

2. Activate Line Items(Document Type: P0)

Continued on next page

307

第 326 页 / 共 509 页

Unit7: Planning AC220

IMG:FinancialAccounting→SpecialPurposeLedger→Planning→

PlanSettings→ActivateLineItems→ActivateLocalLineItems

Ledger: Your ledger

Version: 1

Companycode: ACXX(XX=your groupnumber)

Fiscal year: Current year

Save GXX-PLAN as a variant.

Description: GXX Planning

3. CreatethedistributionkeyGRXX(whereXXisyourgroupnumber)with

thedescriptionRevenuesgroupXX:Summermonths+10%.

IMG:FinancialAccounting→SpecialPurposeLedger→Planning→

Plan Settings →Define Distribution Keys

Save the distribution key.

4. CreatetheplanninglayoutGXX-REVENUES (whereXX isyour group

name).

IMG:FinancialAccounting→SpecialPurposeLedger→Planning→

DefinePlanningLayout→CreatePlanningLayout

Summary table: ZSLTABT

Planning layout: GXX-REVENUES

Description: Revenues for ZONES

Fortheleadcolumn1,determinethesetGXX-ZONESforthecharacteristic

RZZREGION.

UsetheheadingsCharacteristicvalueandName. Confirmyourentries.

Fortheleadcolumn2,specifythesetGXX-REVENUESfortheaccount

characteristic.

UsetheheadingsCharacteristicvalueandName. Confirmyourentries.

Sortyourleadcolumns. Edit→Columns→SortLeadColumns. Enter1for

Special region and 2 for Account number.

You need a column with the key figure KSL (Group currency, which is

theledgercurrency),andtheattributecolumnsUnitandDistributionkey

(each for the key figure KSL).

Your general selections should contain entries for the company code

(ACXX),ledger AA(..RR),record typePlan, version, fiscal year andthe

periods (variables from/to values).

Continued on next page

308

第 327 页 / 共 509 页

AC220 Lesson: Settings in FI-SL Planning

Confirm your entries.

Check and save your layout.

5. Create the planner profile GXX-PLAN (description: Revenue planning

groupXX) (whereXXisyour groupnumber).

IMG:FinancialAccounting→SpecialPurposeLedger→Planning→

Define Planning Profile

SelectNewEntriesandenteryourplannerprofileandadescription. Save

your entries.

EnterZSLTABTasatablewhichcanbeplannedwiththedefaultdistribution

key 1 for Currency.

Youneedaplantaskandplanninglayoutforthistable.

Select theentry with thesummary table anddouble-clickPlanning tasks

for the table.

SelectNewEntriesandenterItem1andyourplanninglayout.

Select the options Default parameters overwriteable, document type PO,

and 3rd currency.

Save your entries.

Enterthedefaultvalues1and12foryouraccountingperiodsintheDefault

parametersforyourplantask,andselectFormula-basedentry.

Save your entries.

Save your planner profile.

Task 2:

Plan Execution

1. SpecifyyourplannerprofileandselectthesummarytableZSLTABT.

SAP Easy Access → Accounting → Financial Accounting → Special

PurposeLedger→Planning→SetPlannerProfile

2. EnteryourplanvaluesRemembertoenteryourdistributionkeyGRXXfor

account810300forthezonesNORTH,SOUTH,EAST,andWEST.

SAP Easy Access → Accounting → Financial Accounting → Special

PurposeLedger→Planning→PlannedValues→Enter

3. Display theplanned totalsandplandocuments.

Continued on next page

309

第 328 页 / 共 509 页

Unit7: Planning AC220

SAP Easy Access → Special Purpose Ledger→ Planning → Planned

Total Display

SAPEasyAccess→SpecialPurposeLedger→Planning→DisplayPlan

Documents

The record type is 1.

310

第 329 页 / 共 509 页

AC220 Lesson: Settings in FI-SL Planning

Solution 12: FI-SL Planning

Task 1:

Exercise: Plan the revenues (accounts 810200, 810300, and 810400) for the

zones,NORTH,SOUTH,EAST,andWESTinversion1foryourcompanycode

ACXX(where XX is your group number) only in the 3rd currency USD. You

needtoplantherevenuefromJanuarytoDecemberandsettheplannedrevenue

foraccount810300tobe10%higherfromJulytoSeptemberthanfortheother

months. Createthedistributionkey,GRXX(whereXXisyourgroupnumber)for

weightingthesummermonths,andusethisdistributionkeyforthecorresponding

combinations when you enter theplan data.

When you record the plan data, determine the periods (from/to) on the initial

screen.

Youneedplanlineitemsforyourplannedtotals. DocumenttypeP0determines

the number assignment.

Note: Youneedtoplaneachcombinationofzoneandrevenueaccountas

negativeamountsbetweenUSD–96000andUSD–150000.

Default Settings

1. Createversion parametersfor your company code, ledger, version 1, and

the current year.

IMG:FinancialAccounting→SpecialPurposeLedger→Planning→

Plan Settings → Maintain Plan Versions

Continued on next page

311

第 330 页 / 共 509 页

Unit7: Planning AC220

IMG: Financial Accounting → Special Purpose Ledger → Planning

→ Plan Settings → Version Parameters → Maintain Local Version

Parameters

a) Createversionparametersforyourcompanycode,ledger, version1,

and the current year.

IMG:FinancialAccounting→SpecialPurposeLedger→Planning

→PlanSettings→Maintain Plan Versions

IMG:FinancialAccounting→SpecialPurposeLedger→Planning

→PlanSettings→VersionParameters→MaintainLocalVersion

Parameters

New entries:

Ledger: Your ledger

Version: Version 1

Companycode: ACXX(XX=yourgroupnumber)

Fiscal year: Current year

Save your version parameters.

2. Activate LineItems (Document Type: P0)

IMG:FinancialAccounting→SpecialPurposeLedger→Planning→

PlanSettings→ActivateLineItems→ActivateLocalLineItems

Ledger: Your ledger

Version: 1

Companycode: ACXX(XX=your groupnumber)

Fiscal year: Current year

Save GXX-PLAN as a variant.

Continued on next page

312

第 331 页 / 共 509 页

AC220 Lesson: Settings in FI-SL Planning

Description: GXX Planning

a) Activate Line Items(Document Type: P0)

IMG:FinancialAccounting→SpecialPurposeLedger→Planning

→PlanSettings→ActivateLineItems→ActivateLocalLineItems

Ledger: Your ledger

Version: 1

Companycode: ACXX(XX=yourgroupnumber)

Fiscal year: Current year

Save GXX-PLAN as a variant.

Description: GXX Planning

3. CreatethedistributionkeyGRXX(whereXXisyourgroupnumber)with

thedescriptionRevenuesgroupXX:Summermonths+10%.

IMG:FinancialAccounting→SpecialPurposeLedger→Planning→

Plan Settings →Define Distribution Keys

Save the distribution key.

a) CreatethedistributionkeyGRXX(whereXXisyourgroupnumber)

IMG:FinancialAccounting→SpecialPurposeLedger→Planning

→PlanSettings→DefineDistributionKeys

Distributionkey: GRXX(whereXXisgroupnumber)

Select Enter.

Description: RevenuesGroupXX:Summermonths+10%

Periods RelativeFactor Periods RelativeFactor

1 10 2 10

3 10 4 10

5 10 6 10

7 11 8 11

9 11 10 10

11 10 12 10

Save the distribution key.

4. Createtheplanning layout GXX-REVENUES(whereXXisyour group

name).

Continued on next page

313

第 332 页 / 共 509 页

Unit7: Planning AC220

IMG:FinancialAccounting→SpecialPurposeLedger→Planning→

DefinePlanningLayout→CreatePlanningLayout

Summary table: ZSLTABT

Planning layout: GXX-REVENUES

Description: Revenues for ZONES

Fortheleadcolumn1,determinethesetGXX-ZONESforthecharacteristic

RZZREGION.

UsetheheadingsCharacteristicvalueandName. Confirmyourentries.

Fortheleadcolumn2,specifythesetGXX-REVENUESfortheaccount

characteristic.

UsetheheadingsCharacteristicvalueandName. Confirmyourentries.

Sortyourleadcolumns. Edit→Columns→SortLeadColumns. Enter1for

Special region and 2 for Account number.

You need a column with the key figure KSL (Group currency, which is

theledgercurrency),andtheattributecolumnsUnitandDistributionkey

(each for the key figure KSL).

Your general selections should contain entries for the company code

(ACXX),ledger AA(..RR),record typePlan, version, fiscal year andthe

periods (variables from/to values).

Confirm your entries.

Check and save your layout.

a) Create the planning layout GXX-REVENUES (where XX is your

group name).

IMG:FinancialAccounting→SpecialPurposeLedger→Planning

→DefinePlanningLayout→CreatePlanningLayout

Summary table: ZSLTABT

Planning layout: GXX-REVENUES

Description: Revenues for ZONES

For the lead column 1, specify the set GXX-ZONES for the

characteristic RZZREGION.

UsetheheadingsCharacteristicvalueandName. Confirmyourentries.

For the lead column 2, specify the set GXX-REVENUES for the

account characteristic.

UsetheheadingsCharacteristicvalueandName. Confirmyourentries.

Continued on next page

314

第 333 页 / 共 509 页

AC220 Lesson: Settings in FI-SL Planning

Sortyourleadcolumns. Edit→Columns→SortLeadColumns. Enter

1forSpecialregionand2for Accountnumber.

YouneedacolumnwiththekeyfigureKSL(Groupcurrency,whichis

theledgercurrency),andtheattributecolumnsUnitandDistribution

key (each for the key figure KSL).

Double-clickcolumn1. SelectthekeyfigureKSL(Groupcurrency)

and confirm your entries.

Double-clickthenextfreecolumn. SelecttheelementtypeAttribute,

andthenUnit. SelectthekeyfigureKSL(groupcurrency)andconfirm

your entries.

Double-clickthenextfreecolumn. SelecttheelementtypeAttribute,

andthenDistributionkey. SelectthekeyfigureKSL(groupcurrency)

and confirm your entries.

Yourgeneralselectionsshouldcontainentriesforthecompanycode

(ACXX),ledgerAA(..RR),recordtypePlan,version,fiscalyearand

the periods(variables from/to values).

Edit→GeneralDataSelection→GeneralDataSelection

SelectthecharacteristicsAccountingperiod,Companycode,Ledger,

Record type, Version, and Fiscal year.

Fortheaccountingperiod,selecttheindicatorforenteringvariablesfor

the From and To fields.

Enter the company code ACXX.

Enter the ledger AA(..RR).

Enter the record type 1.

Enter the version 1.

Enter thefiscal year Current fiscal year.

Confirm your entries.

Check and save your layout.

5. Create the planner profile GXX-PLAN (description: Revenue planning

groupXX) (whereXXisyour groupnumber).

IMG:FinancialAccounting→SpecialPurposeLedger→Planning→

Define Planning Profile

SelectNewEntriesandenteryourplannerprofileandadescription. Save

your entries.

EnterZSLTABTasatablewhichcanbeplannedwiththedefaultdistribution

key 1 for Currency.

Continued on next page

315

第 334 页 / 共 509 页

Unit7: Planning AC220

Youneedaplantaskandplanninglayoutforthistable.

Select the entry with thesummary tableand double-clickPlanningtasks

for the table.

SelectNewEntriesandenterItem1andyourplanninglayout.

Select theoptions Default parameters overwriteable, document type PO,

and 3rd currency.

Save your entries.

Enterthedefaultvalues1and12foryouraccountingperiodsintheDefault

parametersforyourplantask,andselectFormula-basedentry.

Save your entries.

Save your planner profile.

a) CreatetheplannerprofileGXX-PLAN(description: Revenueplanning

groupXX) (whereXXisyour groupnumber).

IMG:FinancialAccounting→SpecialPurposeLedger→Planning

→ Define Planning Profile

SelectNewEntriesand enteryour plannerprofileandadescription.

Save your entries.

Enter ZSLTABT as a table which can be planned with the default

distribution key 1 for Currency.

Youneedaplantaskandplanninglayoutforthistable.

Select theentry with thesummary table and double-clickPlanning

tasks for the table.

SelectNewEntriesandenterItem1andyourplanninglayout.

Selecttheoptions, Defaultparametersoverwriteable, documenttype

PO, and 3rd currency.

Save your entries.

Enterthedefaultvalues1and12foryouraccountingperiodsinthe

Defaultparametersforyourplantask,andselectFormula-basedentry.

Save your entries.

Save your planner profile.

Continued on next page

316

第 335 页 / 共 509 页

AC220 Lesson: Settings in FI-SL Planning

Task 2:

Plan Execution

1. SpecifyyourplannerprofileandselectthesummarytableZSLTABT.

SAP Easy Access → Accounting → Financial Accounting → Special

PurposeLedger→Planning→SetPlannerProfile

a) SpecifyyourplannerprofileandselectthesummarytableZSLTABT.

SAPEasyAccess→Accounting→FinancialAccounting→Special

PurposeLedger→Planning→SetPlannerProfile

2. EnteryourplanvaluesRemembertoenteryourdistributionkeyGRXXfor

account810300forthezonesNORTH,SOUTH,EAST,andWEST.

SAP Easy Access → Accounting → Financial Accounting → Special

PurposeLedger→Planning→PlannedValues→Enter

a) Enteryourplanvalues. RemembertoenteryourdistributionkeyGRXX

foraccount810300forthezonesNORTH,SOUTH,EAST,andWEST.

SAPEasyAccess→Accounting→FinancialAccounting→Special

PurposeLedger→Planning→PlannedValues→Enter

3. Display theplanned totalsandplandocuments.

SAP Easy Access → Special Purpose Ledger → Planning → Planned

Total Display

SAPEasyAccess→SpecialPurposeLedger→Planning→DisplayPlan

Documents

The record type is 1.

a) Displaytheplannedtotalsandplandocuments.

SAPEasyAccess→SpecialPurposeLedger→Planning→Copy

Model Plan → Display Totals

SAPEasyAccess→SpecialPurposeLedger→Planning→Display

Plan Documents → Total Display

The record type is 1.

317

第 336 页 / 共 509 页

Unit7: Planning AC220

Lesson Summary

You should now be able to:

• UsetheActivateLineItemsfunctiontoupdateplanlineitems

• Usedistributionkeystodistributeplanningtotalstoindividualperiods

• Entertheplanning valuesusingvariousfunctions

318

第 337 页 / 共 509 页

AC220 Unit Summary

Unit Summary

You should now be able to:

• UsetheActivateLineItemsfunctiontoupdateplanlineitems

• Usedistributionkeystodistributeplanningtotalstoindividualperiods

• Entertheplanningvaluesusingvariousfunctions

319

第 338 页 / 共 509 页

UnitSummary AC220

320

第 339 页 / 共 509 页

AC220 Test Your Knowledge

Test Your Knowledge

255

1. Thelineitemstable theplanchanges.

Fillintheblankstocompletethesentence.

2. Using distributionkeys,youcandefine

relative factorsfor each planning period.

Fillintheblankstocompletethesentence.

3. Scaling for units is one of the several help functions available during

planning.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

321

第 340 页 / 共 509 页

TestYourKnowledge AC220

Answers

256

1. Thelineitemstabledocumenttheplanchanges.

Answer: document

2. Usingcompanyspecificdistributionkeys,youcandefinerelativefactorsfor

each planning period.

Answer: company specific

3. Scaling for units is one of the several help functions available during

planning.

Answer: True

Scaling for units is one of the several help functions available during

planning.

322

第 341 页 / 共 509 页

Unit 8

Allocations

257

Demonstrate how to set up the prerequisites for allocations. Elaborate on the

rulestodeterminethesender andreceivervalues. Explain howtoorganizethe

allocationsintosegmentsandcycles. Demonstratehowtoexecuteanallocation

cycle, viewtheresults, andchecktheresultswithareport.

Unit Overview

Thisunitwillhelpyouunderstandhowtosetuptheprerequisitesforallocations.

Tobeginwith,youwilllearnhowtoinvestigatetherulestodeterminethesender

andreceivervalues. Youwillseehowtoorganizetheallocationsintosegments

and cycles. You will also learn how to execute an allocation cycle, view the

results, and check the results with a report.

Unit Objectives

After completing thisunit, you will beableto:

• Define the term allocation

• Use the different types of allocation

• Define sender and receiver values

• Create and execute an FI-SL cycle

Unit Contents

Lesson: Using Allocations in FI-SL...........................................324

Demonstration: Demonstration on Cycles and Segments............332

Exercise 13: Allocation of Expenses to Regions ......................337

323

第 342 页 / 共 509 页

Unit8: Allocations AC220

Lesson: Using Allocations in FI-SL

Lesson Duration: 70 Minutes

258

Lesson Overview

This lesson starts with a definition of the term allocation. Then, the lesson

explains the use of the different types of allocations. The lesson gives you an

insight into the sender and receiver values. You will also learn how to create

and execute an FI-SL cycle.

Lesson Objectives

After completingthislesson, you will beable to:

• Define the term allocation

• Use the different types of allocation

• Define sender and receiver values

• Create and execute an FI-SL cycle

Explain the definition of the term allocation, which is the umbrella term for

distribution and assessment. Then, explain the use of the different types of

allocations. Elaborateon the sender andreceiver values. Demonstrate how to

create and execute an FI-SL cycle.

Business Example

Toallowforprecisecontrolandanalysisofthecostsinthefunctionalareas,these

costshavetobeallocatedtoLinesofBusiness. Reportsreflectvariousmethods

for allocating these costs, percentage split and receiver based criteria, such as

percentagesplitandreceiver-basedcriteriahavetobetestedandimplemented.

Forthispurpose,youneedtoanalyzetheallocationinstrumentsofFI-SL.Ifthe

FI-SLallocationinstrumentsareacceptabletomeetthesegoals,youneedtocreate

andexecuteFI-SL cycle for allocation purposes.

324

第 343 页 / 共 509 页

AC220 Lesson: Using Allocations in FI-SL

Overview and Examples of Allocations in FI-SL

Figure 141: Allocations: Overview

Distribution and Assessment

Distribution

ThedatastoredunderanaccountinFI-SLcanbedistributedusingauser-defined

key. Postingsmadetoaccounts,suchaselectricitycostsarecollectedforacost

centerandallocatedattheendoftheperiodusingthedefinedkey.

Indistribution,theoriginalaccountiscreditedwiththeallocation.

Line items that document the distribution are written to the sender as well as

the receiver.

Thedistributioncanberepeatedasoftenasyouwant.

Assessment

Primary costs are added up across accounts and allocated to the receivers by

means of an assessment account.

325

第 344 页 / 共 509 页

Unit8: Allocations AC220

Figure 142: Distribution

ThedatastoredunderanaccountinFI-SLcanbedistributedusingauser-defined

key. Postingsmadetoaccounts,suchaselectricitycostsarecollectedforacost

centerandallocatedattheendoftheperiodusingthedefinedkey.

Indistribution,theoriginalaccountiscreditedwiththeallocation.

Line items that document the distribution are written to the sender as well as

the receiver.

Thedistributioncanberepeatedasfrequentlyasyouwant.

Figure 143: Assessment

During assessment, the account balances are collected on a cost center and

allocated as a total via an assessment account to other characteristics, such as

cost centers.

Theassessmentisperformedaccordingtouser-definedrules.

326

第 345 页 / 共 509 页

AC220 Lesson: Using Allocations in FI-SL

Lineitemsthatdocumenttheassessmentarewrittentothesenderandthereceiver.

Theassessmentcanberepeatedasoftenasyouwant.

Sender and Receiver Information

Allocations: Sender and Receiver

Youmustdefinesenderandreceiverrulestoallocatecosts.

For thesender, you specify whether posted amounts(actualor planvalues), or

fixedamounts(actual or planvalues)aretobeallocated, or whether aresidual

percentage valueshould remain on the sender.

In the receiver rules, you specify whether the allocation is to be performed

accordingtofixedvalues(amounts,percentagerates,andportions)orwhetherthe

tracingfactorsareto bedeterminedfrompostedvalues(or quantities), suchas

accounts,activitytypes,andstatisticalkeyfiguresduringtheallocation.

Explaintheinheritanceprinciple(Sender→Receiver).

Receiver Tracing Factor

Receiver tracing factors. Examples:

Statistical key figures(for example, number of employees), revenue accounts,

sold number of pieces...

Sender Values

Separation of records to be read for the determination of the sender amounts

(sendervalues)andtherecordstobecredited(sender). Examples:

An alternative version, different TC amounts but credited by means of DEM

amount, other account balances, and so on.

Allocations: Sender and ReceiverInformation

2newrecordtypes: 2=allocatedactualand3=allocatedplanningdata

Possibilityforthesenders<>receiverstoupdatetheR(object)andS(partner)

fieldrelationshipscompletely,respectivelywiththehelpoftheD/Kindicator. For

thisreason, theflagisset(at tablelevel) inFI-SLCustomizing: Path: Periodic

Processing→Allocation→MaintainSender/ReceiverRelationship. Thismay

cause a lot of records to be created but allowselimination of ICbalanceswith

Report Writer/Painter.

ExamplesenderS1,DEM1000,receiverR1(40percent)andR2(60percent)

Without S/R:

327

第 346 页 / 共 509 页

Unit8: Allocations AC220

RCNTR SCNTR S/H Amount

S1 H 1000

R1 S1 S 400

R2 S1 S 600

With S/R:

S1 R1 H 400

S1 R2 H 600

R1 S1 S 400

R2 S1 S 600

Figure 144: Allocations: SenderandReceiverInformation

Duringassessmentanddistribution,recordsareupdatedinthesummarytablewith

recordtype2(allocatedactualdata)orrecordtype3(allocatedplandata).

You can specify whether the records should contain the sender and receiver

information(RCNTRtoSCNTRandRFAREAtoSFAREA).

Thisinformationisdocumentedaslineitemsforthesummaryrecords.

Ifyourepeatanassessmentanddistributionwithinaperiod,thesummaryrecords

are reversed before the new execution.

Therefore, theallocationcanberepeatedat anytime.

328

RCNTR	SCNTR	S/H	Amount
S1		H	1000
R1	S1	S	400
R2	S1	S	600

S1	R1	H	400
S1	R2	H	600
R1	S1	S	400
R2	S1	S	600

第 347 页 / 共 509 页

AC220 Lesson: Using Allocations in FI-SL

Cycles and Segments

Segments

Divisioninsegmentsifthevaluedeterminationdiffersforthesenderaswellas

for the receivers.

Cycles

Senderand receiver groupsarecombinedin cycles.

Cyclesarestoredchronologically. Duringprocessing,youcanselectcyclesusing

the validity period.

Divisions in the company can be allocated by splitting them into cycles (also

separatedbytime). Youcanalsosetupallocationcyclesthat arebasedonone

another. Thisenablesyoutoprocesstheservicecostcentersinthefirstcycleand

thefinalcostcentersinthesubsequentcycle,forexample.

Cycles are processed in succession.

Allocations: Example

Groupingofthesegmentsincyclesthatrunseparately(regardingtime).

Headerspecification: generallyvalidforallsegments:

Standardization, iteration (if Sender → Receiver → Sender ....), option of the

distributionofquantitiesandthedifferentiationoftheTCamounts(otherwisethe

GC or LC amount is used as flat rate totals.

Example: Distribution of the personnel costs of theadministration cost center

3100to 2other positions. Percentage distribution.

Field Usage

The next graphic illustrates the need, especially for new characteristics to

determine how they are going to be used in an allocation and how to take the

correspondingstepstospecifythisincustomizing. Therewillbeaneedtodothis

forthenewcharacteristicspecialregionRZSPREGandyouwilldemonstratethis.

329

第 348 页 / 共 509 页

Unit8: Allocations AC220

Figure 145: Segments

Asegmentcombinessendercostcentersforwhichthevaluesbeingallocatedare

tobecalculatedinthesamewayandreceivercostcentersforwhichthetracing

factors are to be calculated in the same way.

Figure 146: Cycles

Senderand receiver groupsarecombinedin cycles.

330