Skip to Content
author's profile photo Former Member
Former Member

Is there a field to show date/time that doc was closed

Hi All

I need to do a query for an alert for a customer.

He wants an alert to run..and show all the Purchases orders closed within that hour.

The alert will run every hour..so if a PO was closed 2 hours before that..it should not be part of the results.

I found the Updatedate field and UpdateTS field..but that field does not change if the PO was copied to a GRV..

is there another field to show the time the doc was closed..the clsdate field shows as null.

On SAP 9.0 PL07

thank you

Jerusha

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Jun 10, 2014 at 01:38 AM

    Hi,

    Try this query and let me know your feedback.

    SELECT T0.[DocNum], T0.[DocStatus],T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Quantity], t3.doctime as 'Closing Time', t3.docdate as 'Closed Date' FROM OPOR T0 INNER JOIN POR1 T1 ON T0.DocEntry = T1.DocEntry left join PDN1 T2 on T2.[BaseEntry] = t0.docentry and T2.[BaseLine] = T1.[LineNum] INNER JOIN OPDN T3 ON T2.DocEntry = T3.DocEntry WHERE T3.[DocDate] = CONVERT(VARCHAR(10),GETDATE(),110) and (CONVERT(varchar, datepart(hour, getdate())) + '' + CONVERT(varchar, datepart(minute, getdate())) - t3.doctime) <= 60 and T0.[CANCELED] = 'N'

    Thanks & Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2014 at 09:33 AM

    Hi Jerusha,

    Closing Date of Document is not available in System yet but you can achieve this by Alert by firing ALERT by Every Minute Interval.

    Please check below link.

    Hope this help 😊

    --

    --

    Regards::::

    Atul Chakraborty

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 06, 2014 at 09:34 AM

    Hi,

    Refer Table EKBE.

    Regards,

    Venkat.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.