AC220_EN_Col52_FV_Inst_A4 (第10页)

第 349 页 / 共 509 页

AC220 Lesson: Using Allocations in FI-SL

Cyclesarestoredchronologically. Duringprocessing,youcanselectcyclesusing

the validity period.

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

separated by time. You canalso set up allocation cyclesthat are based on one

another. Thisenablesyoutoprocesstheservicecostcentersinthefirstcycleand

the final cost centers in thesubsequent cycle.

Cycles are processed in succession.

Figure 147: Allocations: Example

Figure 148: Field Usage: Segment Level

331

第 350 页 / 共 509 页

Unit8: Allocations AC220

FieldstobeusedinAllocationsmustbedeclaredatdifferentlevels:

AttheSegmentlevelifafieldisuseditcanbeenteredasareceiverorsenderwith

a single value, an interval and/or a set.

Demonstration: Demonstration on Cycles and

Segments

Purpose

To demonstrate on cycles and segments

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. Explainthefirsttaskthatwillbetoallocatetheactualfunctionalareacosts

to the respective special regions.

Before demonstrating the definition of a cycle, show how to set up the

characteristicRZZREGION,tableZSLTABTtobeusedasareceiverfield.

Menu: FI-SLCustomizing→PeriodicProcessing→Allocation→Maintain

Field Usage for Distribution

Make an entry as a copy of ZZSPECT-RZSPREG: Allocation type: V,

Act./Plan.: I General Settings: Display.

Field usage :

Control Singlevalue Interval Set

Receiver x ja ja ja

Continue and save.

AnentryhasalsotobemadeforZSLTABT-RFAREAbecausethiswillalso

beusedintheallocationsyouandtheparticipantswilldefineandrun.

Therefore, makeanentryforthis,too, asacopyofZZSPECT-RFAREA:

Allocationtype: V,Act./Plan.: I,GeneralSettings: Display.

Field usage :

332

	Control	Singlevalue	Interval	Set
Receiver	x	ja	ja	ja

第 351 页 / 共 509 页

AC220 Lesson: Using Allocations in FI-SL

Control Singlevalue Interval Set

Sender x yes yes yes

Receiver x yes yes yes

Continue and save.

MenuSAPR/3system→Accounting→FinancialAccounting→Special

purposeledger→Periodicprocessing→Allocation→ActualDistribution

→ Create

Inititial sceen:

Ledger: ZZ

Cycle: TR-DIST

Starting date: 01.01.Current Year

Execute.

Header Data:

Text: Allocation of Farea costs

Indicators:

None chosen

Company code: AC00

Preset selection criteria:

Version: 001

Attach segment.

Sender values Tracing factor

Segment name: S1FAREA costs→ Regions

Rule 1 Rule 3

Leave the remaining settingsas they are.

Allocation characteristics:

Sender:

Account number: Set G00-GEN-EXPENSE

Functional area: Set: G00-FAREAS

Receiver:

Special Region: Set: G00-SPECREGS

Press Button ‘Tracing factors’

333

	Control	Singlevalue	Interval	Set
Sender	x	yes	yes	yes
Receiver	x	yes	yes	yes

第 352 页 / 共 509 页

Unit8: Allocations AC220

Receiver percent

N-00A 10

S-00A 20

E-00A 30

W-00A 40

Save cycle.

Return and execute cycle:

Allocation →Actual distribution→ Execute

Inititial screen:

Ledger: ZZ

Current period and year.

Set the flag for detail listand optionally forjournal if you need a fuller

breakdownonthereceivers,sendersandtheallocatedamounts.

Executefirst as atest run and then for real.

Showtheprotocol,senders,andreceivers. Pointoutthedocumentnumber.

GototheSummaryrecordsdisplayandshowtheresultsforrecordtype2.

Drilldownfromthesummaryrecordtoshowthesingleitems.

Nextdemonstration(OPTIONAL):ReceiverControl:

Scenario: Allocation of the functional area costs to the regions. Tracing

factorforthereceiversaretherevenueswhichhavebeenproducedinthese

