Financial Accounting: Line Item Extraction Procedure - Help

[Former Member]

Hi,

We are loading ODS object 0FIAR_O03 from datasource 0FI_AR_4.

1. Full load with data selection - COMP_CODE=0101;0FISCPER=2006001-2006012;

It loaded 2668 records in the ODS.

2. Then we deleted the full load request and tried to perform init data transfer with data to the same ODS from same datasource with same data selection.

Here it loaded 1504 records.

I guess in both the cases it should have loaded same no. of records.

Can anybody help me to find me why its not giving same no. of records in both the cases.

Thanx,

Prerana

[Former Member · Accepted solution]

Hi,

This is because, whenever we load a INIT / DELTA Load system checks for the TIMESTAMP and when we load a FULL load it does not.

I had a similar problem with a particular data load where we used to load Delta's continuously and once a particular Delta load failed. And the system was not able to recognize the failed delta, thats it was not able to find whether or not the last delta was GREEN/RED. Hence we had to do a INIT without Data Transfer which was recognized by system for the next Delta and it loaded fine.

Hence I came to know that it checks for the TIMESTAMP only in case of INIT / DELTA and NOT FULL.

Hope it helps,

Pradip Parmar

[Former Member · Accepted solution]

I got the problem.It was because of timestamp.

Can anybody tell me the table where the timestamp is stored?

Can I change it?

Thank you.

Prerana

[Former Member · Accepted solution]

Hi,

It is available in the table BWOM2_TIMEST.

by the by what is the plugin used in r/3 ?

With rgds,

Anil Kumar Sharma .P

[Former Member · Accepted solution]

Hi,

I know this table BWOM2_TIMEST.I could find the timestamp from this table.But I would like to know where can we reset the timestamp?

Thanx,

Prerana

[Former Member · Accepted solution]

Hi Prerana

Check this document

www.service.sap.com/bi>infoindex->extraction>Data Extraction (Line Item Level) FI/CO (ppt)

In this you would be able to figure out how to configure timestamp.

Also take a look at OSS Note 416265 'BCT-CO delta DataSources: Technical background information'

Hope this helps

Regards

Pradip

[Former Member]

hi,

have a look at this help doc:

http://help.sap.com/saphelp_bw33/helpdata/en/af/16533bbb15b762e10000000a114084/content.htm

sham'm

[Former Member]

Have a look at this:

and also

Regards