SAP table T352R (Maintenance revisions)
SAP table T352R has 3 primary key fields being MANDT,IWERK,REVNR.
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 | |
| IWERK | Maintenance Planning Plant | CHAR | 4 | 0 | T399I | IWERK | |
| REVNR | Revision for Plant Maintenance and Customer Service | CHAR | 8 | 0 | REVNI | ||
| REVBD | Date of revision start | DATS | 8 | 0 | REVBD | ||
| REVBZ | Time of revision start | TIMS | 6 | 0 | REVBZ | ||
| REVED | Date of revision end | DATS | 8 | 0 | REVED | ||
| REVEZ | Time of revision end | TIMS | 6 | 0 | REVEZ | ||
| REVTX | Revision description | CHAR | 40 | 0 | REVTX | ||
| REVAB | Indicator: Revision completed | CHAR | 1 | 0 | REVAB | ||
| PM_OBJTY | Object Type of CIM Resources for Work Center | CHAR | 2 | 0 | PM_OBJTY | ||
| GEWRK | Main work center for maintenance tasks | CHAR | 8 | 0 | GEWRK | ||
| EQUNR | Equipment Number | CHAR | 18 | 0 | EQUNR | ||
| TPLNR | Functional Location | CHAR | 30 | 0 | TPLNR | ||
| PSPEL | Work breakdown structure element (WBS element) | NUMC | 8 | 0 | PS_PSP_ELE | ||
| AUFNR | Network number | CHAR | 12 | 0 | NW_AUFNR | ||
| AENAM | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||
| AEDAT | Last Changed On | DATS | 8 | 0 | AEDAT | ||
| ERNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||
| ERDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||
| OBJNR | Object number | CHAR | 22 | 0 | J_OBJNR | ||
| REVTY | Revision Type | CHAR | 2 | 0 | DIWPS_REVTY_CORE | ||
| OBJID | Object ID of the Work Center | NUMC | 8 | 0 | CRID | LGWID | |
| VAPLZ | Main work center for maintenance tasks | CHAR | 8 | 0 | GEWRK | ||
| VAWRK | Plant associated with main work center | CHAR | 4 | 0 | * | WERGW | |
| EXTAPPL | External Application | CHAR | 2 | 0 | DIWPS_EXT_APPL | ||
| EXTREF | External Reference to Revision | CHAR | 20 | 0 | DIWPS_REV_EXT_REF |
T352R foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T352R | IWERK | T399I | Planning plant parameters | MANDT |
| 1 T352R | MANDT | T000 | Clients | MANDT |
| 0 T352R | OBJID | CRID | CIM Resource - Entities | MANDT |
| 0 T352R | OBJID | CRID | CIM Resource - Entities | OBJID |