Short Dump

[Former Member]

Iam getting a short dump in the below select statement for the last line..Canu have a look at that

SELECT EBELN EBELP GJAHR BELNR BEWTP MENGE SHKZG MATNR BUDAT

BWART

FROM EKBE APPENDING TABLE IT_EKBE

WHERE EBELN = IT_EKPO-EBELN

AND EBELP = IT_EKPO-EBELP

AND BUDAT IN S_BUDAT

AND ( BEWTP = 'E' OR BEWTP = 'O' ).

The message is

The data read during a SELECT access could not be inserted into the

target field.

Either conversion is not supported for the target field's type or the

target field is too short to accept the value or the data are not in a

form that the target field can accept

Thanks And Regards

Vicky

[LucianoBentiveg]

Try APPENDING CORRESPONDING FIELDS OF TABLE:

SELECT EBELN EBELP GJAHR BELNR BEWTP MENGE SHKZG MATNR BUDAT

BWART

FROM EKBE <b>APPENDING CORRESPONDING FIELDS OF TABLE</b> IT_EKBE

WHERE EBELN = IT_EKPO-EBELN

AND EBELP = IT_EKPO-EBELP

AND BUDAT IN S_BUDAT

AND ( BEWTP = 'E' OR BEWTP = 'O' ).

[former_member181966]

Check the structure of your internal table IT_EKBE.make sure it has the correct date types define ...

Thanks

Saquib

[Former Member]

yup it has the correct structure

[RichHeilman]

Please change your definition like this.

data: begin of it_ekbe occurs 0,
ebeln like ekbe-ebeln,
ebelp like ekbe-ebelp,
gjahr like ekbe-gjahr,
belnr like ekbe-belnr,
bewtp like ekbe-bewtp,
menge like ekbe-menge,
shkzg like ekbe-shkzg,
matnr like ekbe-matnr,
<b>budat type ekbe-budat,
*budat(8) type c,</b>
bwart like ekbe-bwart,
end of it_ekbe.

Regards,

Rich Heilman

[LucianoBentiveg]

I've a question.. How rich knows table definition if Vicky never post it? Are you mentalist too?

[RichHeilman]

Yes, we have telepathy. No, Vicky emailed me at about the same time that he posted here on SDN. My first question to him, was how did he define the internal table. Of course that is the first thing we need to look at when this kind of dump happens.

Regards,

Rich Heilman

[dielom]

sounds funny that all fields but one were declared as Field like table-field.

[RichHeilman]

Diego, I was thinking the same thing, that's what really jumped out at me.

Regards,

Rich Heilman

[Former Member]

Please tell us how you defined IT_EKBE

[dielom]

Naresh,

I think Rich already posted it, by reading Vicky Vicky's mind.

May it be some tongo here???

Regards.

Diego