topic Re: Directly update document status in database table in Application Development and Automation Discussions

Directly update document status in database table

former_member287204 — Wed, 16 Sep 2015 03:00:05 GMT

Dear Experts,

We will plan to execute archieving for Material nos. Before archieving the Materials nos., I know that the related documents must also be completed and archieved first. The list of our Materials nos. are belong to Finished Good so the related documents are Inquiries, Quotations, Sales Orders, Delivery Notes, Billing, Interco. Billing (for most of Delivery Notes) and Accounting documents. However, we found that some of the documents were not completed as below -

1) Delivery Note - "Interco. Billing Status (VBUK-FKIVK)" = "A - Not yet processed (Relevant)". Refer "Screen_95 Sep. 15 17.19_Q1.jpg" for details.

2) Billing - "Posting Status (VBRK-RFBSK)" = "Blank - Error in Accounting Interface". Refer "Screen_93 Sep. 15 16.55_Q2.jpg" for details.

3) Accounting document - Not Cleared. Refer "Screen_94 Sep. 15 17.01_Q3.jpg" for details.

As the above o/s documents had already been lasting for many years and our users might not be able to proceed these documents (from the operational point of view). If we developed a customized program to directly batch update the relevant database table so as to update the status of the above documents to "Completed" or "Cleared", is it feasible to proceed this (for archieving) ? and will there be any impact on this ?

Tks,

KH Fong

Re: Directly update document status in database table

Former Member — Wed, 16 Sep 2015 04:19:39 GMT

Please check idoc status.

Re: Directly update document status in database table

Former Member — Wed, 16 Sep 2015 04:23:08 GMT

You can display the archived data, but not reload it.

To archive the material master, first goto transaction ->........MM71.

->Type in a variant name and click Maintain. ->Tick the Test Mode for archive simulation.

->Save the variant.

->Maintain the Start date and Spool parameters and click execute.

->Click Goto Job Overview to check the archive status.

Re: Directly update document status in database table

former_member287204 — Wed, 16 Sep 2015 07:26:46 GMT

Dear P. Bhagaban,

When archieving Material nos. (Object: MM_MATNR) and Sales Orders (Object: SD_VBAK), found errors as below. These errors should be due to the above problems. That's why I asked you as above.

Could you advise ?

Tks,

KH Fong

Re: Directly update document status in database table

Former Member — Wed, 16 Sep 2015 07:52:41 GMT

Wil you check idoc status before Archiving ur idoc ?

Because , idoc status status should be error free before Archieve .

note : after archive idoc u can check

[ To change the status of the IDocs, execute the program RC1_IDOC_SET_STATUS. ]

Re: Directly update document status in database table

former_member287204 — Thu, 17 Sep 2015 01:56:08 GMT

Dear P.Bhagaban,

We are not using idoc for this case ? Do you mean the idoc is our related archieving docs. ? If so, the related docs' status is as above, i.e.

1) Delivery Note - "Interco. Billing Status (VBUK-FKIVK)" = "A - Not yet processed (Relevant)". Refer "Screen_95 Sep. 15 17.19_Q1.jpg" for details.

2) Billing - "Posting Status (VBRK-RFBSK)" = "Blank - Error in Accounting Interface". Refer "Screen_93 Sep. 15 16.55_Q2.jpg" for details.

3) Accounting document - Not Cleared. Refer "Screen_94 Sep. 15 17.01_Q3.jpg" for details.

Tks,

KH Fong

Re: Directly update document status in database table

former_member287204 — Thu, 22 Oct 2015 07:42:47 GMT

Advised by the following thread -

http://scn.sap.com/thread/3800476

Just don't know whether the manually completed DNs by using the transaction "VL_COMPLETE" can be revoked to the previous status. Could you also advise ?

Tks,

KH Fong

Re: Directly update document status in database table

former_member287204 — Fri, 06 Nov 2015 06:45:40 GMT

Dear all,

Could you help to answer my above question, or just help to redirect this thread to the forum group "SAP ERP Sales and Distribution (SAP SD)" in which the expert(s) of this forum should be able to answer this question ?

Many Thanks,

KH Fong

Re: Directly update document status in database table

former_member287204 — Fri, 06 Nov 2015 07:17:34 GMT

Sorry,

Wrong clicking for the "Assume Answered" but could not be revoked. Still need your help on the above question, i.e.

Related to the following thread -

http://scn.sap.com/thread/3800476

Just don't know whether the manually completed DNs by using the transaction "VL_COMPLETE" can be revoked to the previous status. Could you also advise ?

Pls kindly help to redirect this thread to the forum group "SAP ERP Sales and Distribution (SAP SD)" if you cannot help on this question.

Tks,

KH Fong