Populating Complete Table Structure into Internal Table

[Former Member]

Hi All,

DATA: BEGIN OF I_VBAP OCCURS 100.

INCLUDE STRUCTURE VBEPVB.

DATA: END OF I_VBAP.

SELECT * INTO I_VBAP FROM VBUP

WHERE VBELN = VBAP-VBELN

AND POSNR = VBAP-POSNR

ORDER BY PRIMARY KEY.

APPEND I_VBAP.

ENDSELECT.

In the following code above I am getting the error as

<b>"The Type of DB table and work area (Internal Table) I_VBAP are not

Unicode Convertiable".</b>

Can any one help me in this matter?

Thanks in advance.

[suresh_datti]

data i_vbap type table of vbepvb.

SELECT * INTO table I_VBAP FROM VBUP

WHERE VBELN = VBAP-VBELN

AND POSNR = VBAP-POSNR

ORDER BY PRIMARY KEY.

~Suresh

[Former Member]

Hi Suresh,

After trying your solution I am getting error

<b>" You cannot Use Internal Table as Work Area".</b>

Reagrds

Jitendra

[ferry_lianto]

Hi,

Please try this.

DATA: WA_VBAP LIKE I_VBAP.

SELECT * 
INTO CORRESPONDING FIELDS OF WA_VBAP 
FROM VBUP
WHERE VBELN = VBAP-VBELN
  AND POSNR = VBAP-POSNR
ORDER BY PRIMARY KEY.
APPEND WA_VBAP TO I_VBAP.
ENDSELECT.

Regards,

Ferry Lianto

[Former Member]

Hello Jitendra,

Try

data i_vbap type table of vbepvb.

SELECT * from VBUP

into corresponding fields of table i_vbap

WHERE VBELN = VBAP-VBELN

AND POSNR = VBAP-POSNR

ORDER BY PRIMARY KEY.

Regards

Greg Kern