SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

155 tablesERP 6.0 

Controlling :: Product Cost Controlling :: Actual CostingMaterial Ledger
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0CKMI1232Index for Accounting Documents for MaterialActual CostingMaterial Ledger
2ERP EHP76.0CKML11182Material Ledger Period Totals Records (Release 3.xx)Actual CostingMaterial Ledger
3ERP EHP76.0CKML2242Material Ledger Header Record (Release 3.xx)Actual CostingMaterial Ledger
4ERP EHP76.0CKMLAB0121Material Update StructureActual CostingMaterial Ledger
5ERP EHP76.0CKMLAB01T41Material Update Structure (Description)Actual CostingMaterial Ledger
6ERP EHP76.0CKMLAB01Z51Material Update Structure (Line Assignment)Actual CostingMaterial Ledger
7ERP EHP76.0CKMLAB0231Material Update Structure (Assignment to Valuation Area)Actual CostingMaterial Ledger
8ERP EHP76.0CKMLAGGREGATE51Aggregation ClassesActual CostingMaterial Ledger
9ERP EHP76.0CKMLCOCKPITSTATE151User Data for Actual Costing Costing RunActual CostingMaterial Ledger
10ERP EHP76.0CKMLCOPA71Assign Costing Key to Costing RunActual CostingMaterial Ledger
11ERP EHP76.0CKMLCR551Material Ledger: Period Totals Records ValuesActual CostingMaterial Ledger
12ERP EHP76.0CKMLCRWIP151Material Ledger: WIP Period Records (Values)Actual CostingMaterial Ledger
13ERP EHP76.0CKMLCT81Currency Types and Valuation Types in a Valuation AreaActual CostingMaterial Ledger
14ERP EHP76.0CKMLCUR61Text for currency type and valuation typeActual CostingMaterial Ledger
15ERP EHP76.0CKMLDUV182Distribution of Usage Diff.(Status for each ISEG entry)Actual CostingMaterial Ledger
16ERP EHP76.0CKMLDUVCO251Usage Differences for Each Account Assignment ObjectActual CostingMaterial Ledger
17ERP EHP76.0CKMLHD172Material Ledger: Header RecordActual CostingMaterial Ledger
18ERP EHP76.0CKMLHD_AGGR172Material Ledger: Header RecordActual CostingMaterial Ledger
19ERP EHP76.0CKMLKALNR71Material Ledger: Cost Estimate Number ControlActual CostingMaterial Ledger
20ERP EHP76.0CKMLKEKO111Material Ledger: Cost Component Split (Header)Actual CostingMaterial Ledger
21ERP EHP76.0CKMLKEPH551Material Ledger: Cost Component Split (Elements)Actual CostingMaterial Ledger
22ERP EHP76.0CKMLKEV81Material Ledger: Cost Component Split (Control Record)Actual CostingMaterial Ledger
23ERP EHP76.0CKMLKON61Assignment of Modification Constants to Acct Assignmt ReasonActual CostingMaterial Ledger
24ERP EHP76.0CKMLKONT41Description for Account Assignment ReasonsActual CostingMaterial Ledger
25ERP EHP76.0CKMLLACR191ML Activity Type: Period Record/Currency RecordActual CostingMaterial Ledger
26ERP EHP76.0CKMLLACRWIP91ML Activity Types: Period/ Currency Records WIP (Values)Actual CostingMaterial Ledger
27ERP EHP76.0CKMLLAHD52ML Activity Types: Header RecordActual CostingMaterial Ledger
28ERP EHP76.0CKMLLAPP81ML Activity Types: Period RecordsActual CostingMaterial Ledger
29ERP EHP76.0CKMLLAPPWIP81Ml Activity Types: Period Records WIP (Quantities)Actual CostingMaterial Ledger
30ERP EHP76.0CKMLMV001423Procurement alternativesActual CostingMaterial Ledger
31ERP EHP76.0CKMLMV001T41Texts for procurement alternativesActual CostingMaterial Ledger
32ERP EHP76.0CKMLMV00292Assignments material / procurement alternativesActual CostingMaterial Ledger
33ERP EHP76.0CKMLMV003263Process model: Receipts / mixing strategiesActual CostingMaterial Ledger
34ERP EHP76.0CKMLMV004164Process model: WithdrawalsActual CostingMaterial Ledger
35ERP EHP76.0CKMLMV004WIP433Process Model: Deductions WIPActual CostingMaterial Ledger
36ERP EHP76.0CKMLMV005302Consumption alternativesActual CostingMaterial Ledger
37ERP EHP76.0CKMLMV005T41Texts for consumption alternativesActual CostingMaterial Ledger
38ERP EHP76.0CKMLMV00661Control data for the quantity structure typesActual CostingMaterial Ledger
39ERP EHP76.0CKMLMV006T41Name for quantity structure typesActual CostingMaterial Ledger
40ERP EHP76.0CKMLMV00721Name formation (structure table)Actual CostingMaterial Ledger
41ERP EHP76.0CKMLMV007A61Name formation (algorithms)Actual CostingMaterial Ledger
42ERP EHP76.0CKMLMV007R291Name formation (naming rules)Actual CostingMaterial Ledger
43ERP EHP76.0CKMLMV007RT41Name formation: Text for naming ruleActual CostingMaterial Ledger
44ERP EHP76.0CKMLMV007T41Name formation (name of structure)Actual CostingMaterial Ledger
45ERP EHP76.0CKMLMV00961Process CatagoryActual CostingMaterial Ledger
46ERP EHP76.0CKMLMV009T41Process Catagory (description)Actual CostingMaterial Ledger
47ERP EHP76.0CKMLMV01031Movement type group for ML updateActual CostingMaterial Ledger
48ERP EHP76.0CKMLMV010T41Text for movement type groups for ML updateActual CostingMaterial Ledger
49ERP EHP76.0CKMLMV011165Costing run: Object listActual CostingMaterial Ledger
50ERP EHP76.0CKMLMV011F131Costing Run: Filter Table for Object ListActual CostingMaterial Ledger
51ERP EHP76.0CKMLMV011T31Filter hierarchiesActual CostingMaterial Ledger
52ERP EHP76.0CKMLMV01241Costing run: Predecessor/successor modelActual CostingMaterial Ledger
53ERP EHP76.0CKMLMV013232Assignment table: Process for production orderActual CostingMaterial Ledger
54ERP EHP76.0CKMLMV01471Assignment table: Procurement alternative for orderActual CostingMaterial Ledger
55ERP EHP76.0CKMLMV01552Naming rule assignment for materials (header)Actual CostingMaterial Ledger
56ERP EHP76.0CKMLMV015Z41Naming rule assignment for materials for each procure. cat.Actual CostingMaterial Ledger
57ERP EHP76.0CKMLMV01621Quantity structure tool: Naming ruleActual CostingMaterial Ledger
58ERP EHP76.0CKMLMV016T41Quantity structure tool: Texts for naming rulesActual CostingMaterial Ledger
59ERP EHP76.0CKMLMVADMIN31General Control Parameters for Actual CostingActual CostingMaterial Ledger
60ERP EHP76.0CKMLMV_AUX_KALNR101Cost Estimate Numbers for Valuated Objects in QSTActual CostingMaterial Ledger
61ERP EHP76.0CKMLMYMP151Periodic Receipt Values for Consumption Sequence ProcedureActual CostingMaterial Ledger
62ERP EHP76.0CKMLO121Material Ledger: Organizational JobsActual CostingMaterial Ledger
63ERP EHP76.0CKMLPP371Material Ledger Period Totals Records QuantityActual CostingMaterial Ledger
64ERP EHP76.0CKMLPPWIP81Material-Ledger: Period Records WIP (Quantities)Actual CostingMaterial Ledger
65ERP EHP76.0CKMLPR341Material Ledger: PricesActual CostingMaterial Ledger
66ERP EHP76.0CKMLPRKEKO111Material Ledger: Cost Component Split (Header) for PricesActual CostingMaterial Ledger
67ERP EHP76.0CKMLPRKEPH521Material Ledger: Cost Component Split (Elements) for PricesActual CostingMaterial Ledger
68ERP EHP76.0CKMLPR_EB181Prices for Ending Inventory/Balance Sheet ValuationActual CostingMaterial Ledger
69ERP EHP76.0CKMLRSCHEMA21Key Figure Scheme in Material LedgerActual CostingMaterial Ledger
70ERP EHP76.0CKMLRUNPERIOD393Material ledger costing run for one monthActual CostingMaterial Ledger
71ERP EHP76.0CKMLRUNPLANT111Organizational units in a material ledger costing runActual CostingMaterial Ledger
72ERP EHP76.0CKMLRUNTYPE61Obsolete From Release 4.6AActual CostingMaterial Ledger
73ERP EHP76.0CKMLRUNTYPEBWKEY31Obsolete From Release 4.6AActual CostingMaterial Ledger
74ERP EHP76.0CKMLRUNTYPET51Obsolete From Release 4.6AActual CostingMaterial Ledger
75ERP EHP76.0CKMLSCHEMA41Definition of Key Figure Scheme in Material-LedgerActual CostingMaterial Ledger
76ERP EHP76.0CKMLSCHEMAT41Description of Key Figure Scheme in Material LedgerActual CostingMaterial Ledger
77ERP EHP76.0CKMLV71Material Ledger Control RecordsActual CostingMaterial Ledger
78ERP EHP76.0CKMLVARIANT171FIFO Costing VariantActual CostingMaterial Ledger
79ERP EHP76.0CKMLVARIANTT41Description of FIFO Costing VariantActual CostingMaterial Ledger
80ERP EHP76.0CKMLW151Material Ledger Currencies in Valuation AreaActual CostingMaterial Ledger
81ERP EHP76.0CKMLWIPCUST81Customizing: WIP To ActualActual CostingMaterial Ledger
82ERP EHP76.0CKML_INDX_RUN81System table INDXActual CostingMaterial Ledger
83ERP EHP76.0CKML_PRICE_SEND71Customizing Material Price DispatchActual CostingMaterial Ledger
84ERP EHP76.0CKML_SM_AC91Actual Costing Data for Schedule ManagerActual CostingMaterial Ledger
85ERP EHP76.0CKMVFM_BSEG_OUT301Display of FI Documents, Transaction CKMVFM, SAP Note 912984Actual CostingMaterial Ledger
86ERP EHP76.0CKMVFM_EXTRACT111Transaction CKMVFM, Extracts, see SAP Note 912984Actual CostingMaterial Ledger
87ERP EHP76.0CKMVFM_OUT571Output for the Value_Flow_Monitor, see SAP Note 912984Actual CostingMaterial Ledger
88ERP EHP76.0FCML_ACCMAP51Alternative Accounts for Material Ledger PostingsActual CostingMaterial Ledger
89ERP EHP76.0FCML_ACCONF81Configuration of HDB AcceleratorActual CostingMaterial Ledger
90ERP EHP76.0FCML_ALT221AlternativesActual CostingMaterial Ledger
91ERP EHP76.0FCML_CCS_REP231HDB Reporting Structure for MLActual CostingMaterial Ledger
92ERP EHP76.0FCML_FIAACO41Control Table Transfer of Depreciation to COActual CostingMaterial Ledger
93ERP EHP76.0FCML_MAT361ML Characteristics for Material (Selection Criteria)Actual CostingMaterial Ledger
94ERP EHP76.0FCML_MLCO101Control Table Transfer of ML Postings to COActual CostingMaterial Ledger
95ERP EHP76.0FCML_PROC311Business ProcessesActual CostingMaterial Ledger
96ERP EHP76.0FCML_REP211ML Reporting StructureActual CostingMaterial Ledger
97ERP EHP76.0MLARC_IDX101Index for ML DocumentActual CostingMaterial Ledger
98ERP EHP76.0MLAUF271Material Ledger Item Table for Order HistoryActual CostingMaterial Ledger
99ERP EHP76.0MLAUFCR131Material Ledger Currency Table for Order HistoryActual CostingMaterial Ledger
100ERP EHP76.0MLAUFKEPH571ML: Cost Component Split (Components) for Order HistoryActual CostingMaterial Ledger
101ERP EHP76.0MLBE191Material Ledger FS Item Table for GR/IR relevant transactionActual CostingMaterial Ledger
102ERP EHP76.0MLBECR141Material Ledger Currency Table for GR/IR relevant transact.Actual CostingMaterial Ledger
103ERP EHP76.0MLBECRH141Material Ledger Currency Table for GR/IR relevant transact.Actual CostingMaterial Ledger
104ERP EHP76.0MLBEH191Material Ledger FS Item Table for GR/IR relevant transactionActual CostingMaterial Ledger
105ERP EHP76.0MLBEKEPH531ML: Cost Comp. Split (Elements) for Purchase Order HistoryActual CostingMaterial Ledger
106ERP EHP76.0MLCD191Material Ledger: Summarization Record (from Documents)Actual CostingMaterial Ledger
107ERP EHP76.0MLCO451Material valuation document account assignment informationActual CostingMaterial Ledger
108ERP EHP76.0MLCR161Material Ledger Document: Currencies and ValuesActual CostingMaterial Ledger
109ERP EHP76.0MLCRF101Material Ledger Document: Field Groups (Currencies)Actual CostingMaterial Ledger
110ERP EHP76.0MLCRP171Material Ledger Document: Price Changes (Currencies, Prices)Actual CostingMaterial Ledger
111ERP EHP76.0MLFG21Material Ledger Document: Field GroupsActual CostingMaterial Ledger
112ERP EHP76.0MLHD212Material Ledger Document: HeaderActual CostingMaterial Ledger
113ERP EHP76.0MLIT433Material Ledger Document: ItemsActual CostingMaterial Ledger
114ERP EHP76.0MLITMB212Material valuation document row informationActual CostingMaterial Ledger
115ERP EHP76.0MLKEPH541ML Document: Cost Component Split (Elements) for ValuesActual CostingMaterial Ledger
116ERP EHP76.0MLMST81Material Ledger Document: Costing Run Header DataActual CostingMaterial Ledger
117ERP EHP76.0MLORDERHIST92Conversion Table for Order HistoryActual CostingMaterial Ledger
118ERP EHP76.0MLPP231Material Ledger Document: Posting Periods and QuantitiesActual CostingMaterial Ledger
119ERP EHP76.0MLPPF81Material Ledger Document: Field Groups (Posting Periods)Actual CostingMaterial Ledger
120ERP EHP76.0MLPRKEKO111ML Document: Cost Component Split (Header)for PricesActual CostingMaterial Ledger
121ERP EHP76.0MLPRKEPH541ML Document: Cost Component Split (Components)for PricesActual CostingMaterial Ledger
122ERP EHP76.0MLWERE72Conversion Table between Purchasing and Material LedgerActual CostingMaterial Ledger
123ERP EHP76.0MLWIPCOREF31WIP Document in Material Ledger - Reference to CO DocumentsActual CostingMaterial Ledger
124ERP EHP76.0MLWIPHD142WIP Document in Material Ledger - HeaderActual CostingMaterial Ledger
125ERP EHP76.0MLWIPIT391WIP Document in Material Ledger - LinesActual CostingMaterial Ledger
126ERP EHP76.0T003L31Transaction Type for Material LedgerActual CostingMaterial Ledger
127ERP EHP76.0TCKMHD51Description of Material Ledger TypeActual CostingMaterial Ledger
128ERP EHP76.0TCKMIT31Currency Types and Valuation Categories for Mat. Ledger TypeActual CostingMaterial Ledger
129ERP EHP76.0TCKMLBNKS41Assignment of Other Account Key if Not to ActivateActual CostingMaterial Ledger
130ERP EHP76.0TCKMLBNKSZ51Assignment of Delivery Costs StructureActual CostingMaterial Ledger
131ERP EHP76.0TDUV15641Movement Types That Play a Role in DistributionActual CostingMaterial Ledger
132ERP EHP76.0TMLCCSCR41Act.Cost Comp. Split: Data Range in Valuation Area (Curr)Actual CostingMaterial Ledger
133ERP EHP76.0TMLCCSHD31Act.Cost Comp. Split: Data Range in Valuation Area (General)Actual CostingMaterial Ledger
134ERP EHP76.0TMLCCSSCOPE71Actual Cost Component Split: Structure of Data RangeActual CostingMaterial Ledger
135ERP EHP76.0TMLCCSSCOPETXT41Actual Cost Component Split: Split for Data Range (Texts)Actual CostingMaterial Ledger
Controlling :: Product Cost Controlling :: Actual CostingMaterial Ledger :: Alternative Valuation Run
ProductVersionTableColumnsIndexesDescriptionModule
136ERP EHP76.0CKMLAVRDOC162Closing Document for CumulationAlternative Valuation Run
137ERP EHP76.0CKMLAVRDOCCR71Cumulation Posting Document: Currency InformationAlternative Valuation Run
138ERP EHP76.0CKMLAVRDOCIT701Lines for Cumulation Posting DocumentAlternative Valuation Run
139ERP EHP76.0CKMLAVR_CPTFUNC111Functions in the Alternative Valuation Run CockpitAlternative Valuation Run
140ERP EHP76.0CKMLAVR_CPTFUNCT51Text Table Func. in Alternative Valuation Run CockpitAlternative Valuation Run
141ERP EHP76.0CKMLAVR_KOMOK41Account Modifications Posting Alternative Valuation RunsAlternative Valuation Run
142ERP EHP76.0CKMLAVR_KOMOKT51Account Modifications Posting Alternative Valuations: TextsAlternative Valuation Run
143ERP EHP76.0CKMLRUNSCALE161Re-scaling Amounts in the AVRAlternative Valuation Run
144ERP EHP76.0CKMLRUNW171Runs for Weekly Actual Costing in Material LedgerAlternative Valuation Run
145ERP EHP76.0MLAVRSCALE252Re-scaling Amounts AVRAlternative Valuation Run
146ERP EHP76.0MLAVRSCALEKEPH1061Cost Component Split of Re-scaling Amounts AVRAlternative Valuation Run
Controlling :: Product Cost Controlling :: Actual CostingMaterial Ledger :: Distribution of Usage Variances
ProductVersionTableColumnsIndexesDescriptionModule
147ERP EHP76.0CKMLDUVACT221Distribution of Activity Differences: Single Rcords & StatusDistribution of Usage Variances
148ERP EHP76.0CKMLDUVACTCO291Distribution Acty Differences: Diff. Per Acct Assgnmt objectDistribution of Usage Variances
149ERP EHP76.0CKMLDUVN212Distribution of Usage Diff.(Status for each ISEG entry)Distribution of Usage Variances
150ERP EHP76.0CKMLDUVN001L71Distribution of Consumption Differences: Activation ControlDistribution of Usage Variances
151ERP EHP76.0CKMLDUVNCO401Usage Differences for Each Account Assignment ObjectDistribution of Usage Variances
152ERP EHP76.0DUVMSEG_EXTRACT192duv mseg extract for performanceDistribution of Usage Variances
153ERP EHP76.0TDUVN15641Movement Types That Play a Role in DistributionDistribution of Usage Variances
Controlling :: Product Cost Controlling :: Actual CostingMaterial Ledger :: Periodic Material Valuation
ProductVersionTableColumnsIndexesDescriptionModule
154ERP EHP76.0CKMLCUMDOC112Closing Document for CumulationPeriodic Material Valuation
155ERP EHP76.0CKMLDELTAPOST101Temporary Storage for Delta Postings for CumulationPeriodic Material Valuation