| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBSI |
| 1 | BTXPLAN | BSI: Benefit plan types | 1 | PLANTYPE | BSI: Plan type | nvarchar | 4 | 0 | | |
| 2 | BTXPLNX | BSI: Benefit Plan | 3 | PLANTYPE | BSI: Plan type | nvarchar | 4 | 0 | | |
| TOPConstruction Progress Report |
| 3 | /SAPPCE/TPNV00 | Definition of planning type for construction progress report | 1 | PLANTYPE | Planning Type | nvarchar | 1 | 0 | | |
| TOPControl Plan |
| 4 | QPCPC_PLANTYPE | Customizing Table for Control-Plan Type | 2 | PLANTYPE | Control Plan Type | nvarchar | 3 | 0 | | |
| 5 | QPCPC_PLANTYPET | Text Table for Control-Plan Type | 3 | PLANTYPE | Control Plan Type | nvarchar | 3 | 0 | | |
| TOPIntegrated Product and Process Engineering |
| 6 | CACTOD | Settings for Object Dependency in iPPE Process Structure | 2 | PLANTYPE | Type of iPPE Process Structure | nvarchar | 1 | 0 | | |
| 7 | CACTPLN | Definition of Routing Types for Objects in iPPE Process Str. | 3 | PLANTYPE | Type of iPPE Process Structure | nvarchar | 1 | 0 | | |
| 8 | CLIACTCHECK_DEF | Definition of Task-List-Type Components for iPPE Process Str | 1 | PLANTYPE | Type of iPPE Process Structure | nvarchar | 1 | 0 | | |
| 9 | CLIACTCHECK_DEFT | Text Tables for Routing Types | 1 | PLANTYPE | Type of iPPE Process Structure | nvarchar | 1 | 0 | | |
| 10 | CPNACT | Definition of Routing Types for Objects of iPPE Process Str. | 2 | PLANTYPE | Type of iPPE Process Structure | nvarchar | 1 | 0 | | |
| TOPNursing |
| 11 | N1SNPH | Std.Nurs.Plan: Header Data | 6 | PLANTYPE | Standard Plan: Plan Type | nvarchar | 2 | 0 | | |
| TOPRoom Reservations and Seating Arrangements |
| 12 | VIORPO | Continuous Occupancy | 14 | PLANTYPE | Planning Type | nvarchar | 1 | 0 | | |
