AC220_EN_Col52_FV_Inst_A4 (第13页)

第 487 页 / 共 509 页

AC220 Appendix 2: Appendix 2

IMG: → Financial Accounting → Financial Accounting Global Settings →

Document→LineItem→Controls→Definepostingkeys→Postingkey(e.g.

40) → Field status → Additional account assignments: Entry as Suppress,

Required or Optional

IMG: → Financial Accounting → Financial Accounting Global Settings →

Document→LineItem→Controls→Maintainfieldstatusvariants: →Field

status variant 1000 → Field status group (e.g. G004) → Additional account

assignments: EntryasSuppress, RequiredorOptional

Unit – Defining the Table Requirements

1. Viewing an example Table Group:

IMG:→FinancialAccounting→SpecialPurposeLedger→BasicSettings→

Tables → Display Assignments graphically

FI-SL table e.g. GLFUNCT

2. Table Group Definition:

IMG:→FinancialAccounting→SpecialPurposeLedger→BasicSettings→

Tables→ Definition →Define Table Group

Tablegroup: z.B.ZZNEW→Create: Button“Localtablegroup(companycode)”

Objecttable1: Enternewfields: Setthe“S”(Sender)indicatorasrequired:

→Useobject2Objecttable2: Enternewfieldsifneeded

Navigate totheother tables: Buttonsbelow: Object 1 – Summary –Act. LI –

Plan LI

Indices: →Indices: EnternewIndexID:Buttoncontinue: EnterFieldnames

Technical characteristics: → Extras → Tech. Characteristics: Enter required

currencies,Quantities,Fieldlength15or17: andMaximumnumberofperiods

Overviewof tablegroup: →Tablegroup→Overview

Check table group → Table group →Check

Savetablegroup→Tablegroup→Save: EnterDevelopmentclassforCustomer

objects

Tableactivation: Accept message“Activatetablesandindicesandcreatethem

in the database”.

3. Table Group Installation

Follow-upfunctions: Install: readinformationandcarryon:

SpecifyTableInstallation: ComponentsDirectPosting,MasterData,Allocation,

ReportWriterAdditionalActions: UpdateGLU1andUpdateprograms(Reference

table: Default = GLT1)

Unit – Setting up the FI-SL Environment

469

第 488 页 / 共 509 页

Appendix2: Appendix2 AC220

MasterData: IMG:→FinancialAccounting→SpecialPurposeLedger→Basic

Settings → Master Data

Maintain Activities; Maintain Field Movements; Maintain Ledgers; Maintain

Global Companies; Maintain Company Codes; and in each of the relevant

assignments

Unit – Through Postings and Adjustments

1. Transfer Postings

Applicationmenu: SAPR/3System→Accounting→Financialaccounting→

Specialpurposeledger→Periodicprocessing→Datatransfer:

FI/MM/SD/CO/COstat.key.figures/COplandata-Object/COplandata-

Document

2. Master Data Validation for FI-SL Postings

IMG:→FinancialAccounting→SpecialPurposeLedger→BasicSettings→

MasterData→MaintainIntegrated MasterData

Application: Entering Master Data for the fields (characteristics) in FI-SL

(T830-tables):

Applicationmenu: →SAPR/3System→Accounting→Financialaccounting→

Specialpurposeledger→Environment→Integr. Masterdata→Create

3. Direct (Adjustment) Postings in FI-SL

Applicationmenu: →SAPR/3System→Accounting→Financialaccounting→

Specialpurposeledger→ActualPosting→Localdocuments(Globaldocuments)

→ Enter

4. DocumentTypesandNumberRangesforFI-SLTransactions:

IMG:→FinancialAccounting→SpecialPurposeLedger→ActualPosting→

Maintain Valid Document Types

IMG:→FinancialAccounting→SpecialPurposeLedger→ActualPosting→

NumberRanges→MaintainLocal(Global)NumberRanges

5. Versions:

IMG: → Financial Accounting→ Special Purpose Ledger → Actual Posting

→ Maintain Actual Versions

IMG: → Financial Accounting → Special Purpose Ledger → Planning →

Maintain Plan Versions

6. User Table:

IMG: → Financial Accounting → Special Purpose Ledger → Basic Settings

→MasterData→MaintainUserTables: CreateUsertableandDefinefields

for User table

470

第 489 页 / 共 509 页

AC220 Appendix 2: Appendix 2

7. Document Display

Applicationmenu: →SAPR/3System→Accounting→Financialaccounting→

Specialpurposeledger→ActualPosting→Localdocuments(Globaldocuments)

→ Display

8. Summary Record Display

Applicationmenu: →SAPR/3System→Accounting→Financialaccounting→

Specialpurposeledger→ActualPosting→Displaytotals

8. FI-SL Customizing Tools

ControlReport: IMG: →FinancialAccounting→SpecialPurposeLedger→

Tools → Display Control Report

GraphicNavigation: IMG:→FinancialAccounting→SpecialPurposeLedger

→ Tools → Use Graphic Navigation

PostingTest: IMG:→FinancialAccounting→SpecialPurposeLedger→Tools

→ Perform Diagnosis → Posting Test

PostingStatistics: IMG:→FinancialAccounting→SpecialPurposeLedger→

Tools→PerformDiagnosis→Direct postingstat.

Troubleshooting: IMG:→FinancialAccounting→SpecialPurposeLedger→

Tools →PerformDiagnosis →Troubleshooting

