1 / 18

MINS298c

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.

daktari
Download Presentation

MINS298c

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MINS298c Fall 1998 Three Levels of ABAP Dictionary Chapter 5 & 6

  2. 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

  3. Three Levels of Dictionary F1 F2 F1 F2 F1 F2 Structure F1 F2 F1 F2 Data Element Domain

  4. Three Levels of Dictionary F150 F150 camper Camaro Structure trucks cars Data Element 4 wheel automobiles Domain

  5. 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

  6. Methods to View Hierarchy • Object Browser • design • analysis • Editor • debugging • programming • Basic Process • identify table/structure • drill down

  7. At Table/Structure Level • Field name • Key • Data Element • Type - determined by Domain • Length - determined by Domain • Checktable • Text

  8. At Data Element Level • Domain • Data Type • Field Length • Value Table (allowable values) • Texts

  9. 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?

  10. 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 *

  11. 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

  12. Heads Up on Table Processing • Basic Process • Create Table • Identify those needed • Identify structure • Load Table • Get Data from database • Process data • Display

  13. 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?

  14. 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

  15. 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?

  16. 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.

  17. 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

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

More Related