‎2006 Aug 11 7:26 AM
hi friends,
i need to fetch amount in document currencey and print that.
bsid-wrbtr
if document type (bschl) is populated with '01' '02' '03' '04' '05'......'09'
plz guide me retrive the amont from bsid table
regards
sree
‎2006 Aug 11 7:35 AM
Hello,
Fill one range with required posting keys.
ranges: r_bschl for bsid-bschl.
r_bschl-sign = 'I'.
r_bschl-options = 'BT'.
r_bschl-low = '01'.
r_bshcl-high = '09'.
append r_bschl.
Not select your records from BSID.
select * from bsid into table itab
where BUKRS = " company code
and kunnr = " specify customer
and GJAHR = " fiscal year
and BSCHL in r_bschl.
loop at itab.
if itab-shkzg = 'H'.
itab-wrbtr = itab-wrbtr * -1.
modify itab.
endif.
endloop.
regards,
Naimesh
‎2006 Aug 11 7:28 AM
it should be like this.
loop at xbsid.
if xbsid-shkzg eq 'H'.
xbsid-wrbtr = xbsid-wrbtr * -1.
modify xbsid.
endif.
endloop.
regards
Prabhu
‎2006 Aug 11 7:35 AM
Hello,
Fill one range with required posting keys.
ranges: r_bschl for bsid-bschl.
r_bschl-sign = 'I'.
r_bschl-options = 'BT'.
r_bschl-low = '01'.
r_bshcl-high = '09'.
append r_bschl.
Not select your records from BSID.
select * from bsid into table itab
where BUKRS = " company code
and kunnr = " specify customer
and GJAHR = " fiscal year
and BSCHL in r_bschl.
loop at itab.
if itab-shkzg = 'H'.
itab-wrbtr = itab-wrbtr * -1.
modify itab.
endif.
endloop.
regards,
Naimesh
‎2006 Aug 11 7:41 AM
hi nim
for sign you are outting 'l'
could plz explain about it .
and fiscal year is mandatory here.
regards
‎2006 Aug 11 7:45 AM
‎2006 Aug 11 8:04 AM
hi,
better use:
select-options: p_bschl for bsid-bschl default '01' to '09'.
Andreas