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

第 91 页 / 共 411 页

AC220 Lesson: Configuring the Ledger

Solution 3: Ledger Assignments

Task:

To define FI-SL master data, select:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger→

Basic Settings → Maintain Ledger

Select Create.

1. Ledger and Assignments

Create a ledger.

Group Ledger Group Ledger

01 AA 10 J J

02 BB 11 KK

03 CC 12 LL

04 DD 13 MM

05 EE 14 NN

06 FF 15 OO

07 GG 16 PP

08 HH 17 QQ

09 I I 18 RR

Createaledger for thesummarytableZSLTABT.

Further settings: SettheindicatorsLedgerpostings, Set upbalancecarry

forward, and Maintain d/c.

Savethecurrenciestransactioncurrency, companycodecurrency(2) and

ledger currency (3) for your ledger.

Set the ledger currency to USD.

Continued on next page

Group	Ledger	Group	Ledger
01	AA	10	J J
02	BB	11	KK
03	CC	12	LL
04	DD	13	MM
05	EE	14	NN
06	FF	15	OO
07	GG	16	PP
08	HH	17	QQ
09	I I	18	RR

第 92 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

Quantities: SelectonlytheStorequantitiesindicator.

a) To define FI-SL master data, select:

SAPReferenceIMG→Financial Accounting→SpecialPurpose

Ledger→BasicSettings→MasterData→MaintainLedgers

Ledger and Assignments

Create a ledger.

Ledger: AA(BB,CC,andsoon, up toRR)

Description: Ledger for group XX

Basic settings:

Summary table: ZSLTABT

Further settings:

x Ledgerpostingsallowed Rollup allowed

xSetupbalancecarryforwardWritelineitems

x Debit/Credit Productive

Summarize

Stored currencies:

x Transaction currency

→ Define currencies

Choose:

2ndcurrency–10 Companycodecurrency

3rd currency -- 80 Ledger currency

x Company code currency

x Ledgercurrency LedgercurrencyUSD

Quantities:

x Store quantities Store add. quantity

Remember that the second quantity field was deactivated when the

tablegroupZZSLwascreated,asitwasnotneeded.

2. Ledger Versions

Continued on next page

第 93 页 / 共 411 页

AC220 Lesson: Configuring the Ledger

Defineversion1foractual andmanual plandata.

a) Ledger Versions

Defineversion1foractualandmanualplandata.

Select Versions.

Version Actual Man. Plan Description

1 x x Version 1(GXX)

Save your ledger.

3. Assign Company Code to Ledger.

Assign thecompanycodeACxxto yourledger.

ReleasethiscombinationfordirectpostingandusethefiscalyearvariantK4

(Calendar year and 4 spec. periods).

Lineitemsshouldalsobewrittenforyourcombination.

a) Assign Company Code to Ledger.

AssignthecompanycodeACxxtoyourledger.

Release this combination for direct posting and use the fiscal year

variantK4(Calendaryearand4spec. periods).

Lineitemsshouldalsobewrittenforyourcombination.

Select Assign comp.cd/comp.

Onthelowerhalfofthescreen,scrolldowntothecompanycodeACxx

and double-click it to assign it.

Create ledger: Assign company code

CoCd ACxx

Ledger AA(BB...RR)

Assignment criteria:

Blocking indicator 1

Fiscal year variant K4

x Write line items

Saveyourassignmentledger/companycode.

4. Assignmentof Activitiesand FieldMovements

To post to your ledger/companycodecombination, you need appropriate

activities.

Continued on next page

第 94 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

Create the field movement FIxx (xx = group number) for the activity FI

Postings.

The sender fields from ACCIT_GLX are HKONT, GSBER, FKBER,

ZZSPREG, and MATNR and are to be assigned to the relevant fields in

ZSLTABT.Selectthe“R”versionofthesefieldsasthereceiver.

Initially,youractivitywillonlybeusedforpostingtodirectly.

Your activity will not be set as a “required” activity but must meet the

conditions set out in the next step.

a) Assignment of ActivitiesandFieldMovements

To post to your ledger/company code combination, you need

appropriateactivities. ChoosetheactivityforFIPostings.

For thisactivity, you need anewfield movement Fixx (xx= Group

number).

ThesenderfieldsfromACCIT_GLXareHKONT,GSBER,FKBER,

ZZSPREGandMATNR,andaretobeassignedtotherelevantfields

in ZZSLT.

Initially,youractivitywillonlybeusedfordirectposting.

Youractivitywillnotbeset asarequiredactivitybut must meet the

conditions set out in the next step.

On the Create Ledger: Assign Company Code screen, select

Environment, andFieldMovement→Create.

FieldMovement: FIxx(xx=group number)

FieldmovementFIxx FIpostingsforGroupXX

Receiver table ZSLTABT

SendertableACCHDACCIT_GLXACCCR

Select the following combinations:

Receiverfield Sendertable Senderfield

RACCT ACCIT_GLX HKONT

RBUSA ACCIT_GLX GSBER

RFAREA ACCIT_GLX FKBER

RMATNR ACCIT_GLX MATNR

RZZREGION ACCIT_GLX ZZSPREG

Continued on next page

Receiverfield	Sendertable	Senderfield
RACCT	ACCIT_GLX	HKONT
RBUSA	ACCIT_GLX	GSBER
RFAREA	ACCIT_GLX	FKBER
RMATNR	ACCIT_GLX	MATNR
RZZREGION	ACCIT_GLX	ZZSPREG

