第 347 页 / 共 355 页
AC610 Appendix2: DataStructuresforReportPainterandReportWriterReports
Figure 109: Access Structure of the Report Writer
Characteristics and key figures from line item tables GLPCAand GLPCP are
alsoavailablewhenalibraryiscreatedforreportingtableGLPCT,andnotjust
fields from totals record table GLPCT.
UseonlycharacteristicsandkeyfiguresfromtotalsrecordtableGLPCTinreports.
Otherwiselineitemsareselectedwhichcanleadtoperformanceproblems.
Whichtableisactuallyreaddependsonthekeyfigureusedinthereport.
Library8A2 containsthe characteristicsand keyfiguresfromthetotalsrecord
tableand should becopied for in-housereports.
Library 8A3 contains characteristics and key figures from the line item tables
andshouldonlybeusedinspecialcasesandwithgoodreasonasotherwisethis
cancauseseriousperformanceproblems. Forexample, periodicallytransferred
valuesaredisplayedusingstandardreportswhichaccessthecharacteristicsand
keyfiguresfrom thelineitemtablevialibrary8A3.
Reporting table GLPCOP contains characteristics and key figures which are
requiredforreportingopenitemsandwhicharestoredinspecialdatabasetables.
Library8A4containsthesecharacteristicsandkeyfigures.
337
2005/Q2 © 2005 SAP AG. All rights reserved.
第 348 页 / 共 355 页
Appendix2: DataStructuresforReportPainterandReportWriterReports AC610
Figure 110: Report/Report Interface
Thereport/reportinterfaceletsyouexecuteotherReport Painterreport groups,
ABAPreports,drilldownreportsandtransactionsfromadisplayedreportlist.
Onceyouhaveselectedanindividualcell,row,column,orblock,youcanbranch
directlytoanother ProfitCenterAccountingstandardreport, bychoosingGoto
→Callupreport. Thevaluesintheselectedareaofthereportserveasselection
criteria for the report you call up.
ProfitCenterAccountingReportingallowsyoutoaccessoriginalreportsofCost
CenterAccountingwhensearchingforthecauseofcertainprofitdimensions. An
example of this is shown on the slide.
Notethat,whenbranchingfromtheprofitcenterreports,theselectedvalueswill
only be passed on automatically as selection criteria if you call up a different
profitcenterreportoracostcenterreport. Otherwise,youbranchtotheselection
screen of the report you called up instead.
338
©2005SAPAG.Allrightsreserved. 2005/Q2
第 349 页 / 共 355 页
AC610 Appendix2: DataStructuresforReportPainterandReportWriterReports
Figure 111: Information System: Data Source
When you save reports in extracts, you can access the stored data quickly.
Extracts of reports for groups (for example, profit center groups) also support
navigationwithinthegroup. Ifyoucreateanextractforagroup,youcanuseitto
callupareportforeachindividualprofitcenterinthegroup.
You can choose to access existing extractsfor aReport Painter report, which
allows you to display a report (for a closed period, for example) with a
significantly shorter runtime.
• Youcanalsochoosetoselectdatafromthedatabase,whichallowsyouto
createabasicreportusingthelatestinformation.
Whenyouuseanextracttodisplaythelineitemsofareportrow,theSAPsystem
automaticallyaccessesthelatestrecordsfromthedatabase.
To create extracts, you can answer the dialog window query with “Yes” when
leaving thecompleted report. The selection parameters and the timeof report
creationautomatically characterizethe extract.
Inextractmanagement,youdeterminewhetherandhowthereportcall-upsaccess
existing extracts.
Hint: Anotheralternativeistoreaddatafromthearchive,usingreports
to display archived information.
339
2005/Q2 © 2005 SAP AG. All rights reserved.
第 350 页 / 共 355 页
Appendix2: DataStructuresforReportPainterandReportWriterReports AC610
340
©2005SAPAG.Allrightsreserved. 2005/Q2
第 351 页 / 共 355 页
Appendix 3
Line Item Reporting
Figure 112: Line Item Report: Selection
Theactuallineitemreportletsyouselectindividualpostingsaccordingtovarious
selection criteria (profit center, revenue/cost element, posting date). It is only
availableifyoursystemstoresactuallineitemsfortherelevantcontrollingarea
andfiscalyear. ThelineitemsarestoredintableGLPCA.
The actual line item report also functions as a list of actual costs because it
displayspostingdocuments. All theselected lineitemsareshowninlistform.
Youcandecidehowmuchdetailyourequireinthereportsinceyoucananalyze
the line itemswith varying degrees of detail.
341
2005/Q2 © 2005 SAP AG. All rights reserved.
第 352 页 / 共 355 页
Appendix3: LineItemReporting AC610
Relevantreportinformation,suchasselectedfieldsandtheirorder,isstoredinthe
displayvariant. SeveralstandarddisplayvariantsaredefinedintheSAPsystem.
Furtherdisplayvariantscanbedefinedinteractivelyatapplicationlevel.
Plan Line Items: You can display plan line items in Profit Center Accounting
if your system storesplan line itemsfor thedesired controlling areaand fiscal
year(definedinCustomizing). Ifthisisthecase, theplanlineitemsarestored
in table GLPCP.
Figure113: LineItem Report: MaintenanceofDisplayVariants
The SAP systemoffers several standard display variants. The displayvariants
function lets you change the column structure of the list. The field selection
includes a number of additional fields from the profit center line items (e.g.
informationaboutthecostcenter,orders),additionalcurrencies,andsoon. You
can also choose groupsof fieldsfromthefield selectionbychangingtheField
group. Fromthesetofallavailablefields(includingcustomer-specificfields)you
canchooseasmanyasyouwantforacompany-specificdisplayvariant.
Dependingonthewidthofthecolumn,theSAPsystemautomaticallydisplaysthe
shorttextorlongtextversionofthefieldname,usingyourlogonlanguage(ifthis
language is available for the report).
342
©2005SAPAG.Allrightsreserved. 2005/Q2
第 353 页 / 共 355 页
AC610 Appendix 3: Line Item Reporting
Onceyouhaveexecutedalineitemreport,youhavethefollowingdisplayoptions:
• Horizontal scrolling by column
• Hide/show columns
• Change order of columns
• Sort list according to certain criteria
• Totals for value columns
• Subtotals for each object in a column
• Original Document Display
• Filter Function
343
2005/Q2 © 2005 SAP AG. All rights reserved.
第 354 页 / 共 355 页
Appendix3: LineItemReporting AC610
344
©2005SAPAG.Allrightsreserved. 2005/Q2
第 355 页 / 共 355 页
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.
345
2005/Q2 © 2005 SAP AG. All rights reserved.