Skip to Content

begda and ennda

hi,

If in the code i write a select statment with condition that

begda <= endda and endda >= begda.

which duration list it will give.

Plz make me understand.

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Posted on Jul 24, 2008 at 10:39 AM

    everything ofcourse since it is always true

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 10:40 AM

    U'll get records where the ENDDA >= BEGIN date

    and BEGDA <= ENDdate ..

    I mean the BEGDA and ENDDA will be in BEGIN and END dates ..

    Ex : If U give Begin = 01/01/2008 end date = 12/31/2008

    and If U have records in infotype say as ..

    BEGDA ENDDA

    01/01/2007 12/31/2007

    01/01/2008 12/31/2008

    01/01/2009 12/31/2009

    U'll get the second record ...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 10:40 AM

    check this..

    you will get the records whcih exists between these dates .

    for example...

    select pernr

    begda

    endda

    from pa0002

    into table itab

    where pernr in s_pernr

    and begda le endda

    and endda ge begda .

    then you will get the records whcih exists between these date intervals begda and endda in the infotype 0002 .

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 10:42 AM

    It will give data for the duration from beggining date and endate.

    Ex : if beginda = 1

    endada = 30

    it will fetch data from 1st to 30th..irrespective of the month this will fetch data within that duration

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 10:44 AM

    Hi,

    It will give that records where Enddate is Greater than or equal to begin date.

    In either side it is the same condition, because in first condition it is true, if Begda is less than or equal to Enda.

    In the Second condition is true if Endda greater the or equal to begda. So ultimately the condition is tru if start date is lesss then End date or End date is greater the Start date or same .

    Regards,

    Sujit

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 10:45 AM

    Hi,

    this will give all the dates which is less than or equal to endda.

    as u have written begda<=endda & endda>=begda

    if begin date is less then or equal to end date and then u r checking enddate is greater than or = to begin date means u r checking the same thing but in different manner....

    so it will show u the records in which date is less than or equal to enddate.

    Thanks & Regards

    Ashu Singh

    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.