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

第 1 页 / 共 411 页

AC220

Special Purpose Ledger

mySAP Financials

Date

Training Center

Instructors

Education Website

Participant Handbook

Course Version: 2005 Q2

Course Duration: 5 Day(s)

Material Number: 50074175

An SAP course - use it to learn, reference it for work

第 2 页 / 共 411 页

Nopartofthispublicationmaybereproducedortransmittedinanyformorforanypurposewithout

theexpresspermissionofSAPAG.Additionallythispublicationanditscontentsareprovided

solelyforyouruse,thispublicationanditscontentsmaynotberented,transferredorsoldwithout

theexpresspermissionofSAPAG.Theinformationcontainedhereinmaybechangedwithout

priornotice.

SomesoftwareproductsmarketedbySAPAGanditsdistributorscontainproprietarysoftware

componentsofothersoftwarevendors.

Trademarks

• Microsoft®,WINDOWS®,NT®,EXCEL®,Word®,PowerPoint®andSQLServer®are

registeredtrademarksofMicrosoftCorporation.

• IBM®,DB2®,OS/2®,DB2/6000®,ParallelSysplex®,MVS/ESA®,RS/6000®,AIX®,

S/390®,AS/400®,OS/390®,andOS/400®areregisteredtrademarksofIBMCorporation.

• ORACLE®isaregisteredtrademarkofORACLECorporation.

• INFORMIX®-OnLineforSAPandINFORMIX®DynamicServerTMareregistered

trademarksofInformixSoftwareIncorporated.

• UNIX®,X/Open®,OSF/1®,andMotif®areregisteredtrademarksoftheOpenGroup.

• Citrix®,theCitrixlogo,ICA®,ProgramNeighborhood®,MetaFrame®,WinFrame®,

VideoFrame®,MultiWin®andotherCitrixproductnamesreferencedhereinaretrademarks

ofCitrixSystems,Inc.

• HTML,DHTML,XML,XHTMLaretrademarksorregisteredtrademarksofW3C®,World

WideWebConsortium,MassachusettsInstituteofTechnology.

• JAVA®isaregisteredtrademarkofSunMicrosystems,Inc.

• JAVASCRIPT®isaregisteredtrademarkofSunMicrosystems,Inc.,usedunderlicensefor

technologyinventedandimplementedbyNetscape.

• SAP,SAPLogo,R/2,RIVA,R/3,SAPArchiveLink,SAPBusinessWorkflow,WebFlow,SAP

EarlyWatch,BAPI,SAPPHIRE,ManagementCockpit,mySAP.comLogoandmySAP.com

aretrademarksorregisteredtrademarksofSAPAGinGermanyandinseveralothercountries

allovertheworld. Allotherproductsmentionedaretrademarksorregisteredtrademarksof

theirrespectivecompanies.

Disclaimer

THESEMATERIALSAREPROVIDEDBYSAPONAN"ASIS"BASIS,ANDSAPEXPRESSLY

DISCLAIMSANYANDALLWARRANTIES,EXPRESSORAPPLIED,INCLUDING

WITHOUTLIMITATIONWARRANTIESOFMERCHANTABILITYANDFITNESSFORA

PARTICULARPURPOSE,WITHRESPECTTOTHESEMATERIALSANDTHESERVICE,

INFORMATION,TEXT,GRAPHICS,LINKS,ORANYOTHERMATERIALSANDPRODUCTS

CONTAINEDHEREIN.INNOEVENTSHALLSAPBELIABLEFORANYDIRECT,

INDIRECT,SPECIAL,INCIDENTAL,CONSEQUENTIAL,ORPUNITIVEDAMAGESOFANY

KINDWHATSOEVER,INCLUDINGWITHOUTLIMITATIONLOSTREVENUESORLOST

PROFITS,WHICHMAYRESULTFROMTHEUSEOFTHESEMATERIALSORINCLUDED

SOFTWARECOMPONENTS.

第 3 页 / 共 411 页

About This Handbook

Thishandbookisintendedtocomplementtheinstructor-ledpresentationofthis

course,andserveasasourceofreference. Itisnotsuitableforself-study.

Typographic Conventions

American English is the standard used in this handbook. The following

typographic conventions are also used.

Type Style Description

Example text Wordsorcharactersthatappearonthescreen. These

includefieldnames,screentitles,pushbuttonsaswell

asmenunames, paths, andoptions.

Alsousedforcross-referencestootherdocumentation

bothinternal(inthisdocumentation)andexternal(in

other locations, such asSAPNet).

Example text Emphasizedwords or phrases in bodytext, titlesof

graphics, and tables

EXAMPLETEXT Names of elements in the system. These include

reportnames,programnames,transactioncodes,table

names, andindividualkey wordsof aprogramming

language,whensurroundedbybodytext,forexample

SELECT and INCLUDE.

Example text Screenoutput. Thisincludesfileanddirectorynames

and their paths, messages, names of variables and

parameters, and passages of the source text of a

program.

Example text Exactuserentry. Thesearewordsandcharactersthat

youenterinthesystemexactlyastheyappearinthe

documentation.

<Example text> Variableuserentry. Pointedbracketsindicatethatyou

replacethesewordsandcharacterswithappropriate

entries.

iii

