| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FAGL_R_ARCH_DEF | Definition of Residence Time for Archiving | 2 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
TOPControl Plan |
2 | QPCPD_CPLAN | Control Plan - Header | 8 | PLAN_TYPE | Control Plan Type | nvarchar | 3 | 0 | | |
TOPGeneral Ledger Reorganization |
3 | FAGL_R_BLART | Reorganization: Document Type | 2 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
4 | FAGL_R_COMP_AA | Activation of Asset Accounting by Plan Type | 2 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
5 | FAGL_R_COMP_AA0 | Entities for Activation of Asset Accounting | 2 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
6 | FAGL_R_DERH | Reorganization: Derivation Hierarchy | 2 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
7 | FAGL_R_DERH_VER | Reorganization: Version of a Derivation Hierarchy | 2 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
8 | FAGL_R_DERH_VER0 | Reorganization: Version of a Derivation Hierarchy | 2 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
9 | FAGL_R_DERH_VERT | Reorganization: Text of a Hierarchy Version | 3 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
10 | FAGL_R_JBSIZE | Reorg: Size of a Partition of Object Types to Be Processed | 2 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
11 | FAGL_R_OBJTY | Reorganization: Object Type | 2 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
12 | FAGL_R_OBJTY_DI0 | Reorganization: Display Chars of an Obj. Type (SAP Entries) | 2 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
13 | FAGL_R_OBJTY_DIS | Reorganization: Display Characteristics of an Object Type | 2 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
14 | FAGL_R_OBJTY_RE0 | Reorganization: Restriction Characteristics of an Obj. Type | 2 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
15 | FAGL_R_OBJTY_RES | Reorganization: Restriction Characteristics of an Obj. Type | 2 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
16 | FAGL_R_OBJTY_T | Reorganization: Text of an Object Type | 3 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
17 | FAGL_R_PL | Reorganization Plan | 3 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
18 | FAGL_R_PLTY | Reorganization: Plan Type | 2 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
19 | FAGL_R_PLTY0 | Entities for Activation of Plan Type | 2 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
20 | FAGL_R_PLTY0_T | Reorganization: Text of a Plan Type | 3 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
21 | FAGL_R_PLTY_RES | Reorganization: Restriction Characteristics of a Plan Type | 2 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
22 | FAGL_R_PLTY_RES0 | Reorganization: Restriction Characteristics of a Plan Type | 2 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
23 | FAGL_R_RMVCT | Reorganization: Transaction Type | 2 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | | |
TOPNursing |
24 | N1NRSPH | Nursing Plan: Header Data | 4 | PLAN_TYPE | ISHMED: Nursing Plan - Nursing Plan Type | nvarchar | 1 | 0 | | |
25 | N1SNP | OBSOLETE - Std.Nurs.Plan: Std.Nurs.Plan Header Data | 6 | PLAN_TYPE | | nvarchar | 10 | 0 | | |
TOPPortfolio Management |
26 | /RPM/CAP_B_PLAN | Demand planning for buckets periodic values | 3 | PLAN_TYPE | Plan Type | nvarchar | 2 | 0 | | |
27 | /RPM/CAP_PLAN | xRPM Demand planning periodic values | 3 | PLAN_TYPE | Capacity View Type | nvarchar | 2 | 0 | | |
28 | /RPM/CO_DOWNLOAD | CO Download persisted data | 3 | PLAN_TYPE | Financial View Type | nvarchar | 2 | 0 | | |
29 | /RPM/FIN_B_PLAN | Financial planning for buckets periodic values | 3 | PLAN_TYPE | Financial View Type | nvarchar | 2 | 0 | | |
30 | /RPM/FIN_PLAN | xRPM 4.0 Financial Planning | 3 | PLAN_TYPE | Financial View Type | nvarchar | 2 | 0 | | |
31 | /RPM/FIN_PLA_INT | FI Intermediate table(with exchratedate) | 3 | PLAN_TYPE | Financial View Type | nvarchar | 2 | 0 | | |
32 | RPM_CAPBPLAN_ARC | Demand planning for buckets archive table | 3 | PLAN_TYPE | Plan Type | nvarchar | 2 | 0 | | |
33 | RPM_CAPPLAN_ARC | xRPM Demand planning archive table | 3 | PLAN_TYPE | Capacity View Type | nvarchar | 2 | 0 | | |
34 | RPM_CAP_B_PLN_CD | Bucket demand periodic values - Pseudo table for change docu | 3 | PLAN_TYPE | Plan Type | nvarchar | 2 | 0 | | |
35 | RPM_CAP_PLAN_CD | Cap planning periodic values-Pseudo table for change docu | 3 | PLAN_TYPE | Capacity View Type | nvarchar | 2 | 0 | | |
36 | RPM_FINBPLAN_ARC | Financial planning for buckets archive table | 3 | PLAN_TYPE | Plan Type | nvarchar | 2 | 0 | | |
37 | RPM_FINPLAN_ARC | xRPM Financial Planning archive table | 3 | PLAN_TYPE | Financial View Type | nvarchar | 2 | 0 | | |
38 | RPM_FIN_B_PLN_CD | Bucket financial periodic values-Pseudo table for change doc | 3 | PLAN_TYPE | Plan Type | nvarchar | 2 | 0 | | |
39 | RPM_FIN_PLAN_CD | Fin planning periodic values-Pseudo table for change docu | 3 | PLAN_TYPE | Financial View Type | nvarchar | 2 | 0 | | |