AC220_EN_Col52_FV_Inst_A4 (第11页)

第 393 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

Youcanalsosummarizethedataintherollupledgerbysubstitutingoneormore

characteristics, such as:

• product and product group

• account and account group

• functional area and functional area group

To use substitutions, you specify a condition for the substitution in the rollup

definition. Whenthisconditionismet,thesubstitutioniscarriedout.

Figure 163: Rolling Up Periods

Youcan roll upseveral periodsat the sametime.

You can also perform a summarization over several periods. For example, a

quarterlyreportcanbecreatedfrom12periods(ledgerZZ).

Youcanalsorollupdatatoaledgerthatusesanon-calendarfiscalyear(ledger

YY).Thefiscalyearofthesourceledgercorrespondstothefiscalyear.

375

第 394 页 / 共 509 页

Unit10: Rollups AC220

Figure 164: Rollup with Hierarchical Summarization

Sequences in Rollup

DefiningSequences: Intherollupdefinition,youenterinformationthatisvalid

forallsequences(thatis,generalconditionsthatapplytotheentirerolluprun,for

example, themaximumquantityofdatatobeselectedfortherollup). Arollup

withsingle-level(nothierarchical)summarizationcancontainseveralsequences.

Dividingarollupintosequencesisrecommendedifyouwanttostoreonlycertain

data records from a maximum selected quantity of data in one or more rollup

ledger(s)and/ortransferthesamesourcedatausingadifferentmethod.

RollupHeader: Generallyvalidinformationforallsequences.

Rollup-Set: Fixed Fields

• Therollupheadersetdeterminesthemaximumamountofdatatobeselected

fromthesourceledger(s)fortherollup. Youcanlimitthisamountofdata

usingindividualrollupsequencesets,butyoucannothoweverincreasethis

amount of data.

• The rollup up header set must at least contain the dimensions “ledger”,

“recordtype”,“version”and“companycode/globalcompany”.

• For a rollup with hierarchical summarization, you must also create a

single-dimensionsettodefinethehierarchythatistobesummarized. You

mustincludethissingle-dimensionsetinyourrollupheaderset. Ifyouenter

thedimensionofthesingle-dimensionsetinthefield’Hierarchydimension’,

thesystemrecognizesthatthissetistobeusedintherollupheader set to

determine the hierarchy structure.

Multi Set

376

第 395 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

A multi-dimension (characteristic) set combines sets that use different fields

(characteristics).

Theexampleshowsthemulti-dimensionsetthatcombinesthesingle-dimension

set for the RFAREA (functional area) field and the basic set for the RACCT

(account) field.

Multi Set: Basic Entries

The folio illustrates the basic entries for a multi-dimension set to which the

different fields (characteristics) are assigned.

Rollup set: Variable Fields

• Inadditiontothefixedcharacteristics(ledger,recordtype,version,company

code[orglobalcompany]),therollupsetcontainsthevariablecharacteristics

or combinationsof characteristicsthat determinewhichdatabaserecords

are to be read for the rollup.

• Therollupsetdeterminesthemaximumquantityofdatathatcanbeselected

for the rollup.

Sequences:

• Dividingarollupintosequenceswithtargetledgers. Youcanlimitthedata

selectedfortherollupatthesequencelevelusingasequencesetorarule.

Sequenceset-Youcanuseasequencesettospecifywhichdatashouldbe

rolledupforthespecificsequence. Ifyouenterasequenceset,therelevant

sequencecanonlyreadthosedatabaserecordsthat satisfyboththerollup

headersetandthesequencesetwhenyouexecutetherollup.

Rule-Youcanusearule(selectioncondition)tofurtherlimitthetotalset

ofdatabeingselectedifthedatacannotbelimitedusingtherollupset(or

thesequenceset); forexample,youcandefineORconditionsbetweenthe

characteristics.

Blocking indicator - If the Blocked indicator is set for the sequence, the

sequenceisnottakenintoaccountwhentherollupisexecuted.

377

第 396 页 / 共 509 页

Unit10: Rollups AC220

Figure 165: Defining Sequences

In the rollup definition, you enter information that is valid for all sequences

(generalconditionsthatapplytotheentirerolluprun,forexample,themaximum

quantity of data to be selected for the rollup).

Arollupwithsingle-level(nothierarchical) summarizationcancontainseveral

sequences.

Dividingarollupintosequencesisrecommendedifyouwantto.

Storeonlycertaindatarecordsfromamaximumselectedquantityofdatainoneor

morerollupledger(s)and/ortransferthesamesourcedatausingadifferentmethod.

378

第 397 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

Figure 166: Rollup Header

Thefollowinginformationisstoredintherollupheader:

• Thesummarytablesfromwhichandintowhichthedatarecordsaretobe

rolled

• Whether or not you want to use the reset set to reset data in the rollup

ledger(s) to zerobeforetherollupisexecuted

• Whetherornotthelineitemsaretobewrittenforeachrolluprecord. These

line items document how the rollup summary record was produced and

allow you to reverse the rollup later

• Whetherornotvaluesareaccumulatedintherollupledger

• Whetherornotrecordsthathavezerobalanceinallperiodsaretobeupdated

in the rollup ledger

379

第 398 页 / 共 509 页

Unit10: Rollups AC220

Figure 167: Rollup Sequence

Dividingarollupintosequenceswithtargetledgers.

Figure 168: Restrictions in a Sequence

You can limit the data selected for the rollup at the sequence level using a

sequence set or a rule.

380

第 399 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

Figure 169: Sequence Set

SequenceSet-Youcanuseasequencesettospecifywhichdatashouldberolled