regions.

Demonstration: Procedure:

Create an Allocation Cycle G00-REGS (Validity dates 01.01.Curyear -

31.12.Curyear)

Allocation →Actual distribution → Create

Ledger: Your Ledger

Cycle: G00-REGS

Starting date: 01.01.Curyear

Enter

Text: Wages & Salary Allocation

Indicators: None set

Preset selection criteria:

Company code: AC00

334

第 353 页 / 共 509 页

AC220 Lesson: Using Allocations in FI-SL

Version: 1

2. Add one Segment (S1) to your Cycle with the appropriate Sender and

Receiverinformation,SenderandReceiverrulesandtracingfactor(Variable

portions) for the receivers.

Beforehand define the following sets:

• G00-EXPENSES ‘Expenses’. Reference this on G00-WAGES and

add 2 new lines

003 430000

004 431000

• G00-BLANK’FareaInitialvalue’(Field=RFAREA)

001 -

INHERITANCEPRINCIPLE:Nofunctionalareasrecordedwiththe

revenues posted in the receivers!

Press Button ‘Attach Segment’.

Segmentname: S1‘Distr.ExpensestoSpecialRegions’

Sender values Tracing factor

Rule : 1 Rule: 1 (Var.portions

Leave rest as set Typeofvar.part. 5(grp.act)

Scaleneg.factors3(Neg→Pos)

Allocation characteristics:

Sender: Accountnumber: SetG00-EXPENSES

Functionalarea: Set: G00-FAREAS

Receiver: SpecialRegion: Set: G00-SPECREGS

Press Button ‘Tracing factors’.

Selectioncriteria: Accountnumber: SetG00-EXPENSES

Functionalarea: Set: G00-FAREAS

335

Sender values	Tracing factor
Rule : 1	Rule: 1 (Var.portions
Leave rest as set	Typeofvar.part. 5(grp.act)
	Scaleneg.factors3(Neg→Pos)

Sender:	Accountnumber:	SetG00-EXPENSES
	Functionalarea:	Set: G00-FAREAS
Receiver:	SpecialRegion:	Set: G00-SPECREGS

Selectioncriteria:	Accountnumber:	SetG00-EXPENSES
	Functionalarea:	Set: G00-FAREAS

第 354 页 / 共 509 页

Unit8: Allocations AC220

3. ExecutetheCycleforthecurrentperiod,firstintestmodeandthenforreal.

Allocation →Actual distribution→ Execute

Document type: A0, Processwith: xDetailedlists

Ledger: ZZParameters:Period: CurrentPeriod,FiscalYear: CurrentYear

First with x Test run and for real.

Inyourprotocol,showtheSendersandReceiversandintherealrunshow

the document number.

4. Showthesummaryrecordsandthedocumentpostedthesamemenupathas

for displaying actual totals.

You can define and execute a report similar to the one needed in the

participants’ exercise.

336

第 355 页 / 共 509 页

AC220 Lesson: Using Allocations in FI-SL

Exercise 13: Allocation of Expenses to

265

Regions

Exercise Duration: 50 Minutes

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Define and execute an allocation

Business Example

To enable the costs posted in thegeneral functional areas to be monitored and

analyzedaccurately, thesecostsmustbeassignedtospecialregions. Thisisthe

basisusedtodeterminetheviabilityofproductssoldintheseareas.

Task:

In the menu, select:

SAPEasyAccess→Accounting→FinancialAccounting→SpecialPurpose

Ledger→ Periodic Processing → Allocation

The actual totals for general expenses accrued in the actual period have been

posted in version 1 for the company code ACXX to the accounts 472000 and

476000inthefunctionalareassales(0300),administration(0400),andRandD

(0500). TheseamountsaretobedistributedtothespecialregionsN-XX1,S-XX1,

E-XX1,andW-XX1. Thetracingfactorforthesereceiverspecialregionsare10,

20, 30, and 40 percent, respectively.

Proceed as follows:

1. Create the allocation cycle GXX-DIST for your ledger (validity dates

01.01.current year -31.12.current year). Enter the text: General Expense

AllocationIndicatorandfieldgroup: Not selected

Default selection criteria: Company Code ACXX and Version 1. In the

menu,selectAllocation→CreateActualDistribution

2. Addthesegment(S1)toyourcyclewiththeappropriatesenderandreceiver

information, sender and receiver rules, and the tracing factor (%) for the

receivers. Inthemenu,selectAllocation→ActualDistribution→Execute

3. Executethecycleforthecurrentperiod,firstasatestrunandasanupdate

run. SelectDetailedLists. ThedocumenttypeisA0.

4. Viewthetotalsrecordsandthedocumentpostedusingthesamemenupathas

fordisplayingactualtotals. Therecordtypefortheassessment/distribution

of actual data is 2.

337

第 356 页 / 共 509 页

Unit8: Allocations AC220

Solution 13: Allocation of Expenses to

Regions

Task:

In the menu, select:

SAPEasyAccess→Accounting→FinancialAccounting→SpecialPurpose

Ledger→ Periodic Processing → Allocation

The actual totals for general expenses accrued in the actual period have been

posted in version 1 for the company code ACXX to the accounts 472000 and

476000inthefunctionalareassales(0300),administration(0400),andRandD

(0500). TheseamountsaretobedistributedtothespecialregionsN-XX1,S-XX1,

E-XX1,andW-XX1. Thetracingfactorforthesereceiverspecialregionsare10,

20, 30, and 40 percent, respectively.

Proceed as follows:

1. Create the allocation cycle GXX-DIST for your ledger (validity dates

01.01.current year -31.12.current year). Enter the text: General Expense

AllocationIndicatorandfieldgroup: Not selected

Default selection criteria: Company Code ACXX and Version 1. In the

menu,selectAllocation→CreateActualDistribution

a) CreatetheallocationcycleGXX-DISTforyourledger(validitydates

01.01.current year- 31.12.current year).

Allocation →ActualDistribution→Create

Ledger: Your ledger

Cycle: GXX-DIST (XX=yourcompanycode)

Start date: 01.01.current year

Select Enter.

Text: General Expense Allocation

Indicator and field groups: None set

Default selection criteria:

Companycode: ACXX(XX=yourcompanycode)

Version: 1

Continued on next page

338

第 357 页 / 共 509 页

AC220 Lesson: Using Allocations in FI-SL

2. Addthesegment(S1)toyourcyclewiththeappropriatesenderandreceiver

information, sender and receiver rules, and the tracing factor (%) for the

receivers. Inthemenu,selectAllocation→ActualDistribution→Execute

a) Addthesegment (S1)toyour cyclewith theappropriatesender and

receiverinformation,senderandreceiverrules,andthetracingfactor

(%) for the receivers.

Select Attach Segment.

Segmentname: S1 Distr. Gen.ExpensestoSpecialRegions

Sendervalues Receiver tracingfactor

Rule: Postedamounts Rule: Fixedpercentages

Adopt other settings

Sender/Receiver:

Sender:

Accountnumber: Set: GXX-GEN-EXPENSE

Functional area: Set: GXX-FAREAS

Receiver:

Special region: Set: GXX-SPECREGS

Select Tracing factors.

Receiver Percent

N-001 10

S-0001 20

E-001 30

W-001 40

Save the cycle.

Continued on next page

339

第 358 页 / 共 509 页

Unit8: Allocations AC220

3. Executethecycleforthecurrentperiod,firstasatestrunandasanupdate

run. SelectDetailedLists. ThedocumenttypeisA0.

a) Executethe cyclefor thecurrentperiod, firstasatestrunandasan

update run.

Allocation→ActualDistribution→Execute

Ledger: Your ledger

Parameters:

Period: Current period

Fiscal year: Current year

Document type: A0

Processing options:

x Detailed lists

SelectTestrunfirst,andthenexecutetheupdaterun.

Displaythesenderandrecipientinthelog. Writedownthedocument

number when you executetheupdaterun.

4. Viewthetotalsrecordsandthedocumentpostedusingthesamemenupathas

