To read data from a database tables we use logical database. A logical database provides read-only access to a group of related tables to an ABAP/4 program. Advantages: i)check functions which check that user input is complete, correct,and plausible. ii)Meaningful data selection. iii)central authorization checks for database accesses. iv)good read access performance while retaining the … Read more
First construct the logical database and generation of query report is as follows. The transaction codes used in Query reports are: 1. SQ01 – For creating Query. 2. SQ02 – For creating Infoset. 3. SQ03 – For creating User. First u need to create the USER and generate the INFOSET, in turn can produce theQuery … Read more
Goto the transaction code SE36 ( Logical database Builder) and enter the logical database name and click on the CREATE button.We need to have structure, selections and source code. Enter the short text and click on the CREATE button. In order to create the structure, Enter the short text for the root node and the … Read more
REPORT ZKA_REPORT MESSAGE-ID ZKA LINE-SIZE 255 LINE-COUNT 10(2). TABLES: ZKA_EMP,ZKA_COM. DATA: ITAB LIKE ZKA_EMP OCCURS 0 WITH HEADER LINE. DATA: JTAB LIKE ZKA_COM OCCURS 0 WITH HEADER LINE. SELECT-OPTIONS: EMP_NO FOR ZKA_EMP-EMPNO. SET PF-STATUS ‘ZKA_MENU’. INITIALIZATION. EMP_NO-LOW = ‘1’. EMP_NO-HIGH = ’10’. EMP_NO-SIGN = ‘I’. EMP_NO-OPTION = ‘BT’. APPEND EMP_NO. CLEAR EMP_NO. AT SELECTION-SCREEN. IF … Read more
The Logical Database Builder then saves you work by using components that you have already defined to generate proposals for other components. Some of the most important attributes of a logical database are set when you define its structure. When you have defined the structure, the Logical Database Builder automatically generates a proposal for the … Read more