upforthespecificsequence. Ifyouenterasequenceset, therelevantsequence

canonlyreadthosedatabaserecordsthatsatisfyboththerollupheadersetandthe

sequence set when you execute the rollup.

Figure 170: Sequence Rule

381

第 400 页 / 共 509 页

Unit10: Rollups AC220

Rule-Youcanusearule(selectioncondition)tofurtherlimitthetotalsetofdata

beingselectedifthedatacannotbelimitedusingtherollupset(orthesequence

set);forexample,youcandefineORconditionsbetweenthecharacteristics.

Figure 171: Sequence Block

BlockingIndicator-IftheBlockedindicatorissetforthesequence,thesequence

isnottakenintoaccount whentherollupisexecuted.

Rollup Set

Rollup Set: Fixed Fields

• Therollupheadersetdeterminesthemaximumamountofdatatobeselected

fromthesourceledger(s)fortherollup. Youcanlimitthisamountofdata

usingindividualrollupsequencesetsbutyoucannotincreasethisamount

of data.

• The rollup up header set must at least contain the dimensions “ledger”,

“recordtype”,“version”,and“companycode”/“globalcompany”.

• For a rollup with hierarchical summarization, you must also create a

single-dimensionsettodefinethehierarchythatistobesummarized. You

must include this single-dimension set in your rollup header set. If you

enter the dimension of the single-dimension set in the field, “Hierarchy

dimension”, thesystemdeterminesthatthissetistobeusedintherollup

header setto determinethehierarchystructure.

Multidimension Set

382

第 401 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

A multidimension (characteristic) set combines sets that use different fields

(characteristics). Theexampleshowsthemultidimensionsetthatcombinesthe

single-dimensionsetfortheRFAREA(functionalarea)fieldandthebasicsetfor

the RACCT (account) field.

Multidimension Set: Basic Entries

Discussthebasicentriesfor a multidimension set to which the different fields

(characteristics) are assigned.

Rollup set: Variable Fields

In addition to the fixed characteristics, such as ledger, record type, version,

and company code or global company, the rollup set contains the variable

characteristicsorcombinationsofcharacteristicsthatdeterminewhichdatabase

records are to be read for the rollup. The rollup set determines the maximum

amountof datathat canbeselected for therollup.

Figure 172: Rollup Set: Fixed Fields

The rollup header set determines the maximum amount of data to be selected

fromthesourceledger(s)fortherollup. Youcanlimitthisamountofdatausing

individualrollupsequencesetsbutyoucannotincreasethisamountofdata.

Therollupupheadersetmustatleastcontainthedimensions“ledger”,“record

type”,“version”,and“companycode”/“globalcompany”

For a rollup with hierarchical summarization, you must also create a

single-dimensionsettodefinethehierarchythatistobesummarized. Youmust

include this single-dimension set in your rollup header set. If you enter the

383

第 402 页 / 共 509 页

Unit10: Rollups AC220

dimensionof the single-dimensionset inthefield, “Hierarchy dimension”, the

systemdeterminesthatthissetistobeusedintherollupheadersettodetermine

the hierarchy structure.

Figure 173: Multidimension Set

A multidimension (characteristic) set combines sets that use different fields

(characteristics).

The above example shows the multidimension set that combines the

single-dimensionsetfortheRFAREA(functionalarea)fieldandthebasicsetfor

the RACCT (account) field.

384

第 403 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

Figure 174: Multidimension Set: Basic Entries

This figure illustrates the basic entries for a multidimension set to which the

different fields (characteristics) are assigned.

Figure 175: Rollup Set: Variable Fields

In addition to the fixed characteristics, such as ledger, record type, version,

and company code or global company, the rollup set contains the variable

characteristicsorcombinationsofcharacteristicsthatdeterminewhichdatabase

records are to be read for the rollup.

385

第 404 页 / 共 509 页

Unit10: Rollups AC220

Therollupsetdeterminesthemaximumquantityofdatathatcanbeselectedfor

the rollup.

Field Movement

• Usingfieldmovements,youcanspecifywhichvariablecharacteristicsare

tobetransferred. Foreachfieldmovement,youmustenteravalueforthe

sender and receiver fields.

• If thecharacteristicsarenot transferred to thereceiver table, the data for

these fields is summarized.

Figure 176: Field Movement

Field Movement: Using a field movement, you can specify the variable

characteristicsthataretransferredwiththefixedcharacteristicsduringtherollup.

386

第 405 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

Figure 177: Field Movement (1)

Figure 178: Field Movement (2)

387

第 406 页 / 共 509 页

Unit10: Rollups AC220

Figure 179: Field Movement (3)

Substitution and User Exits

SubstitutionActivity: Summarizationbyomittingcharacteristicsnotrequired

and Substitution (if the condition is met).

User Exits:

Notmyideabutmyson’s. Homework: Truckdriverwhosuddenlybecomesrich

through secret manipulations.

388

第 407 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

In a word:

1. Driver’s license is O.K: can start out: prior to the rollup (exit 1 rollup

header): Example: Checktheenteredperiods-accesstheformintheABAP

(inourexamples,theyarecontainedinthereportZZLVU800intable80D)

2. Motorway exit: only took grapejuice along: own post-selectioncriteria:

(exit 1 in field movement header table)

3. Tradesgrapejuiceintowine: Ownsubstitutionoptions: Exitaccessiblefor

each field during field movement

4. Adds(EUR/USD)10to price/bottle: Optionof revaluatingdatabalances

