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 »
In addition to the primary database, other databases can be accessed using secondary database connections. Using Open-SQL: The keyword ‚CONNECTION’ and the database connection name is specified in the query. The connections are maintained in the Transaction ‘DBA COCKPIT’. Syntax: SELECT ….. FROM db_table CONNECTION connection_name INTO …. Example: The Secondary Database name is secondary_db …
How to create Secondary Database connections in SAP ABAP Read More »
Using the MODIFY statement, we can modify the existing records in a Database table. If the records does not exist in a Database table, then it can insert records in to Database table. This can be achieved in the following two ways. Through Structure. Through Internal table. Structure It is used to modify a single …
How to use MODIFY to modify or insert records in Database table in SAP ABAP Read More »