Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

doc amount

Former Member
0 Likes
817

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

1 ACCEPTED SOLUTION
Read only

naimesh_patel
Active Contributor
0 Likes
775

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

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

5 REPLIES 5
Read only

Former Member
0 Likes
775

it should be like this.

loop at xbsid.

if xbsid-shkzg eq 'H'.

xbsid-wrbtr = xbsid-wrbtr * -1.

modify xbsid.

endif.

endloop.

regards

Prabhu

Read only

naimesh_patel
Active Contributor
0 Likes
776

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

Read only

0 Likes
775

hi nim

for sign you are outting 'l'

could plz explain about it .

and fiscal year is mandatory here.

regards

Read only

0 Likes
775

I for Including .

BT b/w.

regards

Prabhu

Read only

andreas_mann3
Active Contributor
0 Likes
775

hi,

better use:

select-options: p_bschl for bsid-bschl default '01' to '09'.

Andreas