Create a CDS view with relevant category either cube or Fact or dimension with data extraction annotation declared

Create a source system under ODP-ABAP CDS view in the target BW system

Create a Data source on CDS view created in S4

Select Proposal from ODP

Select the ODP in S4 system, the name is same as SQL view from SE11

Create the data source and activate

Create a A-DSO and load the data just like any other BW flow.

For real-time streaming, you can use Open ODS concepts or streaming process chain to A dSO