purchase orders created only on saturday and sundays!! using alv tree(oops)

[Former Member]

URGENT!!!!!!!!!!!!!!

create a simple alv tree to display list of purchase orders created only on saturdays and sundays.during the perticular period..please send the appropriate code..

Thsanks@regards,

venks,,,

[Former Member]

When the date range is given first create a range table to store the dates of staurday & sunday.

u can get day of a date by using DATE_COMPUTE_DAY FM.

first compute the day of the low value. if u get it monday add 4 to this date(it's saturday). insert this to the range.

make a loop to put all the saturdays & sundays to the range table.

then use this range in the select statement.

Reward if useful

Regards

ANUPAM

[Former Member]

thanks anupam.

can u send me the samlpe code using alv tree or which tables are effected.

venk

[Former Member]

Try it in SE38. search for BCALV*.

Reward if useful

Thanks

ANUPAM

[Former Member]

hi anupam

plz send me the table names

thanks@regards

venku

[Former Member]

Hi Venkat,

Purchase order header table contains the creation date, EKKO-ERDAT,

other necessary fields are EBELN, EKGRP, LIFNR, AEDAT.

EKPO contains the details of the PO line items. necessary fields are

EBELN, EBELP, AEDAT, TXZ01, MATNR, WERKS, LGORT ,MENGE, MEINS, NETPR, PEINH, NETWR, NTGEW.

Reward if useful

Regards

ANUPAM