function module to get data for invoice

[Former Member]

hi all,

I am working on the smart forms for invoice document.

Tables <b>VBRK VBRP</b> for <b>invoice header and details </b>respectively.

Is there any <b>function module</b> for getting the data for a particular invoice document number.

I am not able to find all the required data fields from table can you please help me in getting the data even for the <b>delivery document</b> number from LIPS and LIKP

thanks

ekta

[Former Member]

hi ekta,

check this function BAPI_INCOMINGINVOICE_GETDETAIL

<b>Reward points if helpful,</b>

regards,

jinesh.

[Former Member]

Hi Jinesh,

I tried to use the FM you suggested me. But I am not able to get the value of the Fiscal year . Can you suggest me from where i will get the value of fiscal year.

thanks

ekta

[Former Member]

Hi,

The document flow for SD is contained in the VBFA table.

In case you have a sales order or delivery number and you want to find out the invoice for it, you can use the function module -

SD_VBFA_SELECT, input shall be the sales order number.

Also it will list all the preceeding and subsequent documents for the particular document.

Your invoice shall be listed as the subsequent document number with subsequent document category as 'M'.

<b>Reward if useful.</b>

Regards,

Pritha.