Customer Exit for Number of Days from 1 st Apr to last date of Month Enter

Advertisement
Hello BI Experts,
I have a requirement to count the number of days from 1 st April of current year to the last date of month entered.
For example : The use will enter say July 2010 or 003.2010  (as Fiscal Year Variant is V3 ).
Today is 14 July ...So we have to first find out the end date of the July month ie 31 st July
Then go to 1 st April 2010.
Now calculate the Number of days between 1 st April to 31 st July 2010.
I consider I have to create two Customer Exit variable
as below
1 st customer exit Bex variable  say  ZLY_MTH  ( Last day of Month Entered)
  and i_step = 1
2 nd Customer Exit BEx Formula variable say ZF_NUMDAYS ( Number of days between two dates)
i_step =1 .
Please provide me the logic for the above two.
Thanks in Advance.
Regards,
Amol Kulkarni
Advertisement

Replay

PSUDEO CODE:
1. Initially LOOP AT I_T_VAR_RANGE INTO LOC_VAR_RANGE WHERE VNAM = 'ZMONTH'.
2. Get the Month input using VAR_MONTH2 = LOC_VAR_RANGE-LOW+4(2)
3. Now calculate Month+1: VAR_MONTH2 = VAR_MONTH2 + 1 (Refer **)
4. Now calculate the Current Year: VAR_YEAR = LOC_VAR_RANGE-LOW+0(4).
5. Get the 1st Day of the Month (VAR_MONTH2):  CONCATENATE '01' '/' VAR_MONTH2 '/' VAR_YEAR INTO L_S_RANGE-LOW.
6. SUBRACT 1 (0DATE) from this DATE (This will give the logic for last day of the current month)
Insert this code also for using the date conversions
        CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
          EXPORTING
            INPUT  = VAR_MONTH2
          IMPORTING
            OUTPUT = VAR_MONTH2.
Pls. check out this logic. Guess it would solve your need.
Thanks,
Arun Bala

How to calculate number of days from a date field

Dear BW Experts. I have a field 'Create Date' in the BEx query. Now we need to create a variable which should give the number of days from the date of running the query (sy-datum) to the Create Date. This will help the users to get records which are

How to find the customer exits for a particular transaction

hi how to find the customer exits for a particular transactionHi jyothsna vankadari , ther is a convenient way to find all BADIS called. You may know that BADIS are the newer version of EXITs. I would suggest you to go for BADI. Follow the below step

How to create customer exit for characteristic variables and for text vars.

hi friends,   can anybody tell me how to create customer exit for characteristic variables and for text variables in bw ides system. thanks, sreeHi, Please have a look at: https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f1a7e790-0

User or customer exit for ME21N

Hi all, I have to make a check before saving the Purchase order thru ME21N. Is there any user exit or customer exit available to do this check? Plz clarify. Regards, SteveHi Use the BADI ME_PROCESS_PO_CUST see the sample code and the doc for BADI BAd

How to create a customer-exit to calculate a week from a date

Hi my Guru's, I actually try to implement an Exit variable to calculate a week number from a characteristic date (0FINISHDATE) in my BEX report. Does anyone has an example of customer-exit which calculate a week number after giving a date in the popu

Customer exit for calling a database a table

Hi Friends, I want to write a customer exit code for customer exit variable which should call a database table which i have created. The database table  consist of two fileld username and the material value assign to that user. and when a  perticuler

Customer Exit for MTD

Hi, My requirement is to create Customer exit variable to calculate the Month to date (MTD) value (Quantity) in a query. I created a Customer exit variable for MTD (0CALDAY) in Query & wrote code in CMOD for the same as follows. DATA: ZYEAR(4) TYPE N

Customer Exit for query

How can I find out in which queries that the variables that are defined in the customer exit ZXRSRU01 are used? Thanksyou should be able to go into table rszglobv and type in the variable name and select the id for you variable using se12. Then use t

Customer Exit  for Calendar year/Quarter

Hi Experts, I had a scenario as I had a Time char 0Calquarter.  Based on this I need to derive the current quarter headcount and Pervious year same quarter headcount.  To get the headcount I defined a counter constant '1' for each employee at cube le

Customer Exit for FISCPER

Hello guru's, I am in need of the code, Customer exit Var for FISCPER to show 3 months past and 24 months future only. Thanks in advance. Ven.Hi The below is the code , case i_vnam. if 'zvar1'. if i_step = 2. data wa1 like line of e_t_range. data fda

Re:User exit  for number range assignment assignment to purchase order type

Hi All, Is there any user exit which assign the purchase order type to number range. Please help. Regards, vivekHi Implementing the User exit MM06E003 Number range and document number Goto Transaction CMOD ,  Create a Z - Project proceed as follows:

Substracting number of days from date

Hi all, I need to create a user exit to get a date value based on another variable. Basically, 100 days minus the first variable. var2 = var1 - 100 How can I write this? Thanks.Ok, I figured it out. I had to declare variables of type d and then assig

Customized JTextFiled for number autoformatting

Hi everyone, I've been programming a customized JTextField to accept only numbers with auto-format while you're typing on it, it's almost working except some issues with decimal point. I would like you to help me to test it or give me advices to impr

Customer Exit for Subquery

Hi All, I have a scenario where i need to create a report for the following sql query. SELECT * FROM TABLE A WHERE TABLEA-ITNO NOT IN (SELECT ITNO FROM TABLE B) Please Guide me.Hi Vivek, Thks for ur immediate reponse. This is in BW only i have create

Field Exit for Batch Input creation from LSMW

Hi all, I am having problems getting a field exit to work for validation of user id in the "Create Batch Input Session" step of LSMW. Program: /SAPDMC/SAP_LSMW_BI_RECORDING Screen:  1000 Data Element: SYUNAME Any help would be appreciated. Regar

Query Question - "Number of Days" column possible? (for SAP Business One)

Question: Is it possible to create a column in a Query that shows the number of days (from today) until a specified date (from another field in the system)? If so, how? An example of what the Query code would look like would be incredibly helpful! Ed

Number of days customer is due to be maped in dunning notice PLD

Hi All, In the Dunning Reprt PLD I want to print the number of days the Customer is due to company as the number of days due varries from customer to customer please give a solution. So that i want to map number of days from dunning wizard report in

Doubt on customer exit variable for bex ?

Hi ABAP'ers, I have a doubt if we can use the customer exit variable for user input selection as well as for restricting the query ? For example zvar1 is a user input selection variable which will fetch the fiscal year, processing by customer exit, i

Search for User/Customer-Exit in Printing Quality-Notifications

Hello, because we want to use the standard of SAP, we don't want to use a custom print programm for our quality-notifications. One of the print programms is "RQQMUD01". Are there spezific User/Customer Exits for the print programs of the quality