GR and Invoice status

[Former Member]

Hi Gurus,

In srm system is there any table or rfc to find status(open/closed) of gr and invoice.GR is done in srm system then replicated to back end.invoice is done in backend.

Regards,

Shiva

[Former Member · Accepted solution]

Hi Shiva,

Generally whenever a material confirmation is created in the SRM

system, an IDoc is posted from the SRM to the R/3 system and an entry

(with DocType IM) is written into the table BBP_DOCUMENT_TAB. The

sending of the IDOC is then checked by the background job CLEAN_REQREQ_UP. The report reads the BBP_DOCUMENT_TAB and makes a RFC

(remote function call) per META_GOODSMVT_UPDATECHECK to check the

posting of inbound IDoc

If the IDoc is posted successfully (status 53), the SRM confirmation receives status I1018 - "Transmit to Backend System". In addition, the entry is deleted in BBP_DOCUMENT_TAB.

When I run CLEAN_REQREQ_UP, if there are no errors then the confirmation will be sent to the backend and update the backend PO.

Now the confirmation will have status u201CPosted to Backendu201D in the confirmation transaction. If you look at it in transaction BBP_PD you should see the statusu2019 something like

Status Description Inactiv

I1015 Awaiting Approval X

I1017 Currently Being Transferred X

I1018 Posted in the Backend

I1021 Created

I1022 Approved

I1038 Complete

I1044 Confirmed

The central confirmation transaction actually users FM META_PO_GETDETAIL to get information from the backend PO so if you were to create a report or just want information on the status of the backend documents from your SRM system then this function module would be the way to go. BBPCF03 calls the RFC for the backend because it cannot trust that the Local SRM PO is completely up to date (an invoice might be created in the backend)

META_PO_GETDETAIL Display purchase order details

Hope this answers your question.

Kind regards,

Matthew

[Former Member]

Hi Matthews,

Thanks for the reply.I am able to find no_more_gr field in po_item_history table using META_PO_GETDETAIL.

Do any table has information regarding invoice closed field.

Thanks and Regards,

Shiva

[Former Member]

Hi Shiva,

Yes, If you have a look at a PO in BBP_PD click on the item and see table BBP_PDIGP

Field FINAL_INV is similar to FINAL_ENTRY in this respect.

Also field NUM_INV has the number of invoices created.

Returning from META_PO_GETDETAIL in the item also is FINAL_INV

Hope this helps,

Kind Regards,

Matthew

[Former Member]

Hi,

Even if invoice is fully done.Final_inv is not set.

Thanks,Regards,

Shiva