第 95 页 / 共 411 页

AC220 Lesson: Configuring the Ledger

SelectProposal to have the system display a list of sender/receiver

combinationsfromwhichyoucanselecttherequiredcombinationsand

transfer them to your field movement.

Save your field movement.

GobacktotheCreateLedger: AssignCompanyCodescreen.

PositionthecursoronyourcompanycodeandselectAssignactivity.

SelecttheactivityRFBUandthepostingindicator1.

Enter the following:

XFinancialAccountingFIxx(xx=groupnumber)

Hint: You do not need to select line items for your field

movementbecauseyouhavealreadymadethissettingforthe

combination ledger/company code.

5. Ledger Selection

Yourledger/companycodecombinationwillonlyreceiveFIpostingsthat

fulfil the following conditions:

OnlytheicecreamproductsT-IC-F1001toT-IC-F1003, andT-IC-R0007

toT-IC-R0009forrevenueaccounts810200-810400areposted. Onlythe

expense accounts are considered for the functional areas, such as sales

Continued on next page

第 96 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

anddistribution, administration, andresearch anddevelopment. Therule

SELREG1 has been set up in the system for this purpose. Enter this as

&SELREG1 in theledger selectionandsave.

a) Ledger Selection

Yourledger/companycodecombinationwillonlyreceiveFIpostings

that fulfil the following conditions:

Only the ice cream products T-IC-F1001 to T-IC-F1003, and

T-IC-R0007toT-IC-R0009forrevenueaccounts810200-810400are

posted. Onlytheexpenseaccounts areconsideredfor thefunctional

areas,suchassalesanddistribution,administration,andresearchand

development.

TheruleSELREG1hasbeensetupinthesystemforthispurpose.

OntheAssignActivityscreen, selectthelinewiththeactivityRFBU

anddeactivatetheRequired Posting setting.

Save your settings.

The following message appears:

Check the selection conditions

PositionyourcursorontheactivityRFBUandselectLedgerselection.

Choose Enter.

DeletetheconditionFalseandentertheselectionrule&SELREG1.

Save your entries.

第 97 页 / 共 411 页

AC220 Lesson: Configuring the Ledger

Lesson Summary

You should now be able to:

• Describetheprocedureto configure aledger

• Explaintheconceptsofcompanycode,company,ledger,activity,andfield

movement

第 98 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

Lesson: Line Items and Customizing Tools

Lesson Overview

Thislessondescribeslineitems. Italsodescribesthetoolstocheckyoursetup.

Lesson Objectives

After completingthislesson, you will beable to:

• Explain line items

• Use the tools to check your set up

Business Example

Yourcompanyhasamanagementreportingrequirement. Mostoftheinformation

required is obtained from other application areas but must be regrouped and

further enhanced. In some cases, the information must be refined to provide

summarizeddatainchosencombinations. Themanagementalsorequiresafield

(characteristic)calledSpecialRegion,whichcanbeusedtoprovideanadditional

geographical breakdown incertain financial reports. Thisfield (characteristic)

mustbecreatedbecauseithasnotbeendeliveredbySAP.Afterthecharacteristics

andkeyfigureshavebeensorted logicallyinto groupsfortherequiredreports,

databasetablesmustbegeneratedandinstalledforthevariousFI-SLcomponents

beforetheycanbemadeavailableforupdatingandreporting.

Using your newly created field and reporting database, define the actual

organizationalstructureofFI-SL.Inaddition,basedontheamountofinformation

required,wewilldetermineatwhatlevelintheorganizationalstructurelineitem

records should be available. Before postings are made, the tools provided by

FI-SL will be used to check the settings .

第 99 页 / 共 411 页

AC220 Lesson: Line Items and Customizing Tools

Ledger Selection

Figure 56: Ledger Selection

Bycombiningspecificconditionswithyouractivities,youcandefinethecriteria

accordingtowhichyour ledgersareselectedforupdate.

Therulesyouusetodefinevalidationsandsubstitutionscanalsobeusedtodefine

the ledger selection conditions.

Exampleforaledgerselectionruletolimitcertainproductsforarevenueaccount:

• (<ACCIT>$MATNR>=’1111’AND<ACCIT>$MATNR<=’1999’)

• <ACCIT> $HKONT = ’800000‘

– IftheMaterialnumberenteredintheaccountingdocumentisbetween

1111and1999andtheaccountnumberis800000.

第 100 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

Updating Line Items

Figure 57: Line Item Tables

LineitemscanbestoredforsummaryrecordsthatareupdatedinFI-SL.

You canupdateline itemsat thefollowing levels:

• Theledgerlevel(forallcompanycodesassignedtotheledger)

• The company code / ledger level

• The activity level

• The activity / ledger / company codelevel

Figure 58: Data Volume and Performance (Line Items)

第 101 页 / 共 411 页

AC220 Lesson: Line Items and Customizing Tools

LineitemscanbestoredforsummaryrecordsthatareupdatedinFI-SL.

Youcanupdatelineitemsat thefollowing levels:

• Theledgerlevel(forallcompanycodesassignedtotheledger)

• Company Code → Ledger

• The activity level

• The activity/ledger/company code level

If you do not need line item information for your summary records, you can

reducevolumeandperformancebottlenecksbydecidingnottosetthelineitem

indicator at any of these levels.

Figure 59: Line Item Summary

Line Item Summary with Ledger Update

