AC220_EN_Col52_FV_Inst_A4 (第12页)

第 434 页 / 共 509 页

Unit10: Rollups AC220

Solution 16: Additional Optional Exercises

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-

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-

Continued on next page

416

第 435 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

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 is your Ledger AA (...RR).

Writedownthedocumentnumberanddisplaytheresults.

a) DirectFI-SLpostingstoyourledgerAA(..RR).

ThesepostingsaretobemadeforVersion3actualdata. Usetheuser

tableGXX-UTAB anddocument typeA2.

Post the following document lines for the first two periods of the

current quarter:

For example: If the current quarter is the first quarter, repeat the

following document lines for:

January (Period 1)

February (Period 2)

Other requirements:

Thebusinessareas0001and1500aretobereplacedbythebusiness

area RETL (Retail).

Thebusinessareas8000and9000aretobereplacedbythebusiness

area WSLE (Wholesale).

FI-SL substitution: GXX-BUSA

Thematerialnumbersyouenter,whichareallice-creamtypes,willbe

substitutedbythecategories. Tothisend,entertheuserexitU55for

yourmaterialnumber(RMATNR)inthefieldmovement. VANILLA,

CHOCOLATE, and STRAWBERRY.

ThetargetledgerisyourLedgerAA(...RR).

Writedownthedocumentnumberanddisplaytheresults.

1. Createversion 3for postingyour ledger.

SAPEasyAccess→Tools→Customizing→IMG→EditProject→

SAPReferenceIMG →Financial Accounting→SpecialPurpose

Ledger → Basic Settings

→MasterData→MaintainLedgers→ChangeLedger

Select your ledger.

Select Versions.

Continued on next page

417

第 436 页 / 共 509 页

Unit10: Rollups AC220

EnterVersion3foractualdata, andenter thedescriptionVersFI-SL

Direct.

2. Substitution GXXGSBE

SAPEasyAccess→Tools→Customizing→IMG→EditProject→

SAPReferenceIMG→Financial Accounting→SpecialPurpose

Ledger → Tools → Maintain Validation/Substitution/Rules →

MaintainSubstitution→SpecialPurposeLedger→LineItem

Substitution step 1: Prerequisite

Businessarea0001 ORBusinessarea 1500

Substitution value: RETL

Substitution step 2: Prerequisite

Businessarea8000ORBusinessarea=9000

Substitution value: WSLE

3. Change field movement SPXX

SAPEasyAccess→Tools→Customizing→IMG→EditProject

→ SAP Reference IMG → Financial Accounting → Special

PurposeLedger→BasicSettings→MasterData→MaintainField

Movements→ Change Field Movement

Change the field movement SPXX (where XX is your group

number)

ChoosethelinewithRMATNRandentertheexitU55:

Environment→FieldMovement→Change

Rec. Field Send Field Exit

RMATNR RMATNR U55

Enter FI-SL document lines.

Viewtheresultsofyourposting(documentdisplayinFI-SL).

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

Continued on next page

418

第 437 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

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. The fiscal year variantQ1 must, therefore, be assigned

to the rollup ledger.

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

Continued on next page

419

第 438 页 / 共 509 页

Unit10: Rollups AC220

CreateyourrollupGXX-RUP2(whereXXisyourgroupnumber).

Carry out the rollup for 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

View the results in your rollup ledger.

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

NowyoucanrollupthedatathatyoupostedtoyourledgerAA(RR)

in exercise A.

ThisrollupledgermustbedefinedforthetableZZSLTABT.

TheD/CandWritelineitemsindicatorsmustbeselected.

The ledger shouldonly storethe Ledger currency USD. Therollup

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

companycode/ledgerassignmentto1. Thisrollupledgerwillcontain

the company’s quarterly results. The fiscal year variant Q1 must,

therefore,beassignedto therollup ledger.

Continued on next page

420

第 439 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

TheREVENUEACCOUNTS810200and81030,theZONESNorth

andSouth,andtheproductgroupsVANILLA,CHOCOLATE,and

STRAWBERRYmustberolledup1:1. Thebusinessareasshouldnot

betakenoverandtheUSDamountsshouldberoundedtofulldollar

amounts(revenueaccounts810200, and810300).

Create the rollup ledger.

SAPEasyAccess→Tools→Customizing→IMG→EditProject→

SAPReferenceIMG →Financial Accounting→SpecialPurpose

Ledger→BasicSettingsMasterData→MaintainLedgers→Create

Ledger

Ledger: YA to YR (see exercise)

Description: RollupLedger2 for GroupXX

Basic settings:

Summary table: ZSLTABT

Additional settings:

Ledgerpost. allowed xRollupallowed

Set up balance c/f xWrite lineitems

xMaintaind/cindicator Production

Summarize

Saved Currencies

NO TC and NO 2nd currency

xLedgercurrency(80) LedgercurrencyUSD

No QUANTITIES

Define version 3 for the rollup data.