Type Style	Description
Example text	Wordsorcharactersthatappearonthescreen. These includefieldnames,screentitles,pushbuttonsaswell asmenunames, paths, andoptions. Alsousedforcross-referencestootherdocumentation bothinternal(inthisdocumentation)andexternal(in other locations, such asSAPNet).
Example text	Emphasizedwords or phrases in bodytext, titlesof graphics, and tables
EXAMPLETEXT	Names of elements in the system. These include reportnames,programnames,transactioncodes,table names, andindividualkey wordsof aprogramming language,whensurroundedbybodytext,forexample SELECT and INCLUDE.
Example text	Screenoutput. Thisincludesfileanddirectorynames and their paths, messages, names of variables and parameters, and passages of the source text of a program.
Example text	Exactuserentry. Thesearewordsandcharactersthat youenterinthesystemexactlyastheyappearinthe documentation.
<Example text>	Variableuserentry. Pointedbracketsindicatethatyou replacethesewordsandcharacterswithappropriate entries.

第 4 页 / 共 411 页

AboutThisHandbook AC220

Icons in Body Text

The following iconsareused in thishandbook.

Icon Meaning

Formoreinformation,tips,orbackground

Noteorfurtherexplanationofpreviouspoint

Exception or caution

Procedures

Indicatesthattheitemisdisplayedintheinstructor’s

presentation.

Icon	Meaning
	Formoreinformation,tips,orbackground
	Noteorfurtherexplanationofpreviouspoint
	Exception or caution
	Procedures
	Indicatesthattheitemisdisplayedintheinstructor’s presentation.

第 5 页 / 共 411 页

Contents

Course Overview......................................................... vii

Course Goals...........................................................vii

Course Objectives .....................................................vii

Unit 1: FI-SL: Special Reporting........................................1

Overview of FI-SL.......................................................2

Unit 2: Table Definition Characteristics and Key Figures ...... 25

Characteristics and Key Figures of Table Definition..............26

Unit 3: Setting Up the FI-SL Environment.......................... 61

FI-SL Structure........................................................62

Configuring the Ledger...............................................71

Line Items and Customizing Tools..................................90

Unit 4: Direct Postings and Adjustments .........................121

Adjustment Postings in FI-SL ......................................122

Unit 5: Validations, Substitutions, and Rules ....................161

Functionality of FI-SL Validations and Substitutions ............162

Creation and Maintenance of Validations and Substitutions ...177

Unit 6: Sets and Basic Feature Of the Report Painter..........197

Sets....................................................................198

Report Painter Components........................................212

Unit 7: Planning .........................................................221

Settings in FI-SL Planning..........................................222

Unit 8: Allocations......................................................255

Using Allocations in FI-SL ..........................................256

Unit 9: Document Split.................................................271

Understanding and Customizing Document Split................272

Unit 10: Rollups .........................................................291

Rollups in FI-SL......................................................292

第 6 页 / 共 411 页

Contents AC220

Appendix 1: Course Information .................................349

Appendix 2: Appendix 2 ............................................365

Index .......................................................................401

第 7 页 / 共 411 页

Course Overview

Attheendofthecourse,theparticipantswillbefamiliarwiththeFI-SLfunction

andlearnhowtousetheFI-SLcomponents. Theywillalsogainknowledgeabout

theimportantcontrolanddataprocessingtechniques.

Target Audience

Thiscourseisintendedforthefollowing audiences:

• Project team members

Course Prerequisites

Required Knowledge

• A Level 1 and a Level 2 course

Course Goals

This course will prepare you to:

• UnderstandtheconceptsbehindFI-SL,beabletoprocessdatainFI-SL,and

generate reports on this data

• AcquireexpertisegoodknowledgeabouttheFI-SLfunctionsandbeableto

use FI-SL components

Course Objectives

After completingthiscourse, youwillbeable to:

• ExplaintheimportanceofFI-SLandinformationflowinFI-SL

• List thekeycharacteristicsandkeyfiguresintheFI-SL environment and

determinetheprerequisitestocreateanewfieldinFI-SL

SAP Software Component Information

TheinformationinthiscoursepertainstothefollowingSAPSoftwareComponents

and releases:

vii

第 8 页 / 共 411 页

CourseOverview AC220

viii

第 9 页 / 共 411 页

Unit 1

FI-SL: Special Reporting

Unit Overview

This unit gives you a rough representation of the objectives, integration, and

specialrequirementsthatspeakfortheimplementationofanFI-SLsystem. The

unit also presentsaconcreteexamplefor FI-SLusage, theP&Lbreakdownby

functionalareaswithexamplepostingsinthesystem.

Unit Objectives

After completing thisunit, you will beableto:

• UnderstandtheconceptofSpecialPurposeLedgeranditsobjectives

• DistinguishFI-SL from other SAP applications

• Describethe special reporting requirements

• Explain FI-SL with an example

Unit Contents

Lesson: Overview of FI-SL .......................................................2

Exercise 1: Standard Ledgers and Special Purpose Ledgers.........15

第 10 页 / 共 411 页

Unit1: FI-SL:SpecialReporting AC220

Lesson: Overview of FI-SL

Lesson Overview

Thislessonprovidesanoverviewof theFI-SLinformationsystem. It describes

howtodistinguishFI-SLfromotherSAPapplications.Inaddition,itdescribesthe

specialreportingrequirementsandprovidesanexampleofFI-SL.

Lesson Objectives

After completingthislesson, you will beable to:

• UnderstandtheconceptofSpecialPurposeLedgeranditsobjectives

