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

第 33 页 / 共 509 页

AC220 Lesson: Overview of FI-SL

1. ShowwheretoactivatetheCostofGoodsSoldforaCompanyCode. Take

companycode1000 asan example: Menupath

2. Inmostcases,functionalareascanbeenteredineithertheexpenseaccounts,

in the relevant cost object master data, or in the cost center /order types.

Alternatively, a substitution can be used. Without going into the details

(Substitution logicwill beexplainedlaterintherelevant chapter), briefly

explain how the functional areas, manufacturing (0100, sales (0300),

administration (0400), and research and development (0500) can be

substituted as a derivation of the type of cost object, for example, cost

centerandorders,andthenpassedoverintheaccountingdocumentforuse

in the FI-SL system.

3. Executean FI-GL (FB01) posting toacost center of typeproductionand

acostcenteroftypeResearchandDevelopment: SAposting,today’sdate

for Co.Code 1000 :

PKAccount Tax Cde. Cost Cntr Amount

40 420000 4100 10,000 UNI

40 430000 4500 20,000 UNI

50 399999 V0

4. ShowtheFI-Doct,branchto“AccountingDocuments”,andshowtheposting

to the Ledger 0F (Single Item). Point out the fact that FI-SL hasits own

documentnumberingbutholdsthereferenceaccountingdoct.,too. Focuson

thesubstitutedfunctionalareaintheSingleItemsLine.

5. Execute another FI-GL posting using an order of type, sales(Order type

0400:e.g. Order 400177):

PK Account Tax Code Order Amount

40 476000 V0 400177 30,000 UNI

50 399999 V0 *

6. Gothroughthesameprocedureasintheaboveexample.

7. ExecuteaVendorInvoicePostinginFI.Thistime,thecostswillbepostedto

acostcenteroftypeadministration: SAposting,today’sdateforCo.Code

1000 : Vendor for 1000 is 1000. PK Vendor Amount Tax Code31 1000

40,000V1PKAccountAmountTaxCodeCostCntr40476000*V11000

8. Gothroughthesameprocedureasin Example4.

9. Show that in all the postings, the functional area isdetermined using the

functioned areas, which have been entered in the master records of the

corresponding cost objects. This is a more precise method compared to

thesubstitutiontechnique. Thepriorityofdeterminingthefunctionalarea

inapostingcanbeexplained. Seethenotebelowregardingtheprocedure

as from 4.6.

第 34 页 / 共 509 页

Unit1: FI-SL:SpecialReporting AC220

10. YoucannowentertheInformationSysteminFI-SLandexecutethePandL

report showingtheCost of Salesbreakdownbyfunctional areas. Choose

Ledger0F,Co.Code1000,currentperiod,currentyear,andplanversion0.

Showtheresultingtotalsandthebreakdownbythefourfunctionalareacosts

postedabove, drill down tothe SingleItems , and point out the structure

of the Line document and the FI-SL number. Repeat the procedure for

eachoftheFAREAtotals. Inaddition,gototheFIdocumentstoshowthe

participantstheoriginal cost object entered.

11. Toshowanotherexampleofaninterfacepostingtofillthe0Fledger,youcan

showaseriesofSalesandserviceposting,fromthecustomerorderthrough

arevenuepostingresultingfromabillingdocument.

Steps to follow:

a. Create a customer order:

Menupath:SelectLogistics→Salesanddistribution→Sales→Order→

Create.

Order type: OR (Germany TA)

Sales org.: 1000

Distribution channel: 10

Division: 00

Soldtoandshipped-toparty: 1000(BeckerBerlinCalvinstr. 36)

Purchase Order no.: e.g. 1234

Req.delivery date: today’s

Material: M-01

Quantity: 10 pc

Save and note the salesorder number. b.

Delivery: Go back totheSalesOrder:Subsequent functions→Outbound

Delivery.

Shipping point: 1200

Enterthesamesalesordernumberasenteredpreviously.

Menupoint: Subsequentfunctions→Createtransferorder

Save the delivery.

Warehouse number: 012

Plant: 1200

Deliverynumber: Already enteredbythesystem.

Click Background.

第 35 页 / 共 509 页

AC220 Lesson: Overview of FI-SL

Adoptpickquantity. Enter2(Includepick. Quantitiesindeliveryandpost

GI).

Follow the same steps for AQ (2).

PressEnter. Message: Transferorderxxxxxxxxxxcreated’.

SelectOrder→Display→Environment→Displaydocumentflow.

Pointto“GDgoodsissue:delvyxxxxxxxx”andselectMenuIcon“Display

documents.”

Showtheitemandthenselect→Accountingdocuments→Specialpurpose

ledger.

Choose Ledger 0F and show the single items.

Billing document:

Go back to the sales order and select Subsequent functions → Billing

document.

Save and note doct.no.

Menu: Billing document → Display → Accounting → Special purpose

ledger.

Choose Ledger 0F and show the single items updated from this billing

document.

12. Youcan then go back to runthesamereport from the FI-SL Information

Systemand showtheresultsofyour posting intheFI-SL P andL report.

Proceedin the same way asgivenin point 9.

13. Briefly describe how FI-SL acquires the information required to enable

the report output.

GotoFI-SLCustomizing-MasterDataandshowthefollowing:

a. Ledger 0F

b. AssignmentLedger0FandCompanyCode100(alternativeAC00)

c. Activities for the combination in b

d. Pickout the activityRFBU, goto the chosen Field Movement for this

activity,andshowthesenderACCIT_GLXandreceiverGLFUNCTfields

for this activity.

Note: Newfeaturefrom4.6onwardsfordeterminationoffunctional

areas. Upto4.0,theonlywaytoderivethefunctionalareaswasvia

thesubstitutiontechnique. Nowthefunctionalareacanbetagged

tovariousmasterdata. Thefollowingisasummaryof theonline

documentationandreleasenoteonthistopic:

第 36 页 / 共 509 页

Unit1: FI-SL:SpecialReporting AC220

Setting up cost of sales accounting

1. Define the functional areas.

2. ActivateCostofSalesAccountingforPreparation. Bydoingso, the

functionalareacannowbeenteredinthemasterdataforG/Laccounts,

costelements,ordertypes,andinternalordermasterdata.

3. Enterthefunctionalareainthemasterdataoftheindividualobjects.

4. You can define a substitution for deriving the functional area. You

shouldonlycompletethisstepifyourneedsforderivingthefunctional

areaarenotcoveredby theoptiontoenter thefunctionalareainthe

masterdataofseveralaccountassignmentobjects. Setupaledgerfor

costofsalesaccounting. Thecharacteristicfunctionalareaisin this

ledger, but not in the general ledger. (SAP delivers the following:

the Cost of Sales accounting Ledger 0F. Thisis preconfiguredasis

the field movement 0F00.)

5. ActivateCostofSalesaccountingforyourcompanycode. Whenthis

isactivated, thefunctionalareaswillbederivedfromallpostingsin

whichaPandLaccountoracostelement(forCOinternalpostings)

is assigned.

6. ThesystemcheckswhetheraCOobjectisassignedtoanaccount.Ifso,

thesystemcheckswhether afunctionalareaisenteredinthemaster

recordoftheassignedCOobject;ifafunctionalareahasbeenentered,

thesystemusesthisvalueasaprovisionalfunctionalarea.Thismeans

thattheobjectreceivingthecostsdeterminesthefunctionalareaunder

which the costs are posted.

7. Thesystemcheckswhetherafunctionalareaisenteredinthemaster

recordoftheG/Laccount orthecostelement.

Ifso,thisfunctionalareahashigherpriority: Afunctionalareaderived

fromthemasterrecordofaCOobjectisoverwrittenbythefunctional

area of theG/L account (or cost element).

ThehigherpriorityoftheG/Laccount(orcostelement)isjustifiedby

thefactthattherearepostingsforwhichthe“type”ofcostsdetermines

thefunctionalarea, andnottheassignedobject.

8. ThesystemcallsupthesubstitutionforthecomponentFI,event0005.

In the substitution, the user can define his or her own criteria for

derivingafunctionalarea,byusinguserexits,forexample.

The substitution has the highest priority: If a functional area is

determined from the substitution, this functional areaapplies. This

means that the functional area previously determined from the CO

object or cost element is overwritten.

Theprioritywhenderivingthefunctionalareaisthusasfollows: CO

object→PandLaccountorcostelement→Substitution

第 37 页 / 共 509 页

AC220 Lesson: Overview of FI-SL

Forsomepostings,suchaswhenenteringG/Laccountpostings,itispossible

toenterafunctionalarea. Thisfunctionalareaistransferreddirectlytothe

document,withoutthesystemrunninganyofthechecksdescribedabove.

第 38 页 / 共 509 页

Unit1: FI-SL:SpecialReporting AC220

第 39 页 / 共 509 页

AC220 Lesson: Overview of FI-SL

Exercise 1: Standard Ledgers and Special

Purpose Ledgers

Exercise Duration: 20 Minutes

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Namefiveapplicationareaswherestandardledgersareusedandstatethe

maindifferencesbetweenthesestandardledgersandspecialpurposeledgers

• List the main features of special purpose ledgers that go beyond the

restrictionsof standardledgersandprovideenhancementstothestandard

ledgers

• Executeareportgroupthatisdeliveredwiththestandardsystem,showinga

breakdownoftheprofitandlossstatement(costofgoodssold)byfunctional

areasanddisplaytheoriginaldocumentsforthefunctionalareacostsshown

in the report

Business Example

Mostoftheinformationforacompanyourcompanycomesfromotherapplication

areasandmustbereorganizedandprocessedfurthertoprovidesummarizeddata

inthe chosen combinationsin reporting. The concept and design of the FI-SL

componentmustbereviewedtodeterminewhetherornotitmeetsthesespecial

requirements.

Onespecificrequirementistoprovideabreakdownofthesecostsby“functional

areas,” such as manufacturing, administration, sales, and research and

development. CanFI-SLprovidethisinformationandtherequiredreports?

Task:

1. ListfiveapplicationareasforwhichSAPdelivers“standardledgers”.

____________________________________________________________

2. Howdo“specialpurposeledgers”differfrom“standardledgers”?

____________________________________________________________

Continued on next page

第 40 页 / 共 509 页

Unit1: FI-SL:SpecialReporting AC220

____________________________________________________________

3. Listafew“specialreportingrequirements,”whichcouldenableuserstouse

FI-SLasanenhancementtothestandardapplicationareasinAccounting.

____________________________________________________________

4. Postaninvoiceandcheckthederivedfunctionalarea.

Menu path:

SAPEasyAccess→Accounting→FinancialAccounting→Creditors→

Post → General Accounting (F-43)

Usetoday’sdateasthedocumentdateandpostingdate.

Document type: KR

Company code: AC##

Posting key: 31 Creditor: T-F00A00

Amount: 1160

Tax: 160 Tax code: VN Tax code: VN

Postingkey: 40G/Laccount: 471000 G/Laccount: 471000

Amount: 1000

Cost center: T-A20A##

Write down the document number.

Underwhichfunctionalareawasthedocumentposted?

第 41 页 / 共 509 页

AC220 Lesson: Overview of FI-SL

Solution 1: Standard Ledgers and Special

Purpose Ledgers

Task:

1. ListfiveapplicationareasforwhichSAPdelivers“standardledgers”.

____________________________________________________________

a) ThefiveapplicationareasforwhichSAPdelivers“standardledgers”

are:

1. General Ledger FI-GL

2. Legal Consolidation FI-LC

3. Profit Center Accounting EC-PCA

4. Reconciliation Ledger CO-CEL

5. Joint Venture IS-OIL

2. Howdo“specialpurposeledgers”differfrom“standardledgers”?

____________________________________________________________

a) Standard ledgers are configured and delivered by SAP. The data

model and specific functions for certain business requirements are

alreadyset in the individual applications.

Special purpose ledgers are user-defined ledgers for which you

specify attributes that correspond toyour businessrequirements. A

special purpose ledger is the only type of ledger you can create in

the FI-SL system.

3. Listafew“specialreportingrequirements,”whichcouldenableuserstouse

FI-SLasanenhancementtothestandardapplicationareasinAccounting.

____________________________________________________________

Continued on next page

第 42 页 / 共 509 页

Unit1: FI-SL:SpecialReporting AC220

a) Listafew“specialreportingrequirements,”whichcouldenableusers

to useFI-SL asanenhancement to thestandardapplication areasin

Accounting. You can usespecial-purposeledgers for thefollowing

purposes:

1. Toreportadditionalfields(→additionallevelsofdetail,totals

for specific field combinations)

2. To collect data selectively ( → activity assignment, ledger

selection)

3. Toupdatealternativechartsofaccounts(→operating,country,

corporate) and to use a non-calendar fiscal year ( → foreign

subsidiary, corporate group)

4. Tospecifyyourownperioddefinitions,suchasday,week,and

month,forwhichtotalsrecordsaretobewritten

5. To make evaluations that affect several applications and

organizationalunits,suchascompanycodes,companies,business

and controlling areas.

6. To make changes in FI-SL while updating the date, such as

substitutions and summarizations.

AdvantagesofUsingtheFI-SLSpecialLedgerSystem

The FI-SL system is a tool you can use to enhance the functions

availableinotherSAPapplications,suchasGeneralLedger(FI-GL),

Profit Center Accounting (EC-PCA), or Cost Center Accounting

(CO-CCA), without modifying the standard system. You can use

FI-SLtoaddcodingblockdimensionstoyourdatabasetables. Other

advantagesof theFI-SL system include:

FlexibleDatabaseStructureswithAdditionalFields

You cancreateyour owndatabasetablesanddefinedimensionsnot

availableinthestandardsystem,suchas“specialregion”,tomeetthe

specific business and reporting requirements. As a result, you can

compileandsummarizeinformationatthelevelofdetailyourequire

for any code combination.

Selective Data Collection

Data flowin FI-SL isvariable. Youcanassign activities tospecific

company code/ledger or company/ledger combinations to specify

whichledgersaretobeupdated. Youcanuseselectionconditionsto

limit the number of ledgers updated.

Adjustment Postings

Continued on next page

第 43 页 / 共 509 页

AC220 Lesson: Overview of FI-SL

In FI-SL, you can make adjustment or correction postings. For

example,youcanpostdataforadifferentversion. Adjustmentpostings

are used for amortization.

Alternative Charts of Accounts

Youcan use several chartsof accountsin FI-SL, suchasoperating,

corporate, andcountrychartsof accounts.

AlternativeFiscalYearandFiscalYearVariants

You can define your own periods in FI-SL. You can specify the

accountingperiods,thefiscalyear,andtheaccountingperiodsinthe

fiscal year.

You can use this function to report, for example, on a weekly or

monthly basis.

FI-SL-SpecificChangesinUpdatingData

ToensurethatonlyvaliddataisrecordedintheFI-SLsystem,youcan

usethevalidation and substitutionsoftwareto verify and/or replace

data when you enter the data.

SummarizationofLineItemInformationfromOtherSources

YoucanuseFI-SLtosummarize,modify,andoffsetplannedandactual

datafromotherSAPapplicationsandexternalsystems.

Cross-Application Reporting

YoucanusetheFI-SLsystemtoevaluateandreportdatafromvarious

SAP applications andorganizational units.

4. Postaninvoiceandcheckthederivedfunctionalarea.

Menu path:

SAPEasyAccess→Accounting→FinancialAccounting→Creditors→

Post → General Accounting (F-43)

Usetoday’sdateasthedocumentdateandpostingdate.

Document type: KR

Company code: AC##

Posting key: 31 Creditor: T-F00A00

Amount: 1160

Tax: 160 Tax code: VN Tax code: VN

Postingkey: 40G/Laccount: 471000 G/Laccount: 471000

Amount: 1000

Continued on next page

第 44 页 / 共 509 页

Unit1: FI-SL:SpecialReporting AC220

Cost center: T-A20A##

Write down the document number.

Underwhichfunctionalareawasthedocumentposted?

a) Menu path:

SAPEasyAccess→Accounting→FinancialAccounting→Creditors

→ Post →General Accounting (F-43)

Usetoday’sdateasthedocumentdateandpostingdate.

Document type: KR

Company code: AC##

Posting key: 31 Creditor: T-F00A00

Amount: 1160

Tax: 160Tax code: VN Taxcode: VN

Postingkey: 40G/Laccount: 471000 G/Laccount: 471000

Amount: 1000

Cost center: T-A20A##

Functional Area: 0400 was automatically determined from the cost

center.

第 45 页 / 共 509 页

AC220 Lesson: Overview of FI-SL

Lesson Summary

You should now be able to:

• UnderstandtheconceptofSpecialPurposeLedgeranditsobjectives

• DistinguishFI-SL from other SAP applications

• Describethe special reporting requirements

• Explain FI-SL with an example

第 46 页 / 共 509 页

UnitSummary AC220

Unit Summary

You should now be able to:

• UnderstandtheconceptofSpecialPurposeLedgeranditsobjectives

• Distinguish FI-SLfromother SAP applications

• Describethespecial reporting requirements

• Explain FI-SL with an example

第 47 页 / 共 509 页

AC220 Test Your Knowledge

Test Your Knowledge

1. TheadditionalprocessingfunctionsinFI-SLinclude:

Choosethecorrectanswer(s).

□ A Planning

□ B Data transfer

□ C Rollup

□ D Currency translation

2. What is FI-SL used for?

3. Giveany twousesof special-purposeledgers.

4. Forallexpensepostings,thefunctionalarea canbederived

from the existing account assignments.

Fillintheblankstocompletethesentence.

第 48 页 / 共 509 页

TestYourKnowledge AC220

Answers

1. TheadditionalprocessingfunctionsinFI-SLinclude:

Answer: A, C, D

TheadditionalprocessingfunctionsinFI-SLincludeplanning,allocations,

rollup, and currency translation.

2. What is FI-SL used for?

Answer: FI-SLisusedtocollectdatafromotherSAPapplications,suchas

FI,CO,MM,andSD,externalsystems,andFI-SLadjustmentpostingsfor

reporting purposes.

3. Give anytwousesof special-purposeledgers.

Answer: Special-purposeledgerscanbeusedto:

• Display reports about additional fields

• Collect selective data

• Updatealternativechartsofaccountsanduseanon-calendarfiscalyear

4. Forallexpensepostings, thefunctionalareaFAREAcanbederivedfrom

the existing account assignments.

Answer: FAREA

第 49 页 / 共 509 页

Unit 2

Table Definition Characteristics and

Key Figures

Demonstratehowspecialreportingrequirementslargelydependontheavailability

ofthecharacteristicsinthecodingblockforpostingsonsuchfieldstobepassed

over to the FI-SL system and within FI-SL itself. If you are lucky and have a

system to yourself, you may even decide to create a new coding block field

inthetest mode. Thisisnot obligatoryandit willsufficetoshowtheexample

of ZZSPREG (Special Region) and demonstrate how to create a new field in

the test mode.

Unit Overview

Inthisunit,youwilllearnhowtoincludenewfields(characteristics)intheSAP

codingblock. Theunitwillalsodescribekeyfiguresforbalances(amountsand

quantities). YouwillknowaboutthecomponentsthatmakeupFI-SLtables. You

willalsolearnhowtodefineandinstalltablegroupsinFI-SL.

Unit Objectives

After completing thisunit, you will beableto:

• Includeyourownfield(characteristic)inthecodingblockoftheSAPsystem

• Explainhowtousethebasicmodeandnamethestepsrequiredwhenusing

the expert mode

• Implement integrated consolidation

• Describe coding block field selection

• CreateanFI-SLtablegroupintheSAPRepository

• Describehowto usekey figuresand indices

• DescribehowtoinstallthetablegroupinFI-SL

Unit Contents

Lesson: Characteristics and Key Figures of Table Definition ..............33

Demonstration: Demonstration of FI-SL Table Group..................47

第 50 页 / 共 509 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Demonstration: Demonstration of key figures-1.........................48

Demonstration: Demonstration of key figures-2.........................49

Demonstration: Demonstration of Installation-1.........................55

Demonstration: Demonstration of Installation-2.........................56

Exercise 2: Characteristics and Basic Key Figures ....................59

第 51 页 / 共 509 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Lesson: Characteristics and Key Figures of Table Definition

Lesson Duration: 120 Minutes

Lesson Overview

Thislessonwillhelpyouunderstandhowtoincludeyourownfield,characteristic,

inthecodingblockoftheSAPsystem. Youwillgettoknowhowtousethebasic

modeandnamethestepsrequiredwhenusingtheexpert mode. Youwilllearn

