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

第 153 页 / 共 509 页

AC220 Lesson: Line Items and Customizing Tools

SelectProposaltochoosetheappropriatereceiverandsenderfieldsforthe

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

specialregion(RZZREGION),andmaterialnumber(RMATNR).Saveyour

field movement.

a) Additional Field Movement

IntheFI-SLmasterdata,createafieldmovementSPxx.

Fieldmovement: SPxx(xx=groupnumber)

FieldmovementSPxxFI-SLpostingsforgroupXX

Receiver table ZSLTABT

Sender table GLU1

ReceiverField SenderTable Sender Field

RACCT GLU1 RACCT

RBUSA GLU1 RBUSA

RFAREA GLU1 RFAREA

RMATNR GLU1 RMATNR

RZZREGION GLU1 RZZREGION

UsetheRversionforeachsenderandreceiverfield.

Save your field movement.

4. Graphical Navigation

ToenableenteringadjustmentpostingsinFI-SLatalaterstage,selectthe

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

yourgroupnumber),toallowtheAccount,BusinessArea,FunctionalArea,

SpecialRegion,andMaterialNumberfieldstobeupdated.

Callthegraphicalnavigationfunctionandenteryourledgerwiththeposting

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

activityRFBUforyourcompanycode. TheChangeLedger: AssignActivity

screen appears.

SelectChooseactivitiesanddouble-clicktheactivityRGL0.

Continued on next page

135

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

第 154 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

EnteryourfieldmovementSPxx. Setthepostingindicatorto1andselect

RequiredpostingfortheactivityRGL0. SaveyourentriesandclickEXITto

returntothegraphictocheckyour newsettings.

a) Graphic Navigation

In the menu, select:

SAPReferenceIMG→Financial Accounting→SpecialPurpose

Ledger→Tools→UseGraphicNavigation

Selection of view and parameters:

x Ledger Your Ledger

Posting status:

x Direct posting

Onceyouhavemade theseentries, double-clicktheactivityRFBU,

assigntheactivityRGL0toyourledger/companycodecombination

andaddthefieldmovementSPxx(xx=yourgroupnumber).

Activity Field Movement Required

RGL0 SPxx x

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

activity RGL0 was assigned.

136

第 155 页 / 共 509 页

AC220 Lesson: Line Items and Customizing Tools

Exercise 6: FI-SL Diagnostic Tools for

111

Checking Postings, Ledger Comparison

and Troubleshooting

Exercise Duration: 20 Minutes

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Check postings with diagnostic tools

• ComparetotalsrecordsinanFI-SLledgerwiththoseinthegeneralledger

• Troubleshoot records that are not posted

Business Example

SeveraldiagnostictoolsareavailableinFI-SLtohelpyoucheckpostings. You

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

postingarecorrect. Ifthepostingsarenotcorrect,youcandeterminethesettings

that must be changed.

Task:

To open the diagnostics:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger→

Tools → Perform Diagnosis

1. Diagnosis Tool: Direct Posting Statistic:

Check the ledgerstowhichitemswereposted.

2. Ledger Comparison

In the menu, select:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger

→ Tools → Compare Ledgers

CheckthepostingsyoumadetoyourledgerinFI for yourcompanycode

inthecurrentperiodandfiscalyearwiththepostingsmadetothegeneral

ledger. Notedown the differences, if any.

Base ledger selection data:

Ledger: 0

Version: 1

Your company code

Continued on next page

137

第 156 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

Current fiscal year and period

Comparison ledger: Your ledger and version1

Accounts to check:

140000

420000,421000,430000,431000,472000,476000

810200, 810300, 810400

399999

Note downanydifferences andtheir causes:

Acct. No. Amount (your Amount in Reasonfordifference

ledger) G/L

3. Troubleshooting

InFI-SLCustomizing(masterdatamaintenance),selectyourledgerandset

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

posting). Save your entries.

Executeageneralledgeraccountpostingforyourcompanycode:

PK Account TaxCode Amount CostCenter

40 476500 V0 5000 T-A20EXX(XX=Groupno.)

50 399999 V0 5000

Write down your FI document number:

FI document number: _________________

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

which postings have been made.

Ifyourledgerisnotlisted,carryouttheFI-SLTroubleshootingdiagnostic.

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

blockingindicatorforledger/companycodeassignment. Saveyourentries.

138

第 157 页 / 共 509 页

AC220 Lesson: Line Items and Customizing Tools

Solution 6: FI-SL Diagnostic Tools for

Checking Postings, Ledger Comparison

and Troubleshooting

Task:

To open the diagnostics:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger→

Tools → Perform Diagnosis

1. Diagnosis Tool: Direct Posting Statistic:

Check the ledgerstowhichitemswereposted.

a) Diagnosistool: Direct posting statistic:

Check the ledgers posted for:

Origin of original document:

X Financial accounting

Posting status

X Direct posting

Select Direct posting stat.

Document number: xxxxx

Fiscal year: Current year

Companycode: YourcompanycodeACXX

2. Ledger Comparison

In the menu, select:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger

→ Tools → Compare Ledgers

