sales orders and delivery creation

[Former Member]

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 a1_{belnr a1}posnr vbep~etenr into corresponding fields of table itab from a1 inner join vbap

on a1_{belnr = vbap}vbeln

inner join vbep on a1_{posnr = vbep}posnr

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

[Former Member]

Hi,

Modify the Selec as below:

select a1_{belnr a1}posnr vbep~etenr into corresponding fields of table itab from a1 inner join vbap

on a1_{belnr = vbap}vbeln

inner join vbep

<b>on vbap_{vbeln = vbep}vbeln and vbap_{posnr = vbep}posnr</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

[Former Member]

Hey Anji,

i solved my problem ....i used ur input too.

points r rewarded .

Thx

Raghu