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

110 columns | Print definition?ERP 6.0  | KALNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMS_05_CKMLHCollect Table for Material Ledger3KALNRBEDID for CNVTDMS_05_*nvarchar120
2MLAUFCRHHistory table for summerized MLAUFCR data7KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
3MLAUFHHistory table for summarized MLAUF data7KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
4MLAUFKEPHHHistory table for summarized MLAUFKEPH data7KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
5ZEIM_AFPOOrder item28KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
6ZEIM_VBAPSales Document: Item Data162KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPActual CostingMaterial Ledger
7CKMI1Index for Accounting Documents for Material2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
8CKML1Material Ledger Period Totals Records (Release 3.xx)2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
9CKML2Material Ledger Header Record (Release 3.xx)2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
10CKMLAGGREGATEAggregation Classes3KALNRCost Estimate Number - Product Costingnvarchar120
11CKMLCRMaterial Ledger: Period Totals Records Values2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
12CKMLCRWIPMaterial Ledger: WIP Period Records (Values)2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
13CKMLDUVCOUsage Differences for Each Account Assignment Object16KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
14CKMLHDMaterial Ledger: Header Record2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
15CKMLKALNRMaterial Ledger: Cost Estimate Number Control2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
16CKMLKEKOMaterial Ledger: Cost Component Split (Header)2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
17CKMLKEPHMaterial Ledger: Cost Component Split (Elements)2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
18CKMLLACRML Activity Type: Period Record/Currency Record2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
19CKMLLACRWIPML Activity Types: Period/ Currency Records WIP (Values)2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
20CKMLLAHDML Activity Types: Header Record2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
21CKMLLAPPML Activity Types: Period Records2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
22CKMLLAPPWIPMl Activity Types: Period Records WIP (Quantities)2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
23CKMLMV001Procurement alternatives2KALNRProcurement alternative/processnvarchar120
24CKMLMV001TTexts for procurement alternatives2KALNRProcurement alternative/processnvarchar120
25CKMLMV005Consumption alternatives2KALNRConsumption alternativenvarchar120
26CKMLMV005TTexts for consumption alternatives2KALNRProcurement alternative/processnvarchar120
27CKMLMV011Costing run: Object list3KALNRCost Estimate Number - Product Costingnvarchar120
28CKMLMV012Costing run: Predecessor/successor model4KALNRCost Estimate Number - Product Costingnvarchar120
29CKMLMV_AUX_KALNRCost Estimate Numbers for Valuated Objects in QST2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
30CKMLMYMPPeriodic Receipt Values for Consumption Sequence Procedure2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
31CKMLPPMaterial Ledger Period Totals Records Quantity2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
32CKMLPPWIPMaterial-Ledger: Period Records WIP (Quantities)2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
33CKMLPRMaterial Ledger: Prices2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
34CKMLPRKEKOMaterial Ledger: Cost Component Split (Header) for Prices2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
35CKMLPRKEPHMaterial Ledger: Cost Component Split (Elements) for Prices2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
36CKMLPR_EBPrices for Ending Inventory/Balance Sheet Valuation2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
37CKMVFM_OUTOutput for the Value_Flow_Monitor, see SAP Note 9129843KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
38FCML_ALTAlternatives2KALNRProcurement alternative/processnvarchar120
39FCML_MATML Characteristics for Material (Selection Criteria)2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
40FCML_PROCBusiness Processes2KALNRProcurement alternative/processnvarchar120
41MLAUFMaterial Ledger Item Table for Order History7KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
42MLAUFCRMaterial Ledger Currency Table for Order History7KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
43MLAUFKEPHML: Cost Component Split (Components) for Order History7KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
44MLBEMaterial Ledger FS Item Table for GR/IR relevant transaction11KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
45MLBEHMaterial Ledger FS Item Table for GR/IR relevant transaction11KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
46MLCDMaterial Ledger: Summarization Record (from Documents)2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
47MLITMaterial Ledger Document: Items9KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
48MLWIPITWIP Document in Material Ledger - Lines4KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPAppropriation Requests
49IMAVAppropriation request variant25KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
50IMAVCCalculations Copied from Variants to WBS Elements5KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPBalance Sheet Valuation Procedures
51MYABKBal. Sheet Valuation: Table of Database Commits Carried Out2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPConsumer Products for Food Beverage
52CFB_VERID_MRPRelease/Lock Production Version for Mat. Req. Planning6KALNRCost Estimate Number - Product Costingnvarchar120
TOPCosting
53PRECP2ECP: Subobjects, KLVAR/KALNR5KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPCross-Application Components
54VVBAPSales Document: Item Data162KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPCustomer Bill of Services
55ADBOS_ECP_CKISBOS: Enhancement to Detailed Statement3KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPDistribution of Usage Variances
56CKMLDUVACTCODistribution Acty Differences: Diff. Per Acct Assgnmt object25KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
57CKMLDUVNCOUsage Differences for Each Account Assignment Object16KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPExternal Services
58ESLLLines of Service Package96KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPFunds Management
59BPEGLine Item Overall Values Controlling Obj.6KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
60BPEJLine Item Annual Values Controlling Obj.6KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
61BPGETotals Record for Total Value Controlling obj.17KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
62BPJATotals Record for Annual Total Controlling Obj.19KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPIndustry Solution Catch Weight Management
63/FMP/D_MP_HISTMaterial Price History2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
64/FMP/D_MP_PRICMaterial Prices2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPInventory Management
65MWXVM07MFields: Update Control of Module Pool SAPMM07M156KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
66MWZVM07MFields: Update Control of Module Pool SAPMM07M156KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPLocal Currency Changeover
67EWUCOKALException table for conversion of TWAER in detailed planning3KALNRCost Estimate Numbernvarchar120
TOPLocalization
68J_1AINFINVInflation: Invoices for Replacement Value Determination2KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPMaintenance Notifications
69QMELQuality Notification136KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPMaterial
70RSADDAdditional fields for reservation11KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPMaterial Master
71MBEWMaterial Valuation67KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
72MBEW_TMPFile for Incorrect Data in Direct Input70KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
73MVEWMaterial Valuation67KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPOperative Structures
74PRPSWBS (Work Breakdown Structure) Element Master Data94KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPOverhead Cost Controlling
75COKLCO Object: Control Data for Activity Types31KALNRCost Estimate Numbernvarchar120
76COKPCO Object: Control Data for Primary Planning37KALNRCost Estimate Numbernvarchar120
77COKRCO Object: Control Data for Statistical Key Figures18KALNRCost Estimate Numbernvarchar120
78COKSCO Object: Control Data for Secondary Planning31KALNRCost Estimate Numbernvarchar120
TOPPegging, Grouping, and Distribution
79TBLPTransfer/Loan data log table34KALNRCost Estimate Number - Product Costingnvarchar120
TOPProduct Cost by Period
80CKPHMaster Record: Cost Object ID Number33KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPProduct Cost Planning
81CKBSBase Planning Object - Unit Costing51KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
82CKHSHeader: Unit Costing (Control + Totals)4KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
83CKHTTexts for CKHS4KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
84CKIPUnit Costing: Period Costs Line Item4KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
85CKISItems Unit Costing/Itemization Product Costing4KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
86CKIS_CCItemization: Additional Data - Concurrent Costing3KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
87CKITTexts for CKIS4KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
88CKKSHeader: Unit Costing (Control + Totals)3KALNRCost Estimate Number (Unit Costing)nvarchar80
89CKKTTexts for CKKS3KALNRCost Estimate Number (Unit Costing)nvarchar80
90CKPPPeriodic Values for Unit Costing Item3KALNRCost Estimate Number (Unit Costing)nvarchar80
91CKPSUnit Costing Items3KALNRCost Estimate Number (Unit Costing)nvarchar80
92CKPTTexts for CKPS3KALNRCost Estimate Number (Unit Costing)nvarchar80
93CKTC_KALNRDatabase Table for Costing Numbers7KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
94KALMCosting Run: Costing Objects11KALNRCost Estimate Number - Product Costingnvarchar120
95KALOCosting Run: Costing Objects (KVMK)33KALNRCost Estimate Number - Product Costingnvarchar120
96KEKOProduct Costing - Header Data3KALNRCost Estimate Number - Product Costingnvarchar120
97KEKO_CCAdditional Data for Concurrent Costing3KALNRCost Estimate Number - Product Costingnvarchar120
98KEPHProduct Costing: Cost Components for Cost of Goods Mfd3KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
99KNKOAssignment of Cost Est. Number to Config. Object4KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
100KNOBAssignment of Cost Est. Number to Config. Object6KALNRCost Estimate Number - Product Costingnvarchar120
TOPProduction Orders
101AFPOOrder item28KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
102AFVCOperation within an order164KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPRemaining Beverage - Obsolete Objects
103/BEV1/RBVBAPSales Document: Item Data162KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPRevenues and Earnings
104VPKSDITEMSales Pricing Header Data (Specific to SD)7KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPSales
105VBAPSales Document: Item Data162KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
TOPSimulation
106VSAFPO_CNVersion: Order items in PP orders29KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
107VSAFVC_CNVersion: Operation in order165KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
108VSPRPS_CNVersion: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data95KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
109VSRSADD_CNVersion: Additional fields for reservation12KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120
110VSVBAP_CNVersion: Sales document: Item data163KALNRCost Estimate Number for Cost Est. w/o Qty Structurenvarchar120