topic Re: MM_EKKO archiving issue in Application Development and Automation Discussions

MM_EKKO archiving issue

Former Member — Tue, 10 Dec 2013 10:21:01 GMT

Dear Experts,

I have a requirement to archive EKKO, EKPO tables. When i tried doing it using MM_EKKO object, im getting error that "Retention period is not maintained". But I have maintained the retention period in SPRO Tx. I have given residence time 1 and residence time 2 as '1' . Though the last changed date is far behind the current date, i'm getting this issue. Please help me out.

Thanks in advance

Regards,

Shanthi

Re: MM_EKKO archiving issue

nabheetscn — Tue, 10 Dec 2013 10:25:25 GMT

Hi Shanthi

Have you maintained the residence time based on purchasing document category/document type / item category in table T161R

Nabheet

Re: MM_EKKO archiving issue

Former Member — Tue, 10 Dec 2013 10:40:58 GMT

Hi Nabheet

Ya i have maintained the residence times in SPRO Tx and checked in T161R table too. The values have got reflected over there.

Regards,

Shanthi

Re: MM_EKKO archiving issue

Former Member — Tue, 10 Dec 2013 10:57:08 GMT

Hi,

Check the below information once again before archiving the PO's.

All PO’s are needs to be set the deletion indicator at Header Level (in EKKO). Unable to archive the PO’s without deletion flag
Need to check the tolerance period for PO’s. it means need to check the table T161R

Need to check the residence time 2 : ( 0030 days ).

Example: PO creation date is less than the (system date – residence time 2 = PO comparison date

IF PO creation date is greater than the PO comparison date we can’t able to archive the PO’s.

Put the break point on the below report and statement you will get the problem RM06EW47

if t161r-bstyp ne ekko-bstyp or
      t161r-bsart ne ekko-bsart or
      t161r-pstyp ne ekpo-pstyp.
*     t161r-tage2 is initial.                                " 1024764
     select single * from t161r where bstyp = ekko-bstyp
                                and   bsart = ekko-bsart
                                and   pstyp = ekpo-pstyp.
     if sy-subrc <> 0.
       call function 'ARCHIVE_PROTOCOL_COLLECT_APPL'
         exporting
           i_object = ekko-ebeln
           i_msgtype = '02'
           i_text    = text-011.
* clear is necessary for correct message in calling program.
       clear t161r.                                          "1024764
       clear p_archive.
       exit.
     endif.
   endif.

Re: MM_EKKO archiving issue

Former Member — Tue, 10 Dec 2013 11:04:50 GMT

Hi Kiran,

I have checked the dates. Actually the PO creation date is 22.01.2013 i have given both residence time1 and 2 as "1". I tried archiving today. So PO creation date is lesser than the PO comparison date

Regards,

Shanthi

Re: MM_EKKO archiving issue

nabheetscn — Tue, 10 Dec 2013 11:11:10 GMT

Can you please put a breakpoint as mentioned above. Please cross check the purchasing document which you are using its document type/category etc is maintained. Please debug it

Nabheet

Re: MM_EKKO archiving issue

Former Member — Tue, 10 Dec 2013 11:15:48 GMT

As highlighted the code above, the error is triggered particular piece of code only.

Re: MM_EKKO archiving issue

Former Member — Tue, 10 Dec 2013 11:35:59 GMT

Im getting the issue in preprocessing stage. Anyway i have set the debugger in the write program also as you suggested. But it is showing zero log messages. The control didn't reach the breakpoint

Re: MM_EKKO archiving issue

Former Member — Tue, 10 Dec 2013 11:50:53 GMT

Hi,

Put the break point on the below perform go step by step please

* EKPO
perform check_ekpo changing l_archive.

Re: MM_EKKO archiving issue

Former Member — Tue, 10 Dec 2013 12:09:30 GMT

Actually the loekz value is not set to 'L' for the POs. The field is empty.

SELECT ebeln FROM ekko INTO TABLE lt_sekko

WHERE ebeln IN er_ebeln

AND ekorg IN er_ekorg

AND bstyp IN er_bstyp

AND bedat IN er_bedat

AND bsart IN er_bsart

AND ekgrp IN er_ekgrp

AND loekz = 'L'

ORDER BY ebeln.

When the above query is executed, lt_sekko internal table is empty and control is not reaching there.

Re: MM_EKKO archiving issue

Former Member — Tue, 10 Dec 2013 13:14:20 GMT

Hi Shanthi,

I have clearly written on the first point

All PO’s are needs to be set the deletion indicator at Header Level (in EKKO). Unable to archive the PO’s without deletion flag

Re: MM_EKKO archiving issue

JL23 — Tue, 10 Dec 2013 13:41:15 GMT

Just want to advise you not to do anything foolish with the deletion indicators.

Those indicators are set with the pre-processing step. And you should check the log if the deletion indicator was not set, there you can find the reasons why it was not set.

The residence time alone does not decide if a document can be archived. A document has to be closed from a business point of view. if you have for example a difference between invoice and goods receipt then this document is not ready to be archived, even the residence time is over

Re: MM_EKKO archiving issue

Former Member — Wed, 11 Dec 2013 04:37:06 GMT

The problem is with the preprocessing step. I think only this program sets the deletion indicator for POs at header level. But when i run this program, i'm getting issues that retention period is not maintained and the deletion indicator is not set. Is there any other way to flag the POs at header level?

Re: MM_EKKO archiving issue

Former Member — Wed, 11 Dec 2013 04:39:57 GMT

Hi Jurgen

When i ran the preprocessing step, the log contains only one message that retention period is not maintained. But they are already set. As this is not successful the deletion indicator is not set.

Re: MM_EKKO archiving issue

Former Member — Wed, 11 Dec 2013 06:58:45 GMT

Is it necessary that the document must be closed in order to archive the PO data. Can't we do it at any stage we want?

Re: MM_EKKO archiving issue

Former Member — Wed, 11 Dec 2013 07:09:18 GMT

Hi Shanthi,

No you can't do it! document must be closed. If you are not close the document, it should be the major impact on the business.

For example, You created delivery with reference to PO. The goods are in transit with reference to your PO. So how can you archive the PO without closing the delivery. If you archive the PO, there is no reference document to receive the goods.

I hope you understand the situation.

Thanks,

Kiran.

Re: MM_EKKO archiving issue

Former Member — Wed, 11 Dec 2013 07:34:02 GMT

Ya i understood Kiran. Thank you.

Re: MM_EKKO archiving issue

Former Member — Wed, 11 Dec 2013 07:34:49 GMT

Thank you all.

Regards,

Shanthi

Re: MM_EKKO archiving issue

JL23 — Wed, 11 Dec 2013 09:38:52 GMT

Does it really talk about retention period? or about residence time?

the logic is explained in OSS note 588463 - Importance of residence times during archiving

you have to have an entry for each combination or purchasing document type and iten category in table T161R

if you are certain that you have one, then have a look into OSS note 335800 - SARA: Deletion indicator not set, but why?

it explains how and where to debug .

further reasons that prevent setting a deletion flag are explained in OSS note 401318 - Archiving: Additional information

Re: MM_EKKO archiving issue

Former Member — Wed, 11 Dec 2013 12:27:48 GMT

Ya the log message is "Retention period is not maintained". I think there is some data inconsistency.