No of days caluculation in report

10-11  Source: Network gathering  Views:0 

Advertisement
hai all
i am working on Customer aging report
in this report i need to calculate no of days,
no of days i should get in days in numeric value
report running date ( subtract ) due date
for example
current report running date : 28.07.2006
due date                    : 15.05.2006
no of days should get  -- 75 days
like this result should come
please help me ,,, this report in final review
i need to solve this priority urgent
by
kumar.K
Hai Kumar
Check the following Code
data: DATE1 type sy-datum value '20060515',
      DATE2 type sy-datum value '20060728'.
DATA: D TYPE I, M TYPE I, Y TYPE I.
DATE2 = DATE2 + 1.
  CALL FUNCTION 'FIMA_DAYS_AND_MONTHS_AND_YEARS'
    EXPORTING
      I_DATE_FROM          = DATE1
    I_KEY_DAY_FROM       =
      I_DATE_TO            = DATE2
    I_KEY_DAY_TO         =
    I_FLG_SEPARATE       = ' '
   IMPORTING
     E_DAYS               = D
     E_MONTHS             = M
     E_YEARS              = Y
write :/ D,
       / M,
       / Y.
Regards
Sreeni
Message was edited by: Sreenivasulu Ponnadi
Related articles
  • No of days caluculation in report 10-11

    hai all i am working on Customer aging report in this report i need to calculate no of days, no of days i should get in days in numeric value report running date ( subtract ) due date for example current report running date : 28.07.2006 due date     

  • My Safari is quitting unexpectedly for the last 2 days. The report I get is Process:         Safari [386] Path:            /Applications/Safari.app/Contents/MacOS/Safari Identifier:      com.apple.Safari Ve 10-11

    My Safari has been quitting for the last 2 days. The report I get is as follows. I would be grateful for any help. Process:         Safari [386] Path:            /Applications/Safari.app/Contents/MacOS/Safari Identifier:      com.apple.Safari Version

  • How to view day wise depreciation report . 11-30

    Dear experts, How to view day wise depreciation report . Regards, hari.guntupalliHi IMP - Go to T code AFAMA - select Day to the day check box And period control according to the fical years Then Go to AW01N Thanks P J Anil kumarRead other 4 answers

  • Doubt in AP days overdue analysis report 11-30

    Hi Is it possible for any of you to explain me that If a particular Doc no say X for vendor y has a clearing date say 3rd Nov and but there is a payment run ID per on 31st Oct (posting date); Has this any effect on the AP days overdue analysis report

  • Display Excahnge rate for that particular day in the reports 11-30

    Hello friends, I have a requirement from the business users to display the exchange rate being used to convert USD to JPY for that particular day in the reports. Is this possible. Please give me the steps to make this solution. Appreciate a lot --Tha

  • How to get "Number of days" in a report on 0PM_DS02 10-11

    Dear BI Gurus, I need to build  a query on the PM DSO - 0PM_DS02 (MTTR/MTBR). The query has 0Equipment in the rows The fields Available Time | Breakdown TIme | Utilised Time in the columns for the time granularity selected. The field Breakdown Time i

  • How to relate current day to date hierarchy [year - month - day] for SSRS report paramenter 10-11

    Hi there:    I've created a SSRS report based on OLAP cube. In this report, there is a date parameter which is used to filter out data.  Now , I want this report to be run and always retrieve data from previous day. I need to supply the date paramete

  • Day wise balance report 10-11

    Hi, I WANT A REPORT FOR ALL VENDOR S DAY WISE BALANCE. CAN ANYONE GUIDE ME ON THIS. SudhanshuHope this will help you.. ACCOUNTS PAYABLE (Note : Similar Reports available for A/R are available for A/P also) 1. Vendor Balances                          

  • Displaying No. of Days in the report??? 10-11

    Hi All, I have to display the number of the day the report is executed on. I thought that I can do it using the Text Variable and Offsets in it to display the day from the input date. But the problem is, the customer wants to display the number of wo

  • Date Parameters displaying a day prior on Report Layout 11-30

    Hi, I am currently creating some reports using Oracle BI Publisher 11.1.1.6.2. The reports in question have a Start Date from Parameter and an End Date To Parameter. I also display the values for the parameters in the Report Layout which appears to d

  • DAY WISE INVENTORY REPORT 11-30

    Hi In which txn we can see the inventory report day wise. ( we know we can monthy wise inventory report in MC.5 )Hi Raj, i don't think we have Std report for day wise inventory (not sure) u have to go for Z-development anyway's just wait for experts

  • Days Sales Outstanding Report 11-30

    Hi Is there any standard report where Days Sales Outstanding can be viewed. What does it mean in business/layman terms. Many Thanks. Sarah.FD32 t-code for a customer shall show the customer credit management view. while you are in the screen, you can

  • 90 day inactive user report 11-30

    Hi Folks, 1. want to generate the list of AD user accounts are inactive for the past 90 days and export the report to a .csv file. PS: I have more than 100 OUs in the DC and i want the export .csv file should be contain like below format. OU Name|fir

  • Day by Months report 11-30

    Hello Gurus. I want to develop a query in Bex Query Designer and I`m not having success. What I want to do is develop a query where in the lines I have the 0PLANT and 0CALDAY objects, and in the columns I want 0CALMONTH and one key figure for Quantit

  • Day  book  standard  report 11-30

    Dear  All can any  one  give  the  list  for  standard  reports  available  for  day book regards sreeHi Balaji, Transaction Journal Report can be your choice to select any days in particular.  It includes all JE for the day no matter auto or manual.

  • 180 days - customer aging report 11-30

    Hi Experts, I'm required to revise the Customer Receivable Aging Report from  Business Partners > Business Partner Reports > Aging > Customer Receivable Aging.  the Standard report shows only up to 120+ days.  We require  180+ days.  Could you he

  • How to convert Date format into day in ssrs reports? 10-11

    Hi How to convert date format into day? 10/01/2010 as like Monday like that?=weekdayname(datepart("w",Fields!mydate.Value)) -Vaibhav ChaudhariRead other 2 answers

  • Calender Day wise trend report 11-30

    Hi All, I need to design an Inbound and Outbound report for all my Products. I have the dso data in the below format Ser Ord No     Ser Ord Date     Model     Outbound Doc No     Outbound Date 1001     01.01.2010     Mod1     2001     01.01.2010 1002

  • Due this period calculation at report 11-30

    hi for FI aged debit report i want use this column due this period. suppose due date is 10/01/2009  if i enter date 12/01/2009 need to show due date is 2 days ? like how can get this at reportHI Suneel.. Check this...it can give u some idea... no of

  • Report to show Service Requests that are open on a day selected by the user 10-11

    Dunno if I'm being thick, but I can't see how to do this in a report/dashboard... The user selects a day and the report pulls back all the Service Requests that were open on that day using the following logic... Service Request Opened Date <= Selecte