Skip to Content
0
May 31, 2011 at 03:28 PM

Select Columns from a ALL Entry table

34 Views

TYPES: BEGIN OF ty_block1,

werks TYPE likp-werks,

lfdat TYPE likp-lfdat,

lfart TYPE likp-lfart,

vbeln TYPE likp-vbeln,

END OF ty_block1.

DATA: li_block1 TYPE STANDARD TABLE OF ty_block1.

DATA: li_block2 TYPE STANDARD TABLE OF ty_block2.

SELECT likpwerks likplfdat likplfart likpvbeln

INTO TABLE li_block1

FROM likp

INNER JOIN lips ON lipsvbeln = likpvbeln

WHERE likp~werks IN s_werks

SELECT ????? (Don´t allow me to select liblock1 fields in this area)

INTO TABLE li_block2

FROM vbfa

FOR ALL ENTRIES IN li_block1

WHERE vbfa~vbelv = li_block1-vbeln.

ENDIF.

Any idea to extract data from li_block1 table into li_block2 table (i.e li_block1-fdat or li_block1-werks)?

Thanks in advance