fordisplayingactualtotals. Therecordtypefortheassessment/distribution

of actual data is 2.

a) Viewthetotalsrecordsandthedocumentpostedusingthesamemenu

path as for displaying actual totals.

Note: Therecordtypefortheassessment/distributionofactual

allocated data is 2.

340

第 359 页 / 共 509 页

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

341

第 360 页 / 共 509 页

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

342

第 361 页 / 共 509 页

AC220 Test Your Knowledge

Test Your Knowledge

271

1. During ofexpenses,

recordsareupdatedinthesummarytablewithrecordtype2orrecordtype3.

Fillintheblankstocompletethesentence.

2. Howwouldyoudealwithaccountbalancesduringassessment?

3. Howdo youallocatedivisionsinthecompany?

343

第 362 页 / 共 509 页

TestYourKnowledge AC220

Answers

272

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.

344

第 363 页 / 共 509 页

Unit 9

Document Split

273

Explaintheconceptofdocumentsplittingusingexamples. Demonstratehowto

setupthecustomizingfordocumentsplit. Explainhowtoassigntheledgers. Then

detailhowtopostthroughtothesplitledgersandcontrolthesplitdocuments.

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 ................346

Demonstration: Demonstration of the Split Method....................357

Exercise 14: Splitting of Documents ....................................359

345

第 364 页 / 共 509 页

Unit9: DocumentSplit AC220

Lesson: Understanding and Customizing Document Split

Lesson Duration: 45 Minutes

274

Lesson Overview

Thislessondescribeshowasplitledgerworks. Italsodescribeshowtoexecute

thecustomizingactivitiesandhowtosetupasplitledger.

Lesson Objectives

After completingthislesson, you will beable to:

• Describe how a split ledger works

• ExecuteCustomizingactivitiesandsetupasplitledger

Explaintotheparticipantshowasplitledgerworks. Demonstratehowtosetthe

customizingactivities. Explainhowtosetupasplitledger.

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

Using document splitting, the system transfers account assignment objects to

lineitemstowhichtheywerenotassigned,forexample,thebusinessareaofthe

expenseitemstothepayableitems. Thismaynecessitatethesplittingofdocument

items, whereby document items are transferred as several line items. This is

requiredifseveralpayableitemsareenteredwithvariousbusinessareas.

If the business area account assignment was already entered for all line items

during posting, this data is not overwritten when the documents are split.

DocumentsplittinginvolvessplittingthelineitemsofFI-SLdocumentsonlyand

does not affect financial accountingdocuments.

Example

346

第 365 页 / 共 509 页

AC220 Lesson: Understanding and Customizing Document Split

An item category, such as vendor A, isdefined as an itemcategory tobesplit.

Otheritemcategoriesarethenassignedtothisitemcategoryasbasecategories

(forexample,theexpenseitems). Thesebasicitemcategoriescontaintheaccount

assignment objects that are transferred to the vendor line items to be split. A

vendorinvoicecontainsthefollowinglineitemswhenentered:

BS Account Business area Amount

40 300000 0001 40.00

40 300000 0002 60.00

31 Vendor A 100.00

Aftersplitting,theFI-SLdocumentisappears,asshown:

BS Account Business area Amount

40 300000 0001 40.00

40 300000 0002 60.00

31 Vendor A 0001 40.00

31 Vendor A 0002 60.00

Figure 149: Document Split: Overview

347

第 366 页 / 共 509 页

Unit9: DocumentSplit AC220

Basic Principles

Principles: Posting aBusinessTransactionandBalanceSheet byBusiness

Area

Show examples of a revenueposting and incoming customer payment. Using

documentsplitting, theaccountsreceivableandtaxitemsaresplitaccordingto

businessareasintheprimarydocumentandsentexclusivelytoaspecial-purpose

ledger. The resulting discounts are also taken into consideration to split the

documents. Asaresult,regroupingthebalancesisnotnecessaryaswouldbethe

casewiththeb/sandPandLadjustmentprograms,SAPF180andSAPF181.

