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  | MIME_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IAM/C_DOC_MIMEMIME Types for Document Types4MIME_TYPEHTML content typenvarchar1280
2/IWBEP/I_SBD_ATSB: DM Attachments8MIME_TYPEHTML content typenvarchar1280
3/IWBEP/SCARR_MRMedia Resource Table (based on SFLIGHT table SCARR)3MIME_TYPEntext10737418230
4/MRE/DOCTYPEV_NMobile Retail Attachment Type Extraction Values3MIME_TYPEMIME Content Typenvarchar1280
5/OTX/RM_GOS_DDCustomizing document display in BCW1MIME_TYPEMime typenvarchar2550
6/OTX/RM_GOS_DD_CCustomer table for customizing document display in BCW1MIME_TYPEMime typenvarchar2550
7/SLOAP/STORAGESLOAS storage control table4MIME_TYPESLOAS mime typentext10737418230
8/SLOAP/STORAGETtransport table for /SLOAS/STORAGE6MIME_TYPESLOAS mime typentext10737418230
9/XFT/DOCMTYPEMime Types3MIME_TYPEMIME typentext10737418230
10/XFT/STLSSTRATxft StorageLink: Ablagestrategie5MIME_TYPEMIME-Typnvarchar1280
11ABAP_ONLINE_COMABAP Online Community: Data exchange4MIME_TYPEABAP Online Community: Mime typenvarchar2550
12CMCBD_FILE_DATACash Budgeting file data table3MIME_TYPEMIME Typenvarchar300
13DDMIMETYPESMime Types (for Full-Text Index)1MIME_TYPEDD: Mime Type for Full-Text Indexnvarchar1270
14DDMIMETYPES_TMime Types (for Full-Text Index)1MIME_TYPEDD: Mime Type for Full-Text Indexnvarchar1270
15EDOFILETYPEeDocument: File Types per Country3MIME_TYPEeDocument: MIME Content Typenvarchar2550
16ESH_TAU_FL_HFile Loader HANA Test5MIME_TYPEMime Type (EPM File Loader HANA)ntext10737418230
17MDG_GW_ATTACHMNTTemporary Table Fiori File Attachment Contents2MIME_TYPEMime Typenvarchar1280
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
18DD12LR/3 S_SECINDEX: secondary indexes, header;22MIME_TYPEDD: Mime Type for Full-Text Indexnvarchar1270
TOPBasis Components
19/XFT/INV_VIEW02Administration table for buffer table8MIME_TYPE128 characternvarchar1280
TOPCase Management
20SRMMIMESPSTable of Possible SPS IDs for File Extensions2MIME_TYPEWebDAV: Mime Typenvarchar320
TOPClinical System
21N2COMM_LOGDocuments Received in Temporary Storage21MIME_TYPEMIME Typenvarchar500
TOPE-Recruiting
22T77RCF_DOC_FMTDocument Formats4MIME_TYPEHTML content typenvarchar1280
TOPeCATT Extended Computer Aided Test Tool
23ECWD_RESOURCESeCATT: Database Table for WD Resources (HTML)3MIME_TYPEntext10737418230
TOPEnd User Technology
24RSRDE_DOC_CONTDocuments for Broadcasting: Content4MIME_TYPEMIME Type in the Broadcasting Frameworknvarchar1280
25RSRD_ER_DOCLAYException Report: Definition of Layout (XML Conversion)6MIME_TYPEMIME Type in the Broadcasting Frameworknvarchar1280
TOPLean Staffing
26TSAWE_TRANSFORMStaff Assignment Definition for Transformation5MIME_TYPEStaff Assignment Mime Typenvarchar120
TOPMetadata Repository
27RSDCHABASBasic characteristics (for chars, XXL, time-chars and units)53MIME_TYPEMIME Content Typenvarchar1000
TOPNetWeaver Demonstration
28SNWD_ECMAEPM: Table for Enterprise Content Management attachments10MIME_TYPEHTML content typenvarchar1280
TOPNetWeaver Enterprise Search
29ESH_ADM_BIN_ERRdetail table for error protocol in case of binary data20MIME_TYPEntext10737418230
TOPRecruitment
30T750RPermitted document formats for internet applications2MIME_TYPEHTML content typenvarchar1280
TOPReusable Components of Business Suite Foundation
31/BOBF/C_ATFMIMEMIME Types allowed for upload5MIME_TYPEMIME Content Typenvarchar1000
32/BOBF/C_ATF_MIMEMIME Types allowed for upload2MIME_TYPEMIME Content Typenvarchar1000
TOPSales and Distribution
33/MRE/DOCTYPEVMobile Retail Attachment Type Extraction Values3MIME_TYPEFile Name Extensionnvarchar640
34/MRE/DOCTYPSVMobile Retail Attachment Type Selection Values3MIME_TYPEFile Name Extensionnvarchar640