Youcanchooseafunctioninledgermaintenance,whichallowsyoutosummarize

the line itemsupdated in aledger. Theitemsare summarizedaccordingto the

codingblock(user-definedfieldmovement)thatisactivewhenpostingtheitems

to the ledger. As a result, you can summarize line items, which differ only in

theiraccountassignmentsandwhicharenotrelevanttothecorrespondingledger,

into one line item.

第 102 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

Tools to Check your Set up

Figure 60: FI-SL Customizing Tools

Figure 61: Control Report

ThecontrolreportprovidesanoverviewoftheFI-SLdirectpostingtablesanda

completelogofthemostimportantcustomizingentries.

第 103 页 / 共 411 页

AC220 Lesson: Line Items and Customizing Tools

Youcancallupacompletelistofsettingsorasettingslogfor:

• a ledger/ledger interval

• aglobal company/global company interval

• a company code/company code interval

Figure 62: Diagnosis Tool: Posting Test

Usingthepostingtestfunction, youcanenteraspecificactivity tofind outthe

ledgersthathavebeenupdatedbasedonthecurrentcustomizingentries.

Youcanalsofindoutwhydatawasnotpostedtoaspecificledger. Ifnecessary,

youcangototheexactcustomizingscreen wherethechangemustbemadeso

that the ledger can be updated.

第 104 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

Figure 63: Diagnosis Tool: Posting Statistics

If you entered documents from FI, FI-SL, CO, MM, SD, and AM or from an

externalsystem,youcandisplayachecklistoftheledgersthatwereupdated.

Figure 64: Diagnosis Tool: Troubleshooting

Sometimes,oneormoreledgersarenotupdatedbyapostingactivity,althoughthe

ledgershouldbeupdated. Usingtroubleshooting, youcandeterminethecause

oftheerrorandifrequired,youcandirectlycallthecorrespondingcustomizing

transactiontoaddmissingentriesorcorrecttheentriescontainingerrors.

第 105 页 / 共 411 页

AC220 Lesson: Line Items and Customizing Tools

Figure 65: Ledger Comparison

YoucancomparethetransactiondatastoredinanyFI-SLLedger withthosein

the General Ledger.

Theselectionentriesforthecomparisonaremadeonthebasisofversion,record

type,CompanyCode,BusinessArea(s),Account(s),andDebit/Creditindicator.

The comparison period specified is for a period or a range of periods in a

particular fiscal year.

ThedetailedAccountComparisoncanbemadefor:

• G/L Account/G/L Account

• G/L Account/Corporate Account or

• G/L Account/Alternative Account

Iftherearedifferences,youcandrilldowntoaperiodoverviewofthese.

第 106 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

Figure 66: Transfer Postings

With FI-SL‘s transfer programs, you can transfer data from the FI, CO, MM,

and SD systems to the FI-SL system.

Inadditiontotheorganizationalelements(companycodeandcontrollingarea),

youenterinformation relevant for thedocuments youwantto transfer, such as

period,documentdate,postingdate,activity,anddocumentnumbers.

TargetLedger: Ifyouhaveassignedmorethanoneledgerincustomizingandare

settoFollow-uppostingbutyouonlywanttoposttooneledgerinthisrun,you

can specify one ledger as your target ledger.

IfthisledgerhasnotalreadybeenassignedinCustomizing,youwillgetanerror

message.

第 107 页 / 共 411 页

AC220 Lesson: Line Items and Customizing Tools

Appendix

Figure 67: SIMPLY PUT: Creating a Ledger (1)

Figure 68: SIMPLY PUT: Creating a Ledger (2)

第 108 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

100

第 109 页 / 共 411 页

AC220 Lesson: Line Items and Customizing Tools

Exercise 4: FI-SL Customizing Tools 1

Exercise Objectives

After completingthisexercise, youwillbeableto:

• UsetheCustomizingtoolsto check thesettings

Business Example

Beforepostingsaremade,FI-SLsettingsareusedtocheckthesettings.

Task:

Checking your Master Data Settings

To check your FI-SL master data settings:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger→

Tools

1. Display Control Report.

Display acontrolreport for yourledgersettings.

2. Perform Diagnosis: Posting Test.

Executeapostingtestforyourledgersettingsandfinancialaccounting(FI)

documents.

Enter the appropriate activity, your company code, today’s posting date,

and the current year.

Listtheledger(s)towhichthepostingswouldbemade.

Ifaparticularledger isnot listed, enterthenameof theledger underOne

ledger not postedand execute again. The system displays the reason for

not posting the ledger. Change your settings in the FI-SL master data

accordingly.

3. Additional Field Movement

Toenableenteringadjustment postingslaterinFI-SL,youmustcreatean

appropriate field movement.

IntheFI-SLmasterdata,selecttheFieldmovementoptionandthenselect

Fieldmovement→Create. DefinethefieldmovementSPxx(wherexxis

yourgroupnumber). ThereceivertableisZSLTABTandthesendertableis

GLU1.

Continued on next page

101

第 110 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

SelectProposaltochoosetheappropriatereceiverandsenderfieldsforthe

account (RACCT), business area (RBUSA), functional area (RFAREA),

specialregion(RZZREGION),andmaterialnumber(RMATNR).Saveyour

field movement.

4. Graphical Navigation

ToenableenteringadjustmentpostingsinFI-SLatalaterstage,selectthe

activity RGL0 and assign your own field movement, SPxx (where xx is

yourgroupnumber),toallowtheAccount,BusinessArea,FunctionalArea,