• Distinguish FI-SLfromother SAP applications

• Describethespecial reporting requirements

• Explain FI-SL with an example

Business Example

Mostoftheinformationforyourcompanyisobtainedfromotherapplicationareas

andmustbereorganized. Insomecases,youneedtoprocesstheinformationto

providespecificcombinationsofsummarizeddata. Theconceptsanddesignof

thecomponentFI-SLmustbereviewedtoestablishwhetherornotFI-SLmeets

thesespecialrequirements. Onespecificrequirementistoprovideabreakdownof

thesecostsinto“functionalareas”,suchasmanufacturing,generaladministration,

sales,andresearchanddevelopment. YouneedtodeterminewhetherornotFI-SL

cancompilethisinformationandproduceacorrespondingreport.

第 11 页 / 共 411 页

AC220 Lesson: Overview of FI-SL

FI-SL Information System

Figure 1: FI-SL:SpecialReportingRequirements: Overview

Figure 2: FI-SL: Information Processing

InformationiscollectedfromotherSAPapplications,suchasFI,CO,MM,SD,

externaldatatransfer,andFI-SLadjustmentpostings. Thisinformationisstored

in user-defined tables for reporting purposes.

Theupdateandaccumulationofdatatakesplaceduringdatatransfer.

Additional processing functionsinFI-SL includeplanning, allocations, rollup,

currency translation, and balancecarryforward.

第 12 页 / 共 411 页

Unit1: FI-SL:SpecialReporting AC220

FI-SL enables flexible evaluation options in reporting (Report Painter, Report

Writer).

FI-SL as Distinguished from Other SAP Applications

Figure 3: Standard Ledgers and Special-Purpose Ledgers

Ledgers are broken down into two groups:

• Standard ledgers

• Special-purpose ledgers

Standard Ledgers

• StandardledgersarepreconfiguredledgersdeliveredbySAP.Thedatamodel

andspecificpredefinedfunctionsforbusinessrequirementsareavailableto

theusersinstandardledgers,suchasgeneralledger,reconciliationledger,

profitcenterledger,andconsolidationledger. FI-SLfunctionsareintegrated

into the corresponding application.

Special-Purpose Ledgers

• Special-purpose ledgers are user-defined ledgers that can be maintained

as general ledgers or subledgers in the FI-SL application using account

assignments.

UsingtheFI-SLinstallationprograms,userscancreatetheirowndatabases

to meet their requirements.

• Accounting valueson user-defined account assignments canbestoredas

summaryandlineitemtablesforreportingpurposesinFI-SL.

第 13 页 / 共 411 页

AC220 Lesson: Overview of FI-SL

Figure 4: SAPStructuresandCustomer-DefinedStructures

ThoughthestructuresofthetablesdeliveredwiththestandardSAPsystemtable

arefixed,youcanalsocreateyourowntablestructuresinFI-SLtocontainflexible

combinations of characteristics.

Figure 5: Integrated Consolidation

UsingFI-SL,youcancollectdatafromotherSAPapplications,suchasFI,CO,

MM, and SD, external systems, and FI-SL adjustment postings for reporting

purposes.

TheFI-SLsystemiscompletelyintegratedwithotherSAPsystems. Asaresult,

youdonotneedto modifyotherSAPapplications.

Duringdatatransfer,datacanbechangedoraccumulated.

第 14 页 / 共 411 页

Unit1: FI-SL:SpecialReporting AC220

In FI-SL, you can process data using planning, allocations, rollups, currency

translation,andbalancecarryforward(periodicprocessing)functions.

YoucanusetheinformationsysteminFI-SL(ReportPainter/ReportWriter)to

create flexible reports and evaluate data.

Special Reporting Requirements

Figure 6: Special Reporting Requirements (1)

You can use special purpose ledgers to report additional fields, such as ( →

additionallevelsofdetail,totalsforspecificfieldcombinations).

第 15 页 / 共 411 页

AC220 Lesson: Overview of FI-SL

Figure 7: Special Reporting Requirements (2)

You can use special purpose ledgers to collect selective data ( → activity

assignment, ledger selection)

Figure 8: Special Reporting Requirements (3)

Youcanusespecialpurposeledgerstoupdatealternativechartsofaccounts(→

operating, country, corporate) and to use anon-calendar fiscal year→foreign

subsidiary, corporate group).

第 16 页 / 共 411 页

Unit1: FI-SL:SpecialReporting AC220

Figure 9: Special Reporting Requirements (4)

You can usespecial-purposeledgerstodetermineyour ownperioddefinitions,

such as day, week, and month.

Figure 10: Special Reporting Requirements (5)

You can use special purpose ledgers to evaluate several applications and

organizational units.

第 17 页 / 共 411 页

AC220 Lesson: Overview of FI-SL

Figure 11: Special Reporting Requirements (6)

You can use special purpose ledgers to allocate documents according to

characteristics,suchasprofitcenter,businessarea,specialregion,andmaterial.

FI-SL Example

Figure 12: Example: Cost of Sales by Functional Area

This figure shows asimplified exampleof an FI-SL report on aP/L statement

showingthecostofsalesbrokendownintothefunctionalareas,production,sales

anddistribution,administration,andresearchanddevelopment.

第 18 页 / 共 411 页

Unit1: FI-SL:SpecialReporting AC220

Figure 13: Pand L Period and Cost-of-SalesAccounting

