AC220_EN_Col52_FV_Part_A4 (第7页) | ERP软件技术分享

第 275 页 / 共 411 页

AC220 Lesson: Using Allocations in FI-SL

Lesson Summary

You should now be able to:

• Define the term allocation

• Use the different types of allocation

• Define sender and receiver values

• Create and execute an FI-SL cycle

267

第 276 页 / 共 411 页

UnitSummary AC220

Unit Summary

You should now be able to:

• Define the term allocation

• Use the different types of allocation

• Define sender and receiver values

• Create and execute an FI-SL cycle

268

第 277 页 / 共 411 页

AC220 Test Your Knowledge

Test Your Knowledge

1. During ofexpenses,

recordsareupdatedinthesummarytablewithrecordtype2orrecordtype3.

Fillintheblankstocompletethesentence.

2. Howwouldyoudealwithaccountbalancesduringassessment?

3. Howdo youallocatedivisionsinthecompany?

269

第 278 页 / 共 411 页

TestYourKnowledge AC220

Answers

1. Duringassessmentanddistributionofexpenses,recordsareupdatedinthe

summarytablewithrecordtype2orrecordtype3.

Answer: assessment and distribution

2. Howwouldyoudealwithaccountbalancesduringassessment?

Answer: 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.

3. Howdo youallocatedivisionsinthecompany?

Answer: Divisionsinthecompanycanbeallocatedbysplittingtheminto

cycles,alsoseparatedbytime. Youcanalsosetupallocationcyclesthatare

basedononeanother. Thisenablesyoutoprocesstheservicecostcentersin

thefirstcycleandthefinalcostcentersinthesubsequentcycle.

270

第 279 页 / 共 411 页

Unit 9

Document Split

Unit Overview

Thisunitwillhelpyoulearnabouttheexamplesofdocumentsplitting. Youwill

learnhowtosetupthecustomizingfordocumentsplit. Youwillalsolearnhowto

assigntheparticipants’ledgers,topostthroughtotheirsplitledgers,andcontrol

the split documents.

Unit Objectives

After completing thisunit, you will beableto:

• Describe how a split ledger works

• ExecuteCustomizingactivitiesandsetupasplitledger

Unit Contents

Lesson: Understanding and Customizing Document Split ................272

Exercise 13: Splitting of Documents ....................................279

271

第 280 页 / 共 411 页

Unit9: DocumentSplit AC220

Lesson: Understanding and Customizing Document

Split

Lesson Overview

Thislessondescribeshowasplitledgerworks. Italsodescribeshowtoexecute

thecustomizingactivitiesandhowtosetupasplitledger.

Lesson Objectives

After completingthislesson, you will beable to:

• Describe how a split ledger works

• ExecuteCustomizingactivitiesandsetupasplitledger

Business Example

Yourcompanyneedstoaccesssegmentinformationatthedocumentlevel. The

companywantstoaccuratelymonitorandanalyzeatthebusinessarealevel. In

addition, thecompanywantstogroupitsfinancialstatementsbybusinessarea.

You need to use the document split function in FI-SL to meet the company’s

requirement.

Overview of Document Split

Figure 148: Document Split: Overview

272

第 281 页 / 共 411 页

AC220 Lesson: Understanding and Customizing Document Split

Basic Principles

Figure149: BasicPrinciples: PostingaBusinessTransaction(1)

Adocument can be split basedon characteristics, such as businessarea, profit

center, region, or material.

Becausethenumber of documentsmayincreasedramatically, youmust ensure

thatsufficientstoragespaceisavailablebeforesplittingthedocuments.

ThesplitoccursinFI-SL.Inexceptionalcases,adocumentmustbesplitinFIfor

technicalreasons, suchasforforeigncurrencyvaluations.

Figure150: BasicPrinciples: PostingaBusinessTransaction(2)

Theincomingpaymentissplitduetotheoriginalreceivable.

Cashdiscountandtaxareadjustedproportionallyforeachbusinessarea.

273

第 282 页 / 共 411 页

Unit9: DocumentSplit AC220

Figure151: BasicPrinciples: FinancialStatementsByBusinessArea

Financialstatementscanbepreparedbysplittingthedocuments.

RFBILA10 can be usedto address any ledger.

Customizing the Split Ledger

Figure 152: Overview of the Split Logic

274

第 283 页 / 共 411 页

AC220 Lesson: Understanding and Customizing Document Split

Figure 153: Item Category

Severalitemcategoriescanbedeterminedautomatically.

