AC280_EN_Col92_FV_Part_A4 (第8页) | ERP软件技术分享

第 290 页 / 共 319 页

Unit5: InsightintoBWforFinancialAccountingQueries AC280

Re-activatetheinteractivefunctionsandthenremovethefiltervalue

for the customers.

Withtherightmouse,selectanycellandchooseOperatingConcern

→ Properties

TitleElement Field Name Value

Interaction Allow Interactive

Functions

Choose OK.

SelectCustomerwiththeright-handmouseandchooseRemovefilter

value from the context menu.

2. AddthequeryyoucreatedAC280QUERY2GR##(##=yourgroupnumber)

totheworksheetalongsidequeryAC280QUERY1GR##(##=yourgroup

number).

Hint: Toinsertthesecondquery, selectacell inExcel columnF

alongsideyourqueryalreadylocatedintheworksheet(forexample,

line 1, column F)

Entercustomer1000tocustomer2000andperiod012inyear2002. Asthe

filtervalueforyourcustomersforAC280QUERY1GR##,enterthevalue

range1000through2000(BeckerBerlinthroughCarborGmbH).Remove

exception GR##-EXCEPTION from the second query (AC280 QUERY2

GR##).

Update (refresh) your second query (AC280 QUERY2 GR##). You are

requiredtoenterthevalueofthevariableforperiod/year. Accepttheentries

and execute the query again.

Continued on next page

274

TitleElement	Field Name	Value
Interaction	Allow Interactive Functions

第 291 页 / 共 319 页

AC280 Lesson: Exceptions, Conditions, and Other Query Properties

Save the results of the two queries jointly as a new workbook with the

description 2 Queries GR##.

a) Tools → Add Query

PlacethecursoronAC280QUERY2GR##. ChooseOK.

Entercustomer1000tocustomer2000andperiod012inyear2002.

Execute.

b) As the filter value for your customers for AC280 QUERY1 GR##,

enter the value range 1000 through 2000 (Becker Berlin through

Carbor GmbH).

SelectCustomerandchooseFindFilterValuefromthecontextmenu.

Selection for customer: Value Range

Placeyourcursoronthefirstentry(=Becker). Usingtherightmouse,

chooseTechnicalNamesfromthecontextmenu.

Double-click 1000 and scroll down through the list until you reach

2000. Double-click 2000. Choose OK.

RemoveexceptionGR##-EXCEPTIONfromthesecondquery(AC280

QUERY2 GR##).

Usingtheright-handmouse,selectanycellintheoperatingconcernof

queryAC280QUERY2GR##. ChooseExceptionsandthenselectyour

exceptionGR##-EXCEPTION.Thiscallsupyourexception.

Update(refresh)yoursecondquery(AC280QUERY2GR##). Youare

requiredtoenterthevalueofthevariableforperiod/year. Acceptthe

entries and execute the query again.

PlaceyourcursoronanycellintheoperatingconcernofqueryAC280

QUERY2 GR##.

Choose the Refresh Query icon.

Execute

c) Save the resultsof the two queries jointly as a new workbook with

the name 2 Queries GR##.

Choose the Save icon.

Saveasanewworkbook. Enter2QueriesGR##asthedescription.

Choose OK.

3. Nowexecuteyour threeworkbooksconsecutively:

• Result Query 1 GR##

Continued on next page

275

第 292 页 / 共 319 页

Unit5: InsightintoBWforFinancialAccountingQueries AC280

• Result Query 2 GR## and

• 2 Queries GR##

a) Choose the Open icon and then select and execute the three

workbooksmentionedabove(bychoosingtheOKpushbutton).

276

第 293 页 / 共 319 页

AC280 Lesson: Exceptions, Conditions, and Other Query Properties

Lesson Summary

You should now be able to:

• Defineconditionsandexceptionsandusethemwhenyoudisplayaquery

• Tailorcertainpropertiesofqueriestoyourrequirements

• Add queries to existing workbooks

277

第 294 页 / 共 319 页

UnitSummary AC280

Unit Summary

You should now be able to:

• Explain thebasics of SAP BW architecture

• GainanoverviewoftheInfoProvidersinFinancials

• ExplainthebasicsoftheInfoCube0FIAR_C02: FIARTransactionData

• Create and change queries

• Explainandusethenavigationoptionsprovidedforquerydisplay

• Save query output in a workbook

• Defineandusecharacteristicvalueandtextvariables

• Defineconditionsandexceptionsandusethemwhenyoudisplayaquery

• Tailorcertainpropertiesofqueriestoyourrequirements

• Add queries to existing workbooks

278

第 295 页 / 共 319 页

第 296 页 / 共 319 页

第 297 页 / 共 319 页

