topic provide endprovide usage in Application Development and Automation Discussions

provide endprovide usage

Former Member — Fri, 27 Apr 2007 07:53:37 GMT

can we use for all entries in statement along with provide endprovide ?

requirement is as :

Retrieval of Relevent Fields from PA0001 Table.

Retrieve Personnel number (PERNR)

Personnel Area (WERKS)

From Table PA0001

on the basis of Personnel number in the selection screen

and Start Date (BEGDA) less than sy-datum

and End Date (ENDA) greater than sy-datum.

Retrieval of Relevent Fields from PA0002 Table.

Retrieve Personnel number (PERNR)

Last name (NACHN)

First name (VORNA)

from table PA0002 on the basis of all entries in IT_PA0001 comparing personnel number (PERNR)

and Start Date (BEGDA) less than sy-datum

and End Date (ENDA) greater than sy-datum.

Put the retrieved value in an internal table

Re: provide endprovide usage

Former Member — Fri, 27 Apr 2007 08:19:11 GMT

Hi Rippy,

No, you cann't use FOR ALL ENTRIES with PROVIDE END PROVIDE, coz PROVIDE ENDPROVIDE is looping process, just like SELECT ENDSELECT.

And I don't suggest you to use PROVIDE ENDPROVIDE.

You can use FOR ALL ENTRIES, like here:


*get data from PA0001
SELECT PERNR WERKS
INTO TABLE IT_PA0001
FROM PA0001
WHERE PERNR EQ P_PERNR
      AND BEGDA < SY-DATUM
      AND ENDDA > SY-DATUM.

*get data from PA0002
IF IT_PA0001[] IS NOT INITIAL.
   SELECT PERNR NACHN VORNA
   INTO TABLE IT_PA0002
   FROM PA0002
   FOR ALL ENTRIES IN IT_PA0001
   WHERE PERNR = IT_PA0001-PERNR
        AND BEGDA < SY-DATUM
        AND ENDDA > SY-DATUM.  
ENDIF.

Regards,

Re: provide endprovide usage

Former Member — Fri, 27 Apr 2007 10:33:31 GMT

thanx Jatra...