Extract data from DIRECT UPDATE ADSO using REQUEST TSN

[Loed]

Hi,

Is there a way to extract data from a DIRECT UPDATE using the REQUEST TSN?

For example here I only wanted to extract the 2nd request which is the 2024-02-19 18:33:58.

Is it possible? How to set that filter?

Thanks.

Loed

[roland_szajko]

Hi Loed

The Direct Update ADSO has no AQ. The data is written directly to the AT table. See:

https://help.sap.com/docs/SAP_BW4HANA/107a6e8a38b74ede94c833ca3b7b6f51/2866849cf2bb4f1aa8367f819a991...

As such it is impossible to extract data from such an ADSO based on REQUEST TSN. If this is needed, either use an Inbound Only or Datamart (but do not activate requests) type ADSO.

br

Roland

[Loed]

Thanks Roland.

But would you know any workaround (aside from creating a new ADSO) wherein I can load whatever new is being loaded in this kind of ADSO? This DIRECT UPDATE ADSO is being used by the TPM team (similar to INTEGRATED PLANNING before) which loads any changes made by the user.

Loed