I am hoping that someone can help me with this. I need to identify time spent at different stages in a Service Order. The time spans that I need, and the data fields that I believe will give me the information, is as follows:
1.) Goods Receipt date (VBFA-ERDAT) to Sale of Repair date (LIKP-WADAT_IST)
2.) Goods Receipt date (VBFA-ERDAT) to Shipment date (VTTK-DTABF)
3.) Actual Start date (AFVGD-ISDD) to Sale of Repair date (LIKP-WADAT_IST)
4.) Actual Start date (AFVGD-ISDD) to Shipment date (VTTK-DTABF)
5.) Actual Start date (AFVGD-ISDD) to Actual Finish Date (AFVGD-IEDD)
I believe I understand how to join the tables LIKP, VBFA and VTTK to get most of the data but I do not know how to get the AFVGD data. Can someone tell me how I would do this, or if there is a better place to get this info. The following is how I am joining the tables I understand:
FORM join_data.
SELECT t0vbeln t0ernam t0erdat t0vstel t0~lfart
t0wadat t0lfdat t0route t0vbtyp t0~kunnr
t0btgew t0gewei t0lfuhr t0wadat_ist
t1tknum t1tpnum t1~tprfo
t2vbeln t2erdat AS erdat2
t3tknum t3shtyp t3exti1 t3dptbg t3~uptbg
t3tdlnr t3dtabf
t4~wbstk
into corresponding fields of table GT_JOINED_INFO
FROM ( likp AS t0
INNER JOIN vttp AS t1 ON t0vbeln = t1vbeln
INNER JOIN vbfa AS t2 ON t1vbeln = t2vbelv
INNER JOIN vttk AS t3 ON t3tknum = t2vbeln
INNER JOIN vbuk AS t4 ON t0vbeln = t4vbeln ).
DESCRIBE TABLE GT_JOINED_INFO LINES LVI_JOINED_INFO_TBLSIZE.
*
IF LVI_JOINED_INFO_TBLSIZE > 1.
SORT GT_JOINED_INFO BY vbeln.
DELETE ADJACENT DUPLICATES FROM GT_JOINED_INFO
COMPARING vbeln.
ENDIF.
DESCRIBE TABLE GT_JOINED_INFO LINES LVI_JOINED_INFO_TBLSIZE.
ENDFORM.
Any help would be appreciated.
Thank you,
Dave
Bluesky
