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

第 218 页 / 共 509 页

Unit4: DirectPostingsandAdjustments AC220

Solution 8: Adjustment Postings in FI-SL

Document and Display of Totals Records

Task:

Adjustment Postings in FI-SL

1. Createaversion2foractualpostingstoyourledgerinFI-SL.

In the menu, select:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger

→ActualPosting→Maintain ActualVersions

Ledger Version ActivateVersion VersionDescription

Yourledger 2 x Version2Adjustments

a) Createaversion2foractualpostingstoyourledgerinFI-SL.

In the menu, select:

SAPReferenceIMG→Financial Accounting→SpecialPurpose

Ledger→ActualPosting→MaintainActualVersions

Ledger Version ActivateVersion VersionDescription

Your 2 x Version2Adjustments

ledger

2. User Table for FI-SL Adjustment Postings

In the menu, select:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger

→BasicSettings→MasterData→MaintainUserTables

User table: GXX-UTAB Table: GLU1

(XX - your group number)

Fields in the user table:

Field name No.

RACCT 1

RBUSA 2

RMATNR 3

Continued on next page

200

Ledger	Version	ActivateVersion	VersionDescription
Yourledger	2	x	Version2Adjustments

Ledger	Version	ActivateVersion	VersionDescription
Your ledger	2	x	Version2Adjustments

第 219 页 / 共 509 页

AC220 Lesson: Adjustment Postings in FI-SL

RZZREGION 4

a) User Tablefor FI-SL Adjustment Postings

In the menu, select:

SAPReferenceIMG →Financial Accounting→SpecialPurpose

Ledger→BasicSettings→MasterData→MaintainUserTables

User table: GXX-UTAB Table: GLU1

(XX - your group number)

Fields in the user table:

Field name No.

RACCT 1

RBUSA 2

RMATNR 3

RZZREGION 4

3. Adjustment Postings in FI-SL

In the menu, select:

SAP Easy Access → Accounting → Financial Accounting → Special

PurposeLedger→ActualPosting→DocumentEntry

Initial screen entries:

Company code: ACXX

Document type: A0

Version: 2

Posting date: Current date

Additional currency: USD

Target ledger: Your ledger

User table: GXX-UTAB

Enter the following lines:

Acct. BusArea Mat.No. SpecReg Amount(USD)

810200 0001 T-IC-F1001 N-XX1 1,000.00

810200 1500 T-IC-F1002 S-XX1 1,000.00

810300 1500 T-IC-F1003 E-XX1 2,000.00

Continued on next page

201

Acct.	BusArea	Mat.No.	SpecReg	Amount(USD)
810200	0001	T-IC-F1001	N-XX1	1,000.00
810200	1500	T-IC-F1002	S-XX1	1,000.00
810300	1500	T-IC-F1003	E-XX1	2,000.00

第 220 页 / 共 509 页

Unit4: DirectPostingsandAdjustments AC220

810300 1500 T-IC-R2008 W-XX1 2,000.00

810400 0001 T-IC-F1003 N-XX1 3,000.00

810400 1500 T-IC-F1001 S-XX1 3,000.00

Write down thedocument number posted:

DocumentnumberforFI-SL:___________________

a) Adjustment Postings in FI-SL

In the menu, select:

SAPEasyAccess→Accounting→FinancialAccounting→Special

PurposeLedger→ActualPosting→DocumentEntry

Initial screen entries:

Company code: ACXX

Document type: A0

Version: 2

Posting date: Current date

Additional currency: USD

Target ledger: Your ledger

User table: GXX-UTAB

Enterdocumentlinesasindicatedintheexercise. Writethedocument

number posted.

4. Document Display

In the menu, select:

SAP Easy Access → Accounting → Financial Accounting → Special

PurposeLedger→ActualPosting→DocumentEntry

Continued on next page

202

810300	1500	T-IC-R2008	W-XX1	2,000.00
810400	0001	T-IC-F1003	N-XX1	3,000.00
810400	1500	T-IC-F1001	S-XX1	3,000.00

第 221 页 / 共 509 页

AC220 Lesson: Adjustment Postings in FI-SL

ViewthedocumentnumbersthatyounotedfromyourFI-GL,FI-DR,and

FI-SLpostingsanddrilldowntoviewtheoriginal documentsforyour FI

postings.

a) Document Display

In the menu, select:

SAPEasyAccess→Accounting→FinancialAccounting→Special

PurposeLedger→ActualPosting→DocumentEntry

ViewthedocumentnumbersthatyounotedfromyourFI-GL(1-1-2),

FI-DR(1-1-4)andFI-SL(2-1-3)postings,anddrilldowntoviewthe

original documents for your FI postings.

Selection criteria:

Document number fromxxxxx to xxxxx

Fiscal year: Current year

Ledger: Your ledger

Companycode: YourcompanycodeACXX

Dependingonthedocumentnumbersyouhavenotedandtheoriginof

theposting,youcanchoosefromthefollowingdocumentcategories: *

=anydocumenttype,W=documentsfromtheaccountingdocument

or L = FI-SL local documents.

5. Totals Display

In the menu, select:

SAP Easy Access → Accounting → Financial Accounting → Special

PurposeLedger→ActualPosting→TotalsRecordDisplay

Continued on next page

203

第 222 页 / 共 509 页

Unit4: DirectPostingsandAdjustments AC220

ViewthetotalsrecordsthatyourecordedfromyourFI-GL(1-1-2),FI-DR

(1-1-4),andFI-SL(1-2-3)postings,drilldowntothesingleitemsandtothe

original documentsfor your FI postings.

a) Totals Display

In the menu, select:

SAPEasyAccess→Accounting→FinancialAccounting→Special

PurposeLedger→ActualPosting→TotalsRecordDisplay

View thetotalsrecordsthat you recorded from your FI-GL (1-1-2),

FI-DR (1-1-4), and FI-SL (2-1-3) postings, drill down to the single

itemsandtotheoriginaldocumentsforyourFIpostings.

Ledger: AA (...RR)

Period from: Current period

Period to: Current period

User table: Leave blank

Record type: 0

Version: 001

Fiscal year: Current year

Company code: ACXX

Accountnumber: Thoseyouhavepostedto(singlevalueorinterval)

FromtheOverview, double-clickyourtotalsrecordstoselectit, and

callthesingleitemororiginaldocumentsbydouble-clickingthem.

204

第 223 页 / 共 509 页

AC220 Lesson: Adjustment Postings in FI-SL

Lesson Summary

You should now be able to:

• Set upmaster datafor characteristicsusedforpostingsandusetheFI-SL

direct entry function

• Create auser table for FI-SL applications

• CallanddisplaylineitemsandsummaryrecordsinFI-SL

205

第 224 页 / 共 509 页

UnitSummary AC220

Unit Summary

You should now be able to:

• Setupmaster datafor characteristicsused for postingsandusetheFI-SL

direct entry function

• Createa user table for FI-SL applications

• CallanddisplaylineitemsandsummaryrecordsinFI-SL

206

第 225 页 / 共 509 页

AC220 Test Your Knowledge

Test Your Knowledge

161

1. The document header contains information that applies to the entire

document.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

2. Ifyoudonot enterausertableor asummarytable, the fieldsinthetable

containedin theledger willnot be displayed.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

3. Thedocument categorydefinestheoriginofthedocument. Whichofthe

followingvaluesrepresentsdocumentsfromManagementAccounting?

Choosethecorrectanswer(s).

□ A R

□ B B

□ C S

□ D K

4. Insteadofhavingtouseorremembertheoriginaldatabasetablesforcertain

FI-SLapplications,youcancreatea thatlistsonlythose

fieldsthatyouneedtoseeorentervaluesforinaparticularsequence.

Fillintheblankstocompletethesentence.

5. What are the three main methods to ensure master data valuation for the

characteristicstobeused in FI-SLtransactions?

207

第 226 页 / 共 509 页

TestYourKnowledge AC220

Answers

162

1. The document header contains information that applies to the entire

document.

Answer: True

The document header contains information that applies to the entire

document. Youneedtomakeentriesforthecompanycode,documenttype,

version, user table, and target ledger.

2. Ifyoudonot enter ausertableor asummary table, thefieldsin thetable

containedin theledger will not be displayed.

Answer: False

Ifyoudonotenterausertableorasummarytable,allthefieldsinthetable

contained in theledger will be displayed.

3. Thedocument categorydefinestheoriginofthedocument. Whichof the

followingvaluesrepresentsdocumentsfromManagementAccounting?

Answer: D

Thevalue,K,representsdocumentsfromManagementAccounting.

4. Insteadofhavingtouseorremembertheoriginaldatabasetablesforcertain

FI-SLapplications,youcancreateausertablethatlistsonlythosefieldsthat

youneedtoseeorentervaluesforinaparticularsequence.

Answer: user table

5. What arethe three main methods to ensure master data valuation for the

characteristicstobeusedin FI-SLtransactions?

Answer: Thethreemainmethodstoensuremasterdatavaluationforthe

characteristicstobeusedintheFI-SLtransactionsare:

• Validationagainst anFI-SL master datatable

• Validation using an exit routine

• Validation against a valueand text table

208

第 227 页 / 共 509 页

Unit 5

Validations, Substitutions, and Rules

163

Demonstrate the need for validation of certain characteristic combinations

when entering data to their ledgersusing an adjustment FI-SL posting and for

substitution to acquire a further concentrated degree of detail. Explain and

demonstrate the techniquesof both instruments.

Unit Overview

The focus of this unit is to demonstrate the need for validation of certain

characteristic combinations when entering data to their ledgers using an

adjustment FI-SLpostingandfor substitutiontoacquireafurtherconcentrated

degree of detail. The unit will also explain and demonstrate the techniques of

both instruments.

Unit Objectives

After completing thisunit, you will beableto:

• Describevalidationand substitution examples

• Describe call-up points in validations

• Describe operands and operators

• Explain field comparisons

• Use rules and user exits

• Describe the formula builder

• Explaintheprocessofmaintenanceofvalidationsandsubstitutions

• Explain the process of activation

Unit Contents

Lesson: Functionality of FI-SL Validations and Substitutions.............211

Demonstration: Demonstration for Substitutions.......................216

Demonstration: Demonstration of Validation............................217

Exercise 9: Validations.....................................................221

Lesson: Creation and Maintenance of Validations and Substitutions....229

209

第 228 页 / 共 509 页

Unit5: Validations,Substitutions,andRules AC220

Exercise 10: Substitutions.................................................239

210

第 229 页 / 共 509 页

AC220 Lesson: Functionality of FI-SL Validations and Substitutions

Lesson: Functionality of FI-SL Validations and Substitutions

Lesson Duration: 20 Minutes

164

Lesson Overview

ThislessonprovidesanoverviewofFI-SLvalidationsandsubstitutions. Italso

provides examples of validations and substitutions. In addition, it describes

call-up points in validations.

Lesson Objectives

After completingthislesson, youwillbeable to:

• Describevalidationand substitution examples

• Describe call-up points in validations

GiveanoverviewofFI-SLvalidationsandsubstitutions. Explaintheconceptwith

examplesofvalidationsandsubstitutions. Describecall-uppointsinvalidations.

Business Example

Your Company has a fairly rich management reporting requirement. Most of

the information required is obtained from other application areas but must be

regroupedandfurtherenhanced. Insomecases,theinformationmustberefined

toprovidesummarizeddatainchosen combinations.

The management also requires a field (characteristic) called Special Region,

which canbeusedto providean additional geographical breakdown incertain

financial reports. Thisfield (characteristic) hasbeencreatedbecauseithasnot

beendeliveredbySAP.Afterthecharacteristicsandkeyfigureshavebeensorted

logicallyintogroupsfortherequiredreports,databasetablesmustbegenerated

andinstalledforthevariousFI-SLcomponentsbeforetheycanbemadeavailable

forupdateandreporting. Businessmanagershavetoensurethatanyadjustment

postingsmadeinFI-SLarerestrictedtothecorrectversionanddocumenttype.

Additionally,thecorrectcombinationsofBusinessLinesandrevenuesforspecial

reportsmustbeavailableinsuchpostings. Youneedtoexplorethefunctionsof

validationandsubstitutiontomeetthemanagementrequirements.

211

第 230 页 / 共 509 页

Unit5: Validations,Substitutions,andRules AC220

Overview of FI-SL Validations and Substitutions

Procedure

Businessapplicationcomponent(=USER):Whereisthevalidation/substitution

used? (CO, FI-GL, and FI-SL)

Figure 88: Validations, Substitutions, andRules: Overview

Figure 89: Procedure

212

第 231 页 / 共 509 页

AC220 Lesson: Functionality of FI-SL Validations and Substitutions

Youmustperformthefollowingstepstocreateavalidationorsubstitution:

• 1. Entertheapplicationareainwhichthevalidationorsubstitutioniscalled

up.

• 2. Selectthecorrectcalluppointforthevalidationorsubstitution.

• 3. Define the validation or substitution.

• 4. Assignyourvalidationorsubstitutiontoanorganizationalunit,suchas

company code for FI, company code or global company for FI-SL, and

controlling area for CO).

• 5. Activate it.

Thefieldsthatcanbeusedinyourvalidationorsubstitutionaredeterminedfrom

the application area and the callup point. When you define your rules for the

prerequisiteandcheckstatements,youcanchoosethefieldsthatyouwanttouse.

Validations and Substitution Examples

Validation and Substitution

Examples : Customer-defined rules

Example of a Validation

Threeparts: Prerequisite(TRUE)>Check(FALSE)>Message

Example of a Substitution

Two parts: Prerequisite(TRUE) > Substitution

FI-SL: Direct Data Entry

ExampleforuseinanFI-SLdirectentry, wherethefieldsfromthetableGLU1

are validated.

213

第 232 页 / 共 509 页

Unit5: Validations,Substitutions,andRules AC220

Figure 90: Validation and Substitution Examples

User-definedrulesenableyoutovalidateandsubstitutespecificdatawhileyou

enter the data in the system.

Figure 91: Example of a Validation

Validation allows you to define your own checks for specific fields when a

business transaction is being processed.

A validation consists of three parts:

• Prerequisite

• Check

• Message

Iftheprerequisiteismet(ifitisTRUE),acheckisperformed.

214

第 233 页 / 共 509 页

AC220 Lesson: Functionality of FI-SL Validations and Substitutions

IfthecheckstatementisFALSE,thesystemreturnsamessage.

Figure 92: Example of a Substitution

Substitutionallowsyoutodefineyourownconditionstosubstitutespecificfields.

A substitution consists of two parts:

• Prerequisite

• Substitution

Iftheprerequisiteismet(ifitisTRUE),thesubstitutioniscarriedout.

Figure 93: FI-SL: Direct Data Entry

ThisexampleshowshowvalidationsandsubstitutionsareusedinFI-SL.

Thevalidation/substitutioncanbeusedforadirectposting(adjustmentposting).

ThefieldsintableGLU1areusedinthisexample.

215

第 234 页 / 共 509 页

Unit5: Validations,Substitutions,andRules AC220

Demonstration: Demonstration for Substitutions

Purpose

To demonstrate a substitution

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. Substitution TR-BUSA

a. Substitution step 1 pre-requisite:

Businessarea=‘0001’ ORBusinessarea=‘1500’

Substituted value: RETL

b. Substitution step 2 pre-requisite:

Businessarea=‘8000’ ORBusinessarea=‘9000’

Substituted value: WSLE

SimulateandthenexecuteSubstitutionTR-BUSA.

Callup Points in Validations

Validation: Callup Points/Callup Point 1

Exampleofvalidation in an FIG/L or FI-SL postingto fieldsofthedocument

header,suchasdocument/postingdate,documenttype,andpostingkey).

Validation: Callup Points/Callup Point 2

Exampleof thevalidationinanFI G/L(FI SL)account postingtothefieldsof

the additional account assignments and the possibility of using the fields also

fromcalluppoint1, forexampleaccount/businessarea,account/costcenterand

other cross-checks.

216

第 235 页 / 共 509 页