PostingStatistics: IMG:→FinancialAccounting→SpecialPurposeLedger→

Tools→PerformDiagnosis→Direct postingstat.

LedgerComparison: IMG:→FinancialAccounting→SpecialPurposeLedger

→Tools→CompareG/LTransactionFigureLedgerwithFI-SLLedger

Alternative toIMG for the above, fromFI-SL Application Menu: →Tools→

Diagnosis

Unit – Validations, Substitutions and Rules

1. Validation Maintenance:

IMG:→FinancialAccounting→SpecialPurposeLedger→Tools→Maintain

Validation/Substitution/Rules→MaintainValidation(Optional Simulation: →

ValidationInitialScreen→Simulate)(OptionalTraceFunctionality: →Validation

StepsEntry Screen→ Extras: Switch on/off trace)

2.Substitution Maintenance:

IMG:→FinancialAccounting→SpecialPurposeLedger→Tools→Maintain

Validation/Substitution/Rules → Maintain Substitution (Optional Simulation:

→ Substitution Initial Screen→ Simulate) (Optional Trace Functionality: →

SubstitutionStepsEntryScreen→Extras: Switchon/offtrace)

3. Rule Maintenance:

471

第 490 页 / 共 509 页

Appendix2: Appendix2 AC220

IMG:→FinancialAccounting→SpecialPurposeLedger→Tools→Maintain

Validation/Substitution/Rules→MaintainLogicalRules

2. User Exits

IMG:→FinancialAccounting→SpecialPurposeLedger→BasicSettings→

User-Exits→MaintainClientDependentUser-Exits: Enteruserexitformpool

for application area: GBLS

3. Activation Validation/Substitution

IMG:→FinancialAccounting→SpecialPurposeLedger→BasicSettings→

Validation→ Maintain Local (Global)Validation

IMG:→FinancialAccounting→SpecialPurposeLedger→BasicSettings→

Substitution→Maintain Local (Global) Substitution

Unit – Sets and Variables

1. Set Definition

IMG: → Financial Accounting → Special Purpose Ledger → Tools → Set

Maintenance→MaintainSetsAlternativefromFI-SLApplicationmenu→Tools

→ Set Maintenance → Sets

2. Set Utilities

IMG: → Financial Accounting → Special Purpose Ledger → Tools → Set

Maintenance→Sets→(Create,ChangeDisplay)→Utilities

Alternative from FI-SL - Application menu → Tools → Set Maintenance →

Utilities:

Setdirectory;Findvaluesinsets;Setusage;Graphics;Transport;Non-usedsets;

Ambiguity check

3. Variables

IMG: → Financial Accounting → Special Purpose Ledger → Tools → Set

Maintenance→MaintainVariablesAlternativefromFI-SLApplicationmenu→

Tools → Set Maintenance → Variables

4. Variable Utilities

IMG: → Financial Accounting → Special Purpose Ledger → Tools → Set

Maintenance→Variables→(Create,Change,Display)Utilities

Alternative from FI-SL Application menu: → Tools → Set Maintenance →

Variables → Utilities:

Variablesdirectory; Non-used variables; Transport

Unit – Report Painter

1. Library Definition:

472

第 491 页 / 共 509 页

AC220 Appendix 2: Appendix 2

FI-SLApplicationmenu: →FinancialAccounting→SpecialPurposeLedger→

Tools→ReportPainter→ReportWriter→Library→Create(Change..)

2. Report Definition:

FI-SLApplicationmenu: →FinancialAccounting→SpecialPurposeLedger→

Tools→ReportPainter→Report→Create(Change..)

3. Attaching a Report to a Report Group

Alternative one from within the Report Painter definition: → Environment →

Assign report group

Alternativetwo: FI-SLApplication: →Tools→ReportPainter→ReportWriter

→ Report Group → Create (Change..)

3. Executing a Report Group

AlternativeonefromwithintheReportPainterdefinition: →Report→Execute

Alternativetwo: FI-SLApplication: →Tools→ReportPainter→ReportWriter

→ Report Group → Execute

Unit - Planning

1. Plan Versions

IMG: → Financial Accounting → Special Purpose Ledger → Planning →

Maintain Plan Versions

2. Version Parameters

IMG:→FinancialAccounting→SpecialPurposeLedger→Planning→Version

Parameters→MaintainLocal(Global)VersionParameters

3. Plan Periods

IMG:→FinancialAccounting→SpecialPurposeLedger→Planning→Plan

Periods→MaintainLocal(Global) Plan Periods

4. Distribution Keys

IMG: → Financial Accounting → Special Purpose Ledger → Planning →

Maintain Distribution Keys

5. Exchange Rates

IMG:→GlobalSettings→Currencies→Checkexchangeratetype→Maintain

exchange rate spread → Define translation ratios for currency translation→

Enter exchange rates

5. Line Items

IMG: → Financial Accounting → Special Purpose Ledger → Planning →

ActivateLineItems→ActivateLocal(Global)LineItems

6. Planning Parameters

473

第 492 页 / 共 509 页

Appendix2: Appendix2 AC220

IMG: → Financial Accounting → Special Purpose Ledger → Planning →

Maintain Planning Parameters

7. Plan Entries

FI-SL Application menu: → Planning → Local (Global) planned values →

Enter/Display

8. Plan Totals Display

FI-SLApplicationmenu: →Planning→DisplayTotals

9. Plan Documents Display

FI-SLApplicationmenu: →Planning→DisplayPlandocuments

