LDB

[Former Member]

HI All,

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

Thanks,

Rakesh.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

in selection method of ldb you will mention your criteria

[Former Member]

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

[Former Member]

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

[Former Member]

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'.

[Former Member]

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.

[Former Member]

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

[Former Member]

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