Want to have own selection screen in HR-ABAP report using LDB

[Former Member]

Hi experts,

I am working on HR-ABAP report using LDB pnp and infotypes..But, here we get the built in selection criterion..but I want my own selection screen to be displayed..whats the solution for this??? Is it possible to create my own selection screen instead of default one..and how???

Please help me..its very urgent..

[suresh_datti]

You can create your own report ctageory.. in the report attributes click on report category & click on create..

~Suresh

[Former Member]

Hi Suresh.

please tell me the steps to create own selection screen instead of default one..and then how to assign in report???

[Former Member]

Hi,

chk this out:

Create Report Categories

In this step, you define the report categories and determine the layout

of the standard selection screen for these report categories. You can

create report categories for programs or queries that are based on the

PNP or PNPCE logical databases.

The definition of report categories is divided into two sections:

o In the Change Report Category view, you define general attributes

such as sort order, input fields for date, and so on.

o In the Change Selection Criteria view, you define which selection

fields of the logical database should be avaliable on the selection

screen.

Example

You want to set up your system so that your employees can only start

evaluation reports for Payroll if they use a payroll area. Within a

payroll area, you should be able to select according to personnel

number. Additional selection criteria should not be possible and you

should not be allowed to enter a sort sequence.

Standard settings

The standard system already contains report categories. You can find the

attributes of the report categories in the table.

Note the following five report categories in particular:

o Report category ' ' is the SAP default report category for

programs that are based on the PNP logical database.

o Report category PNPCE is the SAP default category for programs that

are based on the PNPCE logical database.

o Report category '00000000' is the customer-specific default category

for programs that are based on the PNP logical database.

o Report category '0PNPCE' is the customer-specific default category

for programs that are based on the PNPCE logical database.

o Report category __X2001 is the default category for Queries that

are based on an InfoSet of the PNP LDB.

o Report category QUEPNPCE is the default category for queries that

are based on an InfoSet of the PNPCE LDB.

The default report categories are used when a report is called if

the report has not been assigned a report category.

Parameters and Options for Report Categories of the LDB PNP and PNPCE

Parameters and Options in Screen Area General Data

If you activate this parameter, you can only enter data on the data

selection period if you use reports that have been assigned. The

same date entries are then used for the person selection as for the

date selection.

o Matchcode allowed

If you activate this parameter, you have use of a Matchcode

pushbutton (search help) if you use reports that have been assigned.

This pushbutton enables you to perform the person selection.

o Sort allowed

If you activate this parameter, you have use of a Sort pushbutton if

you use report that have been assigned. This pushbutton enables you

to define a sort order before you execute the report.

o Organizational structure allowed

If you activate this parameter, you have use of an Org.Structure

pushbutton if you use reports that have been assigned. This

pushbutton enables you to perform the person selection.

Note:

For more information about these options, see the online

documentation under this path:

SAP Library -> Human Resources -> Reporting in Human Resources

Management -> Standard HR Reports -> Report Selection Screen in

Human Resources Management.

Parameters and Options in Screen Areas Data Selection Period/Person

Selection Period/Payroll Area/Period/Year

o Options for data selection period and person selection period (key

date and so on)

Here you define which options for date and person selection are

available for reports that have been assigned.

o Options for payroll area/period/year

Here you define which options for selection using payroll

area/period/year are available for reports that have been assigned.

Parameters and Options in Screen Area Selection View

o Type/Name

This parameter enables you to use selection views to define report

categories. You use the selection view selected here to determine

which fields are available in the Dynamic Selectionsy.

Note:

You create selection views for the PNP and PNPCE logical databases

in the Object Navigator (SE80):

1. Start the Object Navigator (SE80)

2. Choose Workbench -> Edit Object.

3. Choose the More... tab page and the Selection view on this tab

page.

4. Choose Create.

5. In the Create Selection View dialog box, choose the For any

tables option.

6. In the Name of view field, enter a name for your selection view.

7. In the Tables dialog box, enter the name of the table from which

you want to use fields.

Note:

When you enter the table name, observe the naming convention in

Personnel Administration:

Infotype number: nnnn -> table name: PAnnnn

8. Choose Continue.

9. In the Functional groups area, define functional groups by

assigning a name and a number.

10. Assign fields from the selected tables to the functional groups

by entering the number of the desired functional group in front of

each field.

11. Save your entries.

For more information about adjusting the dynamic selections using

your own selection views, see the online documentation under the

following menu path:

SAP Library -> Human Resources -> Reporting in Human Resources

Management -> HR Standard Reports -> Report Selection Screen in

Human Resources Management -> Enhancing the Selection Screen -

Dynamic Selections.

If you do not want to offer dynamic selections, make the following

settings:

- LDB PNP: In the Selection view field, enter PNP_NO_FREE_SEL.

- LDB PNPCE: Leave the Selection view field empty.

Parameters and Options in Screen Area Data Selection Period/Person

