' forward slash / is considered COMMENT in SQL REPLACE ALL OCCURRENCES OF '/' IN WA_FCAT-FIELDNAME WITH '_'.

LOOP AT SALV_META-T_FCAT INTO DATA(WA_FCAT). So I had to write a logic to create different Data type fields in SQL, to be used in CREATE TABLE Native SQL statement dynamically. I have also fetched the ALV Metadata because I need Field Catalog of the SUBMIT program in order to create our DB Table fields Create Table in MS SQL DB according to Report fields I have used the formidable CL_SALV_BS_RUNTIME_INFO class to extract ALV Data from the SUBMIT program 2. Create a Program to fetch data from SAP Report using SUBMIT REPORT ZSCHEDULE.ĬL_SALV_BS_RUNTIME_INFO=>SET( DISPLAY = ABAP_FALSEĭATA(SALV_META) = CL_SALV_BS_RUNTIME_INFO=>GET_METADATA( ).ĬL_SALV_BS_RUNTIME_INFO=>GET_DATA_REF( IMPORTING R_DATA = DATA(SALV_DATA) ). Create Table in MS SQL DB according to Report fieldsġ.Create a Program to fetch data from SAP Report using SUBMIT.So lets start the code with the following objectives: Recently I had a task to Push Data from SAP Reports to MS SQL DB, periodically, and to Create Tables of the required Reports in their MS SQL DB, as wellīeing a complete novice ABAP developer, I learned about ABAP DB Connectivity (ADBC) DDL and DML methods, which helped me complete the task more dynamically, instead of using EXEC SQL with Placeholders ? for each fieldīefore moving forward I would like to state the obvious that by no means my approach is best/optimal out there

Table plus create database