AC220 Lesson: Functionality of FI-SL Validations and Substitutions

Figure 94: Validation: Call-up Points/Callup Point 1

Thecalluppointdetermineswhenthevalidationorsubstitutionisperformed.

ThisexampleshowshowdataisvalidatedinaG/LaccountassignmentorFI-SL

account assignment at callup point 1.

Calluppoint1checksthefieldsinadocumentheader.

Figure 95: Validation: Call-up Points/Callup Point 2

Calluppoint 2isused tocheckthefieldsinadocument linefor aG/L account

postingoraFI-SLadjustmentposting. Thefieldsthatareavailableatcalluppoint

1 are also available for cross checks.

Example: Checkingtheaccount/businessareacombination.

Demonstration: Demonstration of Validation

Purpose

To demonstrate a validation

217

第 236 页 / 共 509 页

Unit5: Validations,Substitutions,andRules AC220

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. Example in System:

1) Create a Validation G00-VAL for the application area GL in Callup

point 0002.

SAPR/3Enterprise>Tools>BusinessEngineer>Customizing>Implement

projects>SAP Reference IMG>Financial Accounting>Special

Purpose Ledger>Basic Settings>Validation>Maintain Local

Validation>Environment>Validation>

Enter your user table TR-UTAB

Place the pointer on Line Item.

Validation>Create

Validation: G00-VAL

Validationdescription: ‘BUSA/FAREA’.Enter

Insert Step

Validationstepdescription: ‘Bus.Area/Fareas’

Prerequisite > Formula Builder

Double click Business area.

GLU1-RBUSA

Doubleclick on ‘=’ indicator

Double click ‘Constant’.

Insert ‘0001’.

Result: GLU1-RBUSA = ‘0001’

Back.

Check > Formula Builder

Double click Functional area.

Double click ‘=’.

Double click ‘Constant’Insert ‘0300’.

Double click ‘OR’.

Double click Functional area.

218

第 237 页 / 共 509 页

AC220 Lesson: Functionality of FI-SL Validations and Substitutions

Double click ‘=’.

Double click ‘Constant’.

Insert ‘0400’ and then ‘0500’.

Result: Functionalarea=’0300’ORFunctionalarea=’0400’ORFunctional

area = ‘0500’

Definethemessagerequiredwiththenumber299, savethemessage, and

enter the message into your validation step.

>Environment>Create messages

Message class Z2

Enter a new message.

Message number 299

Maintaininlogon language(Deutschor English)

Insert‘IncorrectcombinationBAREA&/FAREA&’.

Save and go back to Validation step.

Message Type = E

Insert your number 2xx.

OutputFields: 1. GLU1RBUSA2GLU1RFAREA

Check

Back (F3)

Save the Validation.

Checkyourvalidationstepandthengobacktosaveyourvalidation.

Check

Back (F3)

Save the validation.

Simulateyourvalidationandchecktoseetheexpectedresult.

Validation>Simulate

Typ Object Val.

Field GLU1 RBUSA ... 0001

Field GLU1 RFAREA ... 0100

Execute.Result: Step Object Val

001 Prereq True

001 Check False

219

第 238 页 / 共 509 页

Unit5: Validations,Substitutions,andRules AC220

001 Messge : Incorr.. E299

End Result Validtn failed. Type E Messge

ActivatethevalidationforyourcompanycodeAC00forCalluppoint002

ExitValidationandgobacktomenu,‘ChangeView‘ValidationforSpecial

Purpose Ledger/Co.Code’ : Overview’

New Entries

Insert

CoCode CallPnt Validation Actvtn level

AC00 2 G00-VAL 1

Save

PerformtheFI-SLDocumentEntryasindicatedinyourexercise:

Company Code: AC00

Document Type : A2

Version : 002

Your User Table TR-UTAB

Group Currency USD

Posting Date: Current Date

Target Ledger: Your Ledger

Document Line Entry:

Account: 430000

Bus.Areal: 0001

Enter an incorrect RFAREA ( e.g. 0110). You can see the message you

have set up.

2)Partfieldcomparison: as1)butchecktheRFAREAforoffset1-2(must

be 01, 03 or 05)

220

第 239 页 / 共 509 页

AC220 Lesson: Functionality of FI-SL Validations and Substitutions

Exercise 9: Validations

171

Exercise Duration: 40 Minutes

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Define and execute a validation in FI-SL

Business Example

RegionalmanagersneedtoensurethatanyadjustmentpostingsmadeinFI-SL

arerestrictedtothecorrectversionanddocumenttype. Additionally,managers

needtoensurethecorrectcombinationsofspecialregionsforsomepostingsand

takerevenuesinto account tocreatespecial reports.

Task:

Postings from FI

WhenyoumakeadjustmentpostingsinFI-SL,youmustensurethatthecorrect

combinationofproductsandspecialregionsisenteredforyourcompanycode.

Material: T-IC-R2009

Allowedspecialregions: N-XX1,S-XX1,E-XX1orW-XX1(whereXXisyour

group number.)

Ifanincorrectcombination isentered, thefollowingmessageof typeE should

appear:

Groupxx: Incorrectcombinationmaterial&/region&(wherexxisyourgroup

number)

1. Create a validation GXX-VAL (where XX is your group number) for the

application area GL and the line item.

Select

SAP Reference IMG → Financial Accounting → Special Purpose

Ledger→BasicSettings →Validation→MaintainLocalValidation→

Environment → Validation

Enter the user table GXX-UTAB (where XX is the group number) and

select Continue.

Select the line item and double-click Validation (Create). Enter your

validationwiththedescription,Material/Regions.

Continued on next page

221

第 240 页 / 共 509 页

Unit5: Validations,Substitutions,andRules AC220

Insertthestep,AllowedMaterialandRegions,andusetheFormulaBuilder

to define your prerequisite and check.

2. Definetherequiredmessagewiththenumber2xx(wherexxisyourgroup

number). Saveandenterthemessageinyourvalidationentry.

Point to Message and select

Environment → Maintain Messages)

Find your number in the message table. Double-click the line and enter

your message. Save your message. Click the green arrow icon to return

to validation maintenance.

Save your validation.

3. Simulateyour validationand checktheresult.

PointtoyourvalidationandselectValidation→Simulatefromthemenu.

4. ActivatethevalidationforyourcompanycodeACXXforcalluppoint002.

Exit Validation and go back to the screen, Change View “Validation for

Special PurposeLedger/Co.Code”: Overview.

Select New Entries.

Enter the following:

CompanyCode CallupPoint Validation ActivationLevel

ACXX 2 GXX-VAL 1

Enter the following FI-SL document:

Companycode: ACXX (XX=group number)

Document type: A0

Version: 002

Posting date: Current date

Additional entry currency: USD

Target ledger: Your ledger

Your user table: GXX-UTAB

Document line entry:

Rev. account: 810400

Material: T-IC-R2009

Enteranincorrectregion,suchas,Z-001,andseethemessagethatappears.

222

第 241 页 / 共 509 页

AC220 Lesson: Functionality of FI-SL Validations and Substitutions

Solution 9: Validations

Task:

Postings from FI

WhenyoumakeadjustmentpostingsinFI-SL,youmustensurethatthecorrect

combinationofproductsandspecialregionsisenteredforyourcompanycode.

Material: T-IC-R2009

Allowedspecialregions: N-XX1,S-XX1,E-XX1orW-XX1(whereXXisyour

group number.)

Ifanincorrectcombination isentered, thefollowingmessageof typeE should

appear:

Groupxx: Incorrectcombinationmaterial&/region&(wherexxisyourgroup

number)

1. Create a validation GXX-VAL (where XX is your group number) for the

application area GL and the line item.

Select

SAP Reference IMG → Financial Accounting → Special Purpose

Ledger→BasicSettings →Validation→MaintainLocalValidation→

Environment → Validation

Enter the user table GXX-UTAB (where XX is the group number) and

select Continue.

Select the line item and double-click Validation (Create). Enter your

validationwiththedescription,Material/Regions.

Insertthestep,AllowedMaterialandRegions,andusetheFormulaBuilder

to define your prerequisite and check.

a) CreateavalidationGXX-VAL(whereXXisyourgroupnumber)for

theapplicationareaGLincalluppoint0002.

SAPReferenceIMG →Financial Accounting→SpecialPurpose

Ledger→BasicSettings→Validation→MaintainLocalValidation

→ Environment → Validation.

Validation: GXX-VAL

Applicationarea: Special-PurposeLedger(GL)

Callup point: Line item (2)

Select Continue.

User table: GXX-UTAB

Continued on next page

223

第 242 页 / 共 509 页

Unit5: Validations,Substitutions,andRules AC220

Validationdescription: Material/Regions

Select Insert Step.

Validationentrydescription: AllowedMaterialandRegions

Prerequisite → Formula Builder

From the user table, double-click the material GLU1-RMATNR to

select it.

Double-click =

Double-click Constant.

Insert T-IC-R2009.

Result: GLU1-RMATNR= T-IC-R2009

(Material)

Select Back (F3).

Select Check → Formula Builder.

Double-click Special Region.

Double-click =

Double-click Constant.

Insert N-xx1 (xx = your group number).

Double-click OR.

Double-click Special Region.

Double-click =

Double-click Constant.

Insert S-xx1’ and continueup to W-xx1.

Result: Specialregion=N-xx1ORspecialregion=S-xx1ORspecial

region =E-xx1ORspecialregion= W-xx1.

2. Definetherequiredmessagewiththenumber2xx(wherexxisyourgroup

number). Saveandenterthemessageinyourvalidationentry.

Point to Message and select

Environment → Maintain Messages)

Find your number in the message table. Double-click the line and enter

your message. Save your message. Click the green arrow icon to return

to validation maintenance.

Continued on next page

224

第 243 页 / 共 509 页

AC220 Lesson: Functionality of FI-SL Validations and Substitutions

Save your validation.

a) Define the message with the number 2xx (where xx is your group

number). Saveandenterthemessageinyourvalidationentry.

→ Maintain Messages

Message class: Z2

Select Change.

Messagenumber: 2xx(xx=group number)

Usethelogonlanguagetomaintainyourentries.

Enter the following: Incorrect combination material & / region &

(where xx is your group number)

Saveand goback tothe validation entry.

Message type: E

Insert the number 2xx.

Outputfields: 1. GLU1RMATNR3GLU1RZZREGION

Select Check.

Select Back (F3).

Save your validation.

3. Simulateyour validation andcheck the result.

PointtoyourvalidationandselectValidation→Simulatefromthemenu.

a) Simulateyourvalidationandchecktheresult.

Validation → Display → Simulate

Type Object Value

Field GLU1RMATNR T-IC-R2009

Field GLU1 RZZREGION Z-001

Select Execute.

Result:

Step Object Value

001 Prerequisite True

