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

151 columns | Print definition?ERP 6.0  | HRKFT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_1ITEM_SDocument Item87HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
2/OPT/VIM_TITEMDocument Item87HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
3AUASSettlement Document: Totals Segment24HRKFTCO key subnumbernvarchar140
4BSEGAccounting Document Segment235HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
5BSSEGAccounting Document Segment224HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
6CE1PR22Périm. résultat IDES40HRKFTOrigine (CO-PA)nvarchar40
7CE2PR22Périm. résultat IDES31HRKFTOrigine (CO-PA)nvarchar40
8CE3PR22Périm. résultat IDES11HRKFTOrigine (CO-PA)nvarchar40
9FUDT_VDOCBSEGVerification Document Item with Additional Info224HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
10FUDT_VDOCBSEGEVVerification Document Item in the Entry View224HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
11FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)224HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
12GLPCA_CTProfit Center Documents75HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
13GLPCA_T_CTProfit Center Documents91HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
14GLPOS_C_CTFI Document: Entry View134HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
15GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items134HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
16GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items134HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
17GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items134HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
18GLPOS_N_CTNew General Ledger: Line Item with Currency Type136HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
19GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type136HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
20MLAUFHHistory table for summarized MLAUF data13HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
21TCKHACost Element/Origin Assignment with Additive Costs6HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
22YVIM_1ITEMDocument Item87HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
TOPAccounting Interface
23GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)165HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
24GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)165HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
TOPActual CostingMaterial Ledger
25CKMLKONAssignment of Modification Constants to Acct Assignmt Reason6HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
26CKMLMV011Costing run: Object list11HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
27CKMLMV011FCosting Run: Filter Table for Object List11HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
28FCML_MATML Characteristics for Material (Selection Criteria)16HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
29MLAUFMaterial Ledger Item Table for Order History12HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
30MLBEMaterial Ledger FS Item Table for GR/IR relevant transaction15HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
31MLBEHMaterial Ledger FS Item Table for GR/IR relevant transaction15HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
TOPAlternative Valuation Run
32CKMLAVRDOCITLines for Cumulation Posting Document23HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
TOPBasic Settings
33T8APP_HRKFTTTexts for values of field HRFKT in profit center planning4HRKFTValues of Field HRKFT in Profit Center Planningnvarchar40
TOPControlling
34COKEYCO key sub-numbers2HRKFTCO key subnumbernvarchar140
35CSLAActivity master18HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
TOPCost Center Accounting
36COSPRCO Objekt: Enhancement to COSP for Dependency Planning8HRKFTCO key subnumbernvarchar140
37TKZX3Credit objects for overhead cost elements per BUKRS/GSBER11HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
TOPCost Element Accounting
38COFIO1Object Table for Reconciliation Ledger COFIT11HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
TOPCost Object
39COEPBCO Object: Line Items Variance/Period-Based Results Analysis21HRKFTCO key subnumbernvarchar140
40COSBCO Object: Total Variances/Results Analyses9HRKFTCO key subnumbernvarchar140
41FCO_DOC_POSFailure Cost Document Item15HRKFTCO key subnumbernvarchar140
42TKKH1Origin in CO Object4HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
43TKKH2Text Table for Origin in CO Object5HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
TOPCosting
44COERSales Order Value Revenue7HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
45COESCO Object: Sales Order Value Line Items14HRKFTCO key subnumbernvarchar140
TOPCustomer Bill of Services
46TBOSFACDefine Surcharges and Discounts9HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
TOPData Retention Tool
47TXW_S_COEPRetrieve COEP from archive12HRKFTCO key subnumbernvarchar140
TOPElectronic Bank Statement
48FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)42HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
49FEB_ACTAcct Assignment Templates42HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
TOPFinancial Accounting
50/OPT/VIM_1ITEMDocument Item87HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
51ACCTITCompressed Data from FI/CO Document59HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
52VBSEGSDocument Segment for Document Parking - G/L Account Database84HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
TOPFunds Management
53TBPFKAvailability Control: Cost Elements Exempted4HRKFTCO key subnumbernvarchar140
TOPFunds Management-Specific Postings
54FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years83HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
55PSOSEGSRecurring Request Document Segment, G/L Accounts82HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
TOPGL Account Posting
56TCJ_POSITIONSCash Journal Document Items49HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
TOPInformation System
57MCKALKVVersions: Cost Itemization10HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
58MCKALKWVersions: Cost Itemization11HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
TOPInformation System, iViews
59COOI_PIBW CO-OM: Commitment Management: Deleted Line Items11HRKFTCO key subnumbernvarchar140
TOPInventory Management
60MWXVM07MFields: Update Control of Module Pool SAPMM07M34HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
61MWZVM07MFields: Update Control of Module Pool SAPMM07M34HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
62RESBReservation/dependent requirements148HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
TOPLocal Currency Changeover
63EWUCOKException table for TWAER conversion9HRKFTCO key subnumbernvarchar140
TOPLocalization
64VIXCFRBUDGETBudget Seasonality Data8HRKFTCO key subnumbernvarchar140
TOPMaterial Master
65EBEWSales Order Stock Valuation51HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
66MBEWMaterial Valuation74HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
67MBEW_TMPFile for Incorrect Data in Direct Input77HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
68MVEWMaterial Valuation74HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
69OBEWValuated Stock with Subcontractor50HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
70QBEWProject Stock Valuation50HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
TOPNon-Ferrous Metal enhancements
71/NFM/TCOAssignment of Controlling Area and Origin to NF Keys3HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
TOPOrders for Projects
72COSPPTransfer of the Order in the COSP Table to the Project9HRKFTCO key subnumbernvarchar140
73COSSPTransfer of the Order COSS Table to the Project9HRKFTCO key subnumbernvarchar140
TOPOverhead Cost Controlling
74COEJCO Object: Line Items (by Fiscal Year)172HRKFTCO key subnumbernvarchar140
75COEJRCO Object: Line Items for Stat. Key Figures (by Fiscal Year)47HRKFTCO key subnumbernvarchar140
76COEPCO Object: Line Items (by Period)22HRKFTCO key subnumbernvarchar140
77COEPRCO Object: Line Items for Stat. Key Figs (by Period)17HRKFTCO key subnumbernvarchar140
78COKACO Object: Control Data for Cost Elements5HRKFTCO key subnumbernvarchar140
79COKPCO Object: Control Data for Primary Planning8HRKFTCO key subnumbernvarchar140
80COKRCO Object: Control Data for Statistical Key Figures8HRKFTCO key subnumbernvarchar140
81COKSCO Object: Control Data for Secondary Planning8HRKFTCO key subnumbernvarchar140
82COSPCO Object: Cost Totals for External Postings8HRKFTCO key subnumbernvarchar140
83COSRCO Object: Statistical Key Figure Totals8HRKFTCO key subnumbernvarchar140
84COSSCO Object: Cost Totals for Internal Postings8HRKFTCO key subnumbernvarchar140
85COVP_DELTA_LOGLog of COVP Delta Queue for Error Analysis24HRKFTCO key subnumbernvarchar140
TOPOverhead Cost Orders
86COOICommitments Management: Line Items11HRKFTCO key subnumbernvarchar140
87COSBDCO Object: Total of variances/accruals, of which settled9HRKFTCO key subnumbernvarchar140
88COSPDCO Object: Settled Primary Cost Totals8HRKFTCO key subnumbernvarchar140
89COSSDCO Object: Settled Secondary Cost Totals8HRKFTCO key subnumbernvarchar140
90TKZU3Overhead Credit7HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
TOPPegging, Grouping, and Distribution
91DIS_TOBJSDistribution: cost objects posted to per group11HRKFTCO key subnumbernvarchar140
92DIS_TOBJS_COSPDistribution: Objects distributed to per Group WBS (Cost)9HRKFTCO key subnumbernvarchar140
93DIS_TOBJS_COSSDistribution: Objects distributed to per Group WBS (Cost)8HRKFTCO key subnumbernvarchar140
TOPProduct Cost Planning
94CKHSHeader: Unit Costing (Control + Totals)65HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
95CKISItems Unit Costing/Itemization Product Costing16HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
96CKTC_CBEWCosting Master Data - Attributes6HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
97TCKH2Assignment: Cost Element Interval - Cost Component Structure5HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
TOPProfit Center Accounting
98GLPCAEC-PCA: Actual Line Items20HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
99GLPCCEC-PCA: Transaction Attributes4HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
100GLPCPEC-PCA: Plan Line Items20HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
101GLPCTEC-PCA: Totals Table19HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
102T8APP_GLPCMEC-PCA: Plan Costs from Material Costing for Rep. Material21HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
103T8APP_HRKFTValue of field HRKFT in profit center planning3HRKFTValues of Field HRKFT in Profit Center Planningnvarchar40
TOPProfitability Analysis
104CE1850040HRKFTOrigins (CO-PA)nvarchar40
105CE1BGISErgebnisbereich für40HRKFTHerkunft (CO-PA)nvarchar40
106CE1E_B1Model Bank40HRKFTOrigins (CO-PA)nvarchar40
107CE1IDEAOp. Concern BR World40HRKFTOrigins (CO-PA)nvarchar40
108CE1IDEBErgebnisbereich IDES40HRKFTHerkunft (CO-PA)nvarchar40
109CE1IDESErgebnisbereich IDES40HRKFTHerkunft (CO-PA)nvarchar40
110CE1INT1Ergebnisbereich IDES40HRKFTHerkunft (CO-PA)nvarchar40
111CE1OC01Bike International40HRKFTOrigins (CO-PA)nvarchar40
112CE1R300Operating Concern IDES40HRKFTOrigins (CO-PA)nvarchar40
113CE1S001Sample operating concern40HRKFTOrigins (CO-PA)nvarchar40
114CE1S300Operating Concern IDES40HRKFTOrigins (CO-PA)nvarchar40
115CE1S_ALAirline Route Profit40HRKFTOrigins (CO-PA)nvarchar40
116CE1S_CPTemplate for Consumer Goods Industry40HRKFTOrigins (CO-PA)nvarchar40
117CE1S_GOQuickstart Template40HRKFTOrigins (CO-PA)nvarchar40
118CE2850031HRKFTOrigins (CO-PA)nvarchar40
119CE2BGISErgebnisbereich für31HRKFTHerkunft (CO-PA)nvarchar40
120CE2E_B1Model Bank31HRKFTOrigins (CO-PA)nvarchar40
121CE2IDEAOp. Concern BR World31HRKFTOrigins (CO-PA)nvarchar40
122CE2IDEBErgebnisbereich IDES31HRKFTHerkunft (CO-PA)nvarchar40
123CE2IDESErgebnisbereich IDES31HRKFTHerkunft (CO-PA)nvarchar40
124CE2INT1Ergebnisbereich IDES31HRKFTHerkunft (CO-PA)nvarchar40
125CE2OC01Bike International31HRKFTOrigins (CO-PA)nvarchar40
126CE2R300Operating Concern IDES31HRKFTOrigins (CO-PA)nvarchar40
127CE2S001Sample operating concern31HRKFTOrigins (CO-PA)nvarchar40
128CE2S300Operating Concern IDES31HRKFTOrigins (CO-PA)nvarchar40
129CE2S_ALAirline Route Profit31HRKFTOrigins (CO-PA)nvarchar40
130CE2S_CPTemplate for Consumer Goods Industry31HRKFTOrigins (CO-PA)nvarchar40
131CE2S_GOQuickstart Template31HRKFTOrigins (CO-PA)nvarchar40
132CE3850011HRKFTOrigins (CO-PA)nvarchar40
133CE3BGISErgebnisbereich für11HRKFTHerkunft (CO-PA)nvarchar40
134CE3E_B1Model Bank11HRKFTOrigins (CO-PA)nvarchar40
135CE3IDEAOp. Concern BR World11HRKFTOrigins (CO-PA)nvarchar40
136CE3IDEBErgebnisbereich IDES11HRKFTHerkunft (CO-PA)nvarchar40
137CE3IDESErgebnisbereich IDES11HRKFTHerkunft (CO-PA)nvarchar40
138CE3INT1Ergebnisbereich IDES11HRKFTHerkunft (CO-PA)nvarchar40
139CE3OC01Bike International11HRKFTOrigins (CO-PA)nvarchar40
140CE3R300Operating Concern IDES11HRKFTOrigins (CO-PA)nvarchar40
141CE3S001Segment level (CO-PA)11HRKFTOrigins (CO-PA)nvarchar40
142CE3S300Operating Concern IDES11HRKFTOrigins (CO-PA)nvarchar40
143CE3S_ALAirline Route Profit11HRKFTOrigins (CO-PA)nvarchar40
144CE3S_CPTemplate for Consumer Goods Industry11HRKFTOrigins (CO-PA)nvarchar40
145CE3S_GOQuickstart Template11HRKFTOrigins (CO-PA)nvarchar40
146CECOEJCO-PA Account Based Line Items174HRKFTCO key subnumbernvarchar140
147CECOEPCO-PA Account Based Line Items24HRKFTCO key subnumbernvarchar140
TOPRemaining Beverage - Obsolete Objects
148/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1226HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
TOPSimulation
149VSRESB_CNVersion: Reservation/Dependent requirements149HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40
TOPStatistical Key Figures
150ANLEAsset Origin by Line Item15HRKFTCO key subnumbernvarchar140
151ANLKAsset Origin by Cost Element10HRKFTCO key subnumbernvarchar140