Select Versions.

Version Rollup Description

3 x Version 3 RUP

Save your ledger.

AssignthisledgertoyourcompanycodeACXX.

Ledger/Company code assignment:

Company code: ACXX

Ledger: YA (...YR)

Assignment criteria:

Continued on next page

421

第 440 页 / 共 509 页

Unit10: Rollups AC220

Blocking indicator: 1

Fiscal year variant: Q1

Select Assign.

Saveyour ledger/companycodeassignment.

CreatetherollupsetGXX-ROL2forthetableZSLTABT.

SAPEasyAccess→Accounting→FinancialAccounting→Special

PurposeLedger→Tools→SetMaintenance→Sets→Create

CreatemultisetGXX-ROL2forthetableZSLTABT.

Create the field movement GXXZ. SAP Easy Access → Tools →

Customizing → IMG → Edit Project

SAPReferenceIMG→Financial Accounting→SpecialPurpose

Ledger → Periodic Processing → Rollup → Maintain Field

Movement→CreateRollupFieldMovement

Field movement: GXXZ

Description: FMovement2 RollupGroup XX

Receiver table: ZSLTABT

Sender table: ZSLTABT

User exit before update U02

RecField SendField

RACCT RACCT

RZZREGION RZZREGION

RMATNR RMATNR

Save the field movement GXXZ.

CreateyourrollupGXX-RUP2(whereXXisyourgroupnumber).

SAPEasyAccess→Accounting→FinancialAccounting→Special

PurposeLedger→PeriodicProcessing→Rollup→CreateRollup

Rollup type: Standard

Title: ZONEREVENUESforPRODUCTGROUPS

Sender table: ZSLTABT

Receiver table: ZSLTABT

Rollup set: GXX-ROL2

Select Processing Option.

Continued on next page

422

第 441 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

x Write line items

Select Continue.

Choose Rollup sequence.

EnterthefieldmovementGXXZandyourrollupledgerYA(...YR).

Save the rollup definition.

Carry out therollup for thecurrent quarter.

SAPEasyAccess→Accounting→FinancialAccounting→Special

PurposeLedger→PeriodicProcessing→Rollup→ExecuteRollup

Rollup: GXX-RUP2

Parameters:

Start date: 01.01. Current year

End date: 31.03. current year

This is an example for quarter 1.

xWrite line items

Document type R0

x Detail list

Viewthe results in your rollup ledger.

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

Thisreportreflectstheresultsofyour actual directpostingsandrolledup

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

Continued on next page

423

第 442 页 / 共 509 页

Unit10: Rollups AC220

CHOCOLATE

810200

810300

STRAWBERRY

NORTH

810200

810300

VANILLA

810200

810300

CHOCOLATE

810200

810300

STRAWBERRY

SOUTH

ZONES NORTH-SOUTH

General Selections:

Company code: ACXX

Version: 1

Current fiscal year

a) FinalreportGXX-FINA,libraryLXX>rep. group: FIXX

This report reflects the results of your actual direct postings and

rolledupactualdata. ThisisaSAMPLERESULTforthefinalreport

(example for Q1, Per. 1- 3).

Comparison rollup data/source data

Company code: ACXX

Fiscal year: XXXX Current quarter

Comparison rollup data/source data

Company code: ACXX

Fiscalyear: XXXX Current quarter

RUPLedgerKW-IST ORGLedgerKW-IST

Continued on next page

424

第 443 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

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

General Selections:

Company code: ACXX

Version: 1

Current fiscal year

Report GXX-FINA, library LXX

In Leadcolumn insert Regions/Revenue.

Double-click row 1.

Choose characteristics:

Continued on next page

425

第 444 页 / 共 509 页

Unit10: Rollups AC220

Accountnumber: GroupGXX-ERL12(basicset)

Material: GroupGXX-PRODGROUPS(basicset)

Specialregion: GroupGXX-NORTH-SOUTH(basicset)

Enter the following texts:

Short text: ZONES N-S

Medium text: ZONES NORTH-SOUTH

Long text: ZONES NORTH-SOUTH

Select Adopt.

Position thecursoron row 1and double-clicktheExpand (Explode

Characteristics) icon.

Sort Characteristics:

Subsets(Explode) Individual Value

1. Special Region x

2. Material x

3. Account number x

Select Adopt.

Example column 1:

Selectelementtype: Predefinedcolumn: Groupcurrencyact.

Key figure: Group currency

Characteristics: Recordtype, ledger, period

Record type: 0

Ledger: Your rollup ledger YA(...YR)

Period:1(Example for quarter 1)

Enter the following texts:

Short text: RUPIST

Medium text: RUP-KWIST

Long text: RUPLedger KW-IST

Select Adopt.

Example column 2:

Selectelementtype: Predefinedcolumn: Groupcurrencyact.

Key figure: Group currency

Continued on next page

426

第 445 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

Characteristics: Recordtype, ledger, period

Record type: 0

Ledger: Your ledger (AA - RR)

Period: 1 to 3

Enter the following texts:

Short text: URLIST

Medium text: URL-KWIST

Long text: URSPRLedger KW-IST

Select Adopt.

Edit → General Selections

Choose characteristics

Company code: Your company code

Version: Version 3

Fiscal year: Current year

Check and save your report.

Maintain texts in the footer and header.

Save the report.

Assign thereport tothereportgroup FIXX.

Environment → Assign Report Group

Execute report (group).

Report → Execute

SOLUTIONS: User exit routines

Example1: User exit for fieldmovement

SAPEasyAccess→Tools→Customizing→IMG→EditProject

SAPReferenceIMG →Financial Accounting→SpecialPurpose

Ledger→BasicSettings→UserExits→MaintainClient-Specific

User Exits

Appl Area Ex.prog Applicationarea

GIMV ZGIVU800 Variable field

movement

Continued on next page

427

Appl Area	Ex.prog	Applicationarea
GIMV	ZGIVU800	Variable field movement

第 446 页 / 共 509 页

Unit10: Rollups AC220

ZGIVU800isacopyoftheSAPexampleRGIVS000.

Program ZGIVU800

Tables: ...........

zzprod.

.......................

*FORM E55_MVC

*Readthetablezzprodandreturnaproductgroup.

form e55_mvcusingfrom_field to_field.

clear to_field.

select * from zzprod

where zzmat eq from_field.

move zzprod-zzsubmat to to_field.

endselect.

endform.

Table ZZPROD

Field name Key Data Element Type

Length CheckTable ShortText

MANDT x MANDT CLNT 3

Client

ZZMAT x MATNR CHAR 18

Material number

ZZSUBMAT MATNR CHAR 18

Material number

Table ZZPROD Contents:

MANDT ZZMAT ZZSUBMAT

T-IC-F1001 VANILLA

T-IC-F1002 CHOCOLATE

T-IC-F1003 STRAWBERRY

T-IC-R2007 CHOCOLATE

T-IC-R2008 VANILLA

T-IC-R2009 STRAWBERRY

Example 2: User exit for rollup

Continued on next page

428

第 447 页 / 共 509 页

AC220 Lesson: Rollups in FI-SL

SAPEasyAccess→Tools→Customizing→IMG→EditProject

SAPReferenceIMG →Financial Accounting→SpecialPurpose

Ledger→BasicSettings→UserExits→MaintainClient-Specific

User Exits

Appl Area

Appl Area Ex.prog Applicationarea

GBRU ZZLVU800 Rollup: Userexits

ZZLVU800isacopyoftheSAPexampleRGLVU000.

Program ZZLVU800

*FORM D02_USER_EXIT

*Exit 2 in rollup field movement (header)

*(Datafieldscanbechanged,forexample,forrevaluation)

*Roundgroupcurrencyvaluesroundedtofullamounts.*

form d02_user_exit.

data: hundred type i value 100.

glu2-ksl000=glu2-ksl000/hundred*hundred.

glu2-ksl001=glu2-ksl001/hundred*hundred.

glu2-ksl002=glu2-ksl002/hundred*hundred.

.............

glu2-ksl016=glu2-ksl016/hundred*hundred.

clear sy-subrc.

429

Appl Area	Ex.prog	Applicationarea
GBRU	ZZLVU800	Rollup: Userexits

第 448 页 / 共 509 页

Unit10: Rollups AC220

Lesson Summary

You should now be able 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

430

第 449 页 / 共 509 页

AC220 Unit Summary

Unit Summary

You should now be able 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

431

第 450 页 / 共 509 页

UnitSummary AC220

432

第 451 页 / 共 509 页

AC220 Test Your Knowledge

Test Your Knowledge

347

1. Youcanrollupdatatoaledgerthatusesanon-calendarfiscalyear.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

2. A rollup is divided into sequences when the same source data has to be

transferred using a different method.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

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

todefinethehierarchythatisto

be summarized.

Fillintheblankstocompletethesentence.

4. If thecharacteristicsarenot transferred to thereceiver table, the data for

these fields is not summarized.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

5. When a rollup is executed, the points where the user exits can be used

include:

Choosethecorrectanswer(s).

□ A Exit 1 in the rollup header

□ B Exitinthesubstitutionactivitiesinthefieldmovement

□ C Exit 2inthefieldmovement header table

□ D Exit inthefieldmovement header table

6. When you execute a rollup, you cannot specify whether or not a

carry-forwardperiodistoberolledupforaspecificyear.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

433

第 452 页 / 共 509 页

TestYourKnowledge AC220

Answers

348

1. Youcanrollupdatatoaledgerthatusesanon-calendarfiscalyear.

Answer: True

Youcanrollupdatatoaledgerthatusesanon-calendarfiscalyear.

2. A rollup is divided into sequences when the same source data has to be

