Posts

Showing posts with the label Select with Joins in SAP ABAP

Using BAPI upload excel file for t-code AS02 in SAP

Using BAPI " BAPI_FIXEDASSET_CHANGE " create a zprogram to upload excel file for mass change fixed asset in SAP. REPORT  ZAS02_ASSET_CHANGE_UPLOAD . TYPE-POOLS :  truxs . " Structure for Excel data TYPES :  BEGIN  OF  ty_excel ,          anln1  TYPE  anln1 ,          bukrs  TYPE  bukrs ,          kostl  TYPE  kostl ,          werks  TYPE  werks ,          prctr  TYPE  prctr ,         END  OF  ty_excel . DATA :  lt_excel     TYPE  TABLE  OF  ty_excel ,       ls_excel     TYPE  ty_excel ,     ...
Post a Comment
Read more

Select with Joins in SAP ABAP

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.
Post a Comment
Read more