‎2008 Mar 26 4:49 AM
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.
‎2008 Mar 26 4:54 AM
Hi,
Can you describe the structure of the internal table in which you are inserting records.
Regards,
Sandeep
‎2008 Mar 26 5:04 AM
DATA: T_KNA1 LIKE KNA1 OCCURS 0.
DATA: ST_KNA1 LIKE LINE OF T_KNA1.
Nw suggest.
‎2008 Mar 26 5:13 AM
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
‎2008 Mar 26 5:23 AM
Its a complete report without any includes.I used forms and I am sure I have activated everything.
‎2008 Mar 26 4:54 AM
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.
‎2008 Mar 26 4:56 AM
Hi,
check out the structure that u have used for TABLE T_KNA1 or u need to provide ur code for explanation
‎2008 Mar 26 4:57 AM
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.
‎2008 Mar 26 5:38 AM
THANKU FOR THE REPLY.
DATA: T_KNA1 LIKE KNA1 OCCURS 0.
DATA: ST_KNA1 LIKE LINE OF T_KNA1.
‎2008 Mar 26 5:44 AM
After decklaration FREE the internal table and try ones again.
Revrt back.
regards,
Naveen
‎2008 Mar 26 9:36 AM
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.