SAP Table
TCN51 Version profile for PS versions
SAP table TCN51 has 2 primary key fields being MANDT,VER_PROFIL.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
TCN51 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KeyVER_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 |