Get Project Version Description(Created using CN72)

[former_member539238]

Hi Everyone,

I have created a version for project using tcode CN72. Right now I am trying to fetch the description for the version. I have found the description in VKOMPF table. I have the version key and project definition number. But in the table VKOMPF the key values are version key and another numerical char.(VSZHL Field(NUMC08)). I could not find the project id in the table. Is there any other way I can get the description for the project version? If the table is the only way, then what is the relationship between the project and the version description?

[kenmelching · Accepted solution]

You will have to join tables VSKOPF and VSPROJ_CN with the version id. Then use logic to filter out which VSTEXT description applies. There is not a 1:1 relationship because the same Version Key is allowed on different Project Definitions and Project Definitions are allowed multiple versions. Creatre some sample data then see how the tables react.

[former_member539238 · Accepted solution]

By standard we have a logic to automatically generate a uniques version key, What if we use that? The version key will always be unique so the counter values is fixed to 1. Unless someone goes to CN72 and create a new version with hard coded version key it should not cause any problem.

[former_member539238]

So finally I used the standard number generation to generate the version. Then the Counter will have no use. So I skipped the whole Counter value concept. That worked for me.

[kenmelching]

Where are you finding that table?

In standard PS look at SE11 for table VSPROJ_CN and you will see the POST1 for the description.

I do see table VSKOPF, that is a SAP table for internal control and to prevent duplicates.

[former_member539238]

Hi Ken Melching,

From what I understand the POST1 field you are talking about stores the project description. What I want is not project description. I want the version description which is used in CN72 when creating a version.

When I searched for the description it was found in table VSKOPF, field VSTEXT.

Now I have the data and I need a way to uniquely fetch the description for the project version. My guess is that the counter is stored in some table related to versions. I could not find this table hence the question. Thanks for the reply 🙂

[TammyPowlas]

Hello - I recommend searching; I searched and found this thread: https://archive.sap.com/discussions/thread/3229014 - see tables VSPROJ_CN and VSPRPS_CN

[former_member539238]

Thanks for the reply, as I said I have project version key and project ID, but the issue is that in the version text table VKOMPF, key values are different so I need one more numeric value.

-> Searched the version text table VKOMPF using the version key,

-> Found multiple entries for the same version key( uniquely identifiable by a numerical character of 8 length).

I do not have this numeric number. Project ID is not useful here. So I wanted to find where the numeric can be found in relation to project ID. If that can be done the issue will resolved.

Here same version key can be used for different project versions.

Thanks again for the reply 🙂

PS: I have all needed version details, I only need the description used in CN72 to display in a report.