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

第 69 页 / 共 509 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Settings for the allowed fields for validation/substitution: Data Browser

(SE16): display GB01 for field ZZSPREG: entry for COBL usage.

GenerationreportRGUGBR00validation/substitution.

Generatedsourcecode: SAPFACCGforRWinterface, RFBIBLG0forFI

batchinputandRFBIPPG0forFIdocumentparking.

FieldselectionPurchasingdocumentT162tables: entryforZZSPREGin

T162X (SE16).

You can now display a list of the SAP subscreens: Menu option →

Subscreen; List.

User-definedsubscreenscanalsobecreatedwiththisfunction;the9000

numbersarereserved forcustomerscreens.

NowdisplaythefollowingscreensforthesubscreensusingSE51(Screen

Painter):

Program SAPLKACB

1. Screen0002: SAPfullscreen: displaytheattributesforfunctional

area (COBL-FKBER).

2. Screen9999: User-definedsubscreen: alsodisplaytheattributes

for Special Region (COBL-ZZSPREG)

AsanOPTION,youcandeviseascreen,forexample,9500,withMATNR

andZZSPREG,saveandgenerate. Youmaythengenerateitandshowhow

this will appear (Test display) for postings.

(For participants interested in ABAP: show INCLUDE

LKACBUXX in SAPLKACB and there INCLUDE LKACBU04

→ PERFORM MODNR_BESTIMMEN. Display FUNCTION

COBL_SEND_FULL_SCREENandPERFORMMODNR_BESTIMMEN

for thesearchfor oneuser-definedsubscreens.) Alsofor ABAPorDDIC

specialists, (for informationpurposes; optionalforthiscourse), useSE80

(ObjectBrowser)todisplaytheentriesforfunctiongroupKACBinprogram

SAPLKACB.

Bydefault,subscreen9999isautomaticallyfilledwiththenewfieldwith

the Basic mode Create function.

IfyouthenswitchtotheExpertmode(menuoption),youcanshowthe

list of the necessary steps there:

menu option: Account assignment field

第 70 页 / 共 509 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Indices

Especiallyimportantforreadingthedataandforperiodicprocessingandreporting.

Here,refertothefollowingCSScustomernotethatyoucanalsohandouttothe

participants: Note number 0031374: FI-SL Secondary indices for transparent

tables.

Figure 31: Indices

Definingindicesforyourtablesisveryimportantforfuturesystemperformance.

Forinformationonindices,pleaserefertoOSSNote31374“FISL:Secondary

indices for transparent tables”.

Youshouldcreateindicesforyoursummarytables. Ifyouwanttocreatelineitem

reports,youshouldalsodefineindicesforthelineitemtables.

The ABAP Report RGUIST00 will help you to find an optimal index for SL

Tables. Try running it for GLFUNCT or your own tables after theyhave been

updatedafteracertaintime. Thisprogramwilllistthemostselectivefields.

第 71 页 / 共 509 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Installation in FI-SL

Saving Table Groups

BeforethetablegroupcanbeusedandbeforeitcanbeinstalledinFI-SL,ithasto

besavedintherepositoryandactivated. Thatmeansthetablesandtheirindices

must be created in the database do this.

Installation: Components

Settingof thecontroltablesfor thefollowingtables:

• Through-posting: especiallyT800M:fixedfieldmovement

• Masterdata: especiallyT800Dmasterdatavalidation

• Allocation: the T811 tables

• Report Writer: the T804 tables

Installation: Generating GLU1

TheinternalstructurecontainingallthevariablefieldsknowntoFI-SL(FI-SL

tables) that are to be processed in FI-SL

Figure 32: Saving Table Groups

Whenyousaveyourtablegroup,thesystemautomaticallyperformsaconsistency

check of the tables in your table group.

After your table group has been checked and saved, you can request that the

system activate the tables in your table group.

Whenyouhavecreatedyourtables,youcaninstallthetablegroup.

