| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPliveCache Applications |
1 | /SAPAPO/ORDKEY | Key and descriptive data for order | 3 | SIMID | Name of Planning Version | nvarchar | 22 | 0 | | |
2 | /SAPAPO/STOCKANC | Key and Descriptive Data for Stock | 2 | SIMID | Name of Planning Version | nvarchar | 22 | 0 | | |
3 | /SAPAPO/UPGRADE | Data for Release Upgrade | 3 | SIMID | Name of Planning Version | nvarchar | 22 | 0 | | |
4 | MMRP_DATEVECS | Key: Date Vector (Only in the liveCache) | 3 | SIMID | Name of Planning Version | nvarchar | 22 | 0 | | |
5 | RPM_PERF_DATA | RPM: Performance Results (only in the liveCache) | 2 | SIMID | Name of Planning Version | nvarchar | 22 | 0 | | |
6 | RPM_PLAN_FILE | Matrix: RPM Markings (Only in liveCache) | 2 | SIMID | Name of Planning Version | nvarchar | 22 | 0 | | |
TOPWorkforce Management Core |
7 | /SAPAPO/LRPASGLC | Table of Dispatching Details for Assignment | 2 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
8 | /SAPAPO/LRPASLCT | Long Descriptions for Assignments | 2 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
9 | /SAPAPO/LRPASSAR | Table of Dispatching Details for Assignment | 3 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
10 | /SAPAPO/LRPASSGN | Obsolete: Table of Dispatching Details for Assignment | 2 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
11 | /SAPAPO/LRPASSIG | Table of Dispatching Details for Assignment | 2 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
12 | /SAPAPO/LRPASSIT | Long Descriptions for Assignments | 2 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
13 | /SAPAPO/LRPCAPAV | Interval list for capacitive time specification | 3 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
14 | /SAPAPO/LRPCAPIL | Capacitve Time Intervals List | 3 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
15 | /SAPAPO/LRPDEMH | LRP Requirements | 3 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
16 | /SAPAPO/LRPDUKEY | Obsolete: Attributes for Time Durations | 3 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
17 | /SAPAPO/LRPITKEY | Attributes for Time Intervals | 3 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
18 | /SAPAPO/LRPLOCD | Demand Locations | 3 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
19 | /SAPAPO/LRPLOCR | WFM Supplied Location Table for Resources | 3 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
20 | /SAPAPO/LRPREQRT | Resource Type Profile Requirement | 2 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
21 | /SAPAPO/LRPREQWD | Search/Requirements Profile for Work Descriptions | 3 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
22 | /SAPAPO/LRPRESO | Key and Descriptive Data for a Resource | 3 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
23 | /SAPAPO/LRPRKEY | Obsolete since 110: Key and Descriptive Data for a Resource | 3 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
24 | /SAPAPO/LRPRQPRO | Qualifications Profile | 2 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
25 | /SAPAPO/LRPRTSAT | Attributes for a Requirement's Time Data | 3 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
26 | /SAPAPO/LRPRWRES | LRP Work Description: WD Resource Object | 4 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
27 | /SAPAPO/LRPRWTIM | Work Description: WD Time Object for Requirements | 3 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
28 | /SAPAPO/LRPSCHED | Obsolete: Planning Step Table | 2 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
29 | /SAPAPO/LRPSCPRO | Supplied WD Time Capacity Limits Profile Set | 2 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
30 | /SAPAPO/LRPSOPRO | Supplied WD Time Overtime Profile Set | 2 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
31 | /SAPAPO/LRPSQPRO | Qualifications Profile | 2 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
32 | /SAPAPO/LRPSTSAT | Attributes for Resource's Time Data | 3 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
33 | /SAPAPO/LRPSUPWD | WFM Capacity Profile for Work Descriptions (Internal) | 3 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
34 | /SAPAPO/LRPSWTIM | Work Description: WD Time Object for Resources | 3 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
35 | /SAPAPO/LRPTMRUL | WFM Time Specification - Rules | 3 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
36 | /SAPAPO/LRPTSATT | Obsolete: Attributes for Time Data | 3 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
37 | /SAPAPO/LRPTSTRM | Table for WFM Time Streams of the BuiltIn Dispatcher | 2 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
38 | /SAPAPO/LRPWDRES | LRP Work Description: WD Resource Object | 4 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
39 | /SAPAPO/LRPWDTIM | Obsolete: LRP Work Description: WD Time Object | 3 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
40 | /SAPAPO/TSTASGLC | Table of Dispatching Details for Assignment | 2 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
41 | /SAPAPO/TSTASSIG | Table of Dispatching Details for Assignment | 2 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
42 | /SAPAPO/TSTRESO | Key and Descriptive Data for a Resource | 3 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |
43 | /SAPAPO/TSTRWRES | LRP Work Description: WD Resource Object | 4 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | | |