Fetch Data from a view to ADSO in BW4HANA directly

[Pawan_Mahto]

Hi,

We are have a requirement for which we have to load data from a view created in PRD into an ADSO in BW. The view will be created on ACDOCA table. So we want to fetch data from ZZACDOCA_VIEW in PRD directly to ADSO ZCO_TB in BW4HANA (BHP) is it possible ? If so what will be the steps to achieve that ?

[carlospinto]

Hi Pawan,

It depends on your scenario. Apart from Wira's suggestions you can also use an Open ODS view or a DataSource between the S/4HANA table/view and the aDSO.

Regards,

Carlos

[former_member589205]

Hi Pawan Kumar Mahto,

There are two ways you can achieve this.

1. You can put the HANA view into a composite provider. Then create a data flow to transfer data from the composite provider into the ADSO. Trigger the data movement using DTP.

2. Create a "custom planning function type" as AMDP. In the SQLScript, simply select the data from the HANA view into the e_view. Create a planning function and planning sequence to trigger the data movement.

Regards,
Wira