| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CE1PR22 | Périm. résultat IDES | 4 | VERSI | Version de pré-budget (CO-PA) | nvarchar | 3 | 0 | | |
2 | CE2PR22 | Périm. résultat IDES | 4 | VERSI | Version de pré-budget (CO-PA) | nvarchar | 3 | 0 | | |
3 | CE3PR22 | Périm. résultat IDES | 6 | VERSI | Version de pré-budget (CO-PA) | nvarchar | 3 | 0 | | |
4 | CNVTDMS_05_CE1 | Collected Header Object Numbers for TDMS_Time-CE Tables | 5 | VERSI | VERSI | nvarchar | 3 | 0 | | |
5 | CNVTDMS_05_CE3 | Collected Header Object Numbers for TDMS_Time-CE Tables | 7 | VERSI | VERSI | nvarchar | 3 | 0 | | |
6 | CNVTDMS_05_CE3X | Collected Header Object Numbers for TDMS_Time-CE Tables | 6 | VERSI | VERSI | nvarchar | 3 | 0 | | |
7 | T138A | Fields for Mass Change: Material Master Records | 1 | VERSI | Version number | nvarchar | 2 | 0 | | |
8 | T138C | Individual Transaction Code for Mass Change | 3 | VERSI | Version number | nvarchar | 2 | 0 | | |
9 | T138V | Versions for Mass Change: Material Master Records | 1 | VERSI | Version number | nvarchar | 2 | 0 | | |
10 | T258A | Determining the costing sheet for condition access | 5 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
11 | T258F | CO-PA access control for Product Costing | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
12 | T5C1S | Withholding Tax Rates (CH) | 3 | VERSI | Tax Table Version | nvarchar | 1 | 0 | | |
13 | T77PADKZLNGVER | Language to version connection | 3 | VERSI | Version ID for International Addresses | nvarchar | 1 | 0 | | |
14 | TKEVS | CO-PA version attributes | 2 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
15 | TKKAS_CONV | Copy of TKKAS | 18 | VERSI | Plan Version for Simulation | nvarchar | 3 | 0 | | |
TOPAppropriation Requests |
16 | IMAVZ | Assignment of approp. request variants to plan versions | 4 | VERSI | Version | nvarchar | 3 | 0 | | |
TOPClasses |
17 | KLAH | Class Header Data | 31 | VERSI | Version Number | nvarchar | 2 | 0 | | |
TOPContract Billing |
18 | TE537 | Mass simulation periods | 9 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
TOPCost Object |
19 | TKKAS | Control Table for Results Analysis | 18 | VERSI | Plan Version for Simulation | nvarchar | 3 | 0 | | |
20 | TKKAU | Results Analysis Methods - Default Values in TKKAS | 14 | VERSI | Plan Version for Simulation | nvarchar | 3 | 0 | | |
TOPEnvironment |
21 | LKLAH | Class Header (Special Objects) | 31 | VERSI | Version Number | nvarchar | 2 | 0 | | |
TOPFree goods |
22 | FGDC_COND_P | Free Goods Procedures | 4 | VERSI | Version Number of Free Goods Procedure | nvarchar | 6 | 0 | | |
TOPGlobal Trade Services |
23 | /SAPSLL/LEGMES | SLL: Customs Document: Messages for Each Activity | 30 | VERSI | Version Number of Message | smallint | 5 | 0 | | |
TOPInvestment Programs |
24 | TAIF2 | Plan versions per approval year and program type | 4 | VERSI | Version | nvarchar | 3 | 0 | | |
TOPLocalization |
25 | J_1BECD_HISTORY | Electronic-Accounting-File History | 15 | VERSI | Layout Version Code | nvarchar | 3 | 0 | | |
TOPMaterial |
26 | TPGPRF | Profile for static pegging and data distribution | 16 | VERSI | Version | nvarchar | 3 | 0 | | |
TOPNetherlands |
27 | PA0060 | HR Master Record: Infotype 0060 (Fiscal Data - NL) | 55 | VERSI | Version Number for Conversion of IT0060 | nvarchar | 1 | 0 | | |
TOPOverhead Cost Controlling |
28 | TKA07 | Fiscal-Year Dependent Version Parameters | 22 | VERSI | Receiver Plan Version (CO-PA) | nvarchar | 3 | 0 | | |
29 | TKVS | CO Versions | 2 | VERSI | Version | nvarchar | 3 | 0 | | |
TOPPayroll |
30 | T7ROG8 | EE register - Bonus History | 9 | VERSI | | nvarchar | 8 | 0 | | |
TOPPegging, Grouping, and Distribution |
31 | DIS_ADMIN | Distribution - Administration Table | 19 | VERSI | Version | nvarchar | 3 | 0 | | |
32 | DIS_PGPRF | Distribution: Assignemnt Distribution Profile - Group WBSEl. | 17 | VERSI | Version | nvarchar | 3 | 0 | | |
33 | PEG_DIS_ADMIN | Pegging and Distribution - administration table | 37 | VERSI | Version | nvarchar | 3 | 0 | | |
TOPPricing |
34 | PRCC_COND_PP | Pricing Procedure Data (T683S) | 4 | VERSI | Version Number of Pricing Procedure | nvarchar | 6 | 0 | | |
35 | PRCC_COND_PPT | Texts for Line in Pricing Procedure (T683T) | 5 | VERSI | Version Number of Pricing Procedure | nvarchar | 6 | 0 | | |
TOPProduct Safety |
36 | TCGRULPOSMREST | EHS: Easy Expert Set of Rules, Characteristic Restrictions | 35 | VERSI | Version Number | nvarchar | 2 | 0 | | |
TOPProfitability Analysis |
37 | CE18500 | | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
38 | CE1BGIS | Ergebnisbereich für | 4 | VERSI | Planversion (CO-PA) | nvarchar | 3 | 0 | | |
39 | CE1E_B1 | Model Bank | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
40 | CE1IDEA | Op. Concern BR World | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
41 | CE1IDEB | Ergebnisbereich IDES | 4 | VERSI | Planversion (CO-PA) | nvarchar | 3 | 0 | | |
42 | CE1IDES | Ergebnisbereich IDES | 4 | VERSI | Planversion (CO-PA) | nvarchar | 3 | 0 | | |
43 | CE1INT1 | Ergebnisbereich IDES | 4 | VERSI | Planversion (CO-PA) | nvarchar | 3 | 0 | | |
44 | CE1OC01 | Bike International | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
45 | CE1R300 | Operating Concern IDES | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
46 | CE1S001 | Sample operating concern | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
47 | CE1S300 | Operating Concern IDES | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
48 | CE1S_AL | Airline Route Profit | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
49 | CE1S_CP | Template for Consumer Goods Industry | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
50 | CE1S_GO | Quickstart Template | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
51 | CE28500 | | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
52 | CE2BGIS | Ergebnisbereich für | 4 | VERSI | Planversion (CO-PA) | nvarchar | 3 | 0 | | |
53 | CE2E_B1 | Model Bank | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
54 | CE2IDEA | Op. Concern BR World | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
55 | CE2IDEB | Ergebnisbereich IDES | 4 | VERSI | Planversion (CO-PA) | nvarchar | 3 | 0 | | |
56 | CE2IDES | Ergebnisbereich IDES | 4 | VERSI | Planversion (CO-PA) | nvarchar | 3 | 0 | | |
57 | CE2INT1 | Ergebnisbereich IDES | 4 | VERSI | Planversion (CO-PA) | nvarchar | 3 | 0 | | |
58 | CE2OC01 | Bike International | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
59 | CE2R300 | Operating Concern IDES | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
60 | CE2S001 | Sample operating concern | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
61 | CE2S300 | Operating Concern IDES | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
62 | CE2S_AL | Airline Route Profit | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
63 | CE2S_CP | Template for Consumer Goods Industry | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
64 | CE2S_GO | Quickstart Template | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
65 | CE38500 | | 6 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
66 | CE3BGIS | Ergebnisbereich für | 6 | VERSI | Planversion (CO-PA) | nvarchar | 3 | 0 | | |
67 | CE3E_B1 | Model Bank | 6 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
68 | CE3IDEA | Op. Concern BR World | 6 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
69 | CE3IDEB | Ergebnisbereich IDES | 6 | VERSI | Planversion (CO-PA) | nvarchar | 3 | 0 | | |
70 | CE3IDES | Ergebnisbereich IDES | 6 | VERSI | Planversion (CO-PA) | nvarchar | 3 | 0 | | |
71 | CE3INT1 | Ergebnisbereich IDES | 6 | VERSI | Planversion (CO-PA) | nvarchar | 3 | 0 | | |
72 | CE3OC01 | Bike International | 6 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
73 | CE3R300 | Operating Concern IDES | 6 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
74 | CE3S001 | Segment level (CO-PA) | 6 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
75 | CE3S300 | Operating Concern IDES | 6 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
76 | CE3S_AL | Airline Route Profit | 6 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
77 | CE3S_CP | Template for Consumer Goods Industry | 6 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
78 | CE3S_GO | Quickstart Template | 6 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
79 | CEALE01 | CO-PA Distribution: Line Item Reference for Distribution | 9 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
80 | TKEHDB_CE1_ERR | HANA CO-PA Integration: CE1 Error with HANA Replication | 5 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
81 | TKEHDB_CE2_ERR | HANA CO-PA Integration: CE2 Error with HANA Replication | 5 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
82 | TKEPSV | CO-PA: Plan Structure Status Management | 5 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
83 | TKEVA01 | Valuation - Control | 5 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
84 | TKEVA01N | Valuation - Control | 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
85 | TKEVA03A | Costing Key for Product | 5 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
86 | TKEVA03M | Costing Key for Material Type | 5 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
87 | TKVST | CO Version Texts | 3 | VERSI | Version | nvarchar | 3 | 0 | | |
TOPProfitability Analysis Basic Functions |
88 | K810001 | Verdichtungsebene KT: 800 KE 01 CE1IDEA 000310 | 5 | VERSI | Planversion (CO-PA) | nvarchar | 3 | 0 | | |
89 | K810003 | Verdichtungsebene KT: 800 KE 01 CE1IDEA 000311 | 9 | VERSI | Planversion (CO-PA) | nvarchar | 3 | 0 | | |
90 | K810005 | Verdichtungsebene KT: 800 KE 01 CE1IDEA 000313 | 7 | VERSI | Planversion (CO-PA) | nvarchar | 3 | 0 | | |
91 | K810007 | Verdichtungsebene KT: 800 KE 01 CE1IDEA 000314 | 5 | VERSI | Planversion (CO-PA) | nvarchar | 3 | 0 | | |
TOPSwitzerland |
92 | T5C2O | Conversion of Residence Status for Vaud | 2 | VERSI | Version Number of Notification Format | nvarchar | 4 | 0 | | |
93 | T5C2O_CHILD | EMP-ACI: No. of Children | 2 | VERSI | Version Number of Notification Format | nvarchar | 4 | 0 | | |
94 | T5C2O_FAMST | EMP-ACI: Assignment of Marital Status to Event | 2 | VERSI | Version Number of Notification Format | nvarchar | 4 | 0 | | |
95 | T5C2O_SCALE | EMP-ACI: Conversion of Scale Names for File | 2 | VERSI | Version Number of Notification Format | nvarchar | 4 | 0 | | |
96 | T5C2P | WHT Geneva: Conversion of Pay Scale Indicator | 2 | VERSI | GeTIS and ISEL Version | nvarchar | 4 | 0 | | |
97 | T5C2P_FAMST | WHT Geneva: Conversion of Marital Status from Infotype 0002 | 2 | VERSI | GeTIS and ISEL Version | nvarchar | 4 | 0 | | |
98 | T5C2P_KONFE | WHT GE: Assignment of Religion Key for File | 2 | VERSI | GeTIS and ISEL Version | nvarchar | 4 | 0 | | |
99 | T5C2P_STREET | Withholding Tax for Geneva: Street Name Conversion | 2 | VERSI | GeTIS and ISEL Version | nvarchar | 4 | 0 | | |
TOPTransaction Data Pool |
100 | JBDVTLD_POS | Variable Transaction: Ledger Item | 11 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | | |
TOPTransaction Tax Engine |
101 | TTE2C_TAX_MAP | Mapping between Tax Type and Procedure | 4 | VERSI | Version Number of Pricing Procedure | nvarchar | 6 | 0 | | |
TOPUnited Kingdom |
102 | T5G35F | P35: XML tag structure | 1 | VERSI | Payroll Year | nvarchar | 4 | 0 | | |