| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ATL/SMR1 | Inventory value in "hard" currency | 5 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
2 | /OPT/VIM_1ITEM_S | Document Item | 90 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
3 | /OPT/VIM_TITEM | Document Item | 90 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
4 | /SMD/MD_____00UV | SID-Tabelle fuer Valuation Area | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
5 | BSEG | Accounting Document Segment | 183 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
6 | BSIM_BAK | Secondary Index, Documents for Material | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
7 | BSSEG | Accounting Document Segment | 172 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
8 | CNV_20000_RSEG | Backup copy of RSEG (line item for incoming invoice) | 5 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
9 | CNV_20100_T001K | CNV backup copy for T001K | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
10 | CNV_20100_T001W | CNV backup copy for T001W | 4 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
11 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 172 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
12 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 172 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
13 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 172 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
14 | GLPCA_CT | Profit Center Documents | 56 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
15 | GLPCA_T_CT | Profit Center Documents | 72 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
16 | GLPOS_C_CT | FI Document: Entry View | 74 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
17 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 74 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
18 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 74 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
19 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 74 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
20 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 74 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
21 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 74 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
22 | MYMBEW_BUKRS | Index Table for Material Company Code | 4 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
23 | TCKM2 | Valuation Area Control Table | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
24 | TCO10 | Valuation variant for order costing | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
25 | TKA3C | Automatic Acct. Assignment: Specific Assignments | 4 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
26 | USRMM | User settings: material master | 10 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
27 | YVIM_1ITEM | Document Item | 90 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPAccounting - General |
28 | TFC_ALL_ORG | Extracted Master Data | 8 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
29 | TFC_INST_ALL_OR | Extracted Master Data | 10 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
30 | TFC_TEMPL_ALL_OR | Extracted Master Data | 10 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPAccounting Interface |
31 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 204 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
32 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 204 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPActual CostingMaterial Ledger |
33 | CKMI1 | Index for Accounting Documents for Material | 13 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
34 | CKML2 | Material Ledger Header Record (Release 3.xx) | 4 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
35 | CKMLAB02 | Material Update Structure (Assignment to Valuation Area) | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
36 | CKMLCT | Currency Types and Valuation Types in a Valuation Area | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
37 | CKMLHD | Material Ledger: Header Record | 9 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
38 | CKMLHD_AGGR | Material Ledger: Header Record | 9 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
39 | CKMLKEV | Material Ledger: Cost Component Split (Control Record) | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
40 | CKMLMV001 | Procurement alternatives | 4 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
41 | CKMLMV002 | Assignments material / procurement alternatives | 6 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
42 | CKMLMV003 | Process model: Receipts / mixing strategies | 13 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
43 | CKMLMV004 | Process model: Withdrawals | 10 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
44 | CKMLMV005 | Consumption alternatives | 4 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
45 | CKMLMV011 | Costing run: Object list | 5 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
46 | CKMLMV011F | Costing Run: Filter Table for Object List | 5 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
47 | CKMLMV015 | Naming rule assignment for materials (header) | 4 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
48 | CKMLMV_AUX_KALNR | Cost Estimate Numbers for Valuated Objects in QST | 4 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
49 | CKMLO | Material Ledger: Organizational Jobs | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
50 | CKMLRUNPLANT | Organizational units in a material ledger costing run | 8 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
51 | CKMLRUNTYPEBWKEY | Obsolete From Release 4.6A | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
52 | CKMLV | Material Ledger Control Records | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
53 | CKMLW | Material Ledger Currencies in Valuation Area | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
54 | CKML_PRICE_SEND | Customizing Material Price Dispatch | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
55 | CKMVFM_BSEG_OUT | Display of FI Documents, Transaction CKMVFM, SAP Note 912984 | 4 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
56 | CKMVFM_EXTRACT | Transaction CKMVFM, Extracts, see SAP Note 912984 | 11 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
57 | CKMVFM_OUT | Output for the Value_Flow_Monitor, see SAP Note 912984 | 12 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
58 | FCML_ALT | Alternatives | 3 | BWKEY | Valuation Area (Alternative) | nvarchar | 4 | 0 | | |
59 | FCML_MAT | ML Characteristics for Material (Selection Criteria) | 6 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
60 | FCML_PROC | Business Processes | 3 | BWKEY | Valuation Area (Process) | nvarchar | 4 | 0 | | |
61 | MLARC_IDX | Index for ML Document | 4 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
62 | MLIT | Material Ledger Document: Items | 8 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
63 | TCKMLBNKSZ | Assignment of Delivery Costs Structure | 4 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
64 | TMLCCSCR | Act.Cost Comp. Split: Data Range in Valuation Area (Curr) | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
65 | TMLCCSHD | Act.Cost Comp. Split: Data Range in Valuation Area (General) | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPAlternative Valuation Run |
66 | CKMLAVRDOCIT | Lines for Cumulation Posting Document | 13 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPBalance Sheet Valuation Procedures |
67 | MYLAUFIT | Object Table for Delta Run Using MRN9 | 9 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
68 | TNIW5W | Lowest Value: Devaluatn by Range of Cov. for Each Val. Area | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
69 | TNIW6W | Lowest Value: Devaluation for Slow/Non-movement by Val.Area | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
70 | TNIW9 | Reduction of Sales Prices (Lowest Value) | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPBatches |
71 | WBEW | Active Ingredient Valuation | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPElectronic Bank Statement |
72 | FEB_ACCNT_SAVE | Saving of Posting Lines for Postprocessing (Account Assign.) | 40 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
73 | FEB_ACT | Acct Assignment Templates | 40 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPFinancial Accounting |
74 | /OPT/VIM_1ITEM | Document Item | 90 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
75 | ACCTIT | Compressed Data from FI/CO Document | 76 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
76 | J_1GZSPVAT | Accounts substitutions for VAT report | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
77 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 61 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPFunds Management-Specific Postings |
78 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 60 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
79 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 59 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPGeneral Ledger Accounting |
80 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 111 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPGL Account Posting |
81 | TCJ_POSITIONS | Cash Journal Document Items | 47 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPIndustry Solution Catch Weight Management |
82 | /CWM/MIG_MBEWMUT | MBEW Master Segments | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPInventory Management |
83 | MMINKON | Worklist for Inconsistent Materials | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
84 | MMINKON_UP | Corrections due to Technical Problems with Stock | 7 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
85 | MWXVM07M | Fields: Update Control of Module Pool SAPMM07M | 32 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
86 | MWZVM07M | Fields: Update Control of Module Pool SAPMM07M | 32 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
87 | ORIG_PR_MBEW | Sales Price Origin of Last Total Revaluation at Retail | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
88 | T134H | Organiz. Unit: Business Area Determ. - MM View | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
89 | T134M | Control of Qty/Value Update | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
90 | TASSIGN_MM_T001W | Aux. Table for Status Info SD Maintenance View: Key VKORG | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
91 | USEG | Retail Revaluation Document: Revaluation Segment | 7 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPInvoice Verification |
92 | BSIM | Secondary Index, Documents for Material | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
93 | RBMA | Document Item: Incoming Invoice for Material | 8 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
94 | RSEG | Document Item: Incoming Invoice | 9 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
95 | T8JD | Valuation type with JV-information | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPLocal Currency Changeover |
96 | EWUCKMLW | EMU: Currencies for material ledger | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPLocalization |
97 | J_1AINFINV | Inflation: Invoices for Replacement Value Determination | 8 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
98 | J_1AINFMBW | Material Master - Inflation | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
99 | J_1AINFT16 | Warehouse report ( data of previous fiscal years ) | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
100 | J_1BLPP | Average Tax Rates for Reimbursement | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
101 | J_1BNFLIN | Nota Fiscal line items | 5 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPLogistics Basic Data |
102 | DMF_D_T001W | Transferred Sites | 4 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPMaterial Master |
103 | EBEW | Sales Order Stock Valuation | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
104 | EBEWH | Valuation of Sales Order Stock: History | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
105 | MABW | Management of Differently Maintained Material Data in Retail | 10 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
106 | MBEW | Material Valuation | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
107 | MBEWH | Material Valuation: History | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
108 | MBEW_TMP | File for Incorrect Data in Direct Input | 6 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
109 | MOFF | Outstanding Material Master Records | 8 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
110 | MSTA | Material Master Status | 15 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
111 | MVEW | Material Valuation | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
112 | MVEWH | Material Valuation: History | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
113 | OBEW | Valuated Stock with Subcontractor | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
114 | OBEWH | Valuated Stock with Subcontractor: History | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
115 | QBEW | Project Stock Valuation | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
116 | QBEWH | Valuation of Project Stock: History | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
117 | T149 | Valuation type/valuation class | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
118 | T149A | Valuation types for valuation area | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
119 | T149B | Valuation Category/Valuation type | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
120 | USRM1 | Material Master User Settings: Organizational Levels | 11 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPMaterials Management |
121 | /SAPNEA/J_SC_ACT | Activate Subcontracting with Chargeable Components | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
122 | J_1GVL_WHB015 | FI reposting settings | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPOverhead Cost Controlling |
123 | PFFLD | Period-End Partner: Organizational Log Information | 13 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPPlant Master |
124 | T001K | Valuation area | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
125 | T001W | Plants/Branches | 4 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPProduct Cost Planning |
126 | KEKO | Product Costing - Header Data | 11 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
127 | KNOB | Assignment of Cost Est. Number to Config. Object | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
128 | TCK14 | Overhead Groups | 2 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
129 | TCK15 | Descriptions for Overhead Groups | 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
130 | TCK33 | Assignment of Condition Types to Origin Group | 8 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPProfit Center Accounting |
131 | GLPCA | EC-PCA: Actual Line Items | 59 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
132 | GLPCP | EC-PCA: Plan Line Items | 120 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPReal Estate Management |
133 | VIAKBSEG | Document Line Item from SCS for Interface | 38 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
134 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 174 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
135 | NWCHGALDAT | IS-H CH: Zuordnung Materialnummer->Pharmacode (GalDat) | 10 | BWKEY | Area valorizzazione | nvarchar | 4 | 0 | | |
TOPTariffs, Duties and Permits |
136 | OIH_TAX_REV | Excise Duty Revaluation Documents | 9 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |
TOPVehicle Management System |
137 | VLCBATCHACT | VELO : Variant for Action Execution in Batch | 5 | BWKEY | Valuation Area | nvarchar | 4 | 0 | | |