Skip to Content
0

how to execute multiple insert statement from a table

Jul 01, 2017 at 05:34 AM

44

avatar image

Hi Experts, How to execute multiple insert statements from table in sap bods I have source table like below. I need to execute Query column insert statement.

db_name table_name load_date Query

EDW_TARGET_DEV PRODUCT_DIM 2017/30/06 insert into target table select * from A

EDW_TARGET_DEV CUSTOMER_DIM 2017/30/06 insert into target table select * from B

EDW_TARGET_DEV EMPLOYEE_DIM 2017/30/06 insert into target table select * from C

EDW_TARGET_DEV TIME_DIM 2017/30/06 insert into target table select * from D

EDW_TARGET_DEV PURCHAGE 2017/30/06 insert into target table select * from E

EDW_TARGET_DEV FINACIAL_DIM 2017/30/06 insert into target table select * from F

EDW_TARGET_DEV PROJECT 2017/30/06 insert into target table select * from G

Thanks Murali

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers