ASUG-Reporting-SAPpresentation-三星集團SAP實施文檔

DominicUliano

SAPAmericaReportingToolsinSAPR/3AgendaTypicalReportingChallengesSAPQueryReportPainterDrillDownReportingLISExampleReportingLandscapesTypicalReportingChallengesCompleteviewofthebusinessCollectandAnalyzeDataquicklyw/mimimalefforttoendusersFacilitateeffectivedecisionmakingDatamustbecurrent,accurate,relevant,reliableMinimizelearningcurveelementStandardReportDevelopmentToolsSAPQueryOriginallyCalledABAPQuerypriorto4.6DesignedtocreateandmaintainreportswithoutprogrammingCanreadallSAPdatabasetables,logicaldatabases3mainComponentsInfoSetsUserGroupsSAPQueryInfoSetQueryAvailableinbothR/3andBWFlexibleReportingToolNoABAPskillsrequiredDatasourcecanbeSAPtables,logicaldatabases,oraself-codedABAPprogramOutputavailableinExcelandotherexternalproductsAbilitytopublishtoWebAd-HocandreusablequeriesCrystalReportsavailableasoutputmediumforenhancedOLAPfunctionalityInfoSets-OverviewAnInfoSetisthedatasourceforInfoSetQueriesContainsnoactualdataInfoSetsmaycontainSAPtablesLogicaldatabasesSelf-codedABAPprogramsAdditionalfields,tablesandstructurescanbeaddedtotheInfoSetDisplayattributesoffieldscanbealteredintheInfoSetLoggingfunctioncanbeturnedontotrackuseCustomvs.StandardInfoSetsInfoSetDescriptionGreatInfoSetDocumentationInfoSet->DescriptionInfoSetMaintenance(SQ02)AvailablefieldsofamastertableoranarbitrarytableorviewDetailed

fieldinformationSelectedandgroupedfieldsforQueriesTextsforfieldvaluesareautomaticallyavailable

(ifexisting)Additionalfields,

defaultselectioncriteria,enhancedfunctions,etc.InfoSetJoinConditionsNote:Tablescanonlybejoinedonce–ifatableneedstobejoinedmultipletimes,analiasshouldbeused.AdditionalFeaturesofInfoSetsAdditionalcalculated

fieldsSingleFieldsStructuresTablesAdditionalchecks

onselectioncriteriaAdditionalselectionsAssignInfoSettoaRole(SQ02)GroupedfieldsoftheInfoSet

(valuesandtheirtexts)Chosen

selectioncriteriaPreviewwithtestdataorselecteddataChosencolumns,

filtered,sorted,grouped,withtotals

andsubtotalsDetailed

fieldinformationSelectaccordingtovalueand/ortextDrag

and

DropInfoSetQueryCreation(SQ01)OutputFormatsoftheInfoSetQuerySAP

ListViewer

PreviewMicrosoftWordBusinessGraphicsSAPListViewer

GridFullscreenMicrosoftExcelWebreportingforInfoSetQuery(SQ01)OnlyaURLisneeded.SeveraloptionalparameterscanchangethelookandthefunctionalityoftheQuery.InfoSetQuery–Misc.TopicsMaximumnumberoffieldsis256VariantsshouldbeusedwheneverpossibleinInfoSetqueriesQueryusesSTANDARDvariantbydefault–use‘Change’toalterInordertosumcolumnsintegersmustbeusedStandardR/3AuthorizationsarecheckedInfoSetQueriescanbeusedoutofBWorR/3asanextractor

HowtoRunanInfoSetQueryViaInfoSetQueryDesignerViaWorkplaceorBExBrowserInfoSetQueryPerformanceLargeamountofrelationaldataMinimizedatainInfoSetUseselectioncriteriainInfoSetNarrowdatainInfoSetQueryUsevariantswheneverpossibleEvaluatejoinsExamineadditionalfieldABAPcodeAddindex(s)ReportPainter/ReportWriter-OverviewReportPainterAllowsreportingfrommultipleapplicationsReportdefinitionviaGraphicalInterfaceWYSIWYGApproachReportWriterUnderlyingtechnologythatisusedbytheReportPainterPrimarilyusedtosupportreportingforFIandCOReportPainter/ReportWriter5MainComponentsUseofa“Set”orlogicalgroupingofcharacteristicvaluesUseofa“Library”whichcontrolwhichcharacteristicsandkeyvaluesfromthetableareavailableReports–thedefinitionofrows,columns,anddataselectionReportGroups–Acontainerof1ormorereports.ThisiswhatgetsexecutedVariables–placeholdersforthecharacteristicvaluesReportPainter/ReportWriterReportPainter/ReportWriterMainStepsforcreatingareportReportPainter/ReportWriterIdentifythelibrary,reportnameanddescriptionCreatingareportviathePainterReportPainter/ReportWriterDisplayofthestructureandexpectedoutputoftheselectedreportReportPainter/ReportWriterPrerequisitesTableanddatainformationmustbeknownAsetmustbecreatedbeforethereportcanbebuiltAlibrarycontainingtheevaluationstructureneedstobebuiltinadvanceReportPainter/ReportWriterPerformanceConsiderationsEveryreportgeneratesABAPandSQLcodetoextractthedataoutofthetables.ThereisnowaytotunethiscodeitisgenerateddynamicallyBroadDataSets–DateRangesandlowselectivityJoinsVerylargedatasetsMultipleuseofsamereportDrillDownReportingWhatisDrillDownReporting?Drilldownreportingprovidesyouwitheasy-to-usefunctionsfornavigatingthroughyourdata.Usingdrilldownfunctions,youcan:JumptothenextlevelofdetailortothenextreportobjectatthesamelevelHideindividuallevelsofdetailSwitchbetweenthedetailanddrilldownlistsProcesslistsinteractively(sorting,conditions,rankinglists,andmore)DeploySAPGraphics,SAPmail,andtheMicrosoftExcelListViewerDrillDownReportingWithdrilldownreportingyoucan:AnalyzethedatabasedonanyofthecharacteristicsorobjectsthatdescribetheaccessibledataChooseanykeyfiguresorperformancemeasurestocategorizeyourdataDisplayanumberofobjectsforagivenkeyfigure,oranumberofkeyfiguresforagivenobjectCarryoutanynumberofdeviationanalyses(suchasplan/actualcomparisons,fiscalyearcomparisons,comparisonsofdifferentobjects,andmore)Producebothsimpledata-directedlists(basicreports)andcomplexformattedlists(formreports)Carryoutanumberofadditionalfunctionsthatletyouprocesslistsinteractively(sorting,conditions,rankinglists,andsoon);SAPGraphics,SAPmail,andtheMicrosoftExcelListViewerarealsointegratedintodrilldownreportingPrintreportsforwhichanumberofformattingfunctionsareavailabletodeterminethelookofyourprintedreports(pagebreaks,headersandfooters,underscores,andsoon)DrillDownReportingDrillDownreportingisprimarilyusedwithselectedstructuresinthefollowingareasControllingandprofitabilityanalysis(CO-PA)ExecutiveInformationSystem(EIS)Generalledger(financialversions)ProjectSystemsConsolidationsAccountsPayableAccountsReceivableSpecialledgerRealEstateFundsManagementDrillDownReportingTwotypesofReportsBasicReport–ProvidesaquicksearchforbasicdatathatisalreadyknowninadvanceFormReport–UsedforPrintingreports,officialcompanyreports,whereakeyfigureisusedinthedefinitionDrillDownReportingDrillDownReportingTocreateadrilldownreport,youmust:1.Enteranameforthereport.2.Decidewhetheryouwanttocreateabasicreportoraformreport.Foraformreport,enterthenameofthedesiredform.3.Tocopyanexistingreport,enterthenameofthereportyouwanttocopy.4.Fromtheinitialscreen,youcanaccessthedifferentcomponentsofthereport.5.Afteryouspecifythedesiredcharacteristics,characteristicvalues,andkeyfiguresforthereport,savethereport.6.Executethereport.DrillDownReportingCreatingareportLogisticsInformationSystem(LIS)EssentiallyaDataWarehouseforLogisticsReportinginR/3InformationisstoredatanaggregatedfashionratherthanatthelineitemordetaillevelPerformsallofthecollectionfunctionsinR/3fortheLISdataDefinitionofrulesforupdatingthestructuresPresentationofthedataStandardAnalysisFlexibleAnalysisLISLISisorganizedintoa3tiermodelOLAPAnalyticaltoolsforreportingDataWarehouseDatastorageOLTPTransactionDetailLISAnalysisTypesStandardAnalysisUtilizesexistingInformationStructures(tables)StandardreportsavailablethatpresentthedatacontainedintheInfoStructuresFlexibleAnalysisUseofInfoStructuresUseofReportPainterasagraphicalinterfacetocombineandaggregateinformationcontainedintheinfostructuresLandscapesforReportingBusinessInformationWarehouseAdditionoftheBWintoanexistingR/3landscapeProvidesOLAPanddatawarehousecapabilitiesExtractionfromR/3AnalyticalreportingdoneoutsideofR/3DetaillevelandadhocstillmustbedoneinsideofR/3ReportingInstanceofR/3Usebackupsormirrorsplitstorebuilda“reportinginstance”ofR/3dailyCompletelyfreesuptheproductionR/3frommostreportingAllowsforaddhocandlengthyreportingrequirementsatthedetaillevelMaynotbeeasilysupportingwithoutahighendstoragesuchasEMCConsiderationsforaDistributedLandscapeandEAITherewillbenosingleauthoritativedatastoreHighefforttopushorextractdatathatisthemostcurrentDataSynchronization=highloaduponOLTP,OLAP,andEAIsubsystemsQ&AQuestions?ContactDominicUliano,SAPAmerica,Inc.Dominic.Uliano@NopartofthispublicationmaybereproducedortransmittedinanyformorforanypurposewithouttheexpresspermissionofSAPAG.Theinformationcontainedhereinmaybechangedwithoutpriornotice.SomesoftwareproductsmarketedbySAPAGanditsdistributorscontainproprietarysoftwarecomponentsofothersoftwarevendors.Microsoft?,WINDOWS?,NT?,EXCEL?,Word?,PowerPoint?andSQLServer?areregisteredtrademarksofMicrosoftCorporation.IBM?,DB2?,DB2UniversalDatabase,OS/2?,ParallelSysplex?,MVS/ESA,AIX?,S/390?,AS/400?,OS/390?,OS/400?,iSeries,pSeries,xSeries,zSeries,z/OS,AFP,IntelligentMiner,WebSphere?,Netfinity?,Tivoli?,InformixandInformix?DynamicServerTMaretrademarksofIBMCorporationinUSAand/orothercountries.ORACLE?isaregisteredtrademarkofORACLECorporation.UNIX?,X/Open?,OSF/1?,andMotif?areregisteredtrademarksoftheOpenGroup.Citrix?,theCitrixlogo,ICA?,ProgramNeighborhood?,MetaFrame?,WinFrame?,VideoFrame?,MultiWin?andotherCitrixproductnamesreferencedhereinaretrademarksofCitrixSystems,Inc.HTML,DHTML,XML,XHTMLaretrademarksorregisteredtrademarksofW3C?,WorldWideWebConsortium,MassachusettsInstituteofTechnology.JAVA?

