Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

runtime error

Former Member
0 Likes
980

Hi,

I faced a runtime error stating that, you have attempted to extend an internal table but the required space is not available

for the select query.can anyone say wht wud b the problem?

SELECT KUNNR

NAME1

FROM KNA1

INTO CORRESPONDING FIELDS OF TABLE T_KNA1

FOR ALL ENTRIES IN T_VBPA

WHERE KUNNR = T_VBPA-KUNNR.

10 REPLIES 10
Read only

Sandeep_Panghal
Product and Topic Expert
Product and Topic Expert
0 Likes
962

Hi,

Can you describe the structure of the internal table in which you are inserting records.

Regards,

Sandeep

Read only

0 Likes
962

DATA: T_KNA1 LIKE KNA1 OCCURS 0.

DATA: ST_KNA1 LIKE LINE OF T_KNA1.

Nw suggest.

Read only

0 Likes
962

Hi,

I think you havent Activated the Total program( all includes within your program).

Try to activate the include which u defined and ofcourse all the includes related tour program.

Revert back ..

Regards,

Naveen

Read only

0 Likes
962

Its a complete report without any includes.I used forms and I am sure I have activated everything.

Read only

Former Member
0 Likes
962

Make sure T_VBPA is not INITIAL before the select statement. Also posting the definitions of T_KNA1 and T_VBPA might help for better advices.

Read only

Former Member
0 Likes
962

Hi,

check out the structure that u have used for TABLE T_KNA1 or u need to provide ur code for explanation

Read only

Former Member
0 Likes
962

Hi divyasree kintali,

1. Can you please tell the structure of table T_KNA1 ?

2. Try with this ...

If not T_VBPA[] is initial.

SELECT KUNNR

NAME1

FROM KNA1

INTO CORRESPONDING FIELDS OF TABLE T_KNA1

FOR ALL ENTRIES IN T_VBPA

WHERE KUNNR = T_VBPA-KUNNR.

endif.

Hope this might be helpful

Cheers

Kripa Rangachari.

Read only

0 Likes
962

THANKU FOR THE REPLY.

DATA: T_KNA1 LIKE KNA1 OCCURS 0.

DATA: ST_KNA1 LIKE LINE OF T_KNA1.

Read only

0 Likes
962

After decklaration FREE the internal table and try ones again.

Revrt back.

regards,

Naveen

Read only

0 Likes
962

Thanku for the reply.

Nw I am facing time_out error.

I am selecting from VBFA table where I have used only 2 key fields in condition stmt, although there are 5 key fields for that table.

Wht exactly I dont know,but I am facing time_out error at this select stmt.

TYPES: BEGIN OF TY_DELIVERIES,

VBELN TYPE VBELN_VL,

POSNR TYPE POSNR_VL,

NTGEW TYPE NTGEW_15,

WADAT_IST TYPE WADAT_IST,

UECHA TYPE UECHA,

LFIMG TYPE LFIMG,

ERDAT TYPE ERDAT,

ERZET TYPE ERZET,

GEWEI TYPE GEWEI,

END OF TY_DELIVERIES.

DATA: T_DELIVERIES TYPE TY_DELIVERIES OCCURS 0.

DATA: ST_DELIVERIES LIKE LINE OF T_DELIVERIES.

-

-

-

IF NOT T_DELIVERIES[] IS INITIAL.

SELECT MANDT VBELV POSNV VBELN POSNN INTO TABLE T_VBFA FROM VBFA

FOR ALL ENTRIES IN T_DELIVERIES

WHERE VBELN EQ T_DELIVERIES-VBELN

AND POSNN EQ T_DELIVERIES-POSNR

AND VBTYP_V IN ('C' , 'H').

ENDIF.