001 Check False

001 Message group xx: False E2xx

Result: Validationfailed. MessagetypeE.

Continued on next page

225

第 244 页 / 共 509 页

Unit5: Validations,Substitutions,andRules AC220

4. ActivatethevalidationforyourcompanycodeACXXforcalluppoint002.

Exit Validation and go back to the screen, Change View “Validation for

Special PurposeLedger/Co.Code”: Overview.

Select New Entries.

Enter the following:

CompanyCode CallupPoint Validation ActivationLevel

ACXX 2 GXX-VAL 1

Enter the following FI-SL document:

Companycode: ACXX (XX=group number)

Document type: A0

Version: 002

Posting date: Current date

Additional entry currency: USD

Target ledger: Your ledger

Your user table: GXX-UTAB

Document line entry:

Rev. account: 810400

Material: T-IC-R2009

Continued on next page

226

第 245 页 / 共 509 页

AC220 Lesson: Functionality of FI-SL Validations and Substitutions

Enteranincorrectregion,suchas,Z-001,andseethemessagethatappears.

a) ActivatethevalidationforyourcompanycodeACXXforcalluppoint

002.

ExitValidationandgobacktothescreenChangeView“Validationfor

Special PurposeLedger/Co.Code”:Overview.

Select New Entries.

Enter the following:

CompanyCode CallupPoint Validation ActivationLevel

ACXX 2 GXX-VAL 1

Save your entries.

Enter the following FI-SL document:

Companycode: ACXX(XX=groupnumber)

Document type: A0

Version: 002

Posting date: Current date

Additional entry currency: USD

Target ledger: Your ledger

Your user table: GXX-UTAB

Document line entry:

Rev. account: 810400

Material: T-IC-R2009

Enter an incorrect region, for example, Z-001, and see themessage

that appears.

227

第 246 页 / 共 509 页

Unit5: Validations,Substitutions,andRules AC220

Lesson Summary

You should now be able to:

• Describevalidationand substitutionexamples

• Describe call-up points in validations

228

第 247 页 / 共 509 页

AC220 Lesson: CreationandMaintenanceofValidationsandSubstitutions

Lesson: Creation and Maintenance of Validations and

Substitutions

179

Lesson Duration: 20 Minutes

Lesson Overview

Inthislesson, youwilllearnaboutoperandsandoperators. Youwillalsolearn

about field comparisons. Next, you will learn to use rulesand user exits. You

will cover the formula builder. Finally, you will learn about the processes of

maintenanceofvalidationsandsubstitutionsandactivation.

Lesson Objectives

After completingthislesson, youwillbeable to:

• Describe operands and operators

• Explain field comparisons

• Use rules and user exits

• Describe the formula builder

• Explaintheprocessofmaintenanceofvalidationsandsubstitutions

• Explain the process of activation

Describe operands and operators. Explain field comparisons. Use rules and

userexits. Describetheformulabuilder. Explaintheprocessofmaintenanceof

validationsandsubstitutions. Explaintheprocessofactivation.

Business Example

YourCompanyhasafairlyrichmanagementreportingrequirement. Mostofthe

informationneededcomesfrom other application areasbutmust be regrouped

andfurtherenhanced. Insomecases,theinformationmustberefinedtoprovide

summarizeddatainchosencombinations. TheManagementalsorequiresafield

(characteristic)called’SpecialRegion’,whichcanbeusedtoprovideanadditional

geographicalbreakdownincertainfinancialreports. Thisfield(characteristic)has

beencreatedbecauseitisnotdeliveredbySAP.Afterthecharacteristicsandkey

figuresaresortedlogicallyintogroupsfortherequiredreports, databasetables

mustbegeneratedandinstalledforthevariousFI-SLcomponentsbeforetheycan

be made available for update and reporting.

Businessmanagershavetoensurethat anyadjustmentpostingsmadeinFI-SL

arerestrictedtothecorrectversionanddocumenttype. Additionally,thecorrect

combinationsofBusinessLinesandrevenuesforspecialreportsmustfeaturein

229

第 248 页 / 共 509 页

Unit5: Validations,Substitutions,andRules AC220

suchpostings. Thesamemanagershavedecidedtoreorganizeandregrouptheir

RegionalBusinessLinesintohigher-levelLinesofBusinessandtoaggregatethe

revenues for special reports.

To ensure the verification and consistency of the information entered, FI-SL

ValidationandSubstitutionfacilitiesareinvestigated,tested,andenforced.

Operands and Operators

Completesetofoperandswithlogicaloperatorsandcomparisonoperators.

Figure 96: Operands and Operators

The following elements are used to create rules for prerequisite statements

(validationandsubstitution)andcheckstatements(validation):

Operands:

• Logical operators (Boolean logic)

• Comparison operators

230

第 249 页 / 共 509 页

AC220 Lesson: CreationandMaintenanceofValidationsandSubstitutions

Field Comparisons

Validations& Substitutions: Field Comparison

Check with field constant comparison, subfield comparison, fieldcomparison,

and example comparison with‚ ‘LIKE’.

Figure 97: ValidationsandSubstitutions: FieldComparison

There are four types of field comparison:

• 1. Fieldconstantcomparison: <Table>$field=’literal’

• 2. Subfieldcomparison: <Table>$fname:n1-n2op’fvalue’

:<Table>$fname:n1- op ’fvalue’

:<Table>$fname:n1: op ’fvalue’

n1: positionofthefirstcharacterintheintervaltobecompared