第 72 页 / 共 509 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Figure 33: Installation: Components

You must first determine the components for which you wish to install the

tables. Forthesecomponents,controlentriesaregeneratedforyourtables. The

components are:

• Directposting: Usingtheseentries,youcanpostdatatoyournewtable.

• Masterdata: Usingtheseentries,youcanactivatemasterdatavalidation

for your new table.

• Allocation: Using these entries, you can work with allocations for your

new table.

• Report Writer: Using theseentries, you canwork with report writer for

the new table.

Figure 34: Installation: Generating GLU1

第 73 页 / 共 509 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

If you select this option, theinternal structure, GLU1, isgenerated in theData

Dictionary. Thisisimportant ifyouwanttoinstallanFI-SLtablethatcontains

fieldswhichhavenotyetbeendefinedinanyotherFI-SLtable.

Figure 35: SIMPLYPUT: Create a Special LedgerTable

Demonstration: Demonstration of Installation-1

Purpose

To demonstrate installation in FI-SL

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. Nowcreatethetablegroup,ZSLTAB,asalocal(CCode)tableunderBasic

Settings→Tables→Definition→DefineTableGroup.

Soonafter,youreceiveanoteconcerningyourfutureworkintherepository,

whichyoucanreadthroughtogetherwiththeparticipants.

Note: Thistablegroupusesthetablegroup,GLREF,whichalready

exists in the repository as a template.

第 74 页 / 共 509 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Whenyoureachthemaintenanceofobjecttable1,removethefield,CNTR,

and append the fields, ZZREGION (with the data element, ZREGION)

and MATNR (with the data element, MATNR). For these fields, choose

theoption,S,whichmeansselecttheindicator). Bybranchingtotheother

tables,demonstratetheimmediateeffectofthisindicator: RZZREGIONand

SZZREGION, RMATNR and SMATNR.

ThenewfieldwillnowbenamedZZREGIONandaddressedas

RZZREGION(Object)andSZZREGION(PartnerObject)inthetotals

table(-S),actualitemstable(-A),andplanitemstable(-P),accordingly.

Forthefields,SZZREGIONandSMATNR,inthetable,ZSLTABT,replace

theDataelementsforthesewithZPREGIONandZPMATNR,respectively.

Thisisnecessarytoretrieveappropriatetextforthesepartnerfieldslater.

Explainthestructureofthetotalsactualandplanline-itemtables.

WhenyouchooseUseObject2underExtras,youreachthemaintenanceof

thistransactionattributetable. Add the field, Movement Type RMVCT

(withthedataelementwiththesamename),andthenshowtheeffectofthis

specificationinthetotalsandlineitemtables. Thenbranchto→Technical

Specifications.

Removethespecificationforadditionalquantity. Thendisplaytheeffects

of thesespecificationstotalsandlineitemtables.

DisplaytheindicesthesystemhassetfortheZSLTABtables. Asasample

setting,youcancreateanindex2forthetable,ZSLTABT,withthefollowing

fields:

RACCT,RZZREGION,RFAREA,RBUSA,RBUKRS,RLDNR,andRCLNT

Beforesavingthetablegroup,youcangetanoverviewofthetablesettings

usingthemenupointTableGroup→Overview. Thisgivesalistingofthe

table fields and their indices.

Now check the table group.

Youwillalwaysfirstreceiveaninformationnoteontheindices.

Saveyourtablegroupsandcreatethetablesandtheindicesinthedatabase

(youwillberequestedtodothis). EnterDevelopmentClassZFI0,ifrequired.

Demonstration: Demonstration of Installation-2

Purpose

To demonstrate installation in FI-SL

第 75 页 / 共 509 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. Steps:

Starttheinstallationofyourtablegroup,ZSLTAB..

You should carry out theinstallation for all FI-SL components including

GLU1andprogramgeneration. Thetable,GLT1,isproposedassamplefor

the installation.

Beforeyoureceiveafinalinstallationlog,youwillbeaskedthefollowing

questions:

Program group? : Choose 1

Thesourcecodeforthetablestobeinstalledisorganizedinprogramgroups:

(forreasonsofoverview: theprogramswillnotoverflow)

You are requested to createchange requests for theobjects. You can use

ZFI0asaDevelopmentClass. Createaneworderwithcorrespondingtexts.

For example, Installation ZSLTAB.

Whenyoufinallyreceiveyourlogontheinstallation(thisinstallationroutine

maytakealongtime!),displaythelongtext,accessFI-SLCustomizing,and

displaythecorrespondingtableentries. Forexample, Integr. Master data

(T800D)forZZLST,FI-SLtabledirectory(T800A),ReportWritercatalog

(T804A),fixedfieldmovement(T800m). UsetransactionSE11todisplay

thenewGLU1structuresetupthroughtheinstallation.

Pointouttotheparticipantsthatthenewcharacteristic(field),RZZREGION,

is missing in the control tables, T800D (master data validation and plan

usageFI-SL), and inthe T811tables(for example, field usage for actual

distribution). Someof these settings are explained and made in the units

to come.

Finally, goonceagaintoFI-SLCustomizingandcallupagraphicalview

of your new table ZSLTABT just as you did for GLFUNCT. Show the

participantsallthetablesinthegroupincludingthefieldsandindices.

第 76 页 / 共 509 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

第 77 页 / 共 509 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Exercise 2: Characteristics and Basic Key

Figures

Exercise Duration: 90 Minutes

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-12 Version 1

------------------------------------------------------

- - - - - - - - - - -

LocalCurrencyActualLocalCurrencyPlanVariance

Direct Labor Costs

Salaries

Overtime Costs

MANAGEMENT

Continued on next page

第 78 页 / 共 509 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Direct Labor Costs

Salaries

Overtime Costs

SALES & DISTRIBUTION

Direct Labor Costs

Salaries

Overtime Costs

RESEARCH AND DEVELOPMENT

TOTAL FUNCTIONAL AREAS

Continued on next page

第 79 页 / 共 509 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Report2: Companycode: 1000Businessarea: 0001-0003Fiscalyear: 2000

Periods:1-12 Version 1

Trans.Curr.Local Curr.GroupCurr.Local Curr.Local Curr.(Var.) GroupCurr.

GroupCurr.(Var.)

Actual Actual Actual Actual Plan Actual Plan

Revenue Acct. A

Revenue Acct. B

Revenue Acct. C

Material X

Revenue Acct. A

Revenue Acct. B

Revenue Acct. C

Material Y

MATERIALS XY

Northern Region

Revenue Acct. A

Revenue Acct. B

Revenue Acct. C

MATERIALS XY

Southern Region

Eastern Region

Western Region

ALL REGIONS

1. Listthecharacteristicsandbasickeyfiguresrequiredforthetworeports:

Continued on next page

Report2: Companycode: 1000Businessarea: 0001-0003Fiscalyear: 2000 Periods:1-12 Version 1
Trans.Curr.Local Curr.GroupCurr.Local Curr.Local Curr.(Var.) GroupCurr. GroupCurr.(Var.) Actual Actual Actual Actual Plan Actual Plan
Revenue Acct. A Revenue Acct. B Revenue Acct. C Material X Revenue Acct. A Revenue Acct. B Revenue Acct. C Material Y MATERIALS XY Northern Region Revenue Acct. A Revenue Acct. B Revenue Acct. C MATERIALS XY Southern Region :: Eastern Region :: Western Region ALL REGIONS

第 80 页 / 共 509 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

REPORT 1 REPORT 2

Characteristics: Basic keyfigures: Characteristics: Basickeyfigures:

____________ ____________ ____________ ____________

________________________ ________________________

2. MenupathtocallcodingblockfunctionsinFI-SL:

BasicSettings → Maintain Coding Block

