topic Re: logical database in Application Development and Automation Discussions

logical database

Former Member — Fri, 22 Jun 2007 08:04:17 GMT

i want to use ligical database QMI to write a PM notifications notifications report. how do i use it to extract the required data, say notifications for a certain notification type. please expalin with an example code

Re: logical database

Former Member — Fri, 22 Jun 2007 08:07:41 GMT

Hi Willard ,

You will have to use the GET command.

Regards

Arun

Re: logical database

Former Member — Fri, 22 Jun 2007 08:08:46 GMT

Hi,

After declaration of the NODES, then use the GET statment to get the data from the NODES ..... then use the CHECK statment to check Notification type , if it passed then only insert the record into the Internal table ..

Regards

Sudheer

Re: logical database

Former Member — Fri, 22 Jun 2007 08:10:52 GMT

If you are not aware of the LDB , then don't use it

Sim paly write a report to get the all info of the PM noptifications

Just use a Select statement to the View <b>VIQMFEL</b> and fetch the data into an internal table and display all the needed fields in the output.

Reward points for useful Answers

Regards

Anji

Re: logical database

varma_narayana — Fri, 22 Jun 2007 08:12:18 GMT

Hi,

Plz Check the Logical Database definition in SE36

In the Structure of LDB - check out the Nodes (which are the DB tables)

In the report which is linked to the LDB

Declare the Nodes using the TABLES statement

Eg: Tables: MARA, MARC.

Display the data of the fields under the GET Event of the Respective table.

GET MARA.

Write:/ Mara-matnr.

GET MARC.

Write:/ Marc-werks.

Hope this gives the idea.

Regards,