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

第 48 页 / 共 411 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Ifyouselect this option, the internal structure, GLU1, isgenerated intheData

Dictionary. Thisisimportantif youwanttoinstallanFI-SLtablethatcontains

fieldswhichhavenotyetbeendefinedinanyotherFI-SLtable.

Figure 35: SIMPLYPUT: Create a Special LedgerTable

第 49 页 / 共 411 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Exercise 2: Characteristics and Basic Key

Figures

Exercise Objectives

After completingthisexercise, youwillbeableto:

• On the basis of two specific report requirements, list the characteristics

andkeyfiguresrequiredanddescribehowtoaddthesecharacteristicsand

keyfigureseither totheSAP coding block orto thecustomer include for

the coding block

• Createanewfieldinthecodingblockandnamethestepsrequired

• Define anew table group inthe Repository

Business Example

Onestepintheimplementationprocessinvolvesevaluatingmanagementreports

andcomparingthemwithreportsintheSAPsystem. Fornon-standardreports,

you must specify the key structure of the reporting table and determine the

characteristicsandkeyfiguresthat needtobeincluded.

Managementalsorequiresafield(characteristic)called“SpecialRegion”thatcan

be used to provide an additional geographical breakdown in certain financial

reports. You must create this field (characteristic) because it has not been

delivered by SAP.

Task 1:

Examinethetworeports. Listthecharacteristicsandkeyfiguresneededforthese

reports. Checkwhetherthecharacteristicsrequired arealready included inthe

codingblockdeliveredbySAPorinthecodingblockcustomerinclude.

Report1:Companycode:1000Bus.area:0001-0003Fiscalyear:2000Periods:1-12Version1

LocalCurrency Local Variance

Actual CurrencyPlan

DirectLaborCosts

Salaries

OvertimeCosts

MANAGEMENT

DirectLaborCosts

Salaries

Continued on next page

Report1:Companycode:1000Bus.area:0001-0003Fiscalyear:2000Periods:1-12Version1
LocalCurrency Local Variance Actual CurrencyPlan

第 50 页 / 共 411 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

OvertimeCosts

SALES&DISTRIBUTION

DirectLaborCosts

Salaries

OvertimeCosts

RESEARCH AND

DEVELOPMENT

TOTALFUNCTIONALAREAS

Report2:Companycode:1000Businessarea:0001-0003Fiscalyear:2000Periods:1-12Version1

Trans. Local Group. Lo- Lo- (Var.) Group. Group. (Var.)

Curr. Curr. Curr. cal. caL. Curr. Curr.

Curr. cURr.

Ac- Ac- Ac- Ac- Plan Ac- Plan

tual tual tual tual tual

Revenue

Acct. A

Revenue

Acct. B

Revenue

Acct. C

MaterialX

Revenue

Acct. A

Revenue

Acct. B

Revenue

Acct. C

MaterialY

MATERI-

ALSXY

Northern

Region

Revenue

Acct. A

Continued on next page

第 51 页 / 共 411 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Revenue

Acct. B

Revenue

Acct. C

MATERI-

ALSXY

Southern

Region

Eastern

Region

Western

Region

ALL

REGIONS

1. Listthecharacteristicsandbasickeyfiguresrequiredforthetworeports:

REPORT 1 REPORT 2

Characteristics: Basic key Characteristics: Basickeyfigures:

figures:

__________ __________ __________ __________

2. MenupathtocallcodingblockfunctionsinFI-SL:

Basic Settings → Maintain Coding Block

ExaminetheSAPstandardcodingblock(standardaccountassignment)and

the coding block customer include structure (CI_COBL) and specify the

characteristicsfromthelistin1-1-1thatappearthere:

Continued on next page

REPORT 1	REPORT 2
Characteristics: Basic key figures: __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________	Characteristics: Basickeyfigures: __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________

第 52 页 / 共 411 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Standard Account Assignment

StandardAccountAssignment CustomerIncludeStructure

Fieldname Description Fieldname Description

Task 2:

1. Createanewfield(countrycode). Use“BasicMode”:

( →Maintain Coding Block →Add Field)

