topic Passing data to custom table dynamically in Application Development and Automation Discussions

Passing data to custom table dynamically

Former Member — Fri, 21 Dec 2018 16:12:32 GMT

I have uploaded a excel file using CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'. The internal table obtained from the above function is stored in t_upload.

data: t_upload type table of ZZTEST.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
EXPORTING
* I_FIELD_SEPERATOR =
I_LINE_HEADER = 'X'
i_tab_raw_data = it_type
i_filename = file_nam
TABLES
i_tab_converted_data = t_upload[]
EXCEPTIONS
conversion_failed = 1
OTHERS = 2.

For each record in the t_upload i have to create 365 records dynamically(for 365 different days) .

How to store records dynamically in custom table 'ZZTEST'?

Re: Passing data to custom table dynamically

Domi — Sat, 22 Dec 2018 15:20:12 GMT

just

- loop over your t_upload table

- DO 365 TIMES

- build your "Date Key" and set the data fields

- append to ITab ( with ZZTEST structure)

- INSET/MODIFY ZZTEST from ITab

- clear Itab

Done!

Maybe there is some more complex "Date Key" calculation needed (eg leap-year,...) and you need to think about update/changes of existing records, but that's the basic coding structure

Regards

Domi

Re: Passing data to custom table dynamically

Former Member — Tue, 25 Dec 2018 08:20:19 GMT

Bt i need to do it dynamically. Custom or the database table needs to be updated dynamically.

Re: Passing data to custom table dynamically

Domi — Tue, 25 Dec 2018 09:07:28 GMT

same thing!

https://help.sap.com/saphelp_nw70ehp1/helpdata/en/fc/eb3923358411d1829f0000e829fbfe/content.htm?no_cache=true

https://help.sap.com/doc/abapdocu_750_index_htm/7.50/de-DE/abapupdate_target.htm#!ABAP_ALTERNATIVE_2@2@

https://help.sap.com/doc/abapdocu_750_index_htm/7.50/de-DE/abapupdate_source.htm#!ABAP_ALTERNATIVE_3@3@

regards

Domi