select for all entries statement

[Former Member]

Hi

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....

[Former Member]

Hi

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....

[Former Member]

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

[Former Member]

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á

[Former Member]

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

[Former Member]

done