Runtime errors - if any one can help me

[Former Member]

Runtime Errors DBIF_RSQL_INVALID_RSQL

Exceptn CX_SY_OPEN_SQL_DB

Date and Time 31.05.2007 17:15:10

Above said errors, i m getting while executing the below mentioned script

SELECT PLANT CREATION_DATE SHIFT DESIGN_NUMBER GROUP_MACHINE MACHINE_NO ACTUAL_TURNS PRODUCE_PIECE FABRIC_WIDTH

ACTUAL_STITCH RUNNING_TIME TARGET_STITCHES AUFNR RSPEED

VBELN OPENING_ENTRY CLOSING_ENTRY

FROM ZPP_EMB_PROD

INTO TABLE IT_PROD

WHERE PLANT IN P_WERKS

AND GROUP_MACHINE IN P_MGROUP

AND MACHINE_NO IN P_MNO

AND CREATION_DATE IN P_DATE.

SG

Mumbai

[Former Member]

hi,

if the lenth of your query exceded the limit of 72 character... then sometime it gives dump.

or try "into corresponding fields of table"

regards,

shardul shah

[Former Member]

try to use

From ZPP_EMB_PROD

into corresponding fields of table IT_PROD

Might the field sequence giving problem while updating into internal table.

Regards

Nilesh shete

[Former Member]

1. check the datatypes fields of IT_PROD is matched with what u are passing.

2. Use 'Into corresponding fields of IT_PROD' in your select.

as its a selext query, the runtime error may occur only when type missmatch.

[Former Member]

hi,

if the lenth of your query exceded the limit of 72 character... then sometime it gives dump.

or try "into corresponding fields of table"

regards,

shardul shah

[Former Member]

1. make sure that the fields mentioned in select are in the same order in itab

IT_PROD

2. if all the fields in IT_PROD are not mentioned in select then use

INTO CORRESPONDING FIELDS OF TABLE IT_PROD

SELECT PLANT CREATION_DATE SHIFT DESIGN_NUMBER GROUP_MACHINE MACHINE_NO ACTUAL_TURNS PRODUCE_PIECE FABRIC_WIDTH

ACTUAL_STITCH RUNNING_TIME TARGET_STITCHES AUFNR RSPEED

VBELN OPENING_ENTRY CLOSING_ENTRY

FROM ZPP_EMB_PROD

INTO <b>CORRESPONDING FIELDS OF </b> TABLE IT_PROD

WHERE PLANT IN P_WERKS

AND GROUP_MACHINE IN P_MGROUP

AND MACHINE_NO IN P_MNO

AND CREATION_DATE IN P_DATE.