Nested INNER JOIN Statements May be Ineffective or inefficient | SAP Programming | ABAP

"Using several nested INNER JOIN statements can be inefficient and cause time out if the tables become too big in the future." Joins here (in ABAP) are not those Native SQL Joins.  If you are talking about the Core RDBMS, which mean Oracle or SQL Server, then Undoubtedly Joins are the best. In ABAP, these joins are first split by the ABAP processor...

read more...

Purpose of Using PACKAGE SIZE in Select Statement in SAP ABAP Programming

Package size can be used if you for example only want to finish processing a limited amount of data at a time due to lack of memory. The example below read 50 records at a time from VBAK into an internal table, and selects the corresponding entries from vbap into an internal table. Then the two internal tables can be processed, and the next 50 records...

read more...

Usage of 'for all entries' in Select Statement | SAP ABAP Programming

FORM data_retrieval. DATA: ld_color(1) TYPE c. DATA: BEGIN OF T_VBAP OCCURS 0, VBELN LIKE VBAP-VBELN, MATNR LIKE VBAP-MATNR, POSNR LIKE VBAP-POSNR, END OF T_VBAP. DATA: BEGIN OF T_VBFA OCCURS 0, VBELV LIKE VBFA-VBELV, VBELN LIKE VBFA-VBELN, VBTYP_N LIKE VBFA-VBTYP_N, END...

read more...