(examples: roundingstofullamountsorupgradingamountsbypercentages

for certain account groups (e.g. Revenue accounts): Exit 2 in the field

movement header table.

Note: I’ve changed the exit 02 in the ABAP for the participants‘

conclusionexercisetoroundingoffulldollaramountsbecausethismight

beeasierforthemtograspthantheformeridea(upgrade5%and10%,

respectively).

Showthetable80D(V_T80D)withSM30orinFI-SLCustomizingunder

User-Exits (maintain Client dependent User Exits) and the respective

ABAP,too. ThisisacopyofRGLVS000whichisdeliveredbySAP.

Figure 180: Substitution Activity

Using field movements, you can specify which variable characteristics are to

betransferred. Foreachfieldmovement, youmustenteravalueforthesender

and receiver fields.

389

第 408 页 / 共 509 页

Unit10: Rollups AC220

If thecharacteristicsarenot transferred to the receiver table, thedatafor these

fields is summarized.

Asubstitutionactivitycanbeassignedtoeachreceiverfield.

Usingasubstitutionactivity, youcanreplacethecontentsof thecharacteristics

(for example, RFAREA) with anyconstant value.

Figure 181: User Exits

Whenarollupisexecuted,userexitscanbeusedatfourdifferentpoints:

Exit in the rollup header - This exit is called up before the data records are

processed. Atthisexitpoint,youcanprocessgeneralvalidations,forexample,to

check the period interval for the rollup.

Exit1inthefieldmovementheadertable-Thisexitchecksthevalidityofsender

recordsusinguser-definedcriteria(forexample,ATABtables).

Exitinthesubstitutionactivitiesinthefieldmovement-Thisexitallowsyouto

make substitutionsfor certain characteristics (for example, cost center →cost

center groupand account →account group).

Exit2inthefieldmovementheadertable-Thisexitiscalledwhenthereceiver

recordiscreated. Atthisexitpoint,substitutionscanalsobemadeintheamount

fields(forexample,revaluationordevaluationofcertainaccountgroupbalances).

Youdefineuserexitsusingtheformat,Uxx(wherexxisatwo-digitexitnumber).

TheformpoolnamesforuserexitsarelistedintheT80Dtable. IntheRGLVS000

program,youwillfindexamplesofstandardexitsforthefourexitpointsgiven

above. Thisprogramcanbecopiedandconfiguredinthecorrespondingclients.

390

第 409 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

Executing a Rollup

When you execute arollup, you specifythe periodsthat areto berolled up by

entering a From period and a To period (with the fiscal year). You can also

specify whether or not a carry-forward period is to be rolled up for a specific

year. Thedocumenttypeisrequirediflineitemsaretobewrittenforthisrollup.

Thedocumenttypeallowsyoutoreversetherolluprecordsatalatertime. The

dataisusuallyrolleduptotheFI-SLtablesdirectly. Alternatively,thedatacan

be written to or read from an export file (sequential file or PC file). You can

request acomprehensive list with all the records that were read and generated

while executing the rollup.

Figure 182: Executing a Rollup

When you execute arollup, you specifythe periodsthat areto berolled up by

enteringaFromperiodandaToperiod(withthefiscalyear).

You can also specify whether or not a carry-forward period is to be rolled up

for a specific year.

Thedocumenttypeisrequirediflineitemsaretobewrittenforthisrollup. The

documenttypeallowsyoutoreversetherolluprecordsatalatertime.

ThedataisusuallyrolleduptotheFI-SLtablesdirectly. Thedatacanbewritten

toorreadfromanexportfile(sequentialfileorPCfile).

You can request a comprehensive list with all the records that were read and

generated while executing the rollup.

391

第 410 页 / 共 509 页

Unit10: Rollups AC220

Appendix

Figure 183: SIMPLY PUT: Create a Rollup

Demonstration: Demonstration of Rollups in FI-SL

Purpose

To demonstrate rollups in FI-SL

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. The actual functional area expense costs that have been posted to your

companycodefortheactualperiodaretoberolledintoyourrollupledger.

Therollupledgershouldtakeoverthefunctionalareas1:1buttheaccount

expensecategories(420000-429999,430000-439999,470000-479999)are

tobesubstitutedintothreeglobalaccounts: 422222,433333,and477777.

YourrollupledgershouldbesetupforthetableZSLTABT,onlyberolled

up, and have the indicators, “d/c” and “write line items” set. It should

onlystoretheledgercurrencyUSD.Therollupversionforthisledgeris1.

YoushouldassignyourcompanycodeAC00tothisledgerwithBlocking

Indicatorsetto“1”andFiscalYearVariantsetto“K4”’.

392

第 411 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

Steps:

Create a new Ledger: TR

Description: Rollup Ledger TR

Basic settings:

Summary table: ZSLTABT

Additional settings:

Ledger post. allowed x Rollup allowed

Setupbalancec/fxWritelineitemsxMaintaind/cindicatorxProductive

Summarize

Storedcurrencies: NOTransactioncurrency→Definecurrencies

Choosecombination:SecondCurrencynotdefinedxLedgercurrencyledger

currency USD

Storedquantities: NONE(x=theonlyrequiredchoices)

Save your Ledger.

Assignyour CompanycodeAC00tothisLedger.

Create Ledger: Assign Company Code

Company Code: AC00

Ledger: TR

Assignment criteria:

Blocking indicator: 1

Fiscal year variant: K4

Press Enter.

Save your Assignment Ledger/Co.Code.

Createamultidimensionrollupset(G00-ROLL)toincludeappropriatesets.

Special-Purpose Ledger:

Select Tools→Setmaintenance→Sets→Create.

Set ID: GXX-ROLL

Table: ZSLTABT

Header:

Description:“Roll-Multi Group XX”

Set lines:

393

第 412 页 / 共 509 页

Unit10: Rollups AC220

Set ID: Set short text

G00- LEDGER: Your Ledger TR *

G00-ACT (RRCTY = 0): Actual *

G00-CCD(Co.Code=AC00): CompanyCodeAC00*

G00.VERS1 (Version = 1): Version 1*

G00-FAREASL Functional areas

G00-OVERHEAD: Overhead Accounts:

* New Sets

2. Definethreerulesfortheprerequisitesinyoursubstitutionactivity:

G00-RULE1 (Intervall 420000 - 429999)

G00-RULE2 (Intervall 430000 - 439999)

G00-RULE3 (Intervall 470000-479999)

Menupath: SAPR/3System→Tools→BusinessEngineer→Customizing

→ Implement projects → SAP Reference IMG → Financial Accounting

→ Special Purpose Ledger → Tools → Maintain Validation →

Substitution/Rules→MaintainLogicalRules→Rule→Create.

Applicationarea: Rollup,CallupPoint: 0002,UserTable: TR-UTAB

Rulename: G00-RULE1Accounts420000–429999

Press Button “Formula Editor”.

User Table: TR-UTAB

Select Account number:

Rule: Accountnumber>=“420000”ANDAccountnumber<=“429999”

Save.

RulesG00-RULE2andG00-RULE3inthesamewaywiththeotherintervals

3. Cater for Rollup Presettings:

MenuPath: SAPR/3System→Tools→BusinessEngineer→Customizing

→Implementprojects→SAPReferenceIMG→FinancialAccounting→

SpecialPurposeLedger→PeriodicProcessing→Rollup.

4. CreateaSubstitutionActivity(G00S)foryourexpenseaccountsandinclude

yourrulesandsubstitutedvaluesforthethreeserialnumbersrequired.

SelectFI-SLCustomizing→Rollup→MaintainSubstitution.

Click “New Entries”.

SubAct. NoSum.TableRec.fieldConst.valueRule

394

第 413 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

G00S001ZSLTABTRACCT0000422222G00-RULE1

G00S002ZSLTABTRACCT0000433333G00-RULE2

G00S003ZSLTABTRACCT0000477777G00-RULE3

Note: Do not forget the leading zeros.

5. CreateaFieldMovement(G00M)forthecharacteristicsyouneedtotransfer.

Includeyoursubstitutionactivityinthisfieldmovement. Thereceiverand

sender table is ZSLTABT.

InFI-SLCustomizing,selectRollup→MaintainFieldMovements→Create

Rollup Field Movement.

Field Movement: G00MEnter

Description: FieldMovement forRollupZZ→R

Receiver table: ZSLTABT

Sender table: ZSLTABT

Rec.fld Send.fld SubActivt

RFAREA RFAREA

RACCT RACCT G00S

6. Definea standard RollupG00-ROLL with onesequence.TheSender and

ReceivertableisZSLTABT.IncludeyourRollupSetintheRollupheaderand

theprocessingoptions,WriteLineItems,documentR0andDetailList. Your

sequenceshouldincludethefieldmovementandyournewrollupledger.

Applicationmenu: SelectSpecialPurposeLedger→Periodicprocessing

→ Rollup → Create.

Initial Screen:

Rollup: G00-ROLL

Rollup type: Standard

Click “Rollup Header”

Title: FunctionalareaExpenses→Accountgroups

Sender table: ZSLTABT

Receiver table: ZSLTABT

Rollup set: G00-ROLL

Click“Processing optn”. Writelineitems. ClickContinue. Click“Rollup

sequence”. EnterFieldmovementG00MandyourRollupLedgerTR.Save

the rollup definition.

7. Rollup Execution:

395

第 414 页 / 共 509 页

Unit10: Rollups AC220

Menu:SAP R/3 System→Tools→ Business Engineer →Customizing →

Implement projects → SAP Reference IMG → Financial Accounting →

SpecialPurposeLedger→PeriodicProcessing→Rollup→Execute.

Executeyourrollupforthecurrentperiodandshowtheresultsinyourrollup

ledger.

Rollup: G00-ROLL

Execute.

Parameters:

From and To Period: Current Period

FromandToFiscalYear: CurrentYearProcessingoptions: xwritelineitems

Doc. Type: R0x Detail list

Execute.

Show the results of the protocol and use FI-SL Summary Records (and

Document) to display.

Demonstration: Demonstration of USER EXIT

(Rounding to full dollar amounts)

Purpose

To demonstrate USER EXIT

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. Show Exit 02 in the ABAP above.

2. CreateaFieldMovement(G00P)forthecharacteristicsyouneedtotransfer.

IncludetheExit02intheFieldMovementHeaderfortheBalanceUpgrade.

The Receiver and Sender table isZSLTABT.

InFI-SLCustomizing,selectRollup→MaintainFieldMovements→Create

Rollup. Field Movement

FieldMovement: G00P(XX=yourgroupnumber)

Press Enter.

Description: “FM 2 Rollup”

396

第 415 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

Receiver table: ZSLTABT

Sender table: ZSLTABT

Rec.fld Send.fld SubActivt

RACCT RACCT

Save the Field Movement G00P.

3. RollupDefinition: DefineastandardRollupG00-R001withonesequence.

The Sender and Receiver table is ZSLTABT. Include a Rollup Set (fixed

fieldsasabovebutaddtheRevenueAccountsSet)G00-RTSTintheRollup

header and the processing options; Write Line Items, document R1 and

Detail List

Your sequence should include the field movement and your new rollup

ledger.

Application menu:SelectSpecial Purpose Ledger → Periodicprocessing

→ Rollup → Create.

Initial Screen:

Rollup: G00-R001

Rollup type: Standard

Click “Rollup Header.”

Title: “Zone Revenues for Product groups”

Sender table: ZSLTABT

Receiver table: ZSLTABT

Rollup set: G00-RTST

Click “Processing optn”.

Write line items.

Click Continue.

Click “Rollup sequence”.

EnterFieldmovementG00P andyourRollupLedgerTR.

Save Rollup Definition.

Postings using GB01 (FI-SL):

Account BUSA Amount

800200 9900 1,000.10

800300 9900 2,000.20

800400 9900 3,000.90

397

第 416 页 / 共 509 页

Unit10: Rollups AC220

4. Rollup Execution:

Menu: In SAP R/3 Enterprise, select Tools → Business Engineer →

Customizing→ Implement projects→ SAP Reference IMG →Financial

Accounting→SpecialPurposeLedger→PeriodicProcessing→Rollup

→ Execute.

Executeyourrollupforthecurrentperiodandviewtheprotocol, pointing

outtheroundedamountsandtheresultsinyourrollupledger.

Rollup: G00-R001

Execute.

Parameters:

Current Period

Current Year

Processing options: x write line items

Doc. Type: R0 x Detail list

Execute.

If you havetime, you can explain and complete the exampleROLL-HIE

(hierarchical;showthesetswithrep. valuesforthis)(relevantforthecurrent

period).

398

第 417 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

Exercise 15: Definition and Execution of

313

a Rollup

Exercise Duration: 10 Minutes

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Define and execute a rollup

Business Example

Forsomereports, regionalmanagersneedtoaggregatethedataathigherlevels

to accounting groups.

Task:

Theactualfunctionalareacoststhathavebeenpostedtoyourcompanycodefor

theactualperiodaretoberolledintoyourrollupledger. Therollupledgeristotake

overthefunctionalareas1:1,buttheexpenseaccountcategories(420000-429999,

430000-439999, and 470000-479999) must be substituted by the three global

accounts: 422222,433333,and477777. Yourrollupledgermustbesetupforthe

tableZSLTABT andonlyrollupistobepermittedfor theledger. TheD/Cand

Writelineitemsindicatorsmustalsobeselected. SettheledgercurrencytoUSD

only. Therollupversionforthisledgeris1. AssignyourcompanycodeACXXto

thisledger,andusetheblockingindicator1andthefiscalyearvariantK4.

1. Create a Rollup Ledger:

In the menu, select:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger

→BasicSettings→MasterData→MaintainLedger→CreateLedger

GroupRollupLedgerGroupRollupLedgerGroupRollupLedger

01 XA 02 XB 03 XC

04 XD 05 XE 06 XF

07 XG 08 XH 09 XI

10 XJ 11 XK 12 XL

13 XM 14 XN 15 XO

16 XP 17 XQ 18 XR

2. Createtherollupversion 1for yourrollupledger.

Continued on next page

399

第 418 页 / 共 509 页

Unit10: Rollups AC220

3. MakeanassignmenttoyourcompanycodeACXX.

4. Createamulti-dimensionrollupset(GXX-ROLL)toaddappropriatesets.

Set ID: GXX-ROLL

Table: ZSLTABT

Header:

Description: Roll-Multi Group XX

Set lines:

Set ID: Set Short Text

GXX-LEDGER Your ledger (AA - RR)

GXX-COCODE Company code ACXX

*GXX-ACT Record type 0 (= actual)

GXX-VERS1Version 1

GXX-FAREAS Functional areas

GXX-OVERHEAD Overhead postings

= new set

5. Definethreerulestodeterminetheprerequisitesofyoursubstitutionactivity:

GXX-RULE1 (Interval 420000 - 429999)

GXX-RULE2 (Interval 430000 - 439999)

GXX-RULE3 (Interval 470000 - 479999)

In the menu, select:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger

→Tools→MaintainValidation/SubstitutionRules→LogicalRulesfor

Validation/Substitution→Rollup→Rollup→Execute

User table: GXX-UTAB Table:

Create rule.

Rulename: GXX-RULE1Accounts420000–429999

Double-click the Rule Content field.

Double-click G/L User Table 1 to select it.

Select the account number:

Rule: Accountnumber>=420000ANDaccountnumber<=429999

Save your entries.

Continued on next page

400

第 419 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

DefinetherulesGXX-RULE2andGXX-RULE3inthesamewayasforthe

other intervals.

6. Default Rollup Settings:

In the menu, select:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger

→ Periodic Processing → Rollup

7. Createasubstitutionactivity(GXXS)foryourexpenseaccountsandinclude

your rules and substituted values for the three serial numbers required.

Remembertoincludetheleadingzerosbeforetheaccountnumbers. These

must appear here.

Rollup →Maintain Substitution→NewEntries

8. Create a field movement (GXXM) for the characteristics you want to

transfer. Include your substitution activity in this field movement. The

receiver and sender table is ZSLTABT.

Rollup→MaintainFieldMovements→CreateRollupFieldMovement

9. DefineastandardrollupGXX-ROLLwithonesequence.

The sender and receiver table isZSLTABT.

Intherollupheader,entertherollupsetandselectWriteLineItemsinthe

processing options.

Your sequence should include the field movement and your new rollup

ledger.

SAP Easy Access → Accounting → Financial Accounting → Special

PurposeLedger→PeriodicProcessing→Rollup→Create

10. Execute Rollup:

SAP Easy Access: Accounting → Financial Accounting → Special

PurposeLedger→PeriodicProcessing→Rollup→Execute

Execute your rollup for the current period.

UsethedocumenttypeR0towriteLineItemsandselectDetailList.

View the results in your rollup ledger.

401

第 420 页 / 共 509 页

Unit10: Rollups AC220

Solution 15: Definition and Execution of

a Rollup

Task:

Theactualfunctionalareacoststhathavebeenpostedtoyourcompanycodefor

theactualperiodaretoberolledintoyourrollupledger. Therollupledgeristotake

overthefunctionalareas1:1,buttheexpenseaccountcategories(420000-429999,

430000-439999, and 470000-479999) must be substituted by the three global

accounts: 422222,433333,and477777. Yourrollupledgermustbesetupforthe

tableZSLTABTandonlyrollupisto bepermitted for theledger. TheD/Cand

Writelineitemsindicatorsmustalsobeselected. SettheledgercurrencytoUSD

only. Therollupversionforthisledgeris1. AssignyourcompanycodeACXXto

thisledger,andusetheblockingindicator1andthefiscalyearvariantK4.

1. Create a Rollup Ledger:

In the menu, select:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger

→BasicSettings→MasterData→MaintainLedger→CreateLedger

GroupRollupLedgerGroupRollupLedgerGroupRollupLedger

01 XA 02 XB 03 XC

04 XD 05 XE 06 XF

07 XG 08 XH 09 XI

10 XJ 11 XK 12 XL

13 XM 14 XN 15 XO

Continued on next page

402

第 421 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

16 XP 17 XQ 18 XR

a) Create a Rollup Ledger:

In the menu, select:

SAPReferenceIMG →Financial Accounting→SpecialPurpose

Ledger → Basic Settings → Master Data → Maintain Ledger →

Create Ledger

Ledger: See exercise (XA to XR)

Description: Rollup Ledger Group XX

Basic settings:

Summary table: ZSLTABT

Additional Settings:

X Rollup allowed

X Write line items

X Maintain D/C indicator

Saved currencies:

X Ledger currency USD

No quantities

2. Createtherollupversion 1for yourrollupledger.

a) Select Versions.

Version1RollupxDescriptionVersionRollupVersion1

Save your entries.

3. MakeanassignmenttoyourcompanycodeACXX.

a) Assign your Company Code.

Select Assignment CompCd/Comp.

Assign the company code ACXX.

Assignment criteria:

Blocking indicator: 1

Fiscal year variant: K4

Save your entries.

4. Createamulti-dimensionrollupset(GXX-ROLL)toaddappropriatesets.

Set ID: GXX-ROLL

Continued on next page

403

第 422 页 / 共 509 页

Unit10: Rollups AC220

Table: ZSLTABT

Header:

Description: Roll-Multi Group XX

Set lines:

Set ID: Set Short Text

GXX-LEDGER Your ledger (AA - RR)

GXX-COCODE Company code ACXX