Unit 6

Appendices

Unit Overview

• AdditionalInformationAboutDrilldownReporting

• Menu Paths

Unit Objectives

After completing thisunit, you will beableto:

• Describestandardcharacteristics, keyfigures, andstandardvariables,and

list transactionsused in drilldown reporting

• FindmenupathsintheImplementationGuide(IMG)

Unit Contents

Lesson: Appendix...............................................................280

279

第 298 页 / 共 319 页

Unit6: Appendices AC280

Lesson: Appendix

Lesson Overview

• AdditionalInformationAboutDrilldownReporting

• Menu Paths

Lesson Objectives

After completingthislesson, you will beable to:

• Describestandardcharacteristics,keyfigures, andstandardvariables, and

list transactions used in drilldown reporting

• FindmenupathsintheImplementationGuide(IMG)

Business Example

Now that you have looked at drilldown reporting, you want to find out about

standard characteristics and key figures, as well as standard variables and

transactions.

Additional Information About Drilldown Reporting

Drilldown Reporting in FI: Appendix

• Constants

• Cell Calculation with Constants

• Texts

• GL Drilldown Reporting: Customizing

• GLDrilldownReporting: Standardcharacteristicsandkeyfigures

• GL Drilldown Reporting: Standard variables

• GL Drilldown Reporting: Transactions

• Drilldown Reporting: FI-GL and FI-SL

• GL Drilldown Reporting: Documentation

280

第 299 页 / 共 319 页

AC280 Lesson: Appendix

Figure 120: Constants

Figure 121: Cell Calculation with Constants

281

第 300 页 / 共 319 页

Unit6: Appendices AC280

Additional cell types for cell definition:

• Selection with key figure (value field):

• ChooseSelectionwithkeyfigure(valuefield)ifyouwantaseparateselection

atcelllevel. Youthendefinethecellbyselectingakeyfigure,characteristics

andtheir values, andbyspecifyingaspecialcelltext. Thiscelldefinition

isvisualizedbythesquaredcharacter. Notethatthisspecialcelldoesnot

havetocontainthevaluethatwouldresultfromtheintersectionoftherow

and column selection.

• Defineformulapriority: Thisoptionisofferedifthecolumnandtherow

containformulas. Hereyoudefinewhich of theformulasisto be usedto

calculatethecell. Aresultfromthecolumnformulameansthattheformula

definedin thecolumn isused. Aresult from row formulameans that the

formuladefinedintherowisused. Cellsforwhichyouhavetodefinethe

formulapriorityhavearedquestionmarkintheform. Theselectedformula

is visualized usinganarrow symbol that points tothedimensionthat has

priority(Ifthecolumnformulahaspriority,thearrowpointsupwards;ifthe

rowformulahaspriority, thearrowpointsleft).

Figure 122: GL Drilldown Reporting: Customizing

282

第 301 页 / 共 319 页

AC280 Lesson: Appendix

Figure 123: GL Drilldown Reporting: Standard characteristics and key

figures

Figure 124: GL Drilldown Reporting: Standard Variables

283

第 302 页 / 共 319 页

Unit6: Appendices AC280

Figure 125: GL Drilldown Reporting: Transactions

Figure 126: Drilldown Reporting: FI-SL

You can usedrilldownreportingto evaluateanyFI-SL totalstables. Youcan

create and display the following reports:

• Account balances

• Financial statement reports

• Lineitemreportscalledupfromthetotalsreport

• FlexiblereportsusingSAPaccount assignmentsandyourownadditional

account assignments

284

第 303 页 / 共 319 页

AC280 Lesson: Appendix

TheevaluationofFI-SL totalstablesusing drilldownreportingislimited. The

following restrictions apply:

• You can evaluate only one ledger.

• Youcanonlyreportusingthesecondorthirdcurrency(usuallythelocalor

groupcurrency)andonequantity(noadditionalquantity).

• Youcandisplayonly onecurrency inthereport.

BeforeyouevaluateyourownFI-SLtablesusingdrilldownreporting,youhave

toactivatethedrilldownreportingstructurefortherelevantFI-SLtotalstables.

The drilldown reporting field catalog is only updated for the newfields of the

totals table.

Figure 127: Drilldown Reporting: Documentation

Menu Paths

Unit: StandardreportsinFI-GL,FI-AR,andFI-AP

System → Services → Reporting SA38

Goto → Variants

Variant → Create

→ Display

→ Change

→ Copy

Edit → Attributes

Environment→MaintainSelectionVariables STVARV

SAP Easy Access menu

Accounting

→ Financial Accounting

→ General ledger

285

第 304 页 / 共 319 页

Unit6: Appendices AC280

→ information system

→ General Ledger Reports (New)

→ Financial Statement/Cash Flow

→ General

→Actual/Actualcomparisons

→ Plan/Actual comparison

→ Cash Flow

(...)

→ Account balances

→ General

→ G/L account balances

(...)

→Structuredaccount balances

(...)

→ Line items

→ General ledger line items

→Generalledgerlineitems,listforprinting

(...)

→ Document

→ General

→ Document journal

→Compact documentjournal

→ Line item journal

→Displayofchangeddocuments

(…)

→ Master data

→ Chart of accounts

→ G/L account list

→Account assignment manual

→DisplaychangestoG\Laccounts

→ Accounts Receivable

→ information system

286

第 305 页 / 共 319 页

AC280 Lesson: Appendix

→ Reports for Accounts Receivable Accounting→

Customers balances

→ Customer balances

→Customerbalancesinlocalcurrency

→ Customer sales

(...)

→ Vendor items

→Duedateanalysisforopenitems

→Listofvendoropenitemsforprinting

→OI- Vendorduedateforecast

→VendorpaymenthistorywithOIsortedlist

(...)

→Listofvendorcleareditemsforprinting

→Listofdownpaymentsopenonkeydate

→ Master data

→ Vendor list

→ Address list

→ Displaychanges to vendors

→Display/confirmcriticalvendorchanges

Unit: Reportsin user roles Transaction codes

(or transaction SM30, then Table/View)

Menu → Create role PFCG

Unit: List Viewer Transaction codes

(or transaction SM30, then Table/View)

SAPEasy Access Menu

Accounting

→ Financial Accounting

→ General ledger

→ Account

Displaybalances(new) FAGLB03

Display/changelineitems FAGLL03

287

第 306 页 / 共 319 页

Unit6: Appendices AC280

→ Accounts receivable

→ Account

Display balances FD10N

Display/changelineitems FBL5N

→ Accounts payable

→ Account

Display balances FK10N

Display/changelineitems FBL1N

ImplementationGuideforR/3Configuration(IMG)

Financial Accounting

→ General Ledger Accounting

→ G/L accounts

→ Line items

→ Display Line Items with ALV

→DefineSpecialFieldsforFindingandSortingData

→AccountsReceivableandAccountsPayable

→ Customer Accounts

→ Line items

→ Display Line Items

→DefineAdditionalFieldsforLineItemDisplay

→ Local Reporting for LineItems

→ Maintain Selection Variants for the Display of

Customer Line Items

→ Vendor Accounts

→ Line items

→ Display Line Items

→DefineAdditionalFieldsforLineItemDisplay

→ Local Reporting for LineItems

→ Maintain Selection Variants for the Display of

Vendor Line Items

288

第 307 页 / 共 319 页

AC280 Lesson: Appendix

Unit: Accounts Receivable/Accounts Payable Transaction codes

Information System

ImplementationGuideforR/3 (or transaction SM30, then Table/View)

Configuration(IMG)

→ Financial Accounting

→AccountsReceivableandAccountsPayable

→ Information System

→ Accounts receivable

→ Standard Evaluations

CopyStandardEvaluations FY01

SelectStandardEvaluations OBDF

EnhanceStandardEvaluations CMOD

→ Accounts payable

→ Standard Evaluations

CopyStandardEvaluations FY01

SelectStandardEvaluations OBDF

EnhanceStandardEvaluations CMOD

Application:

SAP Easy Access menu

→ Accounting

→ Financial Accounting

→ Accounts receivable

→ information system

→ Tools

→ Configure

→Specifydatavolume OBAN

→Select evaluations OBAJ

→CreateEvaluations F0.29

→ Display evaluations F0.30

Application:

SAP Easy Access menu

→ Accounting

→ Financial Accounting

289

第 308 页 / 共 319 页

Unit6: Appendices AC280

→ Accounts payable

→ information system

→ Tools

→ Configure

→Specifydatavolume OBAO

→ Select evaluations OBAK

→CreateEvaluations F0.45

→ Display evaluations F.46

Unit: DrilldownReportinginFI Transaction codes

ImplementationGuidefor R/3Configuration(IMG)

→ Financial Accounting

→ General Ledger Accounting (new)

→ Information System

→Drilldown Reports (G/L Accounts)

→ Form

→ Define Form

Specifyform CreateForm FGI4

Change Form FGI5

Display Form FGI6

Transport Form FGIP

ImportFormfromClient000 FGIR

Delete Form FGIZ

→ Define Report

Create report FGI1

Change Report FGI2

Display Report FSI3

Transport Report FGIO

ImportReportfromClient000 FGIQ

Delete Report FGIX

(...)

290

第 309 页 / 共 319 页

AC280 Lesson: Appendix

→DefineGlobal Variables FGIV

(...)

→ Delete Report Data FGIY

Transaction codes: Short description

FGI0 Execute report

FGI1 Create report

FGI2 Change report

FGI3 Display report

FGI4 Create form

FGI5 Change form

FGI6 Display form

FGIB Background processing

FGIC Maintain currency translation type

FGIG Characteristic groups

FGIK Maintain key figures

FGIM Report monitor

FGIO Transport report

FGIP Transport form

FGIQ Import reports from client 000

FGIR Import reports from client 000

FGITTranslation tool - drilldown reporting

FGIV Maintain global variables

FGIX Reorganize drilldown reports

FGIY Reorganize report data

FGIZ Reorganize forms

ImplementationGuideforR/3Configuration(IMG)

→ Financial Accounting

→AccountsReceivableandAccountsPayable

→ Information System

→Accounts receivable

291

第 310 页 / 共 319 页

Unit6: Appendices AC280

→DrilldownReports(Accountsreceivable)

→ Form

→ Define Form

Create Form FDI4

Change Form FDI5

Display Form FDI6

Transport Form FDIP

ImportFormfromClient000 FDIR

Delete Form FDIZ

→ Define Report

Create Report FDI1

ChangeReport FDI2

Display Report FDI3

Transport Report FDIO

ImportReportfromClient000 FDIQ

Delete Report FDIX

(...)

→MaintainGlobalVariables FDIV

(...)

→ReorganizationofReportData FDIY

Transaction codes: Short description

FDI0 Execute report

FDI1 Create report

FDI2 Change report

FDI3 Display report

FDI4 Create form

FDI5 Change form

FDI6 Display form

FDIB Background processing

FDIC Maintain currency translation type

FDIK Maintain key figures

FDIM Report monitor

292

第 311 页 / 共 319 页

AC280 Lesson: Appendix

FDIO Transport report

FDIP Transport form

FDIQ Import reports from client 000

FDIR Import forms from client 000

FDIT Translation tool - drilldown reporting

FDIV Maintain global variables

FDIX Reorganize drilldown reports

FDIY Reorganize report data

FDIZ Reorganize forms

ImplementationGuideforR/3Configuration(IMG)

→ Financial Accounting

→ Accounts payable

→ DrilldownReports(Accountspayable)

→ Form

→ Define Form

Create Form FKI4

Change Form FKI5

Display Form FKI6

Transport Form FKIP

ImportFormfromClient000 FKIR

Delete Form FKIZ

→ Define Report

Create Report FKI1

ChangeReport FKI2

DisplayReport FKI3

Transport Report FKIO

ImportReportfromClient000 FKIQ

Delete Report FKIX

(...)

→DefineGlobalVariables FKIV

(...)

→DeleteReport Data FKIY

293

第 312 页 / 共 319 页

Unit6: Appendices AC280

Trans. code – Short description

FKI0 Execute report

FKI1 Create report

FKI2 Change report

FKI3 Display report

FKI4 Create form

FKI5 Change form

FKI6 Display form

FKIB Background processing

FKIC Maintain currency translation type

FKIK Maintain key figures

FKIM Report monitor

FKIO Transport report

FKIP Transport form

FKIQ Import reports from client 000

FKIR Import forms from client 000

FKIT Translation tool - drilldown reporting

FKIV Maintain global variables

FKIX Reorganize drilldown reports

FKIY Reorganize report data

FKIZ Reorganize forms

294

第 313 页 / 共 319 页

AC280 Lesson: Appendix

Lesson Summary

You should now be able to:

• Describestandardcharacteristics, keyfigures, andstandardvariables,and

list transactionsused in drilldown reporting

• FindmenupathsintheImplementationGuide(IMG)

295

第 314 页 / 共 319 页

UnitSummary AC280

Unit Summary

You should now be able to:

• Describestandardcharacteristics,keyfigures, andstandardvariables, and

list transactions used in drilldown reporting

• FindmenupathsintheImplementationGuide(IMG)

296

第 315 页 / 共 319 页

第 316 页 / 共 319 页

第 317 页 / 共 319 页

AC280 Course Summary

Course Summary

You should now be able to:

• Explain why reports are necessary

• Explain the significance of reporting tools

• Differentiate between:

• Standard reports provided by SAP, and

• Reports that you create yourself

297

第 318 页 / 共 319 页

CourseSummary AC280

298

第 319 页 / 共 319 页

Feedback

SAP AG has made every effort in the preparation of this course to ensure the

accuracy and completeness of the materials. If you have any corrections or

suggestionsforimprovement,pleaserecordthemintheappropriateplaceinthe

course evaluation.

299