Archived CO documents from table COEP

[Former Member]

Hello guys,

for module PM (plaint maintenance) I coded an customer report which displays the cost per year for every WBS element. Therefor I select items from CO table COEP. Unfortunately all items from 2010 and earlier are archived, so I canot find any data in COEP for these years.

Is there any way / table where I can find them? In some SAP standard report painter reports (S_ALR_*) the costs still get displayed. Not the items but the sumarized cost value. How can I make that too? 🙂

Thanks a lot!

Regards

Michael

[Former Member]

Hello guys,

for module PM (plaint maintenance) I coded an customer report which displays the cost per year for every WBS element. Therefor I select items from CO table COEP. Unfortunately all items from 2010 and earlier are archived, so I canot find any data in COEP for these years.

Is there any way / table where I can find them? In some SAP standard report painter reports (S_ALR_*) the costs still get displayed. Not the items but the sumarized cost value. How can I make that too? 🙂

Thanks a lot!

Regards

Michael

[RaymondGiuseppi]

You could

• Use total tables COSS and COSP which may not have been yet a rchived (Why did you use detail tables as COBK/COEP which are largest usually, which information was required ?)
• Use the Archive SDK to access archived data (object CO_ITEM) ( Read Data Archiving with Archive Development Kit (ADK) or use search tool on FM ARCHIVE_GET_TABLE or look at demo function group DEMOCLASS)

Regards,

Raymond

[Former Member]

I used COEP - and yes I know its pretty tough because it takes a lot of select time - because I summarize the cost per order and the order number I only get in items table COEP.

Of course when using archived data I canot summarize per order, but for our building department general cost per WBS element is better than no cost 🙂

I will have a look at the ADK tomorrow 😉

Regards

Michael

[RaymondGiuseppi]

Which kind of order, in total tables COSS/COSP you have the object number, and this should be the object number of order, WBS or any other CO object : e.g. AUFK-OBJNR, PRPS-OBJNR, etc. So you should not be required to access detail data (of course you have to convert OBJNR to AUFNR, with a small JOIN using a secondary index, not generating performance problem, should be faster than COBK x COEP ? )

Hint: Look at COSS or COSP table for records with OBJNR like 'OR%'. (resp. PR% for WBS)

Regards,

Raymond

[Former Member]

Yes its AUFK-OBJNR, but its a bit tougher 🙂

Our building department wants to compare planned cost and actual cost for every WBS. For getting it more in detail in relation to actual cost every single order is displayed with its cost. And the last one and final reason for using COEP is these cost should be displayed individual for every year. For example they want to see cost of all WBS in year 2013. Of course I can use COSS so far, but now the big fact is: Not every FI/CO document that is posted in 2013 refers to year 2013, e.g. postings in 2013 which belong to year 2012. Therefor we use the settlement period field in BSEG.

So I have to do....

(1) select all orders from AUFK

(2) find the corresponding CO items in COEP

(3) look for reference FI document number in COBK

(4) look for correct BSEG position with filled ABPER field...

And yes I know - COEP and BSEG, and just because one single field in BSEG, god bless the oracle database 😉 - but I dont think there is any better way for it.

And it works with "only" 20-30 minutes per selected year Unfortunately with archived documents I got some problems as you can see 😉

Regards
Michael

[FredericGirod]

Hi,

sometimes you could play with SARI to keep data you really need into info-structure table.

You could reprocess data already archived.

But for your specific case ... use a data warehouse ..

regards

Fred