Fieldname: ZZXXLCODE(XX=groupnumber)

Field description: Country Code

Data type: CHAR

Field length: 4

Package: ZFI0

Choose Test run (x) and Execute.

Read the log.

Only execute as a T E S T run.

Task 3:

1. Define anew tablegroup in theRepository.

Menu path:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger

→BasicSettings→Tables→Definition→DefineTableGroup

Tablegroup: ZxxTAB(xx =Group Number)

Select Create.

Tablegrouptype: Localtablegroup(companycode)

Select Continue.

Readtherelevantnotesbeforecontinuingtoprocessthetablegroup.

Select Continue.

Continued on next page

StandardAccountAssignment		CustomerIncludeStructure
Fieldname	Description	Fieldname	Description

第 53 页 / 共 411 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

2. Remove the field CNTR and insert the fields ZZREGION (data element

ZREGION)andMATNR(dataelementMATNR)afterthefieldFAREA.

Thesetwonewfieldsshouldalsobeusedassenders. Inthesummarytable

ZxxTAB,enterthedataelementsZPREGIONandZPMATNRasthepartner

object.

3. Gototheobjecttable2andinsertthefieldRMVCT(dataelementRMVCT).

4. Checkthesummaryandlineitemtablesandcheckwhetherthereceiverand

sender fieldsand the fixed attributesexist.

5. Sinceyourtablegroupdoesnotcontainadditionalquantities,donotselect

theStoreadd.quantityindicator. Gobackandcheckwhetherthefieldgroup

has been removed in your tables.

6. Check your table group.

7. Savethetablegroup. EnterthepackageZ***(askyourtrainerforthe

name). Save your entries.

CreatearequestwithashortdescriptionTablegroupZZxxTAB.Save

your entries.

Select Continue.

Themessage“Activatetablesandindicesandcreatethemonthedatabase?”

appears.

Select Yes.

第 54 页 / 共 411 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Solution 2: Characteristics and Basic Key

Figures

Task 1:

Examinethetworeports. Listthecharacteristicsandkeyfiguresneededforthese

reports. Check whether thecharacteristicsrequiredarealready included inthe

codingblockdeliveredbySAPorinthecodingblockcustomerinclude.

Report1:Companycode:1000Bus.area:0001-0003Fiscalyear:2000Periods:1-12Version1

LocalCurrency Local Variance

Actual CurrencyPlan

DirectLaborCosts

Salaries

OvertimeCosts

MANAGEMENT

DirectLaborCosts

Salaries

OvertimeCosts

SALES&DISTRIBUTION

DirectLaborCosts

Salaries

OvertimeCosts

RESEARCH AND

DEVELOPMENT

TOTALFUNCTIONALAREAS

Report2:Companycode:1000Businessarea:0001-0003Fiscalyear:2000Periods:1-12Version1

Trans. Local Group. Lo- Lo- (Var.) Group. Group. (Var.)

Curr. Curr. Curr. cal. caL. Curr. Curr.

Curr. cURr.

Ac- Ac- Ac- Ac- Plan Ac- Plan

tual tual tual tual tual

Revenue

Acct. A

Continued on next page

Report1:Companycode:1000Bus.area:0001-0003Fiscalyear:2000Periods:1-12Version1
LocalCurrency Local Variance Actual CurrencyPlan
DirectLaborCosts Salaries OvertimeCosts MANAGEMENT DirectLaborCosts Salaries OvertimeCosts SALES&DISTRIBUTION DirectLaborCosts Salaries OvertimeCosts RESEARCH AND DEVELOPMENT TOTALFUNCTIONALAREAS

第 55 页 / 共 411 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Revenue

Acct. B

Revenue

Acct. C

MaterialX

Revenue

Acct. A

Revenue

Acct. B

Revenue

Acct. C

MaterialY

MATERI-

ALSXY

Northern

Region

Revenue

Acct. A

Revenue

Acct. B

Revenue

Acct. C

MATERI-

ALSXY

Southern

Region

Eastern

Region

Western

Region

ALL

REGIONS

