Urgent !!! How to change Accounting document using Billing document number

[former_member217000]

Hi experts,

I have one requirement where I have to modify the accounting document using report. User will enter billing document no and I have to find out respective accounting document and I have to change header data..

I am very new to these modules so please give me solution.

Thanks

Sameer

[Former Member]

Dear Friend,

YOu can do this Functionally by SAP Query.

SQ00.

Using the tables:

Find out your accounting document Table by pressing F1 and Techinical Help.

And then join the table and develop the query.

from SQ02> SQ03>SQ01

Reward points if helpful,

regards,

Amlan

[alpesh_saparia3]

Pass billing document no to field BKPF-AWKEY and pass 'VBRK' to field BKPF-AWTYP of BKPF table to get the accounting document no.

-Alpesh

[Former Member]

Hello,

You can see the accounting documents from the billing document, from the accounting button in VF02, but I doubt whether you can change the accounting document header data. Get the help of a FI consultant, he may be able to guide you.

Prase

[former_member183879]

Pls check the table BKPF

BKPF has got the billingdocument and accounting document numbers.

BKPF-BELNR is accounting documnet number

BKPF-ZBLNR is the invoice document number

So by using the logic

VBRK-VBELN = BKPF-XBLNR, you can find out BKPF-BELNR and then you can change that accounting document.

Hope this helps.

Pls reward if this helps.

[former_member217000]

Hi Navaneetha,

Thanks for the reply..

I understood how ro find out accounting document no from ur reply.

Is there any BAPI or function module exists to update Accounting document??

I have to change basline date.

Thanks

Sameer

[former_member183879]

Hi,

I am not aware of any such FM for this purpose,

If you ask some FI consultant, they should be able to help you Sameer.