Selection Period/Payroll Area/Period/Year

o Available input parameters, date or period entry (today, key date,

all, and so on), and standard value.

Using the Standard value option, you define which of the selected

options is shown.

Parameters and Options in Screen Area CE Selection Fields

o CE selection fields (external person ID, grouping reason, grouping

value)

Using the options in this area, you define whether the external

person Id, grouping reason, or grouping value are available on the

selection screen.

Note:

These parameters are only relevant for you if you implement

Concurrent Employment (see also note 517071).

Parameters and Options in Screen Area Selection view

o Dynamic selections as dialog box

If this switch is set, you can call the dynamic selections as a

dialog box.

o Dynamic selections active

If this switch is set, the dynamic selections of the logical

database are active at the start of the report.

Note that the following combinations are possible for the last two

options mentioned:

Dyn.Sel. as dialog box/Dyn.Sel. active: inactive/inactive

Dyn.Sel. as dialog box/Dyn.Sel. active: inactive/active

Dyn.Sel. as dialog box/Dyn.Sel. active: active/inactive

Activities

1. Choose Edit -> New entries.

2. Enter an abbreviation and a long text for the report category.

The customer name range for report categories is 0-9.

3. Select the For the PNPCE logical database checkbox, if you want to

create a report category for a program or for queries of the PNPCE

logical database.

4. In the General Data screen area, choose the desired options.

If you want to use selection IDs, you must have first created and

grouped selection Ids. The IMG path to do this is given in the

parameter description section.

5. In the Data selection period/person selection period or Selection

period screen area, choose the desired options.

6. In the Selection view screen area, choose the desired options.

7. In the CE selection fields screen area, choose the desired (only

possible for report categories of the LDB PNPCE).

8. Save your entries.

9. Choose the subactivity Permitted selection criteria.

10. Choose Edit -> New entries.

11. In the Select option field, use the input help to select each field

that should be available on the selection screen.

12. Select the checkbox in the 1.page column, if you want this selection

field to be available directly when you call the selection screen.

Further notes

13. If you want to copy entries, you still have to enter the selection

parameters again in the subsequent screen.

o If you create the report category '000000000', a selection screen is

generated according to report category '00000000'for all reports for

which a report category has not explicitly been assigned.

Assign Report Categories

In this step, you assign a report category to your reports.

Example

You have created your own report, for example ZPCTEST1, and would like

it to have the selection screen that corresponds to that of the

evaluation report for Payroll, which is assigned to report category

'__M00001'.

Assign report category '__M00001' to the report.

Requirements

You must have defined the Report Categories.

Standard settings

SAP Standard Reports:

In the standard system, reports are assigned a report category. If you

want to override these assignments, perform the activities described

here. If you want to assign report categories to standard reports using

SE38, this represents a modification.

Customer-Specific Reports:

For reports you have developed yourself, you can either assign report

categories by performing the activities described here or directly in SE38.

Recommendation

Only assign a report category if you have created your own reports or if

the selection screens in the standard system do not meet your

requirements.

Activities

1. Choose Edit -> New entries.

2. Perform the required assignment using the Program name and Report

category fields.

3. Save your entries.

• reward if helpful

regards,

madhumitha

[Former Member]

Hi Ujjwala,

In the<b> atribute</b>s window of report after u give the LDB name in the window there, and press enter to save, u will get a <b>button named "Report Category"</b> below there.

Press it, give any name that u want to give to ur report category and click <b>CREATE</b>.

in this category u can <b>choose the fields that u want to display on the selection screen</b>.

<b>Report Category Determines the Default auto generated selection screen of the LDB PNP.</b>

<b>moreover </b>u can define your own selection screen fields as well in your program just as we do in any report using Select-options and Parameters Statements.

these fields will b dispalyed <b>below </b>the standard fields on selection screen.

so in Report category if you have not selected any field to b there on Selection screen just those fields will b there on selection screen which u define in the program,

Hope this helps,

<b>Reward the answer with points if Helpful,</b>

Regards,

Tejas

[Former Member]

Hii Tejas,

thanks for ur help..I wanted to create my own selection screen using report category..but I am not getting where to insert my own parameters there..Ia m not going to select ne default fields ...as u told I search in report category..but I didnt find ne related ...

please, tell me how to do it???

sorsy for distrubing u...

[jayanthi_jayaraman]

Hi,

Check this link.

http://www.sapdevelopment.co.uk/hr/hr_repcat.htm

[Former Member]

hi ujjwala,

refer to this thread:

regards,

madhu

[Former Member]

hi

good

you can create your own selection screen using the Screen Painter,as per your requirement and you can use them.

Thanks

mrutyun^

[Former Member]

1) if u want to create ur own report category then do it as per suggested by Suresh.

2) if u want to add ur parameters too then simply declare ur parameters in the program and then thy will available with the report categories parameters on selection screen.

amit