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

58 columns | Print definition?ERP 6.0  | CHABASNM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMSBW_NRSIDNumber range Table for SID3CHABASNM30 Charactersnvarchar300
2RSDBCHATRXXLMaster data XXL attributes1CHABASNMReference characteristicnvarchar300
3RSDDTREXNEWTEXT2CHAVL of new Texts for BWA index (with long chavls)1CHABASNMReference characteristicnvarchar300
4RSMDUCMUKADSOUT DataStore Objects (Advanced): identifying attr. for MUKs4CHABASNMCharacteristicnvarchar300
5RSRNEWSIDS_740SIDs, that are not in the inclusion tables (>= BW 7.40)2CHABASNMReference characteristicnvarchar300
TOPBI Content Analyzer
6RSCONTIOBCHECKATReference table for check incompatible changes Attributes1CHABASNMReference characteristicnvarchar300
TOPBW Service API
7RODCHABW: InfoObjects / Characteristics4CHABASNMReference characteristicnvarchar300
8RODCHABASInfoObjects / basic characteristics in the source system1CHABASNMReference characteristicnvarchar300
9RODCHABGENGenerated objects for the basic characteristic1CHABASNMReference characteristicnvarchar300
10RODTIMBW: Time Characteristics3CHABASNMReference characteristicnvarchar300
11RODUNIBW: Units5CHABASNMReference characteristicnvarchar300
12ROHIEBASAssignment of hierarchy class / domain for basic character.1CHABASNMReference characteristicnvarchar300
13ROMSDIOBJBIW: Assignment of master data attributes to InfoObjects1CHABASNMReference characteristicnvarchar300
14RSHIEOBJHierarchies: Directory of the contained InfoObjects1CHABASNMReference characteristicnvarchar300
15RSMDDELTAAssignment basic characteristic - change pointer1CHABASNMReference characteristicnvarchar300
TOPData Basis
16RSDCHABASDELMSGlikely artefact1CHABASNMReference characteristicnvarchar300
17RSDMDATTRDATERelation: Char. and Key Dates of Time-Dependent Attribute1CHABASNMReference characteristicnvarchar300
18RSDMDENQLocking of master data tables / text tables1CHABASNMReference characteristicnvarchar300
19RSMASLELock Table for Master Data Deletion1CHABASNMReference characteristicnvarchar300
20RSMDDELTAEXTable of Active Master Data Extractors1CHABASNMCharacteristicnvarchar300
21RSMDUCMUKATTRUT Attributes: Identifying attributes for MUKs3CHABASNMCharacteristicnvarchar300
22RSMDUCMUKHIERUT Hierarchy: Identifying attributes for MUKs3CHABASNMCharacteristicnvarchar300
23RSMDUCMUKNLSUT Nearline Infoproviders: identifying attributes for MUKs4CHABASNMCharacteristicnvarchar300
24RSMDUCMUKODSOUT DataStore Objects: identifying attributes for MUKs4CHABASNMCharacteristicnvarchar300
25RSMDUC_TEMPTABNMNames of Temporary tables used in MD Where-Used Check5CHABASNMReference characteristicnvarchar300
TOPData Staging
26RSTRAN_R_IOBJInfoObjects for UnitTest Transformation Runtime3CHABASNMInfoObjectnvarchar300
TOPEnvironment
27CLBWObject types (classes) for info object (BW)1CHABASNMReference characteristicnvarchar300
TOPFinancials Basis
28UGMD2040FIN Master Data: Definition of BW Info Objects8CHABASNMReference characteristicnvarchar300
29UGMD2050FIN Master Data: Active Definition of BW Info Objects7CHABASNMReference characteristicnvarchar300
TOPInformation System
30KAP8_TIMESTBW PS: Time Stamp Tables for Delta Extraction2CHABASNMReference characteristicnvarchar300
TOPMDG for Financials
31USMDZ5201Determination Entity Type Depending on Refer. Characteristic2CHABASNMReference characteristicnvarchar300
32USMDZ5202Determination Entity Type/InfoObject Depending on Ref. Char.2CHABASNMReference characteristicnvarchar300
TOPMetadata Repository
33RSDBCHATRMaster data attributes1CHABASNMReference characteristicnvarchar300
34RSDCHACharacteristic Catalog3CHABASNMReference characteristicnvarchar300
35RSDCHABASBasic characteristics (for chars, XXL, time-chars and units)1CHABASNMReference characteristicnvarchar300
36RSDCHABASLOCBasic chars system-local properties (not transport.)1CHABASNMReference characteristicnvarchar300
37RSDDPAData package characteristics3CHABASNMReference characteristicnvarchar300
38RSDHIECHACharacteristics that occur in hierarchies1CHABASNMReference characteristicnvarchar300
39RSDTIMTime characteristics3CHABASNMReference characteristicnvarchar300
40RSDUNIUnits3CHABASNMReference characteristicnvarchar300
TOPOLAP Technology
41RSDDBMDJOBPROTBIA Master Data Indexing Job Log2CHABASNMReference characteristicnvarchar300
42RSDDCHNGPROTTable with InfoObject whose master table has been changed2CHABASNMReference characteristicnvarchar300
43RSDDTPS_HIER_IDXPolestar Hierarchy Indexes3CHABASNMReference characteristicnvarchar300
44RSDDTPS_IOBJDependency of InfoProvider to Chabasnm2CHABASNMReference InfoObjectnvarchar300
45RSDDTREXCRFIXInfoObjects for BIA Indexes Reindexed After Change Run2CHABASNMReference characteristicnvarchar300
46RSDDTREXNEWMDMD Upload: SIDs for InfoObjects in TREX Aggregates1CHABASNMReference characteristicnvarchar300
47RSDDTREXNEWSIDNew SIDs for InfoObjects in TREX Aggregates1CHABASNMReference characteristicnvarchar300
48RSDDTREXNEWSID_RSID Queue for Backup and Recovery1CHABASNMReference characteristicnvarchar300
49RSDDTREXNEWTEXTCHAVLs of New Text for BIA Index1CHABASNMReference characteristicnvarchar300
50RSRHIEDIR_OLAPOLAP Relevant Information for the Hierarchies8CHABASNMInfoObjectnvarchar300
51RSRHIEDIR_SHORTStructure for Appropriate Lock Object for Hierarchies2CHABASNMReference characteristicnvarchar300
52RSRNEWSIDS(obsolete >= 7.4) SIDs, that are not in the inclusion tables2CHABASNMReference characteristicnvarchar300
TOPProfitability Analysis
53TKEBWLHNote Characteristics When Creating CO-PA Hierarchy DataSrce1CHABASNMReference characteristicnvarchar300
TOPSAP Business Partner
54BUT_HIER_BWSAP BP: Hierarchy Extraction1CHABASNMReference characteristicnvarchar300
TOPWithout Description
55RSDMDACTIVATEActivate Master Data1CHABASNMReference characteristicnvarchar300
56RSENQMDCHAVLLock table for master data upload1CHABASNMReference characteristicnvarchar300
57RSENQMDREQULock table for master data upload1CHABASNMReference characteristicnvarchar300
58RSMASDLock Table for Master Data Deletion1CHABASNMReference characteristicnvarchar300