cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

SLT: Add field to target structure from logging table

artemiy_rogachkov
Discoverer
0 Likes
1,424

Hi all!

We have connections in SLT from SAP ECC to SAP DI. How can we add the field IUUC_TIMESTAMP ( timestamp1.jpg) from the source logging table to target structure (or table), is it possible by edditing migrating object ?

Accepted Solutions (0)

Answers (2)

Answers (2)

BlackmanCC
Explorer
0 Likes

I have now managed it. There is an old and a new loading mechanism.
You can switch to the old replication mechanism using report IUUC_REPL_SWITCH_REC_MCHNSM from note 3448296. The _it_io_s_logtab is then usually also available.
However, you should note that the old replication mechanism has some limitations, e.g. no CDS views can be used with it.
https://help.sap.com/doc/9d634180094347038e7b8c96661dc36b/latest/en-US/Compatibility_Views_and_SAP_L... 
It would of course be great from SAP if the _it_io_s_logtab table was also filled with the new replication mechanism.

Translated with DeepL.com (free version)

ian_kirkman
Product and Topic Expert
Product and Topic Expert
0 Likes

Hi Artemiy,

This question would be best asked of a consultant.

I know this can be done for the standard SLT replication scenario for SLT. To transfer the value of IUUC_TIMESTAMP to a target table field, this would be done by assigning a BoR (Begin of Record) event rule to the table that has coding starting "READ TABLE _it_io_s_logtab ASSIGNING <wa_io_s_logtab> WITH KEY".

For example with the COBK table (key fields being MANDT, KOKRS and BELNR) it would be:

READ TABLE _it_io_s_logtab ASSIGNING <wa_io_s_logtab>

WITH KEY mandt = <wa_s_cobk>-mandt

kokrs = <wa_s_cobk>-kokrs

belnr = <wa_s_cobk>-belnr.

If sy-subrc = 0.

<WA_R_[target table name]>-[target field name] = <wa_io_s_logtab>-IUUC_TIMESTAMP.

ENDIF.

Regards,
Ian
SAP Product Support

BlackmanCC
Explorer
0 Likes

Hi Ian,

this sounded good, but I do not have a _it_io_s_logtab table in my BoR rule for table BUT000.
I only have table _IT_IO_S_BUT000 with field /1DH/OPERATION and not the IUUC_TIMESTAMP.
I use embedded SLT in S/4 HANA 2023 FPS2.
What else can I do?

Thanks and regards
Jens