Figure150: BasicPrinciples: PostingaBusinessTransaction(1)

A document can be split basedon characteristics, such asbusiness area, profit

center, region, or material.

Becausethenumber of documentsmayincreasedramatically, youmust ensure

thatsufficientstoragespaceisavailablebeforesplittingthedocuments.

ThesplitoccursinFI-SL.Inexceptionalcases,adocumentmustbesplitinFIfor

technicalreasons,suchasforforeigncurrencyvaluations.

348

第 367 页 / 共 509 页

AC220 Lesson: Understanding and Customizing Document Split

Figure151: BasicPrinciples: PostingaBusinessTransaction(2)

Theincomingpaymentissplitduetotheoriginalreceivable.

Cashdiscountandtaxareadjustedproportionallyforeachbusinessarea.

Figure152: BasicPrinciples: FinancialStatementsByBusinessArea

Financialstatementscanbepreparedbysplittingthedocuments.

RFBILA10 can be used to address any ledger.

349

第 368 页 / 共 509 页

Unit9: DocumentSplit AC220

Customizing the Split Ledger

Overview of the Splitting Logic:

• Main customizing points:

• Item category

• Business transaction

• Splitting rule

• Splitting method

ItemCategory: AssignAccountNumberItemCategory.

Eachbusinessprocessthatyousetuphastobeanalyzedbythedocumentsplitting

of SAP R/3 Enterprise. The system analyzes each document item to check

whether or not the document item is an item that should not bechanged or an

item that should be split.

Toenablethesystemtodeterminehowtheindividualdocumentitemsaretobe

handled,youassignthedocumentitemstoanitemcategory.

Theaccountnumber determinestheitemcategory. Inthisactivity, youneedto

define the following accounts in the system:

• Revenue account

• Expense account

• Bank account/cash account

• Balance sheet account

All other accounts are determined by the system and you do not have to enter

this information here. You can enter an account interval because SAP R/3

EnterprisedeterminesSAP-definedaccountsanddoesnotallowSAPsettingsto

be overwritten by your own settings.

Thefollowingitemcategoriesareincludedinthesystem:·

• Customer

• Vendor

• Cash discount offsetting

• Asset

• Material

• Expense

• Revenue

Businesstransactions: Inthestandardsystem,SAPdeliversbusinesstransactions

withpermitteditemcategories. SAPalsodeliversbusinesstransactionvariants

for the business transactions.

350

第 369 页 / 共 509 页

AC220 Lesson: Understanding and Customizing Document Split

Youcannotdefineyourownbusinesstransactions. However,youcandefineyour

ownbusinesstransactionvariantsthatrestrictthebusinesstransactions.

For a business transaction, you define exactly which item categories can be

posted. Withabusinesstransactionvariant,yourestrictthebusinesstransaction

bydefiningtheitemcategoriesinmoredetail. Whenyoupostadocument, the

systemcanusethebusinesstransactionvarianttocheckwhetherornottheposting

ispermitted. Ifanitemcategoryisnotpermitted,thesystemrejectstheposting.

Split rule: In this activity, you can define a split rule in which you define a

splitprocedureinmoredetail. Thismeansthat youassignbusinesstransaction

variants to a split procedure.

Asplitprocedurecontainstherulesthatdefinehowtheindividualitemcategories

aretobetreated. Youneedtoassignyoursplitproceduretoaledger.

SAPrecommendsthatyoucopythestandardmethodsdeliveredbySAP,thatis,

save the methods under a new name and then change the entries. Proceed as

follows:

• Select the entries of the reference split procedure, choose Copy as.... ,

and enter your own split procedure. In the dialog box, click“Copy All

(Dependent Entries)”.

• Change the entries accordingly.

Theindividualprocessingstepsaredescribedbelow.

1. Entertheaccountkeyforthezerobalanceitemsandtheitemcategorythat

determines the leading company code:

• AccountKeyforZeroBalanceItems: Usetheaccountdetermination

key to define the account and the line items used for the clearing

items. TheaccountdeterminationkeyisdefinedunderDefineAccount

