SAP table TCN51 (Version profile for PS versions)
SAP table TCN51 has 2 primary key fields being MANDT,VER_PROFIL.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| VER_PROFIL | Version profile | CHAR | 7 | 0 | VER_PROFIL | ||
| FLG_PD | Indicator: Project definition in a version | CHAR | 1 | 0 | VSFLG_PD | ||
| FLG_PR | Indicator: WBS element in a version | CHAR | 1 | 0 | VSFLG_PR | ||
| FLG_NP | Indicator: Networks in a version | CHAR | 1 | 0 | VSFLG_NP | ||
| FLG_NV | Indicator: Activity from network is in a version | CHAR | 1 | 0 | VSFLG_NV | ||
| FLG_OF | Indicator: PRT in a version | CHAR | 1 | 0 | VSFLG_OF | ||
| FLG_OK | Indicator: Components in a version | CHAR | 1 | 0 | VSFLG_OK | ||
| FLG_NR | Indicator: Relationship in a version | CHAR | 1 | 0 | VSFLG_NR | ||
| FLG_EL | Indicator: Activity elements in a version | CHAR | 1 | 0 | VSFLG_EL | ||
| FLG_TX | Indicator: PS texts in a version | CHAR | 1 | 0 | VSFLG_TX | ||
| FLG_MS | Indicator: Milestone in a version | CHAR | 1 | 0 | VSFLG_MS | ||
| FLG_KB | Indicator: Capacity requirements in a version | CHAR | 1 | 0 | VSFLG_KB | ||
| FLG_CO | Indicator: Costs in a version | CHAR | 1 | 0 | VSFLG_CO | ||
| FLG_SD | Indicator: Sales order in a version | CHAR | 1 | 0 | VSFLG_SD | ||
| FLG_EV | Earned values in a version | CHAR | 1 | 0 | VSFLG_EV | ||
| FLG_2 | Version is MTA-Relevant | CHAR | 1 | 0 | VSFLG_MTA | ||
| FLG_3 | Placeholder for future indicator in structure | CHAR | 1 | 0 | VSFLG_PH | ||
| FLG_4 | Placeholder for future indicator in structure | CHAR | 1 | 0 | VSFLG_PH | ||
| FLG_5 | Placeholder for future indicator in structure | CHAR | 1 | 0 | VSFLG_PH | ||
| FLG_6 | Placeholder for future indicator in structure | CHAR | 1 | 0 | VSFLG_PH | ||
| FLG_LT | Indicator: Long text in a simulation | CHAR | 1 | 0 | VSFLG_LT | ||
| FLG_DK | Indicator: Documents in a simulation | CHAR | 1 | 0 | VSFLG_DK |