Skip to Content
author's profile photo Former Member
Former Member

Several dates in the same field and table

Hey!

I need dates of different work phases, in order to calculate the duration of each phase separately in SAP-Query. The dates are situated in the same tables and fields (f.ex. actual start dates of work phase 1, phase 2, phase 3, etc. are all located in table AFVV and field ISDD). But I need them separately. So is the only option to create separate fields for the dates of each work phase?

Maria

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Dec 10, 2008 at 08:31 AM

    First select all relevant dates from AFVV into internal table i_afvv

    Then create a new internal table from i_afvv with all related dates in one record. Per record you can do the calculation

    regards,

    Hans

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you Hans,

      I'm a beginner with this, so do you know if there exists some kind of a guide on how to select dates from the table to the internal table and how to create an internal table?

      Greetings,

      Maria

  • author's profile photo Former Member
    Former Member
    Posted on Dec 11, 2008 at 07:08 PM

    Hi

    SDN is itself a one-point source for anything related to SAP. (You can check eLearning etc for the same)

    But still, here is one for you to start learning ABAP [http://abap-gallery.blogspot.com/2007/07/step-by-step-learning-abap.html|http://abap-gallery.blogspot.com/2007/07/step-by-step-learning-abap.html]

    Regards

    Raj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 12:59 PM

    Thank you for your answers. Unfortunately I don't have the authorizations to use ABAP-coding, and I won't be given those, so I'm not able to implement your suggestions :S I probably need to think of something else..

    Best wishes,

    Maria

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.