| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000171000 | PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances | 27 | VALUETYPE | | nvarchar | 3 | 0 | | |
2 | /BIC/B0000173000 | PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal. | 29 | VALUETYPE | | nvarchar | 3 | 0 | | |
3 | /BIC/B0000174000 | PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs | 31 | VALUETYPE | | nvarchar | 3 | 0 | | |
4 | /BIC/B0000175000 | PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q) | 31 | VALUETYPE | | nvarchar | 3 | 0 | | |
5 | CCGLT_PRTREQ_PAR | EHS: Print Request Parameters | 8 | VALUETYPE | Value Type of a Parameter Value | nvarchar | 1 | 0 | | |
6 | CCGLT_PR_PAR_UT | EHS: Print Request Parameters Test Data for Unit Tests | 11 | VALUETYPE | Value Type of a Parameter Value | nvarchar | 1 | 0 | | |
7 | EHFNDD_AMNS_ROOT | Amounts - Root | 18 | VALUETYPE | Value Type | nvarchar | 21 | 0 | | |
TOPActivity-Based Costing |
8 | COTPLFP | CO-OM-ABC: Formula Parameter Lists for Process Template | 14 | VALUETYPE | String Type | nvarchar | 1 | 0 | | |
9 | COTPLFV | CO-OM-ABC: Formula Value Lists for Process Template | 11 | VALUETYPE | String Type | nvarchar | 1 | 0 | | |
TOPBudgeting and Availability Control |
10 | GMBDGTLINE | Budget Document Line | 20 | VALUETYPE | GM Value Type | nvarchar | 2 | 0 | | |
11 | GMHBDGTLINE | Budget Line: Held Documents | 21 | VALUETYPE | GM Value Type | nvarchar | 2 | 0 | | |
TOPBW Service API |
12 | RSMVTDETL | Value table for detailling per value type | 1 | VALUETYPE | Value type for Reporting | nvarchar | 3 | 0 | | |
13 | RSMVTSTAT | Value table for statistics indicators per value type | 1 | VALUETYPE | Value type for Reporting | nvarchar | 3 | 0 | | |
14 | RSMVTYPE | Value table for value types for reporting | 1 | VALUETYPE | Value type for Reporting | nvarchar | 3 | 0 | | |
15 | RSTVTDETL | Texts for detailing per value type | 2 | VALUETYPE | Value type for Reporting | nvarchar | 3 | 0 | | |
16 | RSTVTSTAT | Texts for statistics indicator per value type | 2 | VALUETYPE | Value type for Reporting | nvarchar | 3 | 0 | | |
17 | RSTVTYPE | Texts for value types for reporting | 2 | VALUETYPE | Value type for Reporting | nvarchar | 3 | 0 | | |
TOPCompensation Management |
18 | T71WL2 | Parameter for link structure | 7 | VALUETYPE | Type of Parameter for Web Link | nvarchar | 1 | 0 | | |
TOPDepreciation Simulation |
19 | IMCKF | IM Summarization: Key figures | 8 | VALUETYPE | Value Type | nvarchar | 2 | 0 | | |
TOPGeneral Ledger Accounting |
20 | FAGL_BW_LOG_ITEM | FI-GL: Log for BW Extraction: Line Items | 55 | VALUETYPE | Value type for Reporting | nvarchar | 3 | 0 | | |
21 | FAGL_BW_LOG_TOTL | FI-GL: Log for BW Extraction: Totals Records | 32 | VALUETYPE | Value type for Reporting | nvarchar | 3 | 0 | | |
22 | FAGL_QUEUE_LOG | Log of Delta Queue for Error Analysis | 31 | VALUETYPE | Value type for Reporting | nvarchar | 3 | 0 | | |
TOPIncentive and Commission Management ICM |
23 | TCACS_TGS | Target Agreements: Elementary Target Types | 6 | VALUETYPE | Target Agreements: Target Value Type (Amount or Quantity) | nvarchar | 1 | 0 | | |
TOPInformation System |
24 | BIWTBUF_CV | Buffer Texts | 2 | VALUETYPE | Value type for Reporting | nvarchar | 3 | 0 | | |
25 | BIWTDAT_CV | Date Texts | 2 | VALUETYPE | Value type for Reporting | nvarchar | 3 | 0 | | |
26 | BIWTDUR_CV | Duration Texts | 2 | VALUETYPE | Value type for Reporting | nvarchar | 3 | 0 | | |
27 | BIW_BUF_CV | Conversion of Buffer into BW Format | 2 | VALUETYPE | Value type for Reporting | nvarchar | 3 | 0 | | |
28 | BIW_BUF_TB | Conversion of Buffer into BW Format | 2 | VALUETYPE | Value type for Reporting | nvarchar | 3 | 0 | | |
29 | BIW_DAT_CV | Conversion of Dates into BW Format | 2 | VALUETYPE | Value type for Reporting | nvarchar | 3 | 0 | | |
30 | BIW_DAT_TB | Conversion of Dates into BW Format | 2 | VALUETYPE | Value type for Reporting | nvarchar | 3 | 0 | | |
31 | BIW_DUR_CV | Conversion of Duration into BW Format | 2 | VALUETYPE | Value type for Reporting | nvarchar | 3 | 0 | | |
32 | BIW_DUR_TB | Conversion of Duration into BW Format | 2 | VALUETYPE | Value type for Reporting | nvarchar | 3 | 0 | | |
TOPProcess Controls |
33 | GRPCRLCRSYSA | Rule Criteria System Type Assignment | 5 | VALUETYPE | Rule Criteria value Type | nvarchar | 10 | 0 | | |
TOPProduct Configurator |
34 | COMM_CFGCLNDOM | Domains for Numeric Characteristics of Classes | 11 | VALUETYPE | Value type | nvarchar | 1 | 0 | | |
35 | COMM_CFGCLSDOM | Domains for String Characteristics of Classes | 9 | VALUETYPE | Value type | nvarchar | 1 | 0 | | |
36 | COMM_CFGCLVAL | Values and Defaults for Characteristics of Classes | 10 | VALUETYPE | Value type | smallint | 5 | 0 | | |
37 | COMM_CFGNUMDOM | Domains for Numeric Characteristics | 9 | VALUETYPE | Value type | nvarchar | 1 | 0 | | |
38 | COMM_CFGSTRDOM | Domains for String Characteristics | 7 | VALUETYPE | Value type | nvarchar | 1 | 0 | | |
TOPProduct Safety |
39 | CVDDCSP | EHS: Control Structure Parameters (Report Shipping) | 19 | VALUETYPE | Value Type of a Parameter Value | nvarchar | 1 | 0 | | |
40 | CVDDP | EHS: Parameter Values for Report Shipping | 19 | VALUETYPE | Value Type of a Parameter Value | nvarchar | 1 | 0 | | |
41 | ESTAH | EHS: Application-dependent data for report generation | 6 | VALUETYPE | Value Type of a Parameter Value | nvarchar | 1 | 0 | | |
42 | ESTDCSP | EHS: Parameter Control Structure | 19 | VALUETYPE | Value Type of a Parameter Value | nvarchar | 1 | 0 | | |
TOPSales and Distribution |
43 | SCECLVAL | Values Assigned to Characteristics of a Class | 6 | VALUETYPE | Type of value (default or value) | nvarchar | 1 | 0 | | |