10. Copy Data to Plan

FI-SLApplicationmenu: →Planning→Copydatatoplan(Local/Global)

Unit – Allocations

1. Availability of new field for allocations:

IMG:→FinancialAccounting→SpecialPurposeLedger→PeriodicProcessing

→Allocation→MaintainFieldUsageforAssessment/Distribution

Sender/Receiver Relationship

2 IMG: → Financial Accounting → Special Purpose Ledger → Periodic

Processing→Allocation→MaintainSender/ReceiverRelationship

3. Check Allocation Settings

IMG:→FinancialAccounting→SpecialPurposeLedger→PeriodicProcessing

→ Allocation → Check Allocation Settings

4. Allocation Cycle Definition

FI-SLApplicationmenu: →PeriodicProcessing→Allocation→Actual/Planned

assessment(Actual/Planneddistribution)→Create(Change..)

5. Allocation Cycle Execution

FI-SLApplicationmenu: →PeriodicProcessing→Allocation→Actual/Planned

assessment (Actual/Planneddistribution)→Execute

6 - Display Allocated Totals

FI-SLApplicationmenu: →ActualPosting→Displaytotals(recordtype2or3)

Unit – Rollups

1. Field Movements :

IMG:→FinancialAccounting→SpecialPurposeLedger→PeriodicProcessing

→ Rollup → Maintain Field Movements

2. Substitution Activity :

474

第 493 页 / 共 509 页

AC220 Appendix 2: Appendix 2

IMG:→FinancialAccounting→SpecialPurposeLedger→PeriodicProcessing

→ Rollup → Maintain Substitution

3. Rollup Definition:

FI-SLApplicationmenu: →FinancialAccounting→SpecialPurposeLedger→

PeriodicProcessing→Rollup→Create(Change..)

4. Rollup Execution:

FI-SLApplicationmenu: →FinancialAccounting→SpecialPurposeLedger→

Periodic Processing → Rollup → Execute

5. Rollup Reverse:

FI-SLApplicationmenu: →FinancialAccounting→SpecialPurposeLedger→

Periodic Processing → Rollup → Reverse

GLOSSARY

Activity: Each SAP application or external system, which sends data to the

IntegrationManager,transfersthedataintotheFI-SLSystemwithacorresponding

activity. AnactivityclassifieseachsourceofdatasenttotheIntegrationManager

andgroupstogetherdatathatistobeprocessedthesameway.

With Release 3.0, common activities, such as all MM activities, are grouped

togethersothatitisnolongernecessaryforyoutoassignaspecificactivitytoa

ledger. You simply assign the activity group code to a ledger and the system

automatically assignsthe relevant activities.

Actual Posting: Data can enter the FI-SL System through three different

mediums:

·fromotherSAPSystems, suchasFI,MM,CO,andSD

· directly, using FI-SL’s document entry function (for example, when posting

correction documents)

· from external systems (for non-FI-SL data)

Allocation: FI-SL’sallocationpackageallowsyoutoallocatedifferentamounts

fromonesourcetomanyothersources,dependingonyourindividualneeds.

The two main types of allocations are:

Assessments: Enablesyoutoaccumulateamountsorquantitiesforallaccountsof

thesendingobjectandsummarizethemintoanassessmentaccount. Thesystem

only debits and credits the assessment account.

Distributions: Enablesyoutoallocatetheoriginalbalance(s)fromthesender(s)

to the receivers. You can allocate both the plan and actual data using the

assessment and distribution allocation types.

You can allocate:

475

第 494 页 / 共 509 页

Appendix2: Appendix2 AC220

· fixed amounts: Allocate specific fixed amounts to each receiving unit,

independent of the amount in thesending unit.

· fixed percentages: Allocatespecific fixed percentagestoeachreceivingunit,

basedontheamountorquantitythatthesendingunitallocates.

·dynamicallocations: Allocateapercentageamounttoeachreceivingunit,based

onapercentageoftheamountinthereceivingunit’soriginaldatabaserecords.

You can allocate to specific values and/or use sets to allocate amounts. Sets

areeasytocreateandmaintain, soyouhavemoreflexibilitywhenmaintaining

allocations on your system.

Allocationsarestoredasseparaterecordsinthedatabase. Youcanviewactualor

planneddatawithorwithouttheallocatedvalues. Whenyouviewareceiver,you

canalsodeterminewhichsendershaveallocatedthevalues.

Archiving: Enables you to transfer data from an existing database table to a

sequentialfilesuchasaUNIXfile. Youalsohavetheoptionofdeletingthedata

from your database when you archive thedata.

Average Balance Ledger: With Release 3.0, you can also create an average

balanceledger,basedonthesummarydatastoredinaspecialpurposeledger. The

averagebalanceledger automatically inheritsattributes, suchas thefiscal year

variantandtheassignedtable,ofthespecialpurposeledgertowhichitisassigned.

You can use this ledger only when creating reports using the average balance

ledgerordisplayingsummaryrecordsfromtheledger. Itisalsopossibletocreate

auserexitforpostingtothisledger. Youcandothisincaseswheretheposting

dateshouldnotbeusedtodeterminetheaveragebalance.

Balance Carry Forward:

Balancesheet account balances from the previous fiscal year to thebeginning

balance of the new year

Theprofitandlossaccountbalancefromthepreviousfiscalyeartotheretained

earnings account of the new year

Companies: YoucanuselocalcompaniesandglobalcompaniesinyourFI-SL