SpecialRegion,andMaterialNumberfieldstobeupdated.

Callthegraphicalnavigationfunctionandenteryourledgerwiththeposting

status, Direct posting. When the graphic is displayed, double-click the

activityRFBUforyourcompanycode. TheChangeLedger: AssignActivity

screen appears.

SelectChooseactivitiesanddouble-clicktheactivityRGL0.

EnteryourfieldmovementSPxx. Setthepostingindicatorto1andselect

RequiredpostingfortheactivityRGL0. SaveyourentriesandclickEXITto

returntothegraphictocheckyour newsettings.

102

第 111 页 / 共 411 页

AC220 Lesson: Line Items and Customizing Tools

Solution 4: FI-SL Customizing Tools 1

Task:

Checking your Master Data Settings

To check your FI-SL master data settings:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger→

Tools

1. Display Control Report.

Display acontrolreport for yourledgersettings.

a) Display Control Report

Displayacontrolreportforyourledgersettings.

Restricted data selection:

Fromledger: YourLedger(AA,BB,andsoon,uptoRR)

Detailing of the list

Level of detail: 4

2. Perform Diagnosis: Posting Test.

Executeapostingtestforyourledgersettingsandfinancialaccounting(FI)

documents.

Enter the appropriate activity, your company code, today’s posting date,

and the current year.

Listtheledger(s)towhichthepostingswouldbemade.

Continued on next page

103

第 112 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

Ifaparticularledger isnotlisted,enter thenameoftheledger underOne

ledgernot posted and execute again. Thesystem displays the reason for

not posting the ledger. Change your settings in the FI-SL master data

accordingly.

a) Perform Diagnosis: Posting Test

Executeapostingtestforyourledgersettingsandfinancialaccounting

(FI) documents.

Origin of original document

x Financial accounting (FI)

Posting status

x Direct posting

Select Posting test.

Diagnosis parameters:

Activity: RFBU

Companycode: YourcompanycodeACXX

Posting date: Current date

Fiscal year: Current year

Posting period: Current period

Ledgers used for the diagnosis:

x All posted ledgers

or if a ledger has not been posted

x Oneledgernot posted: Your ledger

Ifnotitemshavebeenpostedtoyourledger(2ndoption),thesystem

specifies the reason for this.

ChangeyoursettingsintheFI-SLmasterdataaccordingly.

3. Additional Field Movement

ToenableenteringadjustmentpostingslaterinFI-SL,youmustcreatean

appropriate field movement.

IntheFI-SLmasterdata,selecttheFieldmovementoptionandthenselect

Fieldmovement→Create. DefinethefieldmovementSPxx(wherexxis

yourgroupnumber). ThereceivertableisZSLTABTandthesendertableis

GLU1.

Continued on next page

104

第 113 页 / 共 411 页

AC220 Lesson: Line Items and Customizing Tools

SelectProposaltochoosetheappropriatereceiverandsenderfieldsforthe

account (RACCT), business area (RBUSA), functional area (RFAREA),

specialregion(RZZREGION),andmaterialnumber(RMATNR).Saveyour

field movement.

a) Additional Field Movement

IntheFI-SLmasterdata,createafieldmovementSPxx.

Fieldmovement: SPxx(xx=groupnumber)

FieldmovementSPxxFI-SLpostingsforgroupXX

Receiver table ZSLTABT

Sender table GLU1

ReceiverField SenderTable Sender Field

RACCT GLU1 RACCT

RBUSA GLU1 RBUSA

RFAREA GLU1 RFAREA

RMATNR GLU1 RMATNR

RZZREGION GLU1 RZZREGION

UsetheRversionforeachsenderandreceiverfield.

Save your field movement.

4. Graphical Navigation

ToenableenteringadjustmentpostingsinFI-SLatalaterstage,selectthe

activity RGL0 and assign your own field movement, SPxx (where xx is

yourgroupnumber),toallowtheAccount,BusinessArea,FunctionalArea,

SpecialRegion,andMaterialNumberfieldstobeupdated.

Callthegraphicalnavigationfunctionandenteryourledgerwiththeposting

status, Direct posting. When the graphic is displayed, double-click the

activityRFBUforyourcompanycode. TheChangeLedger: AssignActivity

screen appears.

SelectChooseactivitiesanddouble-clicktheactivityRGL0.

Continued on next page

105

ReceiverField	SenderTable	Sender Field
RACCT	GLU1	RACCT
RBUSA	GLU1	RBUSA
RFAREA	GLU1	RFAREA
RMATNR	GLU1	RMATNR
RZZREGION	GLU1	RZZREGION

第 114 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

EnteryourfieldmovementSPxx. Setthepostingindicatorto1andselect

RequiredpostingfortheactivityRGL0. SaveyourentriesandclickEXITto

returntothegraphictocheckyour newsettings.

a) Graphic Navigation

In the menu, select:

SAPReferenceIMG→Financial Accounting→SpecialPurpose

Ledger→Tools→UseGraphicNavigation

Selection of view and parameters:

x Ledger Your Ledger

Posting status:

x Direct posting

Onceyouhavemade theseentries, double-clicktheactivityRFBU,

assigntheactivityRGL0toyourledger/companycodecombination

andaddthefieldmovementSPxx(xx=yourgroupnumber).

Activity Field Movement Required

RGL0 SPxx x

Save your activity and return to the graphic navigation to check if

activity RGL0 was assigned.

106

第 115 页 / 共 411 页

AC220 Lesson: Line Items and Customizing Tools

Exercise 5: FI-SL Diagnostic Tools for

Checking Postings, Ledger Comparison

and Troubleshooting

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Check postings with diagnostic tools

• ComparetotalsrecordsinanFI-SLledgerwiththoseinthegeneralledger

• Troubleshoot records that are not posted

Business Example

SeveraldiagnostictoolsareavailableinFI-SLtohelpyoucheckpostings. You

can use these tools to check whether or not your master data settings for the

postingarecorrect. Ifthepostingsarenotcorrect,youcandeterminethesettings

that must be changed.

Task:

To open the diagnostics:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger→

Tools → Perform Diagnosis

1. Diagnosis Tool: Direct Posting Statistic:

Check the ledgerstowhichitemswereposted.

2. Ledger Comparison

In the menu, select:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger

→ Tools → Compare Ledgers

CheckthepostingsyoumadetoyourledgerinFI for yourcompanycode

inthecurrentperiodandfiscalyearwiththepostingsmadetothegeneral

ledger. Notedown the differences, if any.

Base ledger selection data:

Ledger: 0

Version: 1

Your company code

Current fiscal year and period

Continued on next page

107

第 116 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

Comparison ledger: Your ledger and version1

Accounts to check:

140000

420000,421000,430000,431000,472000,476000

810200, 810300, 810400

399999

Note downanydifferences andtheir causes:

Acct. Amount Amount in Reasonfor difference

No. (your G/L

ledger)

3. Troubleshooting

InFI-SLCustomizing(masterdatamaintenance),selectyourledgerandset

the indicator for the assignment to your company code to 0 (blocked for

posting). Save your entries.

Executeageneralledgeraccountpostingforyourcompanycode:

PK Ac- Tax Code Amount Cost Center

count

40 476500 V0 5000 T-A20EXX (XX =

Group no.)

50 399999 V0 5000

Write down your FI document number:

FI document number: _________________

Use the FI-SLPosting statistics diagnostics tool to view the ledger(s) to

which postings have been made.

Ifyourledgerisnotlisted,carryouttheFI-SLTroubleshootingdiagnostic.

Read the system message, call FI-SL Customizing, and select 1 for the

blockingindicatorforledger/companycodeassignment. Saveyourentries.

4. Transfer Posting

Continued on next page

108

Acct. No.	Amount (your ledger)	Amount in G/L	Reasonfor difference

第 117 页 / 共 411 页

AC220 Lesson: Line Items and Customizing Tools

Setthepostingindicatorto3(postingonlineandatsubsequentpossible)for

theactivityRFBU,whichyouhavechosenforyourledger/companycode

combination.

Performapostingtest (subsequent posting) foranRFBUposting toyour

companycodeforthecurrent period/fiscal year.

Execute the transfer posting first as a test run and then as an update

run. Enter the FI document number you wrote down in exercise FI-SL

Customizing Tools 1.

On the menu, select:

SAPEasyAccess→FinancialAccounting→SpecialPurposeLedger→

PeriodicProcessing→DataTransfer→FinancialAccounting

Select: Your company code

Current fiscal year and period

Activity RFBU

Document origin: BKPF

Target ledger: Your ledger (AA...RR)

After you perform the transfer posting, check the result using the FI-SL

document display.

109

第 118 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

Solution 5: FI-SL Diagnostic Tools for

Checking Postings, Ledger Comparison

and Troubleshooting

Task:

To open the diagnostics:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger→

Tools → Perform Diagnosis

1. DiagnosisTool: Direct Posting Statistic:

Check the ledgerstowhichitemswereposted.

a) Diagnosistool: Direct posting statistic:

Check the ledgers posted for:

Origin of original document:

X Financial accounting

Posting status

X Direct posting

Select Direct posting stat.

Document number: xxxxx

Fiscal year: Current year

Companycode: Your company codeACXX

2. Ledger Comparison

In the menu, select:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger

→ Tools → Compare Ledgers

Checkthepostingsyoumadetoyourledger inFI foryour companycode

inthecurrentperiodandfiscalyear withthepostingsmadetothegeneral

ledger. Note down the differences, if any.

Base ledger selection data:

Ledger: 0

Version: 1

Your company code

Current fiscal year and period

Continued on next page

110

第 119 页 / 共 411 页

AC220 Lesson: Line Items and Customizing Tools

Comparison ledger: Your ledger and version1

Accounts to check:

140000

420000,421000,430000,431000,472000,476000

810200, 810300, 810400

399999

Notedown anydifferences and their causes:

Acct. Amount Amount in Reasonfordifference

No. (your G/L

ledger)

a) Ledger Comparison

In the menu, select:

SAPReferenceIMG →Financial Accounting→SpecialPurpose

Ledger →Tools →CompareLedgers

Check the postings you made to your ledger earlier in FI for your

companycodeinthecurrentperiodandfiscalyearwiththepostings

madetothegeneralledger. Notedownanydifferences.

Base ledger selection data:

Ledger: 0

Version: 1

Your company code

Current fiscal year and period

Comparisonledger: Yourledger andversion1

Accounts to check

140000

420000,421000,430000,431000,472000,476000

810200, 810300, 810400

399999

Continued on next page

111

Acct. No.	Amount (your ledger)	Amount in G/L	Reasonfordifference

第 120 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

