topic doc amount in Application Development and Automation Discussions

doc amount

Former Member — Fri, 11 Aug 2006 06:26:21 GMT

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

Re: doc amount

Former Member — Fri, 11 Aug 2006 06:28:20 GMT

it should be like this.

loop at xbsid.

if xbsid-shkzg eq 'H'.

xbsid-wrbtr = xbsid-wrbtr * -1.

modify xbsid.

endif.

endloop.

regards

Prabhu

Re: doc amount

naimesh_patel — Fri, 11 Aug 2006 06:35:43 GMT

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

Re: doc amount

Former Member — Fri, 11 Aug 2006 06:41:56 GMT

hi nim

for sign you are outting 'l'

could plz explain about it .

and fiscal year is mandatory here.

regards

Re: doc amount

Former Member — Fri, 11 Aug 2006 06:45:52 GMT

I for Including .

BT b/w.

regards

Prabhu

Re: doc amount

andreas_mann3 — Fri, 11 Aug 2006 07:04:19 GMT

hi,

better use:

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

Andreas