Question Re: Archieved Data Loading in Technology Q&A

Archieved Data Loading

Former Member — Mon, 14 Sep 2009 14:24:17 GMT

Hi sap gurus, I'm using 0FI_AR_4 data source. I figure out some of data isn't collected by data extractor. eventhough bsid and bsad tables have these data, extractor can't collect them(I can't see rsa3 and psa). when I search these FI documents, I realize these documants are arciheved. why extractor can't collect these data even bsid and bsad tables have?

I searched forum. there is a suggestion about loading arcihved data to r3, then loading to bw. is it usable?

Re: Archieved Data Loading

dennis_scoville4 — Mon, 14 Sep 2009 16:57:46 GMT

The standard content extractors do not extract items that have been flagged for archive (in your case BSID-XARCH or BSAD-XARCH with a value of 'X'). In order to be able to extract those rows of data, you have a couple of options:

1) Create a User Exit routine in CMOD for the 0FI_AR_4 DataSource to additionally extract data where BSID-XARCH = 'X' and BSAD-XARCH = 'X'.

2) Create a generic DataSource to extract only those records from BSID and BSAD where XARCH = X.

Archived documents should not change at all and therefore only require a single Full extraction, therefore Option 2 may be your best choice in this instance.

Re: Archieved Data Loading

Former Member — Mon, 14 Sep 2009 17:59:54 GMT

Thanks Dennis, I will try the second way but when I create generic data source, I can just define table. How can restrict data source by a specific field (xarch)?

Re: Archieved Data Loading

dennis_scoville4 — Mon, 14 Sep 2009 18:09:29 GMT

You could create the generic DataSource based on a Function Module. Use Function Module RSAX_BIW_GET_DATA_SIMPLE as a template for your generic DataSource Function Module and copy the extract structure for 0FI_AR_4 as your extract structure for the generic DataSource.

Re: Archieved Data Loading

Former Member — Mon, 14 Sep 2009 18:10:30 GMT

If you are defining a view you will have selection in view where you can restrict XARCH = 'X'.

Can you check and let us know whether your BSID and BSAD has any value with XARCH = 'X'.

Generally i have heard that when archeived they wont be available in database tables and you need to do some special mechanism to retreive the data from archeive. Just curious to know about it.

Hope this helps for you.

Thanks,

Arun

Re: Archieved Data Loading

Former Member — Tue, 15 Sep 2009 07:21:09 GMT

Hi, I checked BSAD table. there are datas which have XARCH ='x' even they don't come to bw side. I will create a view based data source and collect these data to bw.