Note downanydifferencesandtheir causes:

Acct. Amount Amount in Reasonfordifference

No. (your G/L

ledger)

140000 Not planned for the ledger

399999 selection rule active for

the activity RFBU, which

was selected for your

ledger/company code

combination

Option:

4xxxxx Possibly used in the wrong

8xxxxx combination with functional

area/materialnumber

3. Troubleshooting

InFI-SLCustomizing(masterdatamaintenance),selectyourledgerandset

the indicator for the assignment to your company code to 0 (blocked for

posting). Save your entries.

Executeageneralledgeraccountpostingforyourcompanycode:

PK Ac- Tax Code Amount Cost Center

count

40 476500 V0 5000 T-A20EXX (XX =

Group no.)

50 399999 V0 5000

Write down your FI document number:

FI document number: _________________

Use the FI-SLPosting statistics diagnostics tool to view the ledger(s) to

which postings have been made.

Ifyourledgerisnotlisted,carryouttheFI-SLTroubleshootingdiagnostic.

Continued on next page

112

Acct. No.	Amount (your ledger)	Amount in G/L	Reasonfordifference
140000 399999			Not planned for the ledger selection rule active for the activity RFBU, which was selected for your ledger/company code combination
Option:
4xxxxx 8xxxxx			Possibly used in the wrong combination with functional area/materialnumber

第 121 页 / 共 411 页

AC220 Lesson: Line Items and Customizing Tools

Read the system message, call FI-SL Customizing, and select 1 for the

blockingindicatorforledger/companycodeassignment. Saveyourentries.

a) Troubleshooting

In the menu, select:

SAP Easy Access → AC220:Group → IMG → Edit Project SAP

ReferenceIMG→FinancialAccounting→SpecialPurposeLedger

→ Tools → Perform Diagnosis

Origin of original document:

Financial Accounting

Posting status:

Direct posting

Select Troubleshooting.

FI document number: xxxxx

Companycode: Your companycodeAcxx

Fiscal year: Current year

Ledger: Your ledger

Message:

Thecombinationledger(yourledger)/companycodeACXXisblocked.

Delete this assignment.

SelectExecute,settheblockingindicatorto1andsaveyourentries.

4. Transfer Posting

Setthepostingindicatorto3(postingonlineandatsubsequentpossible)for

theactivityRFBU,whichyouhavechosenforyourledger/companycode

combination.

Performapostingtest (subsequent posting) foranRFBUposting toyour

companycodeforthecurrent period/fiscal year.

Execute the transfer posting first as a test run and then as an update

run. Enter the FI document number you wrote down in exercise FI-SL

Customizing Tools 1.

On the menu, select:

SAPEasyAccess→FinancialAccounting→SpecialPurposeLedger→

PeriodicProcessing→DataTransfer→FinancialAccounting

Select: Your company code

Continued on next page

113

第 122 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

Current fiscal year and period

Activity RFBU

Document origin: BKPF

Target ledger: Your ledger (AA...RR)

After you perform the transfer posting, check the result using the FI-SL

document display.

a) Set the posting indicator to 3 (posting online and at subsequent

possible) for the activity RFBU, which you have chosen for your

ledger/company code combination.

→ Change Ledger: Assign Activity

ActivityFieldMovement PostingIndicator

RFBU FIXX 3

Performapostingtest (subsequent posting) for an RFBUposting to

yourcompanycodeforthecurrentperiod/fiscalyear.

Executethe transfer postingfirst asatestrun andthen asan update

run. EntertheFIdocumentnumberyouwrotedowninexerciseFI-SL

Customizing Tools 1.

On the menu, select:

SAPEasyAccess→FinancialAccounting→SpecialPurposeLedger

→PeriodicProcessing→DataTransfer→FinancialAccounting

Select: Your company code

Current fiscal year and period

Activity RFBU

Document origin: BKPF

Document number from exercise 1-5:

Target ledger: Your ledger (AA...RR)

Afteryouperformthetransferposting,checktheresultusingtheFI-SL

document display.

114

第 123 页 / 共 411 页

AC220 Lesson: Line Items and Customizing Tools

Lesson Summary

You should now be able to:

• Explain line items

• Use the tools to check your set up

115

第 124 页 / 共 411 页

UnitSummary AC220

Unit Summary

You should now be able to:

• Transferdatatoandorganizedatainspecialpurposeledger

• Explainparallelledgerupdateandledgermasterdata

• Describetheprocedureto configurea ledger

• Explaintheconceptsofcompanycode,company,ledger,activity,andfield

movement

• Explain line items

• Use the tools to check your set up

116

第 125 页 / 共 411 页

AC220 Test Your Knowledge

Test Your Knowledge

1. The system groups together the various accounting transactions into

Fillintheblankstocompletethesentence.

2. The Cost Accounting modules transmit relevant data about costs on cost

centers or profit centers.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

3. Howmany versionscaneachrecordtypehave?

Choosethecorrectanswer(s).

□ A 99

□ B 999

□ C 9

□ D 9999

4. Thesmallestorganizationalunitinexternalaccountingforwhichacomplete

self-containedsetofaccountscanbedrawnupforthepurposesofexternal

reporting isa .

Fillintheblankstocompletethesentence.

5. The individual activities from other applications are combined into

Fillintheblankstocompletethesentence.

6. Whatarethetwotypesofspecialpurposeledger?

7. The providesanoverviewoftheFI-SLdirect

