Wednesday, 20 November 2013

NOVEMBER 20


*&---------------------------------------------------------------------*
*&      TABLE CONTROL 1300 : ASSIGN RESULT
*&---------------------------------------------------------------------*
*       TEXT
*----------------------------------------------------------------------*
*&SPWIZARD: TYPE FOR THE DATA OF TABLECONTROL 'TBC_1300'
TYPES: BEGIN OF T_TBC_1300,
         EMP_ID LIKE ZPROJECT_EMP-EMP_ID,
         EMP_NAME LIKE ZPROJECT_EMP-EMP_NAME,
         DEPT_NO LIKE ZPROJECT_EMP-DEPT_NO,
         DEPT_NAME LIKE ZPROJECT_EMP-DEPT_NAME,
         MARK LIKE ZPROJECT_EMP-MARK,
       END OF T_TBC_1300.

*&SPWIZARD: INTERNAL TABLE FOR TABLECONTROL 'TBC_1300'
DATA:     G_TBC_1300_ITAB   TYPE T_TBC_1300 OCCURS 0,
          G_TBC_1300_WA     TYPE T_TBC_1300. "WORK AREA
DATA:     G_TBC_1300_COPIED.           "COPY FLAG

*&SPWIZARD: DECLARATION OF TABLECONTROL 'TBC_1300' ITSELF
CONTROLS: TBC_1300 TYPE TABLEVIEW USING SCREEN 1300.

*&SPWIZARD: OUTPUT MODULE FOR TC 'TBC_1300'. DO NOT CHANGE THIS LINE!
*&SPWIZARD: COPY DDIC-TABLE TO ITAB
MODULE TBC_1300_INIT OUTPUT.
  IF G_TBC_1300_COPIED IS INITIAL.
*&SPWIZARD: COPY DDIC-TABLE 'ZPROJECT_EMP'
*&SPWIZARD: INTO INTERNAL TABLE 'G_TBC_1300_ITAB'
    SELECT * FROM ZPROJECT_EMP
       INTO CORRESPONDING FIELDS
       OF TABLE G_TBC_1300_ITAB.
    G_TBC_1300_COPIED = 'X'.
    REFRESH CONTROL 'TBC_1300' FROM SCREEN '1300'.
    SORT G_TBC_1300_ITAB BY EMP_ID ASCENDING.
  ENDIF.
ENDMODULE.

*&SPWIZARD: OUTPUT MODULE FOR TC 'TBC_1300'. DO NOT CHANGE THIS LINE!
*&SPWIZARD: MOVE ITAB TO DYNPRO
MODULE TBC_1300_MOVE OUTPUT.
  MOVE-CORRESPONDING G_TBC_1300_WA TO ZPROJECT_EMP.
ENDMODULE.

*&SPWIZARD: INPUT MODULE FOR TC 'TBC_1300'. DO NOT CHANGE THIS LINE!
*&SPWIZARD: MODIFY TABLE
MODULE TBC_1300_MODIFY INPUT.
  MOVE-CORRESPONDING ZPROJECT_EMP TO G_TBC_1300_WA.
  MODIFY G_TBC_1300_ITAB
    FROM G_TBC_1300_WA
    INDEX TBC_1300-CURRENT_LINE.
ENDMODULE.
*&---------------------------------------------------------------------*
*&      MODULE  STATUS_1300  OUTPUT
*&---------------------------------------------------------------------*
*       TEXT
*----------------------------------------------------------------------*
MODULE STATUS_1300 OUTPUT.
  SET PF-STATUS '1300'.
  SET TITLEBAR '1300'.

ENDMODULE.                 " STATUS_1300  OUTPUT
*&---------------------------------------------------------------------*
*&      MODULE  USER_COMMAND_1300  INPUT
*&---------------------------------------------------------------------*
*       TEXT
*----------------------------------------------------------------------*
MODULE USER_COMMAND_1300 INPUT.
  CASE SY-UCOMM.

    WHEN 'EXIT'.
      LEAVE PROGRAM.

    WHEN 'BACK'.
      CALL SCREEN 135.

    WHEN 'CANCEL'.
      CLEAR : USER_ID , PASSWORD.
      CALL SCREEN 1000.

    WHEN 'SUBMIT'.
      READ TABLE  G_TBC_1300_ITAB INTO ZPROJECT_EMP  WITH KEY   MARK = 'X'.
      CALL SCREEN 124.

  ENDCASE.
ENDMODULE.                 " USER_COMMAND_1300  INPUT
*&---------------------------------------------------------------------*
*&      TAB 131 - ASSIGN RESULT
*&---------------------------------------------------------------------*
*       TEXT
*----------------------------------------------------------------------*
*&SPWIZARD: FUNCTION CODES FOR TABSTRIP 'TAB_131'
CONSTANTS: BEGIN OF C_TAB_131,
             TAB1 LIKE SY-UCOMM VALUE 'TAB_131_FC1',
             TAB2 LIKE SY-UCOMM VALUE 'TAB_131_FC2',
             TAB3 LIKE SY-UCOMM VALUE 'TAB_131_FC3',
           END OF C_TAB_131.
*&SPWIZARD: DATA FOR TABSTRIP 'TAB_131'
CONTROLS:  TAB_131 TYPE TABSTRIP.
DATA:      BEGIN OF G_TAB_131,
             SUBSCREEN   LIKE SY-DYNNR,
             PROG        LIKE SY-REPID VALUE 'ZPROJECT_EAS',
             PRESSED_TAB LIKE SY-UCOMM VALUE C_TAB_131-TAB1,
           END OF G_TAB_131.

*&SPWIZARD: OUTPUT MODULE FOR TS 'TAB_131'. DO NOT CHANGE THIS LINE!
*&SPWIZARD: SETS ACTIVE TAB
MODULE TAB_131_ACTIVE_TAB_SET OUTPUT.
  TAB_131-ACTIVETAB = G_TAB_131-PRESSED_TAB.
  CASE G_TAB_131-PRESSED_TAB.
    WHEN C_TAB_131-TAB1.
      G_TAB_131-SUBSCREEN = '0132'.
    WHEN C_TAB_131-TAB2.
      G_TAB_131-SUBSCREEN = '0133'.
    WHEN C_TAB_131-TAB3.
      G_TAB_131-SUBSCREEN = '0134'.
    WHEN OTHERS.
*&SPWIZARD:      DO NOTHING
  ENDCASE.
ENDMODULE.

*&SPWIZARD: INPUT MODULE FOR TS 'TAB_131'. DO NOT CHANGE THIS LINE!
*&SPWIZARD: GETS ACTIVE TAB
MODULE TAB_131_ACTIVE_TAB_GET INPUT.
  OK_CODE = SY-UCOMM.
  CASE OK_CODE.
    WHEN C_TAB_131-TAB1.
      G_TAB_131-PRESSED_TAB = C_TAB_131-TAB1.
    WHEN C_TAB_131-TAB2.
      G_TAB_131-PRESSED_TAB = C_TAB_131-TAB2.
    WHEN C_TAB_131-TAB3.
      G_TAB_131-PRESSED_TAB = C_TAB_131-TAB3.
    WHEN OTHERS.
*&SPWIZARD:      DO NOTHING
  ENDCASE.
ENDMODULE.
*&---------------------------------------------------------------------*
*&      MODULE  STATUS_0131  OUTPUT
*&---------------------------------------------------------------------*
*       TEXT
*----------------------------------------------------------------------*
MODULE STATUS_0131 OUTPUT.
  SET PF-STATUS '131'.
  SET TITLEBAR '131'.

  TYPE-POOLS : VRM.


  SELECT *
     FROM ZPROJECT_YEAR
    INTO TABLE YEAR_DETAILS WHERE EMP_ID = ZPROJECT_EMP-EMP_ID.

  LOOP AT YEAR_DETAILS INTO TEMP_YEAR.

    WA_LISTBOX-KEY = TEMP_YEAR-START_DATE.
    WA_LISTBOX-TEXT = TEMP_YEAR-START_DATE.
    APPEND WA_LISTBOX TO IT_LISTBOX.
  ENDLOOP.

  LD_FIELD = 'START_DATE'.
  CALL FUNCTION 'VRM_SET_VALUES'
    EXPORTING
      ID     = LD_FIELD
      VALUES = IT_LISTBOX.
  REFRESH IT_LISTBOX.

  SELECT *
       FROM ZPROJECT_YEAR
    INTO TABLE YEAR_DETAILS WHERE EMP_ID = ZPROJECT_EMP-EMP_ID.

  LOOP AT YEAR_DETAILS INTO TEMP_YEAR.

    WA_LISTBOX-KEY = TEMP_YEAR-END_DATE.
    WA_LISTBOX-TEXT = TEMP_YEAR-END_DATE.
    APPEND WA_LISTBOX TO IT_LISTBOX.
  ENDLOOP.

  LD_FIELD = 'END_DATE'.
  CALL FUNCTION 'VRM_SET_VALUES'
    EXPORTING
      ID     = LD_FIELD
      VALUES = IT_LISTBOX.
  REFRESH IT_LISTBOX.

ENDMODULE.                 " STATUS_0131  OUTPUT

Tuesday, 19 November 2013

NOVEMBER 19


*&---------------------------------------------------------------------*
*&      MODULE  USER_COMMAND_1115  INPUT
*&---------------------------------------------------------------------*
*       TEXT
*----------------------------------------------------------------------*
MODULE USER_COMMAND_1115 INPUT.

  CASE SY-UCOMM.

    WHEN 'EXIT'.
      LEAVE PROGRAM.

    WHEN 'CANCEL'.
      CLEAR : ZPROJECT_KPI, START_DATE , END_DATE .
      CLEAR : USER_ID , PASSWORD.
      CALL SCREEN 1000.

    WHEN 'BACK'.
      CLEAR : START_DATE , END_DATE, ZPROJECT_KPI.
      CALL SCREEN 115.

    WHEN 'RESET_ALL'.
      CLEAR ZPROJECT_KPI.

    WHEN 'CLEAR'.
      IF R1 = 'X'.
        CLEAR : ZPROJECT_KPI-KPI_1 , ZPROJECT_KPI-TIME_1 , ZPROJECT_KPI-QUALITY_1.
      ELSEIF R2 = 'X'.
        CLEAR : ZPROJECT_KPI-KPI_2 , ZPROJECT_KPI-TIME_2 , ZPROJECT_KPI-QUALITY_2.
      ELSEIF R3 = 'X'.
        CLEAR : ZPROJECT_KPI-KPI_3 , ZPROJECT_KPI-TIME_3 , ZPROJECT_KPI-QUALITY_3.
      ELSEIF R4 = 'X'.
        CLEAR : ZPROJECT_KPI-KPI_4 , ZPROJECT_KPI-TIME_4 , ZPROJECT_KPI-QUALITY_4.
      ELSEIF R5 = 'X'.
        CLEAR : ZPROJECT_KPI-KPI_5 , ZPROJECT_KPI-TIME_5 , ZPROJECT_KPI-QUALITY_5.
      ENDIF.

    WHEN 'SUBMIT'.
      TEMP_KPI-EMP_ID = ZPROJECT_EMP-EMP_ID.
      TEMP_KPI-START_DATE = START_DATE.
      TEMP_KPI-END_DATE = END_DATE.
      TEMP_KPI-EMP_NAME = ZPROJECT_EMP-EMP_NAME.
      TEMP_KPI-DEPT_NAME = ZPROJECT_EMP-DEPT_NAME.
      TEMP_KPI-KPI_1 = ZPROJECT_KPI-KPI_1.
      TEMP_KPI-KPI_2 = ZPROJECT_KPI-KPI_2.
      TEMP_KPI-KPI_3 = ZPROJECT_KPI-KPI_3.
      TEMP_KPI-KPI_4 = ZPROJECT_KPI-KPI_4.
      TEMP_KPI-KPI_5 = ZPROJECT_KPI-KPI_5.
      TEMP_KPI-TIME_1 = ZPROJECT_KPI-TIME_1.
      TEMP_KPI-TIME_2 = ZPROJECT_KPI-TIME_2.
      TEMP_KPI-TIME_3 = ZPROJECT_KPI-TIME_3.
      TEMP_KPI-TIME_4 = ZPROJECT_KPI-TIME_4.
      TEMP_KPI-TIME_5 = ZPROJECT_KPI-TIME_5.
      TEMP_KPI-QUALITY_1 = ZPROJECT_KPI-QUALITY_1.
      TEMP_KPI-QUALITY_2 = ZPROJECT_KPI-QUALITY_2.
      TEMP_KPI-QUALITY_3 = ZPROJECT_KPI-QUALITY_3.
      TEMP_KPI-QUALITY_4 = ZPROJECT_KPI-QUALITY_4.
      TEMP_KPI-QUALITY_5 = ZPROJECT_KPI-QUALITY_5.
      MODIFY ZPROJECT_KPI FROM TEMP_KPI.
      MESSAGE I005(ZMSG_EAS).
      CALL SCREEN 115.

  ENDCASE.
