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

34 columns | Print definition?ERP 6.0  | DTELNM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBW Service API
1RODCHABW: InfoObjects / Characteristics3DTELNMData Elementnvarchar300
2RODKYFBW: Key Figures3DTELNMData Elementnvarchar300
3RODTIMBW: Time Characteristics2DTELNMData Elementnvarchar300
4RODUNIBW: Units3DTELNMData Elementnvarchar300
5ROOHIECOMCompound Information for Hierarchy DS in Source System6DTELNMData element (semantic domain)nvarchar300
TOPClient-System Adapter
6MDMEXTRFLDMDM Field Table for Extraktor Metadata7DTELNMData Elementnvarchar300
TOPData Basis
7RSBOHFIELDSFields of the Open Hub Destination18DTELNMData element (semantic domain)nvarchar300
TOPData Staging
8RSDSSEGFDDataSource - Segment Fields7DTELNMData Elementnvarchar300
9RSDSSEGFDSHDataSource in BW - Shadow Table Fields7DTELNMData Elementnvarchar300
10RSISFIELDSHShadow table: InfoSource fields8DTELNMData Elementnvarchar300
11RSISOFIELDInfoSource fields (provider structure of a source system)8DTELNMData Elementnvarchar300
12RSKSFIELDNEWFields for New InfoSource8DTELNMData Elementnvarchar300
13RSKSFIELDSHShadow table: Communication structure fields6DTELNMData Elementnvarchar300
14RSOLTPHIECOMReplicate of Compounding Info. for Hier.-DataSource in BW7DTELNMData Elementnvarchar300
15RSOLTPSOURCEFDSHShadow Table: OLTP Source Fields7DTELNMData Elementnvarchar300
16RSOLTPSOURCEFIEOLTP Source Fields7DTELNMData Elementnvarchar300
17RSOLTPSOURCESFISegment Fields of a DataSource8DTELNMData Elementnvarchar300
18RSOSATTFDSHShadow table: InfoSource attributes8DTELNMData Elementnvarchar300
19RSOSFIELDSHShadow table: InfoSource fields8DTELNMData Elementnvarchar300
20RSOSOATTFDInfoSource attributes of a source system8DTELNMData Elementnvarchar300
21RSOSOFIELDInfoSource fields of a source system7DTELNMData Elementnvarchar300
22RSTRFIELDSHShadow table: Transfer Structure Fields8DTELNMData Elementnvarchar300
23RSTSFIELDTransfer structure fields6DTELNMData Elementnvarchar300
24RSTSFIELDSHShadow table: Transfer structure fields8DTELNMData Elementnvarchar300
25RSTSIDOCFIELDFields for the IDoc Operational Data Store6DTELNMData Elementnvarchar300
26RSTSODSFIELDFields for the Operational Data Store7DTELNMData Elementnvarchar300
TOPFinancials Basis
27UGR31021FIN Master Data: Buffer Table for DataSource Properties14DTELNMData element (semantic domain)nvarchar300
TOPMetadata Repository
28RSDIOBJFIXDelivered Fixed System InfoObjects5DTELNMData element (semantic domain)nvarchar300
29RSOTLOGOSEARATRSearchable attributes for Object Types4DTELNMData Element (For the Text of the Search Attribute)nvarchar300
TOPOLAP Technology
30RSBBSCUBEMAPPINGFixed Mapping for BW-R/RI7DTELNMData element (semantic domain)nvarchar300
31RSBBSQRYMAPPINGFixed Mapping for BW-R/RI8DTELNMData element (semantic domain)nvarchar300
TOPReport Selection for Product Costing
32TKKREHierarchy Summarization (Summarization Characteristics)3DTELNMData Element of a Summarization Characteristic / CO Summariznvarchar300
TOPSAP Business Partner
33MDMEXTRFLD_PREFMDM Field Table Extractor Metadata (Copy)7DTELNMData Elementnvarchar300
TOPWithout Description
34RSKSFIELDFields of the communication structure6DTELNMData Elementnvarchar300