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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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
1ERP EHP76.0DMC_MT_TABLES253DMC: Tables for a Mass Data Transfer
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT ID, TABNAME, FAILED, IN_PROCESS, DEFINED, GENERATED, CALCULATED, ACCESS_PLAN_TYPE, LOADED, TABCLASS, SQLTAB, CONTFLAG, WRITE_BEHAVIOUR, COBJ_GUID, TARGET_TAB, SEQNUM, BLOCKSIZE, SEGMENT_SIZE, SEARCH_DEPTH, SIZE_CAT, SELPAR, READING_TYPE, MAX_PORTION_ACPL, TABLE_MAX_PARALL, BLOCK_PROC_STEP FROM DMC_MT_TABLES
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1IDMass Transfer IDnvarchar30CHAR(N' ')NoDMC_MT_HEADERDMC_MT_IDENTIFIER Allow NULL? 
2TABNAMEName of an ABAP Dictionary objectnvarchar300CHAR(N' ')NoDDNAME Allow NULL? 
3FAILEDBoolean Variable (X=True, -=False, Space=Unknown)char10CHAR(N' ')YesBOOLEAN Allow NULL? 
4IN_PROCESSBoolean Variable (X=True, -=False, Space=Unknown)char10CHAR(N' ')YesBOOLEAN Allow NULL? 
5DEFINEDBoolean Variable (X=True, -=False, Space=Unknown)char10CHAR(N' ')YesBOOLEAN Allow NULL? 
6GENERATEDBoolean Variable (X=True, -=False, Space=Unknown)char10CHAR(N' ')YesBOOLEAN Allow NULL? 
7CALCULATEDMWB: Calculation Status of MTchar10CHAR(N' ')YesDMC_MT_CALC_STATE Allow NULL? 
8ACCESS_PLAN_TYPEType of Access Plannvarchar30CHAR(N' ')YesDMC_ACCESS_PLAN_TYPE Allow NULL? 
9LOADEDBoolean Variable (X=True, -=False, Space=Unknown)char10CHAR(N' ')YesBOOLEAN Allow NULL? 
10TABCLASSTable categorynvarchar80CHAR(N' ')YesTABCLASS Allow NULL? 
11SQLTABName of an SQL table or an appended tablenvarchar300CHAR(N' ')Yes*SQLAPPDTAB Allow NULL? 
12CONTFLAGDelivery classchar10CHAR(N' ')YesCONTFLAG Allow NULL? 
13WRITE_BEHAVIOURMWB: Transfer Behaviour of Conversionchar10NUMC(N'0')YesDMC_RTO_BEHAVIOUR Allow NULL? 
14COBJ_GUIDDMC: Globally Unique Key (22 Characters)nvarchar220CHAR(N' ')YesDMC_GUID Allow NULL? 
15TARGET_TABMWB: Target Table for Mass Processingnvarchar300CHAR(N' ')YesDMC_MT_TARGET_TAB Allow NULL? 
16SEQNUMSequence Numbernvarchar20NUMC(N'00')YesDMC_SEQNR_TABLE Allow NULL? 
17BLOCKSIZEMWB: Size of an RFC Packageint100INT4((0))YesDMC_BLOCKSIZE Allow NULL? 
18SEGMENT_SIZEMWB: Maximum Segment Size for a Precalculationint100INT4((0))YesDMC_SEGMENT_SIZE Allow NULL? 
19SEARCH_DEPTHMWB: Search Depth of a Precalculationint100INT4((0))YesDMC_SEARCH_DEPTH Allow NULL? 
20SIZE_CATMWB: Size Categorychar10CHAR(N' ')YesDMC_SIZE_CATEGORY Allow NULL? 
21SELPARMWB: Field Name of Selection Parameternvarchar300CHAR(N' ')Yes*DMC_SELPAR_FIELDNAME Allow NULL? 
22READING_TYPEreading type (transparent, pool, cluster, indx-cluster)char10CHAR(N' ')YesDMC_READING_TYPE Allow NULL? 
23MAX_PORTION_ACPLmaximum number of portions of single access plan (split)nvarchar50NUMC(N'00000')YesDMC_MAX_PORTION_ACPL Allow NULL? 
24TABLE_MAX_PARALLMaximum Number of Parallel Jobsnvarchar20NUMC(N'00')YesDMC_TAB_MAX_PARALLEL Allow NULL? 
25BLOCK_PROC_STEPBlock a processing step of MWB mass transferschar10CHAR(N' ')YesDMC_BLOCK_PROCESS_STEP Allow NULL? 
NamePrimaryUniqueTypeColumns
DMC_MT_TABLES~0YesYesCLUSTEREDTABNAME, ID
DMC_MT_TABLES~GIDNoNoNONCLUSTEREDCOBJ_GUID
DMC_MT_TABLES~SEQNoNoNONCLUSTEREDTABNAME, SEQNUM, ID