topic Re: Reg : Logical DB's in Application Development and Automation Discussions

Reg : Logical DB's

mallikarjun_vaja — Mon, 18 Jun 2007 13:09:10 GMT

hi,

Iam using LDB : PSJ

My question is : How can we restrict the data when we are using LDB's?

or more clearly

Can we add any field to the selection screen Of LDB's?I mean can we change the own selection screen of LDB's and add a new filed?

regards

vaja

Re: Reg : Logical DB's

Former Member — Mon, 18 Jun 2007 13:13:56 GMT

Hi,

When you use the GET <Node Name>, then use the CHECK statment, if the CHECK statment failes then do not insert these values to the Internal table ...

To add your Fields to the selection screen, then Use the Normal PARAMTERS, SELECT-OPTIONS then the fields will be added to the Selection screen ......

Regards

Sudheer

Re: Reg : Logical DB's

Former Member — Mon, 18 Jun 2007 13:15:30 GMT

Goto attributes->

HR report Category

Master data-->f4

here you can choose the way you want your selection screen to be

thnkx

bhanu

Re: Reg : Logical DB's

mallikarjun_vaja — Mon, 18 Jun 2007 14:17:52 GMT

hi bhanu,

when I goto Attributes,I could not find HR report Category.

Can u Plz explain elaborately....

regards

Vaja

Re: Reg : Logical DB's

Former Member — Mon, 18 Jun 2007 14:32:33 GMT

HR Report category is only for HR LDBs PNP PNPCE and not for anyother LDBs as far as I know.

You can include parameters and select-options in the report and they will appear at the bottom of the standard selection-screen.

I have not worked on the LDB you mentioned but can tell you how data is fetched/filtered for PNP LDB. It may be helpful.

For the criteria entered on the selection screen, ldb checks if any of the record satisfy the condition for the PERNR . If yes, irrespective of the date range it selects all the records pertaining to the PERNR into the internal tables for the infotypes declared. You need to use macros to select the required record and if you don't want to process any record, use REJECT.

Always check if all the selection-screen criteria is being satisfied using IF conditions or CHECK when you are using ldbs.

Regards

Navneet

Re: Reg : Logical DB's

mallikarjun_vaja — Mon, 18 Jun 2007 14:43:35 GMT

Hi bhanu,

I got the HR report Category

But iam using LDB : PSJ ...It does not have the option HR report Category..

so can u plz tell any other option?

Regards

Vaja

Re: Reg : Logical DB's

Former Member — Mon, 18 Jun 2007 14:47:34 GMT

You can add ur own fields to the selection screen using code. Do the normal declaration for Selection-screen. It will appear at the bottom of selection screen provided by LDB.

In case if you want to remove any selection screen fields of LDB then use AT SELECTION-SCREEN OUTPUT event to enable/disable the fields in LDB selection screen.

Reward if its useful.

Regards,

Sail

Re: Reg : Logical DB's

Former Member — Mon, 18 Jun 2007 14:52:24 GMT

Go to SE36

enter the LDB PSJ

see the Tables used in structure

go to the Selections and see the Selection screen of that LDB

If you have the Access key yes, you can change/add the extra field on the selection screen.

Reward points for useful Answers

Regards

Anji

Re: Reg : Logical DB's

Former Member — Mon, 18 Jun 2007 14:56:47 GMT

Do the following.

SELECTION-SCREEN BEGIN OF SCREEN 1001 TITLE screen

AS WINDOW.

parameters: p_second as checkbox default 'X'.

SELECTION-SCREEN END OF SCREEN 1001.

INITIALIZATION.

CALL SELECTION-SCREEN 1001.

This will directly take you to the selection-screen 1001 which you can have the way you like.

Regards

Navneet

Re: Reg : Logical DB's

mallikarjun_vaja — Mon, 18 Jun 2007 16:20:39 GMT

Hi ,

I want to add the fields in the selection screen of LDB : PSJ.

Not after the selection screen..but in that stanadard selection screen .

waiting for ur reply

regards

vaja

Re: Reg : Logical DB's

Former Member — Mon, 18 Jun 2007 17:10:10 GMT

Go to tcode SLDB, give the LDB name. Select the radiobutton Selections and click on Change.

This will ask for access key. If you can get that, you can make whatever changes you want to make.

There is no other way.

Regards

Navneet