MINS298c

1 / 18

# MINS298c - PowerPoint PPT Presentation

MINS298c. Fall 1998 Three Levels of ABAP Dictionary Chapter 5 &amp; 6. Overview. Three conceptual levels Methods to observe the levels What is on the levels How to see the data in a Table Heads up on Table Processing ABAP examples. Three Levels of Dictionary. F1 F2. F1 F2. F1 F2.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about 'MINS298c' - daktari

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

### MINS298c

Fall 1998

Three Levels of ABAP Dictionary

Chapter 5 & 6

Overview
• Three conceptual levels
• Methods to observe the levels
• What is on the levels
• How to see the data in a Table
• Heads up on Table Processing
• ABAP examples
Three Levels of Dictionary

F1 F2

F1 F2

F1 F2

Structure

F1 F2

F1 F2

Data Element

Domain

Three Levels of Dictionary

F150

F150

camper

Camaro

Structure

trucks

cars

Data Element

4 wheel

automobiles

Domain

Definition of Levels
• Domain: Range of values of a certain type and length that can be used by many data elements. Example VIN# is 11 character numeric.
• Data Element: Attribute or field that is defined by a domain. Example: Trade-in_Vin#, NewCar_Vin#
• Table: Collection of related Data Elements and their values (Set of related records) Example: Car Sales Order
• Structure: Like a sub-schema or view of the data (collection of data elements that may not be related through tables) Example: CCSS
Methods to View Hierarchy
• Object Browser
• design
• analysis
• Editor
• debugging
• programming
• Basic Process
• identify table/structure
• drill down
At Table/Structure Level
• Field name
• Key
• Data Element
• Type - determined by Domain
• Length - determined by Domain
• Checktable
• Text
At Data Element Level
• Domain
• Data Type
• Field Length
• Value Table (allowable values)
• Texts
• With regard to the Table SBOOK,
• SBOOK’s structure contains how many fields?
• How many key fields does SBOOK have?
• What is the name, domain, data type and long field name of the last field in SBOOK?
How to see the data in a Table
• Object Browser
• use selection screen to pick a Table (structure)
• Use “Utility > Table Contents”
• Select fields (note selection fields)
• can filter data
• can sort data
• ABAP code
• select *
• With regard to the Table SBOOK,
• Determine the number of records in the database
• The number of records with connecting identification numbers between 400 and 500
• Is the default inclusive or exclusive for the range delimiters (Does SAP include or exclude the limits of the range entered?)

Exclusive Inclusive

• Basic Process
• Create Table
• Identify those needed
• Identify structure
• Get Data from database
• Process data
• Display

Internal Table (no data yet)

Database Table (with data)

MY_TABLE

SFLIGHT

How do I make

sure data will fit in

MY_TABLE?

Internal Table (no data yet)

Database Table (with data)

MY_TABLE

SFLIGHT

How do I make

sure data will fit in

MY_TABLE?

Match the structures.

LIKE

Internal Table (no data yet)

Database Table (with data)

MY_TABLE

SFLIGHT

How do I get the

data into MY_TABLE?

Internal Table (no data yet)

Database Table (with data)

MY_TABLE

SFLIGHT

How do I get the

data into MY_TABLE?

Use SELECT verb:

SELECT *

FROM dbtable

INTO TABLE My_Table.

Internal Table (no data yet)

MY_TABLE

Once in My_Table, how

do I iterate to display it?

Use LOOP AT verb with

ENDLOOP.

Put actions you want done

in the loop between

LOOP AT and ENDLOOP.

LOOP AT itab.

Write data.

ENDLOOP.

LOOP At itab

}

ENDLOOP

Assignment #4
• On paper, create a hierarchy example using the three levels: Domain, Data Element, Structure. Be ready to explain on exam
• Copy ZZ99DEM2
• find the fields for ticket price and plane type in SFLIGHT
• add these fields to the display
• place headings at top of columns; use text elements (do not worry too much about alignment yet)