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

第 332 页 / 共 411 页

Unit10: Rollups AC220

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

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

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

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

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

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

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

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

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

be substituted by the categories VANILLA, CHOCOLATE, and

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

number(RMATNR)inthefieldmovementSPXX.

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

Writedownthedocumentnumberanddisplaytheresults.

2. Rollup

Create the following rollup ledgers:

Group Rollup Group Rollup Group Rollup

Ledger Ledger Ledger

01 YA 02 YB 03 YC

04 YD 05 YE 06 YF

07 YG 08 YH 09 YI

10 YJ 11 YK 12 YL

13 YM 14 YN 15 YO

16 YP 17 YQ 18 YR

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

exercise A.

ThisrollupledgermustbedefinedforthetableZZSLTABT.

TheD/CandWritelineitemsindicatorsmustbeselected.

TheledgershouldonlystoretheLedgercurrencyUSD.Therollupversion

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

code/ledgerassignmentto1. Thisrollupledgerwillcontainthecompany’s

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

to the rollup ledger.

Continued on next page

324

第 333 页 / 共 411 页

AC220 Lesson: Rollups in FI-SL

The REVENUE ACCOUNTS 810200 and 81030, the ZONES North

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

STRAWBERRYmust berolledup1:1. Thebusinessareasshouldnot be

takenoverandtheUSDamountsshouldberoundedtofulldollaramounts

(revenue accounts 810200, and 810300).

Createacorresponding field movementGXXZ(whereXX isyourgroup

number)andassigntheuserexitU02intheUserExitBeforeUpdatefield

movement header.

Refertotheexampleexit routineinthesolutions.

CreatetherollupsetGXX-ROL2forthetableZSLTABT.Thismultisetisto

contain the following sets:

GXX-LEDGER (RLDNR)

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

ZSLTABT

GXX-COCODE (RCOCODE)

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

in ZSLTABT

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

for the field RZZREGION in ZSLTABT

GXX-PRODGROUPS (RMATNR = VANILLA, CHOCOLATE,

STRAWBERRY)newbasicsetforthefieldRMATNRinZSLTABT

GXX-GSBE(RBUSA=RETL,WSLE)newbasicsetforthefieldRBUSA

in ZSLTABT

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

RACCT in ZSLTABT

CreateyourrollupGXX-RUP2(whereXXisyourgroupnumber).

Carry out therollupfor the current quarter.

Rollup: GXX-RUP2

Parameters:

Start date: 01.01. current year

End date: 31.03. current year

This is an example for quarter 1.

x Write line items

Document type R0

x Detail list

Continued on next page

325

第 334 页 / 共 411 页

Unit10: Rollups AC220

View the results in your rollup ledger.

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

Thisreport reflectstheresultsofyouractualdirectpostingsandrolledup

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

Q1, Per. 1- 3):

Comparison rollup data/source data

Companycode: ACXX

Fiscal year: XXXX Current quarter

RUPLedgerKW-IST URSPRLedgerKW-IST

Regions/Revenues

810200

810300

VANILLA

810200

810300

CHOCOLATE

810200

810300

STRAWBERRY

NORTH

810200

810300

VANILLA

810200

810300

CHOCOLATE

810200

810300

STRAWBERRY

SOUTH

ZONES NORTH-

SOUTH

Continued on next page

326

Comparison rollup data/source data
Companycode: ACXX Fiscal year: XXXX Current quarter
RUPLedgerKW-IST URSPRLedgerKW-IST Regions/Revenues 810200 810300 VANILLA 810200 810300 CHOCOLATE 810200 810300 STRAWBERRY NORTH 810200 810300 VANILLA 810200 810300 CHOCOLATE 810200 810300 STRAWBERRY SOUTH ZONES NORTH- SOUTH

第 335 页 / 共 411 页

AC220 Lesson: Rollups in FI-SL

General Selections:

Company code: ACXX

Version: 1

Current fiscal year

327

第 336 页 / 共 411 页

Unit10: Rollups AC220

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

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

328

第 337 页 / 共 411 页

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

329

第 338 页 / 共 411 页

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 Rollup Group Rollup Group Rollup

Ledger Ledger Ledger

01 YA 02 YB 03 YC

04 YD 05 YE 06 YF

07 YG 08 YH 09 YI

Continued on next page

330

第 339 页 / 共 411 页

AC220 Lesson: Rollups in FI-SL

10 YJ 11 YK 12 YL

13 YM 14 YN 15 YO

16 YP 17 YQ 18 YR

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

exercise A.

ThisrollupledgermustbedefinedforthetableZZSLTABT.

TheD/CandWritelineitemsindicatorsmustbeselected.

TheledgershouldonlystoretheLedgercurrencyUSD.Therollupversion

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

code/ledgerassignmentto1. Thisrollupledgerwillcontainthecompany’s

quarterly results. 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

Continued on next page

331

第 340 页 / 共 411 页

Unit10: Rollups AC220

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

RACCT in ZSLTABT

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 Rollup Group Rollup Group Rollup

Ledger Ledger Ledger

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

332

第 341 页 / 共 411 页

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

333

第 342 页 / 共 411 页

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

Continued on next page

334

第 343 页 / 共 411 页

AC220 Lesson: Rollups in FI-SL

Select Processing Option.

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

Companycode: ACXX

Fiscal year: XXXX Current quarter

RUPLedgerKW-IST URSPRLedgerKW-IST

Regions/Revenues

810200

810300

VANILLA

810200

Continued on next page

335

Comparison rollup data/source data
Companycode: ACXX Fiscal year: XXXX Current quarter

第 344 页 / 共 411 页

Unit10: Rollups AC220

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

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

Companycode: ACXX

Fiscal year: XXXX Currentquarter

RUPLedger ORGLedgerKW-IST

KW-IST

Regions/Revenues

Continued on next page

336

Comparison rollup data/source data
Companycode: ACXX Fiscal year: XXXX Currentquarter

第 345 页 / 共 411 页

AC220 Lesson: Rollups in FI-SL

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:

Accountnumber: GroupGXX-ERL12(basicset)

Continued on next page

337

第 346 页 / 共 411 页

Unit10: Rollups AC220

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

338

第 347 页 / 共 411 页

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

339

Appl Area	Ex.prog	Applicationarea
GIMV	ZGIVU800	Variable field movement

第 348 页 / 共 411 页

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 Key Data Type LengthCheck ShortText

name Element Table

MANDT x MANDT CLNT 3 Client

ZZMAT x MATNR CHAR 18 Material

number

ZZSUB- MATNR CHAR 18 Material

MAT 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

Continued on next page

340

第 349 页 / 共 411 页

AC220 Lesson: Rollups in FI-SL

Example 2: User exit for rollup

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.

341

Appl Area	Ex.prog	Applicationarea
GBRU	ZZLVU800	Rollup: Userexits

第 350 页 / 共 411 页

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

342

第 351 页 / 共 411 页

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

343

第 352 页 / 共 411 页

UnitSummary AC220

344

第 353 页 / 共 411 页

AC220 Test Your Knowledge

Test Your Knowledge

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

345

第 354 页 / 共 411 页

TestYourKnowledge AC220

Answers

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

346

第 355 页 / 共 411 页

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.

347

第 356 页 / 共 411 页

CourseSummary AC220

Course Summary

You should now be able to:

• ExplaintheimportanceofFI-SLandinformationflowinFI-SL

• Listthekeycharacteristicsand keyfiguresin theFI-SL environmentand

determinetheprerequisitestocreateanewfieldinFI-SL

348

第 357 页 / 共 411 页

Appendix 1

Course Information

Figure 183: Conclusion

Figure 184: Course Objectives

349

第 358 页 / 共 411 页

Appendix1: CourseInformation AC220

Figure 185: Additional Course Objectives

Figure 186: Additional Course Objectives (1)

Figure 187: Course Goals

350

第 359 页 / 共 411 页

AC220 Appendix 1: Course Information

Figure 188: Course Overview Diagram

Figure 189: Main Features Diagram (1)

351

第 360 页 / 共 411 页

Appendix1: CourseInformation AC220

Figure 190: Main Features Diagram (2)

Figure 191: Main Features Diagram (3)

352

第 361 页 / 共 411 页

AC220 Appendix 1: Course Information

Figure 192: Main Features Diagram (4)

Figure 193: Main Features Diagram (5)

353

第 362 页 / 共 411 页

Appendix1: CourseInformation AC220

Figure 194: Main Features Diagram (6)

Figure 195: Main Features Diagram (7)

354

第 363 页 / 共 411 页

AC220 Appendix 1: Course Information

Figure 196: Main Features Diagram (8)

Figure 197: Main Features Diagram (9)

355

第 364 页 / 共 411 页

Appendix1: CourseInformation AC220

Figure 198: Main Features Diagram (10)

Figure 199: Main Features Diagram (11)

356

第 365 页 / 共 411 页

AC220 Appendix 1: Course Information

Figure 200: Main Business Scenario (1)

Figure 201: Main Business Scenario (2)

Figure 202: Recommended Follow-Up Activities

357

第 366 页 / 共 411 页

Appendix1: CourseInformation AC220

New General Ledger Accounting (New GL)

Figure 203: 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)!

358

第 367 页 / 共 411 页

AC220 Appendix 1: Course Information

Figure204: 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 205: AdvantagesinDetail–Extended DataStructure

359

第 368 页 / 共 411 页

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.

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

360

第 369 页 / 共 411 页

AC220 Appendix 1: Course Information

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

361

第 370 页 / 共 411 页

Appendix1: CourseInformation AC220

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

362

第 371 页 / 共 411 页

AC220 Appendix 1: Course Information

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

363