Thisfolioillustratestwomethodstocalculatetheprofitandlossstatementfora

company,Periodaccounting,whichusestotalcosts,andcost-of-salesaccounting,

which uses the cost of goods sold.

In the total costs schema, the profit and loss statement is broken down into

individual income and expense types.

The total operating profit for this accounting period is compared to the costs

incurred in the period.

In cost-of-sales accounting, the sales revenues of the accounting period are

balanced against the manufacturing costs incurred for the services rendered.

Thesystemassignstheexpenses, accordingtopriority, tothefunctionalareas

in the company, such as production, sales, and administration. Expenses and

revenuesthatcannotbeallocatedtofunctionalareasmustbedisplayedinother

P/Lstatementitemsclassifiedbyexpenseandrevenuetypes.

第 19 页 / 共 411 页

AC220 Lesson: Overview of FI-SL

Figure14: AssignmentofFunctionalAreasintheP/LAccount

By breaking down costsinto the functional areas such asmanufacturing, sales

and distribution, administration, and research and development, cost-of-sales

accountingshowswhereandwhycostswereaccruedinacompany.

Figure 15: Cost-of-Sales Accounting: Overview

Forallexpensepostings,thefunctionalareaFAREAcanbederivedfromexisting

accountassignments,suchascostcenter,costelement,orproductionorder,and

recorded in the document line.

第 20 页 / 共 411 页

Unit1: FI-SL:SpecialReporting AC220

In addition to the general ledger FI-GL,another ledger is stored in FI-SL. All

FI-relatedbusinesstransactionscanbeupdatedinthisledger.

Unlikethegeneralledger,thetransactionfiguresarebrokendownintofunctional

areas.

Thisfiguredemonstrateshowyou canuseFI-SL.

Thefollowingsamplepostingsaredisplayedinthispart:

• Salesrevenuefrom SalesOrderManagement (1)

• Cost of sales from Goods Issue (2)

• Productionvariancesfromsettlementoftheproductionorder(3)

• Allcreditsanddebitsonallproductioncostcenters(over/underabsorption)

(3a)

• All postings to cost centers related to the functional areas, sales and

distribution,administration,andresearchanddevelopment(3b)

• CorrectionpostingsfromthereconciliationledgerbacktoFI-SLinthecase

of secondary cross-functionalareapostings(3c)

• Postings to result objects (4)

• Other expenses (5)

Figure 16: Assignment of Functional Areas in the P/L

Ifthecostofsalesaccountingisactivatedforacompanycode,afunctionalareais

determined for all P and L postings.

No functional area is derived for postings to balance sheet accounts or for

recording keyfiguresinManagementAccounting.

第 21 页 / 共 411 页

AC220 Lesson: Overview of FI-SL

Noconnection(reconciliationledger) toFIisavailablefor allocationsinProfit

Center Accounting.

To ensure that the derivation is consistent, only fields that are available for

ManagementAccounting-internalclearing,suchasassignment,canbequeriedin

theconditionsforsubstitutioninFI.AlthoughthesystemusesFIsubstitutionfor

ManagementAccounting-internalclearing,theresultswouldthenbedifferent.

第 22 页 / 共 411 页

Unit1: FI-SL:SpecialReporting AC220

第 23 页 / 共 411 页

AC220 Lesson: Overview of FI-SL

Exercise 1: Standard Ledgers and Special

Purpose Ledgers

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Namefiveapplicationareaswherestandardledgersareusedandstatethe

maindifferencesbetweenthesestandardledgersandspecialpurposeledgers

• List the main features of special purpose ledgers that go beyond the

restrictionsof standardledgersandprovideenhancementstothestandard

ledgers

• Executeareportgroupthatisdeliveredwiththestandardsystem,showinga

breakdownoftheprofitandlossstatement(costofgoodssold)byfunctional

areasanddisplaytheoriginaldocumentsforthefunctionalareacostsshown

in the report

Business Example

Mostoftheinformationforacompanyourcompanycomesfromotherapplication

areasandmustbereorganizedandprocessedfurthertoprovidesummarizeddata

inthe chosen combinationsin reporting. The concept and design of the FI-SL

componentmustbereviewedtodeterminewhetherornotitmeetsthesespecial

requirements.

Onespecificrequirementistoprovideabreakdownofthesecostsby“functional

areas,” such as manufacturing, administration, sales, and research and

development. CanFI-SLprovidethisinformationandtherequiredreports?

Task:

1. ListfiveapplicationareasforwhichSAPdelivers“standardledgers”.

____________________________________________________________

2. Howdo“specialpurposeledgers”differfrom“standardledgers”?

____________________________________________________________

Continued on next page

第 24 页 / 共 411 页

Unit1: FI-SL:SpecialReporting AC220

3. Listafew“specialreportingrequirements,”whichcouldenableuserstouse

FI-SLasanenhancementtothestandardapplicationareasinAccounting.

____________________________________________________________

4. Postaninvoiceandcheckthederivedfunctionalarea.

Menu path:

SAPEasyAccess→Accounting→FinancialAccounting→Creditors→

Post → General Accounting (F-43)

Usetoday’sdateasthedocumentdateandpostingdate.

Document type: KR

Company code: AC##

Posting key: 31 Creditor: T-F00A00

Amount: 1160

Tax: 160 Tax code: VN Tax code: VN

Postingkey: 40G/Laccount: 471000 G/Laccount: 471000

Amount: 1000

Cost center: T-A20A##

Write down the document number.

Underwhichfunctionalareawasthedocumentposted?

第 25 页 / 共 411 页

AC220 Lesson: Overview of FI-SL

Solution 1: Standard Ledgers and Special

Purpose Ledgers

Task:

1. ListfiveapplicationareasforwhichSAPdelivers“standardledgers”.

____________________________________________________________

a) ThefiveapplicationareasforwhichSAPdelivers“standardledgers”

are:

1. General Ledger FI-GL

2. Legal Consolidation FI-LC

3. Profit Center Accounting EC-PCA

4. Reconciliation Ledger CO-CEL

5. Joint Venture IS-OIL

2. Howdo“specialpurposeledgers”differfrom“standardledgers”?

____________________________________________________________

a) Standard ledgers are configured and delivered by SAP. The data

model and specific functions for certain business requirements are

alreadyset in the individual applications.

Special purpose ledgers are user-defined ledgers for which you

specify attributes that correspond toyour businessrequirements. A

special purpose ledger is the only type of ledger you can create in

the FI-SL system.

3. Listafew“specialreportingrequirements,”whichcouldenableuserstouse

FI-SLasanenhancementtothestandardapplicationareasinAccounting.

____________________________________________________________

Continued on next page

第 26 页 / 共 411 页

Unit1: FI-SL:SpecialReporting AC220

a) Listafew“specialreportingrequirements,”whichcouldenableusers

to useFI-SL asanenhancement to thestandardapplication areasin

Accounting. You can usespecial-purposeledgers for thefollowing

purposes:

1. Toreportadditionalfields(→additionallevelsofdetail,totals

for specific field combinations)

2. To collect data selectively ( → activity assignment, ledger

selection)

3. Toupdatealternativechartsofaccounts(→operating,country,

corporate) and to use a non-calendar fiscal year ( → foreign

subsidiary, corporate group)

4. Tospecifyyourownperioddefinitions,suchasday,week,and

month,forwhichtotalsrecordsaretobewritten

5. To make evaluations that affect several applications and

organizationalunits,suchascompanycodes,companies,business

and controlling areas.

6. To make changes in FI-SL while updating the date, such as

substitutions and summarizations.

AdvantagesofUsingtheFI-SLSpecialLedgerSystem

The FI-SL system is a tool you can use to enhance the functions

availableinotherSAPapplications,suchasGeneralLedger(FI-GL),

Profit Center Accounting (EC-PCA), or Cost Center Accounting

(CO-CCA), without modifying the standard system. You can use

FI-SLtoaddcodingblockdimensionstoyourdatabasetables. Other

advantagesof theFI-SL system include:

FlexibleDatabaseStructureswithAdditionalFields

You cancreateyour owndatabasetablesanddefinedimensionsnot

availableinthestandardsystem,suchas“specialregion”,tomeetthe

specific business and reporting requirements. As a result, you can

compileandsummarizeinformationatthelevelofdetailyourequire

for any code combination.

Selective Data Collection

Data flowin FI-SL isvariable. Youcanassign activities tospecific

company code/ledger or company/ledger combinations to specify

whichledgersaretobeupdated. Youcanuseselectionconditionsto

limit the number of ledgers updated.

Adjustment Postings

Continued on next page

第 27 页 / 共 411 页

AC220 Lesson: Overview of FI-SL

In FI-SL, you can make adjustment or correction postings. For

example,youcanpostdataforadifferentversion. Adjustmentpostings

are used for amortization.

Alternative Charts of Accounts

Youcan use several chartsof accountsin FI-SL, suchasoperating,

corporate, andcountrychartsof accounts.

AlternativeFiscalYearandFiscalYearVariants

You can define your own periods in FI-SL. You can specify the

accountingperiods,thefiscalyear,andtheaccountingperiodsinthe

fiscal year.

You can use this function to report, for example, on a weekly or

monthly basis.

FI-SL-SpecificChangesinUpdatingData

ToensurethatonlyvaliddataisrecordedintheFI-SLsystem,youcan

usethevalidation and substitutionsoftwareto verify and/or replace

data when you enter the data.

SummarizationofLineItemInformationfromOtherSources

YoucanuseFI-SLtosummarize,modify,andoffsetplannedandactual

datafromotherSAPapplicationsandexternalsystems.

Cross-Application Reporting

YoucanusetheFI-SLsystemtoevaluateandreportdatafromvarious

SAP applications andorganizational units.

4. Postaninvoiceandcheckthederivedfunctionalarea.

Menu path:

SAPEasyAccess→Accounting→FinancialAccounting→Creditors→

Post → General Accounting (F-43)

Usetoday’sdateasthedocumentdateandpostingdate.

Document type: KR

Company code: AC##

Posting key: 31 Creditor: T-F00A00

Amount: 1160

Tax: 160 Tax code: VN Tax code: VN

Postingkey: 40G/Laccount: 471000 G/Laccount: 471000

Amount: 1000

Continued on next page

第 28 页 / 共 411 页

Unit1: FI-SL:SpecialReporting AC220

Cost center: T-A20A##

Write down the document number.

Underwhichfunctionalareawasthedocumentposted?

a) Menu path:

SAPEasyAccess→Accounting→FinancialAccounting→Creditors

→ Post →General Accounting (F-43)

Usetoday’sdateasthedocumentdateandpostingdate.

Document type: KR

Company code: AC##

Posting key: 31 Creditor: T-F00A00

Amount: 1160

Tax: 160Tax code: VN Taxcode: VN

Postingkey: 40G/Laccount: 471000 G/Laccount: 471000

Amount: 1000

Cost center: T-A20A##

Functional Area: 0400 was automatically determined from the cost

center.

第 29 页 / 共 411 页

AC220 Lesson: Overview of FI-SL

Lesson Summary

You should now be able to:

• UnderstandtheconceptofSpecialPurposeLedgeranditsobjectives

• DistinguishFI-SL from other SAP applications

• Describethe special reporting requirements

• Explain FI-SL with an example

第 30 页 / 共 411 页

UnitSummary AC220

Unit Summary

You should now be able to:

• UnderstandtheconceptofSpecialPurposeLedgeranditsobjectives

• Distinguish FI-SLfromother SAP applications

• Describethespecial reporting requirements

• Explain FI-SL with an example

第 31 页 / 共 411 页

AC220 Test Your Knowledge

Test Your Knowledge

1. TheadditionalprocessingfunctionsinFI-SLinclude:

Choosethecorrectanswer(s).

□ A Planning

□ B Data transfer

□ C Rollup

□ D Currency translation

2. What is FI-SL used for?

3. Giveany twousesof special-purposeledgers.

4. Forallexpensepostings,thefunctionalarea canbederived

from the existing account assignments.

Fillintheblankstocompletethesentence.

第 32 页 / 共 411 页

TestYourKnowledge AC220

Answers

1. TheadditionalprocessingfunctionsinFI-SLinclude:

Answer: A, C, D

TheadditionalprocessingfunctionsinFI-SLincludeplanning,allocations,

rollup, and currency translation.

2. What is FI-SL used for?

Answer: FI-SLisusedtocollectdatafromotherSAPapplications,suchas

FI,CO,MM,andSD,externalsystems,andFI-SLadjustmentpostingsfor

reporting purposes.

3. Give anytwousesof special-purposeledgers.

Answer: Special-purposeledgerscanbeusedto:

• Display reports about additional fields

• Collect selective data

• Updatealternativechartsofaccountsanduseanon-calendarfiscalyear

4. Forallexpensepostings, thefunctionalareaFAREAcanbederivedfrom

the existing account assignments.

Answer: FAREA

第 33 页 / 共 411 页

Unit 2

Table Definition Characteristics and

Key Figures

Unit Overview

Inthisunit,youwilllearnhowtoincludenewfields(characteristics)intheSAP

codingblock. Theunitwillalsodescribekeyfiguresforbalances(amountsand

quantities). YouwillknowaboutthecomponentsthatmakeupFI-SLtables. You

willalsolearnhowtodefineandinstalltablegroupsinFI-SL.

Unit Objectives

After completing thisunit, you will beableto:

• Includeyourownfield(characteristic)inthecodingblockoftheSAPsystem

• Explainhowtousethebasicmodeandnamethestepsrequiredwhenusing

the expert mode

• Implement integrated consolidation

• Describe coding block field selection

• CreateanFI-SLtablegroupintheSAPRepository

• Describehowto usekey figuresand indices

• DescribehowtoinstallthetablegroupinFI-SL

Unit Contents

Lesson: Characteristics and Key Figures of Table Definition ..............26

Exercise 2: Characteristics and Basic Key Figures ....................41

第 34 页 / 共 411 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Lesson: Characteristics and Key Figures of Table

Definition

Lesson Overview

Thislessonwillhelpyouunderstandhowtoincludeyourownfield,characteristic,

inthecodingblockoftheSAPsystem. Youwillgettoknowhowtousethebasic

modeandnamethestepsrequiredwhenusingtheexpertmode. Youwilllearn

howtocreateanFI-SLtablegroupintheSAPRepositoryandhowtoinstallthe

table group in FI-SL.

Lesson Objectives

After completingthislesson, you will beable to:

• Includeyourownfield(characteristic)inthecodingblockoftheSAPsystem

• Explainhowtousethebasicmodeandnamethestepsrequiredwhenusing

the expert mode

• Implement integrated consolidation

• Describe coding block field selection

• CreateanFI-SL tablegroupintheSAP Repository

• Describehow to usekey figuresand indices

• Describehowtoinstall thetablegroupinFI-SL

Business Example

Managementalsorequiresafield(characteristic)calledSpecialRegionthatcanbe

usedtoprovideanadditionalgeographicalbreakdownincertainfinancialreports.

Thisfield(characteristic)mustbecreatedasitisnotdeliveredbySAP.

Afterthecharacteristicsandkeyfigureshavebeensortedlogicallyintogroupsfor

therequiredreports,youneedtogenerateandinstalldatabasetablesforthevarious

FI-SLcomponentsbeforetheycanbemadeavailableforupdateandreporting.

第 35 页 / 共 411 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

SAP Coding Block

Figure17: TableDefinition: Characteristics/BasicKeyFigures: Overview

Figure 18: Alternative Solutions

Therearemanyfieldsinthestandardsystemthatmayfulfillyourrequirements.

Beforeyoudecidetochangethecodingblock, makesurethatthereisno other

solutioninthestandardsystemthatwillsatisfyyourrequirements.

Ifyoudonotfindanalternativesolution,youshouldcarefullyconsiderhowyou

want to use your new field.

第 36 页 / 共 411 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Figure 19: Additional Fields

