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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

43 columns | Print definition?ERP 6.0  | REFTABLE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVCMIS_A_1_TABFSelection of Object Type TABLE (TABF) Master information16REFTABLETable for reference fieldnvarchar300
2CNVCMIS_A_20_DICTable fields for Cross-Client Customizing Comparison12REFTABLEReference Fields Tablenvarchar300
3CNVMBTTABSTRUCField list of tables for file transfer19REFTABLETable for reference fieldnvarchar300
4DD03NDDD: Attributes of a Node of a Structured Object12REFTABLETable for reference fieldnvarchar300
5DDREPLICREFDD: Information on Metadata Transfer: Fields8REFTABLETable for reference fieldnvarchar300
6DDREPLINTABFDDD: Nametab Field Structure23REFTABLETable for reference fieldnvarchar300
7DDXTF_CONV_UCNametab Feldstruktur für verzögertes Schreiben22REFTABLEReferenztabelle zum Feldnvarchar300
8DDYTF_CONV_UCUsed during UCMIG within DMO of SUM22REFTABLETable for reference fieldnvarchar300
9IUUC_DD_SYNC_NTFSystem synchronization: Nametab field data26REFTABLETable for reference fieldnvarchar300
10IWP_DP_CURR_REFCURR and CUKY Ref table and Ref field mapping for legacy tab4REFTABLETable name, 16 charactersnvarchar160
TOPABAP Authorization and Role Management
11TBRG_OBJObjects with Cross-Client Authorization Groups4REFTABLETable for Authorization Groupsnvarchar300
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
12CRMLOGATrace Areas (OSOLETE)4REFTABLETable Namenvarchar300
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
13DD03LTable Fields13REFTABLETable for reference fieldnvarchar300
14DDXTFNametab Field Structure for Delayed Writing22REFTABLETable for reference fieldnvarchar300
TOPCross-Application Components
15/IXOS/DC_TAHAHitlist Administrator maintenance (hierachy/separat)21REFTABLETable for reference fieldnvarchar300
16/IXOS/DC_TAHUHitlist User maintenance (hierachy/separat)23REFTABLETable for reference fieldnvarchar300
17/IXOS/DC_TAMAGeneral Doculink administraton data for data source16REFTABLETable for reference fieldnvarchar300
18SPRTL1Assignment of Business Objects to Data Elements5REFTABLE30 Charactersnvarchar300
19SPRTL1CAssignment of Business Objects to Data Elements (Runtime)6REFTABLE30 Charactersnvarchar300
TOPData Basis
20RSBTRANSFIELDTarget Structure InfoObjects for Open Hub Transformation6REFTABLETable for reference fieldnvarchar300
TOPData Staging
21RSTSODSFIELDFields for the Operational Data Store15REFTABLETable for reference fieldnvarchar300
TOPFinancials Basis
22UGR31008FIN Master Data: Dummy Field Names with Properties17REFTABLETable for reference fieldnvarchar300
23UGR31022FIN Master Data: Buffer Table f.Fields of Extract Structures15REFTABLETable for reference fieldnvarchar300
TOPFlexible Real Estate Management
24TIVCAECRE-FX: Currency Conversion - Relevant Tables and Fields13REFTABLETable Namenvarchar300
TOPIncentive and Commission Management ICM
25TCACS_ADDFIELDSObsolete - replaced by TCACS_DESFIELDS6REFTABLETable for reference fieldnvarchar300
26TCACS_CUSTFIELDSObsolete - replaced by TCACS_ADDFIELDS7REFTABLETable for reference fieldnvarchar300
27TCACS_DESFIELDSAdditional Fields for Generated Objects9REFTABLETable for reference fieldnvarchar300
28TCACS_EUConversion Rule: Tables and Fields in FS-ICM5REFTABLETable in FS-ICMnvarchar300
TOPLocal Currency Changeover
29EWUCUPAKETContains the individual packages for user-defined objects5REFTABLETable for reference fieldnvarchar300
TOPLogical Database Builder
30LDBQUANCurrency and quantity fields in logical database4REFTABLETable for reference fieldnvarchar300
TOPMaster Data
31EPDPRODHIS-U Master data Generator: Master Data Template Hierarchy8REFTABLETable for MDT (for Triggering Customer Append Str.)nvarchar300
32EPDTYPEIS-U Master Data Generator: Master Data Template Category14REFTABLETable for MDT (for Triggering Customer Append Str.)nvarchar300
TOPTreasury
33CML_MIG_BUFFERTable DDIC buffering (migration)17REFTABLETable for reference fieldnvarchar300
TOPUpgrade - General
34DDMTFNametab Field Structure for Delayed Writing22REFTABLETable for reference fieldnvarchar300
35DDMTF_ISUNametab Field Structure for Delayed Writing22REFTABLETable for reference fieldnvarchar300
36DDMTF_SAVNametab Feldstruktur für verzögertes Schreiben22REFTABLEReferenztabelle zum Feldnvarchar300
37DDXTF_SAVNametab Feldstruktur für verzögertes Schreiben22REFTABLEReferenztabelle zum Feldnvarchar300
38DDXTF_SHDNametab Feldstruktur für verzögertes Schreiben22REFTABLEReferenztabelle zum Feldnvarchar300
39DDXTF_STDNametab Feldstruktur für verzögertes Schreiben22REFTABLEReferenztabelle zum Feldnvarchar300
40DDYTFSubstitution Nametab (shadow-shadow-nametab for DDXTF)23REFTABLE4.0 version of TABNAME (name extension)nvarchar300
TOPUpgrade Tools
41ICNV31LNametab for Incremental Conversion24REFTABLEnvarchar300
TOPUser and Authorization Management
42AUTH_FLDINFO_TMPAuthorization fields: technical info from dictionary13REFTABLETable for reference fieldnvarchar300
TOPWorkbench Utilities
43SPAR_NTDBParameter Storage: Persistent Nametab Container20REFTABLETable for reference fieldnvarchar300