AFVGD structure

[Former Member]

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 t0_{vbeln t0}ernam t0_{erdat t0}vstel t0~lfart

t0_{wadat t0}lfdat t0_{route t0}vbtyp t0~kunnr

t0_{btgew t0}gewei t0_{lfuhr t0}wadat_ist

t1_{tknum t1}tpnum t1~tprfo

t2_{vbeln t2}erdat AS erdat2

t3_{tknum t3}shtyp t3_{exti1 t3}dptbg t3~uptbg

t3_{tdlnr t3}dtabf

t4~wbstk

into corresponding fields of table GT_JOINED_INFO

FROM ( likp AS t0

INNER JOIN vttp AS t1 ON t0_{vbeln = t1}vbeln

INNER JOIN vbfa AS t2 ON t1_{vbeln = t2}vbelv

INNER JOIN vttk AS t3 ON t3_{tknum = t2}vbeln

INNER JOIN vbuk AS t4 ON t0_{vbeln = t4}vbeln ).

• Count of table entries

DESCRIBE TABLE GT_JOINED_INFO LINES LVI_JOINED_INFO_TBLSIZE.

*

IF LVI_JOINED_INFO_TBLSIZE > 1.

• Sort for duplicates.

SORT GT_JOINED_INFO BY vbeln.

• Delete duplicates.

DELETE ADJACENT DUPLICATES FROM GT_JOINED_INFO

COMPARING vbeln.

ENDIF.

• Adjust table count

DESCRIBE TABLE GT_JOINED_INFO LINES LVI_JOINED_INFO_TBLSIZE.

ENDFORM.

Any help would be appreciated.

Thank you,

Dave

[Former Member]

Hi David,

I'm afraid you cannot access AFVGD as if it were a table, 'cause it's not: it's a structure! So if you want (for example) to use field AFVGD-IEDD, you'll need to find out what table stores this data.

I have tried it myself ( I don't know anything about service orders, sorry :,-( ), but I can give you some clues:

- Enter tx SE11 and view structure AFVGD

- Double-click the data element corresponding to field IEDD (that's data element IEDD)

- Look at the cross-references of data element IEDD into tables, and you'll get a few tables

I found it very interesting, table MCAFVGV, this may help you. But sorry again, I'm just wondering as an ABAPer, not as a Service-Order-expert (as I am not...)

Anyway, I hope it could give you some clues about what you have to do. Please let us know if it helped. BR,

Alvaro

[Former Member]

Thank you Alvaro. I will try to track down the actual source of the data in the structure as you suggest.

Dave

[Former Member]

AFRU has the details, but I am not a service expert either, so check how your tables relate to this one. I think your VTTK has a TERNR fieldand you can pass this to AFRU-AUFNR, but again this is just a wild guess.

Srinivas

[Former Member]

Thank you Srinivas. VTTK does have TERNR but in our case the field is empty. I will look into AFRU some more.

Thanks again,

Dave

[franois_henrotte]

try to read directly CAUFV with AUFNR = VBAK-AUFNR

[Former Member]

Thank you François - but another dead end. The AUFNR field in VBAK is also empty. I'll keep looking.

Dave

[Former Member]

Try with VBAK_{VBELN = AUFK}KDAUF.