SAP table P44V (Planning Versions)
SAP table P44V has 4 primary key fields being MANDT,GSTRU,SSOUR,VRSIO.
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 | |
| GSTRU | Generated DDIC table for LIS, conditions, messages | CHAR | 30 | 0 | * | GSTRU | |
| SSOUR | Statistic(s) origin | CHAR | 4 | 0 | SSOUR | ||
| VRSIO | 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 |
P44V foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 P44V | MANDT | T000 | Clients | MANDT |
| 1 P44V | MCINF | TMC4 | Global Control Elements: LIS Info Structure | MANDT |
| 0 P44V | PLSCN | PLSC | Planning scenarios in long-term planning | MANDT |