Community
Application Development and Automation 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: 
Read only

ALV REPORT

Former Member

‎2007 Mar 14 10:14 AM

0 Likes
353

hi friends,

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.

kindly tell me how to proceed...

hi friends,

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.

kindly tell me how to proceed...

Reply
1 REPLY 1
Read only

Jelena_Perfiljeva
Active Contributor

‎2007 Mar 14 6:58 PM

0 Likes
317

1) The date that is entered on VL01N, for example, is not BUDAT, it's LIKP-LFDAT. There is also a document date (BLDAT) and many other dates that you could use, depending on the requirements.

2) You can find shipment number VTTP-TKNUM by VTTP-VBELN = LIKP-VBELN (Delivery Number). The header table for the shipments is VTTK. We are not using other tables, so I;m not sure what's he further connection. Maybe document flow in VBFA will shed some light.

Hope this helps.