topic Shipping point in Application Development and Automation Discussions

Shipping point

Former Member — Wed, 21 Feb 2007 05:34:37 GMT

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

Re: Shipping point

Former Member — Wed, 21 Feb 2007 05:39:50 GMT

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.

Re: Shipping point

Former Member — Wed, 21 Feb 2007 05:41:16 GMT

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

Re: Shipping point

Former Member — Wed, 21 Feb 2007 05:45:02 GMT

Hi Judith,

ur solution was helpful.

thx and full points r rewarded.

Re: Shipping point

Former Member — Wed, 21 Feb 2007 05:46:09 GMT

Hi RK,

the idea was help ful.

thx.

points r rewarded.