Child pages
  • ROOSGENDLM vs Init/Delta extraction
Skip to end of metadata
Go to start of metadata

Purpose:

Test how the datasource based on UTC timestamp works

Create a Datasource based on View and Generic Delta is Time Stamp(UTC)

Source view: 
ZAIRLINEID-TIMESTAMP is defined as UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Its entry in table ROOSOURCE is as below:

   OLTPSOURCE                     OBJVERS TYPE APPLNM      DELTA       GENDELTAFD        GENDELTATP

   ZAIRLINEID_MD                  A       TRAN BW_TECH          AIE             TIMESTAMP        U

Check the time relevant:

ECC System time: 14.05.2021 04:04:46 

SE38 -> TZCUSTHELP ->

Input the current date and select the current time:

Current Date                      14.05.2021

Current Time                      04:04:46

Time Zone                         CET

->

System Date.....................:                            14.05.2021

System Time.....................:                            04:04:46

System Time Zone Offset to UTC..:           3.600

System Currently in DST.........:                   YES

Current UTC Date................:                       14.05.2021

Current UTC Time................:                        02:04:46

Simulate Delta init by report rodps_repl_test:

se38 → rodps_repl_test → ZAIRLINEID_MD / Last Delta → Execute

After DeltaInit, column DELTAID is changed to the date/time of the simulation run:

Table:          ROOSGENDLM

   OLTPSOURCE         SLOGSYS          DELTAID

   ZAIRLINEID_MD    BZHCLNT003    20210514021007  -- UTC time

Create Delta data:

Manually insert a new entry in ZAIRLINEID:

MANDT 003
CARRID AD

TIMESTAMP 20.210.514.021.216
MYDATE 14.05.2021
MYTIME 00:00:00

Test the delta extraction by the same report rodps_repl_test :

se38 → rodps_repl_test -> ZAIRLINEID_MD / Last Delta → Execute.

Debug to see the details that how to determine the lower and upper time:

FORM GENDELTA_GET_HIGH

    WHEN rsaot_c_gendeltatp-timestamp_utc.

*-------- deltarelevantes Feld ist ein UTC-Zeitstempel --------------

      l_duration = i_s_gendelta-deltasafe2.

      DATA: l_tstmp_utc TYPE timestamp,  <---

      GET TIME STAMP FIELD l_tstmp_utc.  -- 20210514021943, current UTC time.

→ After call GENDELTA_GET_HIGH: Upper Limit = CHANGING g_s_status-deltaid. -- 20210514021943

→ Then fetch the delta data from source view ZAIRLINEID:

    Select ... from ZAIRLINEID where timestamp BT 20210514021007 and 20210514021943.

→ After delta run, ROOSGENDLM-DELTAID is changed to 20210514021943 from the last old DELTAID 20210514021007. (in Function module RSA8_GENDELTA_CONFIRM)

The result of delta run is:

AD        20.210.514.021.216        14.05.2021        00:00:00        U        1