CheckthepostingsyoumadetoyourledgerinFI for yourcompanycode

inthecurrentperiodandfiscalyearwiththepostingsmadetothegeneral

ledger. Notedown the differences, if any.

Base ledger selection data:

Ledger: 0

Version: 1

Your company code

Current fiscal year and period

Continued on next page

139

第 158 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

Comparison ledger: Your ledger and version1

Accounts to check:

140000

420000,421000,430000,431000,472000,476000

810200, 810300, 810400

399999

Note downanydifferences andtheir causes:

Acct. No. Amount (your Amount in Reasonfordifference

ledger) G/L

a) Ledger Comparison

In the menu, select:

SAPReferenceIMG→Financial Accounting→SpecialPurpose

Ledger→ Tools →Compare Ledgers

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

companycodeinthecurrentperiodandfiscalyearwiththepostings

madetothegeneralledger. Notedownanydifferences.

Base ledger selection data:

Ledger: 0

Version: 1

Your company code

Current fiscal year and period

Comparisonledger: Yourledger andversion1

Accounts to check

140000

420000,421000,430000,431000,472000,476000

810200, 810300, 810400

399999

Note downanydifferencesandtheir causes:

Continued on next page

140

第 159 页 / 共 509 页

AC220 Lesson: Line Items and Customizing Tools

Acct. Amount (your Amount Reasonfordifference

No. ledger) inG/L

140000 Not planned for the

ledgerselectionrule

399999 active for the activity

RFBU,

which was selected for

your

ledger/companycode

combination

Option:

4xxxxx Possiblyusedinthe

8xxxxx wrongcombination

withfunctionalarea/

material number

3. Troubleshooting

InFI-SLCustomizing(masterdatamaintenance),selectyourledgerandset

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

posting). Save your entries.

Executeageneralledgeraccountpostingforyourcompanycode:

PK Account TaxCode Amount CostCenter

40 476500 V0 5000 T-A20EXX(XX=Groupno.)

50 399999 V0 5000

Write down your FI document number:

FI document number: _________________

Use the FI-SL Posting statisticsdiagnostics tool to view the ledger(s) to

which postings have been made.

Ifyourledgerisnotlisted,carryouttheFI-SLTroubleshootingdiagnostic.

Continued on next page

141

Acct. No.	Amount (your ledger)	Amount inG/L	Reasonfordifference
140000			Not planned for the ledgerselectionrule
399999			active for the activity RFBU, which was selected for your ledger/companycode combination
Option:
4xxxxx			Possiblyusedinthe
8xxxxx			wrongcombination withfunctionalarea/ material number

第 160 页 / 共 509 页

Unit3: SettingUptheFI-SLEnvironment AC220

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

blockingindicatorforledger/companycodeassignment. Saveyourentries.

a) Troubleshooting

In the menu, select:

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

ReferenceIMG→FinancialAccounting→SpecialPurposeLedger

→ Tools → Perform Diagnosis

Origin of original document:

Financial Accounting

Posting status:

Direct posting

Select Troubleshooting.

FI document number: xxxxx

Companycode: Your company codeAcxx

Fiscal year: Current year

Ledger: Your ledger

Message:

Thecombinationledger(yourledger)/companycodeACXXisblocked.

Delete this assignment.

SelectExecute,settheblockingindicatorto1andsaveyourentries.

142

第 161 页 / 共 509 页

AC220 Lesson: Line Items and Customizing Tools

Lesson Summary

You should now be able to:

• Explain line items

• Use the tools to check your set up

143

第 162 页 / 共 509 页

UnitSummary AC220

Unit Summary

You should now be able to:

• Transferdatatoandorganizedatainspecialpurposeledger

• Explainparallelledgerupdateandledgermasterdata

• Describetheprocedureto configurea ledger

• Explaintheconceptsofcompanycode,company,ledger,activity,andfield

movement

• Explain line items

• Use the tools to check your set up

144

第 163 页 / 共 509 页

AC220 Test Your Knowledge

Test Your Knowledge

119

1. The system groups together the various accounting transactions into

Fillintheblankstocompletethesentence.

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

centers or profit centers.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

3. Howmany versionscaneachrecordtypehave?

Choosethecorrectanswer(s).

□ A 99

□ B 999

□ C 9

□ D 9999

4. Thesmallestorganizationalunitinexternalaccountingforwhichacomplete

self-containedsetofaccountscanbedrawnupforthepurposesofexternal

reporting isa .

Fillintheblankstocompletethesentence.

5. The individual activities from other applications are combined into

Fillintheblankstocompletethesentence.

6. Whatarethetwotypesofspecialpurposeledger?

7. The providesanoverviewoftheFI-SLdirect

postingtablesandacompletelogofthemostimportantcustomizingentries.

Fillintheblankstocompletethesentence.

145

第 164 页 / 共 509 页

TestYourKnowledge AC220

8. Youcanchooseafunctionin ,which

allowsyoutosummarizethelineitemsupdatedinaledger.

Fillintheblankstocompletethesentence.

146

第 165 页 / 共 509 页

AC220 Test Your Knowledge

Answers

121