The account assignment block, also called the coding block, is a standard

componentdeliveredwiththeSAPsystem. Usersdonotautomaticallydealwith

coding blocks.

The transactions and components in the SAP system are based on the coding

block. Theblockdefinesallthefieldsusedinatransactionorfunction.

ThestandardSAPsystemcontainspredefinedfieldsthatcanbeusedforvarious

functions. Inmostcases,theuserdoesnotneedtodefinenewfields.

Theusercanaddafieldtothecodingblockifthenewfieldisrequired.

Theaboveexampleshowswhy it isnecessaryto addtheSpecialRegionfield

to the G/L document entry function.

Definitionofsuitablesubscreensthatcontainyournewfield

ThenewaccountassignmentfieldscanbeusedinFIGeneralLedger,Purchasing,

andInventoryManagement. Youcan,ofcourse,alsousethesefieldsinFI-SL.If

youdefineappropriatefieldmovements,thisinformationcanbetransferredtothe

FI-SLdatabase. Youcandefineupto18additionalaccountassignmentfields.

第 37 页 / 共 411 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Field Maintenance

Figure 20: Field Maintenance: Steps

Previously,itwasproblematictochangethecodingblocktoaddanewfield.

You needed extensive knowledge of how to maintain the Data Dictionary

(Repository) and system tables.

Thenewcodingblockmaintenancetransactionisauser-friendlytool.

Youusethisfunctiontomaintaincross-clientobjects. Thismeansthatanychanges

madetotheseobjectsaffectalltheclientsinthesystem.

Thenewfieldisapermanentadditiontothecodingblock.

In the Expert Mode:

• Createdomain: Technicalinformationsuchasthelengthandfieldtype. If

required, you can enter fixedvaluesforthesedomainsor specifyacheck

table.

• Create data element: Conceptual description of a field. For example,

account number and account type.

• Insert fieldinthecustomizingincludeCI_COBOL forthetablesrelevant

for the coding block and in CI_COBOL_BI for use when entering an FI

document in background processing.

• InsertattheendoftableBSEGforFIG/Laccountpostings.

Inthebasicmode,youonlyneedtoentergeneralfieldinformationsuchasname,

description, and field type.

第 38 页 / 共 411 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Inthelaststepoftheexpertmode,youmustgenerateasubscreenthatcontainsthe

newfield. Thesystemautomaticallygeneratesthissubscreeninthebasicmode.

Figure 21: C A U T I O N ! !

Youcanusethisnewtransactiontoaddyourownfieldtothecodingblockwithout

havingspecialknowledgeoftheDataDictionaryorsystemtablemaintenance.

The following functions are available:

Defineanewaccountassignmentfieldwithorwithoutachecktable

Addanewfieldtodatabasetables(BSEG,COEP,andMSEG)andaddentriesto

the appropriate system control tables.

The new fields are added to the existing tables in the Data Dictionary. These

changes are critical and can lead to a loss of data if not carried out properly.

Remembertosaveyourdatabeforeyouexecutethisfunction.

Whenyouadda newfield, youneed not convert any databasetables. It isnot

possibletomakeallthechangesthatrequireaconversion. Forexample,making

subsequentchangestotheformatofanexistingfieldordeletingafieldusingthe

standardfunctions. Thistypeofchangemayleadtoalossofdata.

Any changes you make are effective throughout the SAP system. To use this

function, you need your own test system. As soon as a client is marked as a

productionclientintableT000,thisfunctionislockedfortheentiresystem.

第 39 页 / 共 411 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Toperformthisfunction,yourequirethefollowingauthorizations:

• X_COBL_MOD:Toaddfieldstothecodingblock

• S_TABU_CLI: Tomaintain cross-client tables

• S_DEVELOP: To maintaintheDataDictionary

• S_TRANSPRT: For the transport

Figure 22: Integrated Consolidation

ThenewfieldcanbeusedbythefollowingSAPcomponents:

• FI: G/L account postings.

• CO: The account assignment field is transferred to CO using the FI

document line.

• MM:Purchasing,InventoryManagement,InvoiceVerification.

• SD:ManualCustomizing: SalesandDistribution/systemcustomization/user

exits.

• EnjoySAP transactions Note: 174413.

IfthefieldisalsoaddedtoFI-SLtables,allthefunctionsintheFI-SLsystemare

available tothisfield. Thesefunctions include:

• FI-SL postings

• Planning

• Allocations

• Rollups

• Balance carryforward

• Reporting

第 40 页 / 共 411 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Figure 23: Coding Block Field Selection

AnimportantadvantageofFI-SLisinthecapabilitytomanagemultipleaccount

assignments and structures. With every posting in a highly integrated system,

quiteadealofadditionalassignmentsareincludedinmostbusinessactivities. A

largeproportionoftheseassignmentsareintendedtomeetthedemandsofspecial

applicationareas,suchasgeneralledgerandManagementAccountingthattake

only the required information.

Controllingrequiresinformationrelatingtothecontrollingarea,thecostobjects

involved,andthecostelement. TheGeneralLedgerneedsinformationpertaining

to the general ledger account.

The FI-SL System extracts out of the coding block any number of the

characteristics made available in a posting to update these combinations and

providetherelationshipsandlevelofdetailneeded. Thesemaygowellbeyond

thespecificrequirementsoftheotherapplicationareas.

第 41 页 / 共 411 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

FI-SL Table Group

