Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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_NUMBERS_ORD_ITEMCALYEARKPOSSTAT
99700017411002000
99700017411002012
99700017411002013X
99700017412002000
99700017412002012
99700017412002013

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

Former Member
Not what you were looking for? View more on this topic or Ask a question