topic Re: Document number in Application Development and Automation Discussions

Document number

Former Member — Thu, 09 Apr 2009 07:13:27 GMT

Is there any table which links the invoice document number and the accounting document number?I have a accounting document number using that have to update the contents of bseg table.How to do it?

Re: Document number

GauthamV — Thu, 09 Apr 2009 07:15:37 GMT

Plz SEARCH in SCN you have lot of posts.

Re: Document number

RoySayak — Thu, 09 Apr 2009 07:23:52 GMT

Hello Rajalakshmi,

See the below query, hope its help you to find out the both billing document and accounting document.

*--- Data are fetched from table RSEG
      SELECT belnr            "Accounting Document Number
             gjahr            "Fiscal Year
             buzei            "Document item in invoice document
             ebeln            "Purchasing Document Number
             matnr            "Material Number
             bukrs            "Company Code
             werks            "Plant
             FROM rseg
             INTO TABLE it_rseg
             FOR ALL ENTRIES IN it_mseg <internal table filled from MSEG table>
             WHERE matnr = it_mseg-matnr
             AND bukrs = it_mseg-bukrs
             AND werks = it_mseg-werks
             AND ebeln = it_mseg-ebeln.

*--- Data are fetched from table RBKP
        SELECT belnr         "Document number of an invoice document
               gjahr         "Fiscal Year
               xblnr         "Reference Document Number
               FROM rbkp
               INTO TABLE it_rbkp
               FOR ALL ENTRIES IN it_rseg
               WHERE belnr = it_rseg-belnr
               AND gjahr = it_rseg-gjahr.

Regards,

Sayak

Re: Document number

Former Member — Thu, 09 Apr 2009 07:23:53 GMT

Hello Rajalakshmi,

You can find this in the table VBFA.

Give the invoice number in Preceeding document field and get the entries.

You will get the subsequent entries of the invoice. i.e. after invoce what ever the document generated for the invoice wil be displayed. Using subsequnet doc. type you can find the required document.

Best Regards,

Sasidhar Reddy Matli.

Re: Document number

Former Member — Thu, 09 Apr 2009 07:24:26 GMT

hi,

try with table : BKPF OR VBFA

RAHUL

Edited by: RAHUL SHARMA on Apr 9, 2009 3:24 AM

Re: Document number

Former Member — Thu, 09 Apr 2009 07:29:09 GMT

Sorry am not still clear with this.I have a invoice document number in an internal table using that i want to update the status of bseg table.Plz help to do it.

Re: Document number

Former Member — Thu, 09 Apr 2009 07:37:06 GMT

Get billing document number from VBFA ref to invoice number..

Kiran

Re: Document number

Former Member — Thu, 09 Apr 2009 07:37:16 GMT

Get billing document number from VBFA ref to invoice number..

Kiran

Re: Document number

Former Member — Thu, 09 Apr 2009 08:00:56 GMT

Hi Lakshmi,

Table VBRL-VBELN has Invoice Document No. and the same table has VBRL-VBELN_VF as the Billing document No.

take the billing document No. and

VBRL-VBELN_VF = VBRK-VBELN = BSEG-VBELN.

Or go in a reverse way--- BSEG ~~> VBRK~~-> VBRL

Hope this solves your problem.

Thanks & regards,

Dileep .C

Re: Document number

Former Member — Thu, 09 Apr 2009 09:34:12 GMT

if u have accounting number. bkpf-xblnr.

if s

then

SELECT * FROM BKPF INTO TABLE GT_BKPF

WHERE AWTYP = 'VBRK' .

u will get gt_bkpf-AWKEY.

'0' + VBRK-VBELN = GT_BKPF-AWKEY.

IN THIS WAY U WILL GET VBRK-VBELN .

that is invoice no.

HOPE THIS HELP.

Re: Document number

Former Member — Thu, 09 Apr 2009 09:40:53 GMT

hi,

RESG and RBKP are the two table..

RESG contains accounting document number

RBKP conatins invoice document number

hope this helps

Regards

RItesh J