Posts

Showing posts with the label Select with Joins in SAP ABAP

BAPI for material storage location Add

 We can add material storage location plant wise using third party app or web. BAPI names : BAPI_MATERIAL_MAINTAINDATA_RT Import parameters: HEADDATA: Material Tables: STORAGELOCATIONDATA: Material: Plant: STGE_LOC:   STORAGELOCATIONDATAX: Material: Plant: STGE_LOC:   use below code after completing steps. CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'.        
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