system. LocalcompaniesaredefinedintheFISystemandarethemostcommonly

usedcompaniesinthesystem. Youcansetupyoursystemsothatalocalcompany

directly updates a local ledger (ledger/local company assignment). Global

companiesusuallygrouptogetheroneormorelocalcompanies. Youcanassigna

localcompanytoaglobalcompanysothatthelocalcompanyupdatesaglobal

ledger(ledger/globalcompanyassignment)andalocalledger.

Control Report Tool

Youusethecontrolreporttoolwhenyouwanttodisplayand/orprintthecontents

oftheFI-SLdirectpostingtables(ATABtables). TheFI-SLdirectpostingtables

aredefined usingtheCustomizingfunctionanddeterminehowdocumentsare

posted into the FI-SL System

476

第 495 页 / 共 509 页

AC220 Appendix 2: Appendix 2

Currencies: Currenciesthatshouldbepostedtothespecialpurposeledger

Transaction currency: Is the currency in which the business transaction was

originally entered into the FI-SL System

Secondcurrency: Isthecurrencythatyouwanttostoreinyourledgerinaddition

tothetransactioncurrency(previouslyknownasthelocalcurrency)

Thirdcurrency: Isthecurrencythatyouwanttostoreinyourledgerinaddition

to the transaction currency and the second currency (previously known as the

group currency)

Youcanassigndifferentcombinationsofcurrencytypestoyourspecialpurpose

ledger. Whenyoudefinetheledger,thesystemwillpromptyouwiththepossible

currencycombinations. Whenyouinstallyoursystemdatabases,thesystemalso

promptsyoutoentercurrencyinformationforpostingdata. Forexample,youwill

needtospecifywhetheraledgershouldbepostedtousingtheitemcurrencyor

transaction currency (for FI).

Data Set Entry: Basic key figures define which value fields are displayed in

a report. For example, transaction currency, local currency, group currency,

andquantity. You can combine abasic keyfigurewithoneor moreadditional

characteristics entered in a set to create a data set entry. The set determines

additionalselectionconditions,suchastherecordtype(actualorplandata)and

theplanversion. Youenterdatasetentriesdirectlyindatasets.

InReportPainter,adatasetentryisknownasapredefinedcolumnbecauseeach

dataset entryusually representsareport column.

DataTransfer: TheFI-SLSystemprovidesyouwiththefollowingprogramsto

transfer non-FI-SL datainto theFI-SL System:

RGUREC00: Enables you to loaddata froman external source (non-SAP R/3

Enterprise)totheFI-SL System. RGUREC00isonlyanexampleprogramand

shouldbecopiedandmodifiedaccordingtoyourneedswhenyouprocesspostings.

If you changed the standard coding block delivered with your FI-SL System,

you will need to change the RGUREC00 program so that it reflects the new

dimensions that you have defined.

For information about loading data from external sources with RGUREC00,

contact a SAP consultant.

RGUREC10: Enables you to transfer data from the FI System into the FI-SL

System. Whenyoubeginthetransfer program, youcanselectthespecificdata

that you want to transfer.

RGUREC20: Enablesyou totransfer actual datafromtheCOSystem into the

FI-SLSystem. Whenyoubeginthetransferprogram,youcanselectthespecific

data that you want to transfer.

477

第 496 页 / 共 509 页

Appendix2: Appendix2 AC220

RGUREC30: Enables you to transfer actual data fromMaterialsManagement

(MM) into the FI-SL System. When you begin the transfer program, you can

select thespecificdata that you want to transfer.

RKEPCU40: EnablesyoutotransferactualdatafromSalesandDistribution(SD)

intotheFI-SLSystem. Whenyoubeginthetransferprogram,youcanselectthe

specific data that you want to transfer.

RGUREC40: EnablesyoutotransfertheopeningbalanceofCOstatisticalkey

figuresintotheFI-SLSystem. Whenyoubegintheprogram,youcanspecifythe

selectioncriteriatotransferthestatisticalkeyfiguresintotheFI-SLSystem.

Youshouldnotstarttheseprogramsindialogwhenotherusersareposting.

Diagnosis Tool

Usethediagnosistoolwhenyouwant totest your system setupand determine

howandwhereadocumentwillpostorhaspostedtotheFI-SLSystem. Youcan

thendeterminewhyaspecificdocumentisnotpostingtoaledger.

DocumentandSummaryRecordDisplay: IntheFI-SLSystem,youcandisplay:

Document data: You can display document lines stored in the FI-SL lineitem

databasesandinthelineitemdatabasesofthesourcedatabases.

Summaryrecorddata: YoucandisplayselectedsummaryrecordsfromtheFI-SL

summarydatabasesbyspecifyingkeydimensionvalues.

Fieldgroupingcode:Thecodedeterminesthedimensionsthatcanbeusedina

specialpurposeledger. Thefieldgroupingcodecontainsthedimensionsthatare

takenoverfromthesourcedatabasetableintotheFI-SLdatabasetable.

TheFI-SLSystemisdesignedtoprovidesummaryinformationfrommultiple

applicationsatalevelofdetailthatyoudefine. Usingthevarietyofmodulesthat

FI-SLprovides,youcancollect,combine,summarize,modify,andallocateactual

andplandatathatoriginatesfromotherSAPandexternalsystems.

Formulas: Withinaset,youcanuseformulastoperformcalculations.

Example:

Youcanuseaformulainasetandinstructthesystemtosubtractasetlinefrom

anothersetlinesothatthesystemcalculatesavariancecolumninareport. You

can use formulas in any basic set or data set. You cannot use formulas in a

single-dimension or multi-dimension set.

GlobalCompanyCode: Yourcompanyisataxentityandisdifferentfromthe

legalcompany. Youwanttostoremoredetailedinformationforthetaxentityas

forthelegalcompany. Youwillthendefinethelegalcompany(companycode)

in yoursystemthat willpost tothetaxentity(globalcompany code). Itisalso

possiblefor additionalinformationtopostto thetaxentity. Youcan also usea

global company code when you want to eliminate the generated revenue for a

partner company.

478

第 497 页 / 共 509 页

AC220 Appendix 2: Appendix 2

Global Ledgers

Youcanuseglobal ledgerstostoredata postedfor:

Global company codes and/or

Localcompanycodesthatareassignedtoglobalcompanycodes

Graphic navigation function allows you to graphically display relationships

between companies, ledgers, and activities. Using this function, you can also

branchintotherespectiveconfigurationsettingsandchangethemasrequired.

Indices: In addition to the primary key, which you define in the ABAP/4

Dictionarywhencreatingatable,youcanalsodefineadditionalindices(called

databaseindices)fortransparenttables. Usingindices,youcanimprovethetime

needed to accessandread your database table.

Example:

YoucandefineanindexthatisstructuredbyAccount,CostCenter,andBusiness

Area. YoucandefineanotherindexthatisstructuredbyCostCenter, Account,

and Plant.

The structure of your indices is determined by the table dimensions that you

access most often.

FI-SL’s Integration Manager receives and processes the data that enters

the FI-SL System. The Integration Manager validates, substitutes, and then

summarizesdataaccordingtouser-definedconditions.

Ledger: Eachledgerusesseveraldimensionsthatdefineasubsetofthecoding

blockofanobjecttable. Youcandefineyoursystemsothatyouhaveoneledger

foreachdatabasetablestructureand/ormorethanoneledgerpertablestructure.

AfteryouhavedefinedthemaximumcodingblockintheABAP/4Dictionary,you

definewhichdimensionswillbeusedbyeachledger.

LedgerSelection: TheFI-SLledgerselectionfacilitiesallowyoutodefinethe

exact conditions under which a ledger will be selected for posting. TheFI-SL

Integration Manager usestheseledger selectionconditionstodeterminewhich

specialpurposeledgersshouldbeselectedfor posting.

Each business transaction is posted to the FI-SL databases according to

user-defined rules.

Youmaydefineaspecialpurposeledgertobeselectedforpostingwhen:

-aparticulargroupofaccountsispartofthebusinesstransaction

-aparticulargroupofproductsisinvolvedinabusinesstransaction

- aparticular group of transaction typesisposted

479

第 498 页 / 共 509 页

Appendix2: Appendix2 AC220

Ledgerselectionconditionscanbesimpleorcomplex. Youcanuseanyfieldvalue

or field value combinationscontained inthebusinesstransactionaspartof the

rule, except for amounts or quantities.

Ledger Statistics Tool

Youusethistooltodisplaythenumberofrecordsthathavepostedforaledgeras

wellasthedatabasetablestowhichrecordshavebeenposted.

LineItemdatabase: Normally, mostofthebusinesstransactionsaffectingthe

FI-SLSystemcomefromotherSAPR/3Enterprises(forexample,transactionsfor

material purchasesor customerinvoicing). Documentsarestoredinthesource

applicationdatabasewherethedocumentsareentered. Youcanalsostorethese

documents,alongwiththedetailedtransactioninformation,inanoptionalFI-SL

line item database.

Examplesoflineitemdatabasetablestructuresaredeliveredwithyourstandard

system: GLREFA(foractualdata/localledgers)andGLREFP(forplandata/local

ledgers). These tables are only examples and must be copied for use in your

system.

LocalCompanyCode: Defined asabalanced set oflegal books. You can set

up yoursystemsothat alocalcompanycodedirectly updatesalocal ledger or

youcanassignalocalcompanycodetoaglobalcompanycodesothatthelocal

company code updates a global ledger.

Local Ledgers

Uselocalledgerstostoredatapostedforlocalcompanycodes.

MasterFiles: Foreachdimensioninthedatabasetable,youcandefinemaster

files in the ABAP/4 Data Dictionary. Master files can contain data for each

dimension that is used in a database.

The FI-SL System uses master files to:

Validateadimension usedwithin theFI-SL System

Provide text for Report Writer.

Check the values entered with direct input.

Searchforvalidcombinationsfromanintervalofvalues.

Object numbers determine how you can access the summary and line item

databasetablesthroughtheobjecttables. Theobjectnumber(receiver-ROBJNR)

pointstothevariabledimensionsdefinedinobjecttable1. Thepartnernumber

(sender-SOBJNR)alsopointstothevariabledimensionsdefinedinobjecttable

1. Thetransactionattributesnumber(COBJNR)pointstothevariabledimensions

defined in object table 2.

Variabledimensions: Thevariabledimensionsthatcanbeusedinthesummary

databasetablearedeterminedbythedimensionsdefinedinobjecttables1and2.

480

第 499 页 / 共 509 页

AC220 Appendix 2: Appendix 2

If thedimensionwas defined in object table 1:

Thevariabledimensioncanbeanobject(receiver)dimension,suchasRCNTR,