transferred using a different method.

Answer: True

A rollup is divided into sequences when the same source data has to be

transferred using a different method.

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

single-dimensionsettodefinethehierarchythatistobesummarized.

Answer: single-dimension set

4. If thecharacteristicsarenot transferred to thereceiver table, the data for

these fields is not summarized.

Answer: False

If thecharacteristicsarenot transferred to thereceiver table, the data for

these fields is summarized.

5. When a rollup is executed, the points where the user exits can be used

include:

Answer: B, C

Whenarollupisexecuted,userexitscanbeusedatfourdifferentpoints:·

• Exit in the rollup header

• Exit 1 inthefieldmovementheader table

• Exitinthesubstitutionactivitiesinthefieldmovement

• Exit 2 inthefieldmovementheader table

434

第 453 页 / 共 509 页

AC220 Test Your Knowledge

6. When you execute a rollup, you cannot specify whether or not a

carry-forwardperiodistoberolledupforaspecificyear.

Answer: False

Whenyouexecutearollup,youcanspecifywhetherornotacarry-forward

period is to be rolled up for aspecific year.

435

第 454 页 / 共 509 页

CourseSummary AC220

Course Summary

You should now be able to:

• ExplaintheimportanceofFI-SLandinformationflowinFI-SL

• Listthekeycharacteristicsand keyfiguresin theFI-SL environmentand

determinetheprerequisitestocreateanewfieldinFI-SL

436

第 455 页 / 共 509 页

Appendix 1

Course Information

Figure 184: Conclusion

Figure 185: Course Objectives

437

第 456 页 / 共 509 页

Appendix1: CourseInformation AC220

Figure 186: Additional Course Objectives

Figure 187: Additional Course Objectives (1)

Figure 188: Course Goals

438

第 457 页 / 共 509 页

AC220 Appendix 1: Course Information

Figure 189: Course Overview Diagram

Figure 190: Main Features Diagram (1)

439

第 458 页 / 共 509 页

Appendix1: CourseInformation AC220

Figure 191: Main Features Diagram (2)

Figure 192: Main Features Diagram (3)

440

第 459 页 / 共 509 页

AC220 Appendix 1: Course Information

Figure 193: Main Features Diagram (4)

Figure 194: Main Features Diagram (5)

441

第 460 页 / 共 509 页

Appendix1: CourseInformation AC220

Figure 195: Main Features Diagram (6)

Figure 196: Main Features Diagram (7)

442

第 461 页 / 共 509 页

AC220 Appendix 1: Course Information

Figure 197: Main Features Diagram (8)

Figure 198: Main Features Diagram (9)

443

第 462 页 / 共 509 页

Appendix1: CourseInformation AC220

Figure 199: Main Features Diagram (10)

Figure 200: Main Features Diagram (11)

444

第 463 页 / 共 509 页

AC220 Appendix 1: Course Information

Figure 201: Main Business Scenario (1)

Figure 202: Main Business Scenario (2)

Figure 203: Recommended Follow-Up Activities

445

第 464 页 / 共 509 页

Appendix1: CourseInformation AC220

New General Ledger Accounting (New GL)

Figure 204: New General LedgerAccounting (New GL)

SAPNote756146alsoprovidesanoverviewoftheadvantagespresentedbynew

General Ledger Accounting.

If you would like to experience new General Ledger Accounting in an SAP

training course, please attend AC210.

Note for customers currentlyusingclassicGeneral Ledger Accounting: If you

perceive the advantages outlined in the following slides as decisive for your

enterprise, you can switch to new General Ledger Accounting in a follow-up

project to the upgrade to mySAP ERP.

Planned “General Availability”: April 1,2005

New General Ledger Accounting is fully integrated with all subledgers (=>

FI-AP, FI-AR, and FI-AA)!

446

第 465 页 / 共 509 页

AC220 Appendix 1: Course Information

Figure205: AdvantagesofNewGeneralLedgerAccounting–Overview

Thefollowingslidesdescribetheindividualadvantagesindetail.

Ina nutshell, newGeneral Ledger Accounting comprisesfunctionscombining

classicGeneralLedgerAccountingwiththeSpecialPurposeLedgercomponent.

Caution: In spite of all the innovations mentioned so far, the “user

interfaces”forenteringdataorpostingsremainvirtuallyidenticaltothose

ofthepreviousreleasefromtheuser’spointofview!

Figure 206: AdvantagesinDetail–Extended DataStructure

447

第 466 页 / 共 509 页

Appendix1: CourseInformation AC220

TheFunctionalAreafieldisnowstoredinGeneralLedgerAccountingaswell.

Thismeansthatyounolongerhavetoactivatethecostofsalesledger0Ftocreate

aprofit andlossstatementforcostofsalesaccounting.

TheProfitCenterfield(likethePartnerProfitCenterfield)isalsomanagedin

GeneralLedgerAccounting. Inthisway,youcanuseGeneralLedgerAccounting

