Home » SAP » How to Confirm Which Tables SLT Objects Belong To

How to Confirm Which Tables SLT Objects Belong To

The short URL of the present article is: https://ipraby.com/646m

How to Confirm Which Tables SLT Objects Belong To

When working with SAP Landscape Transformation (SLT) Replication Server, you may encounter technical objects with cryptic names such as /1LT/SAPL<SID><15 digit number>/1CADMC/<8 digit number>, or /1LT/<11 digit number>. Knowing which underlying table these objects are associated with is crucial for troubleshooting, development, or auditing replication setups. In this article, I’ll walk you through the steps to confirm the related tables of these SLT-generated objects using transaction SE16 and key system tables.


1. Identifying Tables for Objects Like /1LT/SAPL<SID><15 digit number>

This object type is commonly seen in SLT systems. Here’s how you can trace the related table:

Steps:

  1. Log into the SLT system (where <SID> in the object name refers to the SLT system’s SID).
  2. Use transaction SE16 to open the table DMC_FMID.
  3. Set the field IDENT with the <15 digit number> from your object’s name. Execute the query and note the value of the COBJ_GUID field.
  4. Again, in SE16, open the table DMC_COBJ. Set the GUID field to the COBJ_GUID value you just recorded. Execute the query and check the value in the IDENT field.
  5. The IDENT value will be in the format Z_<Table Name>_<MTID>, where <Table Name> is your target table and <MTID> is the mapping ID for the object.

2. Identifying Tables for Objects Like /1CADMC/<8 digit number>

There are two ways to confirm the table name for these objects:

Method 1: From the SLT System

  1. Log into the SLT system.
  2. In SE16, open table IUUC_LOGTAB_ID.
  3. Set the IDENT field with the <8 digit number> from your object’s name and execute.
  4. The result will display both the MTID and the associated table name.

Method 2: From the Source System

  1. Log into the source system (the system being replicated).
  2. In SE16, open table IUUC_LOG_APPLTAB.
  3. Set the LOGTAB_NAME field to your object name /1CADMC/<8 digit number> and execute.
  4. The result will return the table name used for that object.

3. Identifying Tables for Objects Like /1LT/<11 digit number>

For this type of object, follow these steps:

  1. Log into the SLT system.
  2. In SE16, open table IUUC_TAB_ID.
  3. Set the IDENT field with the <11 digit number> from your object name and execute.
  4. The output will display the MTID and the corresponding table name.

Summary Table

Object Format Key Table(s) Input Field Output Field / Info
/1LT/SAPL<SID><15 digit number> DMC_FMID, DMC_COBJ IDENT, GUID IDENT (Z_<Table Name>_<MTID>)
/1CADMC/<8 digit number> IUUC_LOGTAB_ID IDENT MTID, Table Name
/1CADMC/<8 digit number> (source) IUUC_LOG_APPLTAB LOGTAB_NAME Table Name
/1LT/<11 digit number> IUUC_TAB_ID IDENT MTID, Table Name

Conclusion

Understanding the mapping between SLT technical objects and their underlying tables can save time and provide valuable insights when managing SAP replication scenarios. By following the steps above, you can quickly trace any SLT object to its original table, helping you maintain, troubleshoot, and optimize your SAP landscape more effectively.

The short URL of the present article is: https://ipraby.com/646m

Leave a Reply

%d