Forexample,thesystemcanidentifythecustomerandvendoraccounts.

In addition, the system identifies exchange rate differences and cash discount

accounts based on the posting activity.

Otheraccountsmustbespecifiedinthepostingdocument. Anerroroccursinthe

postingdocumentifnoitemcategorycanbedetermined.

Theitemcategorydenotestheitemsofanaccountingdocument.

Theitemcategoryprovidesinformationtothesplitprocessoraboutthecategory

of items that is to be split (target).

The item category also provides information to the split processor about the

category of items to be used for the split.

Forexample,differentitems, suchasvendoritemorVAT,whicharetobesplit

maybecontainedforavendorinvoice(businesstransaction)becausetheexpense

itemsareassignedtodifferentbusinessareaaccountssuchasprofitcenters,funds,

andregions. Theexpenseaccountisusedasabasisforthissplit.

275

第 284 页 / 共 411 页

Unit9: DocumentSplit AC220

Figure 154: Business Transactions

Theindividualbusinesstransactionsmustbeassignedtothevaliddocumenttypes.

Avariantistobecreatedforeachbusinesstransaction,wheretheentriespermitted

at the item category level can be stored.

Figure 155: Split Rule

Thesplittingmethoddetermineshowanonlinedocumentsplitistobecarriedout.

Thismeansthatasettingismadeforeachsplittingmethodtodeterminehowto

dealwiththeindividualitemcategories,forexample,whetherornottheaccount

assignment of the customer item is to be copied from the revenue items in a

customer invoice.

276

第 285 页 / 共 411 页

AC220 Lesson: Understanding and Customizing Document Split

Figure 156: Splitting Method

Figure 157: Assignment to the Ledger

The split ledger must write the line items.

Theactuallineitemtablemustcontainthefollowingadditionalfields:

• WSL:Valueintheoriginaltransactioncurrency(documentcurrency)

• RWCUR:Currencykeyoftheoriginaltransactioncurrency

• BELNR:Documentnumberofanaccountingdocument

• BUZEI:Numberofthepostinglineintheaccountingdocument

• LINETYPE: Item category

• XSPLITMOD:Itemchanged bydocumentsplit

• MWSKZ: VAT indicator

• XSKRL:Indicator-Postinglinenotrelevanttocashdiscount

277

第 286 页 / 共 411 页

Unit9: DocumentSplit AC220

ThesefieldsareautomaticallyaddedusingtheAddsplitfieldsbutton.

For performance reasons, you need to store the following indices to clear the

transactions in the line item table:

• RLDNR: Ledger

• RRCTY: Record type

• RVERS: Version

• RBUKRS: Company code

• FI: Document number

• BUZEI: Item

• REFRYEAR: Reference fiscal year

278

第 287 页 / 共 411 页

AC220 Lesson: Understanding and Customizing Document Split

Exercise 13: Splitting of Documents

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Set upa split ledger and post several entries.

Business Example

Asplit ledgeristobeusedtocarryoutaccuratemonitoringandanalysisat the

business area level.

Task 1:

In the menu, select:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger→

BasicSettings→MasterData→MaintainLedgers→CreateLedger

Set up a split ledger.

1. Create a split ledger.

Group Ledger Group Ledger

01 SA 10 S J

02 SB 11 SK

03 SC 12 SL

04 SD 13 SM

05 SE 14 SN

06 SF 15 SO

07 SG 16 SQ

08 SH 17 SR

09 S I 18 SS

Createaledger forthesummarytableZSPLITT.

2. Additional Settings:

Select

Ledger postings

Write line items**

Summarize

Continued on next page

279

第 288 页 / 共 411 页

Unit9: DocumentSplit AC220

D/C indicator

Maintain balance carry forward

**DoNOTforgettosetlineitemsforyourledger

3. Splitting Method

Add the method 0000000002.

Select Assign Fields.

Field: GSBER

Select Zero balance.

4. Assign Company Code to Ledger.

AssignthecompanycodeACxxto yourledger.

ReleasethiscombinationfordirectpostingandusethefiscalyearvariantK4

(Calendar year and 4 spec. periods).

5. Assignment of Activitiesand FieldMovements

To post to your ledger/company codecombination, you need appropriate

activities.

AssigntheactivityFIpostings(RFBU)asrequiredpostingandusethefield

movement ZSPL.

Save your ledger.

Task 2:

Post an Invoice.

In the menu, select:

