sap abap ALV Reporting - Z_LIST_MATERIALS

REPORT Z_LIST_MATERIALS.

TYPE-POOLS: SLIS.
TABLES:MARC, MARD, VBAP, LIPS, EKPO, VBFA, EKBE, MARM, VBBE, MARA, MBEW.

SELECTION-SCREEN BEGIN OF BLOCK SEL WITH FRAME TITLE TEXT-001.
SELECT-OPTIONS: S_WERKS FOR MARC-WERKS, " Plant
             S_MATNR FOR MARC-MATNR, " Material
             S_MTART FOR MARA-MTART. " Material Type SELECTION-SCREEN END OF BLOCK SEL.
PARAMETERS: P_VARI LIKE DISVARIANT-VARIANT. " ALV Variant

CONSTANTS: FORMNAME_TOP_OF_PAGE TYPE SLIS_FORMNAME VALUE 'TOP_OF_PAGE'.

DATA: BEGIN OF INV OCCURS 100,
     WERKS LIKE MARD-WERKS, " Plant
     MATNR LIKE MARD-MATNR, " Material
     MTART LIKE MARA-MTART, " Material Type
     STPRS LIKE MBEW-STPRS, " Standard Price
     AVAIL LIKE MARD-LABST, " Available
     LABST LIKE MARD-LABST, " Unrestricted use
     INSME LIKE MARD-INSME, " Quality Inspection
     RETME LIKE MARD-RETME, " Returns
     TRANS LIKE MARC-UMLMC, " Stock in transit (calculated)
     UMLMC LIKE MARC-UMLMC, " Stock Transfer (plant)
     UMLME LIKE MARD-UMLME, " Transfer (SLoc)
     WESBS LIKE EKBE-WESBS, " GR Blocked Stock
     TRAME LIKE MARC-TRAME, " Stock in transit
     SPEME LIKE MARD-SPEME, " Blocked
     KWMENG LIKE VBAP-KWMENG, " Sales orders
     LFIMG LIKE LIPS-LFIMG, " Scheduled for Delivery
     MENGE LIKE EKPO-MENGE, " Open Purch. Orders
     VALUE LIKE MBEW-SALK3, " Stock Value (Calculated)
     MEINS LIKE MARA-MEINS, " Unit of measure
   END OF INV.

DATA: FIELDTAB TYPE SLIS_T_FIELDCAT_ALV,
   HEADING  TYPE SLIS_T_LISTHEADER,
   LAYOUT   TYPE SLIS_LAYOUT_ALV,
   EVENTS   TYPE SLIS_T_EVENT,
   REPNAME  LIKE SY-REPID,
   F2CODE   LIKE SY-UCOMM VALUE  '&ETA',
   G_SAVE(1) TYPE C,
   G_EXIT(1) TYPE C,
   G_VARIANT LIKE DISVARIANT,
   GX_VARIANT LIKE DISVARIANT.

INITIALIZATION.
REPNAME = SY-REPID.
PERFORM INITIALIZE_FIELDCAT USING FIELDTAB[].
PERFORM BUILD_EVENTTAB USING EVENTS[].
PERFORM BUILD_COMMENT USING HEADING[].
PERFORM INITIALIZE_VARIANT.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_VARI.
PERFORM F4_FOR_VARIANT.

AT SELECTION-SCREEN.
PERFORM PAI_OF_SELECTION_SCREEN.

START-OF-SELECTION.
PERFORM GET_MARD.
PERFORM GET_UNIT_OF_MEASURE.
PERFORM GET_MARC.
PERFORM GET_EKPO.
PERFORM GET_LIPS.
PERFORM GET_VBAP.
PERFORM GET_OPEN.
PERFORM GET_PRICE.

END-OF-SELECTION.

PERFORM BUILD_LAYOUT USING LAYOUT.
PERFORM WRITE_OUTPUT.


*&---------------------------------------------------------------------*
*&      Form  INITIALIZE_FIELDCAT
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->P_FIELDTAB[]  text                                           *
*----------------------------------------------------------------------*
FORM INITIALIZE_FIELDCAT USING P_FIELDTAB TYPE SLIS_T_FIELDCAT_ALV.
DATA: L_FIELDCAT TYPE SLIS_FIELDCAT_ALV.
* fixed columns (obligatory)
CLEAR L_FIELDCAT.
L_FIELDCAT-TABNAME    = 'INV'.
L_FIELDCAT-FIX_COLUMN = 'X'.
L_FIELDCAT-NO_OUT     = 'O'.
L_FIELDCAT-FIELDNAME  = 'WERKS'.
APPEND L_FIELDCAT TO P_FIELDTAB.
L_FIELDCAT-FIELDNAME  = 'MATNR'.
APPEND L_FIELDCAT TO P_FIELDTAB.