ExaminetheSAPstandardcodingblock(standardaccountassignment)and

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

characteristicsfromthelistin1-1-1thatappearthere:

Standard Account Assignment

StandardAccountAssignment CustomerIncludeStructure

FieldnameDescription FieldnameDescription

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.

Continued on next page

REPORT 1	REPORT 2
Characteristics: Basic keyfigures: ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ________________________	Characteristics: Basickeyfigures: ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ________________________

StandardAccountAssignment	CustomerIncludeStructure
FieldnameDescription	FieldnameDescription

第 81 页 / 共 509 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

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.

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.

第 82 页 / 共 509 页

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-12 Version 1

------------------------------------------------------

- - - - - - - - - - -

LocalCurrencyActualLocal CurrencyPlanVariance

Direct Labor Costs

Salaries

Overtime Costs

MANAGEMENT

Direct Labor Costs

Salaries

Overtime Costs

SALES & DISTRIBUTION

Direct Labor Costs

Salaries

Overtime Costs

RESEARCH AND DEVELOPMENT

TOTAL FUNCTIONAL AREAS

Continued on next page

第 83 页 / 共 509 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Report2: Companycode: 1000Businessarea: 0001-0003Fiscalyear: 2000

Periods:1-12 Version 1

Trans.Curr.Local Curr.GroupCurr.Local Curr.Local Curr.(Var.) GroupCurr.

GroupCurr.(Var.)

Actual Actual Actual Actual Plan Actual Plan

Revenue Acct. A

Revenue Acct. B

Revenue Acct. C

Material X

Revenue Acct. A

Revenue Acct. B

Revenue Acct. C

Material Y

MATERIALS XY

Northern Region

Revenue Acct. A

Revenue Acct. B

Revenue Acct. C

MATERIALS XY

Southern Region

Eastern Region

Western Region

ALL REGIONS

1. Listthecharacteristicsandbasickeyfiguresrequiredforthetworeports:

Continued on next page

Report2: Companycode: 1000Businessarea: 0001-0003Fiscalyear: 2000 Periods:1-12 Version 1
Trans.Curr.Local Curr.GroupCurr.Local Curr.Local Curr.(Var.) GroupCurr. GroupCurr.(Var.) Actual Actual Actual Actual Plan Actual Plan
Revenue Acct. A Revenue Acct. B Revenue Acct. C Material X Revenue Acct. A Revenue Acct. B Revenue Acct. C Material Y MATERIALS XY Northern Region Revenue Acct. A Revenue Acct. B Revenue Acct. C MATERIALS XY Southern Region :: Eastern Region :: Western Region ALL REGIONS

第 84 页 / 共 509 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

REPORT 1 REPORT 2

Characteristics: Basic keyfigures: Characteristics: Basickeyfigures:

____________ ____________ ____________ ____________

________________________ ________________________

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

reports.

REPORT 1 REPORT 2

Characteristics:Basic key Characteristics: Basickeyfigures:

figures:

AccountTransactioncurrency

AccountLocal curr.(2nd

Material (product) Local curr.(2nd

curr.)

Functional areas

SpecialregionGroup curr.(3rd curr.)

*Companycode *Company code

Business area Business area

*Year *Year

* Period * Period

*Record type *Record type

*Version *Version

* ‘Fixed’ fields * ‘Fixed’ fields

2. MenupathtocallcodingblockfunctionsinFI-SL:

BasicSettings → Maintain Coding Block

ExaminetheSAPstandardcodingblock(standardaccountassignment)and

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

characteristicsfromthelistin1-1-1thatappearthere:

Standard Account Assignment

Continued on next page

REPORT 1	REPORT 2
Characteristics: Basic keyfigures: ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ________________________	Characteristics: Basickeyfigures: ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ________________________

REPORT 1	REPORT 2
Characteristics:Basic key figures: AccountLocal curr.(2nd curr.) Functional areas Companycode Business area Year * Period Record type Version * ‘Fixed’ fields	Characteristics: Basickeyfigures: AccountTransactioncurrency Material (product) Local curr.(2nd curr.) SpecialregionGroup curr.(3rd curr.) Company code Business area Year * Period Record type Version * ‘Fixed’ fields

第 85 页 / 共 509 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

StandardAccountAssignment CustomerIncludeStructure

FieldnameDescription FieldnameDescription

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

Field nameDescriptionFKBER- Field nameDescription

FunctionalareaGSBERBusiness ZZSPREGSpecialregion

areaMATNRMaterial

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.

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

(→MaintainCodingBlock →AddField)

Fieldname: ZZXXLCODE(XX=groupnumber)

Continued on next page

StandardAccountAssignment	CustomerIncludeStructure
FieldnameDescription	FieldnameDescription

StandardAccountAssignment	CustomerIncludeStructure
Field nameDescriptionFKBER- FunctionalareaGSBERBusiness areaMATNRMaterial	Field nameDescription ZZSPREGSpecialregion

第 86 页 / 共 509 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

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

BB148 S Generation report RFBIPPG0 executed for parked FI

documents

BB147 S Generation report RGUGBR00 executed for

validations/substitutions

BB054 SSubscreen9999hasbeengenerated

Continued on next page

第 87 页 / 共 509 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

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

第 88 页 / 共 509 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Thesetwonewfieldsshouldalsobeusedassenders. Inthesummarytable

ZxxTAB,enterthedataelementsZPREGIONandZPMATNRasthepartner

object.

a) Fields for ZxxTABO: Object table 1

Field NameData ElementKeySender

MANDTMANDTx

OBJNRGOBJNRx

BUKRSBUKRSx

ACCT RACCTx

BUSAGSBERx

FAREAFKBERx

ZZREGIONZREGIONx

MATNRMATNRx

3. Gototheobjecttable2andinsertthefieldRMVCT(dataelementRMVCT).

a) Table name: ZxxTABC: Object table 2

Field NameData ElementKey

MANDTMANDTx

OBJNRGOBNRx

LOGSYSLOGSYS

RMVCTRMVCT <<< (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

第 89 页 / 共 509 页

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.

第 90 页 / 共 509 页

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

第 91 页 / 共 509 页

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

第 92 页 / 共 509 页

UnitSummary AC220

第 93 页 / 共 509 页

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.

第 94 页 / 共 509 页

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.

第 95 页 / 共 509 页

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

第 96 页 / 共 509 页

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.

第 97 页 / 共 509 页

Unit 3

Setting Up the FI-SL Environment

ExplaintheworkingsoftheFI-SLSystem. ElaborateonthesettingsoftheFI-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.........................................................81

Exercise 3: Transfer Postings..............................................91

Lesson: Configuring the Ledger ...............................................95

Exercise 4: Ledger Assignments.........................................107

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

Demonstration: Demonstration of Ledger Assignment................120

Demonstration: Demonstration of Customizing Tools .................127

Exercise 5: FI-SL Customizing Tools 1..................................131

第 98 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

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

Comparison and Troubleshooting........................................137

第 99 页 / 共 509 页

AC220 Lesson: FI-SL Structure

Lesson: FI-SL Structure

Lesson Duration: 25 Minutes

Lesson Overview

Thislessonwillhelpyouunderstandhowtotransferdatatoandorganizedatain

specialpurposeledger. Youwillalsolearnabouttheconceptsofparallelledger

update and ledger master data.

Lesson Objectives

After completingthislesson, youwillbeable to:

• Transferdatatoandorganizedatainspecialpurposeledger

• Explainparallelledgerupdateandledgermasterdata

Demonstratehowtotransferdatatothespecialpurposeledgerandorganizethe

data. Explainparallelledgerupdateandledgermasterdata.

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. Thisfield(characteristic)mustbecreated,asitisnotdeliveredbySAP.

Afterthecharacteristicsandkeyfigureshavebeensortedlogicallyintogroupsfor

therequiredreports,databasetablesmustbegeneratedandinstalledforthevarious

FI-SLcomponentsbeforetheycanbemadeavailableforupdateandreporting.

Usingthenewlycreatedfield,SpecialRegion,andreportingdatabase,youneedto

setuptheFI-SLmasterdatatoenableFI-SLtablestobeupdated.

第 100 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

Transferring Data to and Organizing Data in Special

Purpose Ledger

Transferring Datato Special PurposeLedger

ShowstheSAPapplicationsthatcantransferdatatotheFI-SLsystem

Note the ‘dark’ figure’ substituting. Idea: derivation and substitution of data

possible.

Organizing Data in Special Purpose Ledger

Illustratesthetasksthe Integration Manager does:

Distributingthedataintological‘blocks’, ledgers, at theuser-determinedlevel

of detail

Interface Postings to FI-SL

Top-down presentation:

a) Feeder systems