to perform management analyses.

With mySAP ERP Central Component, you can also use General Ledger

Accounting to portray a lean version of management accounting (=> “CO

light”). Costcentersand(primary)costelementsarenowavailableasobjects.

A new entity (characteristic / category) that is now available is the Segment

field. Withtheadditionofthisnewentity,youarenowabletoperformsegment

reporting.

InnewGeneralLedgerAccounting,thestructureofthetablescanbeextended

flexiblywiththeadditionofcustomfieldsandtherelatedtotalsforthosefields.

Standardreportscanbeusedforalloftheabovepurposes.

Figure207: AdvantagesinDetail–DocumentSplitting(OnlineSplit)I

Theappearanceoftheinterfaceaswellasthewayusersenterfinancialsdocuments

remain exactly thesameas in previousreleases.

An input tax rate of 16% is taken as thenorm.

Currently, SAP supports derivation of the segment from the profit center.

However,theprofitcenteritselfcanbederivedfromacostcenter,aCOorder,or

a project, for example.

448

第 467 页 / 共 509 页

AC220 Appendix 1: Course Information

Figure208: AdvantagesinDetail–DocumentSplitting(OnlineSplit)II

It is necessary to activate document splitting to ensure that the characteristic

Segment(orindeedanyotherentity)issplitconsistently. Uniformsegmentation

meansthata“zerobalance”isachievedforeachdocumentfortherelevantentity.

ThedisplayclearlyrepresentsnotonlyhowtheentitySegmentissplitbutalso

howitisinheritedtothevendorlineitemsandtaxlineitemsofthedocument.

With the online split (and the inheritance), the period-end closing activities

“BalanceSheet Adjustment”(=>SAPF180) and“ProfitandLossAdjustment”

(=> SAPF181) are no longer required.

Caution: Document splitting can also be applied to “subsequent

processes”,suchaspayments. Cashdiscountreceivedorcashdiscount

paidaredistributedtotheentitiesaccordingtotheamountoftheoriginal

postingstotheexpenseaccount(inthecaseofanoriginalvendorinvoice).

Customerinvoicesinwhichtherevenuesaredistributedacrossdifferententities

aretreatedinthesamewayasthevendorinvoicesreferredtointheabovenote.

449

第 468 页 / 共 509 页

Appendix1: CourseInformation AC220

Figure209: AdvantagesinDetail–Real-TimeIntegrationCO->FI

This slide demonstrates real-time integration of CO and FI using the

characteristic/criterion Functional Area by way of example. However, you

can also set up real-time integration for the criteria Company Code, Business

Area, Profit Center, Segment, Fund, and Receivable. The selection is not an

“either/ordecision”-youcanalsoactivatereal-timeintegrationfor allofthese

characteristics at once!

SpecialfeaturesoftheFinancialAccounting(FI)document(=>2b.):

• Postings are made in real time (per document). There is no longer any

needforreconciliation(=>[only]aggregatedforeachexpenseaccount/cost

element) with the reconciliation ledger in Cost Element Accounting

(transaction KALC).

• TheFI document doesnotrequireclearingaccounts. However, clearing

accounts are still required in mySAP ERP for cross-company code

transactions!

• Users can access the FI document generated in real-time from the

management accounting document (=> 2./2a.) and vice versa, thereby

guaranteeingtransparencyoftheaccountingdocuments!

The documents in real-time integration CO -> FI can be logged using atrace

for subsequent analysis.

450

第 469 页 / 共 509 页

AC220 Appendix 1: Course Information

Figure 210: Advantages in Detail –Parallel Accounting

OneoftheledgersinnewGeneralLedgerAccountingisdesignatedasthe“leading

ledger”. Theleadingledgerisgenerallyusedtoportraygroupaccounting.

Other ledgers can also be used for parallel accounting in new General Ledger

Accounting.

• ThisistheledgerapproachinnewGeneralLedgerAccountingdelivered

with mySAP ERP.

•

Caution: These are not the same ledgers as thosein the Special

PurposeLedgercomponentinReleaseR/3Enterprise!

Nevertheless, it is still possibleto portray parallel accounting using additional

accounts(=>accountapproach). Withtheaccountapproach,youonlyuseone

ledgerinGeneralLedgerAccounting,andthatledgeristakenastheleadingledger.

AsofmySAPERP,theledgerapproach(innewGeneralLedgerAccounting)and

theaccountapproacharegenerallygivenequalimportance. Formoreinformation,

see SAP Note 779251.

You can continue to use thedisplay options from earlier releases - such asthe

specialpurposeledgerapproachor thecompanycodeapproach-providedthat

these approaches have already been set up prior to mySAP ERP. However,

enhancementstosuchapproachesarenotincludedinmySAPERP.

451

第 470 页 / 共 509 页

Appendix1: CourseInformation AC220

452

第 471 页 / 共 509 页

Appendix 2

Overview on FI-SL

