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