第 386 页 / 共 411 页
Appendix2: Appendix2 AC220
LOGSYSLogical
system
RMVCTTransactn
type
RASSC Trading
partner
SBUKRSPartner
compCde
SACCT Partner
account
SBUSA Send.bus.ar.
SFAREAPart.
FuncArea
TSL Tcurr.
HSL LocCurr.
KSL GrpCurr.
MSL Quantity
SGTXT Text
AU- Auto. ID
TOM
DOCTY Document
type
Plan Line Item Table GLFUNCP
Field Description Key Field Description Key
RCLNT Client X KSL01 TotalGC
GL_SIRIDRecord X ....
number
RLDNR Ledger .... KSL16 TotalGC
RRCTY Recordtype MSLVT Balc/fQty.
RVERS Version MSL01 Quantity
RYEAR Fiscalyear ....
RTCUR Currency MSL16 Quantity
RUNIT Baseunit .... SGTXT Text
DRCRK Debit/credit AUTOM Auto ID
378
©2005SAPAG.Allrightsreserved. 2005/Q2
第 387 页 / 共 411 页
AC220 Appendix 2: Appendix 2
RPMAX Periode DOCTY Document
type
DOCCT Document ACTIV FI-SLactivity
cat.
DOCNR Document BUDAT Postingdate
number
DOCLN Document WSDAT Valuedate
line
RBUKRS Company REF- Document
Code DOCNR number
RACCT Account RE- Fiscalyear
number FRYEAR
RBUSA Business REFDO- Position
area CLN
RFAREA Functional REF- Documentcat.
area DOCCT
OCLNT Original REFAC- FI-SLactivity
client TIV
LOGSYS Logical CPUDT Enteredon
system
RMVCT Transactn CPUTM Enteredat
type
RASSC Trading USNAM
partner
SBUKRS Partner AWTYP Ref.
compCde procedure
SACCT Partner AWORG Referenc
account org.units
SBUSA Send.bus.ar.
SFAREA Part.
FuncArea
TSLVT Balc/fTC
TSL01 TotalTC
....
TSL16 TotalTC
HSLVT Bal
HSL01 TotalLC
379
2005/Q2 © 2005 SAP AG. All rights reserved.
第 388 页 / 共 411 页
Appendix2: Appendix2 AC220
....
HSL16 TotalLC
KSLVT Balc/fGC KW
MENU PATHS
This is a summary sheet of the menu paths presented during the course. The
menuspathsareapproximatelyarrangedinthesequenceperformedinthecourse.
Youwillfindineachunittherespectivemenupathsusedintheimplementation
guide and in the application.
General navigation
Application menu paths:
SAP R/3 Enterprise: Accounting →Financial Accounting→Special purpose
ledger:
Functions: Planning-Actualposting–Periodicprocessing–Informationsystem
– Environment – Tools – System – Help
Implementation Guide (IMG):
SAP R/3 Enterprise: Tools – Business Engineer – Customizing – Implement
projects – SAP Reference IMG:
FinancialAccounting→SpecialPurposeLedger: →BasicSettings→Planning
→ActualPostings→PeriodicProcessing→InformationSystem→Tools
Unit –FI-SL Special Reporting Requirements:
Cost of Sales Accounting
1. Cost of Sales Reporting:Information Systems → Accounting → Financial
Accounting→Spec.PurposeLedger→Selectreport→CostofSalesReporting
→ P and L cost of sales accounting
Entries:
Ledger: 0F
Fiscal year: Current year
Period from: 001
Period to: Current period
Company code: 1000
Plan version: 0
Data source: Push button “Display Extract”
SelectExtract“P&LCurrentyeartodate”. Execute.
380
©2005SAPAG.Allrightsreserved. 2005/Q2
第 389 页 / 共 411 页
AC220 Appendix 2: Appendix 2
Drilldown to other reports:
Mark block:
Cursoron blockbegin → Edit →Select block
Cursor on block end → Edit → Select block
Goto → Call up report
Options:
1. Actual line items for table GLFUNCT
2. Period breakdown
Foreachoption,youcanthendrilldowntothedocuments.
Customizing Cost of Sales Accounting
1. Functional Areas: IMG: → Enterprise Structure → Maintain Structure →
Definition→FinancialAccounting→Maintainfunctionalarea
2. Preparecostofsalesaccounting: IMG:→FinancialAccounting→Financial
AccountingGlobalSettings→CompanyCode→Preparecostofsalesaccounting
3. Enter Substitutionstepsforthefunctionalareasandactivatethesubstitution
for the company code.
Unit – Characteristics and Key Figures
1. Coding Block
IMG:→FinancialAccounting→SpecialPurposeLedger→BasicSettings→
Maintain Coding Block
Coding Block:
→ SAP standard account assignment
→ Customer include structure
→ CI_COBL
New field: Light mode: → Add Field
Newfield: Expertmode: →Accountassignmentfield→Expertmode→Account
assignmentfield(Createdomain,createdataelementetc.)
2. Subscreen: →Subscreen: → Create→ List
3. Makinganewfieldavailablefor anFI-Posting:
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
381
2005/Q2 © 2005 SAP AG. All rights reserved.
第 390 页 / 共 411 页
Appendix2: Appendix2 AC220
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
Navigateto theother tables: Buttons below: 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: Acceptmessage“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 theFI-SL Environment
MasterData: IMG:→FinancialAccounting→SpecialPurposeLedger→Basic
Settings → Master Data
382
©2005SAPAG.Allrightsreserved. 2005/Q2
第 391 页 / 共 411 页
AC220 Appendix 2: Appendix 2
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: SAP R/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→Maintain IntegratedMasterData
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
7. Document Display
383
2005/Q2 © 2005 SAP AG. All rights reserved.
第 392 页 / 共 411 页
Appendix2: Appendix2 AC220
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→Directpostingstat.
Troubleshooting: IMG:→FinancialAccounting→SpecialPurposeLedger→
Tools→ Perform Diagnosis→ Troubleshooting
PostingStatistics: IMG:→FinancialAccounting→SpecialPurposeLedger→
Tools→PerformDiagnosis→Directpostingstat.
LedgerComparison: IMG:→FinancialAccounting→SpecialPurposeLedger
→Tools→CompareG/LTransactionFigureLedgerwithFI-SLLedger
Alternativeto IMG for the above, from FI-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
StepsEntryScreen→Extras: Switch on/offtrace)
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:
IMG:→FinancialAccounting→SpecialPurposeLedger→Tools→Maintain
Validation/Substitution/Rules→MaintainLogicalRules
384
©2005SAPAG.Allrightsreserved. 2005/Q2
第 393 页 / 共 411 页
AC220 Appendix 2: Appendix 2
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→MaintainLocal (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:
FI-SLApplicationmenu: →FinancialAccounting→SpecialPurposeLedger→
Tools→ReportPainter→ReportWriter→Library→Create(Change..)
2. Report Definition:
385
2005/Q2 © 2005 SAP AG. All rights reserved.
第 394 页 / 共 411 页
Appendix2: Appendix2 AC220
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→Maintain Local(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
IMG: → Financial Accounting → Special Purpose Ledger → Planning →
Maintain Planning Parameters
7. Plan Entries
386
©2005SAPAG.Allrightsreserved. 2005/Q2
第 395 页 / 共 411 页
AC220 Appendix 2: Appendix 2
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 :
IMG:→FinancialAccounting→SpecialPurposeLedger→PeriodicProcessing
→ Rollup → Maintain Substitution
3. Rollup Definition:
387
2005/Q2 © 2005 SAP AG. All rights reserved.
第 396 页 / 共 411 页
Appendix2: Appendix2 AC220
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 assigns the 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:
· fixed amounts: Allocate specific fixed amounts to each receiving unit,
independent of the amount in thesending unit.
388
©2005SAPAG.Allrightsreserved. 2005/Q2
第 397 页 / 共 411 页
AC220 Appendix 2: Appendix 2
·fixed percentages: Allocatespecificfixed percentagesto eachreceivingunit,
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 youarchivethedata.
Average Balance Ledger: With Release 3.0, you can also create an average
balanceledger,basedonthesummarydatastoredinaspecialpurposeledger. The
averagebalanceledger automatically inherits attributes, suchasthefiscalyear
variantandtheassignedtable,ofthespecialpurposeledgertowhichitisassigned.
You can use this ledger only when creating reports using the average balance
ledgerordisplayingsummaryrecordsfromtheledger. Itisalsopossibletocreate
auserexitforpostingtothisledger. Youcandothisincaseswheretheposting
dateshouldnotbeusedtodeterminetheaveragebalance.
Balance Carry Forward:
Balance sheet account balances from the previous fiscal year to the beginning
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
localcompanytoaglobalcompanysothatthelocal companyupdatesaglobal
ledger(ledger/globalcompanyassignment)andalocalledger.
Control Report Tool
Youusethecontrolreporttoolwhenyouwanttodisplayand/orprintthecontents
oftheFI-SLdirectpostingtables(ATABtables). TheFI-SLdirectpostingtables
aredefinedusingtheCustomizing function anddeterminehowdocumentsare
posted into the FI-SL System
Currencies: Currenciesthatshouldbepostedtothespecialpurposeledger
389
2005/Q2 © 2005 SAP AG. All rights reserved.
第 398 页 / 共 411 页
Appendix2: Appendix2 AC220
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 combinea basic keyfigurewith one or moreadditional
characteristics entered in a set to create a data set entry. The set determines
additionalselectionconditions,suchastherecordtype(actualorplandata)and
theplanversion. Youenterdatasetentriesdirectlyindatasets.
InReportPainter,adatasetentryisknownasapredefinedcolumnbecauseeach
datasetentryusually representsareport column.
DataTransfer: TheFI-SLSystemprovidesyouwiththefollowingprogramsto
transfer non-FI-SL datainto the FI-SL System:
RGUREC00: Enables you toload data fromanexternal 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. Whenyoubeginthetransferprogram, youcanselectthespecificdata
that you want to transfer.
RGUREC20: Enablesyou totransfer actual datafromtheCO Systemintothe
FI-SLSystem. Whenyoubeginthetransferprogram,youcanselectthespecific
data that you want to transfer.
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.
390
©2005SAPAG.Allrightsreserved. 2005/Q2
第 399 页 / 共 411 页
AC220 Appendix 2: Appendix 2
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
Usethediagnosistool whenyouwantto test your system setup anddetermine
howandwhereadocumentwillpostorhaspostedtotheFI-SLSystem. Youcan
thendeterminewhyaspecificdocumentisnotpostingtoaledger.
DocumentandSummaryRecordDisplay: IntheFI-SLSystem,youcandisplay:
Document data: You can display document lines stored in the FI-SL line item
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)
inyoursystemthat will post tothetaxentity(globalcompanycode). It isalso
possiblefor additional informationtopost to thetaxentity. You can also usea
global company codewhen you want to eliminate the generated revenue for a
partner company.
Global Ledgers
Youcanuseglobal ledgerstostoredata postedfor:
391
2005/Q2 © 2005 SAP AG. All rights reserved.
第 400 页 / 共 411 页
Appendix2: Appendix2 AC220
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 accessand read 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
definewhichdimensionswill beusedbyeachledger.
LedgerSelection: TheFI-SLledgerselectionfacilitiesallowyoutodefinethe
exact conditions under which a ledger will be selected for posting. The FI-SL
Integration Manager usestheseledgerselectionconditionstodeterminewhich
specialpurposeledgersshouldbeselectedfor posting.
Each business transaction is posted to the FI-SL databases according to
user-defined rules.
Youmaydefineaspecialpurposeledgertobeselectedforpostingwhen:
Youmaydefineaspecialpurposeledgertobeselectedforpostingwhen:
-aparticulargroupofaccountsispartofthebusinesstransaction
-aparticulargroupofproductsisinvolvedinabusinesstransaction
- a particular group of transaction typesisposted
Ledgerselectionconditionscanbesimpleorcomplex. Youcanuseanyfieldvalue
or field value combinationscontained inthebusinesstransactionaspartof the
rule, except for amounts or quantities.
Ledger Statistics Tool
392
©2005SAPAG.Allrightsreserved. 2005/Q2
第 401 页 / 共 411 页
AC220 Appendix 2: Appendix 2
Youusethistooltodisplaythenumberofrecordsthathavepostedforaledgeras
wellasthedatabasetablestowhichrecordshavebeenposted.
LineItemdatabase: Normally, mostofthebusinesstransactionsaffectingthe
FI-SLSystemcomefromotherSAPR/3Enterprises(forexample,transactionsfor
material purchasesorcustomerinvoicing). 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 of legal books. You canset
up your system sothat alocalcompanycodedirectlyupdatesalocal 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:
Validateadimensionusedwithin 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.
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.
393
2005/Q2 © 2005 SAP AG. All rights reserved.
第 402 页 / 共 411 页
Appendix2: Appendix2 AC220
Client, ledger, record type, version, fiscal year, object numbers
(object/partner/transaction attribute), currency key, quantity unit, debit/credit
indicator, and maximum period
Objecttables: SAPdeliverstwotypesofobjecttables:
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-SLisGLREFO
(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.
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).
394
©2005SAPAG.Allrightsreserved. 2005/Q2
第 403 页 / 共 411 页
AC220 Appendix 2: Appendix 2
If youarerunningareport that hasbeen changed, youonlyneedtoregenerate
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 columnsas they 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 functions such as sets, variables, and
formulas, youcancreateareportthatmeetsyourneeds.
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.
Rulesallowyouto refer tofrequently-usedBooleanexpressionsusingtherule
name.
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.
395
2005/Q2 © 2005 SAP AG. All rights reserved.
第 404 页 / 共 411 页
Appendix2: Appendix2 AC220
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
dimensions to createyour owndataset entries.
• 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.
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
396
©2005SAPAG.Allrightsreserved. 2005/Q2
第 405 页 / 共 411 页
AC220 Appendix 2: Appendix 2
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.
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.
397
2005/Q2 © 2005 SAP AG. All rights reserved.
第 406 页 / 共 411 页
Appendix2: Appendix2 AC220
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
theresultof thevalidation/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).
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,
398
©2005SAPAG.Allrightsreserved. 2005/Q2
第 407 页 / 共 411 页
AC220 Appendix 2: Appendix 2
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 have created the tablesubset, you can use the table name when you
createa set. When you create aset and enter thenew tablesubset name in the
Table field on the Create Set: Initial Screen, the dialog box displays only the
fields from your subset table.
Validations:
YoudefinevalidationrulesusingBooleanLogic. Whenyoudefineavalidation
rule,thesystemcheckstheruletoensurethatitissyntacticallycorrect.
Avariableisaplaceholderfor datato bespecifiedwhen you run areport that
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.
Set: Representadefinedsetandthevaluescontainedintheset. Youcanuseset
variablesinmultidimensionalsetstobeusedintherowdefinitionofyourreport
ordirectlyinthegeneralselectionofareportdefinition
Versions: Within a special purpose ledger, you can store different versions of
data. Youcanalsostoreaspecificrecordtypeperversion.
399
2005/Q2 © 2005 SAP AG. All rights reserved.
第 408 页 / 共 411 页
Appendix2: Appendix2 AC220
A record type can be one of the following:
• Actual data
• Plan data
• Actual allocation data
• Planned allocation data
Youdefineaversionbytherecordtypeandversionnumber.
400
©2005SAPAG.Allrightsreserved. 2005/Q2
第 409 页 / 共 411 页
Index
A FIELD GROUPING CODE,
allocation, 259 65
Allocation, 39 Field length, 36
Allocations, 3, 31 Field Movement, 304
assessment, 258 field movements, 306
Fields, 261
B
Flexible Data Transfer, 78
Balance carryforward, 3, 31
Formula Column, 228
Basic Mode, 29
Functional Areas, 10
Blocking, 300
G
(Boolean logic, 178
General ledger, 4
C
I
CALLUP POINT, 183
Chart of accounts, 75 Integration Manager, 64
Company Code, 93 L
Comparison operators, 178
Ledger, 224
consolidation ledger, 4
Ledger Selection, 91
control entries, 39
Line Item Tables, 33
Corporate, 75
Line items, 257
Cost Centers, 64
Line Items, 225
Country, 75
Logical operators, 178
Currency translation, 3
Cycles, 260 M
Management Accounting
D
Modules, 64
data element, 29
Master data, 39
Direct posting, 39
Distribution Key, 226, 232 O
domain, 29 Object Table, 33
Operands, 178
E
Operating, 75
Expert Mode, 29
Operators, 178
Exploding Report Rows, 215
orders/projects, 64
F ORGANIZATIONAL UNIT,
FI-SL, 64 183
FI-SLInformationProcessing, P
3
P/L Account, 11
FI-SL postings, 31
Period Screen, 237
field comparison, 179
Planner Profile, 234
401
2005/Q2 © 2005 SAP AG. All rights reserved.