topic Re: Populating Complete Table Structure into Internal Table in Application Development and Automation Discussions

Populating Complete Table Structure into Internal Table

Former Member — Mon, 04 Jun 2007 14:50:29 GMT

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.

Re: Populating Complete Table Structure into Internal Table

suresh_datti — Mon, 04 Jun 2007 14:54:21 GMT

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

Re: Populating Complete Table Structure into Internal Table

Former Member — Mon, 04 Jun 2007 15:15:21 GMT

Hi Suresh,

After trying your solution I am getting error

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

Reagrds

Jitendra

Re: Populating Complete Table Structure into Internal Table

ferry_lianto — Mon, 04 Jun 2007 15:24:20 GMT

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

Re: Populating Complete Table Structure into Internal Table

Former Member — Mon, 04 Jun 2007 15:27:42 GMT

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