Skip to Content
avatar image
Former Member

Table in which TECO Date is Store

Dear All,

Can any one help me in finding out the Table in which TECO Date of Order is Store.

or any report in which TECO date is present.

I already check COOIS and CO03, there is no TECO date avilable there.

Regards

Shayam

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    Jul 20, 2010 at 01:10 PM

    Dear ,

    COOIS/COHV this kind of report will not display TECO date .Basically , you should have ABAP query with following sequence to get the date :

    1.Enter Production Order Number : AUFK

    2.Pass the value of Object Id from AUFK to JEST then to Tabel : JCDS

    Seat with your abaper with those tables and explain him so that he can help you out

    Regards

    JH

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 20, 2010 at 08:07 AM

    Hi,

    Tables: AUFK, JEST & JCDS

    Pass Order nos. to AUFK, read AUFK-OBJNR.

    Pass the value to JEST to know which status are active or inactive & then check in JCDS when it was set.

    Regards,

    Vivek

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 20, 2010 at 08:08 AM

    HI

    check Table JEST Object status

    Hope it will help u

    Regards

    Anupam Sharma

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 20, 2010 at 08:12 AM

    Hi,

    Apart from above go through AFKO table also.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 20, 2010 at 09:21 AM

    You can develop the ABAP query for JCDS table. The object key is OR+leading zero of order number. The system status for TECO is I0045.

    Or with standard production order display, click status. Use menu Extras -> Change status. Select TECO and click Choose.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 20, 2010 at 12:03 PM

    Hello Shyam,

    You can get the date from JEST table by inputting Object number for active status .

    Regards,

    jayavimal

    Add comment
    10|10000 characters needed characters exceeded