AC220_EN_Col52_FV_Inst_A4 (第4页) | ERP软件技术分享

第 110 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

Solution 3: Transfer Postings

Task:

Transfer Posting

1. Setthepostingindicatorto3(postingonlineandatsubsequentpossible)for

theactivityRFBU,whichyouhavechosenforyourledger/companycode

combination.

Performapostingtest(subsequent posting) for anRFBUposting to your

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)

Continued on next page

第 111 页 / 共 509 页

AC220 Lesson: FI-SL Structure

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

ActivityFieldMovementPostingIndicator

RFBU FIXX 3

Performaposting test (subsequentposting) for anRFBUpostingto

yourcompanycodeforthecurrentperiod/fiscalyear.

Executethetransferpostingfirstasatest run andthen asanupdate

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.

第 112 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

Lesson Summary

You should now be able to:

• Transferdatatoandorganizedatainspecialpurposeledger

• Explainparallelledgerupdateandledgermasterdata

第 113 页 / 共 509 页

AC220 Lesson: Configuring the Ledger

Lesson: Configuring the Ledger

Lesson Duration: 25 Minutes

Lesson Overview

Thislessondiscussestheproceduretoconfigurealedger. Youwillalsolearnabout

theconceptsofcompanycode,company,ledger,activity,andfieldmovement.

Lesson Objectives

After completingthislesson, youwillbeable to:

• Describetheprocedureto configure aledger

• Explaintheconceptsofcompanycode,company,ledger,activity,andfield

movement

Discussindetailtheprocedureforconfiguringtheledger. Explainhowtoassigna

CompanyCode/CompanyIDstoledgers. Describeactivitiesandfieldmovements.

Business Example

YourCompanyhasafairlyrichmanagementreportingrequirement. Mostofthe

informationneededcomesfrom other application areasbutmust be regrouped

andfurtherenhanced. Insomecases,theinformationmustberefinedtoprovide

summarized data in chosen combinations.

Managementalsorequiresafield(characteristic)calledSpecial Region, which

canbeusedtoprovideanadditionalgeographicalbreakdownincertainfinancial

reports. This field (characteristic) must be created because it is not delivered

by SAP.

After thecharacteristicsandkeyfiguresaresortedlogicallyintogroupsforthe

requiredreports,youneedtogenerateandinstalldatabasetablesforthevarious

FI-SLcomponentsbeforetheycanbemadeavailableforupdateandreporting.

Usingyournewlycreatedfieldandreportingdatabase,youwilldefinetheactual

organizational structure of FI-SL.

Procedure to Configure the Ledger

Configuring the Ledger

Thisandthefollowinggraphicsshowreasonsforacompanycode/globalcompany

to choose a ledger to store data.

第 114 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

Thisgraphicdescribeshowbusinessrequirementscanbemetthroughadivision

intodifferentledgers(thatarepossiblytobeupdatedinparallel).

a/Characteristiccombinations(byassigningaledgertoatablestructure)

b/Comparisons: Versions,recordtypes,quantities,andcurrencies

c/ Period

d/ Selected activitiesandactivitiesnotpredefined

e/Ownselectioncriteria(formulatedusingtheBooleanrule)

Procedure

Themainstepsofmasterdataandtheirassignmentsareexplainedhere.

Local Ledgers and Global Ledgers

Division of the database by ledgers:

local: Company codes

global: Global companies

Figure 45: Configuring The Ledger

第 115 页 / 共 509 页

AC220 Lesson: Configuring the Ledger

Incompany-specificreporting,thecriteriatocreatethissummaryinformationcan

be diverseandcan differ in thefollowing aspects:

• Combinationsofuser-definedaccountassignments(forexample,account,

cost center, and product group)

• Comparisons(differentversionsofactualdata, plandata, allocatedactual

data,allocatedplandata,quantityupdate,andvariouscurrencies)

• Time(month,quarter,week,andnoncalendarfiscalyear)

• Selectedbusinesstransactions(forexample,generalledgeraccountpostings

foraprofitandlossstatement,revenuepostings,andgoodsmovement)and