Figure 211: Appendices

Figure 212: Table Group and OtherTechnicalities

453

第 472 页 / 共 509 页

Appendix2: Appendix2 AC220

Figure 213: FI-SL Transaction Data in the Database

Transaction data in the FI-SL database.

Figure 214: Determining FI-SL Storage Space: Basic Data

Calculating the required storage space.

454

第 473 页 / 共 509 页

AC220 Appendix 2: Appendix 2

Figure 215: Update: ONLINEorin the BACKGROUND??

Whetheryouupdatedataonlineorinthebackground,dependsondifferentcriteria:

The online mode can be used when

yourequireup-to-datedataandmayneedtoquicklyaccessdatainordertocorrect

any errors. You can also process your data online if this does not affect your

system capacity.

you usually enter planning values online.

Thebackgroundprocessingmodeisrecommendedwhen

youhavelimitedsystemcapacityandalsowhenthesystemisavailableovernight

and there are no users working in the system.

you use periodic functions that process large amounts of data (for example,

allocation, rollups, and so on).

455

第 474 页 / 共 509 页

Appendix2: Appendix2 AC220

Figure 216: Summary Table: Structure

The summary table contains:

fixedfieldsthat you cannotchangein the keypart, forexample, client, ledger,

recordtype, version, fiscal year, currency key, etc.

variablefields(characteristics)inthedatapart,forexample,FAREAastheobject

(RFAREA) and FAREAasthepartner (SFAREA).

Figure 217: Object Table 1 (1)

An object number (RObjno.) and a partner number (SObjno.) are also fixed

fields in the key part.

456

第 475 页 / 共 509 页

AC220 Appendix 2: Appendix 2

ThesenumbersrefertoObjectTable1whichcontainsthecombinationsofaccount

assignment characteristics.

These characteristic combinations are encrypted in the object table with a

consecutive object number. The key of the summary table stores this object

number instead of the original characteristic.

Youcanassignavalidityperiodtoeachofthesecharacteristiccombinations. The

combinationsarethentreatedlikemasterdatawhichisvalidatedwhenpostings

aremadetotheledgersassignedtothetable. (Theerrormessage“Invalidaccount

assignment combination...” is displayed.)

Formoreinformationonthisfunction,pleaserefertotheslidesinthisUnitunder

‘Code Combinations’.

Figure 218: Object Table 1 (2)

Example:

Object table1 containsthe characteristicFAREA.

ThesummarytablecontainsoneobjectcharacteristicRFAREA(receiver)andone

partner characteristic SFAREA (sender).

Storingapartnerfield(partnercharacteristic)isoptional.

Object characteristics (receiver) must begin with Rand partner characteristics

(sender) must begin with S.

457

第 476 页 / 共 509 页

Appendix2: Appendix2 AC220

Figure 219: Object Table 2 (1)

YouhavetheoptionofusingObjectTable2forthesetransactionattributes.

ThekeypartoftheoptionalObjectTable2containsthefixedcharacteristicsthat

you cannot change (the client and the C Object number). This object number

encrypts thevariable characteristics in the data part. These arethe transaction

attributes.

Figure 220: Object Table 2 (2)

Thefieldsforstoringthesummaryvalues(usuallyablockof16periodsforthe

currencyandquantityfields)comeafterthevariablecharacteristics(R,CandS

characteristics) in the summary table.

458

第 477 页 / 共 509 页

AC220 Appendix 2: Appendix 2

At theend of thesummary table, you can add additional characteristicswhich

arederived directly fromthecharacteristics. For example, thecontrolling area

isderived directly from the company code. These fields are primarily used in

reportingandcannot beusedfor useinotherFI-SL functionssuchasplanning

and allocation.

Figure 221: Actual Line Item Table: Structure

Thekeypartoftheactuallineitemtablecontainstheclientsandarecordnumber.

Thisnumberisaconsecutivenumberthatisassignedautomaticallybythesystem

when a record is written to the table.

As in the summary table, the data part of the actual line item table contains

the fixed characteristics. This is followed by the posting period and other

document-relatedinformation,forexample,thedocumentnumberanddocument

type,andfinallytheobjectandpartnercharacteristics(asinthesummarytable).

Youcanthenincludeadditionalcharacteristics,forexampleatransactioncode,to

furtherspecifyadocument. Thesecharacteristicsareonlyoutputinthedocument

display or in line item reporting.

459

第 478 页 / 共 509 页

Appendix2: Appendix2 AC220

Figure 222: Plan Line Item Tables: Structure

Thefieldsintheplanlineitemtablearethesameasthefieldsintheactualline

itemtable. However, theposting period isreplacedwiththemaximumperiod.

Asinthesummarytable,thismaximumperiodreferstotheamountbalancesand

quantitybalancesthatarenormallystoredinablockof16periods.

Figure 223: Rollup Line Items (Actual and Plan)

IfyoudisplaythesummaryrecordsinyourrollupledgerusingtheReportWriter

