SAP ABAP Problems & Solution

Select with Joins in SAP ABAP: SELECT WITH JOINS statement is used to read data simultaneously from multiple database tables. For more than 3 tables is not advisable to join using select with join , because its create heavy load on database. Select with joins look like: Select  table_name~field             table_name2~field             table_name3~field into table IT_tablename (Internal table) from table_name inner join table_name on table_name~field = table_name2~field inner join  table_name2 on table_name2~field = table_name3~field.