topic Re: select for all entries statement in Application Development and Automation Discussions

select for all entries statement

Former Member — Thu, 12 Jun 2008 06:55:25 GMT

can some one send me a for allentries staterment for the following :

Tables : cvers, cvers_ref.

common field component.

very urgent.

points will be given....

Re: select for all entries statement

Former Member — Thu, 12 Jun 2008 07:00:48 GMT

Hi Venkat,

SELECT * FROM cvers
                INTO  it_cvers
WHERE <condition>.

IF NOT it_cvers IS INITIAL.
SELECT * FROM cvers_ref
               INTO IT_CVBERS_REF
FOR ALL ENTRIES it_cvers
WHERE COMPONENT = IT_CVERS-COMPONENT.
ENDIF.

Best regards,

raam

Re: select for all entries statement

Former Member — Thu, 12 Jun 2008 07:02:38 GMT

Hi!

DATA: gt_cvers LIKE STANDARD TABLE OF cvers,

gs_cvers LIKE LINE OF gt_cvers.

DATA: gt_cvers_ref LIKE STANDARD TABLE OF cvers_ref,

gs_cvers_ref LIKE LINE OF gt_cvers_ref.

SELECT-OPTIONS: s_comp FROM cvers-component.

SELECT * FROM cvers INTO TABLE gt_cvers

WHERE compnent IN s_comp.

IF sy-subrc = 0.

SELECT * FROM cvers_ref INTO TABLE gt_cvers_ref

FOR ALL ENTRIES IN gt_cvers

WHERE component = gt_cvers-component AND langu = sy-langu.

ENDIF.

Regards

Tamá

Re: select for all entries statement

Former Member — Thu, 12 Jun 2008 07:04:38 GMT

Hi,

why dont u use JOIN?

select <fields >
  into table itab
  from cvers as a inner join cvers_ref as b
  on a~component = b~ component
  where < condition>.

regards,

madhu

Re: select for all entries statement

Former Member — Thu, 12 Jun 2008 07:11:07 GMT

done