SAP DEMO-ABAP Database Access

Open SQL

Read data

Individual Columns in One Line

REPORT demo_select_single .

 

         

Individual Columns of Several Lines

REPORT demo_select_some_columns.

 

         

Individual Columns of Serveral Lines

REPORT demo_select_all_columns.

 

         

Specifying Columns Dynamically

REPORT demo_select_dynamic_columns .

 

         

Internal Tables as Target Areas

REPORT demo_select_into_table .

 

         

Reading Packets into Tables

REPORT demo_select_into_package .

 

         

Single Fields as Target Area

REPORT demo_select_single_fields .

 

         

Using Alternative Names

REPORT demo_select_as .

 

         

Specifying the Source Statically

REPORT demo_select_static_database.

 

         

Specifying the Source Dynamically

REPORT demo_select_dynamic_database .

 

         

Inner Join

REPORT demo_select_inner_join.

 

         

Left Outer Join

REPORT demo_select_left_outer_join .

 

         

Dynamic Conditions

REPORT demo_select_dynamic_conditions .

 

         

FOR ALL ENTRIES Function

REPORT demo_select_for_all_entries_1.

 

         

FOR ALL ENTRIES, USE

REPORT demo_select_for_all_entries_2 .

 

         

Grouping Lines

REPORT demo_select_group_by .

 

         

Choosing Line Groups

REPORT demo_select_group_by_having .

 

         

Specifying the Sort Sequence

REPORT demo_select_order_by .

 

         

Correlated Non-Scalar Subsequeries

REPORT demo_select_subquery_1 .

 

         

Scalar Sbuquery with IN

REPORT demo_select_subquery_2 .

 

         

Scalar Subquery

REPORT demo_select_subquery_3.

 

         

Parallel Cursor

REPORT demo_select_cursor_1.

 

         

Cursor as Parameter

REPORT demo_select_cursor_2.

 

         

Cursor for Nested Database Access

REPORT demo_select_cursor_3.

 

         

Native SQL

Function Native SQL

REPORT demo_native_sql .

 

       

Logical databases

Calling LDBs Using a Function Module

REPORT demo_logical_database.

 

       

Contexts

Retrieving Data from Context Instances

REPORT  demo_context_demand.

 

       

Message Handling by System

REPORT  demo_context_message_1.

 

       

Message Handling by Program

REPORT  demo_context_message_2.

 

       

Message Handling by System

REPORT  demo_context_message_3.

 

       

Message Handling by Program

REPORT  demo_context_message_4.

 

       

SAP Transaction Concept

Setting and Releasing Locks

REPORT  demo_transaction_enqueue MESSAGE-ID sabapdocu.