n2: positionofthelastcharacterintheintervaltobecompared

n1: fromthenthpositioninthefieldtotheendofthefield

n: the nth position

• 3. Fieldcomparison:<Table>$field1=<Table>$field2

• 4. Example comparison: Text example can be compared using the key

word, LIKE.

Thesymbol,*,standsforanycombinationofcharacters. Thesymbol,+,stands

for a single character.

Example: <GLU1>$RCNTR LIKE’*3*3’ applies to the cost centers 33, 363,

and 32433.

231

第 250 页 / 共 509 页

Unit5: Validations,Substitutions,andRules AC220

Using Rules and User Exits

Validations& Substitutions: Howto UseRules

AruleisaBooleanstatementthatisusedinaprerequisite, check, orinanother

rule.

If a Boolean statement is frequently used or if it contains complex logic, you

can create a rule for it.

Youcantakethisrulefromtherulelistanduseitinyourvalidationorsubstitution.

The participants have already used a Rule for their Ledger Selection for the

activity RFBUin their Ledger Assignments.

TheRuleexemplifiedhereisusedinanFI-SLDirectPosting.

Figure98: ValidationsandSubstitutions: HowtoUseRules

AruleisaBooleanstatementthatisusedinaprerequisite, check, orinanother

rule.

If a Boolean statement is frequently used or if it contains complex logic, you

can create a rule for it.

Youcantakethisrulefromtherulelistanduseitinyourvalidationorsubstitution.

232

第 251 页 / 共 509 页

AC220 Lesson: CreationandMaintenanceofValidationsandSubstitutions

Figure 99: Validation and Substitution: User Exits

Formula Builder

TheFormulaBuilderprovidesaneasy-to-useinterfacetoinputarithmeticaland

logical expressions.

Dependingonthecontextfortheformulationrequired,youaregivenbuttonsto

press, whichprovideOperandsandOperatorsfor logicalexpressionsthathave

to be inserted in the formula.

Your entry is checked step by step for correct syntax including parentheses.

Dependingonyourentries,thesystemwillonlyallowyoutodisposeofthecorrect

logicalformulationtoguaranteeafullycorrectstatement. Errorsinenteringyour

rules are therefore scored out.

Theuseoftechnicalnames,aswasthecaseinthepast(tablesandfieldnames),is

stillsupported,buttheoptionsyoucanusearedeliveredusingpressbuttonsand

texts. Thisenhancesthecomfortofhandlingalogicthatisintrinsicallytechnical.

This has been conceived to alleviate the entry of rules for validations and

substitutions from 4.0 onwards. The old syntax form is still supported and

foregoing. If you want, for the demonstration in the system later, you may

alternate between the two ways of entering your validation prerequisites and

checks and substitution prerequisites.

233

第 252 页 / 共 509 页

Unit5: Validations,Substitutions,andRules AC220

Figure 100: Formula Builder

TheFormulaBuilderprovidesaneasy-to-useinterfacetoinputarithmeticaland

logical expressions.

Dependingonthecontextfortheformulationrequired,youaregivenbuttonsto

press, whichprovideOperandsandOperatorsforlogical expressionsthathave

to be inserted in the formula.

Yourentryischeckedstepbystepforcorrectsyntaxincludingparentheses.

Dependingonyourentries,thesystemwillallowyoutoonlydisposeofthecorrect

logicalformulationtoguaranteeafullycorrectstatement. Errorsinenteringyour

rules are therefore scored out.

Theuseoftechnicalnames,aswasthecaseinthepast(tablesandfieldnames),is

stillsupported,buttheoptionsyoucanusearedeliveredusingpressbuttonsand

texts. Thisenhancesthecomfortofhandlingalogicthatisintrinsicallytechnical.

Maintenance of Validations and Substitutions

Validations and Substitutions: Maintenance

Possibilitytovalidateorsubstituteseveraltimesforacalluppoint.

Notefortheparticipants: Ifforacalluppoint,onevalidationandonesubstitution

areactiveinparallel,thesequencesubstitutionBEFOREvalidationapplies.

234

第 253 页 / 共 509 页

AC220 Lesson: CreationandMaintenanceofValidationsandSubstitutions

Figure 101: Validations: Maintenance

Eachvalidationcancontainupto999stepsandeachstepconsistofa

• Prerequisite

• Check

• Message

Prerequisites and checks contain the same fields and have the same field

processing options.

You can use a message that has already been defined or you can create a new

message for the validation.

You can include up to four fields in a message. The $ sign in the message

representstheplaceholdersfor thefieldstobeoutput.

Themessagestobeoutputcanhavedifferentlevelsofseverity:

• I = Information

• W = Warning

• E = Error (theuser must correct the entry)

• C = Cancel

235

第 254 页 / 共 509 页

Unit5: Validations,Substitutions,andRules AC220

Figure 102: Substitution: Maintenance

A substitution can also contain upto 999 steps.

A substitution step consists of a :

• Prerequisite

• Substitution

Activation

Activationforanorganizationalunit(CCode/globalcompany)foronecalluppoint

respectively. 1active,2activeexceptforbackgroundprocessing,0inactive.

Figure 103: Activation

236

第 255 页 / 共 509 页

AC220 Lesson: CreationandMaintenanceofValidationsandSubstitutions

Avalidation/substitutionisactivatedforeachofthefollowing:

• An ORGANIZATIONAL UNIT (in FI-SL: Company code or global

company)

• ACALLUPPOINT(inFI-SL:0001(documentheader)or0002(document

line))

• Avalidationorsubstitutioncanbevalidforseveralcompanycodes/global

companies at the same time.

Beforeyouperformavalidation/substitution,itmustbeactivated. Thefollowing

levels of activation are possible:

• 0 Inactive

• 1 Active

• 2 Active, except for batch input

237

第 256 页 / 共 509 页

Unit5: Validations,Substitutions,andRules AC220

238

第 257 页 / 共 509 页

AC220 Lesson: CreationandMaintenanceofValidationsandSubstitutions

Exercise 10: Substitutions

187

Exercise Duration: 40 Minutes

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Define and execute a substitution in FI-SL

Business Example

Themanagershavedecidedtoreorganizeandregrouptheirregionsintozonesand

aggregate the revenues for special reports.

Task:

Substitution

Postings to your regions N-xx1, S-xx1, E-xx1, and W-xx1 are to be replaced

by the following four zones:

NORTH, SOUTH, EAST, and WEST

1. Create the substitution, Gxx-SUB (xx = your group number) for the

applicationareaspecialpurposeledgerandthelineitem. Usetheusertable,

Gxx-UTAB,andenterthedescription,SubstitutionRegions.

In the menu, select:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger

→ Basic Settings → Substitution → Maintain Local Substitution →

Environment → Substitution

SelectthelineitemandentertheusertableGXX-UTAB.SelectContinue

andenter your validation. Select Insert Step.

2. Usethecorrespondingfieldtoenterfoursteps,andusetheFormulaBuilder

todefineaprerequisiteforeachsteprequiredinyoursubstitution. Ineach

step,enterthesubstitutedvalues(NORTH,SOUTH,EAST,andWEST)and

then check each step.

3. Save your substitution.

4. Simulatethesubstitutiontochecktheresult: (Substitutioninitialscreen→

Simulate)

5. Activatethesubstitutionforyourcompanycodeincalluppoint0002.

ExitSubstitutionandgobacktothescreenChangeView“Substitutionfor

Special PurposeLedger/Co.Code”: Overview.

Continued on next page

239

第 258 页 / 共 509 页

Unit5: Validations,Substitutions,andRules AC220

Select New Entries.

Enter the following:

CompanyCode CallupPoint Substitution ActivationLevel

ACXX 2 GXX-SUB 1

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger

→BasicSettings→Substitution→MaintainSubstitution

6. EnterthefollowingFI-SLdocumentlines. UsethedocumenttypeA0and

user table GXX-UTAB:

The version for this posting is 1.

Account Special Region Amount inUSD

810200 N-xx1 5,000.00

810200 S-xx1 6,000.00

810300 W-xx1 1,000.00

810400 E-xx1 2,000.00

7. Check your postings (and substituted regions) using the FI-SL display

function for actual local documents.

240

第 259 页 / 共 509 页

AC220 Lesson: CreationandMaintenanceofValidationsandSubstitutions

Solution 10: Substitutions

Task:

Substitution

Postings to your regions N-xx1, S-xx1, E-xx1, and W-xx1 are to be replaced

by the following four zones:

NORTH, SOUTH, EAST, and WEST

1. Create the substitution, Gxx-SUB (xx = your group number) for the

applicationareaspecialpurposeledgerandthelineitem. Usetheusertable,

Gxx-UTAB,andenterthedescription,SubstitutionRegions.

In the menu, select:

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger

→ Basic Settings → Substitution → Maintain Local Substitution →

Environment → Substitution

SelectthelineitemandentertheusertableGXX-UTAB.SelectContinue

andenter your validation. Select Insert Step.

a) Createthesubstitution,Gxx-SUB(wherexxisyourgroupnumber)for

theapplicationareaGLandthecalluppoint0002. Usetheusertable,

Gxx-UTAB,andenterthedescription,SubstitutionRegions.

SAPReferenceIMG →Financial Accounting→SpecialPurpose

Ledger → Basic Settings → Substitution → Maintain Local

Substitution→Environment →Substitution

Substitution: Gxx-SUB

Applicationarea: SpecialPurposeLedger(GL)

Callup point: Line item (2)

Select Continue.

User table: GXX-UTAB

Validationdescription: Regions→ZONES

Continued on next page

241

第 260 页 / 共 509 页

Unit5: Validations,Substitutions,andRules AC220

2. Usethecorrespondingfieldtoenterfoursteps,andusetheFormulaBuilder

todefineaprerequisiteforeachsteprequiredinyoursubstitution. Ineach

step,enterthesubstitutedvalues(NORTH,SOUTH,EAST,andWEST)and

then check each step.

a) Usethecorrespondingfieldtoenterfoursteps, andusetheFormula

Builder to define a prerequisite for each step required in your

substitution. Ineachentry,enterthesubstitutedvaluesandthencheck

each step.

Select Insert Step.

a. SelectthefieldGLU1-RZZREGIONfromtheusertableandchoose

Continue

b. Description for the substitution entry: Special region: ZONE

NORTH ‘

c. Prerequisite Formula Builder

d. Double-click Special Region

e. Double- click =

f. Double-click Constant

g. Insert N-xx1 (xx=your group number)

Result: Special region = N-xx1

m. Select Back

n. Enter the substitution valueNORTH

o. Check the substitution step

p. Select Back

Insertanentryandrepeattheentriesa. top. forSOUTH,EAST,and

WEST.

3. Save your substitution.

a) Save your substitution.

Continued on next page

242