topic Re: BAPI / Function Module to Retrieve AR Customer Invoices like FB03 in Application Development and Automation Discussions

BAPI / Function Module to Retrieve AR Customer Invoices like FB03

Former Member — Mon, 15 Oct 2007 14:55:03 GMT

I’m writing some code to post and retrieve AR Customer Invoices. It looks like BAPI_ACC_DOCUMENT_POST is the way to create the invoice (any way to park it?) but I’ve only found BAPI_AR_ACC_GETOPENITEMS to retrieve invoice data which does not seem like what I really want. I do want line item details but only for the invoice I’m after and it may not be open any longer. T-code FB03 is the GUI way. How do I get the invoice data throug a remote enabled BAPI or FM?

Thanks for any help,

Karl

Re: BAPI / Function Module to Retrieve AR Customer Invoices like FB03

Former Member — Mon, 15 Oct 2007 14:58:57 GMT

BAPI_INCOMINGINVOICE_CREATE Invoice Verification: Post Invoice

After the CALL of BAPI_ACC_INVOICE_RECEIPT_POST is finsihed and there are no errors, you have to call 'BAPI_TRANSACTION_COMMIT' to commit the invoice.

Please give me reward points if it is useful...

Re: BAPI / Function Module to Retrieve AR Customer Invoices like FB03

Former Member — Mon, 15 Oct 2007 15:03:02 GMT

Hi,

Please try this BAPI or FM.

BAPI_ACC_DOCUMENT_DISPLAY

FI_DOCUMENT_LIST_DISPLAY

Regards,

Ferry Lianto

Re: BAPI / Function Module to Retrieve AR Customer Invoices like FB03

Former Member — Mon, 15 Oct 2007 15:14:30 GMT

Thanks for your reply Ferry! I looked at BAPI_ACC_DOCUMENT_DISPLAY and FI_DOCUMENT_LIST_DISPLAY but I want to retrieve the data programmatically so I can evaluate the information in code instead of displaying it. There may not be SAPGUI where the program is being run.

Re: BAPI / Function Module to Retrieve AR Customer Invoices like FB03

Former Member — Mon, 15 Oct 2007 15:20:45 GMT

Hi,

Please check this BAPI BAPI_ACC_DOCUMENT_CHECK.

Regards,

Ferry Lianto

Re: BAPI / Function Module to Retrieve AR Customer Invoices like FB03

Former Member — Mon, 15 Oct 2007 15:21:10 GMT

Hi Karl

What you really need to do?

The BAPI BAPI_ACC_DOCUMENT_POST should return the number of the document is created, so u can do a select on BKPF and BSEG table in order to return the informations.

Max

Re: BAPI / Function Module to Retrieve AR Customer Invoices like FB03

Former Member — Mon, 15 Oct 2007 16:03:31 GMT

Ferry: Thanks again for the follow-up. BAPI_ACC_DOCUMENT_CHECK will verify data before a post is attempted but I do not think it will retrieve information on a document.

Max: I want to retrieve line item detail of a Customer Invoice so I can compare the data against a remittance for example. I believe RFC_READ_TABLE on BKPF and BSEG is the way to go. I was hoping that it was nicely wrapped up in a BAPI or FM but this will work. Thanks!

Re: BAPI / Function Module to Retrieve AR Customer Invoices like FB03

former_member194669 — Mon, 15 Oct 2007 16:10:34 GMT

Hi,

fm RFC_READ_TABLE have a limitation of length. The output length is restrictied to 512.

a®