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

53 columns | Print definition?ERP 6.0  | LOGSYSTEM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVMBTDEMOTKA01Controlling Areas8LOGSYSTEMnvarchar100
2CNV_20100_TKA01Backup copy - controlling areas27LOGSYSTEMLogical Systemnvarchar100
3CNV_20305_CEPCSAP LT: Backup table of CEPC45LOGSYSTEMLogical Systemnvarchar100
4VIXCITIRE2DATAIRE2 Master Data42LOGSYSTEMLogical Systemnvarchar100
5VIYCEXPITEMExpense Items11LOGSYSTEMLogical Systemnvarchar100
6PIQPROC_DHActivity Documents: Document Header10LOGSYSTEMLogical Systemnvarchar100
TOPActivity-Based Costing
7CBPRCO-ABC: Activity Master Table44LOGSYSTEMLogical Systemnvarchar100
TOPALE Integration Technology
8TBDLILists for a logical system2LOGSYSTEMLogical Systemnvarchar100
9TBDLTLists for a logical system for ALE distribution2LOGSYSTEMLogical Systemnvarchar100
TOPAppropriation Requests
10IMAKAppropriation requests - general data35LOGSYSTEMLogical Systemnvarchar100
TOPControlling
11COPPP_HDRCO Postprocessing List - Headers36LOGSYSTEMLogical Systemnvarchar100
12CSKSCost Center Master Data18LOGSYSTEMLogical Systemnvarchar100
13TKA01Controlling Areas8LOGSYSTEMLogical Systemnvarchar100
TOPCross-Application Components
14AAUUFKOrder master data74LOGSYSTEMLogical Systemnvarchar100
TOPData Retention Tool
15TXW_S_COBKRetrieve COBK from archive29LOGSYSTEMLogical Systemnvarchar100
TOPDepreciation Simulation
16IMCCIM Summarization: Characteristics that are master data6LOGSYSTEMLogical Systemnvarchar100
17IMCECCIM Summarization: Cost centers4LOGSYSTEMLogical Systemnvarchar100
18IMCEFLIM Summarization: Functional locations2LOGSYSTEMLogical Systemnvarchar100
19IMCEFLTIM Summarization: Texts for functional locations3LOGSYSTEMLogical Systemnvarchar100
20IMCEMIM Summarization: Measures5LOGSYSTEMLogical Systemnvarchar100
21IMCEPIM Summarization: Plants2LOGSYSTEMLogical Systemnvarchar100
22IMCEPCIM Summarization: Profit centers4LOGSYSTEMLogical Systemnvarchar100
23IMCEPTIM Summarization: Texts for plants3LOGSYSTEMLogical Systemnvarchar100
24IMCERIM Summarization: Appropriation requests5LOGSYSTEMLogical Systemnvarchar100
25IMCHIM Summarization: Header5LOGSYSTEMLogical Systemnvarchar100
26IMCKFIM Summarization: Key figures14LOGSYSTEMLogical Systemnvarchar100
27TAIC3IM Summarization: Conversion of Investment Program Name2LOGSYSTEMLogical Systemnvarchar100
TOPFlexible Real Estate Management
28VIXCITIREDATAIRE master data25LOGSYSTEMLogical Systemnvarchar100
TOPFunds Management
29FMCICommitment items master data33LOGSYSTEMLogical Systemnvarchar100
30FMFCTRFunds Center Master Record20LOGSYSTEMLogical Systemnvarchar100
31FMFINCODEFIFM: Financing code19LOGSYSTEMLogical Systemnvarchar100
TOPInput Tax Treatment
32VIITTAXDSBASETax Document Item to Be Broken Down (VIITTAXDSBASE)8LOGSYSTEMLogical Systemnvarchar100
TOPLocalization
33VIXCJPSCCOSTSEXTCosts per Object - Legacy Data Transfer13LOGSYSTEMLogical Systemnvarchar100
TOPMaintenance Notifications
34QMELQuality Notification142LOGSYSTEMLogical Systemnvarchar100
TOPMaintenance Processing
35/ISDFPS/MDIV_SUMDFPS: Totals Records for Interval Documents3LOGSYSTEMLogical Systemnvarchar100
TOPMeasuring Points and Counters
36IMRGMeasurement Document53LOGSYSTEMLogical Systemnvarchar100
TOPOperative Structures
37PROJProject definition67LOGSYSTEMLogical Systemnvarchar100
38PRPSWBS (Work Breakdown Structure) Element Master Data89LOGSYSTEMLogical Systemnvarchar100
TOPOverhead Cost Controlling
39CMDTGeneric Master Record: General Header6LOGSYSTEMLogical Systemnvarchar100
40COBKCO Object: Document Header35LOGSYSTEMLogical Systemnvarchar100
TOPOverhead Cost Orders
41AUFKOrder master data74LOGSYSTEMLogical Systemnvarchar100
TOPProfit Center Accounting
42CEPCProfit Center Master Data Table45LOGSYSTEMLogical Systemnvarchar100
TOPProfitability Analysis
43CEALE01CO-PA Distribution: Line Item Reference for Distribution18LOGSYSTEMLogical Systemnvarchar100
TOPRecords and Case Management
44RMPS_AI_LOCATIONSource System for Scenario Assignment3LOGSYSTEMLogical Systemnvarchar100
45RMPS_AI_SESSSave Session3LOGSYSTEMLogical Systemnvarchar100
TOPRental Accounting
46VIRAADVPAYEXTAdvance Payment - Legacy Data Transfer19LOGSYSTEMLogical Systemnvarchar100
47VIRADOCRE Document Header13LOGSYSTEMLogical Systemnvarchar100
48VIRAINVITEMRE Invoice Item25LOGSYSTEMLogical Systemnvarchar100
TOPService Charge Settlement
49VISCCOSTSEXTCosts per Object - Legacy Data Transfer13LOGSYSTEMLogical Systemnvarchar100
50VISCS_DOCSCosts Directly Assigned to Lease-Out7LOGSYSTEMLogical Systemnvarchar100
TOPSimulation
51VSAUFK_CNVersion: Order master data75LOGSYSTEMLogical Systemnvarchar100
52VSPROJ_CNVersion: Project definition68LOGSYSTEMLogical Systemnvarchar100
53VSPRPS_CNVersion: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data90LOGSYSTEMLogical Systemnvarchar100