Posts

Showing posts with the label ALV Reports

ALV with field catalog merge

Example ALV report with field catalog merge in SAP ABAP. REPORT ZALV_WITH_FCAT_MERGE. TYPE-POOLS SLIS . DATA : BEGIN OF I_MARA OCCURS 0, MATNR LIKE MARA-MATNR, MTART LIKE MARA-MTART, MBRSH LIKE MARA-MBRSH, MEINS LIKE MARA-MEINS, END OF I_MARA. DATA : I_FCAT TYPE SLIS_T_FIELDCAT_ALV . DATA : WA_FCAT LIKE LINE OF I_FCAT . START-OF-SELECTION . PERFORM GET_DATA . * PERFORM CREATE_FCAT. PERFORM CREATE_FCAT_MERGE . END-OF-SELECTION . PERFORM DISP_ALV . FORM GET_DATA . SELECT * FROM MARA INTO CORRESPONDING FIELDS OF TABLE I_MARA . ENDFORM. " GET_DATA FORM DISP_ALV . CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' EXPORTING I_CALLBACK_PROGRAM = SY-REPID IT_FIELDCAT = I_FCAT TABLES T_OUTTAB = I_MARA. ENDFORM. " DISP_ALV FORM CREATE_FCAT . WA_FCAT-COL_POS = '1' . WA_FCAT-FIELDNAME = 'MATNR' . WA_FCAT-TABNAME = ...

ALV Blocked list display in SAP ABAP

Example report for ALV blocked list display in SAP ABAP. REPORT ZALV_BLOCKED. TYPE-POOLS : SLIS . DATA: BEGIN OF I_MARA OCCURS 0, MATNR LIKE MARA-MATNR, MTART LIKE MARA-MTART, MBRSH LIKE MARA-MBRSH, END OF I_MARA. DATA: BEGIN OF I_MAKT OCCURS 0, MATNR LIKE MAKT-MATNR, SPRAS LIKE MAKT-SPRAS, MAKTX LIKE MAKT-MAKTX, END OF I_MAKT. DATA: BEGIN OF I_MARC OCCURS 0, MATNR LIKE MARC-MATNR, WERKS LIKE MARC-WERKS, BWTTY LIKE MARC-BWTTY, END OF I_MARC. DATA : WA_LAYOUT TYPE SLIS_LAYOUT_ALV . DATA : I_FCAT TYPE SLIS_T_FIELDCAT_ALV . DATA : I_EVENTS TYPE SLIS_T_EVENT . BREAK-POINT. START-OF-SELECTION . PERFORM INIT_BLOCKED_ALV . PERFORM APPEND_BLOCK1. PERFORM APPEND_BLOCK2. PERFORM APPEND_BLOCK3. PERFORM DISPLAY_BLOCKED_ALV . FORM INIT_BLOCKED_ALV . CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_INIT' EXPORTING I_CALLBACK_PROGRAM = SY-REPID. ENDFORM. " INIT_...

ALV report with totals and sub-totals in SAP ABAP

ALV report with totals and subtotals in SAP ABAP REPORT ZALV_WITH_TOTALS_SUBTOT. TYPE-POOLS SLIS . TYPES : BEGIN OF TY_VBAP, VBELN TYPE VBAP-VBELN, POSNR TYPE VBAP-POSNR, MATNR TYPE VBAP-MATNR, NETWR TYPE VBAP-NETWR, END OF TY_VBAP. DATA : I_VBAP TYPE TABLE OF TY_VBAP . DATA : WA_VBAP TYPE TY_VBAP . DATA : I_FCAT TYPE SLIS_T_FIELDCAT_ALV . DATA : WA_FCAT LIKE LINE OF I_FCAT . DATA : I_SORT TYPE SLIS_T_SORTINFO_ALV . DATA : WA_SORT LIKE LINE OF I_SORT . START-OF-SELECTION . PERFORM GET_DATA . PERFORM CREATE_FCAT. PERFORM CALC_SUBTOT. END-OF-SELECTION . PERFORM DISP_ALV . FORM GET_DATA . SELECT * FROM VBAP INTO CORRESPONDING FIELDS OF TABLE I_VBAP . ENDFORM. " GET_DATA FORM DISP_ALV . CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' EXPORTING * I_INTERFACE_CHECK = ' ' * I_BYPASSING_BUFFER = ' ' * I_BUFFER_ACTIVE = '...