1. Listthecharacteristicsandbasickeyfiguresrequiredforthetworeports:

Continued on next page

第 56 页 / 共 411 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

REPORT 1 REPORT 2

Characteristics: Basic key Characteristics: Basickeyfigures:

figures:

__________ __________ __________ __________

a) List the characteristics and basic key figures required for the two

reports.

REPORT 1 REPORT 2

Characteris- Basic key Characteristics: Basic key

tics: figures: figures:

Account Localcurr.(2nd Account Transaction

curr.) currency

Functional Material Localcurr.(2nd

areas (product) curr.)

*Company Special region Groupcurr.(3rd

code *Company curr.)

code

Businessarea Businessarea

* Year * Year

* Period * Period

*Recordtype *Recordtype

*Version * Version

* ‘fixed’ *‘fixed’Fields

Fields

2. MenupathtocallcodingblockfunctionsinFI-SL:

BasicSettings → Maintain Coding Block

Continued on next page

REPORT 1	REPORT 2
Characteristics: Basic key figures: __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________	Characteristics: Basickeyfigures: __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________

REPORT 1	REPORT 2
Characteris- Basic key tics: figures: Account Localcurr.(2nd curr.) Functional areas Company code Businessarea Year * Period Recordtype Version * ‘fixed’ Fields	Characteristics: Basic key figures: Account Transaction currency Material Localcurr.(2nd (product) curr.) Special region Groupcurr.(3rd Company curr.) code Businessarea Year * Period Recordtype Version *‘fixed’Fields

第 57 页 / 共 411 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

ExaminetheSAPstandardcodingblock(standardaccountassignment)and

the coding block customer include structure (CI_COBL) and specify the

characteristicsfromthelistin1-1-1thatappearthere:

Standard Account Assignment

StandardAccountAssignment CustomerIncludeStructure

Fieldname Description Fieldname Description

a) TocallcodingblockfunctionsinFI-SL,select:

SAPReferenceIMG →Financial Accounting→SpecialPurpose

Ledger→BasicSettings→MaintainCodingBlock

Examine the SAP standard coding block (standard account

assignment) and the customer include structure (CI_COBL).

Thecharacteristics listed here arevariable characteristics. The

mandatory characteristics always contained in special purpose

ledgersarenotlistedhere. Thesemandatorycharacteristicsinclude

Ledger,Version,Recordtype,Companycode,Year,andPeriod.

Standard Account Assignment

StandardAccountAssignment CustomerIncludeStructure

Fieldname Description Fieldname Description

FKBER Functionalarea ZZSPREG Specialregion

GSBER Businessarea

MATNR Material

Task 2:

1. Createanewfield(countrycode). Use“BasicMode”:

( →Maintain Coding Block → Add Field)

Fieldname: ZZXXLCODE(XX=groupnumber)

Field description: Country Code

Data type: CHAR

Field length: 4

Continued on next page

StandardAccountAssignment		CustomerIncludeStructure
Fieldname	Description	Fieldname	Description

StandardAccountAssignment	CustomerIncludeStructure
Fieldname Description FKBER Functionalarea GSBER Businessarea MATNR Material	Fieldname Description ZZSPREG Specialregion

第 58 页 / 共 411 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Package: ZFI0

Choose Test run (x) and Execute.

Read the log.

Only execute as a T E S T run.

a) Createanewfield(countrycode). Use“BasicMode”:

( →Maintain CodingBlock →Add Field)

Fieldname: ZZXXLCODE(XX=groupnumber)

Field description: Country Code

Data type: CHAR

Field length: 4

Package: ZFI0

Choose Test run (x) and Execute.

Read the log.

Thesystemissuesthefollowinglog, forexample:

Log for field ZZXXLCODE

BB112 W Test run

BB150WCustomizingentriesforthefieldZZXXLCODE

BB105 SEntryTCOBM:ZZXXLCODE134

BB105S EntryTCOBF:112ZZXXLCODEX

BB105SEntryTMODO:SKB1-FAUS11122KONT

BB105SEntryTMODP:ESKB1-FAUS1112CountryCode

BB105SEntryTMODU:SKB1-FAUS1112BSEGZZXXLCODESX

