ABAP Dictionary BCDWBDIC.pdf

BC - ABAP Dictionary

Release 4.6B

™

BC - ABAP Dictionary

SAP AG

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 Server TM 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.

December 1999

SAP AG

BC - ABAP Dictionary

Icons

Icon

Meaning

Caution

Example

Note

Recommendation

Syntax

Tip

December 1999

BC - ABAP Dictionary

SAP AG

Contents

BC - ABAP Dictionary .........................................................................................9

ABAP Dictionary .......................................................................................................................... 10

Tables............................................................................................................................................ 13

Table Fields .................................................................................................................................. 14

Reference Fields and Reference Tables.................................................................................. 15

Includes .................................................................................................................................... 16

Named Includes........................................................................................................................ 18

Foreign Keys ................................................................................................................................ 19

Generic and Constant Foreign Keys ........................................................................................ 22

Semantic Attributes of Foreign Keys ........................................................................................ 24

Cardinality............................................................................................................................ 25

Type of Foreign Key Fields ................................................................................................. 26

Text Tables ............................................................................................................................... 27

Multi-Structured Foreign Keys .................................................................................................. 29

Technical Settings ....................................................................................................................... 30

Data Class ................................................................................................................................ 31

Size Category ........................................................................................................................... 32

Buffering Permission ................................................................................................................ 33

Buffering Types ........................................................................................................................ 34

Full Buffering ....................................................................................................................... 35

Generic Buffering ................................................................................................................ 37

Single-Record Buffering ...................................................................................................... 39

Logging ..................................................................................................................................... 41

Converting Pooled Tables to Transparent Tables.................................................................... 42

Buffering Database Tables ......................................................................................................... 43

Local Buffer Synchronization....................................................................................................46

Example for Buffer Synchronization.................................................................................... 48

Which Tables should be Buffered? .......................................................................................... 53

Which Accesses Proceed Directly to the Database? ............................................................... 54

How are Table Buffers Implemented Technically?................................................................... 55

Single-Record Table Buffers ............................................................................................... 56

Generic and Full Table Buffers ........................................................................................... 58

How can you Analyze the Buffer Quality? ................................................................................ 60

Indexes.......................................................................................................................................... 61

What to Keep in Mind for Secondary Indexes .......................................................................... 63

How to Check if an Index is Used ............................................................................................ 65

Unique Indexes......................................................................................................................... 66

Index IDs................................................................................................................................... 67

Customizing Includes.................................................................................................................. 68

Append Structures ...................................................................................................................... 69

Creating Tables ............................................................................................................................ 71

Creating Foreign Keys.............................................................................................................. 74

Maintaining Technical Settings................................................................................................. 76

Creating Secondary Indexes .................................................................................................... 77

Delivery Class........................................................................................................................... 78

December 1999

SAP AG

BC - ABAP Dictionary

Activation Type ......................................................................................................................... 80

Making Changes to Tables ......................................................................................................... 81

Adding an Append Structure .................................................................................................... 82

Inserting an Include .................................................................................................................. 83

Inserting New Fields ................................................................................................................. 85

Initial Values ........................................................................................................................ 86

Deleting Existing Field .............................................................................................................. 88

Changing Data Types and Lengths of Existing Fields ............................................................. 89

Changing the Table Category................................................................................................... 90

Moving Fields ........................................................................................................................... 91

Copying Fields from Another Table.......................................................................................... 92

Copying Fields from an Entity Type ......................................................................................... 93

Deleting Tables......................................................................................................................... 94

Views............................................................................................................................................. 95

Join, Projection and Selection ................................................................................................... 97

Inner Join and Outer Join ....................................................................................................... 101

Foreign Key Relationship and Join Condition ........................................................................ 102

Maintenance Status ................................................................................................................... 103

Time-Dependent Key Components ........................................................................................ 104

Inserts with Database Views .................................................................................................. 105

Database Views.......................................................................................................................... 106

Includes in Database Views ................................................................................................... 108

Technical Settings of a Database View.................................................................................. 109

Projection Views ........................................................................................................................ 110

Help Views .................................................................................................................................. 111

Maintenance Views.................................................................................................................... 112

Restrictions for Maintenance and Help Views........................................................................ 114

Creating Views ........................................................................................................................... 115

Creating a Database View...................................................................................................... 116

Creating Help Views ............................................................................................................... 118

Creating Projection Views ...................................................................................................... 120

Creating Maintenance Views.................................................................................................. 121

Maintenance Attribute of a View Field............................................................................... 123

Delivery Class of a Maintenance View.............................................................................. 124

Maintaining Selection Conditions of Views............................................................................. 125

Deleting Views ........................................................................................................................... 126

Example for Views ..................................................................................................................... 127

Types........................................................................................................................................... 130

Data Elements ............................................................................................................................ 132

Creating Data Elements ......................................................................................................... 134

Documentation and Docu Status............................................................................................ 136

Field Labels ............................................................................................................................ 137

Structures ................................................................................................................................... 138

Creating Structures................................................................................................................. 140

Named Includes...................................................................................................................... 142

Table Types ................................................................................................................................ 143

Creating Table Types ............................................................................................................. 145

Key Definition of a Table Type ............................................................................................... 147

Access Mode .......................................................................................................................... 148

December 1999

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: