Skip to Content
Former Member
Mar 14, 2007 at 01:11 PM

select querry


I have to determine deliveries(LIKP-VBELN) for the posting date(BUDAT) that is being entered in selection screen. but BUDAT is not there in LIKP.

from this list of deliveries, determine the deliveries(LIKP-VBELN) for which a shipment has been created, but with no completed shipment cost document(VFKK-FKNUM). the field status of Account Assignment(VFKK-STFRE) and status of transfer(VFKK-STABR) on the shipment cost document(VFKK-FKNUM) needs to be used to determine the shipments to be reported. If both these fields are NOT in the status "c", then the documents MUST be included.