Skip to Content
avatar image
Former Member

Delete data in a inbound table of a ADSO ?

Hi,

I believe the inbound table is like an initial layer for ADSO and is not needed. Can we delete the data in the inbound table of a ADSO in production. what is the imapct if we delete ? Is there any program or tcode to delete the inbound layer of a ADSO.

Thanks

DR

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 27, 2017 at 05:37 AM

    Hi,

    There are 3 tables for an Advanced DSO Inbound Table, Active Data table and Change log table. When you load data to the ADSO it would first sit in Inbound table then after activation based on your ADSO property it would store in Active Data table and Change log table. During activation process it deletes records from Inbound table and populate it into Active data table and change log table.

    So let me know why do you want to delete inbound table of ADSO ? If you activate the request it will automatically gets deleted.

    Regards

    Githen

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 01 at 11:58 AM

    Sometimes you need to delete corrupt records from an inbound table due to unallowed characters. So the question was not why but how to delete data from an inbound table.

    Regards

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Alexej,

      In these cases the correct approach would be to treat these characters in Transformation routines before they reach the InfoProvider, and not simply delete them from the table. This can cause further inconsistencies and SAP does not recommend this approach.

      BR,

      Roger Bueno