topic Re: mseg table data not retrive in Application Development and Automation Discussions

mseg table data not retrive

Former Member — Fri, 26 Dec 2008 05:28:00 GMT

Hi Guru's,

I have retrieve data using read table . but in that mseg table data display but only first record repeated three time.

my select query like this.

SELECT * FROM MSEG

INTO CORRESPONDING FIELDS

OF TABLE IT_MSEG for all entries in it_vbap

WHERE MAT_KDAUF = it_vbap-vbeln

AND BWART = '501'

AND SOBKZ = 'E'.

and after that i have read table like this

loop at it_vbap where vbeln = it_vbak-vbeln.

read table it_kna1 with key

kunnr = it_vbak-kunnr.

if sy-subrc = 0.

read table it_vbep with key

vbeln = it_vbap-vbeln

posnr = it_vbap-posnr.

if sy-subrc = 0.

read table it_mseg with key

mat_kdauf = it_vbap-vbeln

BWART = '501'

SOBKZ = 'E'.

if sy-subrc = 0.

read table it_mkpf with key

mblnr = it_mseg-mblnr.

if sy-subrc = 0.

read table it_MAKT with key

MATNR = it_MSEG-MATNR.

if sy-subrc = 0.

read table it_lips with key

vgbel = it_vbap-vbeln

posnv = it_vbap-posnr.

if sy-subrc = 0.

IT_ANN-vbeln = it_vbak-vbeln.

IT_ANN-name1 = it_kna1-name1.

IT_ANN-kwmeng = it_vbap-kwmeng.

IT_ANN-lsmeng = it_vbap-lsmeng.

IT_ANN-posnr = it_vbap-posnr.

IT_ANN-matnr = it_vbap-matnr.

IT_ANN-arktx = it_vbap-arktx.

IT_ANN-edatu = it_vbep-edatu.

IT_ANN-prsdt = it_vbkd-prsdt.

IT_ANN-mblnr = it_mseg-mblnr.

IT_ANN-mat1 = it_mseg-matnr.

IT_ANN-lifnr = it_mseg-lifnr.

IT_ANN-erfmg = it_mseg-erfmg.

IT_ANN-sgtxt = it_mseg-sgtxt.

IT_ANN-BUDAT = it_mkpf-BUDAT.

IT_ANN-lfimg = it_lips-lfimg.

IT_ANN-MAKTX = it_MAKT-MAKTX.

append it_ann.

endif.

endloop.

where i am wrong.

please help me.

Thanks in Advance.

Regard.

Sam.

Re: mseg table data not retrive

Former Member — Fri, 26 Dec 2008 05:35:24 GMT

Hi,

I think you have compare another field at the time of selection and read also i.e.

MSEG-MAT_KDPOS = VBAP-POSNR

Arunima

Re: mseg table data not retrive

Former Member — Fri, 26 Dec 2008 05:38:10 GMT

hi.

i don understand wat kind of output you want but

if you don want mseg data to be repeated, then whnever you will find entry in mseg table while reading the mseg table take that sy-tabix value in some other variable and at the end of the if condition ie when your 'endif' of your 'sy-subrc = 0' check comes, delete the entry from internal mseg table after processing which wont repeat further if you dont want.

hope this is you want

Re: mseg table data not retrive

Former Member — Fri, 26 Dec 2008 05:38:51 GMT

If you are using READ key word it gets only the first available record.

loop at i_scarr.

read table i_sflight where carrid = i_scarr-carrid.

obviously SFLIGHT has more number of records for a given carrid

Please check the tables SCARR and SFLIGHT

endloop.

in your case you need to do like this

loop at i_scarr.

loop at i_sflight where carrid = i_scarr-carrid.

endloop.

endloop

or loop the Item interanal table if you have more records in item than header table

if I_VBAP has different MATNR then change your READ statement as follows

read table it_mseg with key

mat_kdauf = it_vbap-vbeln

matnr = it_vbap-matnr " Might be helpful

BWART = '501'

SOBKZ = 'E'.

Re: mseg table data not retrive

Former Member — Fri, 26 Dec 2008 06:48:52 GMT

Hi sam,

actually the condition that you use at loop statement..

here "loop at it_vbap where vbeln = it_vbak-vbeln."

it_vbak-vbeln has same value so you are getting repeated records.

please you propercondtion.

i think you will get record according to last record value in it_vbap .

Re: mseg table data not retrive

Former Member — Fri, 26 Dec 2008 06:55:58 GMT

hi sam did you get the point where it was wrong.

Re: mseg table data not retrive

Former Member — Fri, 26 Dec 2008 06:56:48 GMT

Hi Swati,

Thanks for answer .

Could you tell me which condition i use here.

Sam.

Re: mseg table data not retrive

Former Member — Fri, 26 Dec 2008 07:00:32 GMT

hi use..

loop at it_vbak.

loop at it_vbap where vbeln = it_vbak-vbeln.

clear it_vbap .

endloop.

clear it_vbak.

endloop.

Edited by: swati gupta on Dec 26, 2008 8:02 AM

Re: mseg table data not retrive

Former Member — Fri, 26 Dec 2008 07:08:50 GMT

hi sam,

is your problem solved r not..

please let me know abt that..

Re: mseg table data not retrive

Former Member — Fri, 26 Dec 2008 07:15:46 GMT

hi swati

your suggestion not work.

problem occurred same.

sam.

Re: mseg table data not retrive

Former Member — Fri, 26 Dec 2008 07:17:44 GMT

hello sam,

i had mentioned before that you have to match the line item also....have you tried that???

Arunima

Re: mseg table data not retrive

Former Member — Fri, 26 Dec 2008 07:17:47 GMT

hi please check the entries in it_vbak..

by using debugging..you wll get the solution..and please update me result

Re: mseg table data not retrive

Former Member — Fri, 26 Dec 2008 07:26:51 GMT

I tried that but item not same

menace mseg-mat_kdpos and vbap-posnr not same.

Regard

Sam.

Re: mseg table data not retrive

Former Member — Fri, 26 Dec 2008 07:30:29 GMT

Hi Swati,

I also debugge code .

1)in it_vbak one record.

2)it_vbap three record

3)and it_mseg 3 record

but when dubugge code

1 and 2 correct but last one only display 1 record three time.

Regards.

Sam.

Re: mseg table data not retrive

Former Member — Fri, 26 Dec 2008 07:32:57 GMT

hi sam

when it_vbap has one record ,then you will get the same data according to that record.

so you use different condition..

you let me know your req?

Re: mseg table data not retrive

Former Member — Fri, 26 Dec 2008 07:41:12 GMT

I want to develop Annexure V report.

In that i want MIGO related record,

like sales order no, customer , material , order quantity, del. quantity, raw material, posting date , posting quantity, vendor , invoice text.

Regard.

Sam

Edited by: sam on Dec 26, 2008 10:01 AM

Re: mseg table data not retrive

GuyF — Fri, 26 Dec 2008 10:03:44 GMT

Try the following code:

loop at it_vbap where vbeln = it_vbak-vbeln.
  IT_ANN-vbeln = it_vbak-vbeln.

  IT_ANN-kwmeng = it_vbap-kwmeng.
  IT_ANN-lsmeng = it_vbap-lsmeng.
  IT_ANN-posnr = it_vbap-posnr.
  IT_ANN-matnr = it_vbap-matnr.
  IT_ANN-arktx = it_vbap-arktx.

  IT_ANN-prsdt = it_vbkd-prsdt.

  read table it_kna1 with key kunnr = it_vbak-kunnr.
  if sy-subrc = 0.
    IT_ANN-name1 = it_kna1-name1.
  endif.

  read table it_vbep with key vbeln = it_vbap-vbeln
                              posnr = it_vbap-posnr.
  if sy-subrc = 0.
    IT_ANN-edatu = it_vbep-edatu.
  endif.

  read table it_MAKT with key MATNR = it_MSEG-MATNR.
  if sy-subrc = 0.
    IT_ANN-MAKTX = it_MAKT-MAKTX.
  endif.

  read table it_lips with key vgbel = it_vbap-vbeln
                              posnv = it_vbap-posnr.
  if sy-subrc = 0.
    IT_ANN-lfimg = it_lips-lfimg.
  endif.

  loop at it_mseg where mat_kdauf = it_vbap-vbeln.
    read table it_mkpf with key mblnr = it_mseg-mblnr.
    if sy-subrc = 0.
      IT_ANN-BUDAT = it_mkpf-BUDAT.
    endif.

    IT_ANN-mblnr = it_mseg-mblnr.
    IT_ANN-mat1 = it_mseg-matnr.
    IT_ANN-lifnr = it_mseg-lifnr.
    IT_ANN-erfmg = it_mseg-erfmg.
    IT_ANN-sgtxt = it_mseg-sgtxt.

    append it_ann.
  endloop.
endloop.

Best Regards,

Guy

Edited by: Guy F. on Dec 26, 2008 11:03 AM