Posts

Simple Function Module with Simple Parameters

Here is the use of Function Module with simple parameters Calling Function Module in program *&---------------------------------------------------------------------* *& Report  ZFUNMOD1                                                    * *&                                                                     * *&-----------------------------------------------------------------...

Using GUI Upload to upload file in SAP ABAP

Here is the use of GUI Upload Function Module... Uploading a file using SAP ABAP programming using SAP Function Module GUI_DOWNLOAD. REPORT ZGUI_UPLOAD2 NO STANDARD PAGE HEADING. DATA: BEGIN OF ITAB OCCURS 1, LINE(255) TYPE C, END OF ITAB. DATA: V_FILE TYPE STRING. PARAMETERS: P_FILE LIKE RLGRAP-FILENAME DEFAULT 'C:\Documents and Settings\Administrator\Desktop\ZCALL_TRAN_XD01.TXT'. V_FILE = P_FILE. CALL FUNCTION 'GUI_UPLOAD' EXPORTING FILENAME = V_FILE FILETYPE = 'ASC' TABLES DATA_TAB = ITAB EXCEPTIONS FILE_OPEN_ERROR = 1 FILE_READ_ERROR = 2 NO_BATCH = 3 GUI_REFUSE_FILETRANSFER = 4 INVALID_TYPE = 5 NO_AUTHORITY = 6 UNKNOWN_ERROR = 7 BAD_DATA_FORMAT = 8 HEADER_NOT_ALLOWED = 9 SEPARATOR_...

Using GUI Upload in SAP ABAP

GUI Upload is a Function Module which is used upload a file using SAP ABAP, by using GUI Upload we can upload excel, txt etc files. The below is the example of using GUI Upload . REPORT ZGUI_UPLOAD . DATA: ITAB LIKE ZSTUDENT OCCURS 1 WITH HEADER LINE. CALL FUNCTION 'GUI_UPLOAD' EXPORTING FILENAME = 'C:\Documents and Settings\Administrator\Desktop\STUD.TXT' * FILETYPE = 'ASC' HAS_FIELD_SEPARATOR = 'X' * HEADER_LENGTH = 0 * READ_BY_LINE = 'X' * DAT_MODE = ' ' * IMPORTING * FILELENGTH = * HEADER = TABLES DATA_TAB = ITAB EXCEPTIONS FILE_OPEN_ERROR = 1 FILE_READ_ERROR = 2 NO_BATCH = 3 GUI_REFUSE_FILETRANSFER = 4 INVALID_TYP...

Using of GUI Download in SAP ABAP

GUI Download is a Function Module which is used to download data into a file from SAP GUI, GUI Download works only for SAP GUI and will not work for SAP Web Technologies like web dynpro for ABAP. The below is the example program for downloading data from MARA table.(MARA contains huge data . REPORT ZGUI_DOWNLOAD DATA: ITAB LIKE MARA OCCURS 1 WITH HEADER LINE. DATA: V_FILELEN TYPE I. SELECT * FROM MARA INTO TABLE ITAB. CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING FILENAME = 'C:\DOWNLOADED.txt' FILETYPE = 'ASC' * APPEND = 'X' WRITE_FIELD_SEPARATOR = 'X' IMPORTING * FILELENGTH = V_FILELEN TABLES DATA_TAB = ITAB EXCEPTIONS FILE_WRITE_ERROR = 1 NO_BATCH = 2 GUI_REFUSE_FILETRANSFER = 3 INVALID_TYPE = 4 NO_AUTHORITY ...

Parameters and select-options in SAP ABAP

Parameters and Select-Options are selection-screen elements in SAP ABAP, which are used to provide inputs fields on selection-screens. The below is the example program of using parameters and select-options in SAP ABAP programming. REPORT  ZSELECT_OPTIONS1                        . DATA: ITAB LIKE MARD OCCURS 1 WITH HEADER LINE. SELECT-OPTIONS: S_MATNR FOR ITAB-MATNR. LOOP AT S_MATNR.   WRITE:/ S_MATNR-SIGN,           S_MATNR-OPTION,           S_MATNR-LOW,           S_MATNR-HIGH. ENDLOOP. REPORT  ZSELECT_OPTIONS2. DATA: ITAB LIKE MARD OCCURS 1 WITH HEADER LINE. SELECT-OPTIONS: S_MATNR FOR ITAB-MATNR. SELECT *   FROM MARD   INTO TABLE ITAB   WHERE MATNR IN S_MATNR. LOOP AT ITAB. ...

Select Statements in SAP ABAP

Select statements are used to read data from database table using SAP ABAP programming in SAP, there are different types of select statements in SAP ABAP to read data from database, the below are some of the select statements with examples. 1.Select Single: REPORT ZSELECT_SINGLE . TABLES: MARA. SELECT SINGLE * FROM MARA WHERE MATNR = '100-100'. WRITE:/ MARA-MATNR, MARA-MATKL, MARA-MTART. 2.Select Up To : REPORT ZSELECT_UPTO . TABLES: MARD. SELECT * FROM MARD UP TO 1 ROWS WHERE MATNR = '100-100'. WRITE:/ MARD-MATNR, MARD-WERKS, MARD-LGORT, MARD-LABST. 3.Select Where : REPORT ZSELECT_WHERE . TABLES: ZSTUDENT. SELECT * FROM ZSTUDENT * WHERE AGE = 20. * WHERE AGE <> 20. * WHERE AGE >= 20 AND CLASS <= 40. * WHERE FNAME = 'ABC' OR LNAME = 'AAA'. * WHERE NOT AGE = 20. ...

Important System Variables in SAP ABAP

Here are the list of some important System Fields or System Variables used in ABAP Programming, I suggest you to copy and paste the below code in your Program to know the functionality of the fields.... REPORT  ZSYS_FIELDS NO STANDARD PAGE HEADING. WRITE:/ 'SY-SUBRC:', SY-SUBRC,       / 'SY-MANDT:', SY-MANDT,       / 'SY-UNAME:', SY-UNAME,       / 'SY-INDEX:', SY-INDEX,       / 'SY-TABIX:', SY-TABIX,       / 'SY-DATUM:', SY-DATUM,       / 'SY-UZEIT:', SY-UZEIT,       / 'SY-FDPOS:', SY-FDPOS,       / 'SY-DBCNT:', SY-DBCNT,       / 'SY-COLNO:', SY-COLNO,       / 'SY-VLINE:', SY-VLINE,       / 'SY-ULINE:', SY-ULINE,       / 'SY-LINNO:', SY-LINNO,     ...