H_BLOG

*&---------------------------------------------------------------------* *& Report ZPOPENSQL_1 *&---------------------------------------------------------------------* *& *&---------------------------------------------------------------------* REPORT ZPOPENSQL_1. *SELECT *INSERT *UPDATE *MODIFY *DELETE TABLES ZEMPLOYEES. * This is a work area is like zemployees taking the same structure as our z..

*&---------------------------------------------------------------------* *& Report Z_OTHER_DATA_TYPES *&---------------------------------------------------------------------* *& *&---------------------------------------------------------------------* REPORT Z_OTHER_DATA_TYPES. * Date and Time Fields. *********************************************************************************** *Date ------..

*&---------------------------------------------------------------------* *& Report Z_CHARACTER_STRINGS *&---------------------------------------------------------------------* *& *&---------------------------------------------------------------------* REPORT Z_CHARACTER_STRINGS. TABLES ZEMPLOYEES. DATA MYCHAR(10) TYPE C. DATA MYCHAR2. " DEFAULT LENGTH OF CHAR IS . AND CHARACTER TYPE IS DEFAULT T..

*&---------------------------------------------------------------------* *& Report Z_EMPLOYEE_LIST_02 *&---------------------------------------------------------------------* *& *&---------------------------------------------------------------------* *LINE-SIZE: It determines how many columns to be displayed on the report page. * 132 characters are default. REPORT Z_EMPLOYEE_LIST_02. * Arithmeti..

* Variables ----------------------------------------------------------------- DATA INTEGER01 TYPE I. DATA PACKED_DECIMAL01 TYPE P DECIMALS 1. DATA PACKED_DECIMAL02 LIKE PACKED_DECIMAL01. * It enables to take the property of SURNAME field in ZEMPLOYEES to the NEW_SURNAME. DATA NEW_SURNAME LIKE ZEMPLOYEES-SURNAME. * Define initial value. DATA INTEGER02 TYPE I VALUE 22. DATA NEW_SURNAME02 LIKE ZEMP..