*GXX-ACT Record type 0 (= actual)

GXX-VERS1Version 1

GXX-FAREAS Functional areas

GXX-OVERHEAD Overhead postings

= new set

a) Createamulti-dimensionrollupset(GXX-ROLL),toaddappropriate

sets.

In the menu, select:

SAPEasyAccess→Accounting→FinancialAccounting→Special

PurposeLedger→Tools→SetMaintenance→Sets→Create

Set ID: GXX-ROLL

Table: ZSLTABT

Header:

Description: Roll-Multi Group XX

Set lines:

Set ID:Set Short Text

GXX-LEDGERYour ledger (AA- RR)

GXX-COCODE Company codeACXX

*GXX-ACT Record type 0 (= actual)

GXX-VERS1 Version 1

GXX-FAREAS Functional areas

GXX-OVERHEAD Overhead postings

* = new set

5. Definethreerulestodeterminetheprerequisitesofyoursubstitutionactivity:

Continued on next page

404

第 423 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

GXX-RULE1 (Interval 420000 - 429999)

GXX-RULE2 (Interval 430000 - 439999)

GXX-RULE3 (Interval 470000 - 479999)

In the menu, select:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger

→Tools→MaintainValidation/SubstitutionRules→LogicalRulesfor

Validation/Substitution→Rollup→Rollup→Execute

User table: GXX-UTAB Table:

Create rule.

Rulename: GXX-RULE1Accounts420000–429999

Double-click the Rule Content field.

Double-click G/L User Table1 to select it.

Select the account number:

Rule: Accountnumber>=420000ANDaccountnumber<=429999

Save your entries.

Continued on next page

405

第 424 页 / 共 509 页

Unit10: Rollups AC220

DefinetherulesGXX-RULE2andGXX-RULE3inthesamewayasforthe

other intervals.

a) Define three rules to determine for the prerequisites of your

substitution activity:

GXX-RULE1 (Interval 420000 - 429999)

GXX-RULE2 (Interval 430000 - 439999)

GXX-RULE3 (Interval 470000 - 479999)

In the menu, select:

SAPEasyAccess→Tools→Customizing→IMG→EditProject→

SAPReferenceIMG→Financial Accounting→SpecialPurpose

Ledger→Tools→MaintainValidation/SubstitutionRules→Logical

RulesforValidation/Substitution→Rollup→Rollup→Execute

User table: Enter GXX-UTAB

Create rule.

Rulename: GXX-RULE1Accounts420000-429999

Double-click the Rule Content field.

Double-click G/L User Table1 toselect it.

Select the account number:

Rule: Accountnumber>=420000ANDaccountnumber<=429999

Save your entries.

Definetherules, GXX-RULE2andGXX-RULE3, in thesameway

as for the other intervals.

6. Default Rollup Settings:

In the menu, select:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger

→ Periodic Processing → Rollup

a) Default Rollup Settings:

In the menu, select:

SAPReferenceIMG→Financial Accounting→SpecialPurpose

Ledger→PeriodicProcessing→ Rollup

7. Createasubstitutionactivity(GXXS)foryourexpenseaccountsandinclude

your rules and substituted values for the three serial numbers required.

Remembertoincludetheleadingzerosbeforetheaccountnumbers. These

must appear here.

Continued on next page

406

第 425 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

Rollup →Maintain Substitution→NewEntries

a) Createasubstitutionactivity(GXXS)foryourexpenseaccountsand

includeyourrulesandsubstitutedvaluesforthethreeserialnumbers

required.

Rollup → Maintain Substitution

Select New Entries.

Sub- No. Summary- Receiver Constant Rule

Act. Table Field Value

GXXS 001 ZSLTABT RACCT 0000422222 GXX-

RULE1

GXXS 002 ZSLTABT RACCT 0000433333 GXX-

RULE2

GXXS 003 ZSLTABT RACCT 0000477777 GXX-

RULE3

Save your entries.

8. Create a field movement (GXXM) for the characteristics you want to

transfer. Include your substitution activity in this field movement. The

receiver and sender table is ZSLTABT.

Rollup→MaintainFieldMovements→CreateRollupFieldMovement

a) Createafieldmovement(GXXM)forthecharacteristicsyouwantto

transfer. Includeyoursubstitutionactivityinthisfieldmovement. The

receiver and sender table is ZSLTABT.

Rollup → Maintain Field Movements → Create Rollup Field

Movement

Fieldmovement: GRXX(XX=yourgroupnumber)

Press Enter.

Description: FieldMovementforRollupGroupXX

Receiver table: ZSLTABT

Sender table: ZSLTABT

RecField SendField SubAct.

RFAREA RFAREA

RACCT RACCT GXXS

Continued on next page

407

Sub- Act.	No.	Summary- Table	Receiver Field	Constant Value	Rule
GXXS	001	ZSLTABT	RACCT	0000422222	GXX- RULE1
GXXS	002	ZSLTABT	RACCT	0000433333	GXX- RULE2
GXXS	003	ZSLTABT	RACCT	0000477777	GXX- RULE3

RecField	SendField	SubAct.
RFAREA	RFAREA
RACCT	RACCT	GXXS

第 426 页 / 共 509 页

Unit10: Rollups AC220

9. DefineastandardrollupGXX-ROLLwithonesequence.

The sender andreceiver table isZSLTABT.

Intherollupheader,entertherollupsetandselectWriteLineItemsinthe

processing options.

Your sequence should include the field movement and your new rollup

ledger.

SAP Easy Access → Accounting → Financial Accounting → Special

PurposeLedger→PeriodicProcessing→Rollup→Create

a) DefineastandardrollupGXX-ROLLwithonesequence.

Thesenderandreceiver tableisZSLTABT.

Includeyourrollupsetintherollupheaderandselecttheprocessing

option Write Line Items.

Yoursequenceshouldincludethefieldmovementandyournewrollup

ledger.

SAPEasyAccess: Accounting→FinancialAccounting→Special

PurposeLedger→PeriodicProcessing→Rollup→Create

Initial Screen:

Rollup: GXX-ROLL(XX=yourgroupnumber)

Rollup type: Standard

Select Rollup Header

Title: FunctionalareaExpenses(Accountgroups

Sender table: ZSLTABT

Receiver table: ZSLTABT

Rollup set: GXX-ROLL

Select Processing Option.

x Write line items

Select Continue.

Select Rollup sequence.

Enter the field movement GXXM and your rollup ledger (Ledger

XA XR)

Save the rollup definition.

10. Execute Rollup:

Continued on next page

408

第 427 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

SAP Easy Access: Accounting → Financial Accounting → Special

PurposeLedger→PeriodicProcessing→Rollup→Execute

Execute your rollup for the current period.

UsethedocumenttypeR0towriteLineItemsandselectDetailList.

View the results in your rollup ledger.

a) Execute Rollup:

SAPEasyAccess→Accounting→FinancialAccounting→Special

PurposeLedger→PeriodicProcessing→Rollup→Execute

Executeyourrollupforthecurrentperiodandviewtheresultsinyour

rollup ledger.

Rollup: GXX-ROLL

Select Execute.

Confirm company code 1000.

Parameters:

From period andToperiod: Currentperiod

FromfiscalyearandTofiscalyear: Currentfiscalyear

Processing options:

x Write line items

Document type: R0

x Detailed lists

Select Execute.

ViewtheresultsusingFI-SLtotalsrecords(anddocument)display.

409

第 428 页 / 共 509 页

Unit10: Rollups AC220

410

第 429 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

Exercise 16: Additional Optional Exercises

325

Exercise Duration: 30 Minutes

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Additionaloptionalexercisesonpostingswithsubstitutions,rollupandthe

Report Painter

Business Example

Theseoptionalfollow-upexercisesallowyoutoreinforcetheknowledgeyouhave

gainedfromthiscourseandwillgiveyouadditionalpracticeinthekeytechniques

for using the Special Purpose Ledger.

Task:

Direct FI-SL Postings to your ledger

1. DirectFI-SL Postingstoyour ledger AA(..RR).