Determination.

• Item Category of Leading Company Code: This procedure is used

tosplitthecompanycodeclearingitems. Checkwhetherornotthis

procedure is appropriate to define a business transaction that you

require.

2. Selecttherequiredcombinationofsplitprocedureandbusinesstransaction

variantandchooseItemCategoriestobeProcessed. Foreachcombination,

youcandefinethenumberofitemcategoriesthataretobeprocessedinthe

documentsplitandthemethodofsplittinginthissetting.

UsingtheProcessingType,youdefinethebasicproceduretosplittheitems.

You can select the following procedures:

• Transfer a Fixed Value: Using this processing type, you can use a

constant. Youcandefineconstantsintheactivity,DefineConstants. If

youdothis,thereisnosplitinthedocument. Youusethisprocedure

351

第 370 页 / 共 509 页

Unit9: DocumentSplit AC220

if a split is not required at the time of the posting. If required, you

cansubsequentlydistributethevaluesfortheaccountsof theledger

using Allocation.

• Split According toSpecifiedBase Item Categories: Thisprocessing

typeisthestandardprocedure. Theitemsaresplitusingthebaseitems

thatyoudefineinthenextstepunderBaseItemCategories. Thesystem

getstheinformationaboutthesplitfromthedocument. Thismeansthat

theremustbeatleastonebaseitemtypeinthedocument.

• Split According to Current Account Balance: Using this processing

type,alineitemissplitaccordingtothecurrentaccountbalance. You

use this procedure if the individual document does not receive the

requiredinformationaboutthesplitwiththeaccountassignments. This

processingtypeisuseful, forexample, fortheadvancereturnfortax

on sales and purchases.

Inadditiontotheprocessingtype,youcansettheindicators,ConsiderTax

CodeandConsiderCashDiscountRelevance,fortaxorcashdiscountitems.

The base item is then selected according to the indicator set to calculate

the split.

3. Ifyouhaveselectedtheprocessingtype,SplitAccordingtoSpecifiedBase

ItemCategories,foranitemcategoryforyourcombinationofsplitprocedure

andbusinesstransactionvariant,youneedtodefinethebaseitemcategories

inmoredetail. Todothis,selecttherequireditemcategoryandselectBase

Item Categories in the navigation area.

Youcanusethefollowingsettingstodefinethebaseitemcategories:

• DependencyofLeadingItem: Ifyousetthisindicator,companycode

clearing itemsare split differentlyfor eachcompanycodecategory.

Youneedtosetthisindicatoronlyforcompanycodeclearingitems.

• SplitAutomatically: Ifyousetthisindicator,theitemcategoryisonly

usedfor thesplit ifthesplit iscarried out automatically. Thisisthe

caseforclearing,partialclearing,andreversalprocesses. Youcannot

configuretheseprocessesmanually; theyarefixedandanautomatic

split takes place.

4. Save your split rule. Youcan display and print an overviewof your split

rule. To do this, select Print.

Split MethodsandAssign Split MethodstoaLedger: Documentsplittingis

activatedwhenyouassignasplittingmethodtoyourledger. Asplittingmethod

contains the rules that define how individual line items are to be treated by

document splitting.

352

第 371 页 / 共 509 页

AC220 Lesson: Understanding and Customizing Document Split

SAPprovidesvarioussplittingproceduresinthestandardsystem,suchas:

• AsplittingprocedurethatdealswithA/R,A/P,andtaxitemsandcorresponds

tothepreviousbusinessarea,apportionment,subsequentdebtinthePand

L statement.

• Asplittingprocedureforcompanycodeclearingandbankaccountitems.

In this activity, you specify the account assignment objects to be used in the

ledgerforsplitting. Currently,thefields,businessarea(GSBER)andprofitcenter

(PRCTR),areavailableforsplitting. Youcansetthesefieldssothatazerobalance

isrequiredanddecidewhetherornotapartnerobjectshouldbeconsidered.

Assign a splitting method and the account determination objects to be split to

your ledger.

1. To dothis, select a ledger and then selectAdditions →Splitting methods.

EnteramethodincludedintheSAPstandardsystem.

2. Then, select Assignfields and enter theaccount determination objects to

be split. Set the indicator for account determination objects that should

be balanced to zero balance.

Figure 153: Overview of the Split Logic

353

第 372 页 / 共 509 页

Unit9: DocumentSplit AC220

Figure 154: Item Category

Severalitemcategoriescanbe determinedautomatically.

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.

354

第 373 页 / 共 509 页

AC220 Lesson: Understanding and Customizing Document Split

Figure 155: Business Transactions

Theindividualbusinesstransactionsmustbeassignedtothevaliddocumenttypes.

Avariantistobecreatedforeachbusinesstransaction,wheretheentriespermitted

at the item category level can be stored.

Figure 156: Split Rule

Thesplittingmethoddetermineshowanonlinedocumentsplitistobecarriedout.

Thismeansthatasettingismadeforeachsplittingmethodtodeterminehowto

dealwiththeindividualitemcategories,forexample,whetherornottheaccount

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

customer invoice.

355

第 374 页 / 共 509 页

Unit9: DocumentSplit AC220

Figure 157: Splitting Method

Figure 158: 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:Itemchangedbydocument split

• MWSKZ: VAT indicator

• XSKRL:Indicator-Postinglinenotrelevanttocashdiscount

356

第 375 页 / 共 509 页

AC220 Lesson: Understanding and Customizing Document Split

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

Demonstration: Demonstration of the Split Method

Purpose

To demonstrate the Split method

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. Menu path in Customizing: Financial Accounting → Special Purpose

Ledger → Actual Posting → Settings for Accounting Integration →

Document Splitting.

Assign Account Number Item Category. Assign DocumentTypes. Show

theBusinessTransactionVariantsSplittingProcedureandSplitRuleunder

Additional Activities.

2. ThenextstepwouldbetoassignaledgerthatmustbesplittotheSplitting

MethodandFields. SelectLedger→Createandshowtheparticipantsan

example ledger :

Ledger: SZ

Summentabelle: ZSPLITT“SplitLedgerAC220Example”

3. OpenanewsessionandshowZSPLITA(fieldsatendofthis)withSE11.

Crossoffthefollowing: LedgerPostingallowed,Setupbalancec/f,Write

line Items, Debit/Credit, Summarize.

TransactionCurrencyand2ndCurrency(CompanyCodecurrency)

NO3rdCurrency(CurrencysettingsmustconformtothesameinG/L!)

357

第 376 页 / 共 509 页

Unit9: DocumentSplit AC220

Split Method: → Splitting Method: Enter Method 0000000002 and then

assign fields:

NewentriesGSBERandmarkZeroblnce. Save.

AssigntoCo.Code. AC00: BlockingIndicator1andFiscalYearVariantK4

AssignactivityRFBUastherequiredpostingwithPostingIndicator1and

using the Field Movement ZSPL.

4. Executethesamepostingsasintheparticipants’exercises,forthepayment

in1125,20,whichwillbethereducedamount(consideringthe3%discount).

5. Showthe singleitemandtotalsin yoursplit ledger andpoint out that the

postingshavebeensentonlytoSLalthoughthereferenceistotheoriginal

documents.

358

第 377 页 / 共 509 页

AC220 Lesson: Understanding and Customizing Document Split

Exercise 14: Splitting of Documents

281

Exercise Duration: 45 Minutes

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**

Continued on next page

359

第 378 页 / 共 509 页

Unit9: DocumentSplit AC220

Summarize

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).

Continued on next page

360

第 379 页 / 共 509 页

AC220 Lesson: Understanding and Customizing Document Split

Writedownthenumberoftheaccountingdocument.

______________________________________________________

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.

361

第 380 页 / 共 509 页

Unit9: DocumentSplit AC220

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

Createaledger for thesummarytableZSPLITT.

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.

Continued on next page

362

第 381 页 / 共 509 页

AC220 Lesson: Understanding and Customizing Document Split

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

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.

