Skip to Content
0
Jul 30, 2014 at 01:29 AM

Issue in for all entries

40 Views

Hi,

i face a strange situation ,during the process of an report i pass my data from ekpo to mseg as below. it is such a simple statment.

if p_werks is NOT INITIAL .

SELECT EBELN

ebelp

LOEKZ

MATNR

BUKRS

WERKS

MATKL netwr from ekpo INTO TABLE tb_ekpo_po

WHERE matnr = p_matnr and werks = p_werks and loekz ne 'L'.

if tb_ekpo_po is not initial.

SELECT mblnr mjahr bwart matnr werks lgort shkzg dmbtr menge ebeln ebelp from mseg INTO TABLE tb_mseg_po

FOR ALL ENTRIES IN tb_ekpo_po2

WHERE matnr = tb_ekpo_po2-matnr

and bwart = '281'

and werks = p_werks.

endif .

endif.

but the records i am getting in tb_mseg_po debug as not same as in database(mseg table),the internal is not fethching few records .

for ex:i have given same inputs as given in report.

but while in debug of same given inputs in report i get only 44 records, where i might be wrong, i have checked in all aspects , i have no clue.

if i dont use for all entries i am getting all 47 records as per database table ,is the prob with for all entries?

Thanks in advance.

Attachments

Capture.JPG (64.5 kB)
Capture1123.JPG (43.7 kB)