howtocreateanFI-SLtablegroupintheSAPRepositoryandhowtoinstallthe

table group in FI-SL.

Lesson Objectives

After completingthislesson, youwillbeable to:

• Includeyourownfield(characteristic)inthecodingblockoftheSAPsystem

• Explainhowtousethebasicmodeandnamethestepsrequiredwhenusing

the expert mode

• Implement integrated consolidation

• Describe coding block field selection

• CreateanFI-SLtablegroupintheSAPRepository

• Describehowto usekey figuresand indices

• DescribehowtoinstallthetablegroupinFI-SL

Demonstratehowspecialreportingrequirementslargelydependnotonlyonthe

availabilityofthecharacteristicsinthecodingblockbutalsoonthestructuresof

thetablesthatholdthecharacteristiccombinationsandtheirbalances.

Onlyyouwillactuallyinstallthetablegroup. Theparticipantswilldefine,save,

andactivateatablegroupintherepositorybutNOTinstallit. Themainreason

for this is temporal.

Intheappendix,thetablegroupisillustratedinagraphicalsequence. Youmay

refertothisoptionally,dependingonthedegreeoftechnicaldetailtheparticipants

are interested in.

Business Example

Managementalsorequiresafield(characteristic)calledSpecialRegionthatcanbe

usedtoprovideanadditionalgeographicalbreakdownincertainfinancialreports.

Thisfield(characteristic)mustbecreatedasitisnotdeliveredbySAP.

Afterthecharacteristicsandkeyfigureshavebeensortedlogicallyintogroupsfor

therequiredreports,youneedtogenerateandinstalldatabasetablesforthevarious

FI-SLcomponentsbeforetheycanbemadeavailableforupdateandreporting.

第 52 页 / 共 509 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

SAP Coding Block

The Coding Block

Containsallthefieldsthatareaddressedbyatransactionorfunction.

Alternative Solutions

Stressthatbeforenewcodingblockfieldsarecreated,itmaybewisetoinvestigate

whether thealready existing fieldscan be used.

Possibilityofincludinganewfieldforanaccountassignment. Example‘Special

Region’.

Additional Fields

Possibilityofincludinganewfieldforanaccountassignment. Example‘Special

Region’.

Figure17: TableDefinition: Characteristics/BasicKeyFigures: Overview

第 53 页 / 共 509 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Figure 18: Alternative Solutions

Therearemanyfieldsinthestandardsystemthatmayfulfillyourrequirements.

Beforeyoudecidetochangethecodingblock, makesurethatthereisno other

solutioninthestandardsystemthatwillsatisfyyourrequirements.

Ifyoudonotfindanalternativesolution,youshouldcarefullyconsiderhowyou

want to use your new field.

Figure 19: Additional Fields

The account assignment block, also called the coding block, is a standard

componentdeliveredwiththeSAPsystem. Usersdonotautomaticallydealwith

coding blocks.

The transactions and components in the SAP system are based on the coding

block. Theblockdefinesallthefieldsusedinatransactionorfunction.

第 54 页 / 共 509 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

ThestandardSAPsystemcontainspredefinedfieldsthatcanbeusedforvarious

functions. Inmostcases,theuserdoesnotneedtodefinenewfields.

Theusercanaddafieldtothecodingblockifthenewfieldisrequired.

Theaboveexampleshowswhy it isnecessaryto addtheSpecialRegionfield

to the G/L document entry function.

Definitionofsuitablesubscreensthatcontainyournewfield

ThenewaccountassignmentfieldscanbeusedinFIGeneralLedger,Purchasing,

andInventoryManagement. Youcan,ofcourse,alsousethesefieldsinFI-SL.If

youdefineappropriatefieldmovements,thisinformationcanbetransferredtothe

FI-SLdatabase. Youcandefineupto18additionalaccountassignmentfields.

Field Maintenance

Field Maintenance: Steps

Statusupto3.0. ActivechangeswereneededintherepositoryandinSAPsystem

tables.

User-Defined Coding Block

Newtransaction: User-friendlyinterfacetotheinternalprocesses

Functions: Definitionofthefieldwith/withoutthevalidationtable,enhancement

ofthedatabasetables,BSEG,COEP,andMSEG,andinclusioninsystemcontrol

tables; subscreen definition

Availability for account assignments in FI G/L accounts, purchasing, and

inventory management postings

Basic Mode and Expert Mode

Basicmode: simpleinputdata: fieldname,fielddescription,datatype,andfield

length. No DDIC knowledge required.

Expertmode: Stepbystepsettingsintherepository: Thismodeisintendedfor

users with ABAP/4 Dictionary knowledge.

Field Maintenance: Steps

Expert mode:

1. Create a domain

2. Create a data element

3. IncludefieldascustomerIncludeinCOBOLandCOBOL_BI

4. Append to the BSEG structure

5. Generate a subscreen

Basic mode:

第 55 页 / 共 509 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Onlygeneralfieldentries: Thesubscreenthatcontainsthenewfieldisgenerated

automatically. A check table isnot generated.

Caution: Changestotherepositoryarecritical. Duetothis,youneedto

take the following points into account:

1. Toavoidpossibledatalossesincaseanerroroccurs,makeabackup

of data.

2. Standardmeansforpossible,subsequentchangesarenotavailable

