Solved: Re: regarding GET and PROVIDE coding

Former Member · ‎2007 Mar 10

HI GURUS,

cud u plz explain the given statement:::::HOW does it work.

*****************************

GET pernr.

PROVIDE * FROM p0001

BETWEEN pybegda AND pyendda.

ENDPROVIDE.

Former Member · ‎2007 Mar 10

Hi ,

Get pernr works as select from table .

and provide * from p0001 is like

select * from p0001 .

endselect .

Please reward if useful.

Former Member · ‎2007 Mar 10

Hi ,

Get pernr works as select from table .

and provide * from p0001 is like

select * from p0001 .

endselect .

Please reward if useful.

Former Member · ‎2007 Mar 10

Hi ravi,

GET PERNR :

This event fills the data structures of declared infotypes with all records that exists for a personnel number.

Data selection does not delimit the records that retrieved from the database.

then provide ......endprovide:it retreives the data from p0001 table which is in between the dates pybedda and pyendda.

Former Member · ‎2007 Mar 10

hi srilatha,

cud u plz explain this in a simple way,

********

the answer u have given....

This event fills the data structures of declared infotypes with all records that exists for a personnel number.

Data selection does not delimit the records that retrieved from the database.

Former Member · ‎2007 Mar 10

Hi..

GET:

Use GET to handle two types of events after submitting executable programs: Get events and events at the end of a hierarchy level of a logical database. If during a GET event a list is written, previously an automatic line feed is created.

Provide....

The statements PROVIDE and ENDPROVIDE define a loop through a statement block. In this loop, any number of internal tables itab1 itab2 ... are processed together. A single table can appear several times. For every table itab you must specify a FIELDS clause. After FIELDS you must specify the character * for all components or a list comp1 comp2 ... for specific components of the relevant table. The names of the components comp1 comp2 ... can only be specified directly.

Suresh

Former Member · ‎2007 Mar 10

hi Ravi,

Consider the following example:

tables:
      PERNR.
Infotypes:
      0001,
      0002.

get pernr.
     provide * from p0002 between pn-begda and pn-endda.
            write......
     endprovide.

The GET PERNR statement, pulls all records corresponding to a

personal number from infotypes 0001 and 0002, to internal tables P0001

and P0002 respectively(P0001 and P0002 are not declared in our program,

but they exist in the logical database PNP. There can be multiple

records in these infotypes for a singel pernr, based on BEGDA

and ENDA (validity period).

So Provide...Endprovide is used to loop through these records, one by one..(provide..endprovide can be replace with loop at p0002..endloop statement as well).

Hope this helps,

Sajan Joseph.