| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPGovernance, Risk and Compliance |
1 | GRFNDMRI | DataMart: Risk Influenced | 4 | RI | Influenced Risk ID | nvarchar | 16 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
2 | /BEV3/CHABRKZL_T | CH Settlement Key Figure Statistics | 7 | RI | Rule Identifier - Contract Called | nvarchar | 6 | 0 | | |
3 | /BEV3/CHABRSTZ_P | CH Settlement Items - With Translations | 13 | RI | Rule Identifier - Contract Called | nvarchar | 6 | 0 | | |
4 | /BEV3/CHAGTREE | Contract Tree | 8 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
5 | /BEV3/CHBABNHM | Agreement Purchase | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
6 | /BEV3/CHBABSATZ | Agreement Sales | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
7 | /BEV3/CHBABSS | Agreement Sales Scale Refund | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
8 | /BEV3/CHBABSTVG | Agreement Sales Scale Refunding | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
9 | /BEV3/CHBABSVG | Agreement Sales Refunding | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
10 | /BEV3/CHBALLG | Agreements Administration table (Generalized Data) | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
11 | /BEV3/CHBALLV | Agreements Administration Table: Visibility Index | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
12 | /BEV3/CHBANNU | Agreement Annuity | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
13 | /BEV3/CHBBDGSTF | Agreement Condition Strategy - Formula | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
14 | /BEV3/CHBBDGSTT | Agreement Condition Strategy - Text | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
15 | /BEV3/CHBBKBDG | Agreement Purchase Control - Part Condition | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
16 | /BEV3/CHBBKBFI | Agreement Purchase Control - Part Valuation FI | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
17 | /BEV3/CHBBKBSD | Agreement Purchase Control - Part Valuation SD | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
18 | /BEV3/CHBBKBVV | Agreement Purchase Control - Part Valuation CH | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
19 | /BEV3/CHBBKFLG | Agreement Purchase Control - Part Sequence | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
20 | /BEV3/CHBBKKNTR | Agreement Purchase Control - Part Request | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
21 | /BEV3/CHBBKST | Agreement Purchase Control - Part Status | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
22 | /BEV3/CHBBKTM | Agreement Purchase Control - Part Date | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
23 | /BEV3/CHBBKVRKT | Agreement Purchase Control - Part Concatenation | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
24 | /BEV3/CHBCALCC | Agreement Calculation - Formula Constant | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
25 | /BEV3/CHBCALCF | Agreement Calculation - Formula | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
26 | /BEV3/CHBCALCT | Agreement Calculation | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
27 | /BEV3/CHBCALCTT | Agreement Calculation - Text | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
28 | /BEV3/CHBCALCV | Agreement Calculation - Formula Variable | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
29 | /BEV3/CHBDATUM | Agreement Date | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
30 | /BEV3/CHBDMDHST | History of Condit. Modifications from Temp. Settlement Items | 14 | RI | Rule Identifier - Contract Called | nvarchar | 6 | 0 | | |
31 | /BEV3/CHBEINBIN | Integration Agreement | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
32 | /BEV3/CHBEXTB | Agreement External Amount | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
33 | /BEV3/CHBEZINS | External Interest Agreement | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
34 | /BEV3/CHBFBTRG | Agreement Fixed Amount | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
35 | /BEV3/CHBFPROZ | Agreement Fixed Percentage | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
36 | /BEV3/CHBGABS | Total Sales Agreement | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
37 | /BEV3/CHBGROUP | Agreement Group | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
38 | /BEV3/CHBGUMS | Total Sales Agreement | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
39 | /BEV3/CHBINST | Agreements Administration Table Entity Attributes | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
40 | /BEV3/CHBINSTT | Agreements Administration Table Entity Attributes | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
41 | /BEV3/CHBIZINS | Agreement Internal Interest | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
42 | /BEV3/CHBKERGRSL | Purchase control results | 6 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
43 | /BEV3/CHBKOMTR | Agreement Communication | 5 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
44 | /BEV3/CHBKONT | Agreement Account | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
45 | /BEV3/CHBKPKPZL | Agreement Complement Capital Payment (BTE) | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
46 | /BEV3/CHBKRESHIS | Purchase Control Results - History | 6 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
47 | /BEV3/CHBKRESULT | Purchase control results | 6 | RI | Rule Identifier for Purchase Control | nvarchar | 6 | 0 | | |
48 | /BEV3/CHBKTMP | Temp. Purchase Control Results | 6 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
49 | /BEV3/CHBLEIST | Agreement Performance | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
50 | /BEV3/CHBMINUM | Agreement Sales Target | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
51 | /BEV3/CHBPART | Agreement Partner SD | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
52 | /BEV3/CHBPOST | Agreement Text | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
53 | /BEV3/CHBPRZABW | Agreement Out-of-Line Percentage | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
54 | /BEV3/CHBPRZGRZ | Agreement Percentage Limits | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
55 | /BEV3/CHBREGINF | Payer Information Agreement | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
56 | /BEV3/CHBRUECK | Agreement Breakdown Arrears | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
57 | /BEV3/CHBSALEI | Payment in Kind Agreement | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
58 | /BEV3/CHBSECURE | Agreement Collateral | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
59 | /BEV3/CHBSICH | Agreement Collateral | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
60 | /BEV3/CHBSORT | Agreement Contract Assortment List | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
61 | /BEV3/CHBTERMIN | Agreement Date | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
62 | /BEV3/CHBTMANFO | Agreement Date Request | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
63 | /BEV3/CHBTMANWE | Agreement Date Statement | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
64 | /BEV3/CHBTMBDG | Agreement Date Condition | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
65 | /BEV3/CHBTMBEWFI | Agreement Date Valuation FI | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
66 | /BEV3/CHBTMBEWSD | Agreement Date Valuation SD | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
67 | /BEV3/CHBTMBEWVV | Agreement Date Valuation CH | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
68 | /BEV3/CHBTMFOLGE | Agreement Date Sequence | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
69 | /BEV3/CHBTMSTATU | Agreement Date Status | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
70 | /BEV3/CHBTMVKTG | Agreement Date Concatenation | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
71 | /BEV3/CHBUMSATZ | Agreement Sales (Actual) | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
72 | /BEV3/CHBUMSP | Agreement Sales Scale, Percent | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
73 | /BEV3/CHBVERRE | Agreement Clearing | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
74 | /BEV3/CHBVORG | Agreement Transaction | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
75 | /BEV3/CHBVWDNR | Agreement deviating CHD number | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
76 | /BEV3/CHBWAER | Agreement Currency | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
77 | /BEV3/CHBXREF | Agreements Where-Used-List | 6 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
78 | /BEV3/CHBZUSCH | Agreement Allowance | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
79 | /BEV3/CHCAABTXT | Exception Handling: Programs for Exception Handling - Text | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
80 | /BEV3/CHCAGCLSF | Assignment: Agreement to classification | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
81 | /BEV3/CHCA_AB | Exception Handling: Programs for Exception Handling | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
82 | /BEV3/CHCA_PRO | Exception Handling: log | 14 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
83 | /BEV3/CHCA_RE | Exception Handling: Response | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
84 | /BEV3/CHCA_REL | Exception Handling: Relevance Table for Exception Analysis | 10 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
85 | /BEV3/CHCA_VW | Exception Handling: Comparative Data Table Currency | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
86 | /BEV3/CHCBKRIVBW | Contract MVT dependent on CoCd, RI, Date part, Contract view | 3 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
87 | /BEV3/CHCBPO0350 | Amount to be copied from LT0350 into BPO dep. on AC/RI/ENT | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
88 | /BEV3/CHCBPO0500 | Assignment of the basic data to BPO | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
89 | /BEV3/CHCBPO700A | BPOs for link type 0700: Build-up BPO with components | 6 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
90 | /BEV3/CHCBPO700P | Information for Evaluating Link Type 0700 - Data Sources | 5 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
91 | /BEV3/CHCDPBEWSD | CDP: Contract Dates (SD Valuation) | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
92 | /BEV3/CHCDPBK | CDP: Purchase Control Results | 5 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
93 | /BEV3/CHCDPLINK | CDP: Contract References | 14 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
94 | /BEV3/CHCDPOBLIG | CDP: Contractual Services | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
95 | /BEV3/CHCDPPARM | CDP: Parameter Control of CDP | 8 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
96 | /BEV3/CHCDPSALES | CDP: Contract Sales (Detailed) | 9 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
97 | /BEV3/CHCDPSORTM | CDP: Contract Assortments | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
98 | /BEV3/CHCDPTERMI | CDP: Contract Dates (Dates and PC) | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
99 | /BEV3/CHCDPTEXT | CDP: Contract Texts | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
100 | /BEV3/CHCERGPER | Customizing: Supplement - Periods to Be Supplemented | 3 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
101 | /BEV3/CHCEVLASFI | CH BTE: Customizing Event Listener Assessment FI | 7 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
102 | /BEV3/CHCFDFIELD | Target Fields of Agreements | 3 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
103 | /BEV3/CHCHDP | Reports for Evaluation Agreements | 3 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
104 | /BEV3/CHCKAWDEF | Definition of the CEV evaluations | 8 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
105 | /BEV3/CHCKMPLMNT | Custom. of Complementation f. Negative Amounts in Sett. Rec. | 2 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
106 | /BEV3/CHCLTLOABR | Link type/place for data transfer in settlement record | 3 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
107 | /BEV3/CHCPOSTX | Item texts | 5 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
108 | /BEV3/CHCPT_F | Selected Fields for Item Text Formation | 5 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
109 | /BEV3/CHCRSTRT | Item List - Resettle/Change Despite Success.Final Settlement | 3 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
110 | /BEV3/CHCSIMKONT | Spec. Account Views for Settlement Simulation | 5 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
111 | /BEV3/CHCSIMSALD | Spec. Balancing Method for Simulation | 5 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
112 | /BEV3/CHCTKMPBCH | Complement Postings (BTE) | 9 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
113 | /BEV3/CHCTLTBER | Link Type/Link Loc. Combination with Ref. to Consultant Tab. | 3 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
114 | /BEV3/CHCTSTBSHL | Posting key dependent on CoCd,acc. type/Datepart,sett.method | 5 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
115 | /BEV3/CHCTSTRKZ | CH Settlement Tax Indicator | 3 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
116 | /BEV3/CHCTTMPRIO | Customizing Date Priority (CH Cross-Organizational) | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
117 | /BEV3/CHCTTMPRIV | Customizing Date Priority per CH Organization Unit | 5 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
118 | /BEV3/CHCTTMSTZP | Customizing: Time -> Module | 3 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
119 | /BEV3/CHCTVBRILO | Allowed Locations_out for Agreement Class/Rule Identifier | 3 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
120 | /BEV3/CHCTVRABG | Customizing AG Class Rule ID Rule Attribute Condition Group | 3 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
121 | /BEV3/CHCTVRILOT | Customizing: Linktype(Out) Linktype/Loc.(In) for AG Class RI | 3 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
122 | /BEV3/CHCVBFIMA1 | FIMA converter 1 AC/RI control record setting | 3 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
123 | /BEV3/CHCVBWBKRI | RI, DAPART,contract view dependent on contract movement type | 5 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
124 | /BEV3/CHC_KAWDEF | Definition of the CEV evaluations | 8 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
125 | /BEV3/CHERGSTZ_P | CH Settlement Items - With Translations | 13 | RI | Rule Identifier - Contract Called | nvarchar | 6 | 0 | | |
126 | /BEV3/CHERGSTZ_S | CH Settlement Statistics | 14 | RI | Rule Identifier - Contract Called | nvarchar | 6 | 0 | | |
127 | /BEV3/CHEVTMNOTE | Date Part Info. Regarding Link to Deviating CHD Number | 6 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
128 | /BEV3/CHEVVWDNRN | Information from the Deviating AG CHD No. to the BTE | 7 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
129 | /BEV3/CHEXCSTZ_P | CH Settlement Items/Non-Posted Docs w/o Date Statistics | 13 | RI | Rule Identifier - Contract Called | nvarchar | 6 | 0 | | |
130 | /BEV3/CHKAALLOCA | Customer Evaluation Table: Contract Allocations | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
131 | /BEV3/CHKABEWSD | Customer Evaluation Table: Dates Valuation SD | 5 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
132 | /BEV3/CHKAOBLIGA | Customer Evaluation Table: Contract Performances | 5 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
133 | /BEV3/CHKASRTMNT | Customer Evaluation Table: Assortments | 5 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
134 | /BEV3/CHKATERMIN | Customer Evaluation Table: Dates General | 5 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
135 | /BEV3/CHKATMABUM | Customer Evaluation Table: Sales per Date | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
136 | /BEV3/CHKAW_TEXT | Customer Evaluation Table: Text | 6 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
137 | /BEV3/CHNODES | Structure of Contract Tree | 12 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
138 | /BEV3/CHREPPARM | CH: General Parameter Table for Reports (CDP) | 8 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
139 | /BEV3/CHRESSTZ_P | CH Settlement Items - Reset Documents (2/Transaction) | 13 | RI | Rule Identifier - Contract Called | nvarchar | 6 | 0 | | |
140 | /BEV3/CHSHTSTZ_P | CH Settlement Item | 13 | RI | Rule Identifier - Contract Called | nvarchar | 6 | 0 | | |
141 | /BEV3/CHSIMBDMDH | CH simulation history of modifications caused by conditions | 14 | RI | Rule Identifier - Contract Called | nvarchar | 6 | 0 | | |
142 | /BEV3/CHSIMSTZ_P | CH Simulation Items | 13 | RI | Rule Identifier - Contract Called | nvarchar | 6 | 0 | | |
143 | /BEV3/CHSIMSTZ_S | CH Simulation Statistics | 14 | RI | Rule Identifier - Contract Called | nvarchar | 6 | 0 | | |
144 | /BEV3/CHTBTEXT | Agreement Text | 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
145 | /BEV3/CHTMP0200 | Link Type 0200 Temporary Data from Settlement | 12 | RI | Rule Identifier | nvarchar | 6 | 0 | | |
146 | /BEV3/CHTMPMDHST | Temp. history of cond. modifications from temp. settle. item | 14 | RI | Rule Identifier - Contract Called | nvarchar | 6 | 0 | | |
147 | /BEV3/CHTRMSTZ_P | CH Date Item | 13 | RI | Rule Identifier - Contract Called | nvarchar | 6 | 0 | | |
148 | /BEV3/CHTRMSTZ_S | CH Date Statistics | 14 | RI | Rule Identifier - Contract Called | nvarchar | 6 | 0 | | |
149 | /BEV3/CHVABRSTZS | CH Settlement Statistics | 14 | RI | Rule Identifier - Contract Called | nvarchar | 6 | 0 | | |