postingtablesandacompletelogofthemostimportantcustomizingentries.

Fillintheblankstocompletethesentence.

117

第 126 页 / 共 411 页

TestYourKnowledge AC220

8. Youcanchooseafunctionin ,which

allowsyoutosummarizethelineitemsupdatedinaledger.

Fillintheblankstocompletethesentence.

118

第 127 页 / 共 411 页

AC220 Test Your Knowledge

Answers

1. The system groups together the various accounting transactions into

ACTIVITIES.

Answer: ACTIVITIES

2. The Cost Accounting modules transmit relevant data about costs on cost

centers or profit centers.

Answer: False

TheCostAccountingmodules(CO) transmitrelevant dataaboutcostson

costcenters(CO-CCA)ororders/projects(CO-OPA).

3. Howmany versionscaneachrecordtypehave?

Answer: B

Each recordtype can haveupto 999versions.

4. Thesmallestorganizationalunitinexternalaccountingforwhichacomplete

self-containedsetofaccountscanbedrawnupforthepurposesofexternal

reporting is a company code.

Answer: company code

5. Theindividualactivitiesfromotherapplicationsarecombinedintoactivity

groups.

Answer: activity groups

6. Whatarethetwotypesofspecialpurposeledger?

Answer: Therearetwotypesofspecialpurposeledgers:

• Localledger: UsestheorganizationalunitCOMPANYCODE

• Globalledger: UsestheorganizationalunitCOMPANYID.

7. ThecontrolreportprovidesanoverviewoftheFI-SLdirectpostingtables

andacompletelogofthemostimportantcustomizingentries.

Answer: control report

119

第 128 页 / 共 411 页

TestYourKnowledge AC220

8. You can choose a function in ledger maintenance, which allows you to

summarizetheline itemsupdatedin aledger.

Answer: ledger maintenance

120

第 129 页 / 共 411 页

Unit 4

Direct Postings and Adjustments

Unit Overview

Thisunitwillexplaintheprocedureof postingthroughandmakingadjustment

postings to the ledgers. The unit will help consolidate your knowledge of

the settings gained in the previous unit and test the postings using the FI-SL

Customizing tools.

Unit Objectives

After completing thisunit, you will beableto:

• Set upmaster datafor characteristicsusedforpostingsandusetheFI-SL

direct entry function

• Create auser table for FI-SL applications

• CallanddisplaylineitemsandsummaryrecordsinFI-SL

Unit Contents

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

Exercise 6: FI Postings....................................................137

Exercise 7: Adjustment Postings in FI-SL Document and Display of

Totals Records..............................................................149

121

第 130 页 / 共 411 页

Unit4: DirectPostingsandAdjustments AC220

Lesson: Adjustment Postings in FI-SL

Lesson Overview

This lesson explains how to set up master data for the characteristics used for

postingsintheFI-SLsystem. ThelessonwillcoverhowtousetheFI-SLdirect

entry function. In addition, the lesson discusses how to create a user table for

FI-SL applications. Thelessonalsoexplainshowtocallanddisplaylineitems

and summary records in FI-SL.

Lesson Objectives

After completingthislesson, you will beable to:

• Setupmaster datafor characteristicsused for postingsandusetheFI-SL

direct entry function

• Createa user table for FI-SL applications

• CallanddisplaylineitemsandsummaryrecordsinFI-SL

Business Example

YourCompanyhasafairlyrichmanagementreportingrequirement. Mostofthe

informationneededcomesfrom other application areasbut must beregrouped

andfurtherenhanced. Insomecases,theinformationmustberefinedtoprovide

summarizeddatainchosencombinations. Themanagementalsorequiresafield

(characteristic)calledSpecialRegion,whichcanbeusedtoprovideanadditional

geographicalbreakdownincertainfinancialreports. Thisfield(characteristic)has

beencreatedbecauseitwasnotdeliveredbySAP.Yousometimesneedtomake

adjustmentpostingsinFI-SLforspecialregions,toadjustrevenuesforproducts

thathavebeenevaluatedasstandard. Youneedtoanalyzethedirectentryfunction

in FI-SL for this purpose.

122

第 131 页 / 共 411 页

AC220 Lesson: Adjustment Postings in FI-SL

Overview and Example of FI-SL

Figure 69: ThroughPostings and Adjustments: Overview

Figure 70: FI-SL Update Example

This exampledemonstrates how data from a general ledger account posting is

updated in a FI-SL summary table.

123

第 132 页 / 共 411 页

Unit4: DirectPostingsandAdjustments AC220

Adjustment Postings and Entering Documents

Figure 71: Adjustment Postings in FI-SL

MostdataenterstheFI-SLthroughtheintegrationinterface.

You may want to enter a document directly in FI-SL for one of the following

reasons:

You want to post a document only in FI-SL.

YouwanttopostadocumentindifferentFI-SLversions. Thepostingsmadefrom

theapplicationmodulesFI,SD,andMMautomaticallyreceiveFI-SLversion1. If

youenterdocumentsdirectlyinFI-SL,youcanuseotherversions.

Youwanttomanuallyentertheamountsfortheadditionalcurrency,suchasledger

currency. IfanadditionalcurrencythatismanuallyenteredinFI-SLisidenticalto

theadditionalcurrencyoftheledgertowhichtheamountisposted,theamountis

posteddirectly. Noautomatictranslationoccursinthiscase.

You want to post only statistical quantities.

124

第 133 页 / 共 411 页

