Logical Database with Report HR Report Category Selection Screen

Author       : P. Surjith Kumar

Company  : International Application Solutions Pte Ltd (IAS) – An IBM Company, Singapore.  http://www.ias.com.sg/

Created on : 17th Sep 2011

Author Bio 

I am working as Senior IT Consultant for the Past 5 Years.

Business Scenario

Need to create a Logical Database with custom HR Report Category in a selection Screen

Steps to Create

1)  Create an Executable Program

2)  Assign PNPCE in the Logical Database

3)  Choose the  HR Report Category 

4)  Create custom ‘Report Category ‘

5)  Select the field ‘Selection Period’ and In ‘Report Category ‘ assign the necessary field for the selection screen

6)  Write the Program code

7)  Activate it and Test it

 1) Create an Executable Program

2) Assign PNPCE in the ‘Logical Database’ and click ‘HR report category’ push button

 

3) Then Click the push button ‘Report Category’


4) Create custom ‘Report Category ‘, then click the “New Entries”

5) Select the field ‘Selection Period’ and In ‘Report Category ‘assign the necessary field for the selection screen. Uncheck the unwanted selection period.

Click the “Allowable selection Criteria” as highlighted 

Choose the necessary selection field from the F4 Help 


Save it

6) Write the Program code


*&---------------------------------------------------------------------*
*& Report  ZHRBNR001_ENT_ADJ_PRGM
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*

REPORT  zhrbnr001_ent_adj_prgm using database pnp message-id zhrpa.
*----------------------------------------------------------------------*
* Author                : P Surjith Kumar
*----------------------------------------------------------------------*

INCLUDE zhrbnr001_top.

INCLUDE zhrbnr001_f01.

*-----------------------------------------------------------------------
*  START-OF-SELECTION.
*-----------------------------------------------------------------------
START-OF-SELECTION.

GET peras.

*-----------------------------------------------------------------------
*  END-OF-SELECTION.
*-----------------------------------------------------------------------
END-OF-SELECTION.



*&---------------------------------------------------------------------*
*&  Include           ZHRBNR001_TOP
*&---------------------------------------------------------------------*

*
INCLUDE <CL_ALV_CONTROL>.
*
TABLES:  pernr.

NODES: peras.

INFOTYPES : 0171,0377, 2001, 0002.

DATA: gv_rows TYPE i.

*----------------------------------------------------------------------*
**          SELECTION SCREEN
**----------------------------------------------------------------------*
SELECTION-SCREEN BEGIN OF BLOCK 01 WITH FRAME TITLE text-001.
SELECT-OPTIONS: s_barea FOR p0171-barea,                   " CHAR  2 0 Benefit area
                s_bengr FOR p0171-bengr,                   " CHAR  4 0 Benefit First Program Grouping
                s_bstat FOR p0171-bstat,                   " CHAR  4 0 Benefit Second Program Grouping
                s_bplan FOR p0377-bplan.                   " CHAR  4 0 Benefit plan

SELECTION-SCREEN END OF BLOCK 01.

SELECTION-SCREEN BEGIN OF BLOCK 02 WITH FRAME TITLE text-002.
PARAMETERS:     p_tstrun AS CHECKBOX.                      " TestRun
SELECTION-SCREEN END OF BLOCK 02.

) Activate it and Test it


Labels

logical logical Delete
database database Delete
r r Delete
report report Delete
category category Delete
selection selection Delete
screen screen Delete
hr hr Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.