topic Re: function module to get data for invoice in Application Development and Automation Discussions

function module to get data for invoice

Former Member — Thu, 20 Sep 2007 10:13:13 GMT

hi all,

I am working on the smart forms for invoice document.

Tables VBRK VBRP for invoice header and details respectively.

Is there any function module 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 delivery document number from LIPS and LIKP

thanks

ekta

Re: function module to get data for invoice

Former Member — Thu, 20 Sep 2007 10:15:56 GMT

hi ekta,

check this function BAPI_INCOMINGINVOICE_GETDETAIL

Reward points if helpful,

regards,

jinesh.

Re: function module to get data for invoice

Former Member — Thu, 20 Sep 2007 10:20:30 GMT

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'.

Reward if useful.

Regards,

Pritha.

Re: function module to get data for invoice

Former Member — Thu, 20 Sep 2007 10:50:05 GMT

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