BC430 - ABAP Dictionary BC430 R/3 System Release 46A 20.11.2000 0 BC430 - ABAP Dictionary.........................................................................................................................................1 Copyright.................................................................................................................................................................2 ABAP Workbench...............................................................................................................................................4 Course Content....................................................................................................................................................5 Introduction.............................................................................................................................................................1 Course Objectives...............................................................................................................................................2 Function of the ABAP Dictionary.......................................................................................................................3 Database Objects in the ABAP Dictionary.........................................................................................................4 Type Definitions in the ABAP Dictionary..........................................................................................................5 Services of the ABAP Dictionary.......................................................................................................................6 Linking to the Development and Runtime Environment....................................................................................7 Unit Summary.....................................................................................................................................................8 Tables in the ABAP Dictionary..............................................................................................................................1 Course Objectives...............................................................................................................................................2 Tables and Fields.................................................................................................................................................3 Basic Objects of the ABAP Dictionary...............................................................................................................4 Two-Level Domain Concept: Example...............................................................................................................5 Transparent Tables and Structures......................................................................................................................6 Include Structures................................................................................................................................................7 Technical Settings...............................................................................................................................................8 Data Class............................................................................................................................................................9 Size Category....................................................................................................................................................10 Logging.............................................................................................................................................................11 Unit Summary...................................................................................................................................................12 Exercise Data.....................................................................................................................................................13 Exercises: Tables in the ABAP Dictionary.......................................................................................................14 Solutions: Tables in the ABAP Dictionary.......................................................................................................17 Performance during Table Access...........................................................................................................................1 Course Objectives...............................................................................................................................................2 Structure of an Index...........................................................................................................................................3 Access with Indexes............................................................................................................................................4 Data Access using the Buffer..............................................................................................................................5 Table Buffering...................................................................................................................................................6 Full Buffering......................................................................................................................................................7 Generic Buffering................................................................................................................................................8 Single-Record Buffering.....................................................................................................................................9 Buffer Synchronization 1..................................................................................................................................10 Buffer Synchronization 2..................................................................................................................................11 Buffer Synchronization 3..................................................................................................................................12 Buffer Synchronization 4..................................................................................................................................13 Buffer Synchronization 5..................................................................................................................................14 Buffer Synchronization 6..................................................................................................................................15 Unit Summary...................................................................................................................................................16 Exercises: Performance during Table Access...................................................................................................17 Solutions: Performance during Table Access...................................................................................................19 Consistency through Input Checks..........................................................................................................................1 Course Objectives...............................................................................................................................................2 Fixed Values........................................................................................................................................................3 Value Table.........................................................................................................................................................4 Inserting a Data Record.......................................................................................................................................5 Violation of the Foreign Key Check...................................................................................................................6 Foreign Key Fields / Check Fields......................................................................................................................7 Data Consistency through Foreign Keys.............................................................................................................8 Foreign Key Definitions in the Check Field.......................................................................................................9 Check Table not Equal to Value Table.............................................................................................................10 Semantic Attributes...........................................................................................................................................11 Text Table.........................................................................................................................................................12 Summary...........................................................................................................................................................13 Exercises: Consistency through Input Checks..................................................................................................14 Solutions: Consistency through Input Checks..................................................................................................16 Dependencies of ABAP Dictionary Objects...........................................................................................................1 Course Objectives...............................................................................................................................................2 Active and Inactive Versions.............................................................................................................................3 Runtime Objects..................................................................................................................................................4 Handling of Dependent Objects..........................................................................................................................5 Where-Used Lists................................................................................................................................................6 The Repository Information System ABAP Dictionary.....................................................................................7 Unit Summary.....................................................................................................................................................8 Exercises: Dependencies of ABAP Dictionary Objects......................................................................................9 Solutions: Dependencies of ABAP Dictionary Objects....................................................................................11 Changes to Database Tables....................................................................................................................................1 Course Objectives...............................................................................................................................................2 Changes to Tables...............................................................................................................................................3 How is the Structure Adjusted?...........................................................................................................................4 Conversion Process 1..........................................................................................................................................5 Conversion Process 2..........................................................................................................................................6 Conversion Process 3..........................................................................................................................................7 Conversion Process 4..........................................................................................................................................8 Conversion Process 5..........................................................................................................................................9 Possible Problems during Conversions.............................................................................................................10 Resuming Terminated Conversions..................................................................................................................11 Append Structures 1..........................................................................................................................................12 Append Structures 2..........................................................................................................................................13 Append Structures 3..........................................................................................................................................14 Summary...........................................................................................................................................................15 Exercises: Changes to Database Tables............................................................................................................16 Solutions: Changes to Database Tables............................................................................................................18 Views.......................................................................................................................................................................1 Course Objectives...............................................................................................................................................2 Why do you Need Views?...................................................................................................................................3 Structure of a View - Starting Situation..............................................................................................................4 Structure of a View - Join Condition..................................................................................................................5 Structure of a View - Field Selection (Projection)..............................................................................................6 Structure of a View - Selection Condition..........................................................................................................7 How are Tables Linked to Views?......................................................................................................................8 Structure of the View..........................................................................................................................................9 Data Selection with Views................................................................................................................................10 Database Views.................................................................................................................................................11 Includes in Database Views..............................................................................................................................12 Maintenance Views...........................................................................................................................................13 Inner and Outer Joins........................................................................................................................................14 Unit Summary...................................................................................................................................................15 Exercises: Views...............................................................................................................................................16 Solutions: Views...............................................................................................................................................19 Search Helps............................................................................................................................................................1 Course Objectives...............................................................................................................................................2 R/3 Standard Function: Input Help.....................................................................................................................3 Requirements of the Input Help..........................................................................................................................4 ABAP Dictionary Object Search Help................................................................................................................5 Selection Method of a Search Help.....................................................................................................................6 Description of the Dialog Behavior....................................................................................................................7 Interface of a Search Help...................................................................................................................................8 How do you Use Search Helps?..........................................................................................................................9 Search Help Attachment in the ABAP Dictionary............................................................................................10 Overview: Mechanisms for the Input Help.......................................................................................................11 Performance of the Input Help..........................................................................................................................12 Alternative Search Paths...................................................................................................................................13 Collective Search Helps and Elementary Search Helps....................................................................................14 Append Search Helps........................................................................................................................................15 Unit Summary...................................................................................................................................................16 Exercises: Search Helps....................................................................................................................................17 Solutions: Search Helps....................................................................................................................................21 Appendix.................................................................................................................................................................1 Flight Data Model for ABAP Training Courses.................................................................................................2 Data Model..........................................................................................................................................................3 Implementation in the ABAP Dictionary............................................................................................................4 Decision Tree for Buffering................................................................................................................................5 View as Selection Method of a Search Help.......................................................................................................6 Further Options for Search Helps........................................................................................................................7 Non-Standard: Search Help Exit.........................................................................................................................8 Migration of Existing Input Helps......................................................................................................................9 Alternative Displays of the Input Help.............................................................................................................10 Important Menu Paths and Transactions...........................................................................................................11 Index..................................................................................................................................................................13 0 BC430 - ABAP Dictionary BC430 BC430 ABAP Dictionary ªª SSAAPP AAGG 1999 R/3 System Release: 4.6A Version: January 2000 Material number: 5003 3691 (C) SAP AG BC430 1 0.2 Copyright Copyright 2000 SAP AG. All rights reserved. Neither this training manual nor any part thereof may be copied or reproduced in any form or by any means, or translated into another language, without the prior consent of SAP AG. The information contained in this document is subject to change and supplement without prior notice. All rights reserved. ª SAP AG 1999 Trademarks: Microsoft ®, Windows ®, NT ®, PowerPoint ®, WinWord ®, Excel ®, Project ®, SQL-Server ®, Multimedia Viewer ®, Video for Windows ®, Internet Explorer ®, NetShow ®, and HTML Help ® are registered trademarks of Microsoft Corporation. Lotus ScreenCam ® is a registered trademark of Lotus Development Corporation. Vivo ® and VivoActive ® are registered trademarks of RealNetworks, Inc. ARIS Toolset ® is a registered Trademark of IDS Prof. Scheer GmbH, Saarbrücken Adobe ® and Acrobat ® are registered trademarks of Adobe Systems Inc. TouchSend Index ® is a registered trademark of TouchSend Corporation. Visio ® is a registered trademark of Visio Corporation. IBM ®, OS/2 ®, DB2/6000 ® and AIX ® are a registered trademark of IBM Corporation. Indeo ® is a registered trademark of Intel Corporation. Netscape Navigator ®, and Netscape Communicator ® are registered trademarks of Netscape Communications, Inc. OSF/Motif ® is a registered trademark of Open Software Foundation. ORACLE ® is a registered trademark of ORACLE Corporation, California, USA. INFORMIX ®-OnLine for SAP is a registered trademark of Informix Software Incorporated. UNIX ® and X/Open ® are registered trademarks of SCO Santa Cruz Operation. ADABAS ® is a registered trademark of Software AG (C) SAP AG BC430 2 The following are trademarks or registered trademarks of SAP AG; ABAP™, InterSAP, RIVA, R/2, R/3, R/3 Retail, SAP (Word), SAPaccess, SAPfile, SAPfind, SAPmail, SAPoffice, SAPscript, SAPtime, SAPtronic, SAP-EDI, SAP EarlyWatch, SAP ArchiveLink, SAP Business Workflow, and ALE/WEB. The SAP logo and all other SAP products, services, logos, or brand names included herein are also trademarks or registered trademarks of SAP AG. Other products, services, logos, or brand names included herein are trademarks or registered trademarks of their respective owners. (C) SAP AG BC430 3 0.3 ABAP Workbench Level 2 Level 3 BC402 3 days BC414 2 days BC490 3 days ABAP Programming Programming ABAP Performance Techniques Database Updates Tuning BC404 3 days BC415 2 days ABAP Objects: Object- Communication Oriented Programming in R/3 Interfaces in ABAP BC405 3 days BC425 3 days Techniques of List Enhancements Processing and SAP Query and Modifications BC410 5 days BC412 2 days Programming Dialog Programming BC400 5 days User Dialogs using EnjoySAP Controls ABAP Workbench: BC420 5 days BC440 5 days Concepts and Tools Data Transfer Developing Internet Applications BC430 2 days MBC40 2 days ABAP Dictionary Managing ABAP Recommended supplementary BC460 3 days Development Projects courses are: SAPscript: Forms Design Business Process Technologies and Text Management CA925, CA926, CA927 BC095 (Business Integration CA610 2 days Technology) CATT:Test Workbench and BC619 (ALE), BC620, BC621 Computer Aided Test Tool ª SAP AG 1999 (C) SAP AG BC430 4 0.4 Course Content Preface Unit 1 Introduction Unit 5 Dependencies of ABAP Dictionary Unit 2 Tables in the Objects ABAP Dictionary Unit 6 Changes to Tables Unit 3 Performance in Table Accesses Unit 7 Views Unit 4 Consistency through Unit 8 Search Helps Input Checks Exercises Solutions Appendixes ª SAP AG 1999 (C) SAP AG BC430 5