topic Cancelled Material Document Nos in Application Development and Automation Discussions

Cancelled Material Document Nos

rahul2000 — Wed, 14 May 2008 09:56:24 GMT

Dear All,

from MSEG table i want to pick up MBLNR having movement type 101...but at the same time these MBLNR's should not be cancelled with 102.

In short how can i pick up uncancelled MBLNR from MSEG with movement type 101 .

Former Member — Wed, 14 May 2008 10:05:31 GMT

Hi Rahul,

Try the below select statement.

select * from mesg into table IT_MESG

where BWART in IT_BWART.

Where IT_MBLNR is an internal table with type of lvc_t_rngs (range internal table)

data: IT_BWART type LVC_T_RNGS,

WA_BWART TYPE LVC_S_RNGS.

wa_BWART-option = 'EQ'.

wa_BWART-sign = 'I'.

wa_BWART-low = '101'.

append wa_BWART into IT_BWART.

clear wa_BWART.

wa_BWART-option = 'EQ'.

wa_BWART-sign = 'E'.

wa_BWART-low = '102'.

append wa_BWART into IT_BWART.

clear wa_BWART.

pls reward if it is helpful.

Regrads,

Boobalan Suburaj

Edited by: Boobalan Suburaj on May 14, 2008 1:14 PM

rvinod1982 — Wed, 14 May 2008 10:08:38 GMT

Hi Rahul,

IF u want to select only those documents having movement type 101 and these documents should are not reversed with movement type 102 .

Then u can select those documents having field SMBLN as initial.

select mblnr from mseg where bwart eq '101' and smbln is

initial.

rahul2000 — Wed, 14 May 2008 10:21:08 GMT

hi vonod..

still dosent serve the purpose

SMBLN is intial for a 101 document even though it has been cancelled