b) Datasubjectedtopossiblevalidations/substitutions

c) The tableis the underlying ledger structure.

Thecompanycodeusesthisstructurebymeansofitsassignmenttotheledgerfor

themaintenanceofitstotals. Thecompanycodetransactiontriggersanactivity

thatisrelevanttothisledger. Bymeansofafieldmovement,thecharacteristics

forthiscompanycodeareselectivelyretrievedandstoredwiththeirbalances. A

possible ledger selection restrictstheselection of thedata. You canoptionally

write line item records for these totals.

第 101 页 / 共 509 页

AC220 Lesson: FI-SL Structure

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.

第 102 页 / 共 509 页

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.

第 103 页 / 共 509 页

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

Objectives: Varioustotalsformationoptions; differentdetailingstemmingfrom

report requirements. These aspects are explained in detail using thefollowing

graphics.

第 104 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

Figure 40: Parallel Ledger Update

Thesubdivisionofdataintoledgersenablesyoutosimultaneouslystoredataat

various levels of detail.

Ledger Master Data

LedgerMasterData(1&2): CurrencyandQuantityCombinations

Illustratesthemostsignificantspecificationstobemadeattheledgerlevel.

Figure 41: Ledger Master Data (1)

第 105 页 / 共 509 页

AC220 Lesson: FI-SL Structure

Whenyoucreatealedger,youmustdeterminethefollowing:

• Inwhichsummarytableistheledgerdatatobeupdated?

• Can the ledger be posted to?

• Can the ledger be used asa rollup ledger?

• Shouldtheledgerstorelineitems(thatis,forALLcompanycodes(orglobal

companies) that supply theledger withdata)?

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.

第 106 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

Figure 43: Ledger Master Data (2)

Youmustalsodefinethefollowingattheledgerlevel:

• iftheledgerbalancesaretobestoredintransactioncurrency,

• whichsecondand/orthirdcurrencyshouldbeupdatedandifthisappliesto

ALL company codes,

• thecurrencykey,iftheledgercurrencyisselectedastheadditionalcurrency

• ifcurrenciesandadditionalcurrenciesaretobestoredintheledger

• if balancesaretobemaintainedindebitandcredit

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

postingswhicharethenmadetopreviousyearperiodsthebalanceswillthen

automaticallybetransferredtothecarryforwardperiodofthefollowingyear

第 107 页 / 共 509 页

AC220 Lesson: FI-SL Structure

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.

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.

第 108 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

第 109 页 / 共 509 页

AC220 Lesson: FI-SL Structure

Exercise 3: Transfer Postings

Exercise Duration: 10 Minutes

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Prepare FI-SL for a transfer posting

• ExecutethetransferofanFIdocumenttoanFI-SLLedger

Business Example

BeforetheimplementationofFI-SLiscomplete, certainapplicationareassuch

as FI and SD go live. You must transfer the existing documents from these

applications to FI-SL.

Task:

Transfer Posting

1. 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.