3. Youcannotperformthefunctioninaproductiveclientbecausethe

changesareeffectivethroughoutthesystem.

4. Yourequiresomeauthorizationstoperformthisfunction.

Integration

1. FI G/L account postings

2. CO line items

3. MMpurchasing,changeinstockandinvoiceverification

4. IfthenewfieldsareneededinFI-SL,youneedtodefineacorresponding

FI-SLtable(tablegroup)intherepositoryandtheninstallthetableinFI-Sl.

ThenewfieldsarethenavailableforFI-SLactivities.

Note: InCSS,thereareusefulnotespertainingtothetopic,CodingBlock.

Notesearch: Applicationarea: FI-SL-COBor asafurther search(old)

XXCOBL Coding Block

TheIMGandonlinedocumentationalsoprovideusefulinformation.

Coding Block Field Selection

Standard applications take from the coding block only those combinations of

fields that meet the predetermined information requirements. In contrast, the

FI-SLsystemallowsyoutoretrieveanyfieldandanycombinationofthatfieldin

thecodingblockenteredinatransactionandpassthemonintheformneededfor

specific customer reporting requirements.

第 56 页 / 共 509 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Figure 20: Field Maintenance: Steps

Previously,itwasproblematictochangethecodingblocktoaddanewfield.

You needed extensive knowledge of how to maintain the Data Dictionary

(Repository) and system tables.

Thenewcodingblockmaintenancetransactionisauser-friendlytool.

Youusethisfunctiontomaintaincross-clientobjects. Thismeansthatanychanges

madetotheseobjectsaffectalltheclientsinthesystem.

Thenewfieldisapermanentadditiontothecodingblock.

In the Expert Mode:

• Createdomain: Technicalinformationsuchasthelengthandfieldtype. If

required, youcanenter fixedvaluesforthesedomainsor specifyacheck

table.

• Create data element: Conceptual description of a field. For example,

account number and account type.

• Insertfieldinthecustomizing includeCI_COBOL for thetablesrelevant

for the coding block and in CI_COBOL_BI for use when entering an FI

document in background processing.

• InsertattheendoftableBSEGforFIG/Laccountpostings.

Inthebasicmode,youonlyneedtoentergeneralfieldinformationsuchasname,

description, and field type.

Inthelaststepoftheexpertmode,youmustgenerateasubscreenthatcontainsthe

newfield. Thesystemautomaticallygeneratesthissubscreeninthebasicmode.

第 57 页 / 共 509 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Figure 21: C A U T I O N ! !

Youcanusethisnewtransactiontoaddyourownfieldtothecodingblockwithout

havingspecialknowledgeoftheDataDictionaryorsystemtablemaintenance.

The following functions are available:

Defineanewaccountassignmentfieldwithorwithoutachecktable

Addanewfieldtodatabasetables(BSEG,COEP,andMSEG)andaddentriesto

the appropriate system control tables.

The new fields are added to the existing tables in the Data Dictionary. These

changes are critical and can lead to a loss of data if not carried out properly.

Remembertosaveyourdatabeforeyouexecutethisfunction.

When you adda newfield, you need not convert any databasetables. It isnot

possibletomakeallthechangesthatrequireaconversion. Forexample,making

subsequentchangestotheformatofanexistingfieldordeletingafieldusingthe

standardfunctions. Thistypeofchangemayleadtoalossofdata.

Any changes you make are effective throughout the SAP system. To use this

function, you need your own test system. As soon as a client is marked as a

productionclientintableT000,thisfunctionislockedfortheentiresystem.

Toperformthisfunction,yourequirethefollowingauthorizations:

• X_COBL_MOD:Toaddfieldstothecodingblock

• S_TABU_CLI: Tomaintain cross-client tables

• S_DEVELOP: To maintaintheDataDictionary

• S_TRANSPRT: For the transport

第 58 页 / 共 509 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Figure 22: Integrated Consolidation

ThenewfieldcanbeusedbythefollowingSAPcomponents:

• FI: G/L account postings.

• CO: The account assignment field is transferred to CO using the FI

document line.

• MM:Purchasing,InventoryManagement,InvoiceVerification.

• SD:ManualCustomizing: SalesandDistribution/systemcustomization/user

exits.

• EnjoySAP transactions Note: 174413.

IfthefieldisalsoaddedtoFI-SLtables,allthefunctionsintheFI-SLsystemare

availableto thisfield. Thesefunctions include:

• FI-SL postings

• Planning

• Allocations

• Rollups

• Balance carryforward

• Reporting

第 59 页 / 共 509 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Figure 23: Coding Block Field Selection

AnimportantadvantageofFI-SLisinthecapabilitytomanagemultipleaccount

assignments and structures. With every posting in a highly integrated system,

quiteadealofadditionalassignmentsareincludedinmostbusinessactivities. A

largeproportionoftheseassignmentsareintendedtomeetthedemandsofspecial

applicationareas,suchasgeneralledgerandManagementAccountingthattake

only the required information.

Controllingrequiresinformationrelatingtothecontrollingarea,thecostobjects

involved,andthecostelement. TheGeneralLedgerneedsinformationpertaining

to the general ledger account.

The FI-SL System extracts out of the coding block any number of the

characteristics made available in a posting to update these combinations and

providetherelationshipsandlevelofdetailneeded. Thesemaygowellbeyond

thespecificrequirementsoftheotherapplicationareas.

FI-SL Table Group

GeneraldisplayFI-SLtabletypes. Thesewillbedescribedoneaftertheother.

Grouping Characteristics in Tables

第 60 页 / 共 509 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Startingfromthereportrequests,youshouldfirstdeterminewhichuser-defined

characteristicsarerequired. Characteristicsthatareevaluatedtogetherregarding

theircombinationsandtheircomparabilityfromabusinesspointofviewandin

reportsshouldbeincludedinatablegroup(‘related’collectionofobject,totals,

and line item table).

Number of Database Records

Performanceandstoragespacecriteria: Numberofthecharacteristiccombinations

in one or more table group(s).

Summary Table: Actual Balances

Storageofthesummaryactualbalancesinthetotalstable(-T).

Summary Table: Object and Partner

Sender fields and receiver fields.

Summary Table: Plan Balances

Theupdateofplanbalances(manualFI-SLplanningorthrough-postingfromCO).

Transaction Attributes

Transactionattributes. Fieldsthatdonothaveareceiver/senderrelationship.

Table Group Definition (1-3)

Thedefinitionofarelatedgroupoftablesiseasierthanthedefinitionofindividual

tables. Youonlyhavetomaintaintheobjecttable(s). Theothersaremaintained

automatically. Whenyoumaintainthegroup,theconsistenciesofallthetablesin

thegroupandtheirrelationshiptooneanothercanbecheckedanytime.

Definition: Technical Specifications

Here, youcanset for thegrouptherequiredcurrencyfieldgroupsandquantity

field groups, the field length for currency fields and quantity fields, and the

maximumnumber of periodsperrecordfor thegroup.

第 61 页 / 共 509 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Figure 24: FI-SL Table Group

ThedatayousendtoFI-SLisstoredinagroupoftables. Thesearethefollowing:

• Object Table 1: Stores the characteristics you need and also an object

number for these characteristics as receiver and sender. For example,

receiver account RACCT andpartner SACCT.

• Object Table 2: Is optional and contains characteristics that are (fixed)

transaction attributes and have no receiver/sender relationship, such as

ControllingareaKOKRS.Forthesetransactionattributes,anobjectnumber

is also stored.

Theseobjectnumbersdeterminehowthesummaryandlineitemtableswill

be accessed through the object tables.

• SummaryTable: Storestheactualandplantotalbalances.

• LineItemTables: Storesthedocument information(actual/plan)for the

totals stored in the Summary Table.

第 62 页 / 共 509 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Figure 25: Grouping Characteristics in Tables

An implementation of FI-SL is recommended only if your special reporting

requirementscannotbecoveredbythestandardSAPapplications.

WhenyouhavedecidedtouseFI-SL,youshouldanalyzethecharacteristicsyou

needtouseandcombinetogetherforreports. Bygroupingtogetherdimensions

in different table groups, you can improve the system performance and save

storage space.

Figure 26: Number of Database Records

From aperformancepoint of view, the read time maybelonger, especially for

periodicprocessingandinreporting,ifyouhavealargenumberofdatarecords.

第 63 页 / 共 509 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Itisthereforeadvantageoustouseseveral tablegroups.

Figure 27: Table Group Definition (1)

Usingthe“Definetablegroup”function,youcancreateacompletetablegroup.

Youcandefinethevariablecharacteristicsfortwoobjecttables.

Thesystemautomaticallygeneratesthetables,suchasthesummarytable,actual

lineitemtable,andplanlineitemtable,assignedtotheseobjecttables.

Figure 28: Table Group Definition (2)

第 64 页 / 共 509 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

TheDefinetablegroupfunctionavoidsredundantmaintenanceofobjecttables

andtheirdependenttables. Onlytheobjecttable1(andobjecttable2,ifrequired)

is maintained.

You can specifyif a sender characteristic isrequiredfor a characteristicof the

objecttableinthesummarytable,actuallineitemtable,andplanlineitemtable.

Usethesesendercharacteristicsifyouwanttosavethesenderinformationforan

assessmentordistributioninanallocation. Forexample,ifyouwanttoexecute

a distribution between cost centers, you can save the sender cost center in the

data record.

Importantinformationforsummarytablesandlineitemtablesisderivedfromthe

object table.

Figure 29: Definition: Technical Specifications

Usingthe“Extras→Technicalcharacteristics”function,youdefinethecurrencies

andquantitiesrequiredinyourledger. Tosavestoragespace,youshoulddeselect

allthecurrenciesandquantitiesthatyoudonotwanttouse.

Inthe“Maximumnumberofperiods”field,enterthemaximumnumberofperiod

fieldsperrecord. Thedefaultvalueis16periods,consistingof12periodsandfour

specialperiods. If youwanttostorethedataonaquarterlybasis, for example,

enter‘4’. Fora12periodbasiswithoutspecialperiods,enter‘12’.

Inthe“Fieldlength”field,youdeterminethelengthofthecurrencyandquantity

fields depending on the anticipated length of the amounts to be entered. You

canenterfieldlengths15and17. Youshouldcheckthelengthofthemaximum

amount and quantity and define the respective fields accordingly. If you use

smallerfieldlengths,youwillonceagainsavestoragespace.

第 65 页 / 共 509 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Demonstration: Demonstration of FI-SL Table Group

Purpose

To demonstrate the FI-SL Table Group

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. Before you start with the actual definition, you can provide a graphics

displayofthetablegroupinFI-SLCustomizing(BasicSettings→Tables

→ Display Assignments Graphically). Use GLFUNCT as an example

anddisplay thegroup andtherespectivefields(possiblyalsotheindices,

althoughthistopicisdealtwith separatelylater).

For amoreintensiveand technicaldescriptionofthetables, youcanalso

refer to the appendices and the graphics there on the tables in the table

group. ThisisOPTIONALanddependsonhowTECHNICALLYinterested

the participants are.

Key Figures

For the characteristic combinations needed in FI-SL, the balancesareheldfor

up to five key figures:

• The original (document) currency amount

• A second and third currency amount

• A quantity and an additional quantity

An example of a second and third currency may be Local (Co.Code/Global

Company)currencyandGroupor LedgerCurrency.

Theratesfromthecurrencytable(usuallyMrate)willdeterminethetranslation

at thetimeof postingfromTCurr toLcurr toGcurr.

第 66 页 / 共 509 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Figure 30: Key Figures

For the combination(s) of characteristics selected, the FI-SL system stores the

balances in the following key figures:

• TransactionCurrency; thecurrencyofthedocument

• A secondand third currency dependingonthecurrenciesselectedforthe

ledgers(companycode,company,controllingarea,andgroup)

• Quantity and additional quantity

Demonstration: Demonstration of key figures-1

Purpose

To demonstrate the key figures

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. Steps:

Menu: FI-SLCustomizing→Basicsettings→MaintainCodingBlock

Read the note for the participants. Point out the corresponding

Implementation Guide.

Continue

第 67 页 / 共 509 页

AC220 Lesson: Characteristics and Key Figures of Table Definition

Double-click to display the existing standard SAP account assignments

andcustomerfieldZZSPREGinCI_COBL.Thelatteralsowithtechnical

view (that is, DDIC entry).

Demonstration: Demonstration of key figures-2

Purpose

To demonstrate the key figures

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1.

Note: Thenewfield,ZZSPREG,hasalreadybeendefinedinthe

system and been included as the newcoding blockfieldtogether

with the Basic mode!!

Normally,youshouldnotincludeanewfieldinthecodingblockunlessyou

are the only one working on the system.

Asanexample,itshouldsufficetocarryoutatestrunintheBasicmodeto

displayandexplainthelogandtoexplaintheentriesfortheexpertmodethat

willbenecessaryfortheDDICsettingsifyouexecutedsucharun.

Steps:

Menu: FI-SLCustomizing→Basicsettings→MaintainCodingBlock.

Suggestion: Example of a newaccount assignment field you caninclude

in the test run Basic mode:

Licensenumber: Aleasingcompanywantstocalculatetheoverheadcosts

fortheircarpoolandrunstatisticalevaluationsonitinFI-SL.

AlternativelyLandCodeforRevenueproductpostings(originalcountry):

Enter the following:

第 68 页 / 共 509 页

Unit2: TableDefinitionCharacteristicsandKeyFigures AC220

Fieldname zzlicense or zzldcode

Fielddescription Licensenumber LandCode

Datatype char char

Fieldlength 10 4

TEST RUN!

YoucandisplaythesameinformationforZZSPREGinthealternativemode

fortheindividualpointsoftheindividualmessages.

These are the actions that are carried out by means of the coding block

functionwiththeproductionrunintherepository:

Menu: FI-SLCustomizing→Basicsettings→MaintainCodingBlock→

Continue: User-definedaccount assignments; customerincludestructure;

CI_COBL; ZZSPREG; field information:

Howmuch you showof the following isoptional, dependson the time

schedule,andiftheparticipantsaretechnicallyinterested. Youshould,in

anycase,showinthesystemthosepointsinboldlettering.

1. SE11: ShowCI_COBLwithZZSPREGentry

2. SE11: ShowCI_COBL_BIwithZZSPREGentry

3. SE11: ShowBSEGwithZZSPREG(lastentry)

4. SE16: DisplayTCOBM.ZZSPREGModifno. 133

5. SE16: Display TCOBF. ZZSPREG

6. SE16: TMODO.TMODUandTMODPforthefieldselectionoptions,

posting key/account

For this, showthefollowinginFI Customizing:

Menu: →Customizing→IMG→FinancialAccounting→GeneralLedger

Accounting→BusinessTransactions→G/LAccountPosting→Carryout

or check document settings:

This can, however, be shown later before you execute the revenue

postingsintheUnit“ThroughPostingsandAdjustments”.

Define posting key → 40 Debit posting → Maintain field status →

Additionalaccountassignments→lastfieldZZSPREG.

In case you decide to actually define a new field in the system, you can

show the same entry for this.

ThenshowMaintainfieldstatusvariantsasabove,uptoadditionalaccount

assignmentsandshowthesettingforZZSPREG.GroupDOC1forCCode

1000 is a sample setting.

Fieldname	zzlicense	zzldcode
Fielddescription	Licensenumber	LandCode
Datatype	char	char
Fieldlength	10	4