| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /PLMB/RCA_BALITM | Balancing Item Assignments | 4 | SUBID | Specification | nvarchar | 12 | 0 | | |
2 | /SDF/ZQLMS | SQL Monitor: Subkeys | 1 | SUBID | Natural Number | int | 10 | 0 | | |
3 | CCGLT_PRTREQ_HDR | EHS: Print Request Header Table | 18 | SUBID | Specification | nvarchar | 12 | 0 | | |
4 | CCGLT_PR_HDR_UT2 | EHS: Print Request Header Table Test Data for Unit Test | 21 | SUBID | Specification | nvarchar | 12 | 0 | | |
5 | DFKKODNREP | Official Document Number for Reporting | 20 | SUBID | Generic Key Extension for Document Class Determination | nvarchar | 3 | 0 | | |
6 | EHPRCD_ACHG_ROOT | ACP Relevant Change - Root | 9 | SUBID | Substance ID | nvarchar | 12 | 0 | | |
7 | EHPRCD_EXIMDS | Available Search Criteria | 3 | SUBID | Specification | nvarchar | 12 | 0 | | |
8 | EHPRCD_PERF | CP: Performance Tests | 7 | SUBID | Specification | nvarchar | 12 | 0 | | |
9 | EHPRCD_STRU_IMG | Product Structure Expanded Image | 23 | SUBID | Specification | nvarchar | 12 | 0 | | |
10 | PA3375 | HR Master Record: Infotype 3375 | 90 | SUBID | Submitted by | nvarchar | 20 | 0 | | |
11 | PA3376 | HR Master Record: Infotype 3376 | 31 | SUBID | Submitted by | nvarchar | 20 | 0 | | |
12 | SQLMS | SQL Monitor: Subkeys | 1 | SUBID | Natural Number | int | 10 | 0 | | |
13 | SQLMZD | SQL Monitor: Data | 3 | SUBID | Natural Number | int | 10 | 0 | | |
14 | SQLMZS | SQL Monitor: Subkeys | 2 | SUBID | Natural Number | int | 10 | 0 | | |
15 | SRTMP_DATA | Runtime Monitoring: Data Table | 5 | SUBID | Natural Number | int | 10 | 0 | | |
16 | SRTMP_SUB | Runtime Monitoring: Subkey Table | 3 | SUBID | Natural Number | int | 10 | 0 | | |
17 | T5FPBS5N | Pas d'un module de condition d'admissibilité (avancement) | 4 | SUBID | Nom de la substitution | nvarchar | 7 | 0 | | |
18 | TFK_DOCCLS_DET | Assign Document Classes to Document Type sand Origin Keys | 5 | SUBID | Generic Key Extension for Document Class Determination | nvarchar | 3 | 0 | | |
19 | TFK_ODN_SID_DET | ODN: Sub-ID Determination | 17 | SUBID | Generic Key Extension for Document Class Determination | nvarchar | 3 | 0 | | |
20 | TFK_ODN_SUBID | ODN: Sub-ID | 3 | SUBID | Generic Key Extension for Document Class Determination | nvarchar | 3 | 0 | | |
21 | TFK_ODN_SUBIDT | ODN: Sub-ID (Text) | 3 | SUBID | Generic Key Extension for Document Class Determination | nvarchar | 3 | 0 | | |
TOPAccrual Engine |
22 | ACEDSASSGMT | Standard Account Assignments for Accrual Objects | 5 | SUBID | Accrual Subobject (Internal Display, Sequence Number) | nvarchar | 5 | 0 | | |
23 | ACEDSOH | Accrual Subobject Header Data | 5 | SUBID | Accrual Subobject (Internal Display, Sequence Number) | nvarchar | 5 | 0 | | |
24 | ACEDSOI | Item Data for Accrual Subobject | 5 | SUBID | Accrual Subobject (Internal Display, Sequence Number) | nvarchar | 5 | 0 | | |
25 | ACEDSOI_ACCOUNTS | Accounts for Accrual Postings per Accrual Item | 5 | SUBID | Accrual Subobject (Internal Display, Sequence Number) | nvarchar | 5 | 0 | | |
26 | ACEDSOP | Accrual Subobject Parameters | 5 | SUBID | Accrual Subobject (Internal Display, Sequence Number) | nvarchar | 5 | 0 | | |
27 | ACEPSOH | Accrual Subobject: Header Data in Posting Component | 5 | SUBID | Accrual Subobject (Internal Display, Sequence Number) | nvarchar | 5 | 0 | | |
28 | ACEPSOI | Accrual Item: Values in Posting Component | 6 | SUBID | Accrual Subobject (Internal Display, Sequence Number) | nvarchar | 5 | 0 | | |
29 | ACEPSOIT | Line Items for Accrual Item in Accrual Engine | 6 | SUBID | Accrual Subobject (Internal Display, Sequence Number) | nvarchar | 5 | 0 | | |
TOPCATT Computer Aided Test Tool |
30 | CAT_DP_FLD | Export fields for DataProvider | 3 | SUBID | Character field, 8 characters long | nvarchar | 8 | 0 | | |
31 | CAT_DP_FOR | DataTab format for data provider ! Iposition Ioffset ! | 3 | SUBID | Character field, 8 characters long | nvarchar | 8 | 0 | | |
32 | CAT_DP_PRO | DataTab properties for data provider | 3 | SUBID | Character field, 8 characters long | nvarchar | 8 | 0 | | |
33 | CAT_DP_TAB | Save CATT DataProvider data | 3 | SUBID | Character field, 8 characters long | nvarchar | 8 | 0 | | |
34 | CAT_FDATA | CATT contents for field lists in CAT_FINFO | 3 | SUBID | Character field, 8 characters long | nvarchar | 8 | 0 | | |
35 | CAT_FINFO | General Control field info | 3 | SUBID | Character field, 8 characters long | nvarchar | 8 | 0 | | |
36 | CAT_PARAMS | CATT - Data for Controls | 3 | SUBID | Character field, 8 characters long | nvarchar | 8 | 0 | | |
37 | CAT_VARS | CATT - Data for Controls | 3 | SUBID | Character field, 8 characters long | nvarchar | 8 | 0 | | |
38 | CAT_VERBS | CATT - Controls data | 3 | SUBID | Character field, 8 characters long | nvarchar | 8 | 0 | | |
TOPCompliance Check |
39 | EHSBT_RC_ESTRHSH | EHS: Table f. Storing Substs w. Constraints in Shared Memory | 21 | SUBID | Specification | nvarchar | 12 | 0 | | |
TOPData Collection |
40 | TMCE | LIS - Environment generation sample reports and references | 2 | SUBID | Subset Id for generating function modules | nvarchar | 5 | 0 | | |
TOPeCATT Extended Computer Aided Test Tool |
41 | CAT_SVARS | DBTab for Control Framework | 3 | SUBID | Character field, 8 characters long | nvarchar | 8 | 0 | | |
42 | ECSCR_TFLD | eCATT - TCD Data Provider Data DP_FLD Export Data | 5 | SUBID | Character field, 8 characters long | nvarchar | 8 | 0 | | |
43 | ECSCR_TFOR | eCATT - TCD Data Provider Data DP_FOR Format for DataTab | 5 | SUBID | Character field, 8 characters long | nvarchar | 8 | 0 | | |
44 | ECSCR_TPAR | eCATT - TCD Control Data PARAMS | 5 | SUBID | Character field, 8 characters long | nvarchar | 8 | 0 | | |
45 | ECSCR_TPRO | eCATT - TCD Data Provider Data DP_PRO Properties for DataTab | 5 | SUBID | Character field, 8 characters long | nvarchar | 8 | 0 | | |
46 | ECSCR_TSVAR | eCATT - TCD Control Data SVARS | 5 | SUBID | Character field, 8 characters long | nvarchar | 8 | 0 | | |
47 | ECSCR_TTAB | eCATT - TCD Data Provider Data DP_TAB | 5 | SUBID | Character field, 8 characters long | nvarchar | 8 | 0 | | |
48 | ECSCR_TVAR | eCATT - TCD Control Data VARS | 5 | SUBID | Character field, 8 characters long | nvarchar | 8 | 0 | | |
49 | ECSCR_TVER | eCATT - TCD Control Data VERBS | 5 | SUBID | Character field, 8 characters long | nvarchar | 8 | 0 | | |
TOPEnvironment, Health and Safety |
50 | /TDAG/CPT_EXIMDS | Available Search Criteria | 3 | SUBID | Specification | nvarchar | 12 | 0 | | |
51 | /TDAG/CPT_EXUPL | CP: Application Table für IMDS Uplolad | 2 | SUBID | Specification | nvarchar | 12 | 0 | | |
52 | /TDAG/CPT_PERF | CP: Performance Tests | 7 | SUBID | Specification | nvarchar | 12 | 0 | | |
53 | /TDAG/CPT_TASKH | Header data for tasks | 3 | SUBID | Specification | nvarchar | 12 | 0 | | |
54 | /TDAG/CPT_TASKHA | CP: Kopfdaten für Aufgaben / Archiv | 3 | SUBID | Specification | nvarchar | 12 | 0 | | |
55 | /TDAG/CPT_TRCKH | Obsolete - CP: Tracker - Kopfdaten | 5 | SUBID | Specification | nvarchar | 12 | 0 | | |
56 | /TDAG/CPT_TRCKHA | Obsolete - CP: Tracker - Kopfdaten / Archiv | 5 | SUBID | Specification | nvarchar | 12 | 0 | | |
57 | EHQMT_BASIC_DATA | EH&S-QM: Basic Data for Inspection Plans | 5 | SUBID | Specification | nvarchar | 12 | 0 | | |
TOPGoods Receipt Process |
58 | BORRTTI | Time for route schedule (new) | 5 | SUBID | Schedule Item Number | nvarchar | 4 | 0 | | |
59 | BORRTTS | Route schedule header (new) | 13 | SUBID | Last Item Counter | nvarchar | 4 | 0 | | |
TOPInspection Planning |
60 | QMIPD_MAP_QPAM | Mapping Table for Selected Set from External Source | 7 | SUBID | Specification | nvarchar | 12 | 0 | | |
TOPLease Accounting |
61 | FIEH_STATUS | Object Status for Restart Exception Handling | 5 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
62 | FILA_GF_ITEMCHAH | Object Data: Value ID Change Header Information | 5 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
63 | FILA_GF_ITEMDATA | Process Data | 5 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
64 | FILA_GF_ITEMDOCS | Assignment of Process - FI/CO Document Numbers | 4 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
65 | FILA_GF_ITEMLINK | Assignment of Objects to Assets | 5 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
66 | FILA_GF_ITEMPARM | Object Data: Additional Information | 5 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
67 | FILA_GF_ITEMVALC | Object Data: Changed Value IDs | 5 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
68 | FILA_GF_ITEMVALS | Object Data: Value IDs and their Values/Contents | 5 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
69 | FILA_GF_PROCINFO | Object Data: Processing Info for Process | 5 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
70 | FILA_RE_LNK | Link Between Leasing <-> Refinancing | 4 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
71 | FILA_RE_TR_I | Tranche Item: Selection Result for Refinancing | 4 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
72 | FIOTPOH | One-Time Postings: Header | 5 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
73 | FIOTPOI | One-Time Postings: Items | 5 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
74 | LAE_BILLING_DAT | Payment Schedule | 3 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
75 | LAE_BILLING_DATA | Payment Schedule | 4 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
76 | LAE_CRM_BILLPLAN | Payment Schedule | 4 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
77 | LAE_CRM_CLASS | Contract Classification | 4 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
78 | LAE_CRM_CONDS | Lease-Accounting-Relevant Conditions | 4 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
79 | LAE_CRM_ITEMS | LAE: Contract Items | 4 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
80 | LAE_CRM_LNK | Link between LAE and CRM Contract Items | 6 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
81 | LAE_CRM_PRODS | Product Information | 4 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
82 | LAE_VICN01_AD | Additional Contract Data for LAE | 5 | SUBID | Subobject Number | nvarchar | 5 | 0 | | |
TOPMaintenance Orders |
83 | /MRSS/D_DEM_ADM | Administrative Demand Item Data | 7 | SUBID | Sub ID of Demand Item | nvarchar | 4 | 0 | | |
TOPMeasuring Points and Counters |
84 | IMPH | Measurement and Counter Reading Transmission History | 3 | SUBID | Line Number in Table IMPH (2,000,000,001 - n) | int | 10 | 0 | | |
TOPProduct Safety |
85 | CCGLT_AUDH | EHS: Audit Data Header Entry | 13 | SUBID | Specification | nvarchar | 12 | 0 | | |
86 | CCRCT_CALC | EHS: Calculated Average | 6 | SUBID | Specification | nvarchar | 12 | 0 | | |
87 | CCRCT_CO | EHS: Confirmed Consumed Quantities | 6 | SUBID | Specification | nvarchar | 12 | 0 | | |
88 | CCRCT_COPL | EHS: Planned Consumed Quantities | 6 | SUBID | Specification | nvarchar | 12 | 0 | | |
89 | CCRCT_CU | EHS: Customer List - Header Data | 8 | SUBID | Specification | nvarchar | 12 | 0 | | |
90 | CCRCT_EHS_COMP | EHS: Composition (EH&S Data) | 5 | SUBID | Specification | nvarchar | 12 | 0 | | |
91 | CCRCT_PR | EHS: Confirmed Produced Quantities | 6 | SUBID | Specification | nvarchar | 12 | 0 | | |
92 | CCRCT_PRPL | EHS: Planned Produced Quantities | 6 | SUBID | Specification | nvarchar | 12 | 0 | | |
93 | CCRCT_PU | EHS: Confirmed Purchased Quantities | 6 | SUBID | Specification | nvarchar | 12 | 0 | | |
94 | CCRCT_PUPL | EHS: Planned Purchased Quantities | 6 | SUBID | Specification | nvarchar | 12 | 0 | | |
95 | CCRCT_SO | EHS: Confirmed Sold Quantities | 6 | SUBID | Specification | nvarchar | 12 | 0 | | |
96 | CCRCT_SOPL | EHS: Planned Sold Quantities | 6 | SUBID | Specification | nvarchar | 12 | 0 | | |
97 | CVDDH | EHS: Report shipping orders | 51 | SUBID | Specification | nvarchar | 12 | 0 | | |
98 | EHCSMD_SPC_UT | CBUI_BO Unit Test Helper DB Table | 7 | SUBID | Specification | nvarchar | 12 | 0 | | |
99 | ESTDH | EHS: Report Header | 16 | SUBID | Specification | nvarchar | 12 | 0 | | |
100 | ESTDSCS | EHS: eSDS Control Structure | 16 | SUBID | Specification | nvarchar | 12 | 0 | | |
101 | ESTOCC | EHS: OCC: Table for Saving Import Information | 17 | SUBID | Specification | nvarchar | 12 | 0 | | |
102 | ESTRH | EHS: Specification Header | 18 | SUBID | Specification | nvarchar | 12 | 0 | | |
103 | EST_CHANGE_DOCS | EHS: Change Documents in the EH&S System | 3 | SUBID | Specification | nvarchar | 12 | 0 | | |
TOPPublic Sector |
104 | PA0752 | HR Master Record: Infotype 0752 | 40 | SUBID | Submitted by | nvarchar | 20 | 0 | | |
105 | PA0753 | HR Master Record: Infotype 0753 | 32 | SUBID | Submitted by | nvarchar | 20 | 0 | | |
106 | PA0754 | HR Master Record: Infotype 0754 | 30 | SUBID | Submitted by | nvarchar | 20 | 0 | | |
107 | PA0755 | HR Master Record: Infotype 0755 | 27 | SUBID | Submitted by | nvarchar | 20 | 0 | | |
TOPRecipe Development |
108 | /PLMB/CCK_DRE | Compliance Check: Detailed Results | 4 | SUBID | Specification ID | nvarchar | 12 | 0 | | |
109 | /PLMB/CCK_OBJ | Compliance Check: Objects to be checked | 3 | SUBID | Specification ID | nvarchar | 12 | 0 | | |
110 | /PLMB/CCK_PDEF | Compliance Check: Parameter Defaults | 2 | SUBID | Specification ID | nvarchar | 12 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
111 | /BEV3/CHCTBTDAT | Data to be Copied for Each BTE | 3 | SUBID | Subset ID for Generating Function Modules | nvarchar | 5 | 0 | | |
TOPResourcen Management |
112 | FRMLC71 | RMS-FRM: Sort Sequence for Diet Groups | 2 | SUBID | Substance | nvarchar | 12 | 0 | | |
113 | FRMLC_NTR_GRP | RMS-FRM: Nutrient Groups | 2 | SUBID | Substance | nvarchar | 12 | 0 | | |
114 | RMXTT_TRIAL_FRML | Trial: Material Consumption (Formula) | 12 | SUBID | Specification | nvarchar | 12 | 0 | | |
TOPRuntime Analysis |
115 | HIT_CMP_AUS | Output Structure for Hit List Compare | 2 | SUBID | | nvarchar | 1 | 0 | | |
116 | SATR_HIT_HIER | Event Hierarchy for SE30 and Hit List Compare | 3 | SUBID | SATR: SUBID: Sub-ID of a TRACE Record | nvarchar | 1 | 0 | | |
117 | SATR_ID_SUBID | SATR: Table of ID/SUBID Combinations | 2 | SUBID | SATR: SUBID: Sub-ID of a TRACE Record | nvarchar | 1 | 0 | | |
118 | SATR_ID_SUBID_SD | RT Analysis: ID/SubID Text Assignment for Sequence Diagram | 2 | SUBID | SATR: SUBID: Sub-ID of a TRACE Record | nvarchar | 1 | 0 | | |
119 | SATR_ZUO | SATR : Assignment Table ID/SUBID for Main/Middle Groups | 2 | SUBID | SATR: SUBID: Sub-ID of a TRACE Record | nvarchar | 1 | 0 | | |
TOPSAP System Log |
120 | TSL1D | System Log Message (Formerly 100S or TSL01) | 2 | SUBID | System log: Third character of message name | nvarchar | 1 | 0 | | |
121 | TSL1T | System Log: Message texts (Formerly T100S, TSL01) | 3 | SUBID | System log: Third character of message name | nvarchar | 1 | 0 | | |
TOPService Data Download |
122 | TCUSSYSL | Summary table of message types read from the system log | 2 | SUBID | Single-Character Indicator | nvarchar | 1 | 0 | | |
TOPSyntax, Compiler, Runtime |
123 | SRTM_DAAB | Runtime Monitoring: Data Table | 3 | SUBID | Natural Number | int | 10 | 0 | | |
124 | SRTM_DATA | Runtime Monitoring: Data Table | 3 | SUBID | Natural Number | int | 10 | 0 | | |
125 | SRTM_DATAX | Runtime Monitoring: Data Table for Hexadecimal Strings | 3 | SUBID | Natural Number | int | 10 | 0 | | |
126 | SRTM_SUB | Runtime Monitoring: Subkey Table | 1 | SUBID | Natural Number | int | 10 | 0 | | |
TOPValue Adjustment |
127 | /IBS/CRB_BA_NRKR | RBD: Number Range Assignment | 3 | SUBID | RBD: Sub ID (Help Key Field) | nvarchar | 20 | 0 | | |
TOPWarranty Claim Processing |
128 | CWTYVS | Activation Table for Validation/Substitution | 6 | SUBID | Substitution name | nvarchar | 7 | 0 | | |