1. The system groups together the various accounting transactions into

ACTIVITIES.

Answer: ACTIVITIES

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

centers or profit centers.

Answer: False

TheCostAccountingmodules(CO) transmitrelevant dataaboutcostson

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

3. Howmany versionscaneachrecordtypehave?

Answer: B

Each recordtype can haveupto 999versions.

4. Thesmallestorganizationalunitinexternalaccountingforwhichacomplete

self-containedsetofaccountscanbedrawnupforthepurposesofexternal

reporting is a company code.

Answer: company code

5. Theindividualactivitiesfromotherapplicationsarecombinedintoactivity

groups.

Answer: activity groups

6. Whatarethetwotypesofspecialpurposeledger?

Answer: Therearetwotypesofspecialpurposeledgers:

• Localledger: UsestheorganizationalunitCOMPANYCODE

• Globalledger: UsestheorganizationalunitCOMPANYID.

7. ThecontrolreportprovidesanoverviewoftheFI-SLdirectpostingtables

andacompletelogofthemostimportantcustomizingentries.

Answer: control report

147

第 166 页 / 共 509 页

TestYourKnowledge AC220

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

summarizetheline itemsupdatedin aledger.

Answer: ledger maintenance

148

第 167 页 / 共 509 页

Unit 4

Direct Postings and Adjustments

123

Demonstratetheprocedureofposting. Explainhowtomakeadjustmentpostings

totheledgers. Consolidatetheknowledgeofthesettingsgainedintheprevious

unit. TestthepostingsusingtheFI-SLCustomizingtools.

Unit Overview

Thisunitwillexplaintheprocedureof postingthroughandmakingadjustment

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

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

Customizing tools.

Unit Objectives

After completing thisunit, you will beableto:

• Set upmaster datafor characteristicsusedforpostingsandusetheFI-SL

direct entry function

• Create auser table for FI-SL applications

• CallanddisplaylineitemsandsummaryrecordsinFI-SL

Unit Contents

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

Demonstration: Demonstration of an FI-GL Posting...................153

Demonstration: Demonstration of an FI-GL Posting...................162

Demonstration: Revenue Postings to Special Regions and Products

(Customer Invoice posting)................................................163

Demonstration: Demonstration of Master Data Validation............167

Demonstration: Demonstration of the Document Types in FI-SL....169

Demonstration: Demonstration of Valid Versions ......................169

Demonstration: Demonstration of User Table ..........................170

Demonstration: Demonstration of FI-SL Actual Postings Document

Display.......................................................................173

149

第 168 页 / 共 509 页

Unit4: DirectPostingsandAdjustments AC220

Demonstration: Demonstration of Posting Statistics...................174

Demonstration: Demonstration of Troubleshooting....................175

Demonstration: Demonstration of Graphic Ledger Comparison .....175

Demonstration: Demonstration of Graphic Transfer Posting .........176

Demonstration: Demonstration of Posting and Revaluation Run....180

Exercise 7: FI Postings....................................................185

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

Totals Records..............................................................197

150

第 169 页 / 共 509 页

AC220 Lesson: Adjustment Postings in FI-SL

Lesson: Adjustment Postings in FI-SL

Lesson Duration: 45 Minutes

124

Lesson Overview

This lesson explains how to set up masterdata for the characteristics used for

postingsintheFI-SLsystem. ThelessonwillcoverhowtousetheFI-SLdirect

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

FI-SLapplications. Thelessonalsoexplainshowtocall anddisplaylineitems

and summary records in FI-SL.

Lesson Objectives

After completingthislesson, youwillbeable to:

• Set upmaster datafor characteristicsusedforpostingsandusetheFI-SL

direct entry function

• Create auser table for FI-SL applications

• CallanddisplaylineitemsandsummaryrecordsinFI-SL

Demonstratehowtosetupmasterdataforcharacteristicsusedforpostingsand

usetheFI-SLdirectentryfunction. ExplainhowtocreateausertableforFI-SL

applications. Demonstratehowtocallanddisplaylineitemsandsummaryrecords

in FI-SL.

Business Example

YourCompanyhasafairlyrichmanagementreportingrequirement. Mostofthe

informationneededcomesfrom other application areasbutmust be regrouped

andfurtherenhanced. Insomecases,theinformationmustberefinedtoprovide

summarizeddatainchosencombinations. Themanagementalsorequiresafield

(characteristic)calledSpecialRegion,whichcanbeusedtoprovideanadditional

geographicalbreakdownincertainfinancialreports. Thisfield(characteristic)has

beencreatedbecauseitwasnotdeliveredbySAP.Yousometimesneedtomake

adjustmentpostingsinFI-SLforspecialregions,toadjustrevenuesforproducts

thathavebeenevaluatedasstandard. Youneedtoanalyzethedirectentryfunction

in FI-SL for this purpose.

151

第 170 页 / 共 509 页

Unit4: DirectPostingsandAdjustments AC220

Overview and Example of FI-SL

FI-SL Update Example

UpdateinaFI-SLsummarytable. ThestartingpointisanFIG/Laccountposting.

Dataflow: Aselectedactivityistransferredattheinterfaceandtherequiredfields