Assign thecompanycodeACxxto yourledger.

Continued on next page

363

第 382 页 / 共 509 页

Unit9: DocumentSplit AC220

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.

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.

a) Customer Invoice

YousellproductsforEUR1160.00incl. 16percentoutputtax(taxcode

AN),thatisEUR160.00. Thenumberofthecustomermasterrecord

isT-F00A00. Theinvoiceisdatedthepreviousdayandwascreated

directly by the accounting department.

2. Post an Invoice.

Continued on next page

364

第 383 页 / 共 509 页

AC220 Lesson: Understanding and Customizing Document Split

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

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.

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,

Settletheinvoiceto thecustomer T-F00A00.

Write down the document number:

______________________________________________________

Checkwhetherthisdocumentwassplitinyourledger.

365

第 384 页 / 共 509 页

Unit9: DocumentSplit AC220

Lesson Summary

You should now be able to:

• Describe how a split ledger works

• ExecuteCustomizingactivitiesandsetupasplitledger

366

第 385 页 / 共 509 页

AC220 Unit Summary

Unit Summary

You should now be able to:

• Describe how a split ledger works

• ExecuteCustomizingactivitiesandsetupasplitledger

367

第 386 页 / 共 509 页

UnitSummary AC220

368

第 387 页 / 共 509 页

AC220 Test Your Knowledge

Test Your Knowledge

291

1. Financialstatementscanbepreparedby thedocuments.

Fillintheblankstocompletethesentence.

2. Whatistheproceduretoperformanonlinedocumentsplit?

369

第 388 页 / 共 509 页

TestYourKnowledge AC220

Answers

292

1. Financialstatementscanbepreparedbysplittingthedocuments.

Answer: splitting

2. Whatistheproceduretoperformanonlinedocumentsplit?

Answer: Thesplittingmethoddetermineshowanonlinedocumentistobe

split. Youneedtomakethesettingsforeachsplittingmethodtodetermine

howtodealwith theindividual itemcategories.

370

第 389 页 / 共 509 页

Unit 10

Rollups

293

Explainhowtosetuptheprerequisitesforrollups. Demonstratehowtoinvestigate

thedifferentformsofsummarization. Explainhowtodefinearollupandviewthe

results. Thenexplainhowtodefineandexecuteareportontherollupdata.

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.......................................................372

Demonstration: Demonstration of Rollups in FI-SL....................392

Demonstration: Demonstration of USER EXIT (Rounding to full dollar

amounts).....................................................................396

Exercise 15: Definition and Execution of a Rollup ....................399

Exercise 16: Additional Optional Exercises.............................411

371

第 390 页 / 共 509 页

Unit10: Rollups AC220

Lesson: Rollups in FI-SL

Lesson Duration: 90 Minutes

294

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

Giveanoverviewofrollups. Describethetypesofsummarization. Describethe

sequencesin rollup. Explaintherollupset. Describefieldmovement. Explain

substitutionanduserexits. Explainhowtoexecutearollup.

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.

Overview and Example of Rollups

Rollup Ledgers: For certainreports(toavoidreadingperformanceproblems),

advantage of the rollup.

372

第 391 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

Figure 159: Rollups: Overview

Figure 160: Rollup Ledgers

Thenumber of recordsinthesummary tablecanbelargeduetotheadditional

account assignments.

Forcertainevaluations,thetotalsarenotrequiredtohavethesamelevelofdetail

as in the source ledger.

373

第 392 页 / 共 509 页

Unit10: Rollups AC220

Types of Summarization

Summarization: Discussthefoursummarizationoptions. Explainthatthereisa

fifthoption: Therollupledgercontainsfewerfieldgroups(keyfigures)thanthe

sender ledger(s).

Note: In spite of the summarization, records are again written to the

database. Mainadvantage: “Prepared”reports, manipulate(userexits)

andsubstitutionandbetterreadingperformanceforperiodicprocessing.

Figure 161: Summarization Using Characteristics

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

ledger to a specific level of detail.

Figure 162: Rollup: Summarization Using Substitutions

374