topic Re: GET statement in Application Development and Automation Discussions

GET statement

Former Member — Wed, 22 Nov 2006 13:22:29 GMT

HI all,

How does the GET statement work?

e,g GET kna1.

Rgards

saurabh

Re: GET statement

suresh_datti — Wed, 22 Nov 2006 13:25:29 GMT

its like a SELECT * from KNA1.. ENDSELECT.

It is used in Reports tied to a Logical DataBase.

~Suresh

Re: GET statement

Former Member — Wed, 22 Nov 2006 13:27:37 GMT

hi,

GET is a command used in logical databases for retreiving data in a heirarchial sequence manner. for eg.

GET MARA.

first it displays the parent node and it displays all the child nodes in a sequential manner.

cheers

srinivas

Re: GET statement

Former Member — Wed, 22 Nov 2006 13:29:11 GMT

Hi saurabh,

<b>GET is applicable for LDB (logical database programs only)

In normal programs, it won't work.</b>

1. To get a taste of it.

2. create a new z program.

3. while creating type PNP

in logical database field.

4. paste this code and execute.

REPORT ABC.

*----

infotypes : 0001.

TABLES : PERNR.

*----

GET PERNR.

WRITE 😕 PERNR-PERNR.

5. The selection screen which u see

is coming from logical database PNP program.

6. Execute

7. U will get a list of pernr.

regards,

amit m.

Re: GET statement

Former Member — Wed, 22 Nov 2006 13:29:33 GMT

Get statement is used to use the information stored in a logical database. A logical database is a "Special ABAP program, which provides other ABAP programs with data from the nodes of a hierarchical tree structure. Is linked either in the program attributes of an executable program to this program or is called using function module LDB_PROCESS. A logical database uses a hierarchical structure with nodes to link an ABAP database program and an own standard selection screen. You edit logical databases in the Logical Database Builder."

When you do get XXX, you get all the information related on the program you made for it.

Then you can use it as a normal internat table....

Hope this helps!!

Gabriel P.

Re: GET statement

Former Member — Wed, 22 Nov 2006 13:30:49 GMT

We are using this GET statement when we need to get the data from logical database.

Present more of the client are not accepted to use the Logical databases

IN HR-ABAP

We can use to get the entire data of perner

Eg: GET PERNER

Thanks

Sekhar

Re: GET statement

Former Member — Wed, 22 Nov 2006 13:34:14 GMT

Hi, Extending the previous answer.. When you call a GET statement in your program, there will be a corresponding PUT statement in the LDB which you would have defined in your program attributes. If you look into your LDB program, under the PUT statement you will find the SELECT... ENDSELECT. Meaning, when the GET statement is executed, the processor calls the corresponding PUT statement and retrieves the values and gives it back to the calling program.

Re: GET statement

Former Member — Wed, 22 Nov 2006 14:00:52 GMT

Hi,

GET command use in programme to use LDB ( Logical DB).

Pl explore SE36-> PNP.

Cheers.