GET statement

[Former Member]

HI all,

How does the GET statement work?

e,g GET kna1.

Rgards

saurabh

[suresh_datti]

its like a SELECT * from KNA1.. ENDSELECT.

It is used in Reports tied to a Logical DataBase.

~Suresh

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

Hi,

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

Pl explore SE36-> PNP.

Cheers.