| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /CPD/FC_KF_CEAT | Key Figure with Cost Element and Activity Type | 4 | ACTIVITY_TYPE | Activity Type | nvarchar | 6 | 0 | | |
| 2 | /CPD/FC_RES_CST | Resource and Cost Element | 5 | ACTIVITY_TYPE | Activity Type | nvarchar | 6 | 0 | | |
| 3 | /CPD/FC_RTY_CST | Resource Type and Cost Element | 6 | ACTIVITY_TYPE | Activity Type | nvarchar | 6 | 0 | | |
| 4 | /IAM/C_ACTIVTYP | Activity Template | 3 | ACTIVITY_TYPE | Activity Template | nvarchar | 10 | 0 | | |
| 5 | /IAM/C_ACTIVTYPT | Activity Template Description | 4 | ACTIVITY_TYPE | Activity Template | nvarchar | 10 | 0 | | |
| 6 | /IAM/C_ACT_ACT | Activity Templates for Activity Templates | 3 | ACTIVITY_TYPE | Activity Template | nvarchar | 10 | 0 | | |
| 7 | /IAM/C_ACT_CDGR | Code Group Table for Activity Templates | 3 | ACTIVITY_TYPE | Activity Template | nvarchar | 10 | 0 | | |
| 8 | /IAM/C_ACT_DS | Digital signature | 3 | ACTIVITY_TYPE | Activity Template | nvarchar | 10 | 0 | | |
| 9 | /IAM/D_ACTPTY_MD | Default Party Table for Activities | 3 | ACTIVITY_TYPE | Activity Template | nvarchar | 10 | 0 | | |
| 10 | /MRSS/C_BUND_GRP | Bundle Groups | 5 | ACTIVITY_TYPE | Maintenance activity type (header) | nvarchar | 3 | 0 | | |
| 11 | /MRSS/D_BUND_ORI | Bundled Demand Original data | 33 | ACTIVITY_TYPE | Maintenance activity type (operations) | nvarchar | 6 | 0 | | |
| 12 | /OPT/APPR_COA | Approval COA | 20 | ACTIVITY_TYPE | Activity Type | nvarchar | 6 | 0 | | |
| 13 | /OPT/AT_APPR_HIS | Approval History for Level Based Approvals | 35 | ACTIVITY_TYPE | Activity Type | nvarchar | 6 | 0 | | |
| 14 | /OPT/AT_LBA_LOG | Approval History for Level Based Approvals | 36 | ACTIVITY_TYPE | Activity Type | nvarchar | 6 | 0 | | |
| 15 | /OPT/LIAP_MATX | Line Item Approval Matrix Table | 32 | ACTIVITY_TYPE | Activity Type | nvarchar | 6 | 0 | | |
| 16 | CNVCDOP_IMG | CDOP - Definition of the IMG for CDOP Projects | 4 | ACTIVITY_TYPE | CDOP - Activity Type (Executable / Non-Executable) | nvarchar | 1 | 0 | | |
| 17 | CNVMBTACTIVITY | Unique ID for all activities,information about execution | 3 | ACTIVITY_TYPE | Describes whether an activity is executable or not | nvarchar | 1 | 0 | | |
| 18 | CNV_10993_ACTI | Activity Tables | 5 | ACTIVITY_TYPE | Activity Type (Executable / Non-Executable) | nvarchar | 1 | 0 | | |
| 19 | FIKZD_REGINV_IN | Incoming Invoice Registration Journal | 42 | ACTIVITY_TYPE | Activity Type | nvarchar | 1 | 0 | | |
| 20 | FIKZD_REGINV_OUT | Outgoing Invoice Registration Journal | 41 | ACTIVITY_TYPE | Activity Type | nvarchar | 1 | 0 | | |
| 21 | GRRMOBLEASGNVAL | Loss Event Assignment to HR Objects - Validity | 7 | ACTIVITY_TYPE | Activity Type Id | nvarchar | 2 | 0 | | |
| 22 | GRRMOBRCSAPLAN | RCSA Plan header | 5 | ACTIVITY_TYPE | Activity Type Id | nvarchar | 2 | 0 | | |
| 23 | REMOB_T_ACTIVITY | Activity History master data | 7 | ACTIVITY_TYPE | Activity Type | nvarchar | 4 | 0 | | |
| 24 | REMOB_T_ACT_TYPE | Create Activity Types | 2 | ACTIVITY_TYPE | Activity Type | nvarchar | 4 | 0 | | |
| 25 | ZCSM_SRVC_CATLOG | catalog for facility services | 9 | ACTIVITY_TYPE | Activity Type | nvarchar | 6 | 0 | | |
| TOPBalanced Scorecard |
| 26 | UMB_WIZARD100 | Scorecard Wizard: Activity | 3 | ACTIVITY_TYPE | Scorecard Design: Activity Group | nvarchar | 1 | 0 | | |
| TOPCapacity and Resource Planning |
| 27 | /MRSS/C_RCT_NPRV | Determination of MRS relevance | 6 | ACTIVITY_TYPE | Process variant | nvarchar | 1 | 0 | | |
| 28 | /MRSS/C_RM_PA | Project Activity types | 2 | ACTIVITY_TYPE | Role Activity ID | nvarchar | 2 | 0 | | |
| 29 | /MRSS/C_RM_PA_T | Texts for Project Activity types | 2 | ACTIVITY_TYPE | Role Activity ID | nvarchar | 2 | 0 | | |
| TOPCustom Development Management Cockpit |
| 30 | CNVCDMC_IMG | CDMC - Definition of the IMG for CDMC Projects | 4 | ACTIVITY_TYPE | CDMC - Activity Type (Executable / Non-Executable) | nvarchar | 1 | 0 | | |
| TOPE-Recruiting |
| 31 | T77RCF_ACT2FORM | Assignment of Forms to Activity Types | 2 | ACTIVITY_TYPE | Activity Type | nvarchar | 4 | 0 | | |
| TOPFinancial Accounting |
| 32 | /OPT/BL_APPCOA | Approval COA | 13 | ACTIVITY_TYPE | Activity Type | nvarchar | 6 | 0 | | |
| TOPFunctions for U.S. Federal Government |
| 33 | FMUSFG_GWA_ELIGI | Target System Eligibility | 3 | ACTIVITY_TYPE | Agency Location Code Business Activity Type | nvarchar | 1 | 0 | | |
| 34 | FMUSFG_GWA_RCVAL | Reporter Category Validity | 3 | ACTIVITY_TYPE | Agency Location Code Business Activity Type | nvarchar | 1 | 0 | | |
| TOPLean Staffing |
| 35 | SAWE_D_SA_ITM | Staff Assignment object item | 28 | ACTIVITY_TYPE | Activity Type | nvarchar | 6 | 0 | | |
| TOPMaintenance Orders |
| 36 | /MRSS/C_OPT_FIL | Demand Filter Definition for Optimization | 7 | ACTIVITY_TYPE | Maintenance activity type (header) | nvarchar | 3 | 0 | | |
| 37 | /MRSS/C_RAP_NPPR | Field control in connection with process progress | 3 | ACTIVITY_TYPE | Process variant | nvarchar | 1 | 0 | | |
| 38 | /MRSS/C_RAP_PV | Settings for Process Variants | 2 | ACTIVITY_TYPE | Process variant | nvarchar | 1 | 0 | | |
| 39 | /MRSS/D_DEM_H | Complex Demand | 22 | ACTIVITY_TYPE | Maintenance activity type (header) | nvarchar | 3 | 0 | | |
| 40 | /MRSS/D_DEM_INFO | Informative Fields for Demand Items | 24 | ACTIVITY_TYPE | Process Variant | nvarchar | 1 | 0 | | |
| 41 | /MRSS/D_DEM_PLR | Data required for planning-relevant items | 33 | ACTIVITY_TYPE | Maintenance activity type (operations) | nvarchar | 6 | 0 | | |
| TOPNon Profit Organizations |
| 42 | T7UNPF_MI_ACTCO | UNJSPF Monthly Interface Activity Control Table | 5 | ACTIVITY_TYPE | Activity Type | nvarchar | 4 | 0 | | |
| TOPOverhead Cost Controlling |
| 43 | KCR_T_CCAT | Data Model for Cost Center/Activity Type | 5 | ACTIVITY_TYPE | Activity Type | nvarchar | 6 | 0 | | |
| 44 | KCR_T_CCAT_TD | Data Model for Cost Center/Activity Type - Time-Dependent | 6 | ACTIVITY_TYPE | Activity Type | nvarchar | 6 | 0 | | |
| TOPPegging, Grouping, and Distribution |
| 45 | TBLP_COST_ITEM | TBLP temporary store of costs for accurate payback | 7 | ACTIVITY_TYPE | Activity Type | nvarchar | 6 | 0 | | |
| TOPPortfolio Management |
| 46 | /RPM/OBJ_CUS_UI | Object type customizing for UI | 4 | ACTIVITY_TYPE | Activity for Authorization Check | nvarchar | 10 | 0 | | |
| 47 | /RPM/OBJ_SAP_UI | Object type SAP UI Fields | 3 | ACTIVITY_TYPE | Activity for Authorization Check | nvarchar | 10 | 0 | | |
| 48 | /RPM/PORT_FLD_UI | Portfolio Fields UI | 5 | ACTIVITY_TYPE | Activity for Authorization Check | nvarchar | 10 | 0 | | |
| 49 | /RPM/WF_RECIP | Object type and activity type relevant for RPM workflow | 3 | ACTIVITY_TYPE | Activity for Authorization Check | nvarchar | 10 | 0 | | |
| TOPTransaction Manager |
| 50 | TEXC_MAP_IN | Mapping for Incoming Raw Exposures | 7 | ACTIVITY_TYPE | Exposure Activity Type | nvarchar | 5 | 0 | | |
| TOPTravel Planning |
| 51 | FTPT_PLAN | General Plan Data | 11 | ACTIVITY_TYPE | Trip Activity Type | nvarchar | 1 | 0 | | |
| 52 | FTPT_PLANHISTORY | General Plan Data | 12 | ACTIVITY_TYPE | Trip Activity Type | nvarchar | 1 | 0 | | |
| 53 | FTPT_QT_QTRIP | Quicktrip Trip | 5 | ACTIVITY_TYPE | Trip Activity Type | nvarchar | 1 | 0 | | |
| 54 | FTPT_REQ_HEAD | Framework Data of Travel Request | 13 | ACTIVITY_TYPE | Trip Activity Type | nvarchar | 1 | 0 | | |
| TOPUnique Identification |
| 55 | IUID_MAN_DATA | Manually Maintained Values for IUID Messages | 47 | ACTIVITY_TYPE | Activity Type | nvarchar | 3 | 0 | | |
| 56 | IUID_PEDIGREE | UII IDoc Message Data for Supporting Supplier Collaboration | 47 | ACTIVITY_TYPE | Activity Type | nvarchar | 3 | 0 | | |
