ROOSURCE Doubt

[Former Member]

Hi ,

When i see the following ,

Table : ROOSOURCE

Field : Delta Process

Some search help Values are :

A , ABR , ABR1 , ADD (LIS) , AIM ( FI ) , FIL0 , FIL1

What does this mean ?

There some terns named used in that search help like

<b>After image</b> , <b>Before Image</b>

What does that mean ?

Kumar

[Former Member · Accepted solution]

Hi Kumar,

Those are the delta types. If you want any info for any of the fields then just select the select and press F1. You should get more info.

Bye

Dinesh

[Former Member]

Hi Kumar,

Before & After Image - Check the examples in these posts:

Additive Delta -

Bye

Dinesh

[Former Member]

Hi ,

I am not clearly getting : " <b>Before Image , After Image , Reverse Image</b> " Concept

Kindly explain this with simple example ?

Kumar

[Former Member]

hi Kumar

In the ODS we have 0record Mode which captures the data from the source sytem .For Ex:

MID Qty Price

001 10 600

the obove data ur sending to the ods then the images will be N

MID Qty price

001 9 500

wene ur sending this data to the ods Then it the Before Image is "X" ie 10

After Image is " " ie 9

Only Provides the Key information required to make a deletion

"delte"=Record mode "D"

Send the information required to numerically" cancel" a deleted record

"Reverse"="Record Mode "R"

So each record should be Classfied Like

Data Target UpdateMethod

Before Image X Cube Add

After Image " " ODS Overwrite/ADD

Addtive Image A CUBE Add

ODS Add Only

After Image " " Cube Not allowed

ODS Over write

Reverse Image "R" Cube Add

ODS Add/Overwrite

delte Image "D" Cube Not Allowed

ODS Overwrite

With the help of the record modes ODs Or cube can identify the deltas.

PLS DO ASSIGN POINTS IF IT IS USEFULL

[Former Member]

Hi Kumar,

Check this link for delta types:

http://help.sap.com/saphelp_nw04/helpdata/en/80/1a64d3e07211d2acb80000e829fbfe/content.htm

Bye

Dinesh

[Former Member]

Hi ,

What is the meaning for following

" <i>The field 0RECORDMODE determines whether the records are added to or overwritten. It determines how a record is updated in the delta process: A blank character signifies an after image, ‘X’ a before image, ‘D’ deletes the record and ‘R’ means a reverse image</i>. "

Where it will ' Add ' or 'Over write'.

I am not clearly getting : " Before Image , After Image , Reverse Image " Concept

Kumar .

[edwin_harpino]

hi Kumar,

check this

http://help.sap.com/saphelp_nw2004s/helpdata/en/84/81eb588fc211d4b2c90050da4c74dc/frameset.htm

Delta Process

Definition

The delta process is a feature of the extractor and specifies how data is to be transferred. As a DataSource attribute, it specifies how the DataSource data is passed on to the data target. From this you can derive, for example, for which data a DataSource is suited, and how the update and serialization are to be carried out.

Use

The type of delta process affects the update into a data target. When you update data in an ODS object, you need to serialize it so that you can also overwrite it. According to the delta process, the system decides whether it is necessary to serialize by request or by data packet.

Structure

There are various delta processes for SAP source systems:

...

1. Forming deltas with after, before and reverse images that are updated directly in the delta queue; an after image shows the status after the change, a before image the status before the change with a negative sign and the reverse image also shows the negative sign next to the record while indicating it for deletion. This serializes the delta packets. The delta process controls whether adding or overwriting is permitted. In this case, adding and overwriting are permitted. This process supports an update in an ODS object as well as in an InfoCube. (technical name of the delta process in the system): ABR)

2. The extractor delivers additive deltas that are serialized by request. This serialization is necessary since the extractor within a request delivers each key once, and otherwise changes in the non-key fields are not copied over correctly. It only supports the addition of fields. It supports an update in an ODS object as well as in an InfoCube. This delta process is used by LIS DataSources. (technical name of the delta process in the system): ADD)

3. Forming deltas with after image, which are updated directly in the delta queue. This serializes data by packet since the same key can be copied more than once within a request. It does not support the direct update of data in an InfoCube. An ODS object must always be in operation when you update data in an InfoCube. For numeric key figures, for example, this process only supports overwriting and not adding, otherwise incorrect results would come about. It is used in FI-AP/AR for transferring line items, while the variation of the process, where the extractor can also send records with the deletion flag, is used in this capacity in BBP. (technical name of the delta process in the system): AIM/AIMD)