| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1RA/0SD010MI | Items for Class SD01 - Raw Data | 102 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
2 | /BIC/B0000171000 | PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances | 22 | PPRCTR | | nvarchar | 10 | 0 | | |
3 | /BIC/B0000173000 | PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal. | 23 | PPRCTR | | nvarchar | 10 | 0 | | |
4 | /BIC/B0000174000 | PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs | 25 | PPRCTR | | nvarchar | 10 | 0 | | |
5 | /BIC/B0000175000 | PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q) | 25 | PPRCTR | | nvarchar | 10 | 0 | | |
6 | CE1PR22 | Périm. résultat IDES | 50 | PPRCTR | Centre de profit partenaire | nvarchar | 10 | 0 | | |
7 | CE2PR22 | Périm. résultat IDES | 38 | PPRCTR | Centre de profit partenaire | nvarchar | 10 | 0 | | |
8 | CE4PR22 | Périm. résultat IDES | 22 | PPRCTR | Centre de profit partenaire | nvarchar | 10 | 0 | | |
9 | CE4PR22_ACCT | Périm. résultat IDES | 20 | PPRCTR | Centre de profit partenaire | nvarchar | 10 | 0 | | |
10 | CE4PR22_FLAG | Périm. résultat IDES | 19 | PPRCTR | Flag : caract. imputée manuellement ou via TKEZU | nvarchar | 1 | 0 | | |
11 | CE4PR22_KENC | Périm. résultat IDES | 21 | PPRCTR | Centre de profit partenaire | nvarchar | 10 | 0 | | |
12 | FAGLFLEXC | EMU: Sum of Open Items of Table FAGLFLEXT | 32 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
13 | FAGLFLEXD | EMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT | 34 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
14 | FAGLFLEXT_BAK | General Ledger: Totals | 34 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
15 | FAGLFLEXT_DIF | Delta Table: G/L Totals | 34 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
16 | TKMGB | Business area consolidation: SD assignments | 10 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
17 | TLMGB | Business area consolidation: MM assignments | 10 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPAccounting Interface |
18 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 172 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
19 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 172 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPActual CostingMaterial Ledger |
20 | MLCO | Material valuation document account assignment information | 14 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPAlternative Valuation Run |
21 | CKMLAVRDOCIT | Lines for Cumulation Posting Document | 22 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPBasic Settings |
22 | A141 | Dependent on material and receiver profit center | 7 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPBilling |
23 | VBRP | Billing Document: Item Data | 215 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPConditions |
24 | A902 | Condition Table for Pricing A902 | 6 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
25 | A903 | Condition Table for Pricing A903 | 6 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPData Retention Tool |
26 | TXW_S_MSEG | Retrieve MSEG from archive | 43 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPElectronic Bank Statement |
27 | FEB_ACCNT_SAVE | Saving of Posting Lines for Postprocessing (Account Assign.) | 30 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
28 | FEB_ACT | Acct Assignment Templates | 30 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPFinancial Accounting |
29 | ACCTIT | Compressed Data from FI/CO Document | 65 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
30 | FBICRC003A | ICRC: Open Items Customers/Vendors: Documents | 44 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
31 | VBSEGA | Document Segment for Document Parking - Asset Database | 59 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
32 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 39 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPFunds Management-Specific Postings |
33 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 40 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
34 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 39 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPGeneral Ledger Accounting |
35 | FAGLCOFITRACE | Log of Real-Time Integration CO->FI | 19 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
36 | FAGLFLEX06 | General ledger: Sender SAP additional account assignment | 3 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
37 | FAGLFLEXA | General Ledger: Actual Line Items | 25 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
38 | FAGLFLEXP | General Ledger: Plan Line Items | 27 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
39 | FAGLFLEXT | General Ledger: Totals | 34 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
40 | FAGL_BW_LOG_TOTL | FI-GL: Log for BW Extraction: Totals Records | 26 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
41 | FAGL_QUEUE_LOG | Log of Delta Queue for Error Analysis | 24 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
42 | FAGL_SPLINFO | Splittling Information of Open Items | 15 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
43 | GLFLEX06 | General ledger: Sender SAP additional account assignment | 3 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
44 | GLFLEXA | Flexible general ledger: Actual line items | 20 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
45 | GLFLEXP | Flexible G/L: Plan line items | 20 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
46 | GLFLEXT | Flexible G/L: Totals | 26 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPGeneral Ledger Reorganization |
47 | FAGL_R_APAR | Reorganization: Object List for Receivables and Payables | 16 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
48 | FAGL_R_BLNCE | Reorganization: Balances to Be Transferred | 29 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
49 | FAGL_R_MAP_SAP | Reorganization: Object Number of the Included SAP Fields | 9 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
50 | FAGL_R_SPL | Reorganization: Splitting Information of the Open Items | 14 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPGL Account Posting |
51 | TCJ_POSITIONS | Cash Journal Document Items | 37 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPInventory Management |
52 | MSEG | Document Segment: Material | 144 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
53 | MWXMSEG | ZMSEG: Interface for Posting of Value | 144 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
54 | MWZMSEG | ZMSEG:Interface for Posting of Value | 144 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
55 | JVGLFLEX06 | General ledger: Sender SAP additional account assignment | 3 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
56 | JVGLFLEXA | General Ledger: Actual Line Items | 24 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
57 | JVGLFLEXP | General Ledger: Plan Line Items | 26 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
58 | JVGLFLEXT | General Ledger: Totals | 33 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPProfitability Analysis |
59 | CE18500 | | 50 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
60 | CE1BGIS | Ergebnisbereich für | 50 | PPRCTR | Partnerprofitcenter | nvarchar | 10 | 0 | | |
61 | CE1E_B1 | Model Bank | 50 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
62 | CE1IDEA | Op. Concern BR World | 50 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
63 | CE1IDEB | Ergebnisbereich IDES | 50 | PPRCTR | Partnerprofitcenter | nvarchar | 10 | 0 | | |
64 | CE1IDES | Ergebnisbereich IDES | 50 | PPRCTR | Partnerprofitcenter | nvarchar | 10 | 0 | | |
65 | CE1INT1 | Ergebnisbereich IDES | 50 | PPRCTR | Partnerprofitcenter | nvarchar | 10 | 0 | | |
66 | CE1OC01 | Bike International | 50 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
67 | CE1R300 | Operating Concern IDES | 50 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
68 | CE1S001 | Sample operating concern | 75 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
69 | CE1S300 | Operating Concern IDES | 50 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
70 | CE1S_AL | Airline Route Profit | 50 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
71 | CE1S_CP | Template for Consumer Goods Industry | 50 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
72 | CE1S_GO | Quickstart Template | 50 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
73 | CE28500 | | 38 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
74 | CE2BGIS | Ergebnisbereich für | 38 | PPRCTR | Partnerprofitcenter | nvarchar | 10 | 0 | | |
75 | CE2E_B1 | Model Bank | 38 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
76 | CE2IDEA | Op. Concern BR World | 38 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
77 | CE2IDEB | Ergebnisbereich IDES | 38 | PPRCTR | Partnerprofitcenter | nvarchar | 10 | 0 | | |
78 | CE2IDES | Ergebnisbereich IDES | 38 | PPRCTR | Partnerprofitcenter | nvarchar | 10 | 0 | | |
79 | CE2INT1 | Ergebnisbereich IDES | 38 | PPRCTR | Partnerprofitcenter | nvarchar | 10 | 0 | | |
80 | CE2OC01 | Bike International | 38 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
81 | CE2R300 | Operating Concern IDES | 38 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
82 | CE2S001 | Sample operating concern | 98 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
83 | CE2S300 | Operating Concern IDES | 38 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
84 | CE2S_AL | Airline Route Profit | 38 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
85 | CE2S_CP | Template for Consumer Goods Industry | 38 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
86 | CE2S_GO | Quickstart Template | 38 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
87 | CE48500 | | 22 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
88 | CE48500_ACCT | | 20 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
89 | CE48500_FLAG | | 19 | PPRCTR | Flag: Characteristic Assigned Manually or Using TKEZU | nvarchar | 1 | 0 | | |
90 | CE48500_KENC | | 21 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
91 | CE4BGIS | Ergebnisbereich für | 22 | PPRCTR | Partnerprofitcenter | nvarchar | 10 | 0 | | |
92 | CE4BGIS_ACCT | Ergebnisbereich für | 20 | PPRCTR | Partnerprofitcenter | nvarchar | 10 | 0 | | |
93 | CE4BGIS_FLAG | Ergebnisbereich für | 19 | PPRCTR | Flag: Merkmal manuell oder über TKEZU kontiert | nvarchar | 1 | 0 | | |
94 | CE4BGIS_KENC | Ergebnisbereich für | 21 | PPRCTR | Partnerprofitcenter | nvarchar | 10 | 0 | | |
95 | CE4E_B1 | Model Bank | 22 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
96 | CE4E_B1_ACCT | Model Bank | 20 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
97 | CE4E_B1_FLAG | Model Bank | 19 | PPRCTR | Flag: Characteristic Assigned Manually or Using TKEZU | nvarchar | 1 | 0 | | |
98 | CE4E_B1_KENC | Model Bank | 21 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
99 | CE4IDEA | Op. Concern BR World | 22 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
100 | CE4IDEA_ACCT | Op. Concern BR World | 20 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
101 | CE4IDEA_FLAG | Op. Concern BR World | 19 | PPRCTR | Flag: Characteristic Assigned Manually or Using TKEZU | nvarchar | 1 | 0 | | |
102 | CE4IDEA_KENC | Op. Concern BR World | 21 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
103 | CE4IDEB | Ergebnisbereich IDES | 22 | PPRCTR | Partnerprofitcenter | nvarchar | 10 | 0 | | |
104 | CE4IDEB_ACCT | Ergebnisbereich IDES | 20 | PPRCTR | Partnerprofitcenter | nvarchar | 10 | 0 | | |
105 | CE4IDEB_FLAG | Ergebnisbereich IDES Banking | 19 | PPRCTR | Flag: Merkmal manuell oder über TKEZU kontiert | nvarchar | 1 | 0 | | |
106 | CE4IDEB_KENC | Ergebnisbereich IDES | 21 | PPRCTR | Partnerprofitcenter | nvarchar | 10 | 0 | | |
107 | CE4IDES | Ergebnisbereich IDES | 22 | PPRCTR | Partnerprofitcenter | nvarchar | 10 | 0 | | |
108 | CE4IDES_ACCT | Ergebnisbereich IDES | 20 | PPRCTR | Partnerprofitcenter | nvarchar | 10 | 0 | | |
109 | CE4IDES_FLAG | Ergebnisbereich IDES | 19 | PPRCTR | Flag: Merkmal manuell oder über TKEZU kontiert | nvarchar | 1 | 0 | | |
110 | CE4IDES_KENC | Ergebnisbereich IDES | 21 | PPRCTR | Partnerprofitcenter | nvarchar | 10 | 0 | | |
111 | CE4INT1 | Ergebnisbereich IDES | 22 | PPRCTR | Partnerprofitcenter | nvarchar | 10 | 0 | | |
112 | CE4INT1_ACCT | Ergebnisbereich IDES | 20 | PPRCTR | Partnerprofitcenter | nvarchar | 10 | 0 | | |
113 | CE4INT1_FLAG | Ergebnisbereich IDES | 19 | PPRCTR | Flag: Merkmal manuell oder über TKEZU kontiert | nvarchar | 1 | 0 | | |
114 | CE4INT1_KENC | Ergebnisbereich IDES | 21 | PPRCTR | Partnerprofitcenter | nvarchar | 10 | 0 | | |
115 | CE4OC01 | Bike International | 22 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
116 | CE4OC01_ACCT | Bike International | 20 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
117 | CE4OC01_KENC | Bike International | 21 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
118 | CE4R300 | Operating Concern IDES | 22 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
119 | CE4R300_ACCT | Ergebnisbereich IDES | 20 | PPRCTR | Partnerprofitcenter | nvarchar | 10 | 0 | | |
120 | CE4R300_FLAG | Ergebnisbereich IDES | 19 | PPRCTR | Flag: Merkmal manuell oder über TKEZU kontiert | nvarchar | 1 | 0 | | |
121 | CE4R300_KENC | Operating Concern IDES | 21 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
122 | CE4S001 | Sample operating concern | 37 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
123 | CE4S001_ACCT | Sample operating con | 20 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
124 | CE4S001_FLAG | Sample Operating Concern 1 | 19 | PPRCTR | Flag: Characteristic Assigned Manually or Using TKEZU | nvarchar | 1 | 0 | | |
125 | CE4S001_KENC | Sample operating con | 36 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
126 | CE4S300 | Operating Concern IDES | 22 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
127 | CE4S300_ACCT | Operating Concern IDES | 20 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
128 | CE4S300_FLAG | Ergebnisbereich IDES Serv.Prov | 19 | PPRCTR | Flag: Merkmal manuell oder über TKEZU kontiert | nvarchar | 1 | 0 | | |
129 | CE4S300_KENC | Operating Concern IDES | 21 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
130 | CE4S_AL | Airline Route Profit | 22 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
131 | CE4S_AL_ACCT | Airline Route Profit | 20 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
132 | CE4S_AL_FLAG | Airline Route Profit | 19 | PPRCTR | Flag: Characteristic Assigned Manually or Using TKEZU | nvarchar | 1 | 0 | | |
133 | CE4S_AL_KENC | Airline Route Profit | 21 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
134 | CE4S_CP | Template for Consumer Goods Industry | 22 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
135 | CE4S_CP_ACCT | Template for Consumer Goods Industry | 20 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
136 | CE4S_CP_FLAG | Template for Consumer Goods Industry | 19 | PPRCTR | Flag: Characteristic Assigned Manually or Using TKEZU | nvarchar | 1 | 0 | | |
137 | CE4S_CP_KENC | Template for Consumer Goods Industry | 21 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
138 | CE4S_GO | Quickstart Template | 22 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
139 | CE4S_GO_ACCT | Quickstart Template | 20 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
140 | CE4S_GO_FLAG | Quickstart Template | 19 | PPRCTR | Flag: Characteristic Assigned Manually or Using TKEZU | nvarchar | 1 | 0 | | |
141 | CE4S_GO_KENC | Quickstart Template | 21 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
142 | CEST4 | Segment table (CO-PA) | 22 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
143 | GLTPC | Profit Center Accounting | 9 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPRepetitive Manufacturing |
144 | COMPMOVE | Goods Movement of Components | 239 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPRevenues and Earnings |
145 | AD01DLI | Dynamic items (DI) | 38 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPShipping |
146 | LIPSPO | LIPS Reference Data Purchase Order | 25 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |
147 | LIPSRF | LIPS Reference Data | 28 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | |