The primary key fields of the data records must be unique. There should not be duplicate records in the Database table. The fields of the ALV List are editable through the field catalog. The primary key fields of the SAP ALV List cannot be edited directly. If a new line of record is inserted in […]
How to enable adding new records to the SAP ALV List Read More »
One of the key advantage of the old ALV Models is that it enables the user to edit the values in the table. There are two different ways to set the ALV column as editable. a) Field Catalog b) SET_READY_FOR_INPUT a) Field Catalog: The fields such as field name is used to set the column
How to set the column as editable in SAP ALV Grid Read More »
It is the only ALV variant which is editable. We need an internal table which is based on a global structure to show the data. There are two Display modes to display the data. Full screen display : The output of the ALV List occupies the whole screen. It does not contain Container and Dynpro.
How to create an ALV List based on class CL_GUI_ALV_GRID Read More »
Displaying Table contents is one of the important requirement in any application. ALV is the short form of ABAP List viewer. ALV is used to display the table of contents. It generally shows the data of the internal table. It can also be used to export data in to Excel file. REUSE_ALV_GRID_DISPLAY: It is based
What are the list of available models to program the SAP ALV Tables Read More »
PARAMETER INSTANCE VARIABLE STATIC VARIABLE Access The instance variable is accessed through the object of the class. An object must be created for the class in order to access the instance variable The static variable is accessed through the class name. Object is not needed to access the variable value. Lifetime Instance variables exists till
WHAT IS THE DIFFERENCE BETWEEN STATIC VARIABLE AND INSTANCE VARIABLE Read More »
Ztt_db_table2 is the table name PARAMETER OPEN-SQL – SELECT INTERNAL TABLE – READ, Table expressions, LOOP AT SINGLE RECORD SELECT SINGLE * FROM ztt_db_table2 INTO ls_contact a) READ TABLE lt_contact INDEX 1 INTO ls_contact. b) READ TABLE lt_contact WITH KEY contact_id = 101 INTO ls_contact. c) DATA lt_contact TYPE TABLE OF ztt_db_table2 WITH NON-UNIQUE KEY
How to compare OPEN-SQL – SELECT and INTERNAL TABLE READ Query Read More »
Ztt_db_table2 is the Database table name PARAMETER OPEN-SQL-INSERT INTERNAL TABLE-INSERT Structure i) INSERT ztt_db_table2 FROM ls_contactii) INSERT INTO ztt_db_table2 VALUES ls_contact i) APPEND ls_contact TO lt_contactii) INSERT ls_contact INTO TABLE lt_contactiii) INSERT ls_contact INTO lt_contact INDEX 1 Internal table i) INSERT INTO ztt_db_table2 FROM TABLE lt_internal_tableii) INSERT INTO ztt_db_table2 FROM TABLE lt_internal_table ACCEPTING DUPLICATE KEYS
How to compare OPEN-SQL INSERT and INTERNAL TABLE-INSERT Query Read More »
ztt_db_table2 is the Database table name Parameter OPEN-SQL MODIFY INTERNAL TABLE – MODIFY structure MODIFY ztt_db_table2 FROM ls_structure a) MODIFY lt_internal_table FROM ls_structure TRANSPORTING contact_address WHERE contact_id = 102b) MODIFY lt_internal_table FROM ls_structure INDEX 2 TRANSPORTING contact_name contact_address Internal table MODIFY ztt_db_table2 FROM TABLE lt_internal_table ——- Note: if the database table name and internal table
Difference between OPEN-SQL MODIFY and INTERNAL TABLE MODIFY Query Read More »
ztt_db_table2 is the Database table name Parameter OPEN-SQL – DELETE INTERNAL TABLE – DELETE WHERE DELETE FROM ztt_db_table2 WHERE contact_id = 102 DELETE lt_internal_table WHERE contact_id = 102. STRUCTURE DELETE ztt_db_table2 FROM ls_structure DELETE TABLE lt_internal_table FROM ls_structure INTERNAL TABLE DELETE ztt_db_table2 FROM TABLE lt_internal_table ——- INDEX ——- DELETE lt_internal_table INDEX 2.DELETE lt_internal_table FROM 2
Difference between Open-SQL DELETE and Internal table DELETE query Read More »
Output results must be minimum. Please try to use where, having constraints in the query to reduce the data records read from the Database table. Use SELECT colum1, column2 instead of SELECT *From. The performance will be better as only the important columns are selected in the query. Use Joins instead of writing multiple select
Five Important rules to improve the performance of Database access Read More »