SAP Blog

Search This Blog

Screen variant

September 05, 2018

Get link
Facebook
X
Pinterest
Email
Other Apps

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

ALV program

Demo program: - CL_GUI_ALV_GRID + REUSE...: package SLIS - CL_SALV_TABLE: package SALV_OM_OBJECTS - CL_SALV_GUI_TABLE_IDA: package SALV_IDA_TEST Program: TABLES sscrfields . SELECTION-SCREEN : PUSHBUTTON 2 ( 10 ) but1 USER-COMMAND cli1 , PUSHBUTTON 15 ( 10 ) but2 USER-COMMAND cli2 , PUSHBUTTON 28 ( 10 ) but3 USER-COMMAND cli3 , PUSHBUTTON 41 ( 10 ) but4 USER-COMMAND cli4 . TYPES BEGIN OF ty . INCLUDE TYPE sbook . TYPES test TYPE c LENGTH 10 . TYPES icon TYPE c . TYPES cbox TYPE c . TYPES r_color TYPE c LENGTH 4 . TYPES END OF ty . DATA : grid TYPE REF ...

Xuất dữ liệu từ SAP sang excel (xslx) - 1

- Trong cac du an SAP khi co nhu cau ve viec xuat du lieu tu SAP ra dinh dang excel, thong thuong chung ta co the thong qua tcode SE11, SE16...de load du lieu roi su dung tinh nang 'Export to spreedsheet' co san cua cac tcode nay de xuat ra excel. Ngoai ra cung co kha nhieu cac chuong trinh phat trien cua cong dong ABAPer, dac biet la bo ung dung ABAP2XLSX co the thuc hien hau nhu moi yeu cau khi lam viec voi excel. - Nhuoc diem cua viec thuc hien qua SE11 la khi phai thao tac voi nhieu bang hoac bang co nhieu du lieu thi kha ton thao tac va mat nhieu thoi gian cho doi; ABAP2XLSX doi hoi ban su dung SAPLINK de cai dat va tao ra kha nhieu object ma co the se kho duoc chap nhan o cac he thong yeu cau bao mat cao. Duoi day toi xin dua ra giai phap xuat du lieu mot cach don gian, su dung cac class chuan cua ALV ma ban co the su dung bat cu luc nao. - Chuong trinh nay co the viet duoi dang function mod...

xlsx2abap - ooxml

*--------------------------------------------------------------------* "1) ideal: OOXML Office " Since office 2007, XSLX is default extension for excel and in reality " this extension just a compressed archive of XML text documents. " workbook, sheets, data, shape...all are save in various xml file which " you can easy see by change any extension of excel file from xlsx to zip " With this new formation, also SAP provide a package S_OOXML_CORE to work " with all kind of OOXML ( excel, ppt, word, zip) from version NW 702 " we can find a new way to read/write...

Powered by Blogger

Screen variant

Comments

Post a Comment