get... and node

[Former Member]

Hi,

In one of the programs I was looking at today, there was a line that is similar to this:

tables: pernr.
get pernr.

Does this mean this pernr would automatically obtain all the pernr available in the database through t508s or other tables or the tables pernr defined here is initialized somewhere else (say a statement like

select * from t508s into pernr

) which I am not aware of? In that case, what exactly does this "get" statement here do?

Also, I have seen another line that says:

node: us_node type uspay_result.

what does a node do in ABAP? Does it have exactly the same meaning as in JAVA, i.e., a reference pointer with a name? And why in this case uspay_result is defined as a node? What exactly does this node point to? Does it point to some payroll table?

Comments from anyone is appreciated.

Thanks a lot!

Regards,

Anyi

[Former Member]

get pernr...this event is used in a program when data is read from logical database

[dani_mn]

HI,

<b>GET</b> is used to read data from the Node of a logical database.

If you check the attributes of program you will see the logical database name using in this program.

PERNR node is from logical database 'PNP'.

and if you open the 'PNP' in tcode 'SE36' you will see the structure of PNP and also the node 'PERNR' and all its sub node.

'GET pernr' start reading database from the node 'PERNR' and all its subsequent nodes will be read depending on the selection screen inputs.

REgards,

[Former Member]

Hi,

Now, what u`d seen is a program which uses the logical database PNP.

This logical database consists of several logically related data dictionary objects which includes the structure PERNR.

Now, you can use LDBs to fetch data from several dependent tables. Now, the interaction between your report program and the LDB Program happens through the GET Statement. For every corresponding GET event there is a PUT event available in the LDB Program. Thus, when you say GET PERNR, it dynamically calls the LDB Program and fetches the records ( for which there is a select query should be available in the LDB Program ).

NODE : Nodes are a type of global interface which acts a global work area in programs which uses LDB. So, if at all you`ll have to use LDB in ur program the statment NODES/TABLES are mandatory.

Hope this info. would serve ur purpose.

Reward points if convinced.

Regards

[andreas_mann3]

hi,

look

and this link:http://help.sap.com/saphelp_erp2005/helpdata/en/9f/db9b5e35c111d1829f0000e829fbfe/frameset.htm

Andreas

[Former Member]

Hi Anyi Zhu,

Get statement is used if they are using logical database to fetch the data from tables. you click

goto->attributes there you will come to know which logical database they are using, then double click on logical databse you will goto logical database program there they will use <b>select</b> statement and <b>Put</b> statement.

Regards,

Srinivas