topic Re: LDB in Application Development and Automation Discussions

LDB

Former Member — Wed, 25 Jun 2008 11:16:58 GMT

HI All,

When we write an LDB --GET node,on what selection criteria the records will be fetched from the db?

Thanks,

Rakesh.

Re: LDB

Former Member — Wed, 25 Jun 2008 11:21:53 GMT

HI,

LDB(logical DataBase) is provided with default selection screen and GET(fetching records) works based on the selection-screen criteria (that you entered on selection screen) that we got from that LDB.

Re: LDB

Former Member — Wed, 25 Jun 2008 11:22:44 GMT

hi Rakesh.

i found this in SAP documentation......it may b of yr help

If both GET node FIELDS f1 ...fn and GET node LATE FIELDS g1 ...gm occur in the program, values are assigned to all the fields f1, ..., fn, g1, ..., gm.

In addition to the specified fields, values are also assigned to the key fields of node.

If you use the FIELDS addition, you access only the specified fields.

thnx

prashant

Re: LDB

Former Member — Wed, 25 Jun 2008 11:22:57 GMT

in selection method of ldb you will mention your criteria

Re: LDB

Former Member — Wed, 25 Jun 2008 11:23:10 GMT

hiiii

yes..records will be fetched from database only ..GET is used to get data from tabes..or node..& LDB is actuallya logical database but it will fetch data from databse only

regards

twinkal

Re: LDB

Former Member — Wed, 25 Jun 2008 11:28:47 GMT

The following code is giving me an error although the LDB plpod is working fine in another program.what could be wrong?

tables : plpod.

parameters : p_PLNTY type PLNTY.

START-OF-SELECTION.

GET plpod.

end-of-selection.

Re: LDB

Former Member — Wed, 25 Jun 2008 11:30:51 GMT

Hi,

Ldb Itsele provide the Section criteria on Which records will be fetched,

But If you Mention Field sYou want To fetch Then It Fetch That particular Fields Only,

Here is one Demo program That can help You.

REPORT EVENT_DEMO.

NODES: SFLIGHT, SBOOK.

GET SFLIGHT FIELDS CARRID CONNID.

...

GET SBOOK FIELDS BOOKID.

...

GET SFLIGHT LATE FIELDS PLANETYPE.

...

In this case, the logical database reads the following fields:

u2022 MANDT, CARRID, CONNID, FLDATE, and PLANETYPE from SFLIGHT

u2022 MANDT, CARRID, CONNID, FLDATE, and BOOKID from SBOOK

I hope It will be helpful.

Thanks

Re: LDB

Former Member — Wed, 25 Jun 2008 11:35:11 GMT

Hi,

In the get Event Mention the Node name Not LDB name.

In Tables: mention Root Node(Table) for The LDB.

After you can Specify Table Name And even field names In GET Event you want to get Data.

Thanks

Re: LDB

Former Member — Wed, 25 Jun 2008 11:39:05 GMT

even after removing the parameters statment and witing only GET plpod it is giving error 'PLPOD is not a node of the logical database_S'.

Re: LDB

Former Member — Wed, 25 Jun 2008 11:43:01 GMT

Instead of 'plopd' Write The table name you have used In the Logical database.

In Get Event Mention The Table name of LDB And if posiible The Fields you want to get data.

Re: LDB

Former Member — Wed, 25 Jun 2008 11:48:58 GMT

Hi Rakesh,

LDB's have their own selection screen based on the data they hold.

The GET statement works based on the selection-screen criteria taht we enter in that selection screen of LDB.

Hope this helps you.

Regards,

Chandra Sekhar

Re: LDB

Former Member — Thu, 26 Jun 2008 06:24:54 GMT

how can i find the selection screen of the LDBs?I have my own selection screen.will these fields be taken as selection criteria?