LO Extraction:
Lo extraction for the full load data is
taken from SETUP tables to BW when we run Full loadAnd the deltas are from
DeltaQueue
FI Extraction:
No setup tables for FI Extraction. Full upload in FI,
data will be taken from R/3 tables And for deltas we need to initialize the
delta process(Infopackage level,update tab) then it will create an entry in
Delta queue(RSA7) in R3 by displaying Datasource technical name.
Once the datasource is
initialized, it means that the Datasource is capable of accepting deltas from
the next load. So for deltas the data will be taken from R3 tables and pass
through RSA7.
0FI_GL_4, 0FI_AP_4, 0FI_AR_4 use an After Image Delta
Delta type “Extractor“:
·
Delta records are
directly selected from the R/3 tables using a
timestamp mechanism.
·
Delta records are
directly transferred to BW. No record is written to
the BW delta queue.
After Image Delta:
·
FI line items are
transferred from the source system in their final
state (= “After Image“).
·
This delta method is not
suitable for direct InfoCube update.
·
ODS object is obligatory
to determine the delta for InfoCube update.
Where BW Delta Queue is used:
·
Delta queue and BW
scheduler ensure correct serialization of the
records (e.g. inserts
must not pass changes)
·
Distribution of delta
records to multiple BW systems.
·
Selection criteria of
Delta-Init upload are used to “couple” the
datasources
logically.
