| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMD/MD_____0057 | SID-Tabelle fuer Exchange rate difference key | 5 | CURTP | Valuation Area for FI Year-End Closing | nvarchar | 2 | 0 | | |
2 | CNVA_PCREA_AA_R | LT PC Reorg Analysis: Asset Reconciliation results (Level 1) | 8 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
3 | CNVA_PCREA_WIP_R | LT PC Reorg Analysis: WIP Reconciliation results (Level 1) | 12 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
4 | CNV_10510_FCVMAP | Mappingtable for conversion of foreign currencies | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
5 | CNV_40305_POST_A | Aggregated amount to be reposted | 14 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
6 | CNV_40305_SIM_PA | Aggregated amount to be reposted | 15 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
7 | DFKKFWKORRN | Cumul. Table for Adjustment and Inverse Postings (New) | 4 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
8 | DFKK_ACCADJ | Adjustment Postings when Implementing Acct Assgmt Chars | 23 | CURTP | Currency Type And Valuation View | nvarchar | 2 | 0 | | |
9 | DFKK_NEWACCADJ | Obsolete: See DFKK_ACCADJ | 23 | CURTP | Currency Type And Valuation View | nvarchar | 2 | 0 | | |
10 | FAGL_BSBW_HISTLG | Valuation History of Ledger-Group-Specific Items | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
11 | FAGL_ORG_INFC_CT | Class. General Ledger: Configuration Information (Crcy Type) | 3 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
12 | FAGL_ORG_INFO_CT | New General Ledger: Configuration Information (Crcy Type) | 4 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
13 | GLPCA_CT | Profit Center Documents | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
14 | GLPCA_T_CT | Profit Center Documents | 22 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
15 | GLPOS_C_CT | FI Document: Entry View | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
16 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
17 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
18 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
19 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
20 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
21 | MLAUFCRH | History table for summerized MLAUFCR data | 9 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
22 | MLAUFKEPHH | History table for summarized MLAUFKEPH data | 14 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
23 | T030H | Acct Determ.for Open Item Exch.Rate Differences | 5 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
24 | T030S | Accts for Foreign Currency Assets Exchange Rate Differences | 4 | CURTP | Valuation Area for FI Year-End Closing | nvarchar | 2 | 0 | | |
25 | TBKOW | Valuation Difference Temporary Storage | 3 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
TOPAccounting Interface |
26 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 434 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
27 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 434 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
TOPActual CostingMaterial Ledger |
28 | CKMLCR | Material Ledger: Period Totals Records Values | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
29 | CKMLCRWIP | Material Ledger: WIP Period Records (Values) | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
30 | CKMLCT | Currency Types and Valuation Types in a Valuation Area | 3 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
31 | CKMLCUR | Text for currency type and valuation type | 3 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
32 | CKMLKEPH | Material Ledger: Cost Component Split (Elements) | 14 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
33 | CKMLKEV | Material Ledger: Cost Component Split (Control Record) | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
34 | CKMLLACR | ML Activity Type: Period Record/Currency Record | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
35 | CKMLLACRWIP | ML Activity Types: Period/ Currency Records WIP (Values) | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
36 | CKMLMYMP | Periodic Receipt Values for Consumption Sequence Procedure | 8 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
37 | CKMLPR | Material Ledger: Prices | 3 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
38 | CKMLPRKEKO | Material Ledger: Cost Component Split (Header) for Prices | 7 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
39 | CKMLPRKEPH | Material Ledger: Cost Component Split (Elements) for Prices | 11 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
40 | CKMLPR_EB | Prices for Ending Inventory/Balance Sheet Valuation | 7 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
41 | CKMLRUNPERIOD | Material ledger costing run for one month | 29 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
42 | CKMVFM_OUT | Output for the Value_Flow_Monitor, see SAP Note 912984 | 4 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
43 | FCML_CCS_REP | HDB Reporting Structure for ML | 16 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
44 | FCML_REP | ML Reporting Structure | 13 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
45 | MLAUFCR | Material Ledger Currency Table for Order History | 8 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
46 | MLAUFKEPH | ML: Cost Component Split (Components) for Order History | 13 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
47 | MLBECR | Material Ledger Currency Table for GR/IR relevant transact. | 7 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
48 | MLBECRH | Material Ledger Currency Table for GR/IR relevant transact. | 7 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
49 | MLBEKEPH | ML: Cost Comp. Split (Elements) for Purchase Order History | 12 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
50 | MLCD | Material Ledger: Summarization Record (from Documents) | 9 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
51 | MLCR | Material Ledger Document: Currencies and Values | 7 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
52 | MLCRF | Material Ledger Document: Field Groups (Currencies) | 7 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
53 | MLCRP | Material Ledger Document: Price Changes (Currencies, Prices) | 7 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
54 | MLKEPH | ML Document: Cost Component Split (Elements) for Values | 12 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
55 | MLPRKEKO | ML Document: Cost Component Split (Header)for Prices | 8 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
56 | MLPRKEPH | ML Document: Cost Component Split (Components)for Prices | 12 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
57 | TCKMLBNKSZ | Assignment of Delivery Costs Structure | 2 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
58 | TMLCCSCR | Act.Cost Comp. Split: Data Range in Valuation Area (Curr) | 3 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
TOPAlternative Valuation Run |
59 | CKMLAVRDOCCR | Cumulation Posting Document: Currency Information | 5 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
60 | CKMLRUNSCALE | Re-scaling Amounts in the AVR | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
TOPBalance Sheet Valuation Procedures |
61 | MYML1V | LIFO: Transaction-Related Material Layer (Values) | 8 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
TOPBasic Functions |
62 | T093A | Real depreciation area | 17 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
63 | T881_KEYFIG | FI-SL: Key Figures per Ledger | 4 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
TOPContract Accounts Receivable and Payable |
64 | DFKKFWBEW | Management Data for Foreign Currency Valuations | 4 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
65 | DFKKFWBEW_LD | Management Data for Ledger-Specific Foreign Crcy Valuations | 5 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
66 | DFKKFWKORR | Cumulation Table for Adjustment and Inverse Postings | 3 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
67 | DFKKOPBEW | FI-CA Foreign Currency Valuation | 5 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
68 | DFKKOPBEW_LD | FI-CA Ledger-Specific Foreign Currency Valuation | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
69 | DFKK_DUEGRID | OI - Reclassifications | 28 | CURTP | Currency Type And Valuation View | nvarchar | 2 | 0 | | |
70 | DFKK_RECLASS | OI - Reclassifications | 22 | CURTP | Currency Type And Valuation View | nvarchar | 2 | 0 | | |
71 | TFK020VB | FS Preparation: Summarization Co. Codes for Reclassification | 2 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
72 | TFK044D | FI-CA Company Code Valuation | 5 | CURTP | Currency Type And Valuation View | nvarchar | 2 | 0 | | |
TOPCustomer Bill of Services |
73 | ADBOS_ECP_CKIS | BOS: Enhancement to Detailed Statement | 10 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
TOPData Transfer |
74 | PPDIT | Transfer to Accounting: Lines in HR IDOCs | 34 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
75 | PPDST | Transfer to Accounting: Substituted Acc. Assig. Object | 19 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
TOPFinancial Accounting |
76 | ACCTCR | Compressed Data from FI/CO Document - Currencies | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
77 | BSBM | Document Valuation Fields | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
78 | BSBMT | Text for Valuation Adjustment or Deductible per Item | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
79 | BSBW | Document Valuation Fields | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
80 | F107_TPROV | Provisions | 5 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
81 | SLPB | Log Table for Valuation | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
82 | T001A | Additional Local Currencies Control for Company Code | 3 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
83 | T033 | FI Depreciation Area | 3 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
84 | T044HT | Flat-rate Value Adjustment of Individual Documents (Text) | 7 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
TOPFunds Management |
85 | KBLEW | Item development amounts in various currencies | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
86 | KBLPW | Document item amounts in different currencies | 5 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
TOPGeneral Ledger Accounting |
87 | FAGL_BSBW_HISTRY | Valuation History for Documents | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
88 | FAGL_BSBW_HST_BL | Valuation History of Balances | 5 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
89 | FAGL_SPLINFO_VAL | Splitting Information of Open Item Values | 7 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
TOPGeneral Ledger Reorganization |
90 | FAGL_R_APAR_VAL | Reorg: Values for Receivables and Payables Object List | 13 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
91 | FAGL_R_BLNCE_VAL | Reorganization: Balances to Be Transferred - Values | 14 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
92 | FAGL_R_SPL_VAL | Reorganization: Splitting Information of Open Item Values | 7 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
TOPIndustry Solution Catch Weight Management |
93 | /FMP/D_MP_HIST | Material Price History | 5 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
94 | /FMP/D_MP_PRIC | Material Prices | 5 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
TOPInformation System |
95 | BWKS | Accounts Blocked by Valuation Selection | 5 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
96 | T044J | Preference Key for Reading Valuation Results | 4 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
TOPLocal Currency Changeover |
97 | EWUCKMLW | EMU: Currencies for material ledger | 4 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
98 | EWUFIAASUM | EWU conversion: Table for asset totals at account level | 8 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
99 | EWUMMFI | EMU: transfer table for clearing entries MM-FI | 7 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
TOPMulti Currency Accounting |
100 | GLE_MCA_RV_HSTRY | FX Revaluation History | 7 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
101 | GLE_MCA_T030H | GLE MCA Accounts Table | 7 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
TOPProduct Cost Planning |
102 | TCK27 | Cost Component Split in Different Currency | 6 | CURTP | Currency Type for Controlling Area | nvarchar | 2 | 0 | | |
TOPProfitability Analysis |
103 | TKECHACOAD | Change of KOKRS/ERKRS Assignments: Administration | 17 | CURTP | Exchange Rate Type | nvarchar | 4 | 0 | | |
104 | TKEL | CO-PA ledger | 3 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
TOPTechnical Application Support |
105 | CNV_20425_AASUM | EWU conversion: Table for asset totals at account level | 7 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
TOPTransfer Prices and Decentralized Responsibility |
106 | KFPEW | Clearing Amounts in Various Currencies | 7 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
107 | KFPPW | Document Item Amounts in Different Currencies | 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
TOPTravel Expenses |
108 | PTRV_DOC_IT | Transfer Travel -> FI/CO: Lines of TRV interm. document | 36 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
109 | PTRV_DOC_TAX | Transfer Travel -> FI/CO: Tax lines of TRV document | 13 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | |
TOPTreasury |
110 | FLQCLNT | Liquidity Calculation - Global Settings | 10 | CURTP | Liquidity Calculation: Currency Type for Third Currency | nvarchar | 2 | 0 | | |
111 | FLQCOMPANY | Liquidity Calculation - Company Codes | 5 | CURTP | Liquidity Calculation: Currency Type for Third Currency | nvarchar | 2 | 0 | | |