| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_05_CKMLH | Collect Table for Material Ledger | 3 | KALNR | BEDID for CNVTDMS_05_* | nvarchar | 12 | 0 | | |
2 | MLAUFCRH | History table for summerized MLAUFCR data | 7 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
3 | MLAUFH | History table for summarized MLAUF data | 7 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
4 | MLAUFKEPHH | History table for summarized MLAUFKEPH data | 7 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
5 | ZEIM_AFPO | Order item | 28 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
6 | ZEIM_VBAP | Sales Document: Item Data | 162 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPActual CostingMaterial Ledger |
7 | CKMI1 | Index for Accounting Documents for Material | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
8 | CKML1 | Material Ledger Period Totals Records (Release 3.xx) | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
9 | CKML2 | Material Ledger Header Record (Release 3.xx) | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
10 | CKMLAGGREGATE | Aggregation Classes | 3 | KALNR | Cost Estimate Number - Product Costing | nvarchar | 12 | 0 | | |
11 | CKMLCR | Material Ledger: Period Totals Records Values | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
12 | CKMLCRWIP | Material Ledger: WIP Period Records (Values) | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
13 | CKMLDUVCO | Usage Differences for Each Account Assignment Object | 16 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
14 | CKMLHD | Material Ledger: Header Record | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
15 | CKMLKALNR | Material Ledger: Cost Estimate Number Control | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
16 | CKMLKEKO | Material Ledger: Cost Component Split (Header) | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
17 | CKMLKEPH | Material Ledger: Cost Component Split (Elements) | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
18 | CKMLLACR | ML Activity Type: Period Record/Currency Record | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
19 | CKMLLACRWIP | ML Activity Types: Period/ Currency Records WIP (Values) | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
20 | CKMLLAHD | ML Activity Types: Header Record | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
21 | CKMLLAPP | ML Activity Types: Period Records | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
22 | CKMLLAPPWIP | Ml Activity Types: Period Records WIP (Quantities) | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
23 | CKMLMV001 | Procurement alternatives | 2 | KALNR | Procurement alternative/process | nvarchar | 12 | 0 | | |
24 | CKMLMV001T | Texts for procurement alternatives | 2 | KALNR | Procurement alternative/process | nvarchar | 12 | 0 | | |
25 | CKMLMV005 | Consumption alternatives | 2 | KALNR | Consumption alternative | nvarchar | 12 | 0 | | |
26 | CKMLMV005T | Texts for consumption alternatives | 2 | KALNR | Procurement alternative/process | nvarchar | 12 | 0 | | |
27 | CKMLMV011 | Costing run: Object list | 3 | KALNR | Cost Estimate Number - Product Costing | nvarchar | 12 | 0 | | |
28 | CKMLMV012 | Costing run: Predecessor/successor model | 4 | KALNR | Cost Estimate Number - Product Costing | nvarchar | 12 | 0 | | |
29 | CKMLMV_AUX_KALNR | Cost Estimate Numbers for Valuated Objects in QST | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
30 | CKMLMYMP | Periodic Receipt Values for Consumption Sequence Procedure | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
31 | CKMLPP | Material Ledger Period Totals Records Quantity | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
32 | CKMLPPWIP | Material-Ledger: Period Records WIP (Quantities) | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
33 | CKMLPR | Material Ledger: Prices | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
34 | CKMLPRKEKO | Material Ledger: Cost Component Split (Header) for Prices | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
35 | CKMLPRKEPH | Material Ledger: Cost Component Split (Elements) for Prices | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
36 | CKMLPR_EB | Prices for Ending Inventory/Balance Sheet Valuation | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
37 | CKMVFM_OUT | Output for the Value_Flow_Monitor, see SAP Note 912984 | 3 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
38 | FCML_ALT | Alternatives | 2 | KALNR | Procurement alternative/process | nvarchar | 12 | 0 | | |
39 | FCML_MAT | ML Characteristics for Material (Selection Criteria) | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
40 | FCML_PROC | Business Processes | 2 | KALNR | Procurement alternative/process | nvarchar | 12 | 0 | | |
41 | MLAUF | Material Ledger Item Table for Order History | 7 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
42 | MLAUFCR | Material Ledger Currency Table for Order History | 7 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
43 | MLAUFKEPH | ML: Cost Component Split (Components) for Order History | 7 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
44 | MLBE | Material Ledger FS Item Table for GR/IR relevant transaction | 11 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
45 | MLBEH | Material Ledger FS Item Table for GR/IR relevant transaction | 11 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
46 | MLCD | Material Ledger: Summarization Record (from Documents) | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
47 | MLIT | Material Ledger Document: Items | 9 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
48 | MLWIPIT | WIP Document in Material Ledger - Lines | 4 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPAppropriation Requests |
49 | IMAV | Appropriation request variant | 25 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
50 | IMAVC | Calculations Copied from Variants to WBS Elements | 5 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPBalance Sheet Valuation Procedures |
51 | MYABK | Bal. Sheet Valuation: Table of Database Commits Carried Out | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPConsumer Products for Food Beverage |
52 | CFB_VERID_MRP | Release/Lock Production Version for Mat. Req. Planning | 6 | KALNR | Cost Estimate Number - Product Costing | nvarchar | 12 | 0 | | |
TOPCosting |
53 | PRECP2 | ECP: Subobjects, KLVAR/KALNR | 5 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPCross-Application Components |
54 | VVBAP | Sales Document: Item Data | 162 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPCustomer Bill of Services |
55 | ADBOS_ECP_CKIS | BOS: Enhancement to Detailed Statement | 3 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPDistribution of Usage Variances |
56 | CKMLDUVACTCO | Distribution Acty Differences: Diff. Per Acct Assgnmt object | 25 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
57 | CKMLDUVNCO | Usage Differences for Each Account Assignment Object | 16 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPExternal Services |
58 | ESLL | Lines of Service Package | 96 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPFunds Management |
59 | BPEG | Line Item Overall Values Controlling Obj. | 6 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
60 | BPEJ | Line Item Annual Values Controlling Obj. | 6 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
61 | BPGE | Totals Record for Total Value Controlling obj. | 17 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
62 | BPJA | Totals Record for Annual Total Controlling Obj. | 19 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPIndustry Solution Catch Weight Management |
63 | /FMP/D_MP_HIST | Material Price History | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
64 | /FMP/D_MP_PRIC | Material Prices | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPInventory Management |
65 | MWXVM07M | Fields: Update Control of Module Pool SAPMM07M | 156 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
66 | MWZVM07M | Fields: Update Control of Module Pool SAPMM07M | 156 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPLocal Currency Changeover |
67 | EWUCOKAL | Exception table for conversion of TWAER in detailed planning | 3 | KALNR | Cost Estimate Number | nvarchar | 12 | 0 | | |
TOPLocalization |
68 | J_1AINFINV | Inflation: Invoices for Replacement Value Determination | 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPMaintenance Notifications |
69 | QMEL | Quality Notification | 136 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPMaterial |
70 | RSADD | Additional fields for reservation | 11 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPMaterial Master |
71 | MBEW | Material Valuation | 67 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
72 | MBEW_TMP | File for Incorrect Data in Direct Input | 70 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
73 | MVEW | Material Valuation | 67 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPOperative Structures |
74 | PRPS | WBS (Work Breakdown Structure) Element Master Data | 94 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPOverhead Cost Controlling |
75 | COKL | CO Object: Control Data for Activity Types | 31 | KALNR | Cost Estimate Number | nvarchar | 12 | 0 | | |
76 | COKP | CO Object: Control Data for Primary Planning | 37 | KALNR | Cost Estimate Number | nvarchar | 12 | 0 | | |
77 | COKR | CO Object: Control Data for Statistical Key Figures | 18 | KALNR | Cost Estimate Number | nvarchar | 12 | 0 | | |
78 | COKS | CO Object: Control Data for Secondary Planning | 31 | KALNR | Cost Estimate Number | nvarchar | 12 | 0 | | |
TOPPegging, Grouping, and Distribution |
79 | TBLP | Transfer/Loan data log table | 34 | KALNR | Cost Estimate Number - Product Costing | nvarchar | 12 | 0 | | |
TOPProduct Cost by Period |
80 | CKPH | Master Record: Cost Object ID Number | 33 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPProduct Cost Planning |
81 | CKBS | Base Planning Object - Unit Costing | 51 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
82 | CKHS | Header: Unit Costing (Control + Totals) | 4 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
83 | CKHT | Texts for CKHS | 4 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
84 | CKIP | Unit Costing: Period Costs Line Item | 4 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
85 | CKIS | Items Unit Costing/Itemization Product Costing | 4 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
86 | CKIS_CC | Itemization: Additional Data - Concurrent Costing | 3 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
87 | CKIT | Texts for CKIS | 4 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
88 | CKKS | Header: Unit Costing (Control + Totals) | 3 | KALNR | Cost Estimate Number (Unit Costing) | nvarchar | 8 | 0 | | |
89 | CKKT | Texts for CKKS | 3 | KALNR | Cost Estimate Number (Unit Costing) | nvarchar | 8 | 0 | | |
90 | CKPP | Periodic Values for Unit Costing Item | 3 | KALNR | Cost Estimate Number (Unit Costing) | nvarchar | 8 | 0 | | |
91 | CKPS | Unit Costing Items | 3 | KALNR | Cost Estimate Number (Unit Costing) | nvarchar | 8 | 0 | | |
92 | CKPT | Texts for CKPS | 3 | KALNR | Cost Estimate Number (Unit Costing) | nvarchar | 8 | 0 | | |
93 | CKTC_KALNR | Database Table for Costing Numbers | 7 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
94 | KALM | Costing Run: Costing Objects | 11 | KALNR | Cost Estimate Number - Product Costing | nvarchar | 12 | 0 | | |
95 | KALO | Costing Run: Costing Objects (KVMK) | 33 | KALNR | Cost Estimate Number - Product Costing | nvarchar | 12 | 0 | | |
96 | KEKO | Product Costing - Header Data | 3 | KALNR | Cost Estimate Number - Product Costing | nvarchar | 12 | 0 | | |
97 | KEKO_CC | Additional Data for Concurrent Costing | 3 | KALNR | Cost Estimate Number - Product Costing | nvarchar | 12 | 0 | | |
98 | KEPH | Product Costing: Cost Components for Cost of Goods Mfd | 3 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
99 | KNKO | Assignment of Cost Est. Number to Config. Object | 4 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
100 | KNOB | Assignment of Cost Est. Number to Config. Object | 6 | KALNR | Cost Estimate Number - Product Costing | nvarchar | 12 | 0 | | |
TOPProduction Orders |
101 | AFPO | Order item | 28 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
102 | AFVC | Operation within an order | 164 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
103 | /BEV1/RBVBAP | Sales Document: Item Data | 162 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPRevenues and Earnings |
104 | VPKSDITEM | Sales Pricing Header Data (Specific to SD) | 7 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPSales |
105 | VBAP | Sales Document: Item Data | 162 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
TOPSimulation |
106 | VSAFPO_CN | Version: Order items in PP orders | 29 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
107 | VSAFVC_CN | Version: Operation in order | 165 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
108 | VSPRPS_CN | Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data | 95 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
109 | VSRSADD_CN | Version: Additional fields for reservation | 12 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |
110 | VSVBAP_CN | Version: Sales document: Item data | 163 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | |