any functional module to get financial document based on billing document

[Former Member]

hi all,

do we have any functional module to get accounting document (bseg-BELNR) based on billing document (bseg-VBELN)?

i have a requirement to retrieve the clearing document (bseg-augcp) & date(bseg-augdt) from BSEG with billing document.

billing document is not a key, so i would like to retrieve the accounting document from any function module and use that to get clearing document (bseg-augcp) & date(bseg-augdt).

thanks.

[Former Member]

hi all,

do we have any functional module to get accounting document (bseg-BELNR) based on billing document (bseg-VBELN)?

i have a requirement to retrieve the clearing document (bseg-augcp) & date(bseg-augdt) from BSEG with billing document.

billing document is not a key, so i would like to retrieve the accounting document from any function module and use that to get clearing document (bseg-augcp) & date(bseg-augdt).

thanks.

[Former Member]

Hi

Go through the link given below :

http://help.sap.com/saphelp_erp2005/helpdata/en/ae/24f2a6d86011d195460000e82deb58/content.htm

With Regards

Nikunj Shah

[Former Member]

hi,

use this RV_INVOICE_DOCUMENT_REAd

[Former Member]

hi all,

i got other option to get this....thanks.

select single * from bkpf

where bukrs = <data>-werks

and AWTYP = 'VBRK'

and AWKEY = billing doc.

if sy-subrc EQ 0.

select single * from bseg

where bukrs = bkpf-bukrs

and belnr = bkpf-belnr

and gjahr = bkpf-gjahr.

if sy-subrc EQ 0.

<data>-AUGDT = bseg-augdt.

<data>-AUGBL = bseg-augbl.

endif.