Customer Exit for Number of Days from 1 st Apr to last date of Month Enter
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
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'
INPUT = VAR_MONTH2
OUTPUT = VAR_MONTH2.
Pls. check out this logic. Guess it would solve your need.
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
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
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
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
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
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
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
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
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
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
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:
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
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
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
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
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
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
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
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