ThesepostingsaretobemadeforVersion3actualdata. Usetheusertable

GXX-UTAB and document type A2.

Postthefollowingdocumentlinesforthefirsttwoperiodsofthecurrent

quarter:

Forexample: Ifthecurrentquarteristhefirstquarter,repeatthefollowing

document lines for:

a) January (Period 1)

b) February (Period 2)

Otherrequirements: Thebusinessareas0001and1500aretobereplacedby

the business area. RETL (Retail).

Thebusinessareas8000and9000aretobereplacedbythebusinessarea.

WSLE (Wholesale).

FI-SL Substitution: GXX-GSBE

Account BusinesArea SpecREG MaterialNo. AmountUSD

810200 0001 EAST T-IC-F1001 1,000.10-

810200 8000 SOUTH T-IC-R2008 2,000.20-

810200 1500 NORTH T-IC-F1002 3,000.30-

810200 9000 WEST T-IC-R2007 4,000.40-

Continued on next page

411

第 430 页 / 共 509 页

Unit10: Rollups AC220

810200 0001 NORTH T-IC-F1003 5,000.50-

810200 9000 WEST T-IC-R2009 6,000.60-

810300 0001 NORTH T-IC-F1001 2,000.20-

810300 8000 SOUTH T-IC-R2008 3,000.30-

810300 1500 EAST T-IC-F1002 4,000.40-

810300 9000 WEST T-IC-R2007 5,000.50-

810300 0001 SOUTH T-IC-F1003 6,000.60-

810300 9000 EAST T-IC-R2009 7,000.70-

The material numbers you enter, which are all ice-cream types, will

be substituted by the categories VANILLA, CHOCOLATE, and

STRAWBERRY. To this end, enter the user exit U55 for your material

number(RMATNR)inthefieldmovementSPXX.

The target ledger isyour Ledger AA (...RR).

Writedownthedocumentnumberanddisplaytheresults.

2. Rollup

Create the following rollup ledgers:

Group RollupLedger Group RollupLedger Group RollupLedger

01 YA 02 YB 03 YC

04 YD 05 YE 06 YF

07 YG 08 YH 09 YI

10 YJ 11 YK 12 YL

13 YM 14 YN 15 YO

16 YP 17 YQ 18 YR

Nowyou can roll up the datathat you posted to your ledger AA (RR) in

exercise A.

ThisrollupledgermustbedefinedforthetableZZSLTABT.

TheD/CandWritelineitemsindicatorsmustbeselected.

TheledgershouldonlystoretheLedgercurrencyUSD.Therollupversion

for this ledger is 3. Select the blocking indicator for your company

code/ledgerassignmentto1. Thisrollupledgerwillcontainthecompany’s

quarterly results. Thefiscal year variantQ1 must, therefore, be assigned

to the rollup ledger.

Continued on next page

412

第 431 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

The REVENUE ACCOUNTS 810200 and 81030, the ZONES North

and South, and the product groups VANILLA, CHOCOLATE, and

STRAWBERRYmust berolledup1:1. Thebusinessareasshouldnot be

takenoverandtheUSDamountsshouldberoundedtofulldollaramounts

(revenue accounts 810200, and 810300).

Createacorresponding field movementGXXZ(whereXX isyourgroup

number)andassigntheuserexitU02intheUserExitBeforeUpdatefield

movement header.

Refertotheexampleexit routineinthesolutions.

CreatetherollupsetGXX-ROL2forthetableZSLTABT.Thismultisetisto

contain the following sets:

GXX-LEDGER (RLDNR)

GXX-IST (RRCTY = 0) “IST” new basic set for the field RRCTY in

ZSLTABT

GXX-COCODE (RCOCODE)

GXX-VERS3(RVERS=3)“VERS3”newbasicsetfor thefieldRVERS

in ZSLTABT

GXX-NORTH-SOUTH(RZZREGION=NORTH,SOUTH)newbasicset

for the field RZZREGION in ZSLTABT

GXX-PRODGROUPS (RMATNR = VANILLA, CHOCOLATE,

STRAWBERRY)newbasicsetforthefieldRMATNRinZSLTABT

GXX-GSBE(RBUSA=RETL,WSLE)newbasicsetforthefieldRBUSA

in ZSLTABT

GXX-ERL12 (RACCT= 810200, 810300) new basic set for the field

RACCT in ZSLTABT

CreateyourrollupGXX-RUP2(whereXXisyourgroupnumber).

Carry out therollupfor the current quarter.

Rollup: GXX-RUP2

Parameters:

Start date: 01.01. current year

End date: 31.03. current year

This is an example for quarter 1.

x Write line items

Document type R0

x Detail list

Continued on next page

413

第 432 页 / 共 509 页

Unit10: Rollups AC220

View the results in your rollup ledger.

3. FinalreportGXX-FINA,libraryLXX>rep. group: FIXX

Thisreport reflectstheresultsofyouractualdirectpostingsandrolledup

actual data. This is a SAMPLE RESULT for a final report (example for

Q1, Per. 1- 3):

Comparison rollup data/source data

Company code: ACXX

Fiscal year: XXXX Current quarter

RUPLedgerKW-IST URSPRLedgerKW-IST

Regions/Revenues

810200

810300

VANILLA

810200

810300

CHOCOLATE

810200

810300

STRAWBERRY

NORTH

810200

810300

VANILLA

810200

810300

CHOCOLATE

810200

810300

STRAWBERRY

SOUTH

ZONES NORTH-SOUTH

Continued on next page

414

第 433 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

General Selections:

Company code: ACXX

Version: 1

Current fiscal year

415