BB105SEntryGB01:009SBSEGZZXXLCODE

BB105SEntryGB01:001SCOBLZZXXLCODE

BB105SEntryTMODO:T156B-FAUSW1122KONT

BB105SEntryTMODP:ET156B-FAUSW112CountryCode

BB105SEntryT162X:401E2112CountryCode

FB200 S Report SAPF120 wasgenerated

BB149SGenerationreportSAPFACCGexecuted

BB146SGenerationprogramRFBIBLG0executedforFIbatchinput

Continued on next page

第 59 页 / 共 411 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

BB148 S Generation report RFBIPPG0 executed for parked FI

documents

BB147 S Generation report RGUGBR00 executed for

validations/substitutions

BB054SSubscreen9999hasbeengenerated

Task 3:

1. Define anew tablegroup in theRepository.

Menu path:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger

→BasicSettings→Tables→Definition→DefineTableGroup

Tablegroup: ZxxTAB(xx=GroupNumber)

Select Create.

Tablegrouptype: Localtablegroup(companycode)

Select Continue.

Readtherelevantnotesbeforecontinuingtoprocessthetablegroup.

Select Continue.

a) Beforeyoucreatetablesinspecialpurposeledgers,youmustdefinethe

required fields and data elements.

According to SAP naming conventions, all table groups must start

with Y or Z.

Menu path:

SAPReferenceIMG →Financial Accounting→SpecialPurpose

Ledger→ Basic Settings →Tables →Definition →Define Table

Group

Tablegroup: ZxxTAB(xx=groupnumber)SelectCreate.

Tablegrouptype: Localtablegroup(companycode). SelectContinue.

Readthenotesoneditingtablegroups. Notethatfivetablesarecreated

forthespecialpurposeledgers. SelectContinue.

2. Remove the field CNTR and insert the fields ZZREGION (data element

ZREGION)andMATNR(dataelementMATNR)afterthefieldFAREA.

Continued on next page

第 60 页 / 共 411 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Thesetwonewfieldsshouldalsobeusedassenders. Inthesummarytable

ZxxTAB,enterthedataelementsZPREGIONandZPMATNRasthepartner

object.

a) Fields for ZxxTABO: Object table 1

FieldName DataElement Key Sender

MANDT MANDT x

OBJNRG OBJNR x

BUKRS BUKRS x

ACCT RACCT x

BUSA GSBER x

FAREA FKBER x

ZZREGION ZREGION x

MATNR MATNR x

3. Gototheobjecttable2andinsertthefieldRMVCT(dataelementRMVCT).

a) Table name: ZxxTABC: Object table 2

FieldName DataElement Key

MANDT MANDT x

OBJNRG OBNR x

LOGSYS LOGSYS

RMVCTR MVCT <<< (Add)

4. Checkthesummaryandlineitemtablesandcheckwhetherthereceiverand

sender fields and thefixed attributesexist.

a) Addingthefieldstoobjecttable1andselectingSforSendercreates

thesender andreceiver versionsof thefields.

5. Sinceyourtablegroupdoesnotcontainadditionalquantities,donotselect

theStoreadd.quantityindicator. Gobackandcheckwhetherthefieldgroup

has been removed in your tables.

a) Technical characteristics:

Quantities

X Store add. quantity << Remove X

Continued on next page

第 61 页 / 共 411 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

6. Check your table group.

a) Check your table group.

Thefollowinglogisissued: ForinformationpurposesONLY

Checksecondaryindex1ofthetableZxxTABT.

Checksecondaryindex1ofthetableZxxTABA

Checksecondaryindex1ofthetableZxxTABP.

7. Savethetablegroup. EnterthepackageZ***(askyourtrainerforthe

name). Save your entries.

CreatearequestwithashortdescriptionTablegroupZZxxTAB.Save

your entries.

Select Continue.

Themessage“Activatetablesandindicesandcreatethemonthedatabase?”

appears.

Select Yes.

a) Save your table group and activate it in the database. Your trainer

will specify the package.

第 62 页 / 共 411 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Lesson Summary

You should now be able to:

• Includeyourownfield(characteristic)inthecodingblockoftheSAPsystem

• Explainhowtousethebasicmodeandnamethestepsrequiredwhenusing

the expert mode

• Implement integrated consolidation

• Describe coding block field selection

• CreateanFI-SL tablegroupintheSAP Repository

• Describehow to usekey figuresand indices

• Describehowtoinstall thetablegroupinFI-SL

第 63 页 / 共 411 页

AC220 Unit Summary

Unit Summary

You should now be able to:

• Includeyourownfield(characteristic)inthecodingblockoftheSAPsystem

• Explainhowtousethebasicmodeandnamethestepsrequiredwhenusing

the expert mode

• Implement integrated consolidation

• Describe coding block field selection

• CreateanFI-SLtablegroupintheSAPRepository

• Describehowto usekey figuresand indices

• DescribehowtoinstallthetablegroupinFI-SL

第 64 页 / 共 411 页

UnitSummary AC220

第 65 页 / 共 411 页

AC220 Test Your Knowledge

Test Your Knowledge

1. If you want to create line item reports, you should define indices for the

line item tables.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

2. TheFI-SLSystemisabletoextractoutofthecodingblockanynumberof

thecharacteristicsmadeavailablein aposting.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

3. Thecomponentsforwhichyou installthetablearedirectposting, master

data, allocation, and .

Fillintheblankstocompletethesentence.

4. An implementation of FI-SL is recommended only if your

special reporting requirements cannot be covered by the

Fillintheblankstocompletethesentence.

5. stores theactual andplantotal balances

and store the document information

(actual/plan)forthetotalsstoredintheSummaryTable.

Fillintheblankstocompletethesentence.

6. The transactions and components in the SAP system are based on the

Fillintheblankstocompletethesentence.

7. In the Expert Mode, you have to insert field in the customizing include

CI_COBOL for thetablesrelevant for the and

in CI_COBOL_BI for use when entering an FI document in background

processing.

Fillintheblankstocompletethesentence.

第 66 页 / 共 411 页

TestYourKnowledge AC220

8. Whencanyourequestthesystemtoactivatethetablesinyourtablegroup?

9. WhatdoObject Table1andObjectTable2store?

10. How is the field “field length” used?

11. IfthenewaccountassignmentfieldisaddedtoFI-SLtables,allfunctions

in theFI-SL system will beavailablefor thisfield also. Which functions

are these?

12. Explain the steps to use the expert mode.

第 67 页 / 共 411 页

AC220 Test Your Knowledge

Answers

1. If you want to create line item reports, you should define indices for the

line item tables.

Answer: True

Youshouldcreateindicesforyoursummarytablesandifyouwanttocreate

lineitemreports,youshouldalsodefineindicesforthelineitemtables.

2. TheFI-SLSystemisabletoextractoutofthecodingblockanynumberof

thecharacteristicsmadeavailablein aposting.

Answer: True

TheFI-SLSystemisabletoextractoutofthecodingblockanynumberof

thecharacteristicsmadeavailableinaposting. Thishelpstoupdatethese

combinationsandprovidetherelationshipsandlevelofdetailneeded.

3. Thecomponentsforwhichyou installthetablearedirectposting, master

data, allocation, and report writer.

Answer: report writer

4. AnimplementationofFI-SLisrecommendedonlyifyourspecialreporting

requirementscannotbecoveredbythestandardSAPapplications.

Answer: standard SAP applications

5. Summary Table stores the actual and plan total balances and Line Item

Tablesstorethedocumentinformation(actual/plan)forthetotalsstoredin

the Summary Table.

Answer: SummaryTable, LineItem Tables

6. ThetransactionsandcomponentsintheSAPsystemarebasedonthecoding

block.

Answer: coding block

第 68 页 / 共 411 页

TestYourKnowledge AC220

7. In the Expert Mode, you have to insert field in the customizing

include CI_COBOL for the tables relevant for the coding block and in

CI_COBOL_BI for use when entering an FI document in background

processing.

Answer: coding block

8. Whencanyourequestthesystemtoactivatethetablesinyourtablegroup?

Answer: After your table group has been checked and saved, you can

request thatthesystem activatethetablesin yourtablegroup. Whenyou

havecreatedyourtables,youcaninstallthetablegroup.

9. WhatdoObject Table1andObjectTable2store?

Answer: Object Table 1 stores the characteristics you need and also an

objectnumberforthesecharacteristicsasreceiverandsender. ObjectTable

2isoptionalandcontainscharacteristicsthatarefixedtransactionattributes

and have no receiver/sender relationship.

10. How is the field “field length” used?

Answer: Inthe“Fieldlength”field,youdeterminethelengthofthecurrency

andquantity fieldsdependingontheanticipated length of theamountsto

be entered.

11. IfthenewaccountassignmentfieldisaddedtoFI-SLtables,allfunctions

in theFI-SL system will beavailablefor thisfield also. Which functions

are these?

Answer: IfthefieldisalsoaddedtoFI-SLtables,allfunctionsintheFI-SL

system isavailableto thisfield. These functionsincludeFI-SL postings,

planning,allocations,rollups,balancecarryforward,andreporting.

12. Explain the steps to use the expert mode.

Answer: In the Expert Mode:

• Create a domain.

• Create a data element.

• Insert field in the customizing include CI_COBOL for the tables

relevant for the coding block and in CI_COBOL_BI for use when

enteringanFIdocumentinbackgroundprocessing.

• InsertattheendoftableBSEGforFIG/Laccountpostings.

第 69 页 / 共 411 页

Unit 3

Setting Up the FI-SL Environment

Unit Overview

ThefocusofthisunitistoexplaintheworkingsoftheFI-SLSystem. Youwill

alsolearnaboutthesettingsthatinfluenceboththequalityandquantityofdata

you need to store.

Unit Objectives

After completing thisunit, you will beableto:

• Transferdatatoandorganizedatainspecialpurposeledger

• Explainparallelledgerupdateandledgermasterdata

• Describetheprocedureto configure aledger

• Explaintheconceptsofcompanycode,company,ledger,activity,andfield

movement

• Explain line items

• Use the tools to check your set up

Unit Contents

Lesson: FI-SL Structure.........................................................62

Lesson: Configuring the Ledger ...............................................71

Exercise 3: Ledger Assignments..........................................81

Lesson: Line Items and Customizing Tools ..................................90

Exercise 4: FI-SL Customizing Tools 1..................................101

Exercise 5: FI-SL Diagnostic Tools for Checking Postings, Ledger

Comparison and Troubleshooting........................................107

第 70 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

Lesson: FI-SL Structure

Lesson Overview

Thislessonwillhelpyouunderstandhowtotransferdatatoandorganizedatain

specialpurposeledger. Youwillalsolearnabouttheconceptsofparallelledger

update and ledger master data.

Lesson Objectives

After completingthislesson, you will beable to:

• Transferdatatoandorganizedatainspecialpurposeledger

• Explainparallelledgerupdateandledgermasterdata

Business Example

YourCompanyhasafairlyrichmanagementreportingrequirement. Mostofthe

informationneededcomesfrom other application areasbut must beregrouped

andfurtherenhanced. Insomecases,theinformationmustberefinedtoprovide

summarized data in chosen combinations.

Managementalsorequiresafield(characteristic)calledSpecial Region, which

canbeusedtoprovideanadditionalgeographicalbreakdownincertainfinancial

reports. Thisfield(characteristic)mustbecreated,asitisnotdeliveredbySAP.

Afterthecharacteristicsandkeyfigureshavebeensortedlogicallyintogroupsfor

therequiredreports,databasetablesmustbegeneratedandinstalledforthevarious

FI-SLcomponentsbeforetheycanbemadeavailableforupdateandreporting.

Usingthenewlycreatedfield,SpecialRegion,andreportingdatabase,youneedto

setuptheFI-SLmasterdatatoenableFI-SLtablestobeupdated.

第 71 页 / 共 411 页

AC220 Lesson: FI-SL Structure

Transferring Data to and Organizing Data in Special