第 372 页 / 共 411 页

Appendix1: CourseInformation AC220

364

第 373 页 / 共 411 页

Appendix 2

Overview on FI-SL

Figure 210: Appendices

Figure 211: Table Group and OtherTechnicalities

365

第 374 页 / 共 411 页

Appendix2: Appendix2 AC220

Figure 212: FI-SL Transaction Data in the Database

Transaction data in the FI-SL database.

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

Calculating the required storage space.

366

第 375 页 / 共 411 页

AC220 Appendix 2: Appendix 2

Figure 214: 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).

367

第 376 页 / 共 411 页

Appendix2: Appendix2 AC220

Figure 215: 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 216: Object Table 1 (1)

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

fields in the key part.

368

第 377 页 / 共 411 页

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

369

第 378 页 / 共 411 页

Appendix2: Appendix2 AC220

Figure 218: 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 219: Object Table 2 (2)

Thefieldsforstoringthesummaryvalues(usuallyablockof16periodsforthe

currencyandquantityfields)comeafterthevariablecharacteristics(R,CandS

characteristics) in the summary table.

370

第 379 页 / 共 411 页

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

371

第 380 页 / 共 411 页

Appendix2: Appendix2 AC220

Figure 221: Plan Line Item Tables: Structure

Thefieldsintheplanlineitemtablearethesameasthefieldsintheactualline

itemtable. However, theposting period isreplacedwiththemaximumperiod.

Asinthesummarytable,thismaximumperiodreferstotheamountbalancesand

quantitybalancesthatarenormallystoredinablockof16periods.

Figure 222: 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).

372

第 381 页 / 共 411 页

AC220 Appendix 2: Appendix 2

Itisnotyetpossibletoautomaticallyinstallthesetablesusingthe“Definetable

group” function.

Todoso,youshouldcopythestandardexampletablesGLREFU(RollupActual

LineItemTable)andGLREFV(RollupPlanLineItemTable)andmodifythem

according to your requirements.

Figure 223: 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 224: Checking Code Combinations

Itisoftennecessarytolimitthecharacteristiccombinations.

373

第 382 页 / 共 411 页

Appendix2: Appendix2 AC220

Example: You can define that account 461000 canonlybeposted towithcost

center 3100 and business area 0001.

Figure 225: 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 226: 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.

374

第 383 页 / 共 411 页

AC220 Appendix 2: Appendix 2

TABLE GROUP AND OTHER TECHNICALITIES

TABLEGROUP FIELDS:EXAMPLEGLFUNC

Objekttable 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 fr.pln frm.

DATPB Valid.fr.Pln to

BUKRS Company Code

ACCT Account Number

BUSA Business Area

FAREA Functional Area

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

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 Recordtype X ...

375

第 384 页 / 共 411 页

Appendix2: Appendix2 AC220

RVERS Version X TSL16 Total TC

RYEAR Fiscalyear X HSLVT Bal. c/fLC

ROB- Object X HSL01 Total LC

JNR number

COB- Trans.objct X ...

JNR no.

SOB- Partner X HSL16 Total TC

JNR obj.no.

RTCUR Currency X KSLVT Bal. c/fGC

RUNIT Baseunit X KSL01 Total LC

DR- Debit/credit X ...

CRK

RP- Period X KSL16

MAX

RBUKRSCompany MSLVT Balc/fQty

code

RACCT Account MSL01 Qty

number

RBUSA Businessarea ...

RFAREA Functional MSL16 Qty

area

OCLNT Original CSPRED Distr.KeyCurr.

client

LOGSYSLogical QSPREDDistr. KeyQty

system

RMVCT Transactn

type

RASSC Trading

partner

SBUKRSPartner

compCde

SACCT Partner

account

SBUSA Send.bus.ar.

SFAREA Part.

FuncArea.

Actual Line Item Table GLFUNCA

376

第 385 页 / 共 411 页

AC220 Appendix 2: Appendix 2

Field Description Key Field Description Key

RCLNT Client X ACTIV FI-SLactivity

GL_SIRIDRecord X BU- Postingdate

number DAT

RLDNR Ledger WS- Valuedate

DAT

RRCTY Recordtype REF- Document

DOCNR number

RVERS Version RE- Fiscalyear

FRYEAR

RYEAR Fiscalyear REF- Position

DO-

CLN

RTCUR Currency REF- Documentcat.

DOCCT ber

RUNIT Baseunit REFAC- FI-SLactvty

TIV

DR- Debit/credit CPUDT Enteredon

CRK

POPER Posting CPUTM Enteredat

period

DOCCT Document US- Username

cat. NAM

DOCNRDocument AW- Ref. procedure

nr. TYP

DO- Document AWORG Referenc

CLN line org.un

RBUKRSCompany REF- Lineitem

code DO-

CLN

RACCT Account

number

RBUSA Business

area

RFAREAFunctional

area

OCLNT Original

client

377