Real-time ALV hierarchical list display in SAP ABAP

Example program to display hierarchical ALV report in SAP ABAP. REPORT ZALV_HIE . DATA: IT_VBRK LIKE VBRK OCCURS 1 WITH HEADER LINE. DATA: IT_VBRP LIKE VBRP OCCURS 1 WITH HEADER LINE. TYPE-POOLS: SLIS. DATA: WA_KEY TYPE SLIS_KEYINFO_ALV. SELECT-OPTIONS: S_VBELN FOR IT_VBRK-VBELN. START-OF-SELECTION. PERFORM GET_DATA. END-OF-SELECTION. PERFORM SHOW_HIRAR_GRID. FORM GET_DATA . SELECT * FROM VBRK INTO TABLE IT_VBRK WHERE VBELN IN S_VBELN. SELECT * FROM VBRP INTO TABLE IT_VBRP WHERE VBELN IN S_VBELN. ENDFORM. " GET_DATA FORM SHOW_HIRAR_GRID . WA_KEY-HEADER01 = 'VBELN'. WA_KEY-ITEM01 = 'VBELN'. CALL FUNCTION 'REUSE_ALV_HIERSEQ_LIST_DISPLAY' EXPORTING I_CALLBACK_PROGRAM = 'ZALV_HIE' I_TABNAME_HEADER = 'IT_VBRK' I_TABNAME_ITEM = 'IT_VBRP' I_STRUCTURE_NAME_HEADER = 'VBRK' I_ST...

ALV Report with field catalog and layout in SAP ABAP

Example ALV report for using field catalog and layput in SAP ABAP REPORT ZALV_2 . DATA: BEGIN OF ITAB OCCURS 1, MATNR LIKE MARA-MATNR, MAKTX LIKE MAKT-MAKTX, WERKS LIKE MARD-WERKS, LGORT LIKE MARD-LGORT, LABST LIKE MARD-LABST, END OF ITAB. SELECT-OPTIONS: S_MATNR FOR ITAB-MATNR. PARAMETERS: P_MANU RADIOBUTTON GROUP G1, P_AUTO RADIOBUTTON GROUP G1. TYPE-POOLS: SLIS. DATA: IT_FLDCAT TYPE SLIS_T_FIELDCAT_ALV, WA_FLDCAT LIKE LINE OF IT_FLDCAT, WA_LAYO TYPE SLIS_LAYOUT_ALV. START-OF-SELECTION. PERFORM GET_DATA. PERFORM GENERATE_FLDCAT. PERFORM GENERATE_LAYOUT. END-OF-SELECTION. PERFORM SHOW_GRID. FORM GET_DATA . SELECT A~MATNR MAKTX WERKS LGORT LABST INTO TABLE ITAB FROM MARA AS A JOIN MAKT AS B ON B~MATNR = A~MATNR JOIN MARD AS C ON C~MATNR = A~MATNR WHERE A~MATNR IN S_MATNR AND SPR...

ALV report in SAP ABAP

Example code for ALV report in SAP ABAP REPORT ZALV1 . DATA: ITAB LIKE MARD OCCURS 1 WITH HEADER LINE. PARAMETERS: P_MATNR LIKE MARA-MATNR. START-OF-SELECTION. PERFORM GET_dATA. END-OF-SELECTION. PERFORM SHOW_GRID. FORM GET_dATA . SELECT * FROM MARD INTO TABLE ITAB WHERE MATNR = P_MATNR. ENDFORM. " GET_dATA FORM SHOW_GRID . CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' EXPORTING I_CALLBACK_PROGRAM = 'ZALV1' I_STRUCTURE_NAME = 'MARD' I_GRID_TITLE = 'Material Str Loc Details' TABLES T_OUTTAB = ITAB EXCEPTIONS PROGRAM_ERROR = 1 OTHERS = 2. IF SY-SUBRC <> 0. * MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO * WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4. ENDIF. ENDFORM. " SHOW_GRID

ALV with Field Catelogue

Sample ALV report with Field Catelogue The below code explains you how to create an ALV report with field catelogue using Function module. *&---------------------------------------------------------------------* *& Report ZALV_2 * *& * *&---------------------------------------------------------------------* *& * *& * *&---------------------------------------------------------------------* REPORT ZALV_2 . DATA: BEGIN OF ITAB OCCURS 1, MATNR LIKE MARA-MATNR, MAKTX LIKE MAKT-MAKTX, WERKS LIKE MARD-WERKS, LGORT LIKE MARD-LGORT, LABST LIKE MARD-LABST, END OF ITAB. SELECT-OPTIONS: S_MATNR FOR ITAB-MATNR. PARA...

Interactive ALV report using Function Module

Real-time example of interactive ALV in SAP ABAP REPORT ZALV_4 . DATA: IT_VBRK LIKE VBRK OCCURS 1 WITH HEADER LINE. DATA: IT_VBRP LIKE VBRP OCCURS 1 WITH HEADER LINE. DATA: V_VBELN LIKE VBRK-VBELN. TYPE-POOLS: SLIS. DATA: X_LAYO TYPE SLIS_LAYOUT_ALV. DATA: IT_EVENTS TYPE SLIS_T_EVENT WITH HEADER LINE. SELECT-OPTIONS: S_VBELN FOR IT_VBRK-VBELN. START-OF-SELECTION. PERFORM GET_DATA. PERFORM BUILD_LAYOUT. PERFORM BUILD_EVENTS. END-OF-SELECTION. PERFORM SHOW_BASIC_GRID. *&---------------------------------------------------------------------* *& Form GET_DATA *&---------------------------------------------------------------------* * text *----------------------------------------------------------------------* FORM GET_DATA . SELECT * FROM VBRK INTO TABLE IT_VBRK WHERE VBELN IN S_VBELN. ENDFORM. " GET_DATA *&------------------------------------------------...

Interactive ALV report with ALV Events in SAP ABAP

Interactive ALV report using SAP ABAP programming with ALV events and user command. REPORT ZALV6 . DATA: IT_EKKO LIKE EKKO OCCURS 1 WITH HEADER LINE. DATA: IT_EKPO LIKE EKPO OCCURS 1 WITH HEADER LINE. TYPE-POOLS: SLIS. DATA: WA_LAYOUT TYPE SLIS_LAYOUT_ALV. DATA: IT_EVENTS TYPE SLIS_T_EVENT WITH HEADER LINE. SELECT-OPTIONS: S_EBELN FOR IT_EKKO-EBELN. START-OF-SELECTION. PERFORM GET_DATA. PERFORM BUILD_LAYOUT. PERFORM BUILD_EVENTS. END-OF-SELECTION. PERFORM SHOW_BASIC_GRID. *&---------------------------------------------------------------------* *& Form GET_DATA *&---------------------------------------------------------------------* * text *----------------------------------------------------------------------* FORM GET_DATA . SELECT * FROM EKKO INTO TABLE IT_EKKO WHERE EBELN IN S_EBELN. ENDFORM. " GET_DATA *&--------------------------------------------------------------...

ALV Report 4

Example ALV Report 4 *&---------------------------------------------------------------------* *& Report  ZALV5                                                       * *&                                                                     * *&---------------------------------------------------------------------* *&        ...

ALV Report 3

Example ALV Report 3 *&---------------------------------------------------------------------* *& Report  ZALV3                                                       * *&                                                                     * *&---------------------------------------------------------------------* *&        ...

ALV Report-3

Example ALV Report 3 *&---------------------------------------------------------------------* *& Report  ZALV3                                                       * *&                                                                     * *&---------------------------------------------------------------------* *&        ...

ALV Report-2

Example for ALV Report 2 *&---------------------------------------------------------------------* *& Report  ZALV2                                                       * *&                                                                     * *&---------------------------------------------------------------------* *&       ...

ALV Report

REPORT ZALV1 . DATA: ITAB LIKE ZSTUDENT OCCURS 1 WITH HEADER LINE. START-OF-SELECTION. PERFORM GET_DATA. END-OF-SELECTION. PERFORM SHOW_GRID. *&---------------------------------------------------------------------* *& Form GET_DATA *&---------------------------------------------------------------------* * text *----------------------------------------------------------------------* FORM GET_DATA . SELECT * FROM ZSTUDENT INTO TABLE ITAB . ENDFORM. " GET_DATA *&---------------------------------------------------------------------* *& Form SHOW_GRID *&---------------------------------------------------------------------* * text *----------------------------------------------------------------------* FORM SHOW_GRID . CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' EXPORTING * I_INTERFACE_CHECK = ' ' * I_BYPASSING_BUFFER = ' ' * I_BUFFER_ACTIVE = ' ' * I_CALLBACK_PROGRAM = ' ' * I_CALLBACK_PF_STATUS_S...