Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

select querry

Former Member

‎2007 Mar 14 1:11 PM

0 Kudos
91

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.

1 REPLY 1

Former Member

‎2007 Mar 14 2:05 PM

0 Kudos
43

Hi,

Have a look at this

Select FKNUM from VFKK into ITAB1 where BUDAT in S_BUDAT and STFRE<>'c' and STABR<>'C'.

select VBELN FKNUM from VFKN into ITAB2 for all entries in ITAB1 where

FKNUM = ITAB1-FKNUM.

select * from LIKP into OUTTAB for all entries in ITAB2 where VBELN = ITAB2-VBELN.

I think this will fetch u required data.

Reward points if found helpful.

Regards,

Ravi Kumar