| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_05_CKMLH | Collect Table for Material Ledger | 4 | BDATJ | Fiscal Year | nvarchar | 4 | 0 | | |
2 | MLAUFH | History table for summarized MLAUF data | 12 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
3 | RSDHA_009B | Fiscal year variant periods | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
4 | T009B | Fiscal year variant periods | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
5 | T009C | Period names | 5 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
TOPActual CostingMaterial Ledger |
6 | CKMI1 | Index for Accounting Documents for Material | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
7 | CKML1 | Material Ledger Period Totals Records (Release 3.xx) | 4 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
8 | CKMLCR | Material Ledger: Period Totals Records Values | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
9 | CKMLCRWIP | Material Ledger: WIP Period Records (Values) | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
10 | CKMLKEKO | Material Ledger: Cost Component Split (Header) | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
11 | CKMLKEPH | Material Ledger: Cost Component Split (Elements) | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
12 | CKMLKEV | Material Ledger: Cost Component Split (Control Record) | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
13 | CKMLLACR | ML Activity Type: Period Record/Currency Record | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
14 | CKMLLACRWIP | ML Activity Types: Period/ Currency Records WIP (Values) | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
15 | CKMLLAPP | ML Activity Types: Period Records | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
16 | CKMLLAPPWIP | Ml Activity Types: Period Records WIP (Quantities) | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
17 | CKMLMYMP | Periodic Receipt Values for Consumption Sequence Procedure | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
18 | CKMLO | Material Ledger: Organizational Jobs | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
19 | CKMLPP | Material Ledger Period Totals Records Quantity | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
20 | CKMLPPWIP | Material-Ledger: Period Records WIP (Quantities) | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
21 | CKMLPRKEKO | Material Ledger: Cost Component Split (Header) for Prices | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
22 | CKMLPRKEPH | Material Ledger: Cost Component Split (Elements) for Prices | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
23 | CKMLPR_EB | Prices for Ending Inventory/Balance Sheet Valuation | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
24 | CKMVFM_EXTRACT | Transaction CKMVFM, Extracts, see SAP Note 912984 | 8 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
25 | CKMVFM_OUT | Output for the Value_Flow_Monitor, see SAP Note 912984 | 8 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
26 | FCML_CCS_REP | HDB Reporting Structure for ML | 4 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
27 | FCML_REP | ML Reporting Structure | 4 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
28 | MLARC_IDX | Index for ML Document | 2 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
29 | MLAUF | Material Ledger Item Table for Order History | 11 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
30 | MLBE | Material Ledger FS Item Table for GR/IR relevant transaction | 13 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
31 | MLBEH | Material Ledger FS Item Table for GR/IR relevant transaction | 13 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
32 | MLCD | Material Ledger: Summarization Record (from Documents) | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
33 | MLCR | Material Ledger Document: Currencies and Values | 5 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
34 | MLCRF | Material Ledger Document: Field Groups (Currencies) | 5 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
35 | MLCRP | Material Ledger Document: Price Changes (Currencies, Prices) | 5 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
36 | MLKEPH | ML Document: Cost Component Split (Elements) for Values | 5 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
37 | MLPP | Material Ledger Document: Posting Periods and Quantities | 5 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
38 | MLPPF | Material Ledger Document: Field Groups (Posting Periods) | 5 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
39 | MLPRKEKO | ML Document: Cost Component Split (Header)for Prices | 5 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
40 | MLPRKEPH | ML Document: Cost Component Split (Components)for Prices | 5 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
TOPBasic Functions |
41 | T090Z | Period control for transactions | 4 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
TOPData Transfer |
42 | T51A1 | HR: Final Date for HR Postings (Accruals) | 3 | BDATJ | Fiscal Year | nvarchar | 4 | 0 | | |
TOPLocalization |
43 | J_1AINFINV | Inflation: Invoices for Replacement Value Determination | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
44 | J_1ISERUTZ | Tracking accounting docs already utilized for service tax | 9 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
TOPProduct Cost Planning |
45 | FVMK | Marking File for Release of Std Cost Est in Company Code | 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
46 | KEKO | Product Costing - Header Data | 65 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | |
TOPRegulatory reporting for insurance companies |
47 | ISSR_T009B | ISSR: Mustertabelle Perioden SR-Geschäftsjahresvariante | 3 | BDATJ | Buchungsdatum JJJJ | nvarchar | 4 | 0 | | |