topic Re: filling data into same itab based on condition. in Application Development and Automation Discussions

filling data into same itab based on condition.

Former Member — Sat, 25 Aug 2007 05:34:06 GMT

hi to all

my problem is that i have a itab which has matner and mtart now i want to post the stock in the same itab .my query is as below

data : begin of it5 occurs 0,

matnrfg like stpox-idnrk,

matnrsf like stpox-idnrk,

mtart like stpox-mtart,

labst like mard-labst,

lbkum like mbew-lbkum,

labst_final like mard-labst,

end of it5.

if t_stb1-mtart = 'HALB'.

move t_stb1-idnrk to it5-matnrsf.

append it5.

SELECT labst FROM mard INTO

corresponding fields of table it5

WHERE matnr = it5-matnrsf and

lgort = 'A400'.

SELECT lbkum FROM mbew INTO

corresponding fields of table it5

WHERE matnr = it5-matnrsf.

it5-labst_final = it5-lbkum - it5-labst.

but it is not working can anybody help ,it is urgent plz .pointe will be rewarded

Message was edited by:

sarabjit kaur

Re: filling data into same itab based on condition.

former_member194669 — Sat, 25 Aug 2007 05:47:04 GMT

Hi,

Check this


data : begin of it5 occurs 0,
matnrfg like stpox-idnrk,
matnrsf like stpox-idnrk,
mtart like stpox-mtart,
labst like mard-labst,
lbkum like mbew-lbkum,
labst_final like mard-labst,
end of it5.

if t_stb1-mtart = 'HALB'.

move t_stb1-idnrk to it5-matnrsf.

append it5.

data : v_labst like mard-labst.
data : v_lbkum like mbew-lbkum.

SELECT single labst FROM mard INTO v_labst
WHERE matnr = it5-matnrsf and
lgort = 'A400'.

it5-labst = v_labst.


SELECT single lbkum FROM mbew INTO v_lbkum
WHERE matnr = it5-matnrsf.

it5-lbkum = v_lbkum.


it5-labst_final = it5-lbkum - it5-labst.

aRs

Re: filling data into same itab based on condition.

Former Member — Sat, 25 Aug 2007 05:48:08 GMT

Hi,

First when u first time use corresponding it will insert records itab. So that after that u have to use modiify table sysntax everytime when u enter or modify data of table.

Rewars points if it is useful.

Re: filling data into same itab based on condition.

Former Member — Sat, 25 Aug 2007 06:44:28 GMT

hi ars, thanx for prompt reply ,but now my record is in itab header how to move it in table as i need to clear itab .for next execution.

Re: filling data into same itab based on condition.

former_member194669 — Sat, 25 Aug 2007 06:54:34 GMT

Hi,

Create a temperory table as same as IT5 as IT5_temp.


data : begin of it5 occurs 0,
matnrfg like stpox-idnrk,
matnrsf like stpox-idnrk,
mtart like stpox-mtart,
labst like mard-labst,
lbkum like mbew-lbkum,
labst_final like mard-labst,
end of it5.

data : begin of it5_temp occurs 0,
matnrfg like stpox-idnrk,
matnrsf like stpox-idnrk,
mtart like stpox-mtart,
labst like mard-labst,
lbkum like mbew-lbkum,
labst_final like mard-labst,
end of it5_temp.

 
if t_stb1-mtart = 'HALB'.
 
move t_stb1-idnrk to it5-matnrsf.
 
append it5.
 
data : v_labst like mard-labst.
data : v_lbkum like mbew-lbkum.
 
SELECT single labst FROM mard INTO v_labst
WHERE matnr = it5-matnrsf and
lgort = 'A400'.
 
it5-labst = v_labst.
 
 
SELECT single lbkum FROM mbew INTO v_lbkum
WHERE matnr = it5-matnrsf.
 
it5-lbkum = v_lbkum.
 
 
it5-labst_final = it5-lbkum - it5-labst.
move it5 to it5_temp.
append it5_temp.
clear it5.       "<<<<<<<< clear it5

All further needs you can use it5_temp.

a®

Re: filling data into same itab based on condition.

Former Member — Sat, 25 Aug 2007 07:32:44 GMT

thanx a lot ,awarded you full points