ENDMODULE.                 " USER_COMMAND_1115  INPUT


*&---------------------------------------------------------------------*
*&      MODULE  STATUS_0118  OUTPUT
*&---------------------------------------------------------------------*
*       TEXT
*----------------------------------------------------------------------*
MODULE STATUS_0118 OUTPUT.
  SET PF-STATUS '118'.
  SET TITLEBAR '118'.

  SELECT SINGLE EMP_ID EMP_NAME DEPT_NO DEPT_NAME JOINING_DATE PASSCODE
     EMP_PHONE ADDRESS
    FROM ZPROJECT_EMP
    INTO
    (ZPROJECT_EMP-EMP_ID , ZPROJECT_EMP-EMP_NAME ,ZPROJECT_EMP-DEPT_NO ,
     ZPROJECT_EMP-DEPT_NAME,ZPROJECT_EMP-JOINING_DATE,ZPROJECT_EMP-PASSCODE ,
     ZPROJECT_EMP-EMP_PHONE , ZPROJECT_EMP-ADDRESS)
  WHERE EMP_ID = USER_ID.

ENDMODULE.                 " STATUS_0118  OUTPUT
*&---------------------------------------------------------------------*
*&      MODULE  USER_COMMAND_0118  INPUT
*&---------------------------------------------------------------------*
*       TEXT
*----------------------------------------------------------------------*
MODULE USER_COMMAND_0118 INPUT.
  CASE SY-UCOMM.

    WHEN 'CANCEL'.
      CLEAR : USER_ID , PASSWORD.
      CALL SCREEN 1000.

    WHEN 'EXIT'.
      LEAVE PROGRAM.

    WHEN 'SUBMIT'.
      TEMP_EMP-EMP_ID = ZPROJECT_EMP-EMP_ID.
      TEMP_EMP-EMP_NAME = ZPROJECT_EMP-EMP_NAME.
      TEMP_EMP-DEPT_NO = ZPROJECT_EMP-DEPT_NO.
      TEMP_EMP-DEPT_NAME = ZPROJECT_EMP-DEPT_NAME.
      TEMP_EMP-JOINING_DATE = ZPROJECT_EMP-JOINING_DATE.
      TEMP_EMP-PASSCODE = ZPROJECT_EMP-PASSCODE.
      TEMP_EMP-EMP_PHONE = ZPROJECT_EMP-EMP_PHONE.
      TEMP_EMP-ADDRESS = ZPROJECT_EMP-ADDRESS.
      MODIFY ZPROJECT_EMP FROM TEMP_EMP.
      MESSAGE I005(ZMSG_EAS).
      CALL SCREEN 0115.

    WHEN 'BACK'.
      CALL SCREEN 0115.

  ENDCASE.
ENDMODULE.                 " USER_COMMAND_0118  INPUT
*&---------------------------------------------------------------------*
*&      TAB 119 - VIEW  MARKS AND RESULT
*&---------------------------------------------------------------------*
*       TEXT
*----------------------------------------------------------------------*
*&SPWIZARD: FUNCTION CODES FOR TABSTRIP 'TAB'
CONSTANTS: BEGIN OF C_TAB,
             TAB1 LIKE SY-UCOMM VALUE 'TAB_FC1',
             TAB2 LIKE SY-UCOMM VALUE 'TAB_FC2',
           END OF C_TAB.
*&SPWIZARD: DATA FOR TABSTRIP 'TAB'
CONTROLS:  TAB TYPE TABSTRIP.
DATA:      BEGIN OF G_TAB,
             SUBSCREEN   LIKE SY-DYNNR,
             PROG        LIKE SY-REPID VALUE 'ZPROJECT_EAS',
             PRESSED_TAB LIKE SY-UCOMM VALUE C_TAB-TAB1,
           END OF G_TAB.

*&SPWIZARD: OUTPUT MODULE FOR TS 'TAB'. DO NOT CHANGE THIS LINE!
*&SPWIZARD: SETS ACTIVE TAB
MODULE TAB_ACTIVE_TAB_SET OUTPUT.
  TAB-ACTIVETAB = G_TAB-PRESSED_TAB.
  CASE G_TAB-PRESSED_TAB.
    WHEN C_TAB-TAB1.
      G_TAB-SUBSCREEN = '0121'.
    WHEN C_TAB-TAB2.
      G_TAB-SUBSCREEN = '0122'.
    WHEN OTHERS.
*&SPWIZARD:      DO NOTHING
  ENDCASE.
ENDMODULE.

*&SPWIZARD: INPUT MODULE FOR TS 'TAB'. DO NOT CHANGE THIS LINE!
*&SPWIZARD: GETS ACTIVE TAB
MODULE TAB_ACTIVE_TAB_GET INPUT.
  OK_CODE = SY-UCOMM.
  CASE OK_CODE.
    WHEN C_TAB-TAB1.
      G_TAB-PRESSED_TAB = C_TAB-TAB1.
    WHEN C_TAB-TAB2.
      G_TAB-PRESSED_TAB = C_TAB-TAB2.
    WHEN OTHERS.
*&SPWIZARD:      DO NOTHING
  ENDCASE.
ENDMODULE.

*&---------------------------------------------------------------------*
*&      MODULE  STATUS_0119  OUTPUT
*&---------------------------------------------------------------------*
*       TEXT
*----------------------------------------------------------------------*
MODULE STATUS_0119 OUTPUT.
  SET PF-STATUS '119'.
  SET TITLEBAR '119'.

  TYPE-POOLS : VRM.

  SELECT *
     FROM ZPROJECT_YEAR
    INTO TABLE YEAR_DETAILS WHERE EMP_ID = ZPROJECT_EMP-EMP_ID.

  LOOP AT YEAR_DETAILS INTO TEMP_YEAR.

    WA_LISTBOX-KEY = TEMP_YEAR-START_DATE.
    WA_LISTBOX-TEXT = TEMP_YEAR-START_DATE.
    APPEND WA_LISTBOX TO IT_LISTBOX.
  ENDLOOP.

  LD_FIELD = 'START_DATE'.
  CALL FUNCTION 'VRM_SET_VALUES'
    EXPORTING
      ID     = LD_FIELD
      VALUES = IT_LISTBOX.
  REFRESH IT_LISTBOX.

  SELECT *
       FROM ZPROJECT_YEAR
    INTO TABLE YEAR_DETAILS WHERE EMP_ID = ZPROJECT_EMP-EMP_ID.

  LOOP AT YEAR_DETAILS INTO TEMP_YEAR.

    WA_LISTBOX-KEY = TEMP_YEAR-END_DATE.
    WA_LISTBOX-TEXT = TEMP_YEAR-END_DATE.
    APPEND WA_LISTBOX TO IT_LISTBOX.
  ENDLOOP.

  LD_FIELD = 'END_DATE'.
  CALL FUNCTION 'VRM_SET_VALUES'
    EXPORTING
      ID     = LD_FIELD
      VALUES = IT_LISTBOX.
  REFRESH IT_LISTBOX.


