Skip to Content
0
Jun 21, 2009 at 01:14 PM

select query

21 Views

SELECT matnr

VKORG

TRVOG

AUDAT

VTWEG

SPART

AUART

KUNNR

VKBUR

VKGRP

BSTNK

ERNAM

VBELN

POSNR

FROM vapma INTO

CORRESPONDING FIELDS of TABLE i_vapma

  • WHERE matnr = wa_input_bdc-matnr

WHERE matnr = '10290554'

  • AND vkorg = p_vkorg

AND vkorg = '0300'

  • AND trvog = v_trvog

AND trvog = '4'

  • AND vtweg = p_vtweg

AND vtweg = '90'

  • AND spart = p_spart.

AND spart = '67'.

above select query is not working....is any syntax error in this...

my internal table declared as :

data : begin of i_vapma occurs 0,

matnr like vapma-matnr,

VKORG like vapma-vkorg,

TRVOG like vapma-trvog,

AUDAT like vapma-audat,

VTWEG like vapma-vtweg,

SPART like vapma-spart,

AUART like vapma-auart,

KUNNR like vapma-kunnr,

VKBUR like vapma-vkbur,

VKGRP like vapma-vkgrp,

BSTNK like vapma-bstnk,

ERNAM like vapma-ernam,

VBELN like vapma-vbeln,

POSNR like vapma-posnr,

  • kunnr like vapma-kunnr,

end of i_vapma.