Purpose Ledger

Figure 36: Setting Up the FI-SL Environment: Overview

Figure 37: Transferring Datato Special Purpose Ledger

MostofthedatathatenterstheFI-SLSystemcomefromtransactionsoccurringin

manydifferentplaces. AbusinesstransactioncanentertheFI-SLSystemthrough

anotherSAPapplication,directinputtotheFI-SLSystem,orexternalsystems.

第 72 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

AllthedatathatenterstheFI-SLSystemisprocessedbytheIntegrationManager.

Through user-defined selection, validation, and substitution conditions, the

Integration Manager determinesifand howdatashould bepostedto theFI-SL

databases.

Example:

• Procurement&InventoryManagementsuppliesinformationpertainingto

inventorymovementsaswellastheresultsofinvoiceverification. Datacan

alsobetransmittedfromSalesOrderManagement.

DatacanalsobetransmittedfromFinancialSystems(FI).

TheManagementAccountingmodulestransmitrelevantdataaboutcostsoncost

centers or orders/projects.

Figure 38: Organizing Data in SpecialPurpose Ledger

Organizing Data in FI-SL

TheIntegrationManagerprocessesthetransactiondata.

Within theFI-SL System, you define ledgers that contain dimensions from an

FI-SL database table. Depending on how you define a ledger, the Integration

Manager determines:

• Which data is posted to a ledger

• How data is summarized in a ledger

The Integration Manager also processes incoming transaction data according

to certain user-defined conditions, such as validation, substitution, and ledger

selection conditions.

第 73 页 / 共 411 页

AC220 Lesson: FI-SL Structure

Figure 39: Interface Postings To FI-SL

DatathatistransferredtoFI-SLfromother SAPapplications, externalsystems

or, FI-SL adjustmentpostings isupdatedassummary records(withlineitems,

if required) in user-defined TABLES.

This data is stored in local LEDGERS (for company codes) and in global

LEDGERS (for global companies).

You can assign your company codes or global companies to one or more

LEDGERS.

ThesystemgroupstogetherthevariousaccountingtransactionsintoACTIVITIES.

Fromtheseactivities,youcantransferanycodecombinationstoyourledgers. A

FIELDGROUPING CODE is used to do this.

Parallel Ledger Update

Figure 40: Parallel Ledger Update

第 74 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

Thesubdivisionofdataintoledgersenablesyoutosimultaneouslystoredataat

various levels of detail.

Ledger Master Data

Figure 41: Ledger Master Data (1)

Whenyoucreatealedger,youmustdeterminethefollowing:

• Inwhichsummarytableistheledgerdatatobeupdated?

• Can the ledger be posted to?

• Can the ledger be used as a rollup ledger?

• Shouldtheledgerstorelineitems(thatis,forALLcompanycodes(orglobal

companies) thatsupplytheledger withdata)?

第 75 页 / 共 411 页

AC220 Lesson: FI-SL Structure

Figure 42: Ledger Structure

Basedonitstablestructure,aledgerisasuitableframeworktostoreuser-defined

CHARACTERISTICcombinationsandtheappropriatebalances.

TheRECORDTYPEflagsthebalancesasactualdata(0),plandata(1),allocated

actual data (2), or allocated plan data (3).

Eachrecordtypecanhaveupto999VERSIONs. Youcanusetheseversionsto

comparedifferentvaluationbasesforplanningorallocation. Theactualdatathat

istransferredtoFI-SLthroughtheintegrationinterfaceisautomaticallyassigned

version001. ForFI-SLadjustmentpostings,youcanassigndeltaversionsthatare

stored separately.

Thesummarydatainaledgercanalsobestoredseparatelyasdebitandcreditdata.

Figure 43: Ledger Master Data (2)

第 76 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

Youmustalsodefinethefollowingattheledgerlevel:

• iftheledgerbalancesaretobestoredintransactioncurrency,

• whichsecondand/orthirdcurrencyshouldbeupdatedandifthisappliesto

ALL company codes,

• thecurrencykey,iftheledgercurrencyisselectedastheadditionalcurrency

• ifcurrenciesandadditionalcurrenciesaretobestoredintheledger

• if balancesaretobemaintainedindebitandcredit

• if thesebalancesareto becarried forward to the following year. For any

postingswhicharethenmadetopreviousyearperiodsthebalanceswillthen

automaticallybetransferredtothecarryforwardperiodofthefollowingyear

Figure 44: Currency and Quantity Combinations

When defining your ledger for updating balances, you can select out of up to

five KEY FIGURES.

YoucandecidewhetherornotthebalancesaretobestoredinTRANSACTION

CURRENCY for ALL company codes that store their balances in the ledger.

Thetransactioncurrencyisthecurrencyinwhichthetransactionwasoriginally

entered.

You can store QUANTITIES and ADDITIONAL QUANTITIES at the same

account assignment level.

Thecurrencykeyandunitsofmeasure,respectively,areusedasfurthermeansof

differentiationforthetransactioncurrencybalancesandquantitybalances.

第 77 页 / 共 411 页

AC220 Lesson: FI-SL Structure

In addition to the transaction currency, you can store balances in a SECOND

and/or THIRDcurrency. Thesecombinationscanbe stored for ALL company

codes or ALTERNATIVELY for only ONE company code or for SPECIFIC

company codes in your ledger.

第 78 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

Lesson Summary

You should now be able to:

• Transferdatatoandorganizedatainspecialpurposeledger

• Explainparallelledgerupdateandledgermasterdata

第 79 页 / 共 411 页

AC220 Lesson: Configuring the Ledger

Lesson: Configuring the Ledger

Lesson Overview

Thislessondiscussestheproceduretoconfigurealedger. Youwillalsolearnabout

theconceptsofcompanycode,company,ledger,activity,andfieldmovement.

Lesson Objectives

After completingthislesson, youwillbeable to:

• Describetheprocedureto configure aledger

• Explaintheconceptsofcompanycode,company,ledger,activity,andfield

movement

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.

第 80 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

Procedure to Configure the Ledger

Figure 45: Configuring The Ledger

Incompany-specificreporting,thecriteriatocreatethissummaryinformationcan

bediverse andcandiffer in the followingaspects:

• 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

第 81 页 / 共 411 页

AC220 Lesson: Configuring the Ledger

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.

Figure 47: Local Ledgers and Global Ledgers

第 82 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

Therearetwo typesof special purposeledgers:

• Localledger: UsestheorganizationalunitCOMPANYCODE.

• Globalledger: UsestheorganizationalunitCOMPANYID.

Assigning a Company Code/Company IDs to Ledgers

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

to therelevant commercial law. Aglobal company canconsist of oneor more

company codes.

第 83 页 / 共 411 页

AC220 Lesson: Configuring the Ledger

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

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

第 84 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

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

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

第 85 页 / 共 411 页

AC220 Lesson: Configuring the Ledger

Activities and Field Movements

Figure 51: Activities

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

theFI-SL informationsystem, you can report onseveral 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.

Figure 52: Flexible Data Transfer

第 86 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

Thebusinesstransactionsthat enter intoFI-SLfromother SAPapplicationsor

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, you can do sofor specificactivities.

Figure 53: Activity Groups

Theindividualactivitiesfromotherapplicationsarecombinedintoactivitygroups.

You canassigntheseactivitygroupsto yourledgers.

Commonactivities, suchasallMMactivities, aregroupedtogethersothatitis

nolongerimportantforyoutoassignaspecificactivitytoaledger. Yousimply

assigntheactivitygroupcodetoaledger andthesystemautomaticallyassigns

the relevant activities.

第 87 页 / 共 411 页

AC220 Lesson: Configuring the Ledger

Figure 54: Selective Update of Characteristics

Theledger providesalogical structuretoformtotals.

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

one account assignment.

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.

第 88 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

第 89 页 / 共 411 页

AC220 Lesson: Configuring the Ledger

Exercise 3: Ledger Assignments

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

Createaledger for thesummarytableZSLTABT.

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

第 90 页 / 共 411 页

Unit3: SettingUptheFI-SLEnvironment AC220

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.

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