topic Re: Parameters in a logical database in Application Development and Automation Discussions

Parameters in a logical database

Former Member — Fri, 16 May 2008 11:58:26 GMT

Hi all,

Why Parameters defined in a logical databse are not like those defined in a report program?

And what we can do with those one wich declare in a logical database?

Thanks.

Re: Parameters in a logical database

Former Member — Fri, 16 May 2008 12:06:41 GMT

In logical database the selection screen is already get created.

You can make it dynamic also.But you can not create a selection screen in your report if your report contains a logical database.

but you can check or restrict the select options.

I mean after entering values in selection screen ( coz of logical database) , then you can put check on the select options as per the requirement.

Re: Parameters in a logical database

Former Member — Fri, 16 May 2008 12:13:51 GMT

Hi,

When ever you mention LDB in your program attributes, there is one option for report categories.

you can mention the report category also.

If you execute the program the program will display the screen which contains the parameters or select options for that report category.

Goto the transaction SM30 and check the view V_T599F.

Also check the tables T599C for report categories and T599W for HR report categories.

Edited by: Velangini Showry Maria Kumar Bandanadham on May 16, 2008 2:14 PM

Re: Parameters in a logical database

Former Member — Fri, 16 May 2008 12:15:38 GMT

If U don't want to use any of the parameters given by LDB

.. then U need to change the Report category ...

If UR using LDB PNP and U don't want the default selection

screen then use '_____000' in the report category ..

(No selection criteria for DB PNP) .. declare your own

parameters/select-options

Re: Parameters in a logical database

Former Member — Fri, 16 May 2008 14:48:06 GMT

Hi,

in a fact, I want to know what can I do with a parameters data defined in a logical data base !

Re: Parameters in a logical database

Former Member — Fri, 16 May 2008 19:54:18 GMT

hi check this..

if you want to get the data from the LDB you can give the values in the standard screen given and execute it will work like a report but what happens here is the screen comes automatically...and you can disable the screen as said by srinivas gurram reddy....check the simple program...

with logical data base..PNP. copy this and execute it and give the values in the selection screen...

TABLES:PERNR.

INFOTYPES:0002,0008.

GET PERNR.

PROVIDE * FROM P0002 BETWEEN PN-BEGDA AND PN-ENDDA.

ENDPROVIDE.

PROVIDE * FROM P0008 BETWEEN PN-BEGDA AND PN-ENDDA.

ENDPROVIDE.

IF SY-SUBRC = 0.

WRITE:/ P0002-PERNR,P0002-BEGDA,P0002-ENDDA,P0002-VORNA,P0008-ANSAL,P0008-PREAS.

ENDIF.

regards,

venkat