retrieve latest entry from table OKC_K_HEADERS_TL
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,
0