SAP BW4HANA query variables, customer or sap hana exit?

[burns_sh]

Hi,

I have looked on the community and am struggling to get guidance on what is the best approach for a customer exit for use in a query.

We are on BW4HANA, and have a query sitting on a composite provider which in turn is sitting on some ADSO's.

I want to create 2 exit variables for 0CALDAY that will provide;

1. MTD from date, providing first day of current month and previous year
2. MTD to date, providing current day, current month and previous year

What is the best practice approach to achieve this;

• using customer exit with abap coding etc (old way of doing things)?
• or using sap hana exit with amdp (new BW4HANA way of doing things)?

What is the reason for using one approach over the other?

Any guidance or info will be very much appreciated.

Thanks,

Shane.

[burns_sh]

Hi Bhavin,

many thanks for your replay and links to blogs etc.

It seems we have to use the BADI approach, however my question is whether the exits should be developed in ABAP (Customer Exit) or AMDP (SAP HANA Exit)?

I am confused over whether SAP Hana exits are to be used with Hana views only?

We have a Query on a composite provider on top of an ADSO, should this use Customer or SAP Hana exit approach?

Thanks,

Shane.

[bhavinvyas]

I believe old approach is not possible now using customer exit.See this blogs,

https://wiki.scn.sap.com/wiki/display/BI/RSROA_VARIABLES_EXIT_BADI%3A+Example

https://blogs.saphana.com/2016/09/18/the-road-to-sap-bw4hana-part-2/ (See question answer section)

For HANA Exit,

https://blogs.sap.com/2017/08/29/amdp-based-bex-customer-hana-exit/

Thanks,

Bhavin