aretransportedbymeansofafieldmovementandupdatedinaFI-SLsummary

table in the corresponding totals form.

Figure 70: Through Postings and Adjustments: Overview

Figure 71: FI-SL Update Example

152

第 171 页 / 共 509 页

AC220 Lesson: Adjustment Postings in FI-SL

This exampledemonstrates how data from a general ledger account posting is

updated in a FI-SL summary table.

Demonstration: Demonstration of an FI-GL Posting

Purpose

To demonstrate an FI-GL Posting

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. PerformanFI-GLpostingthistimewiththreeorfourofthesametypesof

posting. Yourcostcentersarethetypessales,administrationandresearch

anddevelopmentT-A20A00,T-A20B00andT-A20E00,Co. CodeisAC00

andtheOffsetpostingistoAccount399999withTaxcodeV0. Continue

withtherestofthelinepostingswithFB01. Youshoulddemonstratehowto

usetheappropriateAccountAssignmentModelGL-SL01forthisposting

(see ‘Preparation in the System‘)

ShowtheaccountingdocumentsandZSL-Updateandconcentratethistime

ontheAccountingDoct. NumberandthenumberthatFI-SLassigns.

Adjustment Postings and Entering Documents

Preview to Master Data Validation

The next foliodemonstratesthree waystoensurehow, within FI-SL,postings,

especially to newcharacteristics, youcan ensure validity of valuesentered for

them.

Since the following exercise will entail postings to special regions in FI A/R

Customer Invoice postings, thevalid valuesfor this field will beneeded there

for the initial postings.

Naturally,forFI-SLinternalpostings,youcanaccessthevalidvaluesinthesame

value table. This will certainly be the case for allocations, planning, and the

retrieval of texts for the report writer.

HowthisisdonewillbeshownpriortoadjustmentpostingsinFI-SL.

153

第 172 页 / 共 509 页

Unit4: DirectPostingsandAdjustments AC220

Ifthecustomerneedstodothis,thetableagainstwhichthefieldischeckedisthe

DB-table, for example, GLFUNCT and ZSLTABT.

Inthe caseof FI-SL Adjustment (Direct) postings, thetablecheckedagainstis

the GLU1.

Bysettingthe newvaluesfor theSpecial Regions, theparticipantswill ensure

validityfor: a)Theirrevenuepostingsb)TheirlaterFI-SLinternalpostings

Adjustment Postings in FI-SL

Thisgraphicshows the adjustment posting for aglobal company for version 2

to the 3rd currency (corporate group amount). Thenotes include three further

advantages, in addition to this application which illustrates examples for the

FI-SL postings: one-sidedFI-SL adjustment, different versions, quantity entry

(statistical).

Entering Documents: Document Header(1)

Thedocumentheadercontainsinformationthatappliestotheentiredocument.

You must make the following entries:

Company code (Company ID)

Documenttype: Thedocumenttypecontrolsthefollowingfunctions:

Document number assignment

Internal or external number assignment

Currencies allowed for document entry

Entry of actual or plan data

Checkwhetherthedocumentbalanceiszeroduringdocumententry

Version: Inthis field, you enter the FI-SL version that you want to usefor the

document.

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

summary record tables, thesystem proposestheGLU1table. The GLU1 table

containsallvariablefieldsinFI-SL.However,youcanalsoenteranFI-SLtable,

suchasGLFUNCT,orausertablefromT883S.Theusertableisaspecialview

of the FI-SL characteristics.

Target Ledger: If you haveassigned more than one ledger in Customizing but

wanttoposttoonlyoneledgerduringthispostingrun,youcanspecifyyourtarget

ledger. If theledger isnot already assigned inCustomizing, however, youwill

get an error message.

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

the document is read.

Eachdocumenttypeisassignedtoadocumenttypegroup.

Thesystemassignsnumber rangesforthesegroups.

154

第 173 页 / 共 509 页

AC220 Lesson: Adjustment Postings in FI-SL

The number assignment takesplace separately for local documentsand global

documents.

Youmustspecifyacompanycode(subobject)forlocaldocuments. Thedocument

type,suchasP0,andnumberassignmentmustbevalidforthecompanycode.

Thesubobjectforglobaldocumentsisaglobalcompany.

Whenmaintainingthenumberranges,youhavethefollowingoptions:

• Maintainintervals: Createandchangethenumberranges

• Changestatus: Aspecificchangetothenumberrangestatus

Versions

Foreachrecordtype,plan,actualandallocatedactualandplanyoucanuseupto

999 versions.

Youcan,forexample,usealternativeplans. Thesecanbecompletealternatives

(fullychangedcopies)ordeltaversions. Adeltaversionbuildssimpleadjustments

toanoriginalbaseversionandbothtotaledtogetherdeliverthenewvariant.

Alternativeversionsareusedmainlyinplanningorforallocations.

Postingsarisingfromtheothersystemsthroughintegrationarealwaysinversion1.

Adjustmentpostingscanbemadeonthisbasicversionatalevelthatgoesbeyond

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

preconsolidated results.

User Table

