第 138 页 / 共 411 页
Unit4: DirectPostingsandAdjustments AC220
Figure 77: 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.
130
©2005SAPAG.Allrightsreserved. 2005/Q2
第 139 页 / 共 411 页
AC220 Lesson: Adjustment Postings in FI-SL
Master Data Validation
Figure 78: MasterData Validation forFI-SL Postings
Therearethreemainmethodstoensuremasterdatavaluationforcharacteristicsto
be used in FI-SL transactions:
ValidationagainstanFI-SL masterdatatable. Thesetableshaveastructureas
inT830A.YouhavetodefinethetablesintheDDICbeforehand,wherebyyou
canuseT830Aasareferencetable. Afterdefiningthetables,youmustenterthe
tablesinT800AwithtypeCMandCT.FI-SLConfigurationmenu: Environment?
Tabledirectory. YouthenhavetostartprogramRGBCFL00,selectingthe’Access
to integr. master data’ option.
YoucanmaintainthetablesontheFI-SLmenuunderEnvironment→Integr.
master data → Create, Change,
Validationusinganexitroutine. Theexitisdefinedas=nn,wherenrepresentsa
number. Theexitroutineitselfisstoredintheprogram,SAPLGUMD.
Validationagainstavalueandtexttable,whichyoumayhavesetupyourselfin
therepository. Thiswilleliminatethetime-consuming definitionofauser 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.
131
2005/Q2 © 2005 SAP AG. All rights reserved.
第 140 页 / 共 411 页
Unit4: DirectPostingsandAdjustments AC220
Document Display
Figure 79: Document Display
Usingthedocumentnumber,youcandisplaytherelevantlineitemsanytime.
By entering the document number, the document with the line items from the
correspondingtable,suchasZZSLA,iscalledup. Ifyouenteradocumentnumber
interval, you can call up several documents.
Thedocumentsarecalledupforacompanycodeoraglobalcompanyinaledger.
Youcanenterausertableorasummarytable. Ifyoudonotdothis,allthefields
in thetablecontainedintheledgerwill bedisplayed.
Thedocumentcategorydefinestheoriginofthedocument. Thepossiblevalues
include:
• B - Documents from accounting
• K - Documents from controlling
• G -DocumentsfromFI-SL for global postings
• L - Documents from FI-SL for local postings
• R - Rollup documents
• S- DocumentsassignedanFI-SLdocumentnumber
• W-DocumentswhicharetransferredtoFI-SLthroughtheRWdocument
132
©2005SAPAG.Allrightsreserved. 2005/Q2
第 141 页 / 共 411 页
AC220 Lesson: Adjustment Postings in FI-SL
Summary Record Display
Figure 80: Summary Record Display (Total)
Summary record displayincludesvariouslevels:
1. Entering the ledger and the period(s)
2. Restrictingthekeyfieldsforwhichyouwanttodisplaythesummaryrecords
3. SelectingthesummaryrecordsforperioddisplayAND
4. Selectingaperiodfordisplayingthelineitemdocuments
Byclickingacertaindocument,youcandisplaytheoriginaldocument.
133
2005/Q2 © 2005 SAP AG. All rights reserved.
第 142 页 / 共 411 页
Unit4: DirectPostingsandAdjustments AC220
Data Flow
Figure 81: Data Flow up to Release 4.6C
Figure 82: Data Flow as of SAP R/3 Enterprise
134
©2005SAPAG.Allrightsreserved. 2005/Q2
第 143 页 / 共 411 页
AC220 Lesson: Adjustment Postings in FI-SL
Foreign Currency Valuation
Figure83: ForeignCurrencyValuation: DifferencesinAccountingPrinciples
Figure 84: Foreign Currency Valuation: Receivable
135
2005/Q2 © 2005 SAP AG. All rights reserved.
第 144 页 / 共 411 页
Unit4: DirectPostingsandAdjustments AC220
Figure 85: Procedure: Foreign Currency Valuation (1)
Figure 86: Procedure Foreign Currency Valuation (2)
136
©2005SAPAG.Allrightsreserved. 2005/Q2
第 145 页 / 共 411 页
AC220 Lesson: Adjustment Postings in FI-SL
Exercise 6: FI Postings
Exercise Objectives
After completingthisexercise, youwillbeableto:
• PerformgeneralledgeraccountpostingsandchecktheresultsinFI-SL
• Setupcorrespondingmasterdataifyouarepostingrevenuepostingstothe
special regions
Business Example
ToupdatetheFI-SLledgers,overheadpostingsandrevenuesmustbepostedfrom
the feeder systems to FI-SL.
Beforeyoumakerevenuepostingstospecialregions,youmustenterappropriate
master data in a value table.
Task:
Postings from FI
ToperformG/Laccountpostings,usethefollowingmenupath:
SAPEasyAccess →FinancialAccounting→General Ledger →Document
Entry → Enter G/L Account Posting
1. Expenseaccountpostingsforthefunctionalareasadministration,sales,and
research and development:
Headerentries: Documentandpostingdate: Currentdate
Document type: SA
Companycode: ACxx(xx=your groupnumber)
Currency: USD
Usetheaccountassignmentmodel(→Acct.assgnmt)GL-SL01toperform
theposting. Youonlyhavetoenterthecostcenterstocompletetheposting
lines:
XX = your group number
PK Account TaxCode Amount CostCenter
40 420000 1,000.00 T-A20AXX
40 420000 2,000.00 T-A20BXX
40 420000 3,000.00 T-A20EXX
Continued on next page
137
2005/Q2 © 2005 SAP AG. All rights reserved.
| PK | Account | TaxCode | Amount | CostCenter |
|---|---|---|---|---|
| 40 | 420000 | 1,000.00 | T-A20AXX | |
| 40 | 420000 | 2,000.00 | T-A20BXX | |
| 40 | 420000 | 3,000.00 | T-A20EXX |
第 146 页 / 共 411 页
Unit4: DirectPostingsandAdjustments AC220
40 421000 7,000.00 T-A20AXX
40 421000 8,000.00 T-A20BXX
40 421000 9,000.00 T-A20EXX
40 430000 1,000.00 T-A20AXX
40 430000 2,000.00 T-A20BXX
40 430000 3,000.00 T-A20EXX
40 431000 1,000.00 T-A20AXX
40 431000 2,000.00 T-A20BXX
40 431000 3,000.00 T-A20EXX
40 472000 V0 4,000.00 T-A20AXX
40 472000 V0 5,000.00 T-A20BXX
40 472000 V0 6,000.00 T-A20EXX
40 476000 V0 7,000.00 T-A20AXX
40 476000 V0 8,000.00 T-A20BXX
40 476000 V0 9,000.00 T-A20EXX
Offsetposting:
50 399999 V0 81,000.00
2. Displaying Documents in FI
DisplaydocumentsforthispostinginFIandcalltheaccountingdocuments.
CheckifyourpostinghasenteredtheFI-SLsystembychoosingtheSpec.
PurposeLedgerdocumenttypeandviewingthelineitempostingforyour
ledger.
Write down the original accounting document number and the FI-SL
document number:
Accounting document number:
FI-SL document number:
3. Master Data for theCharacteristicZZSPREG
Hint: The special regions you create will be used for posting
customerinvoicesand,atalaterstageforpostingsinFI-SL.
Tocreatenewspecialregions,usethefollowingmenupath:
Continued on next page
138
©2005SAPAG.Allrightsreserved. 2005/Q2
| 40 | 421000 | 7,000.00 | T-A20AXX | |
|---|---|---|---|---|
| 40 | 421000 | 8,000.00 | T-A20BXX | |
| 40 | 421000 | 9,000.00 | T-A20EXX | |
| 40 | 430000 | 1,000.00 | T-A20AXX | |
| 40 | 430000 | 2,000.00 | T-A20BXX | |
| 40 | 430000 | 3,000.00 | T-A20EXX | |
| 40 | 431000 | 1,000.00 | T-A20AXX | |
| 40 | 431000 | 2,000.00 | T-A20BXX | |
| 40 | 431000 | 3,000.00 | T-A20EXX | |
| 40 | 472000 | V0 | 4,000.00 | T-A20AXX |
| 40 | 472000 | V0 | 5,000.00 | T-A20BXX |
| 40 | 472000 | V0 | 6,000.00 | T-A20EXX |
| 40 | 476000 | V0 | 7,000.00 | T-A20AXX |
| 40 | 476000 | V0 | 8,000.00 | T-A20BXX |
| 40 | 476000 | V0 | 9,000.00 | T-A20EXX |
| Offsetposting: | ||||
| 50 | 399999 | V0 | 81,000.00 |
第 147 页 / 共 411 页
AC220 Lesson: Adjustment Postings in FI-SL
System→Services→TableMaintenance→ExtendedTableMaintenance
→TableName: ZZSPREG→CreateEntriesicon→NewEntries
Createandsavethefollowingspecialregions: (XX=yourgroupnumber)
SpecialRegion Description
N-XX1 Region North 1 Group XX
S-XX1 Region South 1 Group XX
E-XX1 Region East 1 Group XX
W-XX1 Region West 1 Group XX
4. Revenuepostingsforspecialregionsandproducts(customerinvoiceposting)
In the menu, select:
SAPEasyAccess→FinancialAccounting→Customers→EnterGeneral
Ledger Account Posting
Header entries:
Document and posting date: Current date
Document type: DR
Companycode: ACXX(XX=yourcompanycode)
Currency: USD
Enter the following lines:
PK Customer Amount Calculate Tax Code
Tax
01 T-F00A00 240,000 x A0 (XX = your group
no.)
Call the account assignment model (→ Acct.assgnmt) DR-SL02, to post
the following lines:
Youonly need to enter theappropriate special regions(XX=your group
number).
PK Account Tax Amount BusArea Mat.no. Spec.Reg.
No. Code
50 810200 A0 10,000 0001 T-IC-F1001 N-XX1
50 810200 A0 10,000 1500 T-IC-F1002 S-XX1
50 810200 A0 10,000 8000 T-IC-F1003 E-XX1
Continued on next page
139
2005/Q2 © 2005 SAP AG. All rights reserved.
| SpecialRegion | Description |
|---|---|
| N-XX1 | Region North 1 Group XX |
| S-XX1 | Region South 1 Group XX |
| E-XX1 | Region East 1 Group XX |
| W-XX1 | Region West 1 Group XX |
| PK | Customer | Amount | Calculate Tax | Tax Code |
|---|---|---|---|---|
| 01 | T-F00A00 | 240,000 | x | A0 (XX = your group no.) |
| PK | Account No. | Tax Code | Amount | BusArea | Mat.no. | Spec.Reg. |
|---|---|---|---|---|---|---|
| 50 | 810200 | A0 | 10,000 | 0001 | T-IC-F1001 | N-XX1 |
| 50 | 810200 | A0 | 10,000 | 1500 | T-IC-F1002 | S-XX1 |
| 50 | 810200 | A0 | 10,000 | 8000 | T-IC-F1003 | E-XX1 |
第 148 页 / 共 411 页
Unit4: DirectPostingsandAdjustments AC220
50 810200 A0 10,000 9000 T-IC-R2007 W-XX1
50 810300 A0 20,000 0001 T-IC-F1001 N-XX1
50 810300 A0 20,000 1500 T-IC-F1002 S-XX1
50 810300 A0 20,000 8000 T-IC-F1003 E-XX1
50 810300 A0 20,000 9000 T-IC-R2008 W-XX1
50 810400 A0 30,000 0001 T-IC-F1001 N-XX1
50 810400 A0 30,000 1500 T-IC-F1002 S-XX1
50 810400 A0 30,000 8000 T-IC-F1003 E-XX1
50 810400 A0 30,000 9000 T-IC-R2009 W-XX1
Save your posting.
ViewtheFIdocument(herethecustomerinvoicedocumentnumber)and
write down the document numbers:
Accounting document number:
FI-SL document number:
140
©2005SAPAG.Allrightsreserved. 2005/Q2
| 50 | 810200 | A0 | 10,000 | 9000 | T-IC-R2007 | W-XX1 |
|---|---|---|---|---|---|---|
| 50 | 810300 | A0 | 20,000 | 0001 | T-IC-F1001 | N-XX1 |
| 50 | 810300 | A0 | 20,000 | 1500 | T-IC-F1002 | S-XX1 |
| 50 | 810300 | A0 | 20,000 | 8000 | T-IC-F1003 | E-XX1 |
| 50 | 810300 | A0 | 20,000 | 9000 | T-IC-R2008 | W-XX1 |
| 50 | 810400 | A0 | 30,000 | 0001 | T-IC-F1001 | N-XX1 |
| 50 | 810400 | A0 | 30,000 | 1500 | T-IC-F1002 | S-XX1 |
| 50 | 810400 | A0 | 30,000 | 8000 | T-IC-F1003 | E-XX1 |
| 50 | 810400 | A0 | 30,000 | 9000 | T-IC-R2009 | W-XX1 |
第 149 页 / 共 411 页
AC220 Lesson: Adjustment Postings in FI-SL
Solution 6: FI Postings
Task:
Postings from FI
ToperformG/Laccountpostings,usethefollowingmenupath:
SAPEasyAccess →FinancialAccounting→General Ledger →Document
Entry → Enter G/L Account Posting
1. Expenseaccountpostingsforthefunctionalareasadministration,sales,and
research and development:
Headerentries: Documentandpostingdate: Currentdate
Document type: SA
Companycode: ACxx(xx=your groupnumber)
Currency: USD
Usetheaccountassignmentmodel(→Acct.assgnmt)GL-SL01toperform
theposting. Youonlyhavetoenterthecostcenterstocompletetheposting
lines:
XX = your group number
PK Account TaxCode Amount CostCenter
40 420000 1,000.00 T-A20AXX
40 420000 2,000.00 T-A20BXX
40 420000 3,000.00 T-A20EXX
40 421000 7,000.00 T-A20AXX
40 421000 8,000.00 T-A20BXX
40 421000 9,000.00 T-A20EXX
40 430000 1,000.00 T-A20AXX
40 430000 2,000.00 T-A20BXX
40 430000 3,000.00 T-A20EXX
40 431000 1,000.00 T-A20AXX
40 431000 2,000.00 T-A20BXX
40 431000 3,000.00 T-A20EXX
40 472000 V0 4,000.00 T-A20AXX
40 472000 V0 5,000.00 T-A20BXX
Continued on next page
141
2005/Q2 © 2005 SAP AG. All rights reserved.
| PK | Account | TaxCode | Amount | CostCenter |
|---|---|---|---|---|
| 40 | 420000 | 1,000.00 | T-A20AXX | |
| 40 | 420000 | 2,000.00 | T-A20BXX | |
| 40 | 420000 | 3,000.00 | T-A20EXX | |
| 40 | 421000 | 7,000.00 | T-A20AXX | |
| 40 | 421000 | 8,000.00 | T-A20BXX | |
| 40 | 421000 | 9,000.00 | T-A20EXX | |
| 40 | 430000 | 1,000.00 | T-A20AXX | |
| 40 | 430000 | 2,000.00 | T-A20BXX | |
| 40 | 430000 | 3,000.00 | T-A20EXX | |
| 40 | 431000 | 1,000.00 | T-A20AXX | |
| 40 | 431000 | 2,000.00 | T-A20BXX | |
| 40 | 431000 | 3,000.00 | T-A20EXX | |
| 40 | 472000 | V0 | 4,000.00 | T-A20AXX |
| 40 | 472000 | V0 | 5,000.00 | T-A20BXX |
第 150 页 / 共 411 页
Unit4: DirectPostingsandAdjustments AC220
40 472000 V0 6,000.00 T-A20EXX
40 476000 V0 7,000.00 T-A20AXX
40 476000 V0 8,000.00 T-A20BXX
40 476000 V0 9,000.00 T-A20EXX
Offsetposting:
50 399999 V0 81,000.00
a) Postings from FI
ToperformG/Laccountpostings,usethefollowingmenupath:
SAP EasyAccess→ Financial Accounting →General Ledger →
Document Entry → General Posting
Expenseaccountpostingsforthefunctionalareasadministration,sales,
and research and development:
Headerentries: Documentandpostingdate: Currentdate
Document type: SA
Companycode: ACxx(xx=yourgroupnumber)
Currency: USD
Use the account assignment model (→ Acct.assgnmt) GL-SL01
to perform the posting. You only have to enter the cost centers to
complete the posting lines:
XX = your group number
PK Account TaxCode Amount CostCenter
40 420000 1,000.00 T-A20AXX
40 420000 2,000.00 T-A20BXX
40 420000 3,000.00 T-A20EXX
40 421000 7,000.00 T-A20AXX
40 421000 8,000.00 T-A20BXX
40 421000 9,000.00 T-A20EXX
40 430000 1,000.00 T-A20AXX
40 430000 2,000.00 T-A20BXX
40 430000 3,000.00 T-A20EXX
40 431000 1,000.00 T-A20AXX
Continued on next page
142
©2005SAPAG.Allrightsreserved. 2005/Q2
| 40 | 472000 | V0 | 6,000.00 | T-A20EXX |
|---|---|---|---|---|
| 40 | 476000 | V0 | 7,000.00 | T-A20AXX |
| 40 | 476000 | V0 | 8,000.00 | T-A20BXX |
| 40 | 476000 | V0 | 9,000.00 | T-A20EXX |
| Offsetposting: | ||||
| 50 | 399999 | V0 | 81,000.00 |
| PK | Account | TaxCode | Amount | CostCenter |
|---|---|---|---|---|
| 40 | 420000 | 1,000.00 | T-A20AXX | |
| 40 | 420000 | 2,000.00 | T-A20BXX | |
| 40 | 420000 | 3,000.00 | T-A20EXX | |
| 40 | 421000 | 7,000.00 | T-A20AXX | |
| 40 | 421000 | 8,000.00 | T-A20BXX | |
| 40 | 421000 | 9,000.00 | T-A20EXX | |
| 40 | 430000 | 1,000.00 | T-A20AXX | |
| 40 | 430000 | 2,000.00 | T-A20BXX | |
| 40 | 430000 | 3,000.00 | T-A20EXX | |
| 40 | 431000 | 1,000.00 | T-A20AXX |
第 151 页 / 共 411 页
AC220 Lesson: Adjustment Postings in FI-SL
40 431000 2,000.00 T-A20BXX
40 431000 3,000.00 T-A20EXX
40 472000 V0 4,000.00 T-A20AXX
40 472000 V0 5,000.00 T-A20BXX
40 472000 V0 6,000.00 T-A20EXX
40 476000 V0 7,000.00 T-A20AXX
40 476000 V0 8,000.00 T-A20BXX
40 476000 V0 9,000.00 T-A20EXX
Offsetposting:
50 399999 V0 81,000.00
2. Displaying Documents in FI
DisplaydocumentsforthispostinginFIandcalltheaccountingdocuments.
CheckifyourpostinghasenteredtheFI-SLsystembychoosingtheSpec.
PurposeLedgerdocumenttypeandviewingthelineitempostingforyour
ledger.
Write down the original accounting document number and the FI-SL
document number:
Accounting document number:
FI-SL document number:
a) Displaying Documents in FI
Display documents for this posting in FI and call the accounting
documents. Check if your posting has entered the FI-SL system by
choosingtheSpec. PurposeLedgerdocument typeand viewingthe
line item posting for your ledger.
WritedowntheoriginalaccountingdocumentnumberandtheFI-SL
document number:
Accounting document number:
FI-SL document number:
3. Master Data for theCharacteristic ZZSPREG
Hint: The special regions you create will be used for posting
customerinvoicesand,atalaterstageforpostingsinFI-SL.
Tocreatenewspecialregions,usethefollowingmenupath:
Continued on next page
143
2005/Q2 © 2005 SAP AG. All rights reserved.
| 40 | 431000 | 2,000.00 | T-A20BXX | |
|---|---|---|---|---|
| 40 | 431000 | 3,000.00 | T-A20EXX | |
| 40 | 472000 | V0 | 4,000.00 | T-A20AXX |
| 40 | 472000 | V0 | 5,000.00 | T-A20BXX |
| 40 | 472000 | V0 | 6,000.00 | T-A20EXX |
| 40 | 476000 | V0 | 7,000.00 | T-A20AXX |
| 40 | 476000 | V0 | 8,000.00 | T-A20BXX |
| 40 | 476000 | V0 | 9,000.00 | T-A20EXX |
| Offsetposting: | ||||
| 50 | 399999 | V0 | 81,000.00 |
第 152 页 / 共 411 页
Unit4: DirectPostingsandAdjustments AC220
System→Services→TableMaintenance→ExtendedTableMaintenance
→TableName: ZZSPREG→CreateEntriesicon→NewEntries
Createandsavethefollowingspecialregions: (XX=yourgroupnumber)
SpecialRegion Description
N-XX1 Region North 1 Group XX
S-XX1 Region South 1 Group XX
E-XX1 Region East 1 Group XX
W-XX1 Region West 1 Group XX
a) MasterDatafor theCharacteristicZZSPREG
Hint: Thespecialregionsyoucreatewillbeusedforposting
customerinvoicesandforpostingsinFI-SL.
Tocreatenewspecialregions,usethefollowingmenupath:
System → Services → Table Maintenance → Extended Table
Maintenance → Table Name: ZZSPREG → Create Entries icon
→ New Entries
Create and save the following special regions: (XX= your group
number)
SpecialRegion Description
N-XX1 Region North1 Group XX
S-XX1 Region South1 GroupXX
E-XX1 Region East 1 Group XX
W-XX1 Region West 1 Group XX
4. Revenuepostingsforspecialregionsandproducts(customerinvoiceposting)
In the menu, select:
SAPEasyAccess→FinancialAccounting→Customers→EnterGeneral
Ledger Account Posting
Header entries:
Document and posting date: Current date
Document type: DR
Companycode: ACXX(XX=yourcompanycode)
Continued on next page
144
©2005SAPAG.Allrightsreserved. 2005/Q2
| SpecialRegion | Description |
|---|---|
| N-XX1 | Region North 1 Group XX |
| S-XX1 | Region South 1 Group XX |
| E-XX1 | Region East 1 Group XX |
| W-XX1 | Region West 1 Group XX |
| SpecialRegion | Description |
|---|---|
| N-XX1 | Region North1 Group XX |
| S-XX1 | Region South1 GroupXX |
| E-XX1 | Region East 1 Group XX |
| W-XX1 | Region West 1 Group XX |
第 153 页 / 共 411 页
AC220 Lesson: Adjustment Postings in FI-SL
Currency: USD
Enter the following lines:
PK Customer Amount Calculate Tax Code
Tax
01 T-F00A00 240,000 x A0 (XX = your group
no.)
Call the account assignment model (→ Acct.assgnmt) DR-SL02, to post
the following lines:
Youonly need to enter theappropriate special regions(XX=your group
number).
PK Account Tax Amount BusArea Mat.no. Spec.Reg.
No. Code
50 810200 A0 10,000 0001 T-IC-F1001 N-XX1
50 810200 A0 10,000 1500 T-IC-F1002 S-XX1
50 810200 A0 10,000 8000 T-IC-F1003 E-XX1
50 810200 A0 10,000 9000 T-IC-R2007 W-XX1
50 810300 A0 20,000 0001 T-IC-F1001 N-XX1
50 810300 A0 20,000 1500 T-IC-F1002 S-XX1
50 810300 A0 20,000 8000 T-IC-F1003 E-XX1
50 810300 A0 20,000 9000 T-IC-R2008 W-XX1
50 810400 A0 30,000 0001 T-IC-F1001 N-XX1
50 810400 A0 30,000 1500 T-IC-F1002 S-XX1
50 810400 A0 30,000 8000 T-IC-F1003 E-XX1
50 810400 A0 30,000 9000 T-IC-R2009 W-XX1
Save your posting.
ViewtheFIdocument (herethecustomerinvoicedocumentnumber) and
write down the document numbers:
Accounting document number:
FI-SL document number:
a) Revenuepostingsforspecialregionsandproducts(customerinvoice
posting)
In the menu, select:
Continued on next page
145
2005/Q2 © 2005 SAP AG. All rights reserved.
| PK | Customer | Amount | Calculate Tax | Tax Code |
|---|---|---|---|---|
| 01 | T-F00A00 | 240,000 | x | A0 (XX = your group no.) |
| PK | Account No. | Tax Code | Amount | BusArea | Mat.no. | Spec.Reg. |
|---|---|---|---|---|---|---|
| 50 | 810200 | A0 | 10,000 | 0001 | T-IC-F1001 | N-XX1 |
| 50 | 810200 | A0 | 10,000 | 1500 | T-IC-F1002 | S-XX1 |
| 50 | 810200 | A0 | 10,000 | 8000 | T-IC-F1003 | E-XX1 |
| 50 | 810200 | A0 | 10,000 | 9000 | T-IC-R2007 | W-XX1 |
| 50 | 810300 | A0 | 20,000 | 0001 | T-IC-F1001 | N-XX1 |
| 50 | 810300 | A0 | 20,000 | 1500 | T-IC-F1002 | S-XX1 |
| 50 | 810300 | A0 | 20,000 | 8000 | T-IC-F1003 | E-XX1 |
| 50 | 810300 | A0 | 20,000 | 9000 | T-IC-R2008 | W-XX1 |
| 50 | 810400 | A0 | 30,000 | 0001 | T-IC-F1001 | N-XX1 |
| 50 | 810400 | A0 | 30,000 | 1500 | T-IC-F1002 | S-XX1 |
| 50 | 810400 | A0 | 30,000 | 8000 | T-IC-F1003 | E-XX1 |
| 50 | 810400 | A0 | 30,000 | 9000 | T-IC-R2009 | W-XX1 |
第 154 页 / 共 411 页
Unit4: DirectPostingsandAdjustments AC220
SAP Easy Access → Accounting → Financial Accounting →
AccountsReceivable→DocumentEntry→Invoice-general
Header entries:
Document and posting date: Current date
Document type: DR
Companycode: ACXX(XX=yourcompanycode)
Currency: USD
Enter the following lines:
PK Customer Amount Calculate Tax Code
Tax
01 T-F00A00 240,000 x A0(XX=yourgroup
no.)
Call theaccount assignment model (→Acct.assgnmt)DR-SL02, to
post the following lines:
You only need to enter the appropriate special regions (XX = your
group number).
PK Account Tax Amount BusArea Mat.no. Spec.Reg.
No. Code
50 810200 A0 10,000 0001 T-IC- N-XX1
F1001
50 810200 A0 10,000 1500 T-IC- S-XX1
F1002
50 810200 A0 10,000 8000 T-IC- E-XX1
F1003
50 810200 A0 10,000 9000 T-IC- W-XX1
R2007
50 810300 A0 20,000 0001 T-IC- N-XX1
F1001
50 810300 A0 20,000 1500 T-IC- S-XX1
F1002
50 810300 A0 20,000 8000 T-IC- E-XX1
F1003
50 810300 A0 20,000 9000 T-IC- W-XX1
R2008
Continued on next page
146
©2005SAPAG.Allrightsreserved. 2005/Q2
| PK | Customer | Amount | Calculate Tax | Tax Code |
|---|---|---|---|---|
| 01 | T-F00A00 | 240,000 | x | A0(XX=yourgroup no.) |
| PK | Account No. | Tax Code | Amount | BusArea | Mat.no. | Spec.Reg |
|---|---|---|---|---|---|---|
| 50 | 810200 | A0 | 10,000 | 0001 | T-IC- F1001 | N-XX1 |
| 50 | 810200 | A0 | 10,000 | 1500 | T-IC- F1002 | S-XX1 |
| 50 | 810200 | A0 | 10,000 | 8000 | T-IC- F1003 | E-XX1 |
| 50 | 810200 | A0 | 10,000 | 9000 | T-IC- R2007 | W-XX1 |
| 50 | 810300 | A0 | 20,000 | 0001 | T-IC- F1001 | N-XX1 |
| 50 | 810300 | A0 | 20,000 | 1500 | T-IC- F1002 | S-XX1 |
| 50 | 810300 | A0 | 20,000 | 8000 | T-IC- F1003 | E-XX1 |
| 50 | 810300 | A0 | 20,000 | 9000 | T-IC- R2008 | W-XX1 |
第 155 页 / 共 411 页
AC220 Lesson: Adjustment Postings in FI-SL
50 810400 A0 30,000 0001 T-IC- N-XX1
F1001
50 810400 A0 30,000 1500 T-IC- S-XX1
F1002
50 810400 A0 30,000 8000 T-IC- E-XX1
F1003
50 810400 A0 30,000 9000 T-IC- W-XX1
R2009
Save your posting.
ViewtheFIdocumentinthesamewayasin1-1-2(herethecustomer
invoicedocumentnumber)andwritedownthedocumentnumbers:
Accounting document number:
FI-SL document number:
147
2005/Q2 © 2005 SAP AG. All rights reserved.
| 50 | 810400 | A0 | 30,000 | 0001 | T-IC- F1001 | N-XX1 |
|---|---|---|---|---|---|---|
| 50 | 810400 | A0 | 30,000 | 1500 | T-IC- F1002 | S-XX1 |
| 50 | 810400 | A0 | 30,000 | 8000 | T-IC- F1003 | E-XX1 |
| 50 | 810400 | A0 | 30,000 | 9000 | T-IC- R2009 | W-XX1 |
第 156 页 / 共 411 页
Unit4: DirectPostingsandAdjustments AC220
148
©2005SAPAG.Allrightsreserved. 2005/Q2
第 157 页 / 共 411 页
AC220 Lesson: Adjustment Postings in FI-SL
Exercise 7: Adjustment Postings in FI-SL
Document and Display of Totals Records
Exercise Objectives
After completingthisexercise, youwillbeableto:
• Createaledgerversionforadjustmentactualpostings
• Create a user table for data entry
• Perform adjustment postings
• Display single items and totals records
Business Example
You need to make adjustment postings in FI-SL for special regions to adjust
revenuesforproductsthathavebeenevaluatedasstandard.
ThedirectentryfunctioninFI-SLisanalyzedforthispurpose.
Task:
Adjustment Postings in FI-SL
1. Createaversion2foractualpostingstoyourledgerinFI-SL.
In the menu, select:
SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger
→ActualPosting→Maintain Actual Versions
Ledger Version ActivateVersion VersionDescription
Yourledger 2 x Version2Adjustments
2. User Tablefor 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
Continued on next page
149
2005/Q2 © 2005 SAP AG. All rights reserved.
| Ledger | Version | ActivateVersion | VersionDescription |
|---|---|---|---|
| Yourledger | 2 | x | Version2Adjustments |
第 158 页 / 共 411 页
Unit4: DirectPostingsandAdjustments AC220
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
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:___________________
4. Document Display
In the menu, select:
SAP Easy Access → Accounting → Financial Accounting → Special
PurposeLedger→ActualPosting→DocumentEntry
Continued on next page
150
©2005SAPAG.Allrightsreserved. 2005/Q2
| 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 |
| 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 |
第 159 页 / 共 411 页
AC220 Lesson: Adjustment Postings in FI-SL
ViewthedocumentnumbersthatyounotedfromyourFI-GL,FI-DR,and
FI-SLpostingsanddrilldowntoviewtheoriginal documentsforyour FI
postings.
5. Totals Display
In the menu, select:
SAP Easy Access → Accounting → Financial Accounting → Special
PurposeLedger→ActualPosting→TotalsRecordDisplay
ViewthetotalsrecordsthatyourecordedfromyourFI-GL(1-1-2),FI-DR
(1-1-4),andFI-SL(1-2-3)postings,drilldowntothesingleitemsandtothe
original documents for your FI postings.
151
2005/Q2 © 2005 SAP AG. All rights reserved.
第 160 页 / 共 411 页
Unit4: DirectPostingsandAdjustments AC220
Solution 7: 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
152
©2005SAPAG.Allrightsreserved. 2005/Q2
| Ledger | Version | ActivateVersion | VersionDescription |
|---|---|---|---|
| Yourledger | 2 | x | Version2Adjustments |
| Ledger | Version | ActivateVersion | VersionDescription |
|---|---|---|---|
| Your ledger | 2 | x | Version2Adjustments |
第 161 页 / 共 411 页
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
153
2005/Q2 © 2005 SAP AG. All rights reserved.
| 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 |
第 162 页 / 共 411 页
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
154
©2005SAPAG.Allrightsreserved. 2005/Q2
| 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 |
第 163 页 / 共 411 页
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
155
2005/Q2 © 2005 SAP AG. All rights reserved.
第 164 页 / 共 411 页
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.
156
©2005SAPAG.Allrightsreserved. 2005/Q2
第 165 页 / 共 411 页
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
157
2005/Q2 © 2005 SAP AG. All rights reserved.
第 166 页 / 共 411 页
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
158
©2005SAPAG.Allrightsreserved. 2005/Q2
第 167 页 / 共 411 页
AC220 Test Your Knowledge
Test Your Knowledge
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?
159
2005/Q2 © 2005 SAP AG. All rights reserved.
第 168 页 / 共 411 页
TestYourKnowledge AC220
Answers
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
160
©2005SAPAG.Allrightsreserved. 2005/Q2
第 169 页 / 共 411 页
Unit 5
Validations, Substitutions, and Rules
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.............162
Exercise 8: Validations.....................................................169
Lesson: Creation and Maintenance of Validations and Substitutions....177
Exercise 9: Substitutions..................................................185
161
2005/Q2 © 2005 SAP AG. All rights reserved.
第 170 页 / 共 411 页
Unit5: Validations,Substitutions,andRules AC220
Lesson: Functionality of FI-SL Validations and
Substitutions
Lesson Overview
ThislessonprovidesanoverviewofFI-SLvalidationsandsubstitutions. Italso
provides examples of validations and substitutions. In addition, it describes
call-up points in validations.
Lesson Objectives
After completingthislesson, you will beable to:
• Describevalidationand substitutionexamples
• Describe call-up points in validations
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
to providesummarizeddatainchosencombinations.
The management also requires a field (characteristic) called Special Region,
which can beused to provide an additional geographical breakdownin certain
financialreports. Thisfield(characteristic)hasbeencreatedbecauseit hasnot
beendeliveredbySAP.Afterthecharacteristicsandkeyfigureshavebeensorted
logicallyintogroupsfortherequiredreports,databasetablesmustbegenerated
andinstalledforthevariousFI-SLcomponentsbeforetheycanbemadeavailable
forupdateandreporting. Businessmanagershavetoensurethatanyadjustment
postingsmadeinFI-SLarerestrictedtothecorrectversionanddocumenttype.
Additionally,thecorrectcombinationsofBusinessLinesandrevenuesforspecial
reportsmustbeavailableinsuchpostings. Youneedtoexplorethefunctionsof
validationandsubstitutiontomeetthemanagementrequirements.
162
©2005SAPAG.Allrightsreserved. 2005/Q2
第 171 页 / 共 411 页
AC220 Lesson: Functionality of FI-SL Validations and Substitutions
Overview of FI-SL Validations and Substitutions
Figure 87: Validations, Substitutions,andRules: Overview
Figure 88: Procedure
163
2005/Q2 © 2005 SAP AG. All rights reserved.