* totalized columns
CLEAR L_FIELDCAT.
L_FIELDCAT-TABNAME   = 'INV'.
L_FIELDCAT-SP_GROUP  = 'A'.
L_FIELDCAT-DO_SUM    = 'X'.
L_FIELDCAT-FIELDNAME = 'LABST'.
APPEND L_FIELDCAT TO P_FIELDTAB.
L_FIELDCAT-FIELDNAME = 'INSME'.
APPEND L_FIELDCAT TO P_FIELDTAB.
L_FIELDCAT-FIELDNAME = 'RETME'.
APPEND L_FIELDCAT TO P_FIELDTAB.
L_FIELDCAT-FIELDNAME = 'UMLME'.
APPEND L_FIELDCAT TO P_FIELDTAB.
L_FIELDCAT-FIELDNAME = 'WESBS'.
APPEND L_FIELDCAT TO P_FIELDTAB.
L_FIELDCAT-FIELDNAME = 'SPEME'.
APPEND L_FIELDCAT TO P_FIELDTAB.
* columns with different description
L_FIELDCAT-FIELDNAME = 'KWMENG'.
L_FIELDCAT-SELTEXT_M = 'Sales Orders'.
L_FIELDCAT-SELTEXT_S = 'Sales Or'.
L_FIELDCAT-SELTEXT_L = 'Sales Orders Qty'.
APPEND L_FIELDCAT TO P_FIELDTAB.
L_FIELDCAT-FIELDNAME = 'LFIMG'.
L_FIELDCAT-SELTEXT_M = 'Sched. Delivery'.
L_FIELDCAT-SELTEXT_S = 'Schd. Del'.
L_FIELDCAT-SELTEXT_L = 'Scheduled for Delivery'.
APPEND L_FIELDCAT TO P_FIELDTAB.
L_FIELDCAT-FIELDNAME = 'TRANS'.
L_FIELDCAT-SELTEXT_M = 'Stk. in transit'.
L_FIELDCAT-SELTEXT_S = 'Stk. trns'.
L_FIELDCAT-SELTEXT_L = 'Stock in transit (sum)'.
APPEND L_FIELDCAT TO P_FIELDTAB.
L_FIELDCAT-FIELDNAME = 'AVAIL'.
L_FIELDCAT-SELTEXT_M = 'Available'.
L_FIELDCAT-SELTEXT_S = 'Avail.'.
L_FIELDCAT-SELTEXT_L = 'Stock Available'.
APPEND L_FIELDCAT TO P_FIELDTAB.
L_FIELDCAT-FIELDNAME = 'MENGE'.
L_FIELDCAT-SELTEXT_M = 'Open Orders'.
L_FIELDCAT-SELTEXT_S = 'Open Ord'.
L_FIELDCAT-SELTEXT_L = 'Open Purchase Orders'.
APPEND L_FIELDCAT TO P_FIELDTAB.

* columns not displayed
CLEAR L_FIELDCAT.
L_FIELDCAT-TABNAME   = 'INV'.
L_FIELDCAT-SP_GROUP  = 'A'.
L_FIELDCAT-NO_OUT    = 'X'.
L_FIELDCAT-FIELDNAME = 'MEINS'.
APPEND L_FIELDCAT TO P_FIELDTAB.
L_FIELDCAT-FIELDNAME = 'UMLMC'.
APPEND L_FIELDCAT TO P_FIELDTAB.
L_FIELDCAT-FIELDNAME = 'TRAME'.
APPEND L_FIELDCAT TO P_FIELDTAB.
L_FIELDCAT-FIELDNAME = 'STPRS'.
APPEND L_FIELDCAT TO P_FIELDTAB.
L_FIELDCAT-FIELDNAME = 'VALUE'.
APPEND L_FIELDCAT TO P_FIELDTAB.
ENDFORM.                               " INITIALIZE_FIELDCAT

*&---------------------------------------------------------------------*
*&      Form  BUILD_EVENTTAB
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->P_EVENTS[]  text                                             *
*----------------------------------------------------------------------*
FORM BUILD_EVENTTAB USING P_EVENTS TYPE SLIS_T_EVENT.
DATA: LS_EVENT TYPE SLIS_ALV_EVENT.
CALL FUNCTION 'REUSE_ALV_EVENTS_GET'
    EXPORTING
         I_LIST_TYPE = 0
    IMPORTING
         ET_EVENTS   = P_EVENTS.
READ TABLE P_EVENTS WITH KEY NAME = SLIS_EV_TOP_OF_PAGE
                        INTO LS_EVENT.
IF SY-SUBRC = 0.
 MOVE FORMNAME_TOP_OF_PAGE TO LS_EVENT-FORM.
 APPEND LS_EVENT TO P_EVENTS.
ENDIF.
ENDFORM.                               " BUILD_EVENTTAB

*&---------------------------------------------------------------------*
*&      Form  BUILD_COMMENT
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->P_HEADING[]  text                                            *
*----------------------------------------------------------------------*
FORM BUILD_COMMENT USING P_HEADING TYPE SLIS_T_LISTHEADER.
DATA: HLINE TYPE SLIS_LISTHEADER,
     TEXT(60) TYPE C,
     SEP(20) TYPE C.
CLEAR: HLINE, TEXT.
HLINE-TYP  = 'H'.
WRITE: TEXT-101 TO TEXT+23.
HLINE-INFO = TEXT.
APPEND HLINE TO P_HEADING.
CLEAR TEXT.
WRITE: 'User: ' TO TEXT,
      SY-UNAME TO TEXT+6,
      'Date: ' TO TEXT+25,
      SY-DATUM TO TEXT+31,
      'Page: ' TO TEXT+50,
      SY-PAGNO TO TEXT+56.
HLINE-INFO = TEXT.
APPEND HLINE TO P_HEADING.



ENDFORM.                    " BUILD_COMMENT

*---------------------------------------------------------------------*
*       FORM TOP_OF_PAGE                                              *
*---------------------------------------------------------------------*
*       ........                                                      *
*---------------------------------------------------------------------*
FORM TOP_OF_PAGE.
CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'
    EXPORTING
         IT_LIST_COMMENTARY = HEADING.
ENDFORM.
*&---------------------------------------------------------------------*
*&      Form  INITIALIZE_VARIANT
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM INITIALIZE_VARIANT.
G_SAVE = 'A'.
CLEAR G_VARIANT.
G_VARIANT-REPORT = REPNAME.
GX_VARIANT = G_VARIANT.
CALL FUNCTION 'REUSE_ALV_VARIANT_DEFAULT_GET'
    EXPORTING
         I_SAVE     = G_SAVE
    CHANGING
         CS_VARIANT = GX_VARIANT
    EXCEPTIONS
         NOT_FOUND  = 2.
IF SY-SUBRC = 0.
 P_VARI = GX_VARIANT-VARIANT.
ENDIF.
ENDFORM.                               " INITIALIZE_VARIANT

*&---------------------------------------------------------------------*
*&      Form  F4_FOR_VARIANT
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM F4_FOR_VARIANT.
CALL FUNCTION 'REUSE_ALV_VARIANT_F4'
    EXPORTING
         IS_VARIANT = G_VARIANT
         I_SAVE     = G_SAVE
    IMPORTING
         E_EXIT     = G_EXIT
         ES_VARIANT = GX_VARIANT
    EXCEPTIONS
         NOT_FOUND  = 2.
IF SY-SUBRC = 2.
 MESSAGE ID SY-MSGID TYPE 'S'      NUMBER SY-MSGNO
         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ELSE.
 IF G_EXIT = SPACE.
   P_VARI = GX_VARIANT-VARIANT.
 ENDIF.
ENDIF.
ENDFORM.                               " F4_FOR_VARIANT

*&---------------------------------------------------------------------*
*&      Form  PAI_OF_SELECTION_SCREEN
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM PAI_OF_SELECTION_SCREEN.
*
IF NOT P_VARI IS INITIAL.
 MOVE G_VARIANT TO GX_VARIANT.
 MOVE P_VARI TO GX_VARIANT-VARIANT.
 CALL FUNCTION 'REUSE_ALV_VARIANT_EXISTENCE'
      EXPORTING
           I_SAVE     = G_SAVE
      CHANGING
           CS_VARIANT = GX_VARIANT.
 G_VARIANT = GX_VARIANT.
ELSE.
 PERFORM INITIALIZE_VARIANT.
ENDIF.
ENDFORM.                               " PAI_OF_SELECTION_SCREEN


*&---------------------------------------------------------------------*
*&      Form  GET_MARD
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM GET_MARD.
SELECT MATNR WERKS LABST INSME RETME UMLME SPEME
      FROM MARD
      INTO CORRESPONDING FIELDS OF INV
      WHERE MATNR IN S_MATNR
      AND   WERKS IN S_WERKS.
 COLLECT INV.
ENDSELECT.
PERFORM FILTER_BY_MATERIAL_TYPE.
ENDFORM.                               " GET_MARD

*&---------------------------------------------------------------------*
*&      Form  FILTER_BY_MATERIAL_TYPE
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM FILTER_BY_MATERIAL_TYPE.
LOOP AT INV.
 CLEAR INV-MTART.
 SELECT SINGLE MTART
        INTO INV-MTART
        FROM MARA
        WHERE MATNR EQ INV-MATNR
        AND   MTART IN S_MTART.
 IF SY-SUBRC EQ 0.
   MODIFY INV.
 ELSE.
   DELETE INV.
 ENDIF.
ENDLOOP.
ENDFORM.                    " FILTER_BY_MATERIAL_TYPE

*&---------------------------------------------------------------------*
*&      Form  GET_MARC
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM GET_MARC.
LOOP AT INV.
 SELECT SINGLE UMLMC TRAME
        FROM MARC
        INTO CORRESPONDING FIELDS OF INV
        WHERE MATNR EQ INV-MATNR
        AND   WERKS EQ INV-WERKS.
 IF SY-SUBRC EQ 0.
   INV-TRANS = INV-UMLMC + INV-TRAME.
   MODIFY INV.
 ENDIF.
ENDLOOP.
ENDFORM.                               " GET_MARC
*&---------------------------------------------------------------------*
*&      Form  GET_EKPO
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM GET_EKPO.
DATA: WESBS LIKE INV-WESBS,
     SHKZG LIKE EKBE-SHKZG,
     MEINS LIKE EKPO-MEINS,
     LMEIN LIKE EKPO-LMEIN.
LOOP AT INV.
 CLEAR: WESBS, SHKZG, MEINS, LMEIN.
 SELECT YWESBS YSHKZG XMEINS XLMEIN
        INTO (WESBS, SHKZG, MEINS, LMEIN)
        FROM EKPO AS X JOIN EKBE AS Y
        ON   XEBELN = YEBELN
        AND  XEBELP = YEBELP
        WHERE XMATNR EQ INV-MATNR
        AND   XWERKS EQ INV-WERKS
        AND   XLOEKZ NE 'L'.
   IF SHKZG EQ 'H'.
     MULTIPLY WESBS BY -1.
   ENDIF.
   IF MEINS NE LMEIN.
     PERFORM CONVERT_UNIT_OF_MEASURE CHANGING INV-MATNR MEINS WESBS.
   ENDIF.
   ADD WESBS TO INV-WESBS.
 ENDSELECT.
 MODIFY INV.
ENDLOOP.
ENDFORM.                               " GET_EKPO
*&---------------------------------------------------------------------*
*&      Form  GET_LIPS
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM GET_LIPS.
DATA: LFIMG LIKE INV-LFIMG.
LOOP AT INV.
 CLEAR: LFIMG, INV-LFIMG.
 SELECT OMENG
        INTO LFIMG
        FROM VBBE
        WHERE MATNR EQ INV-MATNR
        AND   WERKS EQ INV-WERKS
        AND   VBTYP EQ 'J'.
   ADD LFIMG TO INV-LFIMG.
 ENDSELECT.
 MODIFY INV.
ENDLOOP.
ENDFORM.                               " GET_LIPS
*&---------------------------------------------------------------------*
*&      Form  GET_VBAP
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM GET_VBAP.
DATA: KWMENG LIKE INV-KWMENG.
LOOP AT INV.
 CLEAR: KWMENG, INV-KWMENG.
 SELECT OMENG
        INTO KWMENG
        FROM VBBE
        WHERE MATNR EQ INV-MATNR
        AND   WERKS EQ INV-WERKS
        AND   VBTYP EQ 'C'.
   ADD KWMENG TO INV-KWMENG.
 ENDSELECT.
 INV-AVAIL = INV-LABST - INV-INSME - INV-KWMENG - INV-LFIMG.
 MODIFY INV.
ENDLOOP.
ENDFORM.                               " GET_VBAP

*&---------------------------------------------------------------------*
*&      Form  GET_UNIT_OF_MEASURE
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*  -->  p1        text
*  <--  p2        text
*----------------------------------------------------------------------*
FORM GET_UNIT_OF_MEASURE.
LOOP AT INV.
 SELECT SINGLE MEINS
        FROM MARA
        INTO INV-MEINS
        WHERE MATNR EQ INV-MATNR.
 MODIFY INV.
ENDLOOP.
ENDFORM.                               " GET_UNIT_OF_MEASURE

