selecion

[Former Member]

Hi All,

i have an internal table itab with 22 records . I have to select records from table febko based on key that kukey = itab-kukey.

How can i do this

[Former Member]

Hi,

Use for all entries

If not itab[] is initial.

Select * from febko into table itab1

for all entriesin table itab

where kukey = itab-kukey.

Endif.

<b>Reward if helpful.</b>

[Former Member]

Hi,

<b>use for all entries</b>

see this code.

PARAMETERS p_city TYPE spfli-cityfrom.

TYPES: BEGIN OF entry_tab_type,

carrid TYPE spfli-carrid,

connid TYPE spfli-connid,

END OF entry_tab_type.

DATA: entry_tab TYPE TABLE OF entry_tab_type,

sflight_tab TYPE SORTED TABLE OF sflight

WITH UNIQUE KEY carrid connid fldate.

SELECT carrid connid

FROM spfli

INTO CORRESPONDING FIELDS OF TABLE entry_tab

WHERE cityfrom = p_city.

SELECT carrid connid fldate

FROM sflight

INTO CORRESPONDING FIELDS OF TABLE sflight_tab

FOR ALL ENTRIES IN entry_tab

WHERE carrid = entry_tab-carrid AND

connid = entry_tab-connid.

<b>reward if helpful</b>

rgds,

bharat.

[Former Member]

Hi,

Select

FIELD1

FIELD1

FIELD1

FIELD1

FIELD1

FIELD1

FIELD1

FIELD1

FIELD1

Into table IT_ITAB_FEB from FEBKO

for all entries in ITAB

where kukey = itab-kukey.

Regards

Sudheer

[Former Member]

Hi,

You can use below code:

if not itab is initial.

select fieldnames from table febko into table <internal table> for all entries in itab where kukey = itab-kukey.

endif.

Thanks,

Sriram Ponna.

[Former Member]

hi,

Hi,

Use for all entries

If not itab[] is initial.

Select * from febko into table itab1

for all entriesin table itab

where kukey = itab-kukey.

Endif.

if helpful reward some points.

with regards,

Suresh Aluri.