isaregisteredtrademarkofSunMicrosystems,Inc.JAVASCRIPT?isaregisteredtrademarkofSunMicrosystems,Inc.,usedunderlicensefortechnologyinventedandimplementedbyNetscape.MarketSetandEnterpriseBuyerarejointlyownedtrademarksofSAPAGandCommerceOne.SAP,R/3,mySAP,mySAP.com,xApps,xApp,SAPNetWeaverandotherSAPproductsandservicesmentionedhereinaswellastheirrespectivelogosaretrademarksorregisteredtrademarksofSAPAGinGermanyandinseveralothercountriesallovertheworld.Allotherproductandservicenamesmentionedarethetrademarksoftheirrespectivecompanies.Datacontainedinthisdocumentservesinformationpurposesonly.Nationalproductspecificationsmayvary.Copyright2003SAPAG.AllRightsReservedWeitergabeundVervielf?ltigungdieserPublikationodervonTeilendaraussind,zuwelchemZweckundinwelcherFormauchimmer,ohnedieaus-drücklicheschriftlicheGenehmigungdurchSAPAGnichtgestattet.IndieserPublikationenthalteneInformationenk?nnenohnevorherigeAnkün-digungge?ndertwerden.DievonSAPAGoderderenVertriebsfirmenangebotenenSoftwareproduktek?nnenSoftwarekomponentenauchandererSoftwareherstellerenthalten.Microsoft?,WINDOWS?,NT?,EXCEL?,Word?,PowerPoint?undSQLServer?sindeingetrageneMarkenderMicrosoftCorporation.IBM?,DB2?,DB2UniversalDatabase,OS/2?,ParallelSysplex?,MVS/ESA,AIX?,S/390?,AS/400?,OS/390?,OS/400?,iSeries,pSeries,xSeries,zSeries,z/OS,AFP,IntelligentMiner,WebSphere?,Netfinity?,Tivoli?,InformixundInformix?DynamicServerTMsindMarkenderIBMCorporationindenUSAund/oderanderenL?ndern.ORACLE?isteineeingetrageneMarkederORACLECorporation.UNIX?,X/Open?,OSF/1?und