Customer exit abap code ?

[Former Member]

I need customer exit code on 0calday which will pull last 7 days data from the input date  in bex query ??

[sander_vanwilligen · Accepted solution]

HI,

I suggest to select or define an appropriate input-ready Variable together with an offset of minus 7 days in the BEx Query. I don't think that your requirement needs a Customer-Exit Variable.

Best regards,

Sander

[Former Member]

Hi Sander ,

actually i wanted to use this query in broadcaster hence i was looking for customer exit code.

[Loed]

Hi,

Do you still want the customer exit code for this?

Are you still using CMOD or BADI?

Regards,

Loed

[Former Member]

Hi ,

yes , we are still  using CMOD .

however  i  have written one code but not sure whether its gonna help or  not

Regards,

Aditya

[KodandaPani_KV]

HI,

create the one offset variable choose the -7 days.

when ever user will run it will take last 7 days data.

create the normal variable on the 0calday then create the another variable restrict with -7 using off set function.

Thanks,

Phani.

[Former Member]

Dear,

First create a variable of type customer exit (Not the manual one) in bex query where you need -7 days of data. Assign this variable to 0CALDAY.

This requires bit of ABAP coding in user exit EXIT_SAPLRRS0_001, if this is not implemented then you need to activate the enhancement which is RSR0001.

Logic:

Based on date being input do a -7 days by using. For example.

LV_DATE = INPUT_DATE - 7.

Thanks & Regards,

M

[carlos_weffer]

[Loed]

Hi,

I agree with Sander's suggestion..Please refer in the blog below on how to implement OFFSET:

Offset Variables Example - SAP NetWeaver Business Warehouse - SCN Wiki

Regards,

Loed