ENDMODULE.                 " STATUS_0119  OUTPUT
*&---------------------------------------------------------------------*
*&      MODULE  USER_COMMAND_0119  INPUT
*&---------------------------------------------------------------------*
*       TEXT
*----------------------------------------------------------------------*
MODULE USER_COMMAND_0119 INPUT.
  CASE SY-UCOMM.

    WHEN 'EXIT'.
      LEAVE PROGRAM.

    WHEN 'CANCEL'.
      CLEAR : START_DATE , END_DATE , ZPROJECT_KPI , ZPROJECT_MARKS , ZPROJECT_RECORD.
      CLEAR : USER_ID , PASSWORD.

      CALL SCREEN 1000.

    WHEN 'OK'.

      CLEAR : START_DATE , END_DATE .
      CLEAR : ZPROJECT_KPI , ZPROJECT_MARKS , ZPROJECT_RECORD.
      CALL SCREEN 115.


  ENDCASE.
ENDMODULE.                 " USER_COMMAND_0119  INPUT


Monday, 18 November 2013

NOVEMBER 18



*&---------------------------------------------------------------------*
*&      MODULE  STATUS_0148  OUTPUT
*&---------------------------------------------------------------------*
*       TEXT
*----------------------------------------------------------------------*
MODULE STATUS_0148 OUTPUT.
*  SET PF-STATUS 'XXXXXXXX'.
*  SET TITLEBAR 'XXX'.
  CASE SY-UCOMM.
    WHEN 'SUBMIT'.
      SELECT SINGLE BEHAVIOUR_ISSUE_1 BEHAVIOUR_ISSUE_2 BEHAVIOUR_ISSUE_3 BEHAVIOUR_ISSUE_4 BEHAVIOUR_ISSUE_5
              FROM ZPROJECT_RESULT
           INTO (ZPROJECT_RESULT-BEHAVIOUR_ISSUE_1 ,ZPROJECT_RESULT-BEHAVIOUR_ISSUE_2 ,ZPROJECT_RESULT-BEHAVIOUR_ISSUE_3
           ,ZPROJECT_RESULT-BEHAVIOUR_ISSUE_4 ,ZPROJECT_RESULT-BEHAVIOUR_ISSUE_5 )
           WHERE EMP_ID = ZPROJECT_EMP-EMP_ID AND START_DATE = START_DATE AND END_DATE = END_DATE.
  ENDCASE.
ENDMODULE.                 " STATUS_0148  OUTPUT
*&---------------------------------------------------------------------*
*&      MODULE  STATUS_0149  OUTPUT
*&---------------------------------------------------------------------*
*       TEXT
*----------------------------------------------------------------------*
MODULE STATUS_0149 OUTPUT.
*  SET PF-STATUS 'XXXXXXXX'.
*  SET TITLEBAR 'XXX'.
  CASE SY-UCOMM.
    WHEN 'SUBMIT'.
      SELECT SINGLE   REWARD_1  REWARD_2  REWARD_3  REWARD_4  REWARD_5
           FROM ZPROJECT_RESULT
           INTO (ZPROJECT_RESULT-REWARD_1 ,ZPROJECT_RESULT-REWARD_2 ,ZPROJECT_RESULT-REWARD_3
        ,ZPROJECT_RESULT-REWARD_4 ,ZPROJECT_RESULT-REWARD_5)
           WHERE EMP_ID = ZPROJECT_EMP-EMP_ID AND START_DATE = START_DATE AND END_DATE = END_DATE.
  ENDCASE.
ENDMODULE.                 " STATUS_0149  OUTPUT


Output:
behavior modifications

reward given

Friday, 15 November 2013

NOVEMBER 15

*&---------------------------------------------------------------------*
*&      MODULE  STATUS_0147  OUTPUT
*&---------------------------------------------------------------------*
*       TEXT
*----------------------------------------------------------------------*
MODULE STATUS_0147 OUTPUT.
*  SET PF-STATUS 'XXXXXXXX'.
*  SET TITLEBAR 'XXX'.
  CASE SY-UCOMM.
    WHEN 'SUBMIT'.

      SELECT SINGLE PROJECT_NAME PROJECT_START_DATE PROJECT_END_DATE FROM ZPROJECT_DETAILS
        INTO (ZPROJECT_DETAILS-PROJECT_NAME ,ZPROJECT_DETAILS-PROJECT_START_DATE , ZPROJECT_DETAILS-PROJECT_END_DATE )
        WHERE EMP_ID = ZPROJECT_EMP-EMP_ID AND PROJECT_START_DATE BETWEEN START_DATE AND END_DATE.

      SELECT SINGLE MAXIMUM_MARKS_TIME MAXIMUM_MARKS_QUALITY TOTAL_MAXIMUM_MARKS MARKS_OBTAINED_TIME
         MARKS_OBTAINED_QUALITY TOTAL_OBTAINED_MARKS PERFORMANCE
         FROM ZPROJECT_RECORD
         INTO (ZPROJECT_RECORD-MAXIMUM_MARKS_TIME , ZPROJECT_RECORD-MAXIMUM_MARKS_QUALITY ,
         ZPROJECT_RECORD-TOTAL_MAXIMUM_MARKS , ZPROJECT_RECORD-MARKS_OBTAINED_TIME ,
         ZPROJECT_RECORD-MARKS_OBTAINED_QUALITY , ZPROJECT_RECORD-TOTAL_OBTAINED_MARKS ,
          ZPROJECT_RECORD-PERFORMANCE)
         WHERE EMP_ID = ZPROJECT_EMP-EMP_ID AND START_DATE = START_DATE AND END_DATE = END_DATE.
  ENDCASE.
ENDMODULE.                 " STATUS_0147  OUTPUT


Output:

mandatory date fields to display values


display of values for selected year






Thursday, 14 November 2013

NOVEMBER 14

*&---------------------------------------------------------------------*
*&     TAB 146 : FINALIZE RESULT
*&---------------------------------------------------------------------*
*       TEXT
*----------------------------------------------------------------------*
*&SPWIZARD: FUNCTION CODES FOR TABSTRIP 'TAB_146'
CONSTANTS: BEGIN OF C_TAB_146,
             TAB1 LIKE SY-UCOMM VALUE 'TAB_146_FC1',
             TAB2 LIKE SY-UCOMM VALUE 'TAB_146_FC2',
             TAB3 LIKE SY-UCOMM VALUE 'TAB_146_FC3',
           END OF C_TAB_146.
*&SPWIZARD: DATA FOR TABSTRIP 'TAB_146'
CONTROLS:  TAB_146 TYPE TABSTRIP.
DATA:      BEGIN OF G_TAB_146,
             SUBSCREEN   LIKE SY-DYNNR,
             PROG        LIKE SY-REPID VALUE 'ZPROJECT_EAS',
             PRESSED_TAB LIKE SY-UCOMM VALUE C_TAB_146-TAB1,
           END OF G_TAB_146.

*&SPWIZARD: OUTPUT MODULE FOR TS 'TAB_146'. DO NOT CHANGE THIS LINE!
*&SPWIZARD: SETS ACTIVE TAB
MODULE TAB_146_ACTIVE_TAB_SET OUTPUT.
  TAB_146-ACTIVETAB = G_TAB_146-PRESSED_TAB.
  CASE G_TAB_146-PRESSED_TAB.
    WHEN C_TAB_146-TAB1.
      G_TAB_146-SUBSCREEN = '0147'.
    WHEN C_TAB_146-TAB2.
      G_TAB_146-SUBSCREEN = '0148'.
    WHEN C_TAB_146-TAB3.
      G_TAB_146-SUBSCREEN = '0149'.
    WHEN OTHERS.
