BC ABAP Reporting Tutorial - MJU

106 Pages·2000·0.53 MB·English

BC ABAP Reporting Tutorial
P
E
R
O
O
T
B
W
D
C
B
.
P
L
E
H
Release 4.6B
™
BC ABAP Reporting Tutorial SAP AG
Copyright
© Copyright 2000 SAP AG. All rights reserved.
No part of this brochure may be reproduced or transmitted in any form or for any purpose without
the express permission of SAP AG. The information contained herein may be changed without
prior notice.
Some software products marketed by SAP AG and its distributors contain proprietary software
components of other software vendors.
Microsoft®, WINDOWS®, NT®, EXCEL®, Word® and SQL Server® are registered trademarks of
Microsoft Corporation.
IBM®, DB2®, OS/2®, DB2/6000®, Parallel Sysplex®, MVS/ESA®, RS/6000®, AIX®, S/390®,
AS/400®, OS/390®, and OS/400® are registered trademarks of IBM Corporation.
ORACLE® is a registered trademark of ORACLE Corporation, California, USA.
INFORMIX®-OnLine for SAP and Informix® Dynamic ServerTM are registered trademarks of
Informix Software Incorporated.
UNIX®, X/Open®, OSF/1®, and Motif® are registered trademarks of The Open Group.
HTML, DHTML, XML, XHTML are trademarks or registered trademarks of W3C®, World Wide
Web Consortium, Laboratory for Computer Science NE43-358, Massachusetts Institute of
Technology, 545 Technology Square, Cambridge, MA 02139.
JAVA® is a registered trademark of Sun Microsystems, Inc. , 901 San Antonio Road, Palo Alto,
CA 94303 USA.
JAVASCRIPT® is a registered trademark of Sun Microsystems, Inc., used under license for
technology invented and implemented by Netscape.
SAP, SAP Logo, mySAP.com, mySAP.com Marketplace, mySAP.com Workplace, mySAP.com
Business Scenarios, mySAP.com Application Hosting, WebFlow, R/2, R/3, RIVA, ABAP, SAP
Business Workflow, SAP EarlyWatch, SAP ArchiveLink, BAPI, SAPPHIRE, Management
Cockpit, SEM, are trademarks or registered trademarks of SAP AG in Germany and in several
other countries all over the world. All other products mentioned are trademarks or registered
trademarks of their respective companies.
2 December 1999
SAP AG BC ABAP Reporting Tutorial
Icons
Icon Meaning
Caution
Example
Note
Recommendation
Syntax
Tip
December 1999 3
BC ABAP Reporting Tutorial SAP AG
Contents
BC ABAP Reporting Tutorial..............................................................................6
BC - ABAP Workbench: Reporting Tutorial................................................................................7
Note to the Reader.........................................................................................................................8
Overview.........................................................................................................................................9
Requirements...............................................................................................................................10
Syntax conventions.....................................................................................................................11
Platform........................................................................................................................................12
Naming Conventions for SAP Objects......................................................................................13
Further Documentation...............................................................................................................14
ABAP Query.................................................................................................................................15
Overview of ABAP Query............................................................................................................16
User Groups.................................................................................................................................17
Functional Areas..........................................................................................................................18
Query.............................................................................................................................................20
Basic Settings for a Query..........................................................................................................21
Creating a Basic List.................................................................................................................23
Layout of a Basic List..........................................................................................................24
Other presentations of a basic list.......................................................................................26
Creating Statistics.....................................................................................................................27
Creating a Report Using ABAP Statements..............................................................................29
Overview.......................................................................................................................................30
The ABAP Programming Language...........................................................................................31
Creating an ABAP Program........................................................................................................32
The ABAP Editor......................................................................................................................34
Comment lines..........................................................................................................................35
ABAP Statements for Screen Display......................................................................................36
Declaring data..........................................................................................................................38
Handling Variables...................................................................................................................39
Text Layout...............................................................................................................................40
List Headers.............................................................................................................................42
Dynamic List Headings........................................................................................................43
Database Access......................................................................................................................44
The SELECT Statement......................................................................................................45
Selection Criteria......................................................................................................................47
PARAMETERS....................................................................................................................48
SELECT-OPTIONS.............................................................................................................50
Variants.....................................................................................................................................52
Nested SELECT Statements....................................................................................................53
Performance of the SELECT Statement..................................................................................55
Sample Program: nested SELECT statements.........................................................................56
Logical Databases and Events...................................................................................................59
Overview: logical databases.......................................................................................................60
Creating a Report That Uses a Logical Database....................................................................61
Retrieving Data Using a Logical Database...............................................................................62
4 December 1999
SAP AG BC ABAP Reporting Tutorial
Sample program: reading SBOOK using a logical database...................................................64
Hierarchy of a Logical Database................................................................................................65
Events...........................................................................................................................................67
GET <tablename> LATE..........................................................................................................68
Sample program: report using logical database......................................................................70
Structures and Internal Tables...................................................................................................72
Internal Tables.............................................................................................................................73
Structures and Internal Tables...................................................................................................74
Declaring a structure................................................................................................................75
Declaring an internal table........................................................................................................77
Defining the Work Area............................................................................................................78
Filling internal tables.................................................................................................................79
Working with Internal Tables....................................................................................................80
IF statement..................................................................................................................................83
Sample program: internal tables................................................................................................84
Processing control levels...........................................................................................................87
Control Level Processing..........................................................................................................89
Calculating Totals.....................................................................................................................91
Sample program: processing control levels.............................................................................92
Interactive Reporting...................................................................................................................95
Concept: interactive reporting...................................................................................................96
New Event Keywords...............................................................................................................97
Creating a Detail List................................................................................................................98
Valid Line Selection................................................................................................................100
Defining a User Interface........................................................................................................101
Sample program for interactive reporting...............................................................................103
December 1999 5
BC ABAP Reporting Tutorial SAP AG
BC ABAP Reporting Tutorial
BC ABAP Reporting Tutorial
6 December 1999
SAP AG BC ABAP Reporting Tutorial
BC - ABAP Workbench: Reporting Tutorial
BC - ABAP Workbench: Reporting Tutorial
The ABAP Reporting Tutorial provides an introduction on how to create report lists.
Unit 1 presents the menu-supported tool for generating report lists.
Unit 2 introduces report programming, including the fundamental topics of reading data from a
database and writing data to the screen.
Unit 3 explains what logical databases are and how to use them. It also describes the event
concept on which ABAP programs are based.
Unit 4 introduces internal tables.
Unit 5 offers an introduction to interactive reporting. It includes the most important statements for
creating details lists.
The tutorial presents only an overview of the extensive topic of reporting. You can find further
information in the ABAP User Manual [Ext.].
December 1999 7
BC ABAP Reporting Tutorial SAP AG
Note to the Reader
Note to the Reader
You should read the following remarks before starting to work with the ABAP Workbench
documentation. Begin the Reporting Tutorial. This section discusses the following topics:
Requirements [Page 10]
Syntax Conventions [Page 11]
Platforms [Page 12]
Naming Conventions for SAP Objects [Page 13]
Further Documentation [Page 14]
8 December 1999
SAP AG BC ABAP Reporting Tutorial
Overview
Overview
December 1999 9
BC ABAP Reporting Tutorial SAP AG
Requirements
Requirements
The ABAP Workbench documentation: Reporting Tutorial addresses readers who are familiar
with the R/3 System.
To be able to work with this documentation, you must know how to log on to the R/3 System. If
you read this documentation online, you are already logged on. Otherwise, ask you system
administrator for your user name, client, and password. For more information on logging on to the
R/3 System, see the documentation Introduction to the R/3 System.
To work with this tutorial, you need R/3 System Release 4.5 or higher. If you are not sure which
version is running on your machine, ask your system administrator.
10 December 1999