different field movements

• Individual selection conditions

Figure 46: Procedure

TosetuptheFI-SLsystemsothatdatacanbepostedtoFI-SL:

• Assignyourcompanycode(orglobalcompany)toaledger.

• Assign therelevant activitiesto your ledger.

• Ifyouwanttolinkconditionstoactivities,youmustdefineledgerselection

conditions.

• Usingafieldmovement,definethefields(characteristics)thatyouwantto

transfer to your ledger for the activities.

第 116 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

Figure 47: Local Ledgers and Global Ledgers

Therearetwo typesof special purposeledgers:

• Localledger: UsestheorganizationalunitCOMPANYCODE.

• Globalledger: UsestheorganizationalunitCOMPANYID.

Assigning a Company Code/Company IDs to Ledgers

Operating,Country,andCorporateChartofAccounts

Explanationofthedifferences: Companycodeandglobalcompanies,thedifferent

chartofaccountsassignmentsandthepossibilitytorepresentthemseparatelyin

different ledgers

Displaycompanycode1000inthesystem, withassignmenttoglobalcompany

1000. Globalcompany1000isassignedtoledgerG0(globalledger). Theglobal

companycanbeassignedtoonecompanycode(normal)ortoncompanycode,

receives its totals through company code-relevant and/or alternatively with a

direct account assignment (activitiesRGG0 or RGG1) - standardizing entryor

adjustment posting in FI-SL.

