26 Replies Latest reply: Jan 25, 2012 11:31 PM by Rob Burbank RSS

Select on VBAP giving a dump in preproduction system

Jaydeep Sahu
Currently Being Moderated

Hello Experts,

 

We are trying to fetch records from VBAP based on the primary key of VBELN. Even with the primary key, it gives dump in pre production system.

 

     

select vbeln posnr matnr arktx pstyv abgru zmeng meins netwr waerk
          kwmeng kbmeng vrkme werks vstel netpr kpein kmein mvgr5 cuobj
           z_vessel_code z_container_size z_container_type
           z_voyage_number z_hub_port z_serv_typ_orig z_serv_typ_dest
           z_ship_typ_orig z_ship_typ_dest z_passthrough z_shipmentterm
           z_oti z_equipment_type
      into table i_vbap
      from vbap
       for all entries in i_vbak
     where vbeln = i_vbak-vbeln.

 

<Added code tags>

 

If we try to add more parameters in the select query it again gives the dump as primary index or secondary index is not used completely.

 

Please suggest some way of optimizing this query.

 

Edited by: Suhas Saha on Jan 17, 2012 2:52 PM

Actions