Shipping point

[Former Member]

Hi :

I have a custom table with fields :

belnr, posnr, btyp, aufnr, ebeln, ebelp, livbeln, liposnr,matnr,wadat,kunnr,werks,bmeinh,getri,inaktiv,wabukz,erdat,aedat,loekz.

Custom Transaction with fields :

vbeln (field name belnr) , aufnr, delivery vbeln ( field name livbeln ),werks, mat .avail.dat ( mbdat ), transport.plan date(tddat),

matnr, and sales order item (posnr).

I have to select sales order , item from custom table based on plant (werks) shipping point , and delivery creation date.

how can i relate shipping point and delivery creation date to my query.

For delivery creation date, it should be selected based on current date+-2 and should choose MBDAT OR TDDAT which ever is earlier based on current date.

I would appreciate if anyone can give me som idea and full points r rewarded.

Thx.

Rag

[Former Member]

Hi :

I have a custom table with fields :

belnr, posnr, btyp, aufnr, ebeln, ebelp, livbeln, liposnr,matnr,wadat,kunnr,werks,bmeinh,getri,inaktiv,wabukz,erdat,aedat,loekz.

Custom Transaction with fields :

vbeln (field name belnr) , aufnr, delivery vbeln ( field name livbeln ),werks, mat .avail.dat ( mbdat ), transport.plan date(tddat),

matnr, and sales order item (posnr).

I have to select sales order , item from custom table based on plant (werks) shipping point , and delivery creation date.

how can i relate shipping point and delivery creation date to my query.

For delivery creation date, it should be selected based on current date+-2 and should choose MBDAT OR TDDAT which ever is earlier based on current date.

I would appreciate if anyone can give me som idea and full points r rewarded.

Thx.

Rag

[Former Member]

v_date = sy-datum + 2.

SELECT vbeln posnr 
              from zxxx
              into table i_zxxx
              where werks IN s_werks
               AND  vstel IN s_vstel
               AND  erdat =  v_date
              AND   ( mbdat >= sy-datum OR 
                          tddat >= sy-datum ).

SORT i_zxxx.

[Former Member]

Hi Judith,

ur solution was helpful.

thx and full points r rewarded.

[Former Member]

Hi

This is just for your idea.

First try to get sales details from vbak and vbap

Here you get sales order number,item

After get delivery details from likp and lips,you pass vbeln here and you get delivery number,item and also shipping details

For material availability check EKET table(use ebeln and ebelp)

Thanks

[Former Member]

Hi RK,

the idea was help ful.

thx.

points r rewarded.