topic Re: changing Fields in LDB..? in Application Development and Automation Discussions

changing Fields in LDB..?

Former Member — Thu, 12 Apr 2007 09:32:33 GMT

HI experts please helpme.

According to our requirement selection screen should display “Cost center” & “Personnel Number”, for this I’m using LDB PNP.

Using Attributes HR report category, created my own report category with the name 1SFPWs for Master data Info types,

It is showing in selection screen, “Personnel Number”, Payroll area” & “Cost center”, but I require only “Personnel number” & “Cost center” only.

Re: changing Fields in LDB..?

Former Member — Thu, 12 Apr 2007 09:37:51 GMT

you can do it using selction-screen output event.

Check the screen attribute in debugging, like group, field name etc, and use the same to disable the elements.

Sample code is below,

AT SELECTION-SCREEN OUTPUT.

LOOP AT SCREEN.

IF SCREEN-GROUP3 = 'IXS'.

SCREEN-ACTIVE = '0'.

SCREEN-INVISIBLE = 1.

MODIFY SCREEN.

CONTINUE.

ELSEIF SCREEN-GROUP4 = '023'.

SCREEN-ACTIVE = '0'.

SCREEN-INVISIBLE = 1.

MODIFY SCREEN.

CONTINUE.

ELSEIF SCREEN-NAME = 'DD_BUKRS-LOW'.

SCREEN-REQUIRED = '1'.

MODIFY SCREEN.

CONTINUE.

ELSEIF SCREEN-NAME = 'DD_BUKRS-HIGH'.

SCREEN-ACTIVE = '0'.

SCREEN-INVISIBLE = 1.

MODIFY SCREEN.

CONTINUE.

ELSEIF ( SCREEN-GROUP3 = 'VPU'

AND SCREEN-GROUP4 = '007' ).

SCREEN-ACTIVE = '0'.

SCREEN-INVISIBLE = 1.

MODIFY SCREEN.

CONTINUE.

ELSEIF SCREEN-NAME = 'DUEDATE1'.

SCREEN-INPUT = 0.

MODIFY SCREEN.

CONTINUE.

ENDIF.

ENDLOOP.

Re: changing Fields in LDB..?

Former Member — Thu, 12 Apr 2007 09:53:41 GMT

Hi Vamsi

as you are using your own report category you can select the number of feilds you need on your selection screen.

from SPRO when you go the report category screen double click on ur report category, now you will see <b>Allowable selection</b> at the left hand side double click on it and you will see a screen where all the selection screen feilds are dipslayed

just you need to tick the checkbox right beside the field you want to see on the screen rest you can leave like that.

Hope it helps you solve ur problem.

Plz reward points if helpful.

Regards

Zarina

Re: changing Fields in LDB..?

Former Member — Thu, 12 Apr 2007 09:54:41 GMT

Hi Vamshi,

Search for other HR Report Cateogry in that PNP .If you find it's OK.

Even you can modify that report category by pressing Search Report category..displays the screen, in that you can make the unwanted field to display.

other wise create you own Report category with those with Pernr and KOSTL fields and use.

But with PNP Even if Personal area is there along with Personal Number and Cost center on selection screen in what way it matters? I mean let it be there on selection screen.

I feel that it will not be a problem at all.

But the client still insists you can create your own and use.

reward if useful

regards,

ANJI

Message was edited by:

Anji Reddy Vangala

Re: changing Fields in LDB..?

Former Member — Thu, 12 Apr 2007 11:35:16 GMT

I’m using

pa0015-pernr,

pa0015-begda,

pa0015-betrg

pa0015-lgart.

Pa0001-pernr,

pa0001-kostl.

As per our requirement I need to fetch the data based on the cost center. I’m using LDB pnp, can you please help me for writing the querie to fetch the data. at least can you give idea how to proceed.

Thanks in advance.

Re: changing Fields in LDB..?

Former Member — Thu, 12 Apr 2007 11:51:01 GMT

hi vamsi

i donno wat feilds you are going to fetch but as you said while using the LDB

you need to define the node PERNR

then in the start of selection write

GET PERNR

this stament gets you the record of teh pernr you will give in the selection screen

and most importantly you will have to end the start of selection with end of selection.

Start-of-selection.

GET PERNR

PErform get_data.

all ur select queires.

end-of-selection.

You may also have to sue few funciton modules if you have to get data from Results table i.e RT tabel for payroll results.

so lemme know wat all data you are displaying in the output.

Regards

Zarina