| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /FLDQ/HNA_CN_OPT | DQM on Hana Country Specific Configuration | 6 | VAL | Possible Values for Country Specifc PV Settings | nvarchar | 20 | 0 | | |
2 | /FLDQ/HNA_PV_VAL | Possible Vlaues for PV on Hana Country Specific Settings | 3 | VAL | Possible Values for Country Specifc PV Settings | nvarchar | 20 | 0 | | |
TOPBasic Functions |
3 | T830A | FI-SL Master Record Table | 3 | VAL | Set value | nvarchar | 24 | 0 | | |
4 | T830B | FI-SL Master Record Table | 3 | VAL | Set value | nvarchar | 24 | 0 | | |
5 | T830D | FI-SL Master Record Table | 3 | VAL | Set value | nvarchar | 24 | 0 | | |
6 | T831A | FI-SL Master data text | 4 | VAL | Set value | nvarchar | 24 | 0 | | |
7 | T831B | FI-SL Master Record Table | 4 | VAL | Set value | nvarchar | 24 | 0 | | |
8 | T831D | FI-SL Master data text | 4 | VAL | Set value | nvarchar | 24 | 0 | | |
TOPBusiness Package for Manager Self-Service FI |
9 | FPB_LINE_DATA | Data Store for Line Item Monitors | 7 | VAL | Total Value in Controlling Area Currency | decimal | 15 | 2 | | |
TOPData Collection |
10 | S174 | Services | 20 | VAL | Order value in document currency | decimal | 15 | 2 | | |
11 | S174BIW1 | S174BIW1 * Activities | 20 | VAL | Order value in document currency | decimal | 15 | 2 | | |
12 | S174BIW2 | S174BIW2 * Activities | 20 | VAL | Order value in document currency | decimal | 15 | 2 | | |
TOPFinancials Basis |
13 | UBC_TB_ACTV | Values for Account Assignment Fields | 4 | VAL | Value of Account Assignment Field (G/L Account, Project,...) | nvarchar | 20 | 0 | | |
14 | UBC_TB_BILDVAL | Account Assignment Default Values on Level of Biller | 5 | VAL | Value of Account Assignment Field (G/L Account, Project,...) | nvarchar | 20 | 0 | | |
15 | UBC_TB_CUR | Max./Min. Amounts per User and Currency | 5 | VAL | Amount in document currency | decimal | 13 | 2 | | |
16 | UBC_TB_INVHACT | Account Assignments on Bill Header | 5 | VAL | Value of Account Assignment Field (G/L Account, Project,...) | nvarchar | 20 | 0 | | |
17 | UBC_TB_INVPACT | Account Assignments on Level of Item | 6 | VAL | Value of Account Assignment Field (G/L Account, Project,...) | nvarchar | 20 | 0 | | |
18 | UBC_TB_ORGDVAL | Account Assignment Default Values on Level of Biller | 4 | VAL | Value of Account Assignment Field (G/L Account, Project,...) | nvarchar | 20 | 0 | | |
19 | UBC_TB_RADVAL | Account Assignment Default Values on Level of Bill Type | 6 | VAL | Value of Account Assignment Field (G/L Account, Project,...) | nvarchar | 20 | 0 | | |
20 | UBC_TB_RPADVAL | Account Assignment Default Values on Level of Bill Item Type | 6 | VAL | Value of Account Assignment Field (G/L Account, Project,...) | nvarchar | 20 | 0 | | |
21 | UBC_TT_ACTV | Texts for Values of Account Assignment Fields | 4 | VAL | Value of Account Assignment Field (G/L Account, Project,...) | nvarchar | 20 | 0 | | |
TOPGraphic |
22 | TBCR | Ribbon Attributes Generated with Time Scale Wizard | 8 | VAL | Value in value table | nvarchar | 80 | 0 | | |
TOPMapping |
23 | SMPPBIND | Mapping Parameterization: Binding | 6 | VAL | Mapping Parameterization: Value | ntext | 1073741823 | 0 | | |
24 | SMPPCONT | Test for Mapping Parameterization | 9 | VAL | Mapping Parameterization: Value | ntext | 1073741823 | 0 | | |
TOPPlant Maintenance |
25 | Z9I_STK_CUST | Stillstandskontrolle: Steuerungsparameter | 3 | VAL | Parameterwert | nvarchar | 40 | 0 | | |
TOPSchedule Manager |
26 | SMEXT | Information on Results Lists That Have Been Saved | 5 | VAL | Unstructured Data Field | nvarchar | 100 | 0 | | |
27 | SMRL | Information on Saved Basic Lists | 5 | VAL | Unstructured Data Field | nvarchar | 100 | 0 | | |
TOPVirtual Machine Container |
28 | SVMCRT_BINDINGS | VMC Runtime: Resources | 6 | VAL | Binary Data of Binding | image | 2147483647 | 0 | | |
TOPWithout Description |
29 | IRTEST_URL | Variable Replacement CR | 2 | VAL | Value of an installation parameter for CR | nvarchar | 128 | 0 | | |
TOPWork Clearance Management |
30 | WCAB | WCM: Valuation | 5 | VAL | Valuation | nvarchar | 1 | 0 | | |
31 | WCABQ | WCM: Log (Valuation) | 6 | VAL | Valuation | nvarchar | 1 | 0 | | |
32 | WCACG | WCM: WCM Object <-> Catalog | 12 | VAL | Valuation | nvarchar | 1 | 0 | | |
33 | WCACGQ | WCM: Log (WCM Object <-> Catalog) | 13 | VAL | Valuation | nvarchar | 1 | 0 | | |
34 | WCAD | WCM: Approval Group | 9 | VAL | Valuation | nvarchar | 1 | 0 | | |
35 | WCADQ | WCM: Log (Approval Group) | 10 | VAL | Valuation | nvarchar | 1 | 0 | | |
36 | WCCPV | WCM: Approval Groups | 8 | VAL | Valuation | nvarchar | 1 | 0 | | |