2008 May 14 10:56 AM
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 .
2008 May 14 11:05 AM
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-sign = 'E'.
wa_BWART-low = '102'.
pls reward if it is helpful.
Regrads,
Boobalan Suburaj
Edited by: Boobalan Suburaj on May 14, 2008 1:14 PM
2008 May 14 11:08 AM
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.
2008 May 14 11:21 AM
hi vonod..
still dosent serve the purpose
SMBLN is intial for a 101 document even though it has been cancelled
Bluesky