and/orapartner(sender)dimension, suchasSCNTR.Thedimensioncanbeup

to 10 characters long, of which up to the last nine characters must be defined

in object table 1.

Client, ledger, record type, version, fiscal year, object numbers

(object/partner/transaction attribute), currency key, quantity unit, debit/credit

indicator, and maximum period

Objecttables: SAP deliverstwotypesofobjecttables:

Object/Partner (Receiver/Sender): Supports 15 variable dimensions including

the local company code/global company. Two of the variable dimensions are

used for internal purposes, leaving 13-14 variable dimensions available for

customerdefinition. Thevariabledimensionsdefinedinthisobjecttablehavea

sender/receiverrelationship(forexample,receiveraccount(RACCT)andsender

account(SACCT)).Theobject/partnertable(objecttable1)contains:

Fixed dimensions: Cannot be changed

- Variable dimensions: Are the key dimensions of the coding block. These

dimensionsaredefinedinobjecttable1andcanbeusedinthesummaryandline

itemdatabasetablesasobjectdimensions(receivers)and/orpartnerdimensions

(senders). Objectandpartnerdimensionshaveadirectrelationship,wherepartner

dimensionsarethesendersofdataandobjectdimensionsarethereceiversofdata.

Example:

Account (ACCT), cost center (CNTR).

Anexampleofanobject/partnerobject tabledeliveredwithFI-SL isGLREFO

(only for local ledgers).

Report Groups:

Once you have created a report, you define a report group for the report(s).

A report group can contain one or more reports. When reports use the same

characteristics and share the same data, the data is selected faster and the

processingtimeisquicker. Thisisbecausethereportdataisselectedonlyoncefor

all the reports within a report group.

481

第 500 页 / 共 509 页

Appendix2: Appendix2 AC220

To define and execute a report group:

1. Create a report group: You define the reports that are in a report group.

The reports in a report group are always from the same library. You can

also change the text that appears on the selection screen when the report

group is processed.

2. Generatingareportgroup: Yougeneratethereportgroup. Areportgroupis

generatedsuccessfullywhentherearenoerrorsinit.

3. Selecting data for the report group: The system selects thedata that will

appear inthereportsdefinedinthereportgroup.

4. Displayingandprintingreportsinareportgroup: Thesystemeditsthedata

thathasbeenselectedforthereportgroupandpresentsthereportgroup’s

reports in the desired output media requested (online, printer, spool file,

or external file).

Ifyouarerunningareport that hasbeen changed, youonly need toregenerate

the report group and select and display the report data. You need not redefine

the report group.

ReportPainterperformsatasksimilartothatofReportWriterbutissimplerto

use. Many of the Report Writer functions are available in Report Painter, but

you need not be familiar with Report Writer concepts, such as sets, to be able

to use Report Painter.

ReportPainterusesagraphicalreportstructurethatformsthebasisofyourreport

definition and displaysthe rows and columnsasthey will appear in the report

output.

Report Writer is designed to provide you with summary information from

multipleapplications. ReportWriterselectsthedatayourequestandthenpresents

it in the format you define. Using FI-SL functionssuch as sets, variables, and

formulas, youcancreateareportthatmeetsyour needs.

Rollup: WhenyoucreateareportintheFI-SLSystem,ReportWriterreadsthe

ledgers that contain the data for your report. If the ledgers contain extensive

records,thesystemperformanceisslower. Toimprovethesystemperformance,

youcancreatearollupledgerthatcontainssummarizedandcondenseddatafrom

one or more ledgers.

Arollupledgeristhesummarizationoftheinformationfromoneormoreledgers

(sourceledgers)intoasingleledger. Eachrecordintherollupledgerisasummary

of the records in other ledgers.

A rule is a Boolean expression that you can use as a condition or check or in

another rule.

Rulesallowyoutorefer tofrequently-usedBooleanexpressionsusingtherule

name.

482

第 501 页 / 共 509 页

AC220 Appendix 2: Appendix 2

FI-SL’sIntegrationManager usesBooleanLogicto:

• Validate data

• Substitute data

• Select ledgers for posting

• Transfer substitution datato a rollup ledger

• Select report data

TheRuleManagerstorestheBooleanrulesusedtoanalyzedata. TheIntegration

ManagercallstheRuleManagertodetermineifthedataenteredshouldbeused.

IfaBooleanLogicstatementistrue,anactionistaken. Ifthestatementisfalse,

no action is taken.

Sets: UsedthroughouttheFI-SLSystemasthebuildingblocksformanyofthe

FI-SLmodules. InFI-SL,youusesetstogrouptogetherdataandtodefinedata

hierarchies. Underasetname,youcanstorespecificvaluesorrangesofvalues.

These values exist within one dimension.

Asetlinkstogetherspecificvaluesorrangesofvaluesunderasetname. These

values exist within one or more dimensions of the FI-SL coding block. A

dimensionisasinglefieldorcolumnofalogicaldatabase(table). Account,cost

center, andbusinessareaareexamplesof dimensions.

In FI-SL, you use four types of sets:

• Basicsets: Containspecificvaluessuchasaccountandcostcenternumbers

• Data sets: Contain specific key figures such as transaction and local

currency. Youcancombineabasickeyfigurewithoneormoreadditional

dimensionstocreateyour own datasetentries.

• Single-dimensionsets: Enableyoutocreateset hierarchiesbycombining

basicsetsandothersingle-dimensionsetsthatusethesamedimension

• Multidimension sets: Used to create set hierarchies with sets that use

different dimensions

YoucanusesetsandsetvaluesinotherFI-SLsystemcomponentssuchas:

• Boolean Logic formulas

• Report Writer

• Allocations

• Planning

• Rollups

• Currency translation

Set and Variable Utilities

Youcanusethesetandvariableutilitiestoobtainadditionalinformationabouta

setorvariable. Forexample,tocheckthesetandvariableusageandtotransport

sets and variables.

483

第 502 页 / 共 509 页

Appendix2: Appendix2 AC220

Displaying a Set Directory

Displaying a Variable Directory

Checking the Field and Set Value Usage

Checking the Set Usage Graphically

Displaying the Set Structure

Maintaining a Set Hierarchy

Transporting Sets

Transporting Variables

Displaying and Deleting Non-Used Sets

Displaying and Deleting Non-Used Variables

Checking for Overlapping Values

Special purpose ledgers are user-defined ledgers designed to meet specific

businessrequirementsaccordingtothedimensionsyouspecify. Specialpurpose

ledgersaretheonlytypeofledgersyoucancreateintheFI-SLSystem.

StandardLayouts: Foreachreportthatyoucreate,youassignastandardlayout.

Thislayoutdeterminesthelayoutfeaturesofthereport,suchasthelengthofarow

titleandthepageandnumericformatofdatainthereport. Thesystemassignsa

defaultstandardlayout,calledSAP,toeachreport. YoureceivetheSAPstandard

layoutwitheachR/3System. Whenyoudefineareport,youcan:

Accept theSAP standard layout for the report,

Assign adifferent standard layout tothereport, or

Revisethereportparameterssothattheparametersarespecifictothereport.

StandardledgersareconfiguredanddeliveredbySAPandarecontrolledwithin

the individual applications.

StandardledgersaredeliveredinthefollowingSAPapplications:

General Ledger Accounting (FI-GL)

Consolidation (FI-LC)

Profit Center Accounting (CO-PCA)

Reconciliation Ledger (CO-OM-CEL)

Substitutions: Substitution rules are stored in the Rule Manager; as data is

beingentered,thedataissubstitutedbytheIntegrationManager,whichcallsthe

RuleManagerwhenitsubstitutesthedata. Substitutionoccursbeforethedatais

postedtotheFI-SLdatabases. YoudefinesubstitutionrulesusingBooleanLogic.

Whenyoudefineasubstitutionrule,thesystemcheckstheruletoensurethatit

is syntactically correct.

484

第 503 页 / 共 509 页

AC220 Appendix 2: Appendix 2

Table Group: Refers to a group of interdependent database tables

(object/summary/actual andplan lineitemtables).

Tracing validations/substitutions/rules:

Using the Extras Switch on trace function, you activate a tracing function

that allows you to test a validation/substitution/rule definition during

the posting process. While posting a document, the system will call the

validation/substitution/ruleanddisplaytherulecontentsaswellashowthedatais

usedforvalidationorsubstitution. Thisfunctionallowsyoutodiagnosepossible

errorsinthevalidation/substitution/ruledefinition.

Youcantraceonlyonevalidationatatime,butonesubstitutionandonerulecan

also be active simultaneously. This is also true when you trace a substitution

or rule. The tracing function is only activated for the user who has turned on

the trace function.

1. Displaythevalidations/substitution/rulethatyouwanttotrace.

2. Select Extras → Switch on trace.

You cannot use the Switch on trace function for matrix validations and

substitutions.

3. 3. Inaseparatesession,callthepostingtransactionthatyouwanttotrace.

When the validation/substitution/rule is called, the system will display

theresultofthevalidation/substitution/rulethatisusedwithintheposting

transaction.

4. Toturnoffthetracingfunction,selectExtras→Switchofftrace.

TransactionAttributes: Thisobjecttablesupports15variabledimensions. The

variabledimensionsdefinedinthisobjecttablearetransactionattribute-dependent

and do not have a sender/receiver relationship. For example,controlling area

(KOKRS).Theoptionaltransactionattributestable(objecttable2)contains:

Fixed dimensions: Cannot be changed

Example: Client,objectnumberforthetransactionattributedimensions

Objectnumbersdeterminehowthesummaryandlineitemdatabasetableswillbe

accessedthroughtheobjecttables. Theobjectnumberforthetransactionattribute

dimensions are defined in object table 2.

Variabledimensions: Donothaveadirectsender/receiverrelationship. Instead,

thevariabledimensionsaretransactionattribute-dependent.

Example: The variable dimensions in object table 2 include controlling area,

movement type, and activity.

An example of a transaction attribute object table delivered with FI-SL is

GLREFC (only for local ledgers).

485

第 504 页 / 共 509 页

Appendix2: Appendix2 AC220

User-Exits: Withinfieldmovements,youcanalsoenteruserexits. Intheprevious

releases,userexitsforfieldmovementswerestoredinthefollowingprograms:

RGIFU000foruserexitsinfixedfieldmovementssuchasCurrency

RGIVUxxx (xxx= client) for user exits in user-defined fieldmovements such

as Account and Cost Center

BeginningwithRelease3.0,youcandefineyourownuserexitprograms. Ifyou

create a user exit program, the program name must be defined in the table for

client-dependentuserexits(tableT80D)inCustomizing. Formoreinformation,

seetheMaintainClient-DependentUserExitsstepintheFI-SLImplementation

Guide(IMG).IfyoudonotchangetableT80D,theexitprograms,RGIFU000and

RGIVUxxx, are used.

Usertables: Whenyoucreateormaintainasetandyoudonotenteradimension

in the Field name field when you create the set, a list of all dimensions in the

specifiedtableappearsinadialogbox. (Youenteratablenameforthesetonthe

CreateSet: InitialScreen. Youthenchooseadimensionforyourset.)

If you do not use most of the fields in a table, you can create a table subset.

Thissubset, whichyounameanddefine, containsonlythefieldsthatyouneed

for the set.

BeginningwithRelease3.0D,youcreatetablesubsetsusingviewmaintenance

inCustomizing. YounolongerneedtousetheTablemaintenancetransactionto

create your own user tables.

Forinformationaboutcreatingtablesubsets,calluptheMaintainUserTablesstep

in the FI-SL Implementation Guide (IMG).

Once you havecreated thetable subset, you can usethe table name when you

createa set. When you create aset and enter thenew tablesubset name inthe

Table field on the Create Set: Initial Screen, the dialog box displays only the

fields from your subset table.

Validations:

YoudefinevalidationrulesusingBooleanLogic. Whenyoudefineavalidation

rule,thesystemcheckstheruletoensurethatitissyntacticallycorrect.

A variableisaplaceholder for datatobespecified when you run areportthat

usesthevariable. Forexample,avariablemaybeacompany,thecurrentyear,the

current month, a date, or a user name.

You can create three types of variables:

Value: Representsaspecificvaluethatyoucanenterdirectly. Youcanusevalue

variables only in basic sets.

Formula: Representsaformulathatdeterminesavalueforthevariable. Youcan

use formula variables only in basic sets.

486

第 505 页 / 共 509 页

AC220 Appendix 2: Appendix 2

Set: Representadefinedsetandthevaluescontainedintheset. Youcanuseset

variablesinmultidimensionalsetstobeusedintherowdefinitionofyourreport

ordirectlyinthegeneralselectionofareportdefinition

Versions: Within a special purpose ledger, you can store different versions of

data. Youcanalsostoreaspecificrecordtypeperversion.

A record type can be one of the following:

• Actual data

• Plan data

• Actual allocation data

• Planned allocation data

Youdefineaversionbytherecordtypeandversionnumber.

487

第 506 页 / 共 509 页

Appendix2: Appendix2 AC220

488

第 507 页 / 共 509 页

Index

A domain, 38

allocation, 328 E

assessment, 254

Expert Mode, 38

distribution, 254

Exploding Report Rows, 275

Allocation, 54

Allocations, 3, 40 F

assessment, 326 FI-SL, 84

FI-SLInformationProcessing,

B

Balance carryforward, 3, 40

FI-SL postings, 40

Basic Entries, 382

field comparison, 231

Basic Mode, 38

FIELD GROUPING CODE,

Blocking, 382

Boolean logic, 254

Field length, 46

(Boolean logic, 230

Field Movement, 386

C field movements, 389

CALLUP POINT, 237 Fields, 332

Chart of accounts, 99 Flexible Data Transfer, 103

CO line items, 37 Formula Builder, 233

Coding Block, 34 Formula Column, 293

Coding Block Field Selection, Functional Areas, 12

37 G

Company Code, 119

General ledger, 4

company codes, 96

global companies, 96

Comparison operators, 230

Global Ledgers, 96

Configuring the Ledger, 95

consolidation ledger, 4 I

control entries, 54 Integration, 37

Corporate, 99 Integration Manager, 84

Cost Centers, 84

L

Country, 99

Ledger, 287

Currency translation, 3

Ledger Selection, 117

Cycles, 330

Line Item Tables, 43

D

Line items, 326

data element, 38 Line Items, 288

Direct posting, 54 Local Ledgers, 96

Distribution Key, 289, 296 Logical operators, 230

489

第 508 页 / 共 509 页

Index AC220

M Report Writer:, 3

Management Accounting Reporting, 40

Modules, 84 Rollup, 3

Master data, 54 Rollup set: Variable Fields,

MM purchasing, 37 382

Multiset, 382 Rollups, 40

O S

Object Table, 43 Sales Order Management, 84

Operands, 230 segment, 330

Operating, 99 Sets, 254

Operating, Country, and Special Purpose Ledger, 83

Corporate Chart of Split, 348

Accounts, 98 Split Processor, 354

Operators, 230 Standard Ledgers, 4

orders/projects, 84 Subfield comparison, 231

ORGANIZATIONAL UNIT, Substitution, 215

237 Summary Table, 43

P T

P/L Account, 12 Table Group Definition, 45

Period Screen, 304 TRANSACTION

Planner Profile, 299 CURRENCY, 89

planning, 254 U

Planning, 3, 40

user-defined key, 326

Planning Layouts, 292

Posting Document, 354 V

Procurement & Inventory Validation

Management, 84 Check, 214

Profit center ledger, 4 Message, 214

Prerequisite, 214

R

Validations & Substitutions,

Reconciliation ledger, 4

231

RECORD TYPE, 87

Variant, 355

Report Painter, 3, 254

Report Writer, 54, 254, 287

490

第 509 页 / 共 509 页

Feedback

SAP AG has made every effort in the preparation of this course to ensure the

accuracy and completeness of the materials. If you have any corrections or

suggestionsforimprovement,pleaserecordthemintheappropriateplaceinthe

course evaluation.

491