*&---------------------------------------------------------------------*
*&      Form  GET_OPEN
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM GET_OPEN.
DATA: BEGIN OF XTAB OCCURS 10,       " Open orders table
        WERKS LIKE EKPO-WERKS,
        LGORT LIKE EKPO-LGORT,
        MATNR LIKE EKPO-MATNR,
        MENGE LIKE EKPO-MENGE,
        MENGK LIKE EKPO-MENGE,
      END OF XTAB.
RANGES: L_WERKS FOR MARD-WERKS.

LOOP AT INV.
 REFRESH XTAB.
 CLEAR: XTAB, L_WERKS.
 MOVE INV-WERKS TO L_WERKS-LOW.
 CALL FUNCTION 'MB_ADD_PURCHASE_ORDER_QUANTITY'
      EXPORTING
           X_MATNR = INV-MATNR
           X_MEINS = INV-MEINS
           X_ELIKZ = SPACE
           X_LOEKZ = SPACE
      TABLES
           XTAB    = XTAB
           XWERKS  = L_WERKS.
 MOVE XTAB-MENGE TO INV-MENGE.
 MODIFY INV.
ENDLOOP.
ENDFORM.                               " GET_OPEN

*&---------------------------------------------------------------------*
*&      Form  GET_PRICE
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM GET_PRICE.
LOOP AT INV.
 SELECT SINGLE STPRS
        FROM MBEW
        INTO INV-STPRS
        WHERE MATNR EQ INV-MATNR
        AND   BWKEY EQ INV-WERKS
        AND   BWTAR EQ SPACE.
   IF SY-SUBRC EQ 0.
     INV-VALUE = INV-STPRS *
               ( INV-LABST + INV-INSME + INV-TRANS + INV-SPEME ).
     MODIFY INV.
   ENDIF.
ENDLOOP.
ENDFORM.                    " GET_PRICE

*---------------------------------------------------------------------*
*       FORM CONVERT_UNIT_OF_MEASURE                                  *
*---------------------------------------------------------------------*
*       text                                                          *
*---------------------------------------------------------------------*
*  -->  P_MATNR                                                       *
*  -->  P_VRKME                                                       *
*  -->  P_QUANT                                                       *
*---------------------------------------------------------------------*
FORM CONVERT_UNIT_OF_MEASURE USING P_MATNR P_VRKME P_QUANT.
DATA: UMREZ LIKE MARM-UMREZ,
     UMREN LIKE MARM-UMREN.
SELECT SINGLE UMREZ UMREN
      INTO (UMREZ, UMREN)
      FROM MARM
      WHERE MATNR EQ P_MATNR
      AND   MEINH EQ P_VRKME.
IF SY-SUBRC EQ 0.
 COMPUTE P_QUANT = ( P_QUANT * UMREZ ) / UMREN.
ENDIF.
ENDFORM.

*&---------------------------------------------------------------------*
*&      Form  BUILD_LAYOUT
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->P_LAYOUT  text                                               *
*----------------------------------------------------------------------*
FORM BUILD_LAYOUT USING P_LAYOUT TYPE SLIS_LAYOUT_ALV.
P_LAYOUT-F2CODE       = F2CODE.
P_LAYOUT-ZEBRA        = 'X'.
P_LAYOUT-DETAIL_POPUP = 'X'.
ENDFORM.                               " BUILD_LAYOUT

*&---------------------------------------------------------------------*
*&      Form  WRITE_OUTPUT
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM WRITE_OUTPUT.
SORT INV BY WERKS MATNR.
CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE'
    EXPORTING
         I_PROGRAM_NAME     = REPNAME
         I_INTERNAL_TABNAME = 'INV'
         I_INCLNAME         = REPNAME
    CHANGING
         CT_FIELDCAT        = FIELDTAB.
IF SY-SUBRC <> 0.
 WRITE: 'SY-SUBRC: ', SY-SUBRC, 'REUSE_ALV_FIELDCATALOG_MERGE'.  ENDIF.  CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'
    EXPORTING
         I_CALLBACK_PROGRAM = REPNAME
         I_STRUCTURE_NAME   = 'INV'
         IS_LAYOUT          = LAYOUT
         IT_FIELDCAT        = FIELDTAB
         I_DEFAULT          = 'A'
         I_SAVE             = G_SAVE
         IS_VARIANT         = G_VARIANT
         IT_EVENTS          = EVENTS[]
    TABLES
         T_OUTTAB           = INV.
IF SY-SUBRC <> 0.
 WRITE: 'SY-SUBRC: ', SY-SUBRC, 'REUSE_ALV_LIST_DISPLAY'.  ENDIF.
ENDFORM.                               " WRITE_OUTPUT