mins298c n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
MINS298c PowerPoint Presentation
Download Presentation
MINS298c

Loading in 2 Seconds...

play fullscreen
1 / 18

MINS298c - PowerPoint PPT Presentation


  • 102 Views
  • Uploaded on

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.

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

PowerPoint Slideshow about 'MINS298c' - daktari


An Image/Link below is provided (as is) to download presentation

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

MINS298c

Fall 1998

Three Levels of ABAP Dictionary

Chapter 5 & 6

overview
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
Three Levels of Dictionary

F1 F2

F1 F2

F1 F2

Structure

F1 F2

F1 F2

Data Element

Domain

three levels of dictionary1
Three Levels of Dictionary

F150

F150

camper

Camaro

Structure

trucks

cars

Data Element

4 wheel

automobiles

Domain

definition of levels
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
Methods to View Hierarchy
  • Object Browser
    • design
    • analysis
  • Editor
    • debugging
    • programming
  • Basic Process
    • identify table/structure
    • drill down
at table structure level
At Table/Structure Level
  • Field name
  • Key
  • Data Element
  • Type - determined by Domain
  • Length - determined by Domain
  • Checktable
  • Text
at data element level
At Data Element Level
  • Domain
  • Data Type
  • Field Length
  • Value Table (allowable values)
  • Texts
in class assignment write down the answers don t yell out
In Class Assignment Write down the answers; Don’t yell out.
  • 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
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 *
in class assignment write down the answers don t yell out1
In Class Assignment Write down the answers; Don’t yell out.
  • 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

heads up on table processing
Heads Up on Table Processing
  • Basic Process
    • Create Table
      • Identify those needed
      • Identify structure
    • Load Table
      • Get Data from database
      • Process data
    • Display
heads up on table processing1
Heads up on Table Processing

Internal Table (no data yet)

Database Table (with data)

MY_TABLE

SFLIGHT

How do I make

sure data will fit in

MY_TABLE?

heads up on table processing2
Heads up on Table Processing

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

heads up on table processing3
Heads up on Table Processing

Internal Table (no data yet)

Database Table (with data)

MY_TABLE

SFLIGHT

How do I get the

data into MY_TABLE?

heads up on table processing4
Heads up on Table Processing

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.

heads up on table processing5
Heads up on Table Processing

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
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)