| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000139000 | PSA for 0DPR_PROJECT_DATE T90CLNT090 Proj. Def. Dates | 19 | DURATION_UNIT | | nvarchar | 3 | 0 | | |
2 | /BIC/B0000140000 | PSA for 0DPR_PHASE_DATE T90CLNT090 Phase Dates | 19 | DURATION_UNIT | | nvarchar | 3 | 0 | | |
3 | /BIC/B0000141000 | PSA for 0DPR_TASK_DATE T90CLNT090 Task Dates | 21 | DURATION_UNIT | | nvarchar | 3 | 0 | | |
4 | /IAM/C_ACTIVTYP | Activity Template | 8 | DURATION_UNIT | Unit of Activity Duration | nvarchar | 3 | 0 | | |
5 | /MRSS/D_BUND_ORI | Bundled Demand Original data | 17 | DURATION_UNIT | Unit for the Transaction Duration | nvarchar | 3 | 0 | | |
6 | /XLSO/NEW_COURSE | New Course Requirement | 13 | DURATION_UNIT | Duration Unit: Minutes, Hours, Days, Weeks, Months or Year | nvarchar | 10 | 0 | | |
7 | FARR_C_POB_TYPE | Configuration of Performance Obligation Types | 8 | DURATION_UNIT | Duration Unit | nvarchar | 3 | 0 | | |
8 | FARR_D_DEFERRAL | Deferrals | 7 | DURATION_UNIT | Duration Unit | nvarchar | 3 | 0 | | |
9 | FARR_D_LEGACY | Legacy data for initial load of revenue accounting items | 16 | DURATION_UNIT | Duration Unit | nvarchar | 3 | 0 | | |
10 | FARR_D_POB | Performance Obligation | 18 | DURATION_UNIT | Duration Unit | nvarchar | 3 | 0 | | |
TOPCapacity and Resource Planning |
11 | /MRSS/D_RM_MDATA | Maintain Master Data settings for Resource Management | 35 | DURATION_UNIT | Customizable Unit of measure for day type | nvarchar | 3 | 0 | | |
TOPClinical System |
12 | N1ALPROFILE | AppLog: Profile | 10 | DURATION_UNIT | AppLog: Unit of Validity Period Log | nvarchar | 1 | 0 | | |
TOPERP related topics |
13 | /MRSS/C_SNO_DUR | MRS: Default value for work (used during notif. integration) | 5 | DURATION_UNIT | Unit for work | nvarchar | 3 | 0 | | |
TOPError and Conflict Handler |
14 | ECHS_DEFLTRESOL | SAP Default Resolution Strategy | 14 | DURATION_UNIT | Unit for Time Interval | nvarchar | 1 | 0 | | |
TOPGeneric Project Planning |
15 | CGPL_PROJECT | Project Planning: Attribute Table for Project Headers | 27 | DURATION_UNIT | Time Unit for Execution Duration | nvarchar | 3 | 0 | | |
16 | CGPL_TASK | Project Planning: Attribute Table for Activities | 27 | DURATION_UNIT | Time Unit for Execution Duration | nvarchar | 3 | 0 | | |
TOPMaintenance Orders |
17 | /MRSS/D_DEM_PLR | Data required for planning-relevant items | 17 | DURATION_UNIT | Unit for the Transaction Duration | nvarchar | 3 | 0 | | |
TOPSAP Multiresource Scheduling |
18 | /MRSS/C_AVG_TIME | MRS Average Travel Time | 5 | DURATION_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | | |
TOPWorkforce Management Application |
19 | WFAC_BRKTYPES | Break Types | 5 | DURATION_UNIT | Duration Unit of Measure | nvarchar | 3 | 0 | | |
20 | WFA_SCHDL_EVT | Scheduled activites(meetings) | 38 | DURATION_UNIT | Duration Unit of Measure | nvarchar | 3 | 0 | | |
TOPWorkforce Management Core |
21 | WFDSD_DEMAND | Work Force Deployment Demand | 20 | DURATION_UNIT | Unit for Duration of Work | nvarchar | 3 | 0 | | |
22 | WFMCAS_SCHDL_EVT | Scheduled activites(meetings) | 38 | DURATION_UNIT | Duration Unit of Measure | nvarchar | 3 | 0 | | |
23 | WFMC_BRKTYPES | Break Types | 5 | DURATION_UNIT | Duration Unit of Measure | nvarchar | 3 | 0 | | |