SAPs Data Dictionary

1
SAPs Data Dictionary

• Learning to use it effectively

FSS Technical Peer Group Meeting Wednesday
November 13, 2002 Carolyn Fuller
2
Introduction

• To know an application is to know its data
• Data dictionary holds key to performance
• Data dictionary tools reduce custom programming

3
Agenda

• The SAP Data Model
• Data Filtration
• SAP Indexes
• Building Custom Tables/Simple Apps

4
Vocabulary

• Relational Database
• Indexes
• Unique Index
• Primary Key
• Foreign Key (Check Table)
• One-to-Many Relationship
• Recursive Relationship
• Client Dependent
• View Cluster

5
The Data Model
6
The SAP Data Model

• Transactional Data One-to-Many
• One header row to many line items
• Master Data One-to-Many
• One master to many company code masters
• One master to many transaction line items
• Recursive data
• One parent to many children grandchildren

7
Report Example
8
One Should be Driver
All the WBS (billable and non-billable)
Each WBS looks up its parent
Billable WBS
Billable WBS finds children, grandchildren
9
Recursive Relationship
10
PRHI - WBS Edges
11
Filtering Data Billing Example
Move filter to beginning of program
12
Filtering Data MM Example
Unfiltered
Filtered
13
SAP Indexes

• Primary Key
• Secondary Indexes
• Secondary Index Tables
• Foreign Key

14
Secondary Index Table
Secondary Indexes
Primary Key Unique Index
Client
15
BSIDs Secondary Indexes
Unique flag
BSID-1 Index for logical database
16
Recursive Resolution Table
17
BKPF Primary Foreign Keys
Foreign Key
18
COVP Useful Secondary Index
WBS 4579002
19
COVP Primary Foreign Keys
20
Additional Useful Indexes
http//fuller.mit.edu/SAPDocs/indexes.htm
21
Building Custom Tables

• Create Header Table
• Create Line Item Table
• Create Maintainable Views for Header Items
• SE54 - Extended Table Maintenance for Views
• Program Activate Event User Exits
• Data validations
• SE54 - Create View Cluster
• SM34 - Maintain View Cluster
• SF8 View Cluster name is ZSDBLINE_VC

22
Create Header Table
Client
Search help can beattached to Field or Field type
Custom field type allows custom documentation
23
Custom Search Help
Defined in Data type
24
Custom Field Documentation
Defined in Data type
25
Create Line Item Table
26
Create Maintainable View
Not the default!
27
View Fields
28
Extended Table Maintenance

• SE54 - Generated Objects

Maintainable View
29
Create an Include via SE38
30
Modify Function Pool
SAPLfunction_group
Uncomment
31
Modify Lfunction_groupFXX
SE80 - Function group
32
Events

• SE54 -gt Environment -gt Events

33
Create View Cluster

• SE54 -gt Edit viewcluster

34
Object structure
35
Generated Field Dependences
Header - ZSDBHEAD_V
36
Generated Field Dependences
Header - ZSDBLINE_V
37
View Cluster - Line Items SM34
Header
Line Items
38
Summary

• Know your program driver
• Find the One in the application data model
• Filter the data early in the program
• Know the indexes available in an area
• If you cant use the primary index there are
  usually other indexes
• Use the SAP supplied tools when possible

39
Where to Get More Information

• BC430 ABAP Dictionary
• Tomorrow in Waltham (11/14 - 11/15)
• January 9 - 10, 2003 Waltham
• My personal favorite, the book
• Object-Oriented Systems Analysis - Modeling the
  World of Data by Sally Shlaer Stephen Mello
• Available, used on www.amazon.com