InsteadofhavingtouseorremembertheoriginaldatabasetablesforcertainFI-SL

applications,suchasdirectdataentryandsummaryview,‘youcancutthesedown

tosize‘bycreatingaUserTablethatlistsjustthosefieldsyouneedtoseeorenter

valuesforinaparticularsequenceandusethisViewforthespecifictransaction.

This reduces the entry time, minimizes errors in choosing wrong fields, and

providesyou with acomfortable overview of just theinformation youneed to

carry on with your processing.

Entering Documents: Document Header 2

Youcanenteranothercurrencyinadditiontothetransactioncurrency.

Youcanalsospecifyaunitofmeasureandanadditionalunitofmeasure.

Theperiodsfortheledgerupdatearedeterminedfromthepostingdate.

You can also enter data for a special period. (If you want to post to a special

period,thepostingdatemustbeinthelastnormalperiodofthefiscalyear.)

Youcanspecifyatranslationdatetodetermineaspecificexchangeratefromthe

exchangeratetable. Thedefaultvalueisthepostingdate.

155

第 174 页 / 共 509 页

Unit4: DirectPostingsandAdjustments AC220

Ifrequired,enteraledgerformasterdatavalidation. Thesystemusestheledger

youenterheretodeterminewhichchartofaccountsisusedtovalidatethemaster

data(especiallytheAccountdimension). Thechartofaccountsisdefinedatthe

ledger/companycodelevelorattheledger/globalcompanylevel. Showthisfor

yourLedger/Co. CodeAC00Assignment. Thereisnoentrythere,sothesystem

uses the chart of accounts of the local company code. For global ledgers, the

system uses the chart of accounts of the company code assigned to the global

company.

Entering Documents: Document Line

For each document line, you can enter the amounts, the account assignments

(characteristicsand/orcombinationsofcharacteristics),andexplanatorytext.

Theexchangeratesaretakenfromtheexchangeratetableandcanbechanged,if

required.

Foradocumentlinewithanegativeamount/quantity,youmustentertheminus(-)

sign after the amount.

Whenyouenteradocument,youcanusethevariousHelpfunctions(forexample,

holdingorreleasingaccountassignmentcharacteristicsandscrollingupordown

between document lines).

Afteryoupostthedocument,thesystemdisplaysthedocumentnumber.

Figure 72: Adjustment Postings in FI-SL

MostdataenterstheFI-SLthroughtheintegrationinterface.

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

reasons:

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

156

第 175 页 / 共 509 页

AC220 Lesson: Adjustment Postings in FI-SL

YouwanttopostadocumentindifferentFI-SLversions. Thepostingsmadefrom

theapplicationmodulesFI,SD,andMMautomaticallyreceiveFI-SLversion1. If

youenterdocumentsdirectlyinFI-SL,youcanuseotherversions.

Youwanttomanuallyentertheamountsfortheadditionalcurrency,suchasledger

currency. IfanadditionalcurrencythatismanuallyenteredinFI-SLisidenticalto

theadditionalcurrencyoftheledgertowhichtheamountisposted,theamountis

posteddirectly. Noautomatictranslationoccursinthiscase.

You want to post only statistical quantities.

Figure 73: Entering Documents: Document Header 1

157

第 176 页 / 共 509 页

Unit4: DirectPostingsandAdjustments AC220

Thedocumentheadercontainsinformationthatappliestotheentiredocument.

You must make the following entries:

• Company code (Company ID)

• Documenttype: Thedocumenttypecontrolsthefollowingfunctions:

– Document number assignment

– Internal or external number assignment

– Currencies allowed for document entry

– Entry of actual or plan data

– Checkwhetherthedocumentbalanceiszeroduringdocumententry

• Version: Inthisfield, youentertheFI-SLversionthatyouwanttousefor

the document.

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

severalsummaryrecordtables, the systemproposestheGLU1table. The

tablecontainsallthevariablefieldsinFI-SL.YoucanalsoenteranFI-SL

table, suchasGLFUNCT,or auser tablefrom T883S. Theuser tableisa

special view of the FI-SL characteristics.

• TargetLedger: IfyouhaveassignedmorethanoneledgerinCustomizing

butwanttoposttoonlyoneledgerduringthispostingrun,youcanspecify

yourtargetledger. IftheledgerisnotalreadyassignedinCustomizing,you

will get an error message.

Figure 74: Document Types for FI-SL Transactions

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

the document is read.

Eachdocumenttypeisassignedtoadocumenttypegroup.

158

第 177 页 / 共 509 页

AC220 Lesson: Adjustment Postings in FI-SL

Thesystemassignsanumber rangesfor thesegroups.

The number assignment takesplace separately for local documentsand global

documents.

Youmustspecifyacompanycode(subobject)forlocaldocuments. Thedocument

type,suchasP0,andnumberassignmentmustbevalidforthecompanycode.

Thesubobjectforglobaldocumentsisaglobalcompany.

Whenmaintainingthenumberranges,youhavethefollowingoptions:

• Maintainintervals: Createandchangethenumberranges

• Changestatus: Aspecificchangetothenumberrangestatus

• Insert or delete the year

Figure 75: Versions

Foreachrecordtype,plan,actualandallocatedactualandplanyoucanuseupto

999 versions

Youcan,forexample,usealternativeplans. Thesecanbecompletealternatives

(fullychangedcopies)ordeltaversions. Adeltaversionbuildssimpleadjustments

toanoriginalbaseversionandbothtotaledtogetherdeliverthenewvariant

Alternativeversionsareusedmainlyinplanningorforallocations

Postingsarisingfromtheothersystemsthroughintegrationarealwaysinversion1.

Adjustmentpostingscanbemadeonthisbasicversionatalevelthatgoesbeyond

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

preconsolidated results.

159

第 178 页 / 共 509 页

Unit4: DirectPostingsandAdjustments AC220

Figure 76: User Table

InsteadofhavingtouseorremembertheoriginaldatabasetablesforcertainFI-SL

applications,suchasdirectdataentryandsummaryview,“youcancutthesedown

tosize”bycreatingaUserTablethatlistsjustthosefieldsyouneedtoseeorenter

valuesforinaparticularsequenceandusethisViewforthespecifictransaction.

Thisreducesentrytime,minimizeserrorsinchoosingwrongfields,andprovides

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

with your processing.

160

第 179 页 / 共 509 页

AC220 Lesson: Adjustment Postings in FI-SL

Figure 77: Entering Documents: Document Header 2

Youcanenteracurrencyinadditiontothetransactioncurrency.

Youcanalsospecifyaunitofmeasureandanadditionalunitofmeasure.

Theperiodsfortheledgerupdatearedeterminedfromthepostingdate.

Youcanalsoenterdataforaspecialperiod. Ifyouwanttoposttoaspecialperiod,

thepostingdatemustbeinthelastnormalperiodofthefiscalyear.

Youcanspecifyatranslationdatetodetermineaspecificexchangeratefromthe

exchangeratetable. Thedefaultvalueisthepostingdate.

Ifrequired,enteraledgerformasterdatavalidation. Thesystemusestheledger

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

data, especiallytheAccountdimension. Thechart ofaccountsisdefinedatthe

ledger/companycodelevelorattheledger/globalcompanylevel. Ifyoudonot

enteraledger,thesystemusesthechartofaccountsofthelocalcompanycode.

For global ledgers, thesystem usesthechart of accountsof thecompany code

assigned to the global company.

161

第 180 页 / 共 509 页

Unit4: DirectPostingsandAdjustments AC220

Figure 78: Entering Documents: Document Line

For each document line, you can enter the amounts, the account assignments

(characteristicsand/orcombinationsofcharacteristics),andexplanatorytext.

Theexchangeratesaretakenfromtheexchangeratetableandcanbechanged,if

required.

Foradocumentlinewithanegativeamount/quantity,youmustentertheminus(-)

sign after the amount.

Whenyouenteradocument,youcanusethevariousHelpfunctions. Forexample,

holding or releasingaccountassignment characteristics, scrolling up or downs

between document lines.

Afteryoupostthedocument,thesystemdisplaysthedocumentnumber.

Demonstration: Demonstration of an FI-GL Posting

Purpose

To demonstrate an FI-GL Posting

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. Maintain valid special regions:

162

第 181 页 / 共 509 页

AC220 Lesson: Adjustment Postings in FI-SL

Todefinenewspecialregions,usethefollowingmenupath: SAPR/3System

→Tools→ABAPWorkbench→Overview→DataBrowser→Tablename:

ZZSPREG → Icon ‘Create Entries’

ShowtheSpecialRegionsalreadyexistingandthencreatethreenewones

as examples:

N-00A: North region A

S-00A: South region A

E-00A: East region A

W-00A: West region A

Demonstration: Revenue Postings to Special Regions

and Products (Customer Invoice posting)

Purpose

Todemonstraterevenuepostingstospecialregionsandproducts

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. RevenuePostingstoSpecialRegionsandProducts(CustomerInvoice

posting)

TomakeCustomerInvoicepostings,usethefollowingMenuPath: SAPR/3

System→Accounting→FinancialAccounting→Accountsreceivable→

Postings → Invoice

Header entries:

Document and Posting date: Current date

Doc.Type: DR

Company Code: AC00

Currency: USD

Enter the following document lines:

163

第 182 页 / 共 509 页

Unit4: DirectPostingsandAdjustments AC220

PK Customer Amount Calculate Taxcode

Tax

01 T-F00A00 40,000 x A0

PK Accountno. Amount BusAREAMat.no. Spec.Reg.

50 800200 10,000 0001 T-IC- N-00A

F1001

50 800200 10,000 1500 T-IC- S-00A

F1002

50 800200 10,000 8000 T-IC- E-00A

F1003

50 800200 10,000 9000 T-IC- W-00A

R2007

You can show and use your Account Assignment Model (DR-SL02) for

this posting.

Whenenteringthefirstrevenueline,demonstratewiththeMatchCodeon

SpecialRegionthevaluesinthetable,ZZSPREG.Amongthevalues,point

outtheexistenceofthenewspecialregions,N-00AtoW-00A.