Figure 24: FI-SL Table Group

ThedatayousendtoFI-SLisstoredinagroupoftables. Thesearethefollowing:

• Object Table 1: Stores the characteristics you need and also an object

number for these characteristics as receiver and sender. For example,

receiver account RACCT andpartner SACCT.

• Object Table 2: Is optional and contains characteristics that are (fixed)

transaction attributes and have no receiver/sender relationship, such as

ControllingareaKOKRS.Forthesetransactionattributes,anobjectnumber

is also stored.

Theseobjectnumbersdeterminehowthesummaryandlineitemtableswill

be accessed through the object tables.

• SummaryTable: Storestheactualandplantotalbalances.

• LineItemTables: Storesthedocument information(actual/plan)for the

totals stored in the Summary Table.

第 42 页 / 共 411 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Figure 25: Grouping Characteristics in Tables

An implementation of FI-SL is recommended only if your special reporting

requirementscannotbecoveredbythestandardSAPapplications.

WhenyouhavedecidedtouseFI-SL,youshouldanalyzethecharacteristicsyou

needtouseandcombinetogetherforreports. Bygroupingtogetherdimensions

in different table groups, you can improve the system performance and save

storage space.

Figure 26: Number of Database Records

From aperformancepoint of view, the read time maybelonger, especially for

periodicprocessingandinreporting,ifyouhavealargenumberofdatarecords.

第 43 页 / 共 411 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Itisthereforeadvantageoustouseseveral tablegroups.

Figure 27: Table Group Definition (1)

Usingthe“Definetablegroup”function,youcancreateacompletetablegroup.

Youcandefinethevariablecharacteristicsfortwoobjecttables.

Thesystemautomaticallygeneratesthetables,suchasthesummarytable,actual

lineitemtable,andplanlineitemtable,assignedtotheseobjecttables.

Figure 28: Table Group Definition (2)

第 44 页 / 共 411 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

TheDefinetablegroupfunctionavoidsredundantmaintenanceofobjecttables

andtheirdependenttables. Onlytheobjecttable1(andobjecttable2,ifrequired)

is maintained.

You can specifyif a sender characteristic isrequiredfor a characteristicof the

objecttableinthesummarytable,actuallineitemtable,andplanlineitemtable.

Usethesesendercharacteristicsifyouwanttosavethesenderinformationforan

assessmentordistributioninanallocation. Forexample,ifyouwanttoexecute

a distribution between cost centers, you can save the sender cost center in the

data record.

Importantinformationforsummarytablesandlineitemtablesisderivedfromthe

object table.

Figure 29: Definition: Technical Specifications

Usingthe“Extras→Technicalcharacteristics”function,youdefinethecurrencies

andquantitiesrequiredinyourledger. Tosavestoragespace,youshoulddeselect

allthecurrenciesandquantitiesthatyoudonotwanttouse.

Inthe“Maximumnumberofperiods”field,enterthemaximumnumberofperiod

fieldsperrecord. Thedefaultvalueis16periods,consistingof12periodsandfour

specialperiods. If youwanttostorethedataonaquarterlybasis, for example,

enter‘4’. Fora12periodbasiswithoutspecialperiods,enter‘12’.

Inthe“Fieldlength”field,youdeterminethelengthofthecurrencyandquantity

fields depending on the anticipated length of the amounts to be entered. You

canenterfieldlengths15and17. Youshouldcheckthelengthofthemaximum

amount and quantity and define the respective fields accordingly. If you use

smallerfieldlengths,youwillonceagainsavestoragespace.

第 45 页 / 共 411 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Key Figures

Figure 30: Key Figures

For the combination(s) of characteristicsselected, theFI-SL system stores the

balances in the following key figures:

• TransactionCurrency; thecurrencyofthedocument

• Asecondandthirdcurrencydependingonthecurrenciesselectedfor the

ledgers(companycode,company,controllingarea,andgroup)

• Quantity and additional quantity

Indices

Figure 31: Indices

第 46 页 / 共 411 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Definingindicesforyourtablesisveryimportantforfuturesystemperformance.

Forinformationonindices,pleaserefertoOSSNote31374“FISL:Secondary

indices for transparent tables”.

Youshouldcreateindicesforyoursummarytables. Ifyouwanttocreatelineitem

reports,youshouldalsodefineindicesforthelineitemtables.

The ABAP Report RGUIST00 will help you to find an optimal index for SL

Tables. Try running it for GLFUNCT or your own tables after theyhave been

updatedafteracertaintime. Thisprogramwilllistthemostselectivefields.

Installation in FI-SL

Figure 32: Saving Table Groups

Whenyousaveyourtablegroup,thesystemautomaticallyperformsaconsistency

check of the tables in your table group.

After your table group has been checked and saved, you can request that the

system activate the tables in your table group.

Whenyouhavecreatedyourtables,youcaninstallthetablegroup.

第 47 页 / 共 411 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Figure 33: Installation: Components

You must first determine the components for which you wish to install the

tables. Forthesecomponents,controlentriesaregeneratedforyourtables. The

components are:

• Directposting: Usingtheseentries,youcanpostdatatoyournewtable.

• Masterdata: Usingtheseentries,youcanactivatemasterdatavalidation

for your new table.

• Allocation: Using these entries, you can work with allocations for your

new table.

• Report Writer: Using these entries, you canworkwith report writer for

the new table.

Figure 34: Installation: Generating GLU1