ABAP y SAP

  Objective: Prepare excel from code and format excel column as ‘TEXT’. Example, 0001 will be saved as 0001 and not 1. The code mentioned in this document   is cross – country  with no language dependency and independent of excel properties across country. Manual step for text formatting  of a column in  excel.       Automation of  excel column  formatting as te xt via code. When we create excel via code and want to have value in any of the column as “TEXT” format. Below code will help to format cell as text. DATA: ls_attach     TYPE solisti1, ls_email         TYPE /dpm/a_pls_email, lt_email         TYPE /dpm/tt_pls_email, ls_final_email   TYPE /dpm/a_pls_email, lv_tab           TYPE c, lv_cret    ...

 WEB with a lot of tutorials https://www.guru99.com https://www.kodyaz.com/articles/default.aspx https://www.samplecodeabap.com/ Referencia ABAP 7.4 https://community.sap.com/t5/technology-blogs-by-members/abap-7-40-quick-reference/ba-p/13287523

How to find which Transaction code that is replaced by a new Transaction code in SAP S/4 HANA? Introduction Everyone will move to SAP S/4 HANA someday. It is very important to know which are the Transaction Codes that are replaced with new Transaction Codes. This will be very important so that you can plan from now to use the Updated Transaction Codes.It is very important for SAP Consultant to know which are the Transaction Codes that are Replaced so that they can plan their Migration efficiently,   Solution How to find which Transaction code that is replaced by a new Transaction code in SAP S/4 HANA? Go to  Transaction Code SE16-> Enter table PRGN_CORR2 Now enter REL_NAME Field as 751 like below and Execute Wala now you get the list.The  S_TCODE is Replaced by T_TCODE Column or field value Conclusion   This Tutorial will be very beneficial for every Consultant that are moving to SAP S/4 HANA. Fuente: https://blogs.sap.com/2020/07/15/how-to-find-which-transaction-...

REPORT yvpn. DATA: l_cont TYPE i,       l_texto(80),       l_hora(8),       l_tiempo(8),       l_horaini LIKE sy-uzeit,       l_difhora LIKE sy-uzeit. l_horaini = sy-uzeit. DO.   l_difhora = sy-uzeit – l_horaini.   WRITE l_difhora TO l_tiempo.   WRITE sy-uzeit TO l_hora.   WRITE sy-index TO l_texto(5).   concatenate l_texto(5) ‘Hora:’ l_hora ‘Tiempo transcurrido’ l_tiempo               into l_texto separated by space.   CALL FUNCTION ‘SAPGUI_PROGRESS_INDICATOR’        EXPORTING             text   = l_texto        EXCEPTIONS             OTHERS = 1.   WAIT UP TO 30 SECONDS.   COMMI...

TYPE-POOLS ole2 . DATA : wf_cell_from TYPE ole2_object , wf_cell_from1 TYPE ole2_object , wf_cell_to TYPE ole2_object , wf_cell_to1 TYPE ole2_object , wf_excel TYPE ole2_object , " Excel object wf_mapl TYPE ole2_object , " list of workbooks wf_map TYPE ole2_object , " workbook wf_worksheet TYPE ole2_object , " Worksheet wf_cell TYPE ole2_object , " Cell Range wf_cell1 TYPE ole2_object , wf_range TYPE ole2_object , " Range of cells to be formatted wf_range2 TYPE ole2_object , wf_column1 TYPE ole2_object . " Column to be Autofit DATA : BEGIN OF t_hex , l_tab TYPE x, END OF t_hex . DATA : wf_deli ( 1 ) TYPE c, "delimiter wf_action TYPE i, wf_file TYPE string, wf_path TYPE string, wf_fullpath TYPE string. TYPE...