Home

Crystal Enterprise™ Solution Kit for mySAP.com User's Guide

1. waming Applet Window 3 In the User Name and Password fields provide your usual Seagate Info credentials 4 Ifthe APS field is blank or if you want to connect to a different Info APS type the name of the appropriate machine 5 Click Connect 6 When the Info Desktop for Java appears locate the Info Query Cube whose data you want to analyze 7 Select the cube and on the View menu click View output Note If a Security Warning asks you whether or not to install and run the Java Worksheet click Yes The Info Worksheet Java applet loads and retrieves the Info Query Cube s structure and data Depending on the size of the cube and the current network load this may take a few minutes Now use the Info Worksheet s powerful features to arrange and analyze the cube s multidimensional data For full details on the Info Worksheet for Java consult your Seagate Info documentation Direct access to BW s Info Query Cubes If you do not have access to a Seagate Info reporting environment or if your administrator has not set up the Open OLAP components you can connect directly to BW s Info Query Cubes using your Report Designer However the BW OLAP Kit must be installed on your local machine For complete details see the Solution Kit for mySAP com Installation Guide 50 Crystal Enterprise Solution Kit for mySAP com User s Guide 4 Reporting off BW s Multidimensional Data Reporting directly off Info Query C
2. To add a report template to the SAP system 1 With your original query still displayed in the SAP List Viewer screen click the Settings menu point to Layout and click Change Crystal Enterprise Solution Kit for mySAP com User s Guide 63 Generating Crystal report templates for SAP queries The Change Layout dialog box appears Age of employee Cty SAAE M caco E ararau 8 O Grid Template _ L Amoname Createdon createdon 0 Excel ER 4 gt EA D Template selected 64 Crystal Enterprise Solution Kit for mySAP com User s Guide 5 Viewing SAP Queries as Crystal Reports Click Create template from file In the Open dialog box browse to the local directory where you saved the Crystal report template Select the Crystal report template and click Open The template is uploaded to SAP s Business Document Service BDS and added to the list of available Crystal reports On the View tab in the Template column select your new template This adds the name of the template to the Template selected field Click Save layout The Save layout dialog box appears Save as Descript Save layout SALES C User specific Default setting On the Save as tab in the Save layout field type and a name for the new layout In the Name field type a descriptive name for the template The SAP
3. Cross division Pumps 2 245 00 f 1 655 500 3 182 2 Motorcycles Paints 679 900 00 457 800 C 0 00 High Tech 0 00 1 713 925 631 643 0 170 583 87 170 600 C Vehicles All Division 2 245 00 0 00 4 219 909 4 442 32 _ Hal Sold to party aj zjSales Volume Now use the Info Worksheet s powerful features to arrange analyze and format the cube s multidimensional data For full details on the Info Worksheet consult your Seagate Info documentation To save the current Worksheet view 1 2 3 On the File menu click Save View As In the Save View As dialog box type a name for the Worksheet view Click OK You can now open this view of the data the next time you connect to the Info Query Cube with the Info Worksheet Crystal Enterprise Solution Kit for mySAP com User s Guide 4 Reporting off BW s Multidimensional Data To open a saved Worksheet view 1 On the File menu click Open 2 Inthe Select View dialog box select from the list of saved Worksheet views 3 Click OK The Info Worksheet arranges the cube data in accordance with the view that you selected Generating Crystal reports from Info Query Cubes Once you ve used the Info Worksheet for Windows to create an informative view of the cube s multidimensional data you can quickly generate a Crystal report that displays this information Note To obtain this functionality you must be running the Inf
4. 2 Select Program from the list and type the name of the program that holds the key information related to the cluster area For this example type RPCLSTB2 which is the program that holds the key information for the B2 cluster area and its SALDO table 3 Inthe Object name list expand the Fields folder 4 Double click the entry that corresponds to the table that you want to access For this example double click the SALDO entry The relevant ABAP code is displayed pics alB eee BHAR SAHss iA ABAP Editor Dispiay include RPC2B202 ae oe a S E O Pattern eH cP insert cP Replace Ef Delete RPC2B202 Program amp AA E2 RPCLSTB2 MK XIA ais ma NE XHRALRKO05639 090597 Neue Tabellen f r Urlaubskumulation 4 rfl 3 0 XHRS11K146777 010895 Aufnahme der Tabellen VS und CYS 12 Wes Gn ea yoikikiassss 011294 aufnahme der Tabelle URLAN Objectname aries Searle aati YLLK64048 140292 Aufteilung wegen Common Bereichen RET_CODE INCLUDE RPTDPDOGO RP IMP B2 SUBRC RPCLYXX CLSTB2_ PER DATA BEGIN OF SALDO OCCURS 50 RUFB z INCLUDE STRUCTURE PC2B5 DATA END OF SALDO SAVE SGART ARAL APATA ARTS RAL ARANARCAAA SELCLTYP lil m SELEKTION 2 INS Li15 Co1 Li15 Co 33 Ln4 Ln18 of 75 lines SELPABRJ x n Bhe D RD1 1 800 PE VANSAPO1 INS 5 Inthe ABAP code look for the he
5. 7 Create a new session in R 3 and execute transaction SE11 to access the ABAP 4 Dictionary Crystal Enterprise Solution Kit for mySAP com User s Guide 33 Reporting off ABAP data clusters The Dictionary Initial Screen appears 8 Select Database table and type the name of the structure that contains the key fields For this example type PC2B0 9 Click Display The Display Structure screen appears 34 Crystal Enterprise Solution Kit for mySAP com User s Guide 3 Advanced Open SQL Reporting 10 Make a note of the names of the key fields displayed in the Component column In this case the four key fields are PERNR PABRJ PABRP CLTYP You now need to add the key fields to your new dictionary entry in the Cluster Definition tool Here you will add the four key fields to the dictionary entry that you created for the B2 cluster area To add the key fields to the dictionary entry 1 Execute transaction ZCDD to return to the Cluster Definition tool 2 Inthe View Cluster Id Table screen select the new entry that you created For this example select the PCL2 B2 entry 3 Click Edit The View Cluster Record screen appears 4 Click New Cluster Key Crystal Enterprise Solution Kit for mySAP com User s Guide 35 Reporting off ABAP data clusters 9 The Edit Cluster Key Record screen appears SAP Edit Cluster Key Record Cluster Database PCL2 Cluster Area Key Number Key Name Referenc
6. Reporting off ABAP data clusters sscsscccssssecsssscssseessseesseeees 27 Whatis adata Cluster eariioinenioii ninn a EE A E AR 27 FOW TWOP ICS aja dessa sasetea ue cea es anA E EE E E EEE EEEE S EEEE ET 27 Mapping ABAP data clusters essessseseesrieersssereserssrrrsrrrrerreseestsesssretsrresereeseresres 28 Simplifying the Open SQL driver cssccsscccesssessssessssessssseeeees 39 Using Info Views and Crystal Dictionaries ssessesseeeseeeieereseriesrissrersereserresrreseen 39 Clusters and SO CEN oopis eii ai N eiet 40 Chapter 4 Reporting off BW s Multidimensional Data Overview of the BW OLAP Kit sssesssssesssosessseessssocessecsesseesssoessssee 42 Releasing cubes for OLE DB for OLAP ssscccsssessssessseesseeeees 42 Open OLAP reporting with Seagate Info ssscssccssseesseesseeees 43 Adding BW s Info Query Cubes to the Info Desktop ssssssssesesrrssrrreerrserresereseee 44 Analyzing cubes from the Info Desktop for Windows s sssssssessssesreerssresrreereereereeee 48 Generating Crystal reports from Info Query Cubes sssssseseseseerrseresersssriserererrese 49 Analyzing cubes with the Info Desktop for Java esssssescsesrsrrresrrrsrrrerrirerreseresees 49 Direct access to BW s Info Query Cubes ssessssssssssseessocsssscessseessss 50 Reporting directly off Info Query Cubes essesssrsssriserrseersserssrrssrersereserrssresssen 51 Chapter 5 Viewing SAP Queries as Crystal Reports O
7. Tom M VP Mail 7 12 98 5 6 97 15300 Reporting off ABAP data clusters Reporting off ABAP data clusters is an advanced topic that requires an understanding of the ABAP programming language What is a data cluster Unlike most of the SAP system the Human Resources module stores much of its data in ABAP data clusters rather than in data dictionary tables such as transparent pool or cluster tables Data clusters are actually stored in some transparent tables Any such transparent table can contain many different types of clusters Each cluster of data is stored in one or more rows in the transparent table A cluster can contain any number of individual components or pieces of data which may range from single values to structures to tables You can access a data cluster in an ABAP program by running the ABAP command IMPORT This command takes parameters such as cluster database name cluster ID and so on as well as a list of pieces of data to import The IMPORT command also copies the contents of the data cluster into local variables within the calling code A typical transparent table that contains cluster data has a structure similar to the following client area key line counter user data data length data cluster The combination of transparent table name and area identifies which type of cluster to import while the key identifies the specific cluster For HR the cluster key is typ
8. 19 return types using wrapper functions 0 23 RSAQ_REMOTE_FUNCAREA_CATALOG function mod le a e cages vvesetseas Cassa sestees 64 S sample reports editing selection formulas s sssssssiesseeseere 18 refreshing against SAP sssssssssssssresrsesesere 17 SENE UP ccayssssesegnecsssesesvesvsaces sede ENEEK 17 SAP Business Explorer Analyzer 00 cceeeee 42 SAP queries generating report templates for 56 VIEWING aS FEPOFts cee 60 SAP R 3 Logon dialog bOX ceeeeeeeeee eee 8 SAP spool printing reports eeeeeeeees 61 SAP system adding report templates 0 cece connecting with the drivers errors when connecting logging on with the drivers SAPGUI Integration Kit OVEIVICW ccecesssnscerseseusessatevsensbicsacteensbenstercevens 56 CSI ioe E E Soeieets vce stovlceousnapcteceaecen teats 55 saving Info Worksheet views eecseeeeeeeees 48 scheduling OLAP repos c c sesscsetsesecsesieeebetbesetorss 47 54 TEPOMtS seseessnsescsssererisiesiosaicsosstrestareneiiiasi cee vactocs 6 Seagate Info adding BW s Info Query Cubes 0 005 44 Info WebACCESS seeeseeeceeeeeeeeteeteeseeeeaeeaees Open OLAP reporting ve scheduling reports cccccsceeseseesesceecseseeeeees Security Definition Editor cesses ees selecting ABAP FUNGON Seernes 23 ABAP queries 14 16 an SAP system 8 drivers for reports 6 iiO ES S E E so
9. Pointing existing reports to your production system on page 18 a Configuration options on page 19 For up to date information on known issues and additional Tips and Tricks search our online Knowledge Base for relevant articles http support crystaldecisions com library kbase asp Note The procedures in this chapter are based on Crystal Reports 8 which parallels the Info Report Designer component of Seagate Info 7 5 If you are using an earlier version of the Report Designer the dialog boxes may differ The general concepts however remain the same Connecting to SAP with the Report Designer Once you ve installed the Data Access Kit you must select the driver for your report There are two ways to select a driver in the Report Designer use one of the Report Experts or select Log On Server from the File or Database menu Both methods are described below 6 Crystal Enterprise Solution Kit for mySAP com User s Guide 2 Reporting off SAP Data Using the Report Experts 1 On the File menu click New The Crystal Report Gallery appears Crystal Report Gallery e 8 Drill Down s OLaP 2 If it s not already selected click Using the Report Expert 3 Inthe Choose an Expert list click Standard then click OK Tip To create a specific type of report select the appropriate Expert 4 On the Report Expert s Data tab click Database The Data Explorer appears E Data Explorer MS IIS
10. chapter covers both the Open OLAP method of reporting in a Seagate Info environment and the direct access method that is available to Crystal Reports users Chapter 5 Viewing SAP Queries as Crystal Reports provides procedures related to the SAPGUI Integration Kit This functionality enables report designers to create Crystal report templates for SAP queries All users can then view SAP queries as Crystal reports from within the SAPGUI for Windows or for HTML For additional information about the Solution Kit for mySAP com consult the printed Installation Guide which is also included as a PDF in the Docs directory of your product CD The Installation Guide provides administrators with the information they need to deploy each of the Solution Kit for mySAP com components For up to date information on known issues and additional Tips and Tricks search our online Knowledge Base for relevant articles http support crystaldecisions com library kbase asp Crystal Enterprise Solution Kit for mySAP com User s Guide 1 Welcome to Crystal Enterprise Solution Kit for mySAP com Product registration Because Crystal Enterprise Solution Kit for mySAP com is designed to work with your core Crystal Decisions product Crystal Enterprise Crystal Reports or Seagate Info you are not required to register the Solution Kit for mySAP com as a separate product You should however register your core product in one of the following ways m F
11. combine the table name with the name of the cluster area as has been done here in case there is another SALDO table in a different cluster area In the Piece Class field type the abbreviation appropriate to the data piece T able S tructure or B asic type For this example type T Use the Reference Table field to define the structure of the new data piece by referencing an existing structure of the same type in another table For this example type PC2B5 Crystal Enterprise Solution Kit for mySAP com User s Guide 39 Reporting off ABAP data clusters 40 Note In this example you need not complete the remaining fields Reference Field ABAP Type and Length Use these fields to add specific information if the structure of the table is not defined in the data dictionary Click Save then click Back to return to the View Cluster Record screen Now that you have entered all of the definitions you have finished creating your new dictionary entry in the Cluster Definition tool The View Cluster Record screen looks like this SAP i as ANE OVE SHAR BHH018 SS View Cluster Record Reference Field Data Type Data Length J 8 0 0 0 Edit Cluster Data New Cluster Data Delete Cluster Data OAR OOD EAL VANDEL INS A When you create a new report with the Open SQL driver you
12. combined Info Set ABAP Query driver and provide your user credentials For details see Connecting to SAP with the Report Designer on page 6 The Allow Reporting On dialog box appears r Report Options Data Source Work Space I SAP Info Set Global area V SAP ABAP Query Local area The local area is client specific Name Filters User Group name like _ Info Set name like _ Query name like Jaz _ Optionally use the Info Set name filter to further restrict the list of available queries Note Leave empty to select all Use _ in name filter e g DAV matches DAVE DAVID DAV_ matches DAVE only Cancel Note If you log on to the SAP system but the Allow Reporting On dialog box does not appear check your Report Designer s configuration options For details see Configuration options on page 19 2 In the Data Source area select either SAP ABAP Query or SAP Info Set 3 Inthe Work Space area specify whether you want to search in the Global area the Local area or both 4 Inthe Name Filters area use the appropriate text field to specify the data sources that you want to make available to the report Crystal Enterprise Solution Kit for mySAP com User s Guide 2 Reporting off SAP Data Use the following techniques when selecting queries or Info Sets m Type full or partial names of queries or Info Sets m Separate distinct names with commas m A
13. easier for users to understand the content and purpose of the data m Create complex data manipulation formulas that users can access without needing to understand formula concepts m Reduce support cost and time increase user productivity and reduce data misuse loss and damage If you are an administrator who is distributing the Open SQL driver to multiple users you can use Info Views or Crystal Dictionaries to enhance and streamline users reporting experience m When you design Info Views and Crystal Dictionaries in accordance with specific reporting tasks your users can quickly and easily access the SAP data they need by building reports off the appropriate view m When you utilize the Column Security and Row Security features of Info Views and Crystal Dictionaries you gain the ability to create a single view that can be distributed to users with varying data access permissions Alternatively if you are a report design expert you can create a selection of task oriented Info Views or Crystal Dictionaries in order to enhance your ability to design new reports quickly For instance you could customize a view of your organization s sales data a view of the HR data and a view of the expense data Then when you need to design a new HR report or a new sales report you select the predefined view as the data source for your report For more information on creating Info Views consult the Online Help supplied with the Info View D
14. from the SAP system The appearance of this dialog box changes depending upon which driver you are using For details see Selecting tables views functions and clusters on page 11 or Reporting off ABAP queries and Info Sets on page 13 Note If you can log on to your SAP system but the Allow Reporting On dialog box does not appear check your Report Designer s configuration options For details see Configuration options on page 19 Reporting off tables views clusters and functions By writing reports with the Open SQL driver you gain easy access to SAP s transparent tables pool tables cluster tables and views If you are currently involved with the production of ABAP reports you will find it easy to build reports quickly with this driver The Open SQL driver is the most powerful of the three drivers due to the flexibility it provides for accessing data in SAP This flexibility however can result in a higher level of complexity than with the ABAP Query driver or the Info Set driver The driver s advanced functionality allows you to report against ABAP functions and ABAP data clusters ABAP developers can therefore perform advanced tasks such as reporting against data clusters in HR Developers can also utilize ABAP to augment report processing When you are familiar with the general procedures for selecting functions and clusters for your report see Advanced Open SQL Reporting on page 23 for more detai
15. increment the sequence number by one every time you define a new key field for this cluster area Crystal Enterprise Solution Kit for mySAP com User s Guide 3 Advanced Open SQL Reporting The values for each field in this example are Key Number Key Name Reference Table Reference Field 002 PABRJ PC2B0 PABRJ 003 PABRP PC2B0 PABRP 004 CLTYP PC2B0 CLTYP Once you have entered all of the definitions the View Cluster Record screen looks like this SAP Cl aX I Ge SHhRpan5an ES View Cluster Record Reference Table Edit Cluster Key New Cluster Key Delete Cluster Key Cluster Data Definition Piece Name Ref Table Ref Field Data Type Data Length Edit Cluster Data New Cluster Data Delete Cluster Data PO RDI 4 800 ET VANSAP OT TINS 7 Now you need to determine the structure of the table that you want to access In this example the table in question is SALDO There are several ways to determine the SALDO table s structure within SAP This example again uses the Object Navigator to locate the required information about the SALDO table Crystal Enterprise Solution Kit for mySAP com User s Guide 37 Reporting off ABAP data clusters To determine the structure of the cluster table 1 Execute transaction SE80 to return to the Object Navigator
16. mySAP com User s Guide 25 Reporting off ABAP functions This function would appear as a table called F with the following schema Field Type Name String Department String Years_of_service Integer Age Integer The first two fields Name and Department are input parameters You must either link to them from another table or function or specify them with a record selection formula for example F Name Richard For example if table T contains departments that are over budget you can link T Department to F Department and have a record selection formula specifying F Name Richard This formula will get the years of service and age of all people named Richard in departments over budget Functions with values as inputs and outputs and in out CHANGING parameters Function F IMPORTING VALUE NAME TYPE C VALUE DEPARTMENT TYPE C EXPORTING VALUE Years_of_service TYPE I VALUE Age TYPE I CHANGING DATEFIELD TYPE D This function would appear as a table called F with the following schema Field Type Name String Department String Years_of_service Integer Age Integer DateField_In Date DateField_Out Date When working with the Name Department and DateField_In fields you must either link them to another table or specify them in a record selection formula Crystal Enterprise Solution Kit for mySAP com User s Guide 3 A
17. the Info Query Cube is treated as an Open OLAP Cube users can neither schedule it for regular processing nor modify its design from the Info Desktop Users can however generate Crystal reports based on the cube object and then schedule those reports for regular processing against the Info Query Cube For details see Generating Crystal reports from Info Query Cubes on page 49 For more information on Open OLAP technology consult the Solution Kit for mySAP com Installation Guide and your Seagate Info documentation Crystal Enterprise Solution Kit for mySAP com User s Guide 47 Open OLAP reporting with Seagate Info Analyzing cubes from the Info Desktop for Windows 48 If you have installed the Info Desktop client software use it to connect to and analyze the Info Query Cubes that have been added to the Seagate Info system Note If you usually connect to your Seagate Info system over the Web see Analyzing cubes with the Info Desktop for Java on page 49 To analyze Info Query Cubes 1 2 3 Start the Info Desktop Locate the Info Query Cube that you want to analyze On the View menu click View The Info Worksheet opens and displays the initial view of the cube data E Info Worksheet Default View OSD_CO1 SALES_ANALYSIS Of x File Edit View Format Data Tools Window Help S ki 6 u AEEA lE R ER Year Mon FEB 1996 MAR 1996 APR 1996 JUL 1996 AUG 1996 JAN 1997 FEB 1997
18. want to report off then click OK Crystal Enterprise Solution Kit for mySAP com User s Guide 53 Direct access to BW s Info Query Cubes You are returned to the Data tab of the OLAP Report Expert OLAP Report Expert x Rows Columns Fiter Paqe Style Customize Style Labels Chart Choose the data to be your On Line Analytical Processing OLAP source Choose an OLAP Server type then select the Cube that contains the data Cube foo_coPa 0D_COPA_g001 z Type OLE DB for OLAP _ Database w208 Design Report Cancel lt Back Next gt gt Finish 13 Click the Cube list to view a list of available Info Query Cubes 14 When you ve selected the appropriate cube click Next You can now proceed through the remaining tabs of the OLAP Report Expert to specify the data you want to include and to add formatting to the OLAP report Press F1 to obtain help on any individual tab For more details on OLAP reporting see the Creating and Updating OLAP Reports chapter in your Report Designer s printed User s Guide or Online Help Note Within a Seagate Info or a Crystal Enterprise environment you cannot schedule reports that were created directly off BW Info Query Cubes the server components that process the scheduled reports Seagate Info Servers or Crystal Job Servers will be unable to connect to BW with the logon information that you specified for the report 54 Crystal Enterprise Solution Kit for my
19. 16 Report Designer configuration options 19 analyzing Info Query Cubes Info Desktop for JaVa ccecccceeeeeeees 49 Info Desktop for Windows cccee 48 sample repo sasn eiiiai iisi i 17 areas global and local 15 audience intended ree authorizations data security ccceeeeeeees 40 B Business Document Service BDS and templates 59 Business Explorer AnalyZer cccccceceseeeeeees 42 Business Information Warehouse BW adding OLAP cubes to Seagate Info 44 reporting off multidimensional data 41 BW OLAP Kit and Crystal Reports c ssavisisiesssseieseaserivisceiees 50 and Seagate Info 5 OE D EEE abies ebeasee C calculations and ABAP functions c0ceee 22 chapter overviews Glienttield sinecure Cluster Definition tool iniddolo Ure o PAON EEEE 28 utorial s N D EE cessendevssysassesaasaet sresvensateass cluster tables CES CHIDER sss sanman p naa 10 selecting for reports cccceeecsesseeeeeseeeees 11 clusters see ABAP data clusters configuration Options cccc cesses eseeeeeeseeees 19 connecting o the SAP system 6 roubleshooting 5 64 conventions used in document isd Converting queries tO reports ce eeeeseeeeeeeee tees 56 creating report templates saisine 56 TEPOITS ccc secceesescsssectesactes see accdcescadsedsactanessegersae 6 Crystal Dictionaries roubles hootin
20. Crystal Enterprise Solution Kit for mySAP com User s Guide Crystal Decisions Inc 895 Emerson St Palo Alto California USA 94301 Copyright 2001 Crystal Decisions Inc 895 Emerson St Palo Alto California USA 94301 All rights reserved Documentation Issue 1 No part of this documentation may be stored in a retrieval system transmitted or reproduced in any way except in accordance with the terms of the applicable software license agreement This documentation contains proprietary information of Crystal Decisions Inc and or its suppliers Trademark Acknowledgements 2001 Crystal Decisions Inc All rights reserved Crystal Decisions Solution Kit for mySAP com Crystal Crystal Reports Crystal Enterprise Seagate Info Seagate Software Seagate and the Seagate and Crystal logos are trademarks or registered trademarks of Crystal Decisions Inc and or Seagate Technology Inc All other trademarks referenced are the property of their respective owner Contents Chapter 1 Welcome to Crystal Enterprise Solution Kit for mySAP com Welcome saline eae 2 Who should use this guide cccssscssnscesessscasecnencesensccsassnensase 2 Product registrati scsessscasvessacessesssiasvnsascessasasstasvessscessaniiiasensesiaesiesin 3 TECNICA SUPPO sirier aaa 3 Document conventions csssisrseneran s 3 Chapter 2 Reporting off SAP Data Overview of the Data Access Kit drivers ssscccsseccsssescsss
21. ESKEOP 0siscvccesesasn edennasecsavcovssconsseotoeensss Info Views and Crystal Dictionaries st Info Worksheet for Java ccccccessseeseseseeneaees Info Worksheet for WindowWS 0 ce SAPGUI Integration Kit cece cee eteeeeee Vv viewing Info Query Cubes with Seagate Info 43 SAP queries as Crystal reports 0cce 55 views in SAP described serinipreninrsriinisiiise 10 linking eee ID reporting Off sssrinin iers 9 saving from Info Worksheet 0 ccceeeee 48 Crystal Enterprise Solution Kit for mySAP com User s Guide using Crystal Dictionaries ccceeeee 39 using INTO VIEWS ssc tice esessirecciesisted uii 39 WwW web sites Knowledge Base sec csssssocsscsissscpsnseassosesessevscsees 6 FEgISthAlOMics ss assessises ies iinan si seats 3 SUPPOTT sissssocssssssreriesiicsrsscsssisesritecesoerere dsoetssses s 3 wrapper functions defining return types 23 Z Z_IMG_FETCH_DATA2 function module ZCDD Cluster Definition tool ccceeeeeeeee zoom viewer control Crystal Enterprise Solution Kit for mySAP com User s Guide 71
22. LAP FEPOPtIN Gs wss sscsecssesssczon seve sass ecsesestotes 50 Display database field by configuration options 19 document CONVENtIONS ccceceeseee ees eeeteeeeeeees 3 drivers ABAP Query driver cceccecsesceeeseseeeeteteesees 13 BWFOLAP Kit ines ord denton Niere EEES 42 combined Info Set ABAP Query driver 13 CONNECTING tO SAP s rsissiersisiere Open SQL driver selecting for reports E errors when connecting to SAP ccceeeeeseeeeees 64 when reporting 64 examples ABAP functions 23 Excel Microsoft 00 42 experts report seen EXPOMAOMMALS civ sescervicrdssvres teovaadereebuvuwcecsaesteeetes 61 F fax numbers registration ss sssesssisesssreresisers erene 3 fields troubleshooting 64 formats exporting reports 61 Frontend integration 56 Functional Area driver see Info Set driver functions see ABAP functions G global argassecomsertonsaas sisi 15 68 H help Knowledge Base ccccccceeseeeeeseeeeseseeeeees product registration ss technical SuppOltic scsssisactssass as vasssseitesassaranees Human Resources modules and data clusters 27 Info Desktop adding Info Query Cubes eeeeseeeeees 44 analyzing Info Query Cubes 000 48 49 Info Query Cubes adding to the Info Desktop ceeeeeee ANALYZING essre ss analyzing over the Web direct ACCES
23. Proxy Log Files TINT Archived Event Log NT Current Event Log ESAP Table Cluster or Function Crystal Enterprise Solution Kit for mySAP com User s Guide 4 Connecting to SAP with the Report Designer 5 Expand More Data Sources and select the driver that you want to use m To use the Open SQL driver select SAP Table Cluster or Function m To use the combined Info Set ABAP Query driver select SAP Info Sets for versions 4 6b and later of SAP R 3 To use the standalone ABAP Query driver select SAP ABAP Query for versions 4 5b and earlier of SAP R 3 Once you ve selected a driver the SAP R 3 Logon dialog box appears For more details see Logging on to the SAP server on page 8 Using the Log On Server command 1 On the File menu or Database menu if a report is already open click Log On Off Server 2 Inthe Data Explorer expand More Data Sources and select the driver that you want to use m To use the Open SQL driver select SAP Table Cluster or Function m To use the combined Info Set ABAP Query driver select SAP Info Sets for versions 4 6b and later of SAP R 3 m To use the standalone ABAP Query driver select SAP ABAP Query for versions 4 5b and earlier of SAP R 3 Once you ve selected a driver the SAP R 3 Logon dialog box appears For more details see Logging on to the SAP server on page 8 Logging on to the SAP server Regardless of t
24. S sorrires releasing for OLE DB for OLAP w reporting Ollissts2 s4saheaaes cessssotertass aaie INFO Set AdrIVET scesuc ccoss ysesessersecnnesnidecaiovestacecsepsesss Allow Reporting On dialog box is OVEIVICW oaie seee E ae E Ee E Dt selecting data SOUICES s ssssssssssesere resserre Info Sets ANC ParAaMeters sirosis reiser 13 ANG SUDTEPOMS csccssdsscssvssvencsssesecseesscesratestsasees 13 PICTIXES Accres sea ane erar e A a Ea rE EEE SR a 15 selecting for reports sssrin 14 Info Views providing for USFS cccceceeeeeeeeeeeceeeeee 39 troubleshooting seus INFO WeDACGCOSS nasisira Info Worksheet TOM AVA sins ea a a aE for Windows oe generating OLAP reports ccceseceeeeseenees SAVING VIEWS ses sosisini ee i areae input parameters and ABAP functions Di integration SAPGUI Integration Kit J Java analyzing cubes from the Info Desktop 49 Info Worksheet sscsscssecssscssecsscsevconssvesveveasconens 50 K Knowledge Base web Site c ecseseeeeeeeseees 6 L language field csi c ississc yesteassiveisgars i 13 limitations and ABAP functionS cceeseeeees 23 linking Client Fel ississseesnce hazees decxciakseaseseecesiassaceasets 13 language field Ss tables and ViCWS ccccecccceeceesceeeeecseeeeeeeeees 12 Crystal Enterprise Solution Kit for mySAP com User s Guide List tables and fields by configuration options 19 local areal niisiis aeeti ei
25. SAP com User s Guide Viewing SAP Queries as Crystal Reports 5 This chapter shows how to convert SAP queries to Crystal reports from within the SAPGUL It also provides details on navigating exporting and printing report data Crystal Enterprise Solution Kit for mySAP com User s Guide 61 Overview of the SAPGUI Integration Kit Overview of the SAPGUI Integration Kit The SAPGUI Integration Kit enables you to convert SAP queries into Crystal reports from within the SAP system You view the new Crystal reports with the Crystal Reports Viewer When you need to save or distribute a report you can choose between multiple export formats including RTF and PDF This chapter includes the following topics m Generating Crystal report templates for SAP queries on page 62 m Viewing SAP queries as Crystal reports on page 66 m Using the Crystal Reports Viewer on page 66 Generating Crystal report templates for SAP queries Before any SAP user can view an SAP query as a Crystal report a corresponding Crystal report template must be added to the SAP system You can generate this initial template quickly if you have the Report Designer installed Once you have generated the initial report template and saved it to the SAP system other SAP users can view the query in Crystal report format By creating and providing a selection of customized report templates you allow users to enhance the formatting of the queries genera
26. a eE SE iE Log On Server command logging Onto SAP secsarsaessesssdevvseetexesesSeagedgecsenseseteents logical databases ssent lOBON ialOG DOK ss csccnsssescaseeseceosevsrssencosensecensersnoys M MANDY Tiel dives amp sictecsscsduoncavesvensorneuneiusieaeeseesutes 13 mapping ABAP data Clusters cecceseeeeeeee 28 Microsoft EXCel c cesses cseeseeeceeceeteeteeteeteese 42 multidimensional data ANALYZING v5 eraro stoves E S reporting off N navigating FEPOTTS ce cececeeeeceecteeeseeteetsetteesseteees 60 O ODBO releasing Info Query Cubes 0 000 42 OLAP cubes see Info Query Cubes OLAP Report Expert cccccsecsceeecessetectseeneeeseeees 51 OLAP reports creating with Crystal Reports eccee 50 generating from the Info Worksheet 49 OLE DB for OLAP releasing Info Query Cubes 42 online analytical processing s cccceseeeeeeseee 42 Open OLAP reporting cece cesseteceeeeteeeseeees 43 Open SQL driver advanced topics Overview cccceeeeeee Allow Reporting On dialog box a and ABAP functions c sees ceeeeeeeeeeee and Crystal Dictionaries 0 cceee eee and Info VIEWS and the Cluster Definition tool objects supported by OVEIVIEW sosse sesiis selecting data sources ise simplifying for USMS 0 0 eee ce eeeeeeeeeee options report designer configuration 19 overviews BV OEAP IN Gs casvanseesa
27. ading that denotes the beginning of the table and note the structure that is included in the following line For this example look under the heading DATA BEGIN OF SALDO OCCURS 50 for the line INCLUDE STRUCTURE PC2B5 highlighted in the image above This shows that the PC2B5 structure defines the fields of the SALDO table Now that you ve determined which structure defines the fields of the table you want to report off you must add this information to your new dictionary entry 38 Crystal Enterprise Solution Kit for mySAP com User s Guide 3 Advanced Open SQL Reporting To add the table to the dictionary entry 1 2 Execute transaction ZCDD to return to the Cluster Definition tool In the View Cluster Id Table screen select your new entry For this example select the PCL2 B2 entry Click Edit In the View Cluster Record screen click New Cluster Data The Edit Cluster Data Record screen appears SAP el EO Ee S Edit Cluster Data Record Cluster Database Cluster Area Piece Name Display Name Piece Class T B or Reference Table Reference Field ABAP Type Length a e ROEA SAEN A In the Piece Name field type the name of the table as it appears in the cluster area For this example type SALDO In the Display Name field type the name of the table as you want it to appear in the Report Designer For this example type B2SALDO Tip In general use a naming convention For instance
28. amiliar with report parameters select Use current parameter values and click OK 5 When the first SAP R 3 Logon dialog box prompts you for User Data click Cancel The multi tabbed SAP R 3 Logon dialog box appears 6 On the R 3 System tab select your R 3 system then click OK The SAP R 3 Logon dialog box once again prompts you for User Data Note If your SAP administrator has not configured SAP Logon your SAP system will not appear on the R 3 System tab In this case click the Server tab and provide the valid information for your production system Contact your SAP administrator if you are unsure of the entries that need to be made 7 Inthe Client field type the number appropriate to your R 3 system 8 Type your usual logon information in the User Name Password and Language fields 9 Click OK The report should now be refreshed with data from your SAP system However if no data appears in the report and you receive no database error messages then it is likely that the report is using tables and fields that are empty in your SAP system By editing the report s record selection formula you may be able to alter the report so that it coincides with your SAP data To locate the record selection formula click Report gt Edit Selection Formula gt Record Pointing existing reports to your production system 18 If you have already designed reports against your R 3 development system you can quickly modify those repor
29. and views on page 12 If you selected a single table you can now add fields to the report Linking tables and views Reports based on SAP tables transparent pool and cluster tables as well as views behave similarly to reports based on mainstream databases If you include more than one table or view in a report you must describe the relationship between the tables by using the Visual Linking Expert in the Report Designer Note Due to the standardized field naming conventions utilized by SAP you may find that Smart Linking in the Visual Linking Expert or on the Links tab of the Report Expert generates unnecessary links between tables To disable Smart Linking click Options on the File menu On the Database menu clear the Auto SmartLinking option and click OK The following client field and language field features are specific to SAP tables 12 Crystal Enterprise Solution Kit for mySAP com User s Guide 2 Reporting off SAP Data Client field Most tables in SAP contain a client field native field name is MANDT Because individual SAP systems can be configured to hold data for multiple clients the client field specifies which rows of data in a table are for which clients The Open SQL driver handles this configuration automatically When you connect to SAP you are prompted to provide your client number this information eliminates the need to create a selection formula that filters on the client Also if a report contain
30. ated the BW OLAP Kit with your Seagate Info reporting environment you can analyze and report off BW s Info Query Cubes from your Info Desktop This functionality utilizes Seagate Info s Open OLAP technology to provide you with quick access to BW s Info Query Cubes The following sections cover the key topics Adding BW s Info Query Cubes to the Info Desktop on page 44 Analyzing cubes from the Info Desktop for Windows on page 48 Generating Crystal reports from Info Query Cubes on page 49 Analyzing cubes with the Info Desktop for Java on page 49 Crystal Enterprise Solution Kit for mySAP com User s Guide 43 Open OLAP reporting with Seagate Info Adding BW s Info Query Cubes to the Info Desktop 44 The Info Query Cube s Release for OLE DB for OLAP property must be enabled before you complete this procedure For details see Releasing cubes for OLE DB for OLAP on page 42 To add an Info Query Cube to the Info Desktop 1 Start the Info Desktop for Windows 2 On the File menu click New The New Item dialog box appears 3 Double click Open Cube object The Open Cube Expert starts and displays its Choose Server dialog box Open Cube Expert Choose Server Connect Crystal Enterprise Solution Kit for mySAP com User s Guide 4 Reporting off BW s Multidimensional Data 4 Inthe Active Open OLAP Gateways list expand OLE DB then expand si_sap 5 Sele
31. can report off your customized ABAP data cluster by searching for the table named B2SALDO Although it takes some time to define each data cluster keep in mind that once the definition is complete all users can access the cluster regardless of whether or not they have ABAP experience Crystal Enterprise Solution Kit for mySAP com User s Guide 3 Advanced Open SQL Reporting Simplifying the Open SQL driver The standard SAP system has thousands of tables to which the Open SQL driver provides access Finding the data is the first challenge when building a report ABAP reporting usually requires a content specialist to identify where in the SAP system the reportable data resides The Open SQL driver is a powerful driver packed with a large number of features While some of these features require ABAP programming knowledge or knowledge of the SAP authorization model it is possible for business users to make use of these features as well The following are some tips for simplifying the usability of this driver Using Info Views and Crystal Dictionaries Info Views and Crystal Dictionaries are structured and simplified views of data that you can provide to individuals who are designing reports with the Open SQL driver Info Views and Crystal Dictionaries allow you to m Design a single dynamic view of all the data that is necessary to create organizational reports and queries m Organize the data and rename tables and fields to make it
32. click a table to add it Help Tip Each Info Set also has a G or L prefix to indicate whether the Info Set is in the global or local area it is possible to have two Info Sets with the same name one in each area To view additional information right click any query or Info Set and on the shortcut menu click Properties 6 Double click the query or Info Set that you want to add to the report If the query or Info Set contains parameters the Enter Parameter Values dialog box prompts you for information Use the dialog box to specify the data that you want to include and then click OK 7 When you are returned to the Data Explorer click Close You can now add fields and continue to design your report in the usual manner For additional information on parameters and on general report design topics consult the Online Help or the printed User s Guide supplied with your Report Designer Crystal Enterprise Solution Kit for mySAP com User s Guide 15 Reporting off ABAP queries and Info Sets 16 To select an ABAP query Note Follow this procedure if your R 3 system is version 4 5b or earlier For later versions of R 3 see To select an ABAP query or Info Set on page 14 1 Connect to SAP with the Report Designer select the ABAP Query driver and provide your user credentials For details see Connecting to SAP with the Report Designer on page 6 The Allow Reporting On dialog box appears Allow Report
33. ct the machine name of the Open OLAP Gateway that your administrator has configured for BW connectivity then click Connect The Connect To Server dialog box appears Connect To Server x Type of Server OLE DB Gateway si_sap pbrownsey04 Cancel Provider MDmsaP OLAP Server ew0e User ID demo Parameters stc_client 800 stc_language er 6 Inthe Provider field type MDrmSap In the OLAP Server field type the information that appears in the Description field of your BW server s Properties screen Note To locate the required information about your BW server start the SAP Logon screen select your BW server from the list and click Properties The Report Designer s logon fields are case sensitive so the entries must match exactly 8 In the User ID and Password fields type your SAP user credentials 9 Inthe Parameters field provide your SAP client number and your default SAP logon language as follows sfc_client x sfc_language y For instance if your usual SAP client number is 800 and your default language is English you type sfc_client 800 sfc_language en 10 Click Connect 11 When you are returned to the Choose Server dialog box click Next Crystal Enterprise Solution Kit for mySAP com User s Guide 45 Open OLAP reporting with Seagate Info The Choose Database dialog box appears Open Cube Expert Choose Database DATABASESW_COPAT 12 Select the Info Cube that stores the I
34. d m On the SQL tab Prompt on every table is selected Crystal Enterprise Solution Kit for mySAP com User s Guide Advanced Open SQL Reporting This chapter describes some of the advanced tasks related to reporting with the Open SQL driver These tasks include reporting off ABAP data clusters and functions and using the Cluster Definition tool Crystal Enterprise Solution Kit for mySAP com User s Guide 23 Overview Overview Advanced functionality in the Open SQL driver allows you to report against ABAP functions and ABAP data clusters ABAP developers can use these features to perform advanced tasks such as reporting against data clusters in HR The Cluster Definition tool is provided as part of the server installation for users who need to add edit and delete data cluster definitions Developers can also utilize ABAP to augment report processing Advanced users can hide some of the complexity of the Open SQL driver for business users who need to build reports quickly This chapter includes the following topics m Reporting off ABAP functions on page 24 m Reporting off ABAP data clusters on page 29 m Mapping ABAP data clusters on page 30 m Simplifying the Open SQL driver on page 41 Additionally the Open SQL driver provides the ability to secure the data to which users have access You can place limitations either on individual tables or at a more granular level on the individual
35. d report Configuration options When you install the Data Access Kit the setup program changes some configuration options of your Report Designer so that it can take advantage of the drivers advanced features These global changes affect your default reporting options therefore you may notice slightly altered behaviors when you report off data sources other than SAP Firstly the driver installation configures the Report Designer to list tables and fields by both name and description Secondly the installation forces the Report Designer to prompt you for information whenever you access a database table These configuration changes generally improve the experience of reporting off SAP data Your SAP system may contain thousands of tables each with a predefined non descriptive name The configuration changes ensure that you can select specific tables for a report without having to search through an immense list To locate these configuration options in the Report Designer see To view configuration options If you are reporting off data sources other than SAP you may prefer not to be prompted for information every time you connect to the database If so clear the Reprompt user when connecting option or the Prompt on every table option in version 7 of the Report Designer Crystal Enterprise Solution Kit for mySAP com User s Guide 19 Configuration options Note If you are unable to connect to certain SAP table
36. dd wildcards to select multiple queries or Info Sets use a percentage sign to denote any number of characters use an underscore _ to denote a single character The and _ wildcards correspond respectively to the and wildcards used within Windows m Clear the filter field and click OK to proceed without filtering Note however that there is a limit to the number of objects that can be displayed in the Data Explorer If the number of queries or Info Sets in SAP exceeds this limit which is by default 8000 you may receive an Out of Memory error or a blank Data Explorer 5 When you have specified the data sources that you want to see click OK The Data Explorer appears and displays the selected queries or Info Sets along with the descriptions defined by the SAP administrator im Data Explorer x SAP R73 Info Sets Wg Make New Connection vansapOl ES GL AU AB Audit Letter Changed Documents gt x xx E OL AU AD Audit Letter Cust Account with Variance gt x xx E OL AU AK Audit Letter Vendor Account with Variance gt x xx E OL AU AS Audit Letter Bal Sheet Accts with Variance gt x xx E OL AU AT Audit Letter Analysis of offsetting acct determinat x gt 5H a A a Data Explorer Options Browse through the folders to find your data source s tables Select and Add tables Omon that contain data you want to report on You can also double
37. dvanced Open SQL Reporting For example if table T contains departments that are over budget you can link T Department to F Department and have a record selection formula specifying F Name Richard and DateField Date 1999 04 14 This formula will get the years of service age and start date of all people named Richard in departments over budget on April 14 1999 Functions with structures as inputs and outputs Function F IMPORTING VALUE ADDRESS LIKE S_ADDR STRUCTURE S_ADDR EXPORTING VALUE CONTACTINFO LIKE S_CINFO STRUCTURE S_CINFO S_CINFO is defined as PHONE 20 TYPE C EMAIL 100 TYPE C S_ADDR is defined as STREET 100 TYPE C ZIPCODE 6 TYPE N lt a tl This function would appear as a table called F with the following schema Field Type Address street String Address zipcode Integer ContactInfo Phone String ContactInfo email String As before you must either link the street and zip code fields to or from another table or define them in a record selection formula Functions with a table as their output Function F IMPORTING VALUE NAME TYPE C EXPORTING VALUE GENDER TYPE C TABLES POSITIONS STRUCTURE S_POSN S_POSN is defined as TITLE 20 TYPE C STARTDATE TYPE D Crystal Enterprise Solution Kit for mySAP com User s Guide af Reporting off ABAP functions 28 In this case the function takes a name as an argument and returns the age and po
38. e Table Reference Field ABAP type Length FR 1 800 Pal VANSAPOI INS In the Key Number field type the sequence number of the key field that you want to specify For this example type 001 this is the first entry for this cluster area s key In the Key Name field type the name that you want to appear when you use this key field in the Report Designer For this example type K_PERNR Tip In general follow a naming convention For instance start a key field name with K_ to specify it as a key field as has been done here Use the Reference Table field to define the key field s data type by referencing an existing field of the same type in another table For this example type PC2B0 because it is the name of the structure that holds the Reference Field In the Reference Field field type the name of the field to which you want to refer This field must exist in the Reference Table For this example type PERNR Note If the key field is not already defined in the data dictionary and if you do not define it by referencing an existing field you can manually specify the ABAP type and Length in order to define the key field s data type In this example the key field is defined by reference so you can ignore the ABAP type and Length fields Click Save then click Back to return to the View Cluster Record screen 10 Repeat steps 4 to 9 for each field in the key In the Key Number field be sure to 36
39. eports Each subfolder corresponds to a specific Data Access Kit driver 3 Browse the subfolders contents select the report that you want to see and then click Open The report appears in the Preview tab of the Report Designer 4 Click the Design tab see how the sections and groups have been used to create the report s layout 5 Use the Report Designer s other tools such as the Field Explorer the Formula Editor and the Record Selection Formula Editor to see how the SAP data has been incorporated and utilized in the report To refresh the sample reports against your SAP system Note Depending on your current SAP configuration you may or may not retrieve data when you refresh the sample reports against your SAP system 1 Start the Report Designer and on the File menu click Open 2 Locate the sample reports folder usually C Program Files Seagate Software Crystal Enterprise Solution Kit for mySAP com Samples Crystal Enterprise Solution Kit for mySAP com User s Guide 7 Pointing existing reports to your production system 3 Browse the subfolders contents select the report that you want to see and then click Open The report appears in the Preview tab of the Report Designer 4 On the Report menu click Refresh Report Data Note If the report contains parameters the Refresh Report Data dialog box prompts you to Use current parameter values or Prompt for new parameter values If you are unf
40. esigned to retrieve Reports based on ABAP queries and Info Sets behave similarly to reports based on stored procedures in mainstream databases You can include only one query or Info Set per report however you can insert subreports based on different queries or Info Sets into the main report Your ABAP queries and Info Sets may contain parameters that you can use to limit the data returned from the SAP system For example you might specify a date range to get data for a certain period only If parameters are included in the ABAP query or Info Set the Report Designer prompts you to specify the values that you want to include in the query Crystal Enterprise Solution Kit for mySAP com User s Guide 13 Reporting off ABAP queries and Info Sets 14 Note The combined Info Set ABAP Query driver is designed for use with versions 4 6b of SAP R 3 and versions 2 0b of SAP BW If you are reporting against an earlier version of SAP R 3 use the standalone ABAP Query driver to report off ABAP queries The ABAP Query driver is not installed by default so you must select it explicitly during a Custom installation For information on designing ABAP queries and Info Sets refer to your SAP documentation To select an ABAP query or Info Set Note Follow this procedure if your R 3 system is version 4 6b or later For earlier versions of R 3 see To select an ABAP query on page 16 1 Connect to SAP with the Report Designer select the
41. esigner component of Seagate Info For more information on creating Crystal Dictionaries consult the Online Help or User s Guide supplied with Crystal Reports Crystal Enterprise Solution Kit for mySAP com User s Guide 41 Simplifying the Open SQL driver Clusters and security The configuration of the cluster and security definitions can be time consuming depending on how much HR reporting needs to be done and how tight the security of the system needs to be However this usually needs to be done only once When the customization of an SAP system is complete the definition of data clusters does not change and it is unlikely that the checks that need to be performed against a table will change frequently For information on defining clusters see Mapping ABAP data clusters on page 30 For instructions on customizing security definitions see the sections pertaining to the Security Definition Editor in the Solution Kit for mySAP com Installation Guide 42 Crystal Enterprise Solution Kit for mySAP com User s Guide Reporting off BW s Multidimensional Data4 This chapter shows how to analyze and report off the multidimensional data stored in the Info Query Cubes that reside in your SAP Business Information Warehouse Crystal Enterprise Solution Kit for mySAP com User s Guide 41 Overview of the BW OLAP Kit Overview of the BW OLAP Kit The BW OLAP Kit has been specially designed to integrate the Online Analyt
42. essseeees 6 Connecting to SAP with the Report Designer sssssscsssseessees 6 Using the Report EX GNIS pace neses adsuesieeiesaticresieeseageunestinvelanauenusiored n EE N e EEEE 7 Using the Log On Server command ssssssessssisesriserissetsssistsresettrstresteessrisestesereseere 8 Logging on to the SAP server esssseessereseeresesreessseessteeestessrtsesessseessreessterestsssessseess 8 Reporting off tables views clusters and functions seeeeeeeees 9 Objects supported by the Open SQL driver sssesssssssrsssrrssrrssrrrssrresresssrsssreeerrese 10 Selecting tables views functions and clusters sessssessesresrrrseriserissereserresressre 11 Linking tablesand Views i ics cesccestbepascedacpexdarsenensneiaieneesanideernecsntenadie aS E 12 Reporting off ABAP queries and Info Sets ssccsssesssscesseeees 13 Setting up the sample reports ssascsscssssesesscnseseseaseesensssacs 17 Pointing existing reports to your production system ss00e 18 COnTIGUTAUION GPUONS eserini ai 19 Crystal Enterprise Solution Kit for mySAP com User s Guide i Chapter 3 Advanced Open SQL Reporting OPI reiiacnidiii ienei nirenani a AERE AEE EEES 22 Reporting off ABAP functions sseesseesseessoessessssesssessseessesssesssesssse 22 How it WOKS eor corcsvensnsbseaseacenannyniniaastenise e an i aaa a e S 23 LIMITATIONS sssigososirscnki inania on a i i 23 EXAMP leS etapa a a a a a iste shat tase a o 23
43. eteessetteesaenee 6 generating OLAP reports cceeeseserseeeeees 49 logging on tO SAP 25 cosecrecserscescsencerserecsensaaderses 8 report experts OLAP reports selecting drivers report templates adding tO SAPar eroine nene a ienei taii 57 creating for QUETI ESssisscsesisonsessireisissisisesisrsres 56 reporting advanced TOPICS eers ieerriioie reeeo off ABAP data clusters s sseseeeseeeeeereseseeee off ABAP functions ee off ABAP queries and Info Sets off BW s multidimensional data off Info Query Cubes 0 0 eee off tables views clusters and functions Open OLAP for Seagate Info cceeeeeee reports creating off Info Query Cubes 00 eee eee 49 50 creating off SAP data 5 exporting and printing ss s ssssssseseresiseereree 61 Crystal Enterprise Solution Kit for mySAP com User s Guide generating from Info Query Cubes ccececeeeeeeeees templates for SAP queries A NAVEA MG 2 00 ssscadevesectovs arse rea CEE ERLE EE reporting off BW s multidimensional data 41 scheduling piesen arrire inr aerer rore 6 selecting Ko EVS EE T an SAP system export formats setting database location s sseseesseeeereeee setting UP SAMPIES ssriasiserssisresesrssierinsser troubleshooting cceseeecseseeeees 3 viewing SAP queries as Crystal reports 55 Reprompt user when connecting configuration Options cceeeseeeeseeeeeeees
44. g risisesisis sessist 64 using as views 5 Crystal Enterprise scheduling reports 0064 6 Crystal Reports Viewer USING s s sssresssisies ersen 60 cubes see Info Query Cubes D data access connecting with the BW OLAP Kit connecting with the Data Access Kit connecting with the SAPGUI Integration Kit 56 Data Access Kit configuration Options ccecseseeeeeeeeees 19 connecting to SAP ja6 OVEFVIEW eeeeceeeeees 6 sample repris s 5 c pssveeseasevserencederverseotevserouees 7 Crystal Enterprise Solution Kit for mySAP com User s Guide 67 data ACCESS reStriCtiONS ccccccscccessscecessseesesseeens 40 data clusters see ABAP data clusters data sources ABAP data ClUStErS e sscsssessecsesirssestoisrosisisesisssve 9 ABAP FUNGI OAS snenie nan nE 9 ABAP queries 13 Info Query Cubes 42 Info Sets cece a13 transparent pool and cluster tables 9 troubleshooting eeceeeeeeeeeee 64 ATE NE S cians sedvessnetents dash oe 9 database location setting for reports 04 18 databases logical isi ss issese ction ninsis 13 designing report templates PEPONI aiia r a a Susdhnodest sevens development reports pointing to a production system 18 dictionaries Crystal Dictionaries s ssesssssssssseseereresereseeee 39 Of data Clusters esiseina nmi 28 of data clusters creating s ssssssseries eresie 28 direct O
45. g off tables views clusters and functions 4 When you have specified all the tables that you want to see click OK The Data Explorer appears and displays the selected tables along with the descriptions defined by the SAP administrator a Data Explorer x SAP R73 Info Sets SAP Table Cluster or Function X3 Make New Connection vansap01 E FN SA4_ACTIVATE_COMPONENT Systemadm Assistent Komponente akt FN SA4_BKUPLOG 45 400 Backup Log E FN SAA_COPY_SUBJECT Schlagwortzuordnungen kopieren FN SA4_DEFINE_COMPONENT Systemadm Assistent Neue Komponente E FN SAA_DEFINE_SUBJECT Systemadm Assistent Schlagwort definieren E FN SAA4_DISPLAY_ADMIN System Administration Assistant Administration x SS eee Data Explorer Browse through the folders to find your data source s tables Select and Add tables that contain data you want to report on You can also double click a table to add it Help Tip To view additional table and database information right click any table and on the shortcut menu click Properties Add to evyorites Delete Favorite Options 5 Double click the tables that you want to add to the report Tip You can also CTRL click multiple tables and then click Add 6 When you ve selected all of the necessary tables click Close If you selected multiple tables for the report you must provide table linking information For more details see Linking tables
46. he driver you select you must specify the SAP system that you want to report off and then provide valid R 3 or BW user credentials for that system Each driver prompts you for this logon information before it allows you to select the elements that you want to include in the report Your user credentials are also requested when you run any existing reports built off SAP data sources To logon to the SAP server 1 Once you ve selected a data source and a driver the SAP R 3 Logon dialog box appears SAP R 3 Logon xi R73 System Group Server Advanced T ew208 T TestServerd 6b 8 Crystal Enterprise Solution Kit for mySAP com User s Guide 2 Reporting off SAP Data 2 On the R 3 System tab select the SAP system that you want to report off Note If your SAP administrator has not configured SAP Logon your SAP system will not appear on the R 3 System tab In this case click the Server tab and provide the valid SAP system information Contact your SAP administrator if you are unsure of the entries that need to be made 3 Click OK The next SAP R 3 Logon dialog box prompts you for User Data SAP R 3 Logon r User Data a i Cancel Password Language HH 4 Type your usual SAP user credentials in the Client User Password and Language fields 5 Click OK The Report Designer logs you onto the SAP system and displays the Allow Reporting On dialog box Use this dialog box to filter the data that is returned
47. ical Processing OLAP capabilities of Seagate Info with your SAP Business Information Warehouse BW However the BW OLAP Kit is also available to Crystal Reports users who do not have access to a Seagate Info environment The BW OLAP Kit provides two general ways to analyze and report off the multidimensional data stored in BW s Info Query Cubes The method that is available to you depends upon the way your SAP administrator has set up your reporting environment m Open OLAP reporting with Seagate Info m Direct access to BW s Info Query Cubes Regardless of the method you use each Info Query Cube s Release for OLE DB for OLAP property must be enabled Releasing cubes for OLE DB for OLAP 42 In order to make an Info Query Cube available to Seagate Info or Crystal Reports users you or your administrator must first enable the cube s Release for OLE DB for OLAP property from within the SAP Business Explorer Analyzer To release a cube for OLE DB for OLAP Note This example uses the SAP Business Explorer Analyzer for BW 2 0B 1 Start the SAP Business Explorer Analyzer 2 If prompted by Microsoft Excel click Enable Macros Microsoft Excel 21 x C Program Files SAPpc Bw sapbex xla contains macros Macros may contain viruses It is always safe to disable macros but if the macros are legitimate you might lose some Functionality Disable Macros i More Info 3 On the SAP Business Explorer toolbar cl
48. ically some combination of personnel number and something else The key is stored in a single text field but may actually represent more than one logical key field for example personnel number a sequence number for HR Payroll data How it works The difficulty in working with clusters from a generic relational data access point of view is that the definition of the clusters is not stored in a repository such as the ABAP dictionary unlike the definitions of transparent pool and cluster tables for instance Furthermore the format of these clusters may change from site to site due to customizations Finally it is fundamentally difficult to map these as tables in the relational sense because although the data represented is relational it is stored in independent clusters in an almost hierarchical form Crystal Enterprise Solution Kit for mySAP com User s Guide 29 Reporting off ABAP data clusters In order to overcome these issues the individual components of data clusters must be mapped as tables You can do this by creating a dictionary of the clusters on a particular SAP system The dictionary can then be accessed by the Open SQL driver To build this dictionary use the Cluster Definition tool which was installed by your administrator with the Solution Kit for mySAP com transport files Mapping ABAP data clusters 30 The Cluster Definition tool transaction ZCDD enables you to create a dictionary of the data clusters on
49. ick Tools and on the submenu click Edit queries global definition 4 If prompted by the SAP Logon dialog box double click your BW server and enter your logon information 5 Inthe Define the query dialog box click Open query on the toolbar Crystal Enterprise Solution Kit for mySAP com User s Guide 9 4 Reporting off BW s Multidimensional Data In the Open Query dialog box select the Info Query Cube that you want to make available to users then click OK When the query definition appears click Query properties on the toolbar In the Query properties dialog box select the Release for OLE DB for OLAP option then click OK P Query properties x Description feaRSQUHIER O Documentation Result position Key date y Botomvigh z pora K I for OLE DB Display options Number format IV Adjust formatting after refreshing Sign Display I Suppress repeated key values x z I Display scaling factors for key figures I Suppress zeroes Entry variables sequence Owner IPSQA4 Last changed by IPSQ4 Date time 7 24 00 1 56 16 PM OK Cancel On the toolbar click Save query then click Exit SAP BW now exposes the Info Query Cube using the OLE DB for OLAP interface This allows Seagate Info and Crystal Reports users to analyze and report off the cube s multidimensional data Last changed Open OLAP reporting with Seagate Info If your administrator has integr
50. ill out the Product Registration form on the Crystal Decisions web site at http www crystaldecisions com register m Print the Product Registration form and then fax it to the registration fax number closest to you Crystal Decisions will then fax you a registration number that can be entered into the product the next time you use it Registration fax numbers USA Canada 1 604 681 5147 United Kingdom 44 0 20 8231 0601 Australia 6 2 9955 7682 Germany 49 0 69 9509 6182 Hong Kong 852 2893 2727 Singapore 65 777 8786 Registration of your core product Crystal Enterprise Crystal Reports or Seagate Info is required to access online or telephone technical support In addition registering the product ensures that you are kept up to date with product advancements Technical support To find out how to receive technical support services on the product you purchased m Consult the enclosed Technical Support Guide Go to our support web site at http support crystaldecisions com m Contact your regional office Go to http www crystaldecisions com contact and locate the one nearest to you Document conventions For easy recognition within procedures command names button names and other pertinent User Interface UI features appear in bold type For example On the File menu click New and so on Letter Gothic font indicates data that you enter using the computer keyboard For example Open your browser and go to htt
51. ing On dialog box appears r Table Name Filter Table Name LIKE _ e g DAV matches DAVE DAVID DAV_ matches DAVE only Table Types M Views Pool Tables M Cluster Tables IV ABAP Data Clusters IV ABAP Functions Note If you log on to your SAP system but the Allow Reporting On dialog box does not appear check your Report Designer s configuration options For details see Configuration options on page 19 2 Inthe Table Types area select the type of data sources that you want to search for 3 Inthe Table Name Filter area type a filter to select the data sources that you want to make available to the report Use the following techniques when selecting tables m Type full or partial table name s m Separate distinct table names with commas m Add wildcards to select multiple tables use a percentage sign to denote any number of characters use an underscore _ to denote a single character The and _ wildcards correspond respectively to the and wildcards used within Windows m Clear the Table Name field and click OK to proceed without filtering tables Note however that there is a limit to the number of tables that can be displayed in the Data Explorer If the number of tables in SAP exceeds this limit which is by default 8000 you may receive an Out of Memory error or a blank Data Explorer Crystal Enterprise Solution Kit for mySAP com User s Guide 11 Reportin
52. ing On x SAP Query name filter Query name LIKE j _ Enter user group and Query name separated by a space e g DAV matches DAVE DAVID DAV_ matches DAVE only Cancel Note If you log on to the SAP system but the Allow Reporting On dialog box does not appear check your Report Designer s configuration options For details see Configuration options on page 19 Type a filter to select the queries that you want to make available to the report Use the following techniques when selecting queries m Type full or partial names of queries m Separate distinct names with commas m Separate the user group and query name with a space m Add wildcards to select multiple queries use a percentage sign to denote any number of characters use an underscore _ to denote a single character The and _ wildcards correspond respectively to the and wildcards used within Windows m Clear the filter field and click OK to proceed without filtering Note however that there is a limit to the number of objects that can be displayed in the Data Explorer If the number of queries in SAP exceeds this limit which is by default 8000 you may receive an Out of Memory error or a blank Data Explorer When you have specified the queries that you want to see click OK The Data Explorer appears and displays the selected queries along with the descriptions defined by the SAP administrator Tip To view additional info
53. is displayed in the Crystal Reports Viewer Using the Crystal Reports Viewer The following sections briefly show how to navigate export and print Crystal reports with the Crystal Reports Viewer The viewer installation is included on the Solution Kit for mySAP com CD Navigating Crystal reports 66 When viewing a Crystal report navigate through the data in its entirety by clicking the page navigation buttons on the viewer s toolbar Go to First Page Go to Previous Page Go to Next Page Go to Last Page and Stop Loading Or specify a particular page in the Page Number box To page through the report Use the page navigation buttons on the toolbar to move through the report Waja 192 gt vita Note The total number of report pages may not be calculated until you click the Go to Last Page button Crystal Enterprise Solution Kit for mySAP com User s Guide 5 Viewing SAP Queries as Crystal Reports To increase decrease the report s size 100 a Type a numeric value in the Zoom list on the toolbar or choose from the list of default zoom values Exporting and printing reports From the Crystal Reports Viewer you can export reports to various file formats including version 7 and 8 Crystal report formats rpt Microsoft Excel xls Microsoft Word doc Rich Text rtf and Adobe Acrobat pdf You can also print hard copies of your reports To export a report 1 2 In the viewer click the Export b
54. it for mySAP com When combined with Crystal Reports or with the enterprise reporting power of Crystal Enterprise or Seagate Info the Solution Kit for mySAP com provides you the SAP user with the ability to extract the business intelligence contained within your SAP R 3 and BW systems This User s Guide leads you through the various reporting tasks that the Solution Kit for mySAP com enables you to perform When combined the various components enable you to report directly off your SAP R 3 and BW data and to generate Crystal reports from SAP queries Who should use this guide This guide includes instructional information for report designers and report users The major product components the Data Access Kit the BW OLAP Kit and the SAPGUI Integration Kit are treated separately and the documentation for each component is organized by key reporting tasks Chapter 2 Reporting off SAP Data shows how to use the Data Access Kit driver to design Crystal reports off the data stored in SAP R 3 or SAP BW Preliminary instruction on connecting to SAP and selecting a data source are included Chapter 3 Advanced Open SQL Reporting describes advanced reporting topics associated with the Open SQL driver These topics include reporting off ABAP functions and defining and reporting off ABAP data clusters Chapter 4 Reporting off BW s Multidimensional Data shows how to report off BW s OLAP data with the BW OLAP Kit The
55. ls Crystal Enterprise Solution Kit for mySAP com User s Guide 9 Reporting off tables views clusters and functions You may choose to hide some of the complexity of the Open SQL driver for business users who need to build reports quickly For details see Simplifying the Open SQL driver on page 42 Objects supported by the Open SQL driver The Open SQL driver provides access to several low level objects within SAP transparent tables pool and cluster tables views and ABAP data clusters and functions Transparent tables This type of database object is similar to the traditional database table Transparent tables contain the majority of SAP application data from which you can derive Business Intelligence Most SAP applications use one or more transparent tables to store and retrieve business transactions You can link these tables to other transparent tables in order to pull information from other application areas of the SAP system Pool and cluster tables Pool and cluster tables are made up of a logical grouping of other database tables They are primarily used to store application configuration and control information rather than the actual application data Because these tables are only a logical view of several tables combined they are accessible only through the Open SQL driver Native database access will not provide the same view of this data Views A view appears as one table with a list of fields but actual
56. ly consists of several tables linked together Views provide a more abstract view of the data and allow you to build reports without having to worry about linking multiple tables in a report Views are maintained within SAP and need to be configured before you use them for reporting For more information on views see your SAP documentation ABAP data clusters and functions Reporting off ABAP data clusters and functions are advanced topics that usually require some understanding of the ABAP programming language For details see Advanced Open SQL Reporting on page 23 10 Crystal Enterprise Solution Kit for mySAP com User s Guide 2 Reporting off SAP Data Selecting tables views functions and clusters Once you have selected the Open SQL driver and provided valid SAP user credentials use the Allow Reporting On dialog box to choose the tables views functions or clusters that you want to add to the report You can filter by the type of table and by the actual table name Note that in this situation table also refers to views ABAP data clusters and ABAP functions For advanced information on ABAP data clusters and functions see Advanced Open SQL Reporting on page 23 To select tables views functions and clusters 1 Connect to SAP with the Report Designer select the Open SQL driver and provide your user credentials For details see Connecting to SAP with the Report Designer on page 6 The Allow Report
57. n already added to the report All the input and output parameters are displayed as fields in the table Specify the input parameters either by linking them to another table s fields or by adding them to a record selection formula If the output of the function is one or more tables the virtual table consists of rows that are the cross product of the values in all the tables If the output of the function is one or more values or structure instances the virtual table consists of a single row containing all the values structure values Limitations For functions to be used in a report they must meet two conditions Functions must have defined return types for each of the output parameters m Functions must not have whole tables as input parameters Note If a function does not meet the first condition you can write a wrapper function with defined return types and then call the original function from within the wrapper function Finally the ability to call entire programs is not supported you may call individual functions only Examples The following examples illustrate the different types of ABAP functions that can be called by the Open SQL driver and show how they appear in the Report Designer Functions with values as inputs and outputs Function F Importing VALUE NAME TYPE C VALUE DEPARTMENT TYPE C Exporting VALUE Years_of_service TYPE I VALUE Age TYPE I Crystal Enterprise Solution Kit for
58. nfo Query Cube that you want to add to the Info Desktop then click Next The Choose Cube dialog box appears Open Cube Expert Choose Cube 13 Select the desired Info Query Cube then click Next 46 Crystal Enterprise Solution Kit for mySAP com User s Guide 4 Reporting off BW s Multidimensional Data The Summary dialog box appears Open Cube Expert will create an Open Cube with the following specifications peas verify the information and press the back button to make necessary changes Title 0D COPA 0D COPA Q001 Server Type OLE DB Gateway si_sap pbrownsey04 Owner Administrator Database DATABASE 0D_COPA Cube 0D_COP4 0D_COP4_G001 URI osca iiop com seagatesoftware img osca si_sap cect e 14 When you ve verified the cube information click Finish You are returned to the Info Desktop which displays the new cube object fj Info Desktop O x File Edit View Tools Help JO Aeagel imealour a x Qaerge pbrownsey04 l Seagate Info Samples Employee Profile Alphabetical Financial Report Inventory Report by Category Product Catalog by Category Sample Count Program Top Craze Customers Query Toys Co Cube World Sales Report For Help press F1 APS pbrownsey04 User Administrator 7 Seagate Info users can now analyze and report off this Info Query Cube through the Info Desktop for Windows or for Java However because
59. o Desktop for Windows and you must have the Info Report Designer installed locally To create a report from a Worksheet view 1 On the File menu click Save View As 2 Inthe Save View As dialog box type a name for the Worksheet view 3 Click OK 4 On the Tools menu click Generate Report The Info Report Designer opens automatically generates an OLAP report and displays the OLAP grid in the Preview tab Use the Info Report Designer to format and modify this report as you would any other OLAP report You can also save the report to the Info APS and schedule it for regular processing within the Seagate Info system Analyzing cubes with the Info Desktop for Java If your administrator has enabled Seagate Info WebAccess functionality you can connect to and analyze Info Query Cubes over the Web Note If you have the Info Desktop for Windows installed locally see Analyzing cubes from the Info Desktop for Windows on page 48 To analyze cubes over the Web 1 Open a browser window and go to http webserver ciweb where webserver is the name of the machine that is running the Seagate Info WebAccess components 2 Click Info Desktop for Java Crystal Enterprise Solution Kit for mySAP com User s Guide 49 Direct access to BW s Info Query Cubes The Info Desktop for Java logon applet appears A Enter a user name and password that is valid for this system User Name l Password APS PBROwNsEY04 Connect Cancel
60. olution Kit for mySAP com User s Guide 3t Reporting off ABAP data clusters 32 3 Press Enter The Object Navigator displays the information for the specified program Program RPCLSTB2 an BT e 1 314 e0 D Dictionary structures gt E Types gt G Fields b gt Macros gt E Events gt Subroutines b gt Gi Screens gt G Gul status b gt E GUI tite D Transactions gt G includes 4 Inthe Object name list expand the Fields folder 5 Double click the entry that corresponds to your cluster area s key For this example double click the B2 Key entry The relevant ABAP code is displayed Crystal Enterprise Solution Kit for mySAP com User s Guide 3 Advanced Open SQL Reporting ABAP Editor Dispiay include RPC2B2 Be a 2280 6 Prose ag AUX_ONUXT AUX_OTABX AUX_SRTF2 B2 VERSION BEFORE_IMAGE_PCLX BEZUG BISPERNR BUFFER_DIR C1 C1ZNR CALLED CLST_INF CLUSTER_ARCHIVED ANLNT 6 Inthe ABAP code look for the heading that denotes the beginning of the cluster area s key and note the structure that is included in the following line For this example look under the heading DATA BEGIN OF B2 KEY for the line INCLUDE STRUCTURE PC2B0 highlighted in the image above This shows that the PC2B0 structure contains the fields of the key Now that you ve located the name of the structure that holds the key fields you need to determine the names of those key fields
61. p www crystaldecisions com Crystal Enterprise Solution Kit for mySAP com User s Guide 3 Document conventions 4 Crystal Enterprise Solution Kit for mySAP com User s Guide Reporting off SAP Data This chapter shows how to connect to SAP from the Report Designer and how to create reports off your SAP data with the Data Access Kit The chapter also discusses the sample reports and the Report Designer s configuration options Crystal Enterprise Solution Kit for mySAP com User s Guide Overview of the Data Access Kit drivers Overview of the Data Access Kit drivers The Data Access Kit consists of the Open SQL driver the combined Info Set ABAP Query driver and the standalone ABAP Query driver These drivers enable you to design reports off your SAP tables ABAP functions ABAP data clusters ABAP queries and Info Sets The Crystal reports that you create can be refreshed against the current SAP data by any user who has installed the drivers along with the Report Designer You can also schedule these reports within Seagate Info or Crystal Enterprise so your users receive customized reports with current data on a regular basis This chapter includes the following topics m Connecting to SAP with the Report Designer on page 6 m Reporting off tables views clusters and functions on page 9 m Reporting off ABAP queries and Info Sets on page 13 m Setting up the sample reports on page 17 m
62. possible that when creating a report you may not have the option to see all of the SAP tables In some cases the option to see any of the SAP tables in the list box may not be available m When you create an Info View or a Crystal Dictionary against an SAP system the tables are not displayed in the Choose SQL Table dialog box These problems may result from the configuration options in your Report Designer For more information see Configuration options on page 19 Errors when connecting to SAP 64 R 3 Error SYSTEM_FAILURE Function module Z_IMG_FETCH_DATA2 not found m Crystal Reports and Seagate Info reference the Z_IMG_FETCH_DATA2 ABAP function when you connect to R 3 If the function is missing this error appears m Ensure that each of the server installation steps has been performed successfully R 3 error System failure Function module RSAQ_REMOTE_FUNCAREA_CATALOG not found m This error message indicates that you are trying to use the Info Set driver to access a system that is older than R 3 4 6b The Info Set driver is supported only for versions 4 6b and later of SAP R 3 Crystal Enterprise Solution Kit for mySAP com User s Guide A Troubleshooting Displaying ABAP queries No ABAP queries are displayed when you use the ABAP query driver m Ensure that the user name provided at log on has the valid authorizations For details see the Solution Kit for mySAP com Installation Guide m Also ensure
63. prise Solution Kit for mySAP com User s Guide Troubleshooting A This chapter describes some common installation and configuration issues in order to assist you in troubleshooting your Solution Kit for mySAP com implementation Crystal Enterprise Solution Kit for mySAP com User s Guide 63 Reports tables and functions Reports tables and functions When you create a new report the SAP data source does not appear m This may be the result of a failure in the client installation Or the files may have been deleted since installation Run the driver installation again See the Solution Kit for mySAP com Installation Guide You are unable to report off an ABAP Query whose output is a Ranked List m SAP s ABAP query provides access to three report types that can be stored ina query Basic Lists Statistics and Ranked Lists However the ABAP Query driver only supports Basic Lists queries at present You cannot add more than ten links when linking to SAP ABAP functions m Itis not possible to have more than ten links between two tables or in this instance between two functions Tables or fields are not displayed as expected For instance m During report creation the table or field descriptions are not shown m Tables are not displayed in the Data Explorer when you create a report There is a limit to the number of tables that can be displayed in the list Depending on the number of tables in your SAP R 3 system it is
64. rmation right click any query and on the shortcut menu click Properties Double click the query that you want to add to the report Crystal Enterprise Solution Kit for mySAP com User s Guide 2 Reporting off SAP Data If the query contains parameters the Enter Parameter Values dialog box prompts you for information Use the dialog box to specify the data that you want to include and then click OK 5 When you are returned to the Data Explorer click Close You can now add fields and continue to design your report in the usual manner For additional information on parameters and on general report design topics consult the Online Help or the printed User s Guide supplied with your Report Designer Setting up the sample reports The Data Access Kit includes sample reports that have been saved with SAP data in order to demonstrate some of the ways in which you can use Crystal reports to extract and format your SAP data By analyzing or modifying these samples you can create reports that display your SAP data in ways that offer the greatest value to your SAP users To analyze the sample reports 1 Start the Report Designer and on the File menu click Open 2 Locate the sample reports folder usually C Program Files Seagate Software Crystal Enterprise Solution Kit for mySAP com Samples Depending on which database drivers you installed you will see up to three subfolders ABAP Query Reports Info Set Reports and Open SQL R
65. rows within a table For more information on using the Security Definition Editor to customize your own set of data access authorizations see Defining Security for the Data Access Kit in the Solution Kit for mySAP com Installation Guide Reporting off ABAP functions 24 Reporting off ABAP Functions is an advanced topic that requires an understanding of the ABAP programming language While technically not a table an ABAP function is often used in SAP reporting to provide calculations and to retrieve data that is based on parameters passed into the function for example an employee number passed to a function that returns the employee s address For this reason the Open SQL driver provides the ability to call ABAP functions that have defined return types and to display their results ABAP functions are also useful in situations where complex pre processing of the data must occur before viewing or in circumstances where you may wish to further optimize the performance of a query Crystal Enterprise Solution Kit for mySAP com User s Guide 3 Advanced Open SQL Reporting How it works You select a function in the same way as a table Ensure that ABAP Functions is selected in the Allow Reporting On dialog box then type the full or partial function name in the Table Name filter area When you add it to the report the function appears in the Visual Linking Expert just like a table assuming there is more than one table or functio
66. s multiple tables you need not include a link on the client field this too is handled automatically by the Open SQL driver Language field Some tables in SAP specifically those that contain text descriptions have multiple entries one for each language installed on the SAP system Consequently with these tables you must create a selection formula on the Language Key native field name is SPRAS and specify the language that you want to display For example table spras E For additional help on table linking and on general report design topics consult the Online Help or the printed User s Guide supplied with your Report Designer Reporting off ABAP queries and Info Sets The combined Info Set ABAP Query driver allows you to use an existing ABAP query or Info Set also known as a Functional Area as a source of data for a Crystal report The main advantage of this driver is that the ABAP query or Info Set is built within SAP by a content expert who then makes the data set available to the business user The user can then design multiple reports by quickly referencing the same query or Info Set Another advantage is that an Info Set can be built on top of the logical databases in SAP This allows the Info Set to inherit all of the business logic and security that is programmed into the logical database The disadvantage of using this driver is that reports can contain only as much data as the ABAP query or Info Set has been d
67. s or if you cannot view table or field names or descriptions ensure that these default settings remain selected To view configuration options 1 2 3 20 Start the Report Designer On the File menu click Options In the Options dialog box click the Database tab and note the following changes m In the Explorer Options area Reprompt user when connecting is selected m In the List Tables and Fields by area Both is selected Data Source Defaults Reporting l Fields Fonts Layout New Report Database Editors Explorer Options gt Show M Tables Table name LIKE _ MV Views I System Tables Owner LIKE 4 T Synonyms I Stored Procedures IV Reprompt user when connecting m List Tables and Fields by Sorting C Name Sort Tables Alphabetically C Description I Sort Fields Alphabetically C Bott Advanced Options M Use Indexes or Server for Speed Translate DOS Memos I Perform Grouping On Server I Auto SmartLinking Use Default Alias I Cartesian Product Translate DOS Strings T Perform Query Asynchronously IV Case Insensitive SOL Data IV Select Distinct Data for Browsing Cancel Hep Note This image shows the reporting options available in version 8 of the Report Designer If you are using an earlier version of the Report Designer the changes are as follows m On the Database tab in the Display database field by area Both is selecte
68. sition of that person Suppose that Tom s gender is male and that the Positions table returned by F for Tom contains Title StartDate Mail Clerk 1 1 93 Manager Mail 3 4 95 VP Mail 7 12 98 When the function is called the result will be a table called F that contains Name Gender Positions Title Positions StartDate Tom M Mail Clerk 1 1 93 Tom M Manager Mail 3 4 95 Tom M VP Mail 7 12 98 Functions with multiple tables as their output Function F IMPORT NG VALUE NAME TYPE C EXPORT NG VALUE GENDER TYPE C TABLES POSITIONS ST RUCTURE S_POSN OPTIONS STRUCTURE S_OPTN e S_POSN is d GRANTDATE TYPE D NUMBER TYPE fined as before and S_OPTN is defined as Suppose that the data from Positions is as before and the Options table looks like GrantDate Number 4 4 93 1000 5 6 97 15300 When the function is called the result will be a table called F that contains Name Gender Positions Title on T id Tom M Mail Clerk 1 1 93 4 4 93 1000 Tom M Manager Mail 3 4 95 4 4 93 1000 Tom M VP Mail 7 12 98 4 4 93 1000 Crystal Enterprise Solution Kit for mySAP com User s Guide 3 Advanced Open SQL Reporting Name Gender Positions Title ia ye aia opion Tom M Mail Clerk 1 1 93 5 6 97 15300 Tom M Manager Mail 3 4 95 5 6 97 15300
69. ss tase pE Ea 42 Data Access Kit c ccossesccsscsosecessyeosstcconeaoyeesencesicn 6 RIVETS r E E ea 6 OAE AE A ET 2 Open SQL driver cccssssssasiteessndtessssssssersensensseates 9 Open SQL driver advanced topics 122 SAPGUI Integration Kit rssrssisesorrisiss 56 P parameters and ABAP functions and ABAP queries and Info Sets 3 and sample reports sesssssssssiessiesssesssssesssisenee pool tables described sunen n 10 selecting for reports sen iT pre processing ABAP functions ccceceeee 22 printing reports locally vcscsteasesuseoreredusrsepsadeeseereseunsesavacdeesentans to the SAP spool x product Tegistration s 4 scvscsetsessersetecenpesvsepecdonvesees production system POINTING reports tO oo eceeseceecsesteetseteeerseeeeees 18 Prompt on every table configuration options 19 Q queries generating templates for ceeeeee ees 56 viewing AS repOrtS sisi sotiei nsina 60 R record selection editing sample reports 18 on client field MANDT asl on language field SPRAS ssneseseeeseeeee 13 refreshing reports against a production system 18 SAMPIETEPOMMS ds ccsveersvecdaviavsncdseaenoseodsedavee esse 17 registration TAX NUMDE NS ysesesven sori te rAr ET of product websitesini releasing Info Query Cubes report designer configuration Options ccceee ee eeeees 19 CONNECTING tO SAP oo ceeceeceecseeeee
70. sseasacerncerssndsisbwassszen 14 tables views functions and clusters 11 70 selection formulas changing in sample reports 18 server log ON COMMANA ccceeeeeeeeeee etcetera simplifying the Open SQL driver ae Smart Linking assrnasr mnisi SPRAS field sctsscsnssssssasstisessstgncssssssssesnessensenssassasees subreports for ABAP queries and Info Sets 13 support Knowledge Base product registration technical a WED SE erenn ek erir iE EErEE EN Er T tables AN SECUIILY oseiro menerai inian 40 linking a selecting for reports s s ssssssssissssirirrsreseressre res 9 troubleshooting srriesrssrerssner sinirini 64 technical SUPPOTrt sz vesesssssscvsaderessenseeseesgentenease 3 templates adding to the SAP system eeeeeeeeeeee 57 Creatin Erered icare generating shee SAIN PIE MEPOMMS aissi renie EER S 17 tips online Knowledge Base ccecceeeeeeeeee 6 transaction ZCDD Cluster Definition tool 28 transparent tables described senares nasra ren 10 selecting for reports s s ssssssssissssererrsrsssseseenee 11 troubleshooting ABAP functions a23 appendix 0 eee 63 configuration Options cee eee 19 U using Business Explorer Analyzer 42 BW OLAP Kit sssssrsrsessesssisrsrseevseassessense Al Crystal Reports OLAP Report Expert 50 Data Access Kits sieme cessissases sssasstesaaadpecssttas RIO D
71. system displays this text as the Layout Description when other SAP users view the list of available report templates 10 Select the Default setting option 11 Click Enter 12 In the Change layout dialog box click Enter The query is now displayed as a Crystal report in the Crystal Reports Viewer which is integrated into the SAPGUI Crystal Enterprise Solution Kit for mySAP com User s Guide 65 Viewing SAP queries as Crystal reports Viewing SAP queries as Crystal reports Once an initial Crystal report template has been associated with a particular SAP query other SAP users can view that query as a Crystal report If the Crystal report template has been set as the default format then users need only execute the query to view the report To view an SAP query as a Crystal report 1 Execute one of your SAP queries in the SAP List Viewer For instruction on displaying queries in the SAP List Viewer consult your SAP documentation If a Crystal report template has been set as the default layout the query data is displayed in the Crystal Reports Viewer Note To set or check default settings click the Settings menu point to Layout and click Layout Manager 2 Ifthe output is displayed in the SAP List Viewer instead of the Crystal Reports Viewer click the Settings menu point to Layout and click Choose The Choose layout dialog box appears 3 In the Layout column select one of the available report templates The query data
72. ted within the SAP system You can for instance create templates that include customized titles corporate logos or contact information in the Report Header Or you can place your copyright information along with page numbers in the Page Footer To generate a report template 1 Execute one of your SAP queries in the SAP List Viewer For instruction on displaying queries in the SAP List Viewer consult your SAP documentation 2 Inthe SAP List Viewer screen click the Goto menu and click Crystal Reports Designer 62 Crystal Enterprise Solution Kit for mySAP com User s Guide 5 Viewing SAP Queries as Crystal Reports The Name of Crystal report template generated dialog box appears Save in C a ml Multimedia Files C Program Files C Psfonts _ Recycler L System Volume Information Temp Save as type Crystal Reports RPT RPT a Cancel 3 Browse to the root directory of your local drive usually C Tip If you prefer to save the report template in a specific folder ensure that the complete path contains no spaces 4 Specify a File name for the report template 5 Click Save The Report Designer opens creates the report template and saves it to the local directory that you specified You can now add your own formatting to the template After saving your changes and closing the Report Designer you must add the report template to the SAP system and associate it with the corresponding SAP query
73. that the user belongs to the query user groups For details see the R 3 documentation regarding the ABAP Query tool Crystal Enterprise Solution Kit for mySAP com User s Guide 65 Displaying ABAP queries 66 Crystal Enterprise Solution Kit for mySAP com User s Guide Index A ABAP data clusters advanced TOPICS r aserrean 21 and security and the Cluster Definition tool 0 04 27 and the Open SQL driver eeeeeeeeeees 9 Aescribed sisisi 10 27 mapping as tables 28 reporting off a27 selecting for reports s ssssssisisssrresrsrssereresre n 11 ABAP functions AAVANCE TOPICS isisi sisreisiiinr ia and the Open SQL driver calculations and functions described esiaine examples 05 selecting for reports troubleshooting ABAP queries ANd Parameters ic ssvsscsssew susie esate eats 13 ANG SUDTEPOMS seeiis iesise 13 Selecting Tor reports s cvvcsissvesitssedeenvesde var dvetece 13 troubleshooting 00 cece eee eeeeee eee 64 65 ABAP Query driver Allow Reporting On dialog box 14 16 OVEIVIEW anieri aaae oee riae eE EEES 13 selecting data sources 14 16 version dependencies ceccccecceeeeeeees 14 adding Info Query Cubes to Seagate Info 0 44 report templates to SAP ceceeceeeeeeeeees 57 advanced reporting topics cc cceeceeseeeeeees 21 Allow Reporting On dialog box 11 14
74. ts so they report off the data stored in your R 3 production system This requires you to set each report s database location so that it points to the production system To set the location of a report 1 Start the Report Designer and ensure that you don t log on to your SAP system 2 Open the report that you want to modify Crystal Enterprise Solution Kit for mySAP com User s Guide 2 Reporting off SAP Data 3 On the Report menu click Refresh Report Data The SAP R 3 Logon box prompts you for User Data including the Client number of the R 3 development system the system against which the report was originally designed 4 Click Cancel so as not to log on to the development system The multi tabbed SAP R 3 Logon dialog box appears 5 On the R 3 System tab select your R 3 production system then click OK The SAP R 3 Logon box once again prompts you for User Data Note If your SAP administrator has not configured SAP Logon your SAP system will not appear on the R 3 System tab In this case click the Server tab and provide the valid information for your production system Contact your SAP administrator if you are unsure of the entries that need to be made 6 Inthe Client field type the number appropriate to your R 3 production system 7 Type your usual logon information in the User Name Password and Language fields 8 Click OK The report is now refreshed with data from your SAP production system 9 Save the modifie
75. ube 6 Inthe Choose OLAP Type dialog box double click OLE DB for OLAP The Connect to Olap DB Servers dialog box appears Connect To Olap DB Servers BW208 52 Crystal Enterprise Solution Kit for mySAP com User s Guide 4 Reporting off BW s Multidimensional Data 7 Inthe Provider field type MDrmSap 8 Inthe OLAP Server field type the information that appears in the Description field of your BW server s Properties screen Note To locate the required information about your BW server start the SAP Logon screen select your BW server from the list and click Properties The Report Designer s logon fields are case sensitive so the entries must match exactly 9 Inthe User ID and Password fields type your SAP user credentials 10 In the Parameters field provide your SAP client number and your default SAP logon language as follows sfc_client xxx sfc_language yy For instance if your usual SAP client number is 800 and your default language is English you type sfc_client 800 sfc_language en 11 Click Connect The Choose Cube dialog box appears Choose Cube x pm Description DB Name SIM_CARS Choose a cube from the list Cube Name is the Cube Name name stored inside the database and Title is the descriptive name of the cube appears on the desktop Cubes in Database OD_COPA OSD_Co1 CARS_HIER 12 Select the Info Cube that you
76. ubes To connect to the Info Query Cubes stored in BW you must provide your usual BW logon information in the Connect to Server dialog box The following procedure shows how to report off an Info Query Cube using your Report Designer s OLAP Report Expert If your administrator has not already done so you must first enable each Info Query Cube s Release for OLE DB for OLAP property For details see Releasing cubes for OLE DB for OLAP on page 42 To report off an Info Query Cube 1 Start the Report Designer 2 On the File menu click New The Crystal Report Gallery appears r Create a New Crystal Report Document A Using the Report Expert L C As a Blank Report m Choose an Expert Guides the creation of a report that contains a summarized grid based on an OLAP data source en ce j e 3 If it s not already selected click Using the Report Expert 4 From the Choose an Expert list select OLAP then click OK Crystal Enterprise Solution Kit for mySAP com User s Guide af Direct access to BW s Info Query Cubes The Data tab of the OLAP Report Expert appears OLAP Report Expert Rows Cokumns Fiter Paae Style Customize Style Labels Chat Ernie 5 Click Server Type The Choose OLAP Type dialog box appears Choose OLAP Type Essbase Cube Seagate Info Cube IBM DB2 Cube C OLE DB for OLAP Informix MetaCube Holos HDC C
77. uster Database 2 Cluster Area D Cam O D RD1 1 800 FEIT VANSAPOT TINS AA 3 In the Cluster Database field type the name of the table in which the ABAP data cluster is stored For this example type PCL2 Note To find out which transparent table contains a required ABAP data cluster ask a subject matter expert about the module you are working on Or if you are trying to locate the data from a particular program such as an SAP report like RPC11XE0 look for the table in the ABAP code When you find the table look at the data in the RELID field for a list of cluster areas 4 Inthe Cluster Area field type the name of the cluster area or RELID For this example type B2 5 Click Save and exit the Cluster Definition tool You now need to find the key to the cluster area Specifically you need the name of the dictionary structure or table in which the key fields are stored and you need the names of those key fields There are several ways to find this information within SAP This example uses the Object Navigator to locate the key information for the B2 cluster area To locate the cluster area s key fields 1 Execute transaction SE80 to access the Object Navigator 2 Select Program from the list and type the name of the program that holds the key information related to the cluster area For this example type RPCLSTB2 which is the program that holds the key information for the B2 cluster area Crystal Enterprise S
78. utton on the toolbar In the Export dialog box click the Format list and select from the available export formats Click the Destination list and select from the available export destinations Tip To save the report on your local drive specify Disk file Click OK In the Export Options dialog box specify whether you want to export All pages of the report or a particular Page Range Click OK Depending upon the export destination that you selected you may need to provide additional information For instance if you selected Disk file you must specify a location and name for the exported report To print a report locally 1 When the report is displayed in the Crystal Reports Viewer click the Print button on the viewer s toolbar In the Print dialog box click OK to accept the default print options Note The Crystal Reports Viewer uses the default printer that is configured locally under Windows Start gt Control Panel gt Printers To print a report to the SAP Spool 1 When the report is displayed in the Crystal Reports Viewer click Crystal Reports batch printing on the List menu The default SAP Spool Print dialog box appears Follow the usual SAP printing procedure Note Your administrator must install the Postscript printing components in order for you to print reports to the SAP Spool Crystal Enterprise Solution Kit for mySAP com User s Guide 67 Using the Crystal Reports Viewer 68 Crystal Enter
79. verview of the SAPGUI Integration Kit eesssesseosssessesssssssessseese 56 Generating Crystal report templates for SAP queries s0000 56 ii Crystal Enterprise Solution Kit for mySAP com User s Guide Viewing SAP queries as Crystal reports sccsscsssscsssesssesseseeees 60 Using the Crystal Reports Viewer ccsssccsssscscsscsesscsssccsencnceee 60 Navigating Crystal reports siisicec escectieslee ies ianen a s 60 Exporting and printing reports esesssssssesisesriserssserssrissttestrtsetrssresssrrssreesereseressee 61 Appendix A Troubleshooting Reports tables and functions sssssseessssesssossessscesssocessocessscssessessss 64 Errors when connecting to SAP sssccssssscsscsssesesssessseessseeees 64 Displaying ABAP queries sicisccscasacistinivisinisnnsinspinusscasianniativinncetsanuais 65 O TPE E ES O E EA E 67 Crystal Enterprise Solution Kit for mySAP com User s Guide iii Crystal Enterprise Solution Kit for mySAP com User s Guide Welcome to Crystal Enterprise Solution Kit for mySAP com This chapter briefly outlines the intended audience of the various procedures included in this guide Product registration and technical support information is also included along with a brief description of the document conventions used within this guide Crystal Enterprise Solution Kit for mySAP com User s Guide Welcome Welcome Welcome to Crystal Enterprise Solution K
80. your SAP system Once you ve added a data cluster to the dictionary you can select the cluster in the Report Designer and report off its data with the Open SQL driver You will usually require prior experience with ABAP programming because you need to find the cluster definitions within R 3 before you enter them with the Cluster Definition tool Combined the following procedures show how to map the SALDO table Time balances per period to your dictionary of data clusters with the Cluster Definition tool The SALDO table is located in the B2 PDC Data Month cluster area of the ABAP data cluster that is stored in the PCL2 HR cluster 2 transparent table In this case PCL2 is the cluster database B2 is the cluster area or type and SALDO is the table The procedures described in this example correspond to SAP R 3 4 6b To create a new cluster entry in the dictionary 1 From the SAPGUI execute transaction ZCDD The Cluster Definition tool displays its View Cluster Id Table screen SAD 7 OE iS View Cluster id Tabie Cluster ID Table Table name Cluster Area Delete Po O RDI m B00 Pal VANSAPOT INS Crystal Enterprise Solution Kit for mySAP com User s Guide 3 Advanced Open SQL Reporting 2 Click Add to create a new entry The Edit Cluster ID Record screen appears SAP Edit Ciuster id Record Cl

Crystal Enterprise™ Solution Kit for mySAP.com User's Guide

Contents

Download Pdf Manuals

Related Search

Related Contents

Crystal Enterprise&trade; Solution Kit for mySAP.com User's Guide

Contents

Download Pdf Manuals

Related Search

Related Contents

Crystal Enterprise™ Solution Kit for mySAP.com User's Guide