ShowtheAccounting documentsand the updatein Ledger ZZ. Point out

once again the accounting document number and the document number

issued by FI-SL.

PK Customer Amount Calculate Taxcode

Tax

01 T-F00A00 200,000 x A0

PK Accountno. Amount BusAREAMat.no. Spec.Reg.

50 800300 20,000 0001 T-IC- N-00A

F1001

50 800300 20,000 1500 T-IC- S-00A

F1002

50 800300 20,000 8000 T-IC- E-00A

F1003

50 800300 20,000 9000 T-IC- W-00A

R2008

50 800400 30,000 0001 T-IC- N-00A

F1001

164

PK	Customer	Amount		Calculate Tax	Taxcode
01	T-F00A00	40,000		x	A0
PK	Accountno.	Amount	BusARE	AMat.no.	Spec.Reg.
50	800200	10,000	0001	T-IC- F1001	N-00A
50	800200	10,000	1500	T-IC- F1002	S-00A
50	800200	10,000	8000	T-IC- F1003	E-00A
50	800200	10,000	9000	T-IC- R2007	W-00A

PK	Customer	Amount		Calculate Tax	Taxcode
01	T-F00A00	200,000		x	A0
PK	Accountno.	Amount	BusARE	AMat.no.	Spec.Reg.
50	800300	20,000	0001	T-IC- F1001	N-00A
50	800300	20,000	1500	T-IC- F1002	S-00A
50	800300	20,000	8000	T-IC- F1003	E-00A
50	800300	20,000	9000	T-IC- R2008	W-00A
50	800400	30,000	0001	T-IC- F1001	N-00A

第 183 页 / 共 509 页

AC220 Lesson: Adjustment Postings in FI-SL

50 800400 30,000 1500 T-IC- S-00A

F1002

50 800400 30,000 8000 T-IC- E-00A

F1003

50 800400 30,000 9000 T-IC- W-001

R2009

Master Data Validation

Master Data Validation forFI-SLPostings

Therearethreemainmethodstoensuremasterdatavaluationforthecharacteristics

to be used in FI-SL transactions:

-ValidationagainstanFI-SLmasterdatatable. Thesetableshaveastructure

asinT830A.YouhavetodefinethetablesintheDDICbeforehand,whereby

you can use T830A as a reference table. After defining the tables, you

mustenterthetablesinT800AwithtypeCMandCT.FI-SLConfiguration

menu: Environment → Table directory. You then have to start program

RGBCFL00,selectingthe“Accesstointegr. masterdata”option. Youcan

maintainthetablesontheFI-SLmenuunderEnvironment→Integr. master

data → Create, Change,.

- Validation using an exit routine. The exit is defined as =nn, where “n”

represents a number. The exit routine itself is stored in the program,

SAPLGUMD.

- Validation against a value and text table, which you may have set up

yourselfintherepository. Thiswilleliminatethetime-consumingdefinition

of a user exit aswellasthedoublemaintenance of master data incertain

FI-SLmasterdatatables. Thesystemgeneratesautomaticaccessroutines

thatcarryoutmasterdatavalidationandpreparetextsforafieldfromentries

intheblock, "Validationwithvaluetable",intheview, "Fieldsformaster

data validation" (table T800D).

You may also use higher-level fields. For example, account is company

code-dependent.

165

50	800400	30,000	1500	T-IC- F1002	S-00A
50	800400	30,000	8000	T-IC- F1003	E-00A
50	800400	30,000	9000	T-IC- R2009	W-001

第 184 页 / 共 509 页

Unit4: DirectPostingsandAdjustments AC220

Figure 79: MasterData Validation for FI-SL Postings

Therearethreemainmethodstoensuremasterdatavaluationforcharacteristicsto

be used in FI-SL transactions:

ValidationagainstanFI-SL masterdatatable. Thesetableshavea structureas

inT830A.YouhavetodefinethetablesintheDDICbeforehand,wherebyyou

canuseT830Aasareferencetable. Afterdefiningthetables,youmustenterthe

tablesinT800AwithtypeCMandCT.FI-SLConfigurationmenu: Environment?

Tabledirectory. YouthenhavetostartprogramRGBCFL00,selectingthe’Access

to integr. master data’ option.

You can maintainthetablesontheFI-SLmenuunderEnvironment→Integr.

master data → Create, Change,

Validationusinganexitroutine. Theexitisdefinedas=nn,wherenrepresentsa

number. Theexitroutineitselfisstoredintheprogram,SAPLGUMD.

Validationagainstavalueandtexttable,whichyoumayhavesetupyourselfin

therepository. Thiswill eliminatethetime-consumingdefinitionof auser exit

as well as the double maintenance of master data in certain FI-Sl master data

tables. Thesystemgeneratesautomaticaccessroutinesthatcarryoutmasterdata

validationandpreparetextsforafieldfromentriesintheblock,Validationwith

valuetable,intheview,Fieldsformasterdatavalidation(tableT800D).

You may also use higher-level fields. For example, account is company

code-dependent.

166

第 185 页 / 共 509 页

AC220 Lesson: Adjustment Postings in FI-SL

Demonstration: Demonstration of Master Data

Validation

Purpose

To demonstrate master data validation

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. BranchtoFI-SLCustomizing→BasicSettings→MasterData→Maintain

Integrated Master Data

UseGLFUNCT-RFAREAorZSLTABT-RACCTasexample,

Undermasterdata,displaytheExit/Tablefieldandcallupinformationon

thepossibleentriesforthisfieldbypressingF1: eitheranFI-SL830table

or oneoftheexitsdeliveredbySAP( routineintheABAPSAPLGUMD

) or a user exit ( CMOD/SMOD).

DisplaytheexitroutineforRFAREAorRACCTinSAPLGUMD.

An example exists in the system for the field, RZSPREG, in the table,

ZZSPECT.Thisshowsthevalidationagainstavaluetable.

Youcanshowthisentry aswelland afterthat, choose themenuposition,

Edit and Copy as. Now enter thefollowing:

Summary table: ZSLTABT

Field name: RZZREGION

Youcanleavetheremainingentriesastheyare.

YoudonothavetomakeanentryintheRollup‘PartnerDimension‘field.

This is used for rollup with elimination of the internal business volume

fromtotalbusiness. Inhierarchicalsummarization,thisfieldenablesyouto

eliminatetheinternalbusinessvolumewithinanarea.

Example:

Field: RBUSA (business area)

Partnerdimension: SBUSA(sendingbusinessarea)

Iftherearesender-receiverrelationshipsbetweenthesetwofieldswithinan

area,thisinternalbusinessvolumeiseliminatedduringtherollup.

167

第 186 页 / 共 509 页

Unit4: DirectPostingsandAdjustments AC220

Theentry you makewill beused tovalidatevalues for thespecial region

in the FI-SL Allocation and Planning components as well as to retrieve

texts for Reporting.

Inadditiontothis,becausewearegoingtolaterusethefield,RFAREA,in

ZSLTABTfor Allocation as well, point out that it willalso be necessary

to create an entry for this.

Takethefield,RFAREA,inGLFUNCTandcopythisentryforRFAREAin

ZSLTABT.

Youcantakeoverthesameexitandtheotherspecifications.

Save your entries.

If needed, extra entries has to be made for FI-SL Direct Entry because

the table validated against there is GLU1. For RFAREA, RMATNR

(appropriate exit numbers) and RZZREGION (value table check like

ZSLTABT-RZZREGION).

TodemonstratehowtodefinevaluesforafieldwithinFI-SL:

The following entries are necessary:

• Make a new entry for RBUSA (Table GLU1). Enter T830A as the

Exit/TableandRBUKRSasthesuperiorfield. Whenyoucreatemaster

data for the business area in FI-SL, the company code will be the

organizational unit as the dependency.

• Continueandsave. YouwillgetawarningthatGSBERisthereference

dataelement, but you can ignore this.

1. Validation: T830D ( T830A, B, and D are standard samples: if the

customerneedsnewFI-SLmasterdatatables,youcancopyT830Aor

T831A(texts)intheDDICforanewT830xtable).

2. BranchtotheFI-SLapplication: Environment>Integra. masterdata

andcreatevalidmasterdataforGLU1-RBUSA.

Summary table: GLU1

Field name: RBUSA

Date from 0101XXXX

Date to 3112XXXX( XXXX= curr. year )

Company Code: 1000

Values:

0001 Text ‘Barea 0001‘

1500 Text ‘Barea 1500‘

8000 Text ‘Barea 8000‘

9000 Text ‘Barea 9000‘

168

第 187 页 / 共 509 页

AC220 Lesson: Adjustment Postings in FI-SL

Save!

This is just an example to create master data for fields in FI-SL. Few

customersmakeuseofthisbecausethemajorityofvaluechecksaremade

againstmasterdata/tablesavailableinthefeedersystems.

Demonstration: Demonstration of the Document

Types in FI-SL

Purpose

To demonstrate the document types in FI-SL

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. ShowtheDocumentTypesinFI-SLandthenumberrangesfortheDocument

typegroups. Takethedocumenttype,A2,asanexample.

Demonstration: Demonstration of Valid Versions

Purpose

To demonstrate valid versions

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. Show the valid versions for actual data and then create a Version 2 for

Ledger ZZ ‘Adjustment Postings’.

169

第 188 页 / 共 509 页

Unit4: DirectPostingsandAdjustments AC220

Demonstration: Demonstration of User Table

Purpose

To demonstrate the user table

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. Create a User Table TR-UTAB:

Menu path:

SAPR/3System→Tools→BusinessEngineer→Customizing→Implement

projects→SAPReferenceIMG→FinancialAccounting→SpecialPurpose

Ledger→BasicSettings→MasterData→MaintainUserTables

User Table: TR-UTAB Table: GLU1

Fields in the User Table:

Field name No.

RACCT 1

RBUSA 2

RMATNR 3

RZZREGION 4

Demonstration: Demonstration of User Table

Purpose

To demonstrate the user table

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

170

Field name	No.
RACCT	1
RBUSA	2
RMATNR	3
RZZREGION	4