Skip to Content
avatar image
Former Member

InfoCube archiving

Hi everyone,

we have a field in our cube that determines if a sales order position is closed in ERP system and will not be changed anymore (KPOSSTAT = 'X').

In the cube this might look like :

DOC_NUMBER S_ORD_ITEM CALYEAR KPOSSTAT 9970001741 100 2000 9970001741 100 2012 9970001741 100 2013 X 9970001741 200 2000 9970001741 200 2012 9970001741 200 2013

What I want to do now, is to archive all sales order position records that are older than 01.01.2014 and where the position has been closed at some point in time before 01.01.2014, so basically all records for position 100. If I use KPOSSTAT = X and CALYEAR <= 2014 in my archiving process selection profile I'm going to archive only the third record for position 100. If I'm selecting only for CALYEAR <= 2014 I'm also going to archive position 200 which is not wanted.

Is this way of archiving possible at all?

Help would be appreciated.

Alexander Oertel

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Nov 25, 2014 at 02:54 PM

    as far as i understand you can create AND like filters for archiving.

    what you want to do seems like an OR filter.

    Do I understand you right?

    Marco

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 25, 2014 at 03:36 PM

    You can try to add another field in the cube (a flag) which gets populated only when both of your conditions are met and based on this you can do the archiving.

    Regards,

    Arminder

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 25, 2014 at 03:42 PM

    Hi Alexander,

    Assumming that the filter in dtp have <2014.

    You need create a init routine, with for all entries in your source_package and the where instruction KPOSSTAT EQ X.

    And in loop instruction need a execute a read table with doc_number and s_ord_item, and add in your archiving.

    I hope help.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded