SAP Table
P44V Planning Versions
SAP table P44V has 4 primary key fields being MANDT,GSTRU,SSOUR,VRSIO.
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
P44V columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KeyGSTRU | Generated DDIC table for LIS, conditions, messages | CHAR | 30 | 0 | * | GSTRU | |
| KeySSOUR | Statistic(s) origin | CHAR | 4 | 0 | SSOUR | ||
| KeyVRSIO | Version number in the information structure | CHAR | 3 | 0 | VRSIO | ||
| VETXT | Version description | CHAR | 40 | 0 | VETXT | ||
| CDAT | Created on | DATS | 8 | 0 | CDAT | ||
| AUTOR | Author | CHAR | 12 | 0 | AUTOR | ||
| UDAT | Changed On | DATS | 8 | 0 | UDAT | ||
| UPNAM | Last Changed By | CHAR | 12 | 0 | UPNAM | ||
| MCINF | Name of information structure | CHAR | 8 | 0 | TMC4 | MCINF | |
| CTIME | Time of creation | TIMS | 6 | 0 | CTME | ||
| UTIME | Time of last change | TIMS | 6 | 0 | UTME | ||
| AVRSI | Active version | CHAR | 1 | 0 | AVRSI | ||
| VWDAT | Pointer to administrative data | NUMC | 10 | 0 | VWDAT | ||
| STATU | LIS version status | CHAR | 1 | 0 | VSSTA | ||
| VEART | Version type: current/historical/test | CHAR | 1 | 0 | VEART | ||
| CNTER | Counter which specifies the age of the version | NUMC | 8 | 0 | CNTER | ||
| PLSCN | Planning Scenario in Long-Term Planning | NUMC | 3 | 0 | PLSC | PLSCN |