Fetch release code that last approve a PR Number

[former_member844813]

Hi experts!

im making a zprogram for a PR number resume in ALV, i was stuck on how to fetch the release code that last approve a PR Number.

where as seen here the approval status is at PL.

but it appears like this in my program, i wanted it to only show one PR number with the last release code that approved the PR number.

can anyone help me with this ?

[yogananda]

demaauliansyah

Here is some pseudo to explain what you need to do:

1. Retrieve the PR number from the database.
2. Query the database to get the release codes associated with each PR number.
3. Loop through the release codes to identify the latest one (based on the creation/date/time stamp).
4. Once the latest release code is identified, store it in a variable.
5. Link the PR number to the latest release code and display it in ALV.

[former_member844813]

yoganandamuthaiah

Thank you for the explanation but can u make it beginner-friendly, please ? with a bit of syntax or a code example perhaps