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

shipping point and delivery creation date

Hi :

im selecting sales orders , items and schedule line

from a custom table based on plant, shipping point and delivery creation date.

Is there any relation between Schedule lines and delivery creation date.

For delivery creation date d_date = SY-DATUM, and should select Mat Avail dt MBDAT or Trans. planning dt TDDAT which ever comes earlier.

vbep-edatu = itab-d_date.

select a1belnr a1posnr vbep~etenr into corresponding fields of table itab from a1 inner join vbap

on a1belnr = vbapvbeln

inner join vbep on a1posnr = vbepposnr

where a1~werks = p_werks

AND vbap~vstel = p_vstel

AND vbep~edatu = p_edatu

AND (vbep~mbdat <= p_edatu OR

vbep~tddat <= p_edatu ).

can anyone help me with this select statement.

Thanks.

Raghu

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 27, 2007 at 05:32 AM

    Hi,

    Try this:

    select a1belnr a1posnr vbep~etenr into corresponding fields of table itab from a1 inner join vbap

    on a1belnr = vbapvbeln

    inner join vbep

    <b>on vbapvbeln = vbepvbeln and vbapposnr = vbepposnr</b>

    where a1~werks = p_werks

    AND vbap~vstel = p_vstel

    AND vbep~edatu = p_edatu

    AND (vbep~mbdat <= p_edatu OR

    vbep~tddat <= p_edatu ).

    regards,

    Anji

    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.