Short dump

[Former Member]

Hi all,

I have written a select statement using the inner join, my internal table and the select statement is below:

data: begin of it_output occurs 0,

syst_date like sy-datum,

syst_time like sy-uzeit,

belnr like vbkpf-belnr,

gjhar like vbkpf-gjahr,

xprfg like vbkpf-xprfg,

uscmp like vbkpf-uscmp,

usupd like vbkpf-usupd,

hwaer like vbkpf-hwaer,

blart like vbkpf-blart,

bukrs like vbkpf-bukrs,

shkzg like vbsegs-shkzg,

dmbtr like vbsegs-dmbtr,

saknr like vbsegs-saknr,

geber like vbsegs-geber,

fkber like vbsegs-fkber,

kostl like vbsegs-kostl,

grant_nbr like vbsegs-grant_nbr,

ps_psp_pnr like vbsegs-ps_psp_pnr,

aufnr like vbsegs-aufnr,

kblnr like vbsegs-kblnr,

kblpos like vbsegs-kblpos,

anln1 like vbsegs-anln1,

anln2 like vbsegs-anln2,

xref3 like vbsegs-xref3,

sgtxt like vbsegs-sgtxt,

bschl like vbsegs-bschl,

gsber like vbsegs-gsber,

fipos like vbsegs-fipos,

fistl like vbsegs-fistl,

ausbk like vbsegs-ausbk,

TRANS_ID like ZTEST-TRANS_ID,

HIER_NAME like ZTEST-HIER_NAME,

CARDHOLDER like ZTEST-CARDHOLDER,

CARDNUMBER like ZTEST-CARDNUMBER,

CARDNUMBER6 like ZTEST-CARDNUMBER6,

POSTINGDATE like ZTEST-POSTINGDATE,

MERCHANTNAME like ZTEST-MERCHANTNAME,

MERCHANTCITY like ZTEST-MERCHANTCITY,

MERCHANTSTATE like ZTEST-MERCHANTSTATE,

MERCHANTZIP like ZTEST-MERCHANTZIP,

MCC like ZTEST-MCC,

MCCDESCRIPTION like ZTEST-MCCDESCRIPTION,

REFNUMBER like ZTEST-REFNUMBER,

CURRENCYCODE like ZTEST-CURRENCYCODE,

TRANSMEMO like ZTEST-TRANSMEMO,

UNIQUEID like ZTEST-UNIQUEID,

COSTCENTER like ZTEST-COSTCENTER,

ACCTLVLGLNUM like ZTEST-ACCTLVLGLNUM,

MASTERACCTCODE like ZTEST-MASTERACCTCODE,

EXPENSECATEGORY like ZTEST-EXPENSECATEGORY,

PURCHASEID like ZTEST-PURCHASEID,

CRI like ZTEST-CRI,

MINORITYVENDCDE like ZTEST-MINORITYVENDCDE,

STATUS1099 like ZTEST-STATUS1099,

INCORPSTATUS like ZTEST-INCORPSTATUS,

INCORPDESCR like ZTEST-INCORPDESCR,

FEDTAXID like ZTEST-FEDTAXID,

RDATE like ZTEST-RDATE,

RTIME like ZTEST-RTIME,

select VBKPF_{BELNR VBKPF}GJAHR VBKPF_{XPRFG VBKPF}USCMP VBKPF_{USUPD VBKPF}HWAER VBKPF_{BLART VBKPF}BUKRS VBSEGS~BSCHL

VBSEGS_{GSBER VBSEGS}DMBTR VBSEGS_{KOSTL VBSEGS}AUFNR VBSEGS_{SAKNR VBSEGS}PS_PSP_PNR VBSEGS_{FIPOS VBSEGS}ANLN1

VBSEGS_{ANLN2 VBSEGS}KBLNR VBSEGS_{KBLPOS VBSEGS}GEBER VBSEGS_{FISTL VBSEGS}FKBER VBSEGS_{XREF3 VBSEGS}GRANT_NBR

VBSEGS_{AUSBK vbsegs}shkzg vbsegs_{sgtxt vbsegs}bschl VBSEGS_{BELNR VBSEGS}GJAHR ztest~cardnumber

ztest_{uniqueid ztest}costcenter ztest_{acctlvlglnum ztest}masteracctcode

ztest_{rdate ztest}rtime ZTEST_{HIER_NAME ZTEST}CARDHOLDER ZTEST~CARDNUMBER6

ZTEST_{MERCHANTNAME ZTEST}MERCHANTCITY ZTEST_{MERCHANTSTATE ZTEST}MERCHANTZIP

ZTEST_{MCC ZTEST}MCCDESCRIPTION ZTEST_{REFNUMBER ZTEST}TRANSMEMO

ZTEST_{EXPENSECATEGORY ZTEST}PURCHASEID ZTEST_{CRI ZTEST}MINORITYVENDCDE

ZTEST_{STATUS1099 ZTEST}INCORPSTATUS ZTEST_{INCORPDESCR ZTEST}FEDTAXID

ZTEST_{POSTINGDATE ZTEST}BUKRS ZTEST_{belnr ZTEST}gjahr

into table it_output

from VBKPF

inner join VBSEGS

on VBSEGS_{AUSBK = VBKPF}AUSBK

and VBSEGS_{BELNR = VBKPF}BELNR

and VBSEGS_{GJAHR = VBKPF}GJAHR

inner join ZTEST

on ZTEST_{BUKRS = VBSEGS}AUSBK

and ZTEST_{BELNR = VBSEGS}BELNR

and ZTEST_{GJAHR = VBSEGS}GJAHR

where VBKPF~USUPD in chngb

and VBKPF~USCMP in compb

and VBKPF~XPRFG in docom

and VBKPF~GJAHR in fisyr

and VBKPF~BELNR in docnum

and VBKPF~BLART in blart

and VBKPF~BUKRS in bukrs

and VBSEGS~XREF3 in ref

and VBSEGS~SAKNR in glact

and ZTEST~MERCHANTNAME in mname

and ZTEST~CARDNUMBER6 in anum

and ZTEST~CARDHOLDER in cname

and ZTEST~HIER_NAME in hname

and ZTEST~POSTINGDATE in date.

after executng this I am getting a short dump which says :

Error analysis

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

and

therefore caused a runtime error.

The reason for the exception is:

In a SELECT access, the read file could not be placed in the target

field provided.

Either the conversion is not supported for the type of the target field,

the target field is too small to include the value, or the data does not

have the format required for the target field.

Can you please help how to fix this short dump.

[former_member194669]

Change

into table it_output

by

into corresponding fields of table it_output

a®

[Former Member]

into corresponding fields of table it_output

if still dont work, make sure, all fields you are selecting are there in internal table.