Directly update document status in database table

[former_member287204]

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

[Former Member]

Please check idoc status.

[Former Member]

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.

[former_member287204]

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

[Former Member]

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

[former_member287204]

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

[former_member287204]

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

[former_member287204]

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

[former_member287204]

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