Skip to Content

Update Procedure of DD02T & DD02L

Hi experts,

I'm using SLT with MSSQL & HANA

I have a problem about update of DD02T & DD02L

As described in Technical Operation Manual of SLT,

(6 Further Tips and Tricks, Frequently Asked Questions, and Troubleshooting Recommendations)

---------------------------------------------------

Tables DD002L and DD002T (for SAP source systems used to replicate the SAP dictionary information)

include the metadata of the tables in the non-SAP system –

however these tables are just initially loaded and not automatically updated (replicated).

---------------------------------------------------

After creating(or deleting) new tables on Source System,

These 2 tables don't be updated on HANA system.

Please tell me how to update these 2 tables.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jun 18, 2012 at 11:04 PM

    Deep:

    Go through the steps mentioined in this video:

    1. www.experiencesaphana.com/videos/1373

    Regards,

    Rama

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 08, 2013 at 01:04 AM

    Dear Yoh,

    As per SAP Note 1768805

    Tables DD002L, DD002T include the metadata of the tables in the non-SAP system - however these tables are just initially loaded and not automatically updated (replicated).

    If, after the initial setup, you have created new tables in the source and you would like to be able to replicate them from the Data Provisioning follow the instructions from the SAP Note 1751323 (Non Sap Replication-Update DD02L and DD02T tables).

    SAP Note 1751323says that:

    Create local report with name Z_CREATE_DD_TABLES in the SLT system. Find attached in the note a txt document Z_CREATE_DD_TABLES.txt and copy the content from the attachement into the source code of the report.

    When you want to update the content of DD02L and DD02T tables, execute the report and give the corresponding mt_id and source schema name as a parameters.

    The source schema name should be the same as the source schema name specified in the LTR transaction.

    After executing the report the content of DD02L and DD02T tables will be updated.

    Regards

    Raj

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.