Skip to Content
0

Delete data in a inbound table of a ADSO ?

Apr 26, 2017 at 06:29 AM

764

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Apr 27, 2017 at 05:37 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 01 at 11:58 AM
0

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

Show 1 Share
10 |10000 characters needed characters left 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

0