and select a block of data, you can drill down to the line items of the relevant

summary records.

However, this is only possible when you have created and installed the

correspondingrolluplineitem tables(actual/ plan).

460

第 479 页 / 共 509 页

AC220 Appendix 2: Appendix 2

Itisnotyetpossibletoautomaticallyinstallthesetablesusingthe“Definetable

group” function.

Todoso,youshouldcopythestandardexampletablesGLREFU(RollupActual

LineItemTable)andGLREFV(RollupPlanLineItemTable)andmodifythem

according to your requirements.

Figure 224: Code Combinations

Whenyoucreateorpostadocumentinthestandardsystem,youcanposttoany

characteristiccombination,iftherelevantmasterdatahasbeenmaintained.

Forexample,youcanposttoallexistingaccountsandcostcenters.

Youmaynotwanttotakeadvantageofthisflexibility. Fororganizationalreasons

itmaybenecessarytolimitthenumber ofcharacteristiccombinationsthatcan

be posted to by a document.

Inthatcase,settingCodeCombinationsinFI-SLwillhavetheresultofblocking

postings to the FI-SL ledgers which do not meet the valid combination of

characteristics.

Figure 225: Checking Code Combinations

Itisoftennecessarytolimitthecharacteristiccombinations.

461

第 480 页 / 共 509 页

Appendix2: Appendix2 AC220

Example: You can define that account 461000 canonlybeposted towithcost

center 3100 and business area 0001.

Figure 226: Validity Periods

For these code combinations, you assign a validity period for the actual data

and/or plan data.

Youactivatecodecombinationsattablelevel. Thecodecombinationsaffectall

ledgers that use this table.

Figure 227: Comparison with Validation

Thisfunctionalityissimilartovalidation,butshouldnotreplaceit.

The validation function performs extremely complicated data checks using

Boolean logic.

When you maintain the code combinations and their validity periods for

actual/plan, youcanonlyuse“If...then...”statements.

462

第 481 页 / 共 509 页

AC220 Appendix 2: Appendix 2

TABLE GROUP AND OTHER TECHNICALITIES

TABLEGROUP FIELDS:EXAMPLEGLFUNC

1. Object Table 1 GLFUNCO

Accountassignmentelements(Object/PartnerObject)

Field Description Key

MANDT Client X

OBJNR Object number X

DATIV Valid fr act.fr

DATIB Valid fr act.to

DATPV Valid f.pln frm

BUKRS Company Code

ACCT Account Number

BUSA Business Area

FAREA Functional Area

2. Object Table 2 GLFUNCC

Transaction attributes

Field Description Key

MANDT Client X

OBJNR Object number X

OCLNT Original client

LOGSYS Logical System

RMVCT Transactn type

RASSC Trading partner

3. Summary Table GLFUNCT

Transaction attributes

Field Description Key Field Description Key

RCLNT Client X TSLVT Bal. c/fTC

RLDNR Ledger X TSL01 Total TC

RRCTY Record type X ... ...

RVERS Version X TSL16 ...

RYEAR Fiscal year X

463

第 482 页 / 共 509 页

Appendix2: Appendix2 AC220

ROBJNR Objectnumber X HSLVT Bal. c/fLC

COBJNR Trans.objctno. X HSL01 TotalLC

SOBJNR Partner obj.no. X ... ...

RTCUR Currency X HSL16 ...

RUNIT Base unit X

DRCRK Debit/credit X KSLVT Bal. c/fGC

RPMAX Period X KSL01 Total LC

RBUKRS Company code ... ...

RACCT Account number KSL16 ...

RBUSA Business area

RFAREA Functionalarea MSLVT Balc/fQty

OCLNT Original client MSL01 Qty

LOGSYS Logical system ... ...

RMVCT Transactn type MSL16 ...

RASSC Tradingpartner MSL16 ...

SBUKRS PartnercompCde CSPRED Distr.KeyCurr.

SACCT Partneraccount QSPRED Distr. KeyQty

SBUSA Send.bus.ar.

SFAREA Part. FuncArea

4. Actual Line Item Table GLFUNCA

FieldDescription KeyFieldDescription Key

RCLNT Client X REFDOCCT Document cat. ber GL_SIRID Record

number X REFACTIV FI-SL actvty

RLDNR Ledger CPUDT Entered on

RRCTY Record type CPUTM Entered at

RVERS Version USNAM User name

RYEARFiscal year AWTYP Ref. procedure

RTCURCurrency AWORGReferenc org.un

RUNIT Base unit

DRCRK Debit/credit

POPER Posting period

464

第 483 页 / 共 509 页

AC220 Appendix 2: Appendix 2

DOCCT Document cat.

DOCNR Document nr.

DOCLN Document line

RBUKRS Company code

RACCT Account number

RBUSA Business area

RFAREA Functional area

OCLNT Original client

LOGSYS Logical system