SAP Easy Access → Accounting → Financial Accounting → Accounts

Receivable→Document Entry→Invoice(FB70)

1. Customer Invoice

YousellproductsforEUR1160.00incl. 16%outputtax(taxcodeAN),that

isEUR160.00. Thenumberofthecustomer master recordisT-F00A00.

The invoice is dated the previous day and was created directly by the

accounting department.

2. Post an Invoice.

UsetheG/Laccount800200andposttheinvoicetothebusinessareasBA01

andBA02withtheinvoiceitemsEuro696and464. (Tip: Usescreenvariant

Z_WITHBUSINESSAREAtoenteryour items).

Writedownthenumberoftheaccountingdocument.

Continued on next page

280

第 289 页 / 共 411 页

AC220 Lesson: Understanding and Customizing Document Split

______________________________________________________

Checkwhetherthisdocumentwassplitinyourledger.

3. Post Incoming Payments

Post → Incoming Payment

Post the incoming check for EUR 1125,20 taking into account the 3%

discountwithtoday’sdateasthedocumentandpostingdatetotheincoming

check account 113108,

Settletheinvoiceto the customer T-F00A00.

Write down the document number:

______________________________________________________

Checkwhetherthisdocumentwassplitinyourledger.

281

第 290 页 / 共 411 页

Unit9: DocumentSplit AC220

Solution 13: Splitting of Documents

Task 1:

In the menu, select:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger→

BasicSettings→MasterData→MaintainLedgers→CreateLedger

Set up a split ledger.

1. Create a split ledger.

Group Ledger Group Ledger

01 SA 10 S J

02 SB 11 SK

03 SC 12 SL

04 SD 13 SM

05 SE 14 SN

06 SF 15 SO

07 SG 16 SQ

08 SH 17 SR

09 S I 18 SS

Continued on next page

282

第 291 页 / 共 411 页

AC220 Lesson: Understanding and Customizing Document Split

Createaledger forthesummarytableZSPLITT.

a) Create a split ledger.

Group Ledger Group Ledger

01 SA 10 S J

02 SB 11 SK

03 SC 12 SL

04 SD 13 SM

05 SE 14 SN

06 SF 15 SO

07 SG 16 SQ

08 SH 17 SR

09 S I 18 SS

CreatealedgerforthesummarytableZSPLITT.

2. Additional Settings:

Select

Ledger postings

Write line items**

Summarize

D/C indicator

Maintain balance carry forward

**DoNOT forgettosetlineitemsforyourledger

a) Additional Settings:

Select

Ledger postings

Write line items**

Summarize

D/C indicator

Maintain balance carry forward

**DoNOTforgettosetlineitemsforyourledger

3. Splitting Method

Continued on next page

283

第 292 页 / 共 411 页

Unit9: DocumentSplit AC220

Add the method 0000000002.

Select Assign Fields.

Field: GSBER

Select Zero balance.

a) Splitting Method

Add the method 0000000002.

Select Assign Fields.

Field: GSBER

Select Zero balance.

4. Assign Company Code to Ledger.

AssignthecompanycodeACxxto yourledger.

ReleasethiscombinationfordirectpostingandusethefiscalyearvariantK4

(Calendar year and 4 spec. periods).

a) Assign Company Code to Ledger.

AssignthecompanycodeACxxtoyourledger.

Release this combination for direct posting and use the fiscal year

variantK4(Calendaryear and4spec. periods).

5. Assignment of Activitiesand FieldMovements

To post to your ledger/company codecombination, you need appropriate

activities.

AssigntheactivityFIpostings(RFBU)asrequiredpostingandusethefield

movement ZSPL.

Save your ledger.

a) Assignment of ActivitiesandFieldMovements

To post to your ledger/company code combination, you need

appropriate activities.

Assign the activity FI postings(RFBU) as required posting anduse

the field movement ZSPL.

Save your ledger.

Continued on next page

284

第 293 页 / 共 411 页

AC220 Lesson: Understanding and Customizing Document Split

Task 2:

Post an Invoice.

In the menu, select:

SAP Easy Access → Accounting → Financial Accounting → Accounts

Receivable→Document Entry→Invoice(FB70)

1. Customer Invoice

YousellproductsforEUR1160.00incl. 16%outputtax(taxcodeAN),that

isEUR160.00. Thenumberof thecustomer masterrecordisT-F00A00.

The invoice is dated the previous day and was created directly by the

accounting department.

a) Customer Invoice

