Archieved Data Loading

[Former Member]

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?

[dennis_scoville4 · Accepted solution]

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.

[Former Member · Accepted solution]

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)?

[dennis_scoville4 · Accepted solution]

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.

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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.