dump in fm

[Former Member]

Moderator message: please use more descriptive subject lines and format your code properly.

i am getting dump when executing my z fm in below select statement .

code is like below ,

SELECT vbak~vbeln "Sales Document

vbak~auart "Sales Document Type

vbak~kunnr "Sold-to party

vbap~posnr "Sales Document Item

vbap~matnr "Article Number

vbap~werks "Site

vbap~vstel "Shipping Point/Receiving Point

vbap~route "Route

vbap~zz_area "Area Information

vbap~zz_cube "Cube

vbap~zz_weight "weight

vbap~zzevent_id "Event id

vbap~zzline_no "Line no

vbep~etenr "Delivery Schedule Line Number

vbep~edatu "Schedule line date

vbuk~lfstk

vbup~lfsta

INTO TABLE itab_area_sku_so

FROM vbak

INNER JOIN vbap ON

vbak_{vbeln = vbap}vbeln

INNER JOIN vbep ON

vbap_{vbeln = vbep}vbeln

AND vbap_{posnr = vbep}posnr

INNER JOIN vbuk ON vbuk_{vbeln = vbak}vbeln

INNER JOIN vbup ON vbup_{vbeln = vbap}vbeln

AND vbup_{posnr = vbap}posnr

WHERE vbak~auart IN r_doc_type_ranges

AND vbak~kunnr IN r_store_ranges

AND vbap~vstel IN r_ship_point_ranges

AND vbap~route IN r_route_ranges

AND vbap~abgru EQ space

• AND vbap~werks = i_site

AND vbap~zz_area = i_area

AND vbap~matnr = i_sku

AND vbap~zzpog_name IN r_pog_name_ranges

AND vbap~zzevent_id IN r_event_id_ranges

AND vbap~zz_wms_cat_cd IN r_category_ranges

AND vbep~edatu = i_delivery_date

AND NOT ( vbuk~lfstk EQ c_complete_process OR

vbuk~lfstk EQ c_partially_process )

AND vbuk~spstg NE 'C'.

error analysis is like below

" 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. :"

please suggest how to avoid dump

Edited by: Thomas Zloch on Dec 1, 2010 12:40 PM

[Former Member]

Moderator message: please use more descriptive subject lines and format your code properly.

i am getting dump when executing my z fm in below select statement .

code is like below ,

SELECT vbak~vbeln "Sales Document

vbak~auart "Sales Document Type

vbak~kunnr "Sold-to party

vbap~posnr "Sales Document Item

vbap~matnr "Article Number

vbap~werks "Site

vbap~vstel "Shipping Point/Receiving Point

vbap~route "Route

vbap~zz_area "Area Information

vbap~zz_cube "Cube

vbap~zz_weight "weight

vbap~zzevent_id "Event id

vbap~zzline_no "Line no

vbep~etenr "Delivery Schedule Line Number

vbep~edatu "Schedule line date

vbuk~lfstk

vbup~lfsta

INTO TABLE itab_area_sku_so

FROM vbak

INNER JOIN vbap ON

vbak_{vbeln = vbap}vbeln

INNER JOIN vbep ON

vbap_{vbeln = vbep}vbeln

AND vbap_{posnr = vbep}posnr

INNER JOIN vbuk ON vbuk_{vbeln = vbak}vbeln

INNER JOIN vbup ON vbup_{vbeln = vbap}vbeln

AND vbup_{posnr = vbap}posnr

WHERE vbak~auart IN r_doc_type_ranges

AND vbak~kunnr IN r_store_ranges

AND vbap~vstel IN r_ship_point_ranges

AND vbap~route IN r_route_ranges

AND vbap~abgru EQ space

• AND vbap~werks = i_site

AND vbap~zz_area = i_area

AND vbap~matnr = i_sku

AND vbap~zzpog_name IN r_pog_name_ranges

AND vbap~zzevent_id IN r_event_id_ranges

AND vbap~zz_wms_cat_cd IN r_category_ranges

AND vbep~edatu = i_delivery_date

AND NOT ( vbuk~lfstk EQ c_complete_process OR

vbuk~lfstk EQ c_partially_process )

AND vbuk~spstg NE 'C'.

error analysis is like below

" 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. :"

please suggest how to avoid dump

Edited by: Thomas Zloch on Dec 1, 2010 12:40 PM

[Former Member]

Hi,

Please check if your Internal table " itab_area_sku_so" has all the fields you are selectiog in the same order and the same type.

vbak~vbeln

vbak~auart

vbak~kunnr

vbap~posnr

vbap~matnr

vbap~werks

vbap~vstel

vbap~route

vbap~zz_area

vbap~zz_cube

vbap~zz_weight

vbap~zzevent_id

vbap~zzline_no

vbep~etenr

vbep~edatu

vbuk~lfstk

vbup~lfsta

Regards,

Srini.

[Former Member]

my internal table is like below,

please suggest what to do

BEGIN OF ty_area_sku_so,

vbeln TYPE vbeln_vl, "SO no

auart TYPE auart, "Sales Document Type

kunnr TYPE kunnr, " Sold to party = store

posnr TYPE posnr, "SO line item

matnr TYPE matnr, "Material

werks TYPE werks_d,

vstel TYPE vstel , "shipping point

route TYPE route, "route no

zz_area TYPE zzlocation_code, "Area

zz_cube1 TYPE zz_cube1,

zz_weight1 TYPE zz_weight1,

zzevent_id TYPE zzeventid, "Event Id

zzline_no TYPE zzline_no,"Line no

etenr TYPE etenr, "Delivery Schedule Line Number

edatu TYPE edatu, "Schedule line date

lfstk TYPE lfstk, "Delivery status

lfsta TYPE lfsta, "Delivery status

END OF ty_area_sku_so,

[Former Member]

you have described a type. Did you follow that with a data declaration....like

data: itab type table of ty_area_sku_so.

[jayanthi_jayaraman]

Hi,

In declaration, try changing zz_cube1 and zz_weight1 to zz_cube and zz_weight.

zz_cube TYPE vbap-zz_cube,

zz_weight TYPE vbap-zz_weight,

If still you have problem, check with the declared types with target fields in select.

[Former Member]

Hi,

check your Internal table fileds sequence should match the select statement filed list. else u can use INTO CORRESPONDING FIELDS OF TABLE.

Regards,

Anil.

[Former Member]

Hi

Try it with Nested select statements,

Comparitively Nested select performs accurately than Inner joins,

For example , follow this link

se38-> open any program -> Select Environment Menu -> Examples -> Performance Examples -> Abap Objects Performance Ex

-> Sql Interface -> Select Over more than one table -> Select with Join.. click on Measure runtime Button to check Performance.

Edited by: Murthy.SAP on Dec 6, 2010 12:26 PM