*&SPWIZARD:      DO NOTHING
  ENDCASE.
ENDMODULE.

*&SPWIZARD: INPUT MODULE FOR TS 'TAB_146'. DO NOT CHANGE THIS LINE!
*&SPWIZARD: GETS ACTIVE TAB
MODULE TAB_146_ACTIVE_TAB_GET INPUT.
  OK_CODE = SY-UCOMM.
  CASE OK_CODE.
    WHEN C_TAB_146-TAB1.
      G_TAB_146-PRESSED_TAB = C_TAB_146-TAB1.
    WHEN C_TAB_146-TAB2.
      G_TAB_146-PRESSED_TAB = C_TAB_146-TAB2.
    WHEN C_TAB_146-TAB3.
      G_TAB_146-PRESSED_TAB = C_TAB_146-TAB3.
    WHEN OTHERS.
*&SPWIZARD:      DO NOTHING
  ENDCASE.
ENDMODULE.

*&----------------------------------------------------------------------*
*&      MODULE  STATUS_0146  OUTPUT
*&----------------------------------------------------------------------*
*       TEXT
*------------------------------------------------------------------------*
MODULE STATUS_0146 OUTPUT.
  SET PF-STATUS '146'.
  SET TITLEBAR '146'.

  TYPE-POOLS : VRM.


  SELECT *
     FROM ZPROJECT_YEAR
    INTO TABLE YEAR_DETAILS WHERE EMP_ID = ZPROJECT_EMP-EMP_ID.

  LOOP AT YEAR_DETAILS INTO TEMP_YEAR.

    WA_LISTBOX-KEY = TEMP_YEAR-START_DATE.
    WA_LISTBOX-TEXT = TEMP_YEAR-START_DATE.
    APPEND WA_LISTBOX TO IT_LISTBOX.
  ENDLOOP.

  LD_FIELD = 'START_DATE'.
  CALL FUNCTION 'VRM_SET_VALUES'
    EXPORTING
      ID     = LD_FIELD
      VALUES = IT_LISTBOX.
  REFRESH IT_LISTBOX.

  SELECT *
       FROM ZPROJECT_YEAR
    INTO TABLE YEAR_DETAILS WHERE EMP_ID = ZPROJECT_EMP-EMP_ID.

  LOOP AT YEAR_DETAILS INTO TEMP_YEAR.

    WA_LISTBOX-KEY = TEMP_YEAR-END_DATE.
    WA_LISTBOX-TEXT = TEMP_YEAR-END_DATE.
    APPEND WA_LISTBOX TO IT_LISTBOX.
  ENDLOOP.

  LD_FIELD = 'END_DATE'.
  CALL FUNCTION 'VRM_SET_VALUES'
    EXPORTING
      ID     = LD_FIELD
      VALUES = IT_LISTBOX.
  REFRESH IT_LISTBOX.

ENDMODULE.                 " STATUS_0146  OUTPUT
*&---------------------------------------------------------------------*
*&      MODULE  USER_COMMAND_0146  INPUT
*&---------------------------------------------------------------------*
*       TEXT
*----------------------------------------------------------------------*
MODULE USER_COMMAND_0146 INPUT.
  CASE SY-UCOMM.

    WHEN 'EXIT'.
      LEAVE PROGRAM.

    WHEN 'CANCEL'.
      CLEAR : USER_ID , PASSWORD.
      CALL SCREEN 1000.

    WHEN 'BACK'.
      CLEAR : START_DATE , END_DATE , ZPROJECT_DETAILS , ZPROJECT_RECORD , ZPROJECT_EMP , ZPROJECT_RESULT.
      CALL SCREEN 145.

    WHEN 'OK'.
      CLEAR : START_DATE , END_DATE , ZPROJECT_DETAILS , ZPROJECT_RECORD , ZPROJECT_EMP , ZPROJECT_RESULT.
      CALL SCREEN 144.

  ENDCASE .
ENDMODULE.                 " USER_COMMAND_0146  INPUT