RMVCT Transactn type

RASSC Trading partner

SBUKRS Partner compCde

SACCT Partner account

SBUSA Send.bus.ar.

SFAREA Part. FuncArea

TSL Tcurr.

HSL LocCurr.

KSL GrpCurr.

MSL Quantity

SGTXT Text

AUTOM Auto. ID

DOCTY Document type

ACTIV FI-SL activity

BUDAT Posting date

WSDAT Value date

REFDOCNR Document number

REFRYEAR Fiscal year

REFDOCLN Line item

5. Plan Line Item Table GLFUNCP

Field Description KeyFieldDescription Key

RCLNT Client X TSVLT Bal c/f TC

465

第 484 页 / 共 509 页

Appendix2: Appendix2 AC220

GL_SIRIDRecordnumber XTSL01TotalTC

RLDNR Ledger .... ....

RRCTY Record type TSL16 ....

RVERS Version

RYEAR Fiscal year HSLVT Bal

c/f LC

RTCUR Currency HSL01 Total LC

RUNIT Base unit .... ....

DRCRK Debit/credit HSL16 ....

RPMAX Period

DOCCT Document cat. KSLVT Bal c/f GC

DOCNRDocument number KSL01Total GC

DOCLN Document line .... ....

RBUKRS Company code KSL16 ....

RACCT Account number

RBUSA Businessarea MSLVT Bal c/f Qty

RFAREA Functional area MSL01 Quantity

OCLNT Original client .... ....

LOGSYS Logical system MSL16 ....

RMVCT Transactn type

RASSC Trading partner SGTXT Text

SBUKRSPartner compCdeAUTOM AutoID.

SACCT Partner accountDOCTYDocumenttype

SBUSASend.bus.ar. ACTIVFI-SL activity

SFAREAPart. FuncAreaBUDAT Postingdate

WSDAT Value date

REFDOCNR Document number

REFRYEAR Fiscal year

REFDOCLN Line item

REFDOCCT Document cat.

REFACTIV FI-SL actvty

466

第 485 页 / 共 509 页

AC220 Appendix 2: Appendix 2

CPUDT Entered on

USNAM Username

AWTYP Ref. procedure

AWORG Referenc org.units

CPUTM Entered at

MENU PATHS

This is a summary sheet of the menu paths presented during the course. The

menuspathsareapproximatelyarrangedinthesequenceperformedinthecourse.

Youwillfindineachunittherespectivemenupathsusedintheimplementation

guide and in the application.

General navigation

Application menu paths:

SAP R/3 Enterprise: Accounting →Financial Accounting→Special purpose

ledger:

Functions: Planning-Actualposting–Periodicprocessing–Informationsystem

– Environment – Tools – System – Help

Implementation Guide (IMG):

SAP R/3 Enterprise: Tools – Business Engineer – Customizing – Implement

projects – SAP Reference IMG:

FinancialAccounting→SpecialPurposeLedger: →BasicSettings→Planning

→ActualPostings→PeriodicProcessing→InformationSystem→Tools

Unit –FI-SLSpecial ReportingRequirements:

Cost of Sales Accounting

1. Cost of Sales Reporting:Information Systems → Accounting → Financial

Accounting→Spec.PurposeLedger→Selectreport→CostofSalesReporting

→ P and L cost of sales accounting

Entries:

Ledger: 0F

Fiscal year: Current year

Period from: 001

Period to: Current period

Company code: 1000

Plan version: 0

467

第 486 页 / 共 509 页

Appendix2: Appendix2 AC220

Data source: Push button “Display Extract”

SelectExtract“P&LCurrentyeartodate”. Execute.

Drilldown to other reports:

Mark block:

Cursoron blockbegin → Edit→ Select block

Cursor on block end→ Edit → Select block

Goto → Call up report

Options:

1. Actual line items for table GLFUNCT

2. Period breakdown

Foreachoption,youcanthendrilldowntothedocuments.

Customizing Cost of Sales Accounting

1. Functional Areas: IMG: → Enterprise Structure → Maintain Structure →

Definition→FinancialAccounting→Maintainfunctionalarea

2. Preparecostofsalesaccounting: IMG:→FinancialAccounting→Financial

AccountingGlobalSettings→CompanyCode→Preparecostofsalesaccounting

3. Enter Substitutionstepsforthefunctionalareasandactivatethesubstitution

for the company code.

Unit – Characteristics and Key Figures

1. Coding Block

IMG:→FinancialAccounting→SpecialPurposeLedger→BasicSettings→

Maintain Coding Block

Coding Block:

→ SAP standard account assignment

→ Customer include structure

→ CI_COBL

New field: Light mode: → Add Field

Newfield: Expertmode: →Accountassignmentfield→Expertmode→Account

assignmentfield(Createdomain,createdataelementetc.)

2. Subscreen: → Subscreen: → Create→ List

3. Makinganewfieldavailable for anFI-Posting:

468