COPA - delta relevant field

[Former Member]

hi experts,

I have created COPA data source in keb0, the delta method shows as Generic delta. here i have not done any settings for delta management. but when i do Full, init & delta info packages it woks correctly.

i have some doubts... on whether delta relevant field is set automatically here. if so, how do we know which field it is.?

also,

what is the difference between generic delta and timestamp delta..

should we do any settings related to delta, so as to make delta work correctly.

regards.

[Former Member · Accepted solution]

You can get to know which delta is set in RSO2 transaction

In timestamp delta..timestamp of last delta is recorded in table ROOSGENDLM when new delta is triggered the records will pe picked timestamp greater than as present in table.

also pls see

[Former Member]

ive one more doubt like.

what is the difference between generic delta & timestamp delta in keb0 delta method?

up on what basis is both created automatically.

regards.

[Former Member]

im facing 2 issues:

1. im not able to display COPA data source in RSO2, it is showing in rsa6 as welll as BI

2. in roosource, field deltasafe2 is showing the safety limit, is there a way to find which is the delta specific field set for this data source.

regards.

[Former Member]

1. You cannot check COPA datasource/delta from RSO2. Use transaction KEB0 to check the datasource. KEB2 has lot of info on your COPA data loads/timestamps.

2. To know the field, i guess you would have to debug the FM RKE_BIW_GET_DATA_API. This is the FM used by the COPA datasource to extract data.

[Former Member]

can anyone explain different fields of exmethods in roosource like

V Transparent Table or DB View

D Fixed Domain Value

F1 Function Module (Complete Interface)

F2 Function Module (Simple Interface)

FS Function Module (Segmented Data Transfer)

Q Extraction Using ABAP Query

A DataSource Append

2. is extractor RKE_BIW_GET_DATA_API automatically created, is this FM getting automatically changed when we append fields to structure of a data source?

regards.

[Former Member]

1. V - When you create generic DS in RSO2 on a table/view.

F* - Extraction is using funtion modules. You can create a generic FM in RSO2 and use FM to extract. Most of the std

datasources are based on FMs, like std LO & FI datasources.

Q - We can create generic datasources from RSO2 using infoset queries/ABAP queries created in ECC.

not sure about the rest.

2. This FM gets generaed automatically when COPA datasource is created. This does not get changed when we append fields. For fields that we append we have to write code in CMOD. This FM won't extract for such fields.

[Former Member]

Yes. it is set automatically. we need not do anything. One thing to note is there is a safety interval upper limit set automatically to 30 min, which means when you run the extraction now, records posted in the last 30 min would not be extracted. Those records would be extracted in the next delta load.

When delta is run, records get selected from the tables (CE1****, etc. I guess we have a timestamp field in the tables) and the timestamp will be recorded in the delta control table ROOSGENDLM. When the next delta is triggered the timestamp of last extraction is picked from the table and selection of records will be done from the database tables.

[Former Member]

where can we see the safety upper limit set to 30 mins?

[Former Member]

in transaction RSO2...give DS name and select generic delta

[Former Member]

Hi

Open your data source in RSO2.

click on generic delta on top, you can check the delta field and safety upper limit and lower limit.

Regards,

Venkatesh

[Former Member]

Table ROOSOURCE, field DELTASAFE2