Transfer internal table data into PC file using class CL_GUI_FRONTEND_SERVICES

Scenario: Need to tansfer internal table data into  PC file or desktop file using class CL_GUI_FRONTEND_SERVICES in ABAP

Solution: check the code below

tables: lfa1.

types: begin of ty_lfa1,
       lifnr(10) type c,
       name1(35) type C,
       land1(2) type c,
       end of ty_lfa1.


Data: it_data type standard table of ty_lfa1.
data: wa_data type ty_lfa1.
data: v_filename type string,
      v_path     type string,
      v_fullpath type string,
      v_action   type I.
select-options: s_lfa1 for lfa1-lifnr.

select lifnr name1 land1 from lfa1 into corresponding fields of table it_data where lifnr in s_lfa1.

** calling window to enter file name and path
call method CL_GUI_FRONTEND_SERVICES=>FILE_SAVE_DIALOG
            exporting
              window_title      = 'Testing GUI'
              default_extension = 'txt'
              default_file_name  = 'Test file'
            changing
              filename          = v_filename
              path              = v_path
              fullpath          = v_fullpath
              user_action       = v_action.
if v_action = 0.

** Downloading data into specified file.

call method CL_GUI_FRONTEND_SERVICES=>GUI_DOWNLOAD
            exporting
              FILENAME   = v_filename
            changing
              data_tab   = it_data.
else.
  write: 'No'.
endif.

Comments

Post a Comment

Popular posts from this blog

Add additional fields in VA05 report

Example: Add RAN number in VA05 report Adding fields in Selection screen:  Use enhancement spot in program "SD_SALES_DOCUMENT_VIEW". enhancement - point sd_sales_document_view_ep_int1  spots  es_sd_sales_document_view  . *$*$-Start: SD_SALES_DOCUMENT_VIEW_EP_INT1---------------$*$* ENHANCEMENT  1   ZENH .     "active version selection-screen  begin  of  block  sch1  with  frame  title  text - SCH . select-options :   skannr  for  vbap - kannr . selection-screen  end  of  block  sch1 . ENDENHANCEMENT . Selection parameter into select list    enhancement - point sd_sales_document_view_ep_int2  spots  es_sd_sales_document_view  . *$*$-Start: SD_SALES_DOCUMENT_VIEW_EP_INT2--------------$*$* ENHANCEMENT  2   ZENH .     "active version *INSERT LINES OF skannr INTO TABLE gs_selcrit-kannr.   transfer_select_option  'VBAP'  'KANNR'  SKANNR . ENDENHANCEMENT . Adding field in the output list.  Implement BADI: "BADI_SDOC_WRAPPER" Use method "ADAPT
Read more

Totals table for ACDOCA in S/4 HANA - ACDOCT

In old classical legder SAP provided GLT0 table for totals. In new GL SAP provided FAGLFLEXT table for totals. In S/4 HANA SAP has provided ACDOCT view for totals. (ACDOCT_BCK is a table). ACDOCT is a CDS view not a table. This view will be useful to find out totals per period and with some standard fields. This can be used in Report writer/painter also. But in S/4 Hana SAP not suggesting to use Report Writer/Painter tool. Most of the times SAP customers enhance Accounting document with custom fields. So custom fields can be added into ACDOCA table but it will not added to ACDOCT (Since it is view). what if customer needs total values including custom fields what to do then ? For this purpose either extend ACDOCT view or write sum logic using ACDOCA table. Writing logic with ACDOCA in each program means need to repeat same code many programs and also it is not code-pushdown approach. So better solution is either extend ACDOCT CDS view or create custom CDS view like ACDOCT.
Read more

FAGLL03 / FBL1N / FBL3N / FBL5N not showing custom fields

For T-code: FBL1N/FBL3N/FBL5N Execute the report RFPOSXEXTEND with T-code: SE38 in your system. Table T021S and structure RFPOSXEXT are able to synchronize. For T-code: FAGLL03Call T-code: SE37, enter the function module ITEM_STRUC_EXTENSION and execute it with the following parameters: BASIC_STRUCNAME FAGLPOSY EXT_STRUCNAME FAGLPOSYEXT EXT_FIELDS_TABNAME T021S I_LSTCL D X_TRANSPORT ' ' After you have executed the function module, the related structure FAGLPOSYEXT should be regenerated correctly. In addition, start the BALVBUFDEL report when you enhance the special fields
Read more