topic Re: why this statement going to dump... in Application Development and Automation Discussions

why this statement going to dump...

Former Member — Wed, 06 Aug 2008 15:00:18 GMT

TYPES : BEGIN OF type_repstruc,

ccode TYPE bukrs,

docnum TYPE belnr_d,

docs TYPE dbzhl,

fyear TYPE gjahr,

fir_run TYPE dbbdt,

nex_run TYPE dbatr,

las_run TYPE dbedt,

dbakz TYPE dbakz_t054,

del_ind TYPE c,

lifnr TYPE lifnr,

hkont TYPE hkont,

ttl_docamt TYPE wert, " Total Doc. Amount

ttl_pstamt TYPE wert, " Total Post Amount

*----

UHDK932263

LIFNR TYPE LIFNR,

DBMON TYPE DBMON,

BELNR TYPE BELNR_D,

BUDAT TYPE BUDAT,

WRBTR TYPE WRBTR,

AUGBL TYPE AUGBL,

AUGDT TYPE AUGDT,

WRBTR TYPE WRBTR,

*----

UHDK932263

END OF type_repstruc.

TYPES : BEGIN OF type_detail,

bukrs TYPE bukrs,

lifnr TYPE lifnr,

hkont TYPE hkont,

belnr TYPE belnr_d,

dmbtr TYPE dmbtr,

koart TYPE koart,

shkzg TYPE shkzg,

ttl_docamt TYPE wert, " Total Doc. Amount

ttl_pstamt TYPE wert, " Total Post Amount

*----

UHDK932263

WRBTR TYPE WRBTR,

AUGBL TYPE AUGBL,

AUGDT TYPE AUGDT,

*----

UHDK932263

END OF type_detail.

DATA : gt_detail TYPE TABLE OF type_detail,

gt_detail1 TYPE TABLE OF type_detail,

gt_reptab TYPE TABLE OF type_repstruc,

gt_doc_detail TYPE TABLE OF type_doc_detail.

DATA : gw_reptab TYPE type_repstruc,

gw_detail TYPE type_detail,

gw_doc_detail TYPE type_doc_detail.

SELECT bukrs belnr dbzhl gjahr dbbdt dbatr dbedt dbakz xdelt

FROM bkdf

INTO TABLE gt_reptab

WHERE bukrs IN so_code

AND dbbdt IN so_date

AND bukrs IN so_code

AND belnr IN so_docn.

SORT gt_reptab BY docnum.

SELECT bukrs lifnr hkont belnr dmbtr koart shkzg WRBTR AUGBL AUGDT

FROM bseg

INTO TABLE gt_detail

FOR ALL ENTRIES IN gt_reptab

WHERE belnr EQ gt_reptab-docnum

AND bukrs EQ gt_reptab-ccode.

I AM GETTING DUMP IN SECOND SELECT STATEMENT...

Re: why this statement going to dump...

Former Member — Wed, 06 Aug 2008 15:01:52 GMT

in the second select statement use into corresponding fields of table

SELECT bukrs lifnr hkont belnr dmbtr koart shkzg WRBTR AUGBL AUGDT

FROM bseg

INTO into corresponding fields of table gt_detail

FOR ALL ENTRIES IN gt_reptab

WHERE belnr EQ gt_reptab-docnum

AND bukrs EQ gt_reptab-ccode.

Re: why this statement going to dump...

Former Member — Wed, 06 Aug 2008 15:02:49 GMT

hi,

WHERE belnr EQ gt_reptab-docnum

AND bukrs EQ gt_reptab-ccode.

here is docnum same as belnr?

check for the filed names

Re: why this statement going to dump...

Former Member — Wed, 06 Aug 2008 15:02:59 GMT

Hi Ravi,

Before using 'FOR ALL ENTRIES' , you need to check that internal table is iniital or not.

What is the error message(Error Analysis) you got in that runtime error.

Thanks,

Pranav

Re: why this statement going to dump...

RaymondGiuseppi — Wed, 06 Aug 2008 15:04:34 GMT

The fields ttl_docamt ttl_pstamt are missing in the select statement.

Use a INTO CORRESPONDING FIELDS OF in the second SELECT statement, /or/ add the missing fields in the SELECT clause /or/ redefine the local type to match exactly the fields selected.

Regards