Skip to Content

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

  • Follow
  • Get RSS Feed

3 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

  • Mar 01, 2018 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

  • Jan 08 at 10:44 AM

    Roger Bueno

    Your response is all very well, but in an operational situation when you have an unexpected invalid character in a text field in the inbound table, how can you correct that problem so that you can activate the data in the ADSO?

    In BW 7 you could edit the request in the PSA to correct the problem and then push it up to the DSO again. In BW4 using ODP datasources there is no PSA, so what is the recommended best practice in this situation?

    Can the ADSO inbound table be edited to remove the bad character, or does the data have to be corrected at source and reloaded?

    Please let me know what SAP recommend.

    Regards,

    Mark

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Mark,

      In an ideal scenario you would, at first, prevent the data to be loaded in the aDSO with a well-developed routine. Yet, you have the option to use the new DTIS functionality, which is similar to the Error Stack from previous BW versions to act like a PSA. If the data is already loaded to the aDSO, however, the most consistent recommendation would be to correct the data at Source and reload as you mentioned.

      Best regards,

      Roger Bueno