topic GET Statement in Application Development and Automation Discussions

GET Statement

Former Member — Thu, 14 Jun 2007 12:15:46 GMT

What is the Purpose of GET Statement,

When I say GET sflight, what will happens exactly.

Akshitha.

Re: GET Statement

Former Member — Thu, 14 Jun 2007 12:19:09 GMT

It is used in Logical data abses (LDB's)

define and attach the required LDB in the program attributes then in the code startof selection event you can write the command GET

GET KNA1.

it is similar to select * from KNA1.

It will fetch all records from KNA1 table

You can also use

GET KNB1 LATE...

see the doc on LDB's

A logical database is a special ABAP/4 program which combines the contents of certain database tables. You can link a logical database to an ABAP/4 report program as an attribute. The logical database then supplies the report program with a set of hierarchically structured table lines which can be taken from different database tables.

LDB offers an easy-to-use selection screens. You can modify the pre-generated selection screen to your needs. It offers check functions to check whether user input is complete, correct, and plausible. It offers reasonable data selections. It contains central authorization checks for data base accesses. Enhancements such as improved performance immediately apply to all report programs that use the logical database.

Less coding s required to retrieve data compared to normal internel tables.

Tables used LDB are in hierarchial structure.

Mainly we used LDBs in HR Abap Programming.

Where all tables are highly inter related so LDBs can optimize the performance there.

Check this Document. All abt LDB's

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.highlightedcontent?documenturi=%2flibrary%2fabap%2fabap-code-samples%2fldb+browser.doc

GO THROUGH LINKS -

http://www.sap-basis-abap.com/saptab.htm

http://help.sap.com/saphelp_nw04/helpdata/en/9f/db9bfa35c111d1829f0000e829fbfe/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/9f/db9b5e35c111d1829f0000e829fbfe/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/c6/8a15381b80436ce10000009b38f8cf/frameset.htm

/people/srivijaya.gutala/blog/2007/03/05/why-not-logical-databases

www.sapbrain.com/FAQs/TECHNICAL/SAP_ABAP_Logical_Database_FAQ.html

www.sap-img.com/abap/abap-interview-question.htm

www.sap-img.com/abap/quick-note-on-design-of-secondary-database-indexes-and-logical-databases.htm

http://help.sap.com/saphelp_nw04/helpdata/en/9f/db9b5e35c111d1829f0000e829fbfe/content.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/9f/db9bb935c111d1829f0000e829fbfe/content.htm

Gothru the blog which provides info on LDB's:

/people/srivijaya.gutala/blog/2007/03/05/why-not-logical-databases

Reward points for useful Answers

Regards

Anji

Message was edited by:

Anji Reddy Vangala

Re: GET Statement

Former Member — Thu, 14 Jun 2007 12:20:08 GMT

GET STATEMENT

The GET statement also enables you to specify a list of fields that are required in a report. Only these fields are read from the logical database. The connection between the GET statement and the SELECT statement is that in a database program the SELECT statement helps implement the GET statement. You are able to specify a field list in a GET statement only if the relevant logical database supports this option.

Functions

The term access optimization refers to the way that the query supports the use of field lists in SELECT and GET statements.

When an InfoSet is generated, a reference list is created containing all the fields that are needed in a query when the InfoSet is used.

Using additional tables and coding segments (additional fields, coding for GET and GET LATE events, record processing) is more problematic, because additional tables and coding segments can also access fields that do not appear in the reference list. If you use ABAP coding, it can sometimes happen that the InfoSet does not contain all of the information that is needed to determine the required fields. If this is the case, the system generates an incomplete reference list. This can mean that when query reports are processed some of the required fields only ever contain their initial values.

The reference list ensures that the report generator is able to determine from the list of required fields, all of the fields that are needed if an additional table or coding is used. This information enables the report generator to specify field lists for all SELECT and GET statements that are generated.

regards

ravish

plz dont forget to reward points if helpful

Re: GET Statement

Former Member — Thu, 14 Jun 2007 12:24:31 GMT

GET -- >only for Parameter ID's (associated with Screen Fields of Transaction)

Re: GET Statement

Former Member — Thu, 14 Jun 2007 12:26:43 GMT

GET statement is an event used to access a particular node in the LDB -Logical Database.

an LDB is an hierarchial structured database ( hierarchy of nodes ) which can be used through SE36 t-code...

NODES: SPFLI, SFLIGHT, SBOOK.

GET SFLIGHT.

SKIP.

WRITE: / 'Carrid:', SFLIGHT-CARRID,

'Connid:', SFLIGHT-CONNID,

'Fldate:', SFLIGHT-FLDATE.

hope this helps u,

reward if useful..

Ginni

Re: GET Statement

Former Member — Thu, 14 Jun 2007 12:27:09 GMT

hi,

This is the most important event for executable programs that use a logical database.

It occurs when the logical database has read a line from the node <table> and made it available to the program in the work area declared using the statement NODES <table>.

When you define the corresponding event block in the program, you can specify a field list if the logical database supports field selection for this node:

GET <table> [FIELDS <f1> <f 2>...].

GET sflight means...

whenever the control encountere the statemnet GET sflight, then the logical database has read a line from the node sflight and it available to the program in the work area declared using the statement NODE sflight.

regards,

Ashokreddy.