Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

retrieve latest entry from table OKC_K_HEADERS_TL

edited Dec 6, 2023 11:21PM in Reporting and Analytics for ERP 3 comments

Summary:

I am trying to get only the entry that has the most recent creation date from this table.

Content (please ensure you mask any confidential information):

Creation date is present in the table. How do I structure the SQL in a way that will return only the most recent creation date? I only want the most recent contract version description.

Version (include the version you are using, if applicable):

23C

Code Snippet (add any code snippets that support your topic, if applicable):

select 

      bu.name bu_name,

      header.CONTRACT_NUMBER,

      header.COGNOMEN,

      types.name contract_type, 

      hz.party_name,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!