YousellproductsforEUR1160.00incl. 16percentoutputtax(taxcode

AN),thatisEUR160.00. Thenumberofthecustomermasterrecord

isT-F00A00. Theinvoiceisdatedthepreviousdayandwascreated

directly by theaccounting department.

2. Post an Invoice.

UsetheG/Laccount800200andposttheinvoicetothebusinessareasBA01

andBA02withtheinvoiceitemsEuro696and464. (Tip: Usescreenvariant

Z_WITHBUSINESSAREAtoenter youritems).

Writedownthenumberoftheaccountingdocument.

______________________________________________________

Checkwhetherthisdocumentwassplitinyourledger.

a) Post an Invoice.

UsetheG/Laccount800200andposttheinvoicetothebusinessareas

BA01andBA02withtheinvoiceitemsEuro696and464.

Hint: Use screen variant Z_:WITH BUSINESS AREA to

enter your items.

Writedownthenumberoftheaccountingdocument:

______________________________________________________

Checkwhetherthisdocumentwassplitinyourledger.

3. Post Incoming Payments

Post → Incoming Payment

Continued on next page

285

第 294 页 / 共 411 页

Unit9: DocumentSplit AC220

Post the incoming check for EUR 1125,20 taking into account the 3%

discountwithtoday’sdateasthedocumentandpostingdatetotheincoming

check account 113108,

Settletheinvoice tothecustomer T-F00A00.

Write down the document number:

______________________________________________________

Checkwhetherthisdocumentwassplitinyourledger.

a) Post Incoming Payments

Post → Incoming Payment

PosttheincomingcheckforEUR1125,20takingintoaccountthe3%

discount with today’s date as the document and posting date to the

incoming check account 113108,

Settletheinvoicetothecustomer T-F00A00.

Write down the document number:

______________________________________________________

Checkwhetherthisdocumentwassplitinyourledger.

286

第 295 页 / 共 411 页

AC220 Lesson: Understanding and Customizing Document Split

Lesson Summary

You should now be able to:

• Describe how a split ledger works

• ExecuteCustomizingactivitiesandsetupasplitledger

287

第 296 页 / 共 411 页

UnitSummary AC220

Unit Summary

You should now be able to:

• Describe how a split ledger works

• ExecuteCustomizingactivitiesandsetupasplitledger

288

第 297 页 / 共 411 页

AC220 Test Your Knowledge

Test Your Knowledge

1. Financialstatementscanbepreparedby thedocuments.

Fillintheblankstocompletethesentence.

2. Whatistheproceduretoperformanonlinedocumentsplit?

289

第 298 页 / 共 411 页

TestYourKnowledge AC220

Answers

1. Financialstatementscanbepreparedbysplittingthedocuments.

Answer: splitting

2. Whatistheproceduretoperformanonlinedocumentsplit?

Answer: Thesplittingmethoddetermineshowanonlinedocumentistobe

split. Youneedtomakethesettingsforeachsplittingmethodtodetermine

howtodealwith theindividual itemcategories.

290

第 299 页 / 共 411 页

Unit 10

Rollups

Unit Overview

Thefocusofthisunitistosetuptheprerequisitesforrollups. Tobeginwith,you

willlearnhowtoinvestigatethedifferentformsofsummarization. Youwilllearn

howtodefinearollupandviewtheresults. Theunitwillalsocoverinformation

onhowtodefineandexecuteareportontherollupdata.

Unit Objectives

After completing thisunit, you will beableto:

• Describe the types of summarization

• Describe sequences in rollup

• Explain the rollup set

• Describe field movement

• Explain substitution and user exits

• Explain how to execute a rollup

Unit Contents

Lesson: Rollups in FI-SL.......................................................292

Exercise 14: Definition and Execution of a Rollup ....................311

Exercise 15: Additional Optional Exercises.............................323

291

第 300 页 / 共 411 页

Unit10: Rollups AC220

Lesson: Rollups in FI-SL

Lesson Overview

Thislessondescribesrollupsandthetypesof summarization. Italsodescribes

sequencesinrollupandrollupset. Itexplainsfieldmovement,substitution,and

userexits. Inaddition,itdescribeshowtoexecutearollup.

Lesson Objectives

After completingthislesson, you will beable to:

• Describe the types of summarization

• Describe sequences in rollup

• Explain the rollup set

• Describe field movement

• Explain substitution and user exits

• Explain how to execute a rollup

Business Example

For the report, “Functional Area-Wise Costs”, business line managers want to

