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

118 columns | Print definition?ERP 6.0  | MT_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DMCC_AUTH_MAPAUTH MAPPING -> HANA AUTH-Privileges1MT_IDMass Transfer IDnvarchar30
2DMCC_AUTH_STGAuthorization Mapping1MT_IDMass Transfer IDnvarchar30
3DMCC_AUTH_USERAUTH USER1MT_IDMass Transfer IDnvarchar30
4DMC_ACP_STG_GENMWB: Static Delimitation Settings for generation3MT_IDMass Transfer IDnvarchar30
5DMC_ACSPL_SELECTDefine WHERE conditions for access plan calc. and load1MT_IDMass Transfer IDnvarchar30
6DMC_COMPARETable for compare result for table2MT_IDMass Transfer IDnvarchar30
7DMC_DB_TAB_MAPMapping of internal tabnames to generic DB tabnames1MT_IDMass Transfer IDnvarchar30
8DMC_FM_RESTARTAssignment of IDs to sender objects for restart handling1MT_IDMass Transfer IDnvarchar30
9DMC_JOB_SETTINGJob control information1MT_IDMass Transfer IDnvarchar30
10DMC_LOG_INDEXIndex for log filtering6MT_IDMass Transfer IDnvarchar30
11DMC_MT_COUNT_RESMWB: Count Results from Table Count3MT_IDMass Transfer IDnvarchar30
12DMC_MT_RULE_ASSMWB: Rule Assignment1MT_IDMass Transfer IDnvarchar30
13DMC_MT_TABLE_MAPMappings of database table names to technical names1MT_IDMass Transfer IDnvarchar30
14DMC_MT_TRACKMWB: Tracking Information for a Mass Transfer3MT_IDMass Transfer IDnvarchar30
15DMC_PERF_OPTIONSPerformance options for migration objects1MT_IDMass Transfer IDnvarchar30
16DMC_TRNSF_SEQUENDefine Migr.Obj. Transfer Sequence (pred. / succ. relationsh1MT_IDMass Transfer IDnvarchar30
17IRW_LTARCHDEFArchiving Object Definition1MT_IDMass Transfer IDnvarchar30
18IRW_LTARCHOBJArchiving Object1MT_IDMass Transfer IDnvarchar30
19IRW_LTCDETables for CDE Extraction1MT_IDMass Transfer IDnvarchar30
20IRW_LTCLUSTBLCluster Tables1MT_IDMass Transfer IDnvarchar30
21IRW_LTCONFIGSession Information1MT_IDMass Transfer IDnvarchar30
22IRW_LTJOINMAPTable Relationship between Parent and Child1MT_IDMass Transfer IDnvarchar30
23IRW_LTMAPTABLEMapping Table1MT_IDMass Transfer IDnvarchar30
24IRW_LTRUNLT Archiving Document Number5MT_IDMass Transfer IDnvarchar30
25IUUC_ASS_RUL_MAPAssignment of Rules to Tables1MT_IDMass Transfer IDnvarchar30
26IUUC_AT_RESTARTcontrol tab if tab is rescheduled on struct. change1MT_IDMass Transfer IDnvarchar30
27IUUC_BW_LOGSYSSettings for BW Logsys used in SLT1MT_IDMass Transfer IDnvarchar30
28IUUC_BW_PSASettings for BW PSA connection1MT_IDMass Transfer IDnvarchar30
29IUUC_CCARD_ORDERorder and status information for credit card de-/encryption2MT_IDMass Transfer IDnvarchar30
30IUUC_DD_SYNC_HDRSystem synchronization: header data of a synchronization run2MT_IDMass Transfer IDnvarchar30
31IUUC_DR_CHECKIUUC: Checkresult for Delta Replay1MT_IDMass Transfer IDnvarchar30
32IUUC_EXCEPT_TABIUUC exception table (for table classification)1MT_IDMass Transfer IDnvarchar30
33IUUC_EXCHNG_TABLList of exchange tables1MT_IDMass Transfer IDnvarchar30
34IUUC_INCO_MEDATAInconsistency handling -> meta data of data cluster2MT_IDMass Transfer IDnvarchar30
35IUUC_INDX_OBJECTObject definition for INDX-like tables1MT_IDMass Transfer IDnvarchar30
36IUUC_KB_AIM_GENTables processed by AIMs1MT_IDMass Transfer IDnvarchar30
37IUUC_KB_AIM_TABLTables processed by AIMs1MT_IDMass Transfer IDnvarchar30
38IUUC_KB_AIM_XREFAIM dependencies1MT_IDMass Transfer IDnvarchar30
39IUUC_KB_BUF_INVBuffer Tables and Invalidations1MT_IDMass Transfer IDnvarchar30
40IUUC_KB_LOCK_TRXIUUC: Locked Transactions1MT_IDMass Transfer IDnvarchar30
41IUUC_KB_SPLIT_FLIUUC: Knowl.Base Split fields for parallel processing1MT_IDMass Transfer IDnvarchar30
42IUUC_KB_XPRA_GENXPRAs: General data1MT_IDMass Transfer IDnvarchar30
43IUUC_KB_XPRA_TABTables processed by XPRAs1MT_IDMass Transfer IDnvarchar30
44IUUC_LOGTAB_IDMWB: Mapping Structure/ Append for Unique Identifier1MT_IDMass Transfer IDnvarchar30
45IUUC_LOGTB_FIELDnon-key fields of a table being part of the logging table1MT_IDMass Transfer IDnvarchar30
46IUUC_MOD_PERF_OPIUUC: Modify PERF_OPT based on automated ST10 evaluation1MT_IDMass Transfer IDnvarchar30
47IUUC_MT_HEADERmass transfer header fields for IUUC1MT_IDMass Transfer IDnvarchar30
48IUUC_NO_MULTICONMass Transfers for 1:1 replication only1MT_IDThree-digit character field for IDocsnvarchar30
49IUUC_ODQ_ALIASMapping of MT_ID to alias known in ODQ1MT_IDMass Transfer IDnvarchar30
50IUUC_ODQ_TABLEStables for processing as ODQ provider3MT_IDMass Transfer IDnvarchar30
51IUUC_PARALL_CALCPrecalculation tables for IUUC initial load1MT_IDMass Transfer IDnvarchar30
52IUUC_PERF_OPTIONtable-specific options for performance improvements1MT_IDMass Transfer IDnvarchar30
53IUUC_PRECALC_OBJPrecalculation tables for IUUC initial load1MT_IDMass Transfer IDnvarchar30
54IUUC_PREDEF_COBJtable for defining predefined COBJ for later-on usage1MT_IDMass Transfer IDnvarchar30
55IUUC_PROCOPT_CHNChange log for Process Option changes1MT_IDMass Transfer IDnvarchar30
56IUUC_RC_TMPL_MAPMapping between MTID and Template_ID1MT_IDMass Transfer IDnvarchar30
57IUUC_RECONIUUC: Reconcilitaion Results per Table1MT_IDMass Transfer IDnvarchar30
58IUUC_RECON_F2FIUUC: Reconciliation Field to Field Comparison1MT_IDMass Transfer IDnvarchar30
59IUUC_RECON_F2F_EIUUC: Reconciliation Field to Field Comparison Exceptions1MT_IDMass Transfer IDnvarchar30
60IUUC_RECON_F2F_HIUUC: Reconcilitaion Results per Table1MT_IDMass Transfer IDnvarchar30
61IUUC_RECON_F2F_RIUUC: Reconcilation Field-to-Field Result2MT_IDMass Transfer IDnvarchar30
62IUUC_RECON_HDRIUUC: Reconcilitaion Header1MT_IDMass Transfer IDnvarchar30
63IUUC_RECON_RCIUUC: Reconciliation Field to Field Comparison1MT_IDMass Transfer IDnvarchar30
64IUUC_RECON_RUNIDIUUC Reconciliation RunID1MT_IDMass Transfer IDnvarchar30
65IUUC_RECON_WCL_CIUUC: Where Cluase1MT_IDMass Transfer IDnvarchar30
66IUUC_RECON_WCL_HIUUC: Reconciliation Where Clause1MT_IDMass Transfer IDnvarchar30
67IUUC_REPL_CONFIGConfiguration of a replication mt_id1MT_IDMass Transfer IDnvarchar30
68IUUC_REPL_DATAAGControl table for data aging1MT_IDMass Transfer IDnvarchar30
69IUUC_REPL_ENError notification settings for LT replicator1MT_IDMass Transfer IDnvarchar30
70IUUC_REPL_EN_EMLEmail settings for Error notification in LT replicator1MT_IDMass Transfer IDnvarchar30
71IUUC_REPL_EN_TABError notification settings (table level) for LT replicator1MT_IDMass Transfer IDnvarchar30
72IUUC_REPL_LTNCYLEmail settings for Error notification in LT replicator1MT_IDMass Transfer IDnvarchar30
73IUUC_REPL_MAPMapping between config_guid and MT_ID3MT_IDMass Transfer IDnvarchar30
74IUUC_REPL_PARALLTables for Automatic Parallel Replication1MT_IDMass Transfer IDnvarchar30
75IUUC_REPL_PARFLDTable for Automatic Parallel Replication Fields1MT_IDMass Transfer IDnvarchar30
76IUUC_REPL_TABSTGReplication Setting for Table1MT_IDMass Transfer IDnvarchar30
77IUUC_REPL_TAB_DVFieldname table for deviations in HANA1MT_IDMass Transfer IDnvarchar30
78IUUC_REPL_TYPMAPReplication: Type Mapping1MT_IDMass Transfer IDnvarchar30
79IUUC_REPL_TYPREDFieldname table for deviations in HANA1MT_IDMass Transfer IDnvarchar30
80IUUC_RL_DATArepl logging - staging area for tables in replication3MT_IDMass Transfer IDnvarchar30
81IUUC_RL_DATA_CLrepl logging - staging area for tables in replication3MT_IDMass Transfer IDnvarchar30
82IUUC_RL_MEDATARepl logging -> meta data of data cluster2MT_IDMass Transfer IDnvarchar30
83IUUC_RL_MEDATACLRepl logging -> meta data of data cluster2MT_IDMass Transfer IDnvarchar30
84IUUC_RL_TABSTRstructural historical information for tables(Transp,Cluster)2MT_IDMass Transfer IDnvarchar30
85IUUC_RM_MT_PARAMreplication monitoring parameters1MT_IDMass Transfer IDnvarchar30
86IUUC_RS_ORDERTable to keep the history for all actions from RS_ORDER1MT_IDMass Transfer IDnvarchar30
87IUUC_RS_STATUSTable to keep the history for all actions from RS_STATUS1MT_IDMass Transfer IDnvarchar30
88IUUC_SCHEMA_MAPTable to map schema to mass transfers2MT_IDMass Transfer IDnvarchar30
89IUUC_SPC_PROCOPTdefine field-content-specific trigger behaviour (freeze/delt1MT_IDMass Transfer IDnvarchar30
90IUUC_TABCL_MAPMapping: TABCLASS sender to TABCLASS receiver1MT_IDMass Transfer IDnvarchar30
91IUUC_TABLEStables to be processed by IUUC1MT_IDMass Transfer IDnvarchar30
92IUUC_TABLESVtables to be processed by IUUC - version table1MT_IDMass Transfer IDnvarchar30
93IUUC_TABLES_RCVTable with receiver shadowtabs for iCWB scenario of IUUC1MT_IDMass Transfer IDnvarchar30
94IUUC_TAB_EVALUATIUUC Table analysis: evaluation of table usage - OBSOLETE1MT_IDMass Transfer IDnvarchar30
95IUUC_TAB_IDMWB: Mapping structure for unique identifier1MT_IDMass Transfer IDnvarchar30
96IUUC_TRACKIUUC: Tracking for Delta Replay1MT_IDMass Transfer IDnvarchar30
97IUUC_TRACK_HDRIUUC: Tracking for Delta Replay1MT_IDMass Transfer IDnvarchar30
98IUUC_UC_TAB_COPYIUUC CopyControl for Unicode Conversion tables1MT_IDMass Transfer IDnvarchar30
99MDS_AIM_USAGEDMC: AIM Usage1MT_IDMass Transfer IDnvarchar30
100MDS_E070MDS: E070 to a specific simulation version1MT_IDMass Transfer IDnvarchar30
101MDS_E071MDS: E071 to a specific simulation version1MT_IDMass Transfer IDnvarchar30
102MDS_E071CMDS: E071C to a specific simulation version1MT_IDMass Transfer IDnvarchar30
103MDS_E071KMDS: E071K to a specific simulation version1MT_IDMass Transfer IDnvarchar30
104MDS_MAINT_EV_VERIUUC: all maintenance events specific for a upgrade version1MT_IDMass Transfer IDnvarchar30
105MDS_OBJHMDS: OBJH to a specific simulation version1MT_IDMass Transfer IDnvarchar30
106MDS_OBJMMDS: OBJM to a specific simulation version1MT_IDMass Transfer IDnvarchar30
107MDS_OBJSMDS: OBJS to a specific simulation version1MT_IDMass Transfer IDnvarchar30
108MDS_OBJSLMDS: OBJSL to a specific simulation version1MT_IDMass Transfer IDnvarchar30
109MDS_POSLIST_VERVersionable positive list db-table1MT_IDMass Transfer IDnvarchar30
110MDS_RES_HEADERResult table for table analysis (Header)1MT_IDMass Transfer IDnvarchar30
111MDS_RES_INFOInformation on a result table run1MT_IDMass Transfer IDnvarchar30
112MDS_RES_OBJECTResult table for table analysis (Object)1MT_IDMass Transfer IDnvarchar30
113MDS_RES_TRKORRResult table for table analysis (Transport)1MT_IDMass Transfer IDnvarchar30
114MDS_TABU_USAGEDMC: TABU Usage1MT_IDMass Transfer IDnvarchar30
115MDS_TRANSP_O_VERIUUC: All transports belonging to a maint ev spec 4 version1MT_IDMass Transfer IDnvarchar30
116MDS_TRKORR_VERall trkorr for a ME -> special buffers like mainimp.buf1MT_IDMass Transfer IDnvarchar30
117MDS_VERSIONMDS: Headertable for analysis versions1MT_IDMass Transfer IDnvarchar30
118MDS_XPRA_USAGEDMC: XPRA Usage1MT_IDMass Transfer IDnvarchar30