topic Re: Regarding Logical Databases in Application Development and Automation Discussions

Regarding Logical Databases

Former Member — Thu, 23 Oct 2008 12:02:41 GMT

Hi,

I have selected the logical dtaabase pnp in my attributs screen.

i have read that logical databases can have a maximum of 300 tables.

So what tables can i access using the pnp LDB.

Also i have heard that if we select a LDB a standard selection screen appears.

But in my case it does not appear.

Please help.

Thanks in advance,

Bala.

Re: Regarding Logical Databases

Former Member — Thu, 23 Oct 2008 12:06:13 GMT


> Also i have heard that if we select a LDB a standard selection screen appears.
> But in my case it does not appear.
.

please add the following statement in your program

TABLES: pernr.

Please check the link below

[Logical Databases |http://help.sap.com/saphelp_47x200/helpdata/en/9f/db9b5e35c111d1829f0000e829fbfe/content.htm]

and the following demo programs on LDB

DEMO_SELECTION_SCREEN_LDB_1

DEMO_SELECTION_SCREEN_LDB_2

DEMO_SEL_SCREEN_SELECT_LDB_1

DEMO_SEL_SCREEN_SELECT_LDB_2

Edited by: Rajesh on Oct 23, 2008 5:36 PM

Added additional info

Re: Regarding Logical Databases

KK07 — Thu, 23 Oct 2008 12:06:33 GMT

hi,

use the statements

TABLES :PERNR

INFOOTYPES:0001,....etc(as per ur requirement).

use GET PERNR (for ldb PNP )

and activate it.it should show u default selection-screen.

yes u can use max.300 dbtables in ldb.for the ldb PNP u can read infotypes related to PA,TM,etc..

Edited by: krishna kishore on Oct 23, 2008 5:38 PM

Re: Regarding Logical Databases

Former Member — Thu, 23 Oct 2008 12:06:54 GMT

declare node also

use get pernr

regards

vivek

Re: Regarding Logical Databases

Former Member — Thu, 23 Oct 2008 12:32:38 GMT

Thank you guys.

worked like a breeze!!!!!!!!!!!!!!!!!!!!!!!!!!!

Thank you all very much.

I have a doubt.

You told about infotypes : 0001....

But i heard infotypes statement is obsolste.

is it so

Thanks in advance,

Bala.

Re: Regarding Logical Databases

Former Member — Thu, 23 Oct 2008 12:47:40 GMT


> Thank you guys.
> worked like a breeze!!!!!!!!!!!!!!!!!!!!!!!!!!!
> 
> Thank you all very much.
> 
> 
> I have a doubt.
> 
> You told about infotypes : 0001....
> 
> But i heard infotypes statement is obsolste.
> is it so
> 
> Thanks in advance,
> Bala.

Yes, the "Infotypes" declaration is obsolete, you can replace the "infotypes" declaration with the declaration below

DATA:
  P0001 TYPE TABLE OF P0001.

Re: Regarding Logical Databases

Former Member — Thu, 23 Oct 2008 12:51:45 GMT

Thanks...

If i want to disable the selection screen what should i do

i got the selection screen by using nodes statement.

nodes pernr.

thanks in advance,

Bala.