topic Re: how to change internal table structure dynamically in Application Development and Automation Discussions

how to change internal table structure dynamically

Former Member — Thu, 06 Sep 2012 07:52:01 GMT

Hi Experts,

i am getting all openitems using BAPI_AR_ACC_GETOPENITEMS into my final internal table final data i am uploading into AL11 (application server )

but they don't want all the field they want field according to layout setting they will maintain in T Code FBL5N field can be different every time.

How to change the structure of internal table based on layout setting?

Re: how to change internal table structure dynamically

gouravkumar64 — Thu, 06 Sep 2012 08:39:04 GMT

Hi,

I think this will works

1)For custom field catalog use GET_FRONTEND_FIELDCATALOG,

2)loop with in it,check no_out field equal to 'X' or not,

3)Copy or create to new field catalog ,

4)For generate dynamic table CL_ALV_TABLE_CREATE,

5)loop through output table and copy required fields to dynamic table appending to it,

6)Then gui_download like this

CALL FUNCTION 'GUI_DOWNLOAD'
   EXPORTING
     filename                        = lv_file
    FILETYPE                        = 'DAT'
   tables
     data_tab                        = it_mbew " it is generic.

Thanks

Gourav.

Re: how to change internal table structure dynamically

Former Member — Thu, 06 Sep 2012 08:39:29 GMT

You can use the class CL_ABAP_ELEMDESCR, CL_ABAP_STRUCTDESCR and

CL_ABAP_TABLEDESCR.

The first two are to generate the structure, the last one to create the internal table.

I suppose it can find out many samples in SCN

Max

Re: how to change internal table structure dynamically

Former Member — Thu, 06 Sep 2012 09:31:32 GMT

Hi Max,

thanks but its depend on the individual login they will set the layout in fbl5n ,according to layout setting my data will be upload into AL11 file. Example some time they will display only 3 field in fbl5n output some time they want 10 like this.

Re: how to change internal table structure dynamically

Former Member — Thu, 06 Sep 2012 09:51:23 GMT

Yes

I've understood that, the first problem is to know how you manage the download (It's not clear if you want to download the data into application server or to upload the data from application server).

Because here you need to know the ALV layout to be used, and it's not clear the logic you want to use

Max

Re: how to change internal table structure dynamically

Former Member — Thu, 06 Sep 2012 10:08:30 GMT

Max i don't want to download the data into application server i created one program that program will upload the data into AL11 automatically every day i am using open, dataset they will run into background mode. they can change the layout in fbl5n according to the current layout my program should upload only those field what ever they set into fbl5n layout.

Re: how to change internal table structure dynamically

Former Member — Thu, 06 Sep 2012 10:17:05 GMT

So who downloads the data?

Re: how to change internal table structure dynamically

Former Member — Mon, 10 Sep 2012 06:23:57 GMT

Hi,

In standalon program you can not change the structure dynamically coz to upload the data into al11 you need to convert all field into char ask them to give field what they want.

Thanks

Rohan