topic document amount in Application Development and Automation Discussions

document amount

Former Member — Fri, 11 Aug 2006 05:33:30 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' wrbtr is positive else negitive so how to populate this with negative sign.

regards

sree

Re: document amount

Former Member — Fri, 11 Aug 2006 05:41:28 GMT

u have to check SHKZG ( debit / credit indicator ).

regards

Prabhu

Re: document amount

Former Member — Fri, 11 Aug 2006 05:43:02 GMT

just use select it automaticaly store .

for +ve it show itab-wrbtr = 123.90

-ve it show itab-wrbtr = 123.90-

now u can shift -ve sighn to front of amont using fm

CALL FUNCTION <b>'CLOI_PUT_SIGN_IN_FRONT'

</b>CHANGING

value = itab-wrbtr.

Re: document amount

dani_mn — Fri, 11 Aug 2006 05:44:28 GMT

HI,

to make the field nagative simply multiply it with '-1'.

like this.

if bsid-bschl <> '01' OR

bsid-bschl <> '02' OR

bsid-bschl <> '03' OR

bsid-bschl <> '04'.

itab-wrbtr = bsid-wrbtr * '-1'.

ENDIF.

Regards,

HRA

Re: document amount

Former Member — Fri, 11 Aug 2006 05:52:20 GMT

Hi,

If bsid-bschl < '10'.

if bsid-wrbtr < 0.

bsid-wrbtr = -1 * bsid-wrbtr.

endif.

else.

if bsid-wrbtr > 0.

bsid-wrbtr = -1 * bsid-wrbtr.

endif.

Regards

Subbu

Re: document amount

Former Member — Fri, 11 Aug 2006 06:13:13 GMT

hi subbu

how to fetch this document amount ie how can we write select statement i am bit confusing

plz guide me

regards

sree

Re: document amount

Former Member — Fri, 11 Aug 2006 06:18:40 GMT

hi hra

could you have a look on my query plz

regards

sree

Re: document amount

Former Member — Fri, 11 Aug 2006 20:11:23 GMT

select bschl wrbtr wrbtr

into table itab

from bsid.

loop at itab.

if itab-bschl < 10.

itab-wrbtr = itab-wrbtr * -1.

endif.

write : / itab-bschl, itab-wrbtr.

endloop.

Regards,

Anurag