AC220 Lesson: Adjustment Postings in FI-SL

Figure 72: Entering Documents: Document Header 1

Thedocument headercontainsinformationthatappliestotheentiredocument.

You must make the following entries:

• Company code (Company ID)

• Documenttype: Thedocumenttypecontrolsthefollowingfunctions:

– Document number assignment

– Internal or external number assignment

– Currenciesallowed for document entry

– Entry of actual or plan data

– Checkwhetherthedocumentbalanceiszeroduringdocumententry

• Version: Inthisfield,youentertheFI-SLversionthatyouwanttousefor

the document.

• User table: Since this posting will update several ledgers and possibly

severalsummaryrecordtables, thesystemproposestheGLU1table. The

tablecontainsallthevariablefieldsinFI-SL.YoucanalsoenteranFI-SL

table, suchasGLFUNCT, or auser tablefromT883S.Theuser tableisa

special view of the FI-SL characteristics.

• TargetLedger: IfyouhaveassignedmorethanoneledgerinCustomizing

butwanttoposttoonlyoneledgerduringthispostingrun,youcanspecify

yourtargetledger. IftheledgerisnotalreadyassignedinCustomizing,you

will get an error message.

125

第 134 页 / 共 411 页

Unit4: DirectPostingsandAdjustments AC220

Figure 73: Document Types for FI-SL Transactions

The document type is a two-character alphanumeric key used to control how

the document is read.

Eachdocumenttypeisassignedtoadocumenttypegroup.

Thesystemassignsanumber rangesfor thesegroups.

The number assignment takes place separately for local documents and global

documents.

Youmustspecifyacompanycode(subobject)forlocaldocuments. Thedocument

type,suchasP0,andnumberassignmentmustbevalidforthecompanycode.

Thesubobjectforglobaldocumentsisaglobalcompany.

Whenmaintainingthenumberranges,youhavethefollowingoptions:

• Maintainintervals: Createandchangethenumberranges

• Changestatus: Aspecificchangetothenumberrangestatus

• Insert or delete the year

126

第 135 页 / 共 411 页

AC220 Lesson: Adjustment Postings in FI-SL

Figure 74: Versions

Foreachrecordtype,plan,actualandallocatedactualandplanyoucanuseupto

999 versions

Youcan,forexample,usealternativeplans. Thesecanbecompletealternatives

(fullychangedcopies)ordeltaversions. Adeltaversionbuildssimpleadjustments

toanoriginalbaseversionandbothtotaledtogetherdeliverthenewvariant

Alternativeversionsareusedmainlyinplanningorforallocations

Postingsarisingfromtheothersystemsthroughintegrationarealwaysinversion1.

Adjustmentpostingscanbemadeonthisbasicversionatalevelthatgoesbeyond

the legal entity (company code) appropriate. For example, for subgroups or

preconsolidated results.

127

第 136 页 / 共 411 页

Unit4: DirectPostingsandAdjustments AC220

Figure 75: User Table

InsteadofhavingtouseorremembertheoriginaldatabasetablesforcertainFI-SL

applications,suchasdirectdataentryandsummaryview,“youcancutthesedown

tosize”bycreatingaUserTablethatlistsjustthosefieldsyouneedtoseeorenter

valuesforinaparticularsequenceandusethisViewforthespecifictransaction.

Thisreducesentrytime,minimizeserrorsinchoosingwrongfields,andprovides

you with a comfortable overviewof just the information you need to carry on

with your processing.

128

第 137 页 / 共 411 页

AC220 Lesson: Adjustment Postings in FI-SL

Figure 76: Entering Documents: Document Header 2

Youcanenteracurrencyinadditiontothetransactioncurrency.

Youcanalsospecifyaunitofmeasureandanadditionalunitofmeasure.

Theperiodsfortheledgerupdatearedeterminedfromthepostingdate.

Youcanalsoenterdataforaspecialperiod. Ifyouwanttoposttoaspecialperiod,

thepostingdatemustbeinthelastnormalperiodofthefiscalyear.

Youcanspecifyatranslationdatetodetermineaspecificexchangeratefromthe

exchangeratetable. Thedefaultvalueisthepostingdate.

Ifrequired,enteraledgerformasterdatavalidation. Thesystemusestheledger

you enter to determine which chart of accounts is used to validate the master

data, especiallytheAccountdimension. Thechart ofaccountsisdefinedatthe

ledger/companycodelevelorattheledger/globalcompanylevel. Ifyoudonot

enteraledger,thesystemusesthechartofaccountsofthelocalcompanycode.

For global ledgers, thesystem usesthechart of accountsof thecompany code

assigned to the global company.

129

Group	Ledger	Group	Ledger
01	AA	10	J J
02	BB	11	KK
03	CC	12	LL
04	DD	13	MM
05	EE	14	NN
06	FF	15	OO
07	GG	16	PP
08	HH	17	QQ
09	I I	18	RR

Group	Ledger	Group	Ledger
01	AA	10	J J
02	BB	11	KK
03	CC	12	LL
04	DD	13	MM
05	EE	14	NN
06	FF	15	OO
07	GG	16	PP
08	HH	17	QQ
09	I I	18	RR

Group	Ledger	Group	Ledger
01	AA	10	J J
02	BB	11	KK
03	CC	12	LL
04	DD	13	MM
05	EE	14	NN
06	FF	15	OO
07	GG	16	PP
08	HH	17	QQ
09	I I	18	RR