aggregatethedataathigherlevelstoaccountinggroupsandbusinesslinezones

andupgrade balancesfor simulation andstatistical reasons. TheFI-SL Rollup

functioncondensesandsubstitutesdataacrosscharacteristics. Ifthisisacceptable

tothemanagement,youneedtocreateandexecutearollupandchecktheresults

of the date update.

292

第 301 页 / 共 411 页

AC220 Lesson: Rollups in FI-SL

Overview and Example of Rollups

Figure 158: Rollups: Overview

Figure 159: Rollup Ledgers

Thenumber of recordsinthesummary tablecanbelargeduetotheadditional

account assignments.

Forcertainevaluations,thetotalsarenotrequiredtohavethesamelevelofdetail

as in the source ledger.

293

第 302 页 / 共 411 页

Unit10: Rollups AC220

Types of Summarization

Figure 160: Summarization Using Characteristics

By omitting certain characteristics, you can summarize the data in the rollup

ledger to a specific level of detail.

Figure 161: Rollup: Summarization Using Substitutions

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.

294

第 303 页 / 共 411 页

AC220 Lesson: Rollups in FI-SL

Figure 162: 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.

Figure 163: Rollup with Hierarchical Summarization

295

第 304 页 / 共 411 页

Unit10: Rollups AC220

Rollupwithhierarchicalsummarizationallowsyoutosummarizethedatafromthe

sourceledgerbottom-upaccordingtothehierarchicalstructureyouhavedefined

(for exampleacost centerorprofitcenterhierarchy).

Whentherollupisexecutedthesummarizedvaluesarestoredunderthenameof

the representative value of the respectiveset.

Sequences in Rollup

Figure 164: 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.

296

第 305 页 / 共 411 页

AC220 Lesson: Rollups in FI-SL

Figure 165: 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

297

第 306 页 / 共 411 页

Unit10: Rollups AC220

Figure 166: Rollup Sequence

Dividingarollupintosequenceswithtargetledgers.

Figure 167: Restrictions in a Sequence

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

sequence set or a rule.

298

第 307 页 / 共 411 页

AC220 Lesson: Rollups in FI-SL

Figure 168: Sequence Set

SequenceSet-Youcanuseasequencesettospecifywhichdatashouldberolled

upforthespecificsequence. Ifyouenterasequenceset, therelevantsequence

canonlyreadthosedatabaserecordsthatsatisfyboththerollupheadersetandthe

sequence set when you execute the rollup.

Figure 169: Sequence Rule

299

第 308 页 / 共 411 页

Unit10: Rollups AC220

Rule-Youcanusearule(selectioncondition)tofurtherlimitthetotalsetofdata

beingselectedifthedatacannotbelimitedusingtherollupset(orthesequence

set);forexample,youcandefineORconditionsbetweenthecharacteristics.

Figure 170: Sequence Block

BlockingIndicator-IftheBlockedindicatorissetforthesequence,thesequence

isnottakenintoaccount whentherollupisexecuted.

300

第 309 页 / 共 411 页

AC220 Lesson: Rollups in FI-SL

Rollup Set

Figure 171: 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

dimensionof thesingle-dimension set inthefield, “Hierarchydimension”, the

systemdeterminesthatthissetistobeusedintherollupheadersettodetermine

the hierarchy structure.

301

第 310 页 / 共 411 页

Unit10: Rollups AC220

Figure 172: 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.

Figure 173: Multidimension Set: Basic Entries

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

different fields (characteristics) are assigned.

302

第 311 页 / 共 411 页

AC220 Lesson: Rollups in FI-SL

Figure 174: 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.

Therollupsetdeterminesthemaximumquantityofdatathatcanbeselectedfor

the rollup.

303

第 312 页 / 共 411 页

Unit10: Rollups AC220

Field Movement

Figure 175: Field Movement

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

characteristicsthataretransferredwiththefixedcharacteristicsduringtherollup.

Figure 176: Field Movement (1)

304

第 313 页 / 共 411 页

AC220 Lesson: Rollups in FI-SL

Figure 177: Field Movement (2)

Figure 178: Field Movement (3)

305

第 314 页 / 共 411 页

Unit10: Rollups AC220

Substitution and User Exits

Figure 179: Substitution Activity

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

betransferred. Foreachfieldmovement, youmustenteravalueforthesender

and receiver fields.

If thecharacteristicsarenot transferred to the receiver table, thedatafor these

fields is summarized.

Asubstitutionactivitycanbeassignedtoeachreceiverfield.

Usingasubstitutionactivity, youcanreplacethecontentsof thecharacteristics

(for example, RFAREA) with anyconstant value.

306

第 315 页 / 共 411 页

AC220 Lesson: Rollups in FI-SL

Figure 180: 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.

307

第 316 页 / 共 411 页

Unit10: Rollups AC220

Executing a Rollup

Figure 181: Executing a Rollup

Whenyouexecutea rollup, you specifythe periodsthat areto berolled upby

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.

308

第 317 页 / 共 411 页

AC220 Lesson: Rollups in FI-SL

Appendix

Figure 182: SIMPLY PUT: Create a Rollup

309

第 318 页 / 共 411 页

Unit10: Rollups AC220

310

第 319 页 / 共 411 页

AC220 Lesson: Rollups in FI-SL

Exercise 14: Definition and Execution of

a Rollup

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

Grp. Rollup- Grp. Rollup- Grp. Rollup-

Ledger Ledger Ledger

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.

3. MakeanassignmenttoyourcompanycodeACXX.

Continued on next page

311

第 320 页 / 共 411 页

Unit10: Rollups AC220

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 Recordtype 0(=actual)

GXX-VERS1 Version 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

312

第 321 页 / 共 411 页

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.

313

第 322 页 / 共 411 页

Unit10: Rollups AC220

Solution 14: 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

Grp. Rollup- Grp. Rollup- Grp. Rollup-

Ledger Ledger Ledger

01 XA 02 XB 03 XC

04 XD 05 XE 06 XF

07 XG 08 XH 09 XI

Continued on next page

314

第 323 页 / 共 411 页

AC220 Lesson: Rollups in FI-SL

10 XJ 11 XK 12 XL

13 XM 14 XN 15 XO

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.

Continued on next page

315

第 324 页 / 共 411 页

Unit10: Rollups AC220

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

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 Recordtype 0(=actual)

GXX-VERS1 Version 1

GXX-FAREAS Functional areas

GXX-OVERHEAD Overhead postings

Continued on next page

316

第 325 页 / 共 411 页

AC220 Lesson: Rollups in FI-SL

= 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-LEDGER Your Ledger(AA-RR)

GXX-COCODE CompanyCodeACXX

*GXX-IST Recordtype0(=actual)

GXX-VERS1 Version 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.

Continued on next page

317

第 326 页 / 共 411 页

Unit10: Rollups AC220

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

Select the account number:

Rule: Accountnumber>=420000ANDaccountnumber<=429999

Save your entries.

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:

Continued on next page

318

第 327 页 / 共 411 页

AC220 Lesson: Rollups in FI-SL

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger

→ Periodic Processing → Rollup

a) Default Rollup Settings:

In the menu, select:

SAPReferenceIMG →Financial Accounting→SpecialPurpose

Ledger→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

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.

Continued on next page

319

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

第 328 页 / 共 411 页

Unit10: Rollups AC220

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

9. DefineastandardrollupGXX-ROLLwithonesequence.

The sender andreceiver table isZSLTABT.

Intherollupheader,entertherollupsetandselectWriteLineItemsinthe

processing options.

Your sequence should include the field movement and your new rollup

ledger.

Continued on next page

320

RecField	SendField	SubAct.
RFAREA	RFAREA
RACCT	RACCT	GXXS

第 329 页 / 共 411 页

AC220 Lesson: Rollups in FI-SL

SAP Easy Access → Accounting → Financial Accounting → Special

PurposeLedger→PeriodicProcessing→Rollup→Create

a) DefineastandardrollupGXX-ROLLwithonesequence.

Thesender andreceiver 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:

SAP Easy Access: Accounting → Financial Accounting → Special

PurposeLedger→PeriodicProcessing→Rollup→Execute

Execute your rollup for the current period.

UsethedocumenttypeR0towriteLineItemsandselectDetailList.

Continued on next page

321

第 330 页 / 共 411 页

Unit10: Rollups AC220

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: Current period

FromfiscalyearandTofiscalyear: Currentfiscalyear

Processing options:

x Write line items

Document type: R0

x Detailed lists

Select Execute.

ViewtheresultsusingFI-SLtotalsrecords(anddocument)display.

322

第 331 页 / 共 411 页

AC220 Lesson: Rollups in FI-SL

Exercise 15: Additional Optional Exercises

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 Business SpecREG MaterialNo AmountUSD

Area

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

323