How to Get the PO Creation Date and Time in SAPIf you've ever tried to trace back the exact creation time of a Purchase Order (PO) in SAP, you've likely realized—it's not as straightforward as it should be. Sure, SAP gives us the date. But the time? That’s where things get tricky. Let’s walk through all the reliable ways (and a few workarounds) to get this done—with a bit of friendly commentary along the way.Why SAP Doesn’t Store PO Creation Time (At Least Not Directly)First, here's the kicker: SAP doesn’t store the PO creation *time* by default. It only stores the date in standard tables. This is often surprising—especially since you'd expect a transactional system as robust as SAP to log every second. But hey, it's been around since the ‘90s.So, if you’re looking for a field like “PO_CREATE_TIME,” spoiler alert: it doesn’t exist.Primary Table and Field for PO Creation Date: EKKO-AEDAT vs EKKO-ERDATHere’s where you’ll find the creation date of a PO:
Want the PO Time? Use ME23N and the Output Message TrickNow, you’re probably wondering—“Okay, I’ve got the date, but where do I get the actual time?”Since SAP doesn’t log creation time in the main tables, here’s the workaround:
Use CDHDR/CDPOS Tables with CautionYou may have heard: “Just use CDHDR and CDPOS to get the creation log.”Not so fast.These tables are part of SAP’s change document mechanism, which logs changes—not creations. That means:
Alternative: Use EKAB for PO Release DatesAnother table worth checking is EKAB:
Seeing the Creation Date in ME23N (Document Date)Here’s a simple way to confirm the creation date without table digging:
Restricting PO Creation Date Changes in SAPIf you’re an admin or consultant trying to lock the document date so users can’t backdate it during PO creation, here’s your move:Option 1: Use Screen Layout CustomizationSPRO path: SPRO → IMG → Materials Management → Purchasing → Purchase Order → Screen Layout → Define Screen Layout at Document Level
Option 2: Restrict Past Dates Using Error MessageAnother trick is to configure system messages to prevent past dates.
Advanced Logging via User Exits or BADIIn highly audited environments, some companies customize SAP to log PO creation time using:
Best Practice: Timestamp via Output Trigger or Workflow LogsThe most widely accepted approach to approximate PO creation time is using:
FAQ SectionQ1: Can I see the PO creation time in standard SAP reports?No, standard reports like ME2N, ME2L, etc., only show the creation date. For time, you’ll need to use one of the workarounds discussed.Q2: Does SAP store the PO creator’s username?Yes. You can find the creator’s user ID in the EKKO table field “ERNAM”.Q3: Can I write a custom report to show PO creation date and time?Yes, you can use ABAP to combine data from EKKO, CDHDR, and NAST (messages) to build a comprehensive PO log with estimated creation time.Q4: Are there risks in locking the Document Date field?Yes. If you set it to display-only, it may affect other date fields like Delivery Date. Always test in QA before moving to production.Q5: How can I audit old POs if time wasn't logged?If time wasn’t captured via output message or workflow, you’ll have to estimate using approval logs, release dates, or user activity via STAD.ConclusionFinding the exact creation time of a PO in SAP is a bit like detective work. The creation date is easy—check EKKO-ERDAT. But the time? You'll need to rely on output messages, workflow logs, or custom enhancements. If you're implementing a new SAP system, consider logging PO creation timestamps via user-exits for future clarity. For everyone else, the message tab in ME23N is your best bet.Related:
SAP MM Forums - Do you have a SAP MM Question? SAP Material Management Books
SAP Materials Management Tips
Best regards,
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
|