The representation of different charts of accounts (field movement: HKONT,

LOKKT, or ALTKT (ACCIT_GLX) and currencies - local currency (Code,

countrycurrencyorgroupcurrency)canberealizedinFI-SL.

Company Code → Ledger

IllustratesthemostsignificantspecificationstobemadeattheCompanyCode/

Ledger level.

FI-SLUser-DefinedPeriodAssignmentKeyFigures

第 117 页 / 共 509 页

AC220 Lesson: Configuring the Ledger

Division in the ledger for different period totals; year, month, quarter, week,

non-calendar fiscal year, and so on.

RequiredfiscalyearvariantforthecombinationCCode(globalcompany)/Ledger

Figure48: Operating,Country,&CorporateChartofAccounts

A company code is the smallest organizational unit in external accounting for

whichacompleteself-containedsetofaccountscanbedrawnupforthepurposes

ofexternalreporting. Acompanycoderecordsallaccounting-relevanttransactions

inlocalcurrency. Inadditiontothelocalcurrency,itmayalsoberequiredthatyou

storedatainanadditionalcurrency,suchashardcurrencyorindex-basedcurrency.

The global company is the smallest organizational unit in a corporate group.

Individualfinancialstatementsforglobalcompaniescanbedrawnupaccording

totherelevant commercial law. Aglobal company canconsist of oneor more

company codes.

There are three types of charts of accounts in the SAP system. These can all

be used in FI-SL.

• Operating: Forintegrated,cross-company,standardizedclassificationofthe

operatingbusinesstransactions. Financialaccountingandcostaccounting

must use the same chart of accounts.

• Country: Todisplaytheposteddataaccordingtocountry-specificcriteria,

such as Plan de comptes (France).

• Corporate: Todisplaytheposteddataaccordingtotherequirementsofthe

external group accounting

第 118 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

Example: The German subsidiary (global company 100000) of an American

corporategroupmaintainsaAmerican-orientedchartofaccounts(corporatechart

ofaccounts)paralleltotheoperatingGermanchartofaccounts.

• ThisGermancompanyhasaplantlocatedinFrancethatisrepresentedasa

companycodeandforwhichthelocalFrenchchartofaccountsisusedasthe

country chart of accounts.

Figure 49: Company Code → Ledger

Whenassigningacompanycodetoaledger,youdefinethefollowing:

• Ifthecombinationisreleased for direct posting

• Howthepostingperiodsshouldbedetermined. Thisisdefinedbythefiscal

yearvariantselectedforthiscombination. Indoingthis,youcanmaintain

summary balances for a company code (or global company) at different

timeintervals(yearly,quarterly,monthly, andweekly)atthesametimein

several ledgers.

• Thesecondandthirdcurrencytobestoredforthiscombination,ifyouhave

notalreadydefinedthecurrenciesattheledgerlevel

• Whetherlineitemsaretobewrittenforthiscombination

100

第 119 页 / 共 509 页

AC220 Lesson: Configuring the Ledger

Figure 50: FI-SL User-Defined Period Assignment

InFI-SL,youcandefinevariousperiodsforacompanycode.

Whenassigningcompanycodestoledgers,youneedtoassignaFISCALYEAR

VARIANT to each ledger.

Thefiscalyearvariantcaneitherbethesameordifferfromthefiscalyearvariant

in financial accounting.

Thisallowsyoutosimultaneouslymaintaintotalsforacompanycodeinvarious

ledgers, for example for:

• Monthly income statements

• Weekly sales

• Quarterly results in a summarized form

Activities and Field Movements

Activities

The data from the different SAP application areas are divided into activities

according to business points of view.

IfanapplicationcallsuptheFI-SLintegrationmanager, thedataistransferred

with a corresponding activity.

The ledger selection and field assignments are carried out depending on this

activity.

Sourcesystems: MM,FI,CO, AssetAccounting, HumanCapitalManagement

through FI

Flexible Data Transfer

101

第 120 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

Collectionofsimilaraccountingtransactionsinactivitiesthatcanbechosenfor

the update of one or several ledger(s)

Activity Groups

Groupingtheactivitiesintogroups: FI,CO,MM,SD,andSLactivities

Selective Update of Characteristics

Fieldmovementallowstheusertogroupthecharacteristicstogether, whichare

jointly transferred to a ledger during through-posting or rollup execution. By

leavingoutcharacteristicsorwiththehelpofuserexits(derivationrules),youcan

further influencethelevel of detailof theupdate.

Field Movements and Summarization

Sender/receiver fieldassignments: 1:1or derivation / determination by means

of user exits.

Figure 51: Activities

You select specific “activities” (business transactions) for your ledger. Using

theFI-SL informationsystem, youcanreport on several Characteristicsacross

the company.

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

Manager,transfersthedataintotheFI-SLSystemwithacorrespondingactivity.

An activity classifies each source of data sent to the Integration Manager and

groupstogetherdatathatistobeprocessedthesameway.

102

第 121 页 / 共 509 页

AC220 Lesson: Configuring the Ledger

Figure 52: Flexible Data Transfer

ThebusinesstransactionsthatenterintoFI-SL from other SAP applicationsor

external systems are transferred to the update interface as ACTIVITIES. The

activitiesareusedtoclassifythetransferreddataintobusiness-relatedcategories.

Businesstransactionsthatareprocessedinthesamewayarecombinedintogroups.

IfanapplicationcallsuptheFI-SL integrationinterface, thedataistransferred

using the appropriate activity.

Theledgersareselectedforupdatedependingonthisactivity.

Ifyoudecidednottoupdatelineitemsattheledgerleveloratledger-company

code level, youcan dosofor specific activities.

103

第 122 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

Figure 53: Activity Groups

Theindividualactivitiesfromotherapplicationsarecombinedintoactivitygroups.

You canassigntheseactivitygroupsto yourledgers.

Commonactivities, suchasallMMactivities, aregroupedtogethersothatitis

nolongerimportantforyoutoassignaspecificactivitytoaledger. Yousimply

assigntheactivitygroupcodetoaledger andthesystemautomaticallyassigns

the relevant activities.

Figure 54: Selective Update of Characteristics

Theledger providesalogical structuretoformtotals.

Any number of ledgers can be updated with various field combinations from

one account assignment.

104

第 123 页 / 共 509 页

AC220 Lesson: Configuring the Ledger

Figure 55: Field Movements and Summarization

Inorder toobtainthelevel of detail you requireinyour summary records, you

canselectsendercharacteristicsusingafieldmovementandtransportthemtothe

receiver characteristics specifiedfor your ledger.

If a 1:1 assignment is not possible or not required, you can use an exit in the

ABAProutinetoderiveordeterminethecharacteristics.

105

第 124 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

106

第 125 页 / 共 509 页

AC220 Lesson: Configuring the Ledger

Exercise 4: Ledger Assignments

Exercise Duration: 45 Minutes

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Create a ledger

• Assign a company code to the ledger

• Create relevant field movements

• Choose the appropriate activities and assign them to the combination

’ledger/company code’

Business Example

UsethenewfieldandthetabletodefinetheorganizationalstructureofFI-SL.

Based on the information required, determine the level of the organizational

structureatwhichlineitemrecordsshouldbeavailable.

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

Continued on next page

107

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

第 126 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

Createaledgerfor thesummarytableZSLTABT.

Further settings: SettheindicatorsLedgerpostings, Set up balancecarry

forward, and Maintain d/c.

Savethecurrenciestransactioncurrency, company codecurrency(2) and

ledger currency (3) for your ledger.

Set the ledger currency to USD.

Quantities: SelectonlytheStorequantitiesindicator.

2. Ledger Versions

Defineversion1foractualandmanual plandata.

3. Assign Company Code to Ledger.

AssignthecompanycodeACxxto yourledger.

ReleasethiscombinationfordirectpostingandusethefiscalyearvariantK4

(Calendar year and 4 spec. periods).

Lineitemsshouldalsobewrittenforyourcombination.

4. Assignment of Activitiesand FieldMovements

To post to your ledger/company codecombination, you need appropriate

activities.

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.

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

anddistribution, administration, andresearch anddevelopment. Therule

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

&SELREG1 in theledger selectionandsave.

108

第 127 页 / 共 509 页

AC220 Lesson: Configuring the Ledger

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

109

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

第 128 页 / 共 509 页

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

110

第 129 页 / 共 509 页

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

111

第 130 页 / 共 509 页

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

112

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

第 131 页 / 共 509 页

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

113

第 132 页 / 共 509 页

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.

114

第 133 页 / 共 509 页

AC220 Lesson: Configuring the Ledger

Lesson Summary

You should now be able to:

• Describetheprocedureto configure aledger

• Explaintheconceptsofcompanycode,company,ledger,activity,andfield

movement

115

第 134 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

Lesson: Line Items and Customizing Tools

Lesson Duration: 30 Minutes

Lesson Overview

Thislessondescribeslineitems. Italsodescribesthetoolstocheckyoursetup.

Lesson Objectives

After completingthislesson, you will beable to:

• Explain line items

• Use the tools to check your set up

Explainledgerselection. Discusshowtoupdatelineitems. Describethetoolsto

check the 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 .

Ledger Selection

Youcanmarkoneormoreledgerswithinanactivityforarequiredposting. To

specifytherequirementfor activityupdate, youcanusetheentireinventoryof

Booleanrules. Asaresult, amoresummarizedlevelof detailcanbeachieved.

116

第 135 页 / 共 509 页

AC220 Lesson: Line Items and Customizing Tools

Forexample,fromaG/Laccountposting,onlydocumenttypesXX,accountsof

theclassxxxxxx, orcertaincombinationsofcharacteristicsaretobetakeninto

account for the update.

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.

Updating Line Items

Line Item Tables

Optional line item update at various levels.

Line Item Summary

New function in Release 4.0.

117

第 136 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

When you select this indicator, FI-SL line items are summarized according to

the characters of the coding block. If certaindocument linesfrom the original

document are only different in terms of fields that are not part of the coding

block for the corresponding ledger , then these lines are summarized into one

FI-SL line item.

Note: SummarizationdoesnottakeplaceindirectdataentryinFI-SL(GB01or

GB11) or for the entry of external data using program RGUREC00 (or copies

derived from it).

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

118

第 137 页 / 共 509 页

AC220 Lesson: Line Items and Customizing Tools

Figure 58: Data Volume and Performance (Line Items)

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.

119

第 138 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

Figure 59: Line Item Summary

Line Item Summary with Ledger Update

Youcanchooseafunctioninledgermaintenance,whichallowsyoutosummarize

the line itemsupdated in aledger. Theitems are summarized according to 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.

Demonstration: Demonstration of Ledger Assignment

Purpose

To demonstrate Ledger Assignment

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. Create a ledgerZZfor table ZSLTABT:

120

第 139 页 / 共 509 页

AC220 Lesson: Line Items and Customizing Tools

Ledger can be posted to, rollup allowed, set up balance carry forward,

managelineitems,setD/Kindicator,donotsetproductionindicator,stored

currencies: TC, 2nd C> company code-, 3rdC>Ledger currency. Enter

USDastheledgercurrency. Markthequantitiesbutdonotaddadditional

quantities.

ForledgerZZ,createversion1foractual,plan,androll-updataandversion

2 for actual data.

Then,assignthecompanycodeAC00totheledgerZZ.Releasetheledger

forthrough-postingandchoosethefiscalyearvariantK4.

Choose the transaction group, FI. Explain to the participants that a new

field movement is necessary because no field movement exists for table

ZSLTABT as receiver.

Youcan createthisfieldmovement, for example, ZZFI,inthealternative

mode:

ReceivertableZSLTABTsendertable: ACCHDACCIT_GLXassignment:

RACCT<HKONT,RBUSA<GSBER,RFAREA<FKBER,RZZREGION

< ZZSPREG, RMATNR < MATNR

Assignthisfieldmovement totheFI transactiongroupRFBUandsetthe

postingindicatorto1. Youcanmarktheactivityasrequiredactivity.

MentionthatyouwillcarryoutanFI-SLdirectpostinglaterforthecompany

code AC00 and will now definea corresponding field movement for the

company code in advance.

Branchtothefieldmovementandcreateanewone,forexample,ZZSL:

Receiver table ZSLTABT sender table: GLU1 assignment: RACCT <

RACCT, RBUSA <RBUSA, RFAREA < RFAREA, RZZREGION <

RZZREGION, RMATNR < RMATNR

ExecuteanFI GLpostingforCo.CodeAC00toexpenseaccount 430000

andCC4100 (FAREA0100) and offset postingto Account 399999 (Tax

code V0). Show the accounting documents, including the document for

your ledger, ZZ.

ExecuteanFICustomer(A/RInvoicePostingwithCo.CodeAc00: Posting

Key 01 Customer T-F00A00 Amount 1000 UNI Tax Code A1, Posting

Key 50 Account number 800200 sameamount and tax code, Busa 0001,

Material M-01.

ShowtheaccountingdocumentsandZZ lineitem.

Explainthat,accordingtothebusinessscenario,ourFI-SLsystemshouldbe

acceptingonlycertaincombinationsofexpenseaccounts(4)withFAREAS

andRevenueAccounts(8)withice-creamproducts(T-IC-FI).

121

第 140 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

Both the postings madeincludetwo superfluouslines, wrong Functional

Area0100 andwrongMaterial(Product)0100.

Youcanreversethelastposting,showingtheeffectsofthispostinginFI-SL.

Toavoidthis,youcanusealedgerselectionfortherelevantactivity. Inthis

case, the ledger selection is RFBU.

You can now show the Sel.Rule SELREG1 set up in the system,

FI-Customizing>Tools>Val/Sub/Rules>Rules,andthenincludeitforyour

activity.

Dothetwopostingsagainandshowtheresults.

Tools to Check your Set up

FI-SLCustomizingTools: ControlReport,PostingTest,InteractiveGraphic

Maintenance

The customizing tools are used in the test and implementation phases. These

toolsareusedtochecktheFI-SLsettings, tosimulatepostings, anddisplaythe

settings graphically.

Figure 60: FI-SL Customizing Tools

122

第 141 页 / 共 509 页

AC220 Lesson: Line Items and Customizing Tools

Figure 61: Control Report

ThecontrolreportprovidesanoverviewoftheFI-SLdirectpostingtablesanda

completelogofthemostimportantcustomizingentries.

Youcancallupacompletelistofsettingsorasettingslogfor:

• a ledger/ledger interval

• aglobal company/global company interval

• a company code/company code interval

Figure 62: Diagnosis Tool: Posting Test

123

第 142 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

Usingthepostingtestfunction, youcanenteraspecificactivityto findoutthe

ledgersthathavebeenupdatedbasedonthecurrentcustomizingentries.

Youcanalsofindoutwhydatawasnotpostedtoaspecificledger. Ifnecessary,

youcangototheexact customizing screenwherethechangemustbemadeso

that the ledger can be updated.

Figure 63: Interactive Graphic Maintenance

GraphicalnavigationinsomeareasofFI-SLcustomizing.

Ahierarchyconsistingofaledger,companycodeorglobalcompany,andactivity,

whichhasbeencreatedusingthenormalcustomizingfunctions,canbedisplayed

as a graphic.

Withinthegraphic,youcanclicktheindividualhierarchynodes,suchasledger

and company code. The system moves from the graphic to the customizing

transaction that correspondsto the hierarchy nodeyou clicked . Here, youcan

makeinteractivechanges,suchasassignanewcompanycodeoractivity. When

youexitthecustomizingtransactionandreturntothegraphic,yourchangeswill

be displayed in the graphic.

Using this tool, you candirectly check the individual customizing actions and

make necessary corrections.

124

第 143 页 / 共 509 页

AC220 Lesson: Line Items and Customizing Tools

Figure 64: Diagnosis Tool: Posting Statistics

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

externalsystem,youcandisplayachecklistoftheledgersthatwereupdated.

Figure 65: Diagnosis Tool: Troubleshooting

Sometimes,oneormoreledgersarenotupdatedbyapostingactivity,althoughthe

ledgershouldbeupdated. Usingtroubleshooting, youcandeterminethecause

oftheerrorandifrequired,youcandirectlycallthecorrespondingcustomizing

transactiontoaddmissingentriesorcorrecttheentriescontainingerrors.

125

第 144 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

Figure 66: Ledger Comparison

YoucancomparethetransactiondatastoredinanyFI-SLLedgerwiththosein

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.

ThedetailedAccount Comparisoncanbemadefor:

• G/L Account/G/L Account

• G/L Account/Corporate Account or

• G/L Account/Alternative Account

Iftherearedifferences,youcandrilldowntoaperiodoverviewofthese.

126

第 145 页 / 共 509 页

AC220 Lesson: Line Items and Customizing Tools

Figure 67: 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),

youenter informationrelevantfor the documentsyouwant totransfer, suchas

period,documentdate,postingdate,activity,anddocumentnumbers.

TargetLedger: Ifyouhaveassignedmorethanoneledgerincustomizingandare

settoFollow-uppostingbutyouonlywanttoposttooneledgerinthisrun,you

can specify one ledger as your target ledger.

IfthisledgerhasnotalreadybeenassignedinCustomizing,youwillgetanerror

message.

Demonstration: Demonstration of Customizing Tools

Purpose

To demonstratethe customizing tools in FI-SL

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. Youcan explainandshowthecustomizingtools:

ControlreportonledgerZZoralternativelycompanycodeAC00

127

第 146 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

Posting test: Financial Accounting and through-posting: activity RFBU,

AC00, today’s date.

Graph. navigation: ledger ZZ,through-posting.

Aftershowingtheassignments,double-clickanactivity,forexample,RFBU,

andwhenyoureachFI-SLCustomizing,assigntheactivityRGL0toyour

company code AC00 in the ledger ZZ as a required activity with field

movement,ZZSL.Aftersavingyourentries,returntothegraphicsdisplay

andshowtheeffectof yourCustomizingsetting.

Appendix

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

128

第 147 页 / 共 509 页

AC220 Lesson: Line Items and Customizing Tools

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

129

第 148 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

130

第 149 页 / 共 509 页

AC220 Lesson: Line Items and Customizing Tools

Exercise 5: FI-SL Customizing Tools 1

105

Exercise Duration: 20 Minutes

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

131

第 150 页 / 共 509 页

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.

132

第 151 页 / 共 509 页

AC220 Lesson: Line Items and Customizing Tools

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

133

第 152 页 / 共 509 页

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

134

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

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