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

45 columns | Print definition?ERP 6.0  | ATTR_NAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/PWSC_CONATTContact Attribute3ATTR_NAMEContact Profile Attributesnvarchar300
2/CPD/PWSC_GRATTRReporting Attribute Profile3ATTR_NAMEReporting Attributenvarchar300
3/CPD/PWSC_OATLObject Attribute Object Link Table4ATTR_NAMEReporting Attributenvarchar300
4/CPD/PWSC_OATRObject Attribute Link Attribute Name Link Table4ATTR_NAMEReporting Attributenvarchar300
5/CPD/PWSC_OATTLObject Attribute Object Link Table8ATTR_NAMEReporting Attributenvarchar300
6/CPD/PWSC_RA_DEPDependencies Across Reporting Attribute2ATTR_NAMEReporting Attributenvarchar300
7/CPD/PWSC_RA_DPDdependency table for reporting attributes3ATTR_NAMEReporting Attributenvarchar300
8/FLDQ/AD_DUP_FLDFields to use during duplicate check, per data model3ATTR_NAMEAttributenvarchar90
9/FLDQ/AD_DUP_MTCTable to hold match code configuration for a data model3ATTR_NAMEAttributenvarchar90
10/OTX/AL_ATTRMAPMapping table for external attributes3ATTR_NAMEField Namenvarchar300
11BBPD_CMS_ATTABLegal Attributes2ATTR_NAMEAttribute Namenvarchar600
12BBPD_CMS_ATTAB_TText Table for BBPD_CMS_ATTAB (Legal Attibutes Table)3ATTR_NAMEAttribute Namenvarchar600
13FUCN_AMOUNT_RGRange table for amount2ATTR_NAMEnvarchar500
14LWMRECQUATTRSAP Receivables Manager - Key Figure Attributes2ATTR_NAMEAttribute Namenvarchar300
15LWMRECQUATTRTSAP Receivables Manager - Key Figures Attributes (Texttable)3ATTR_NAMEAttribute Namenvarchar300
16N1SE_INDEX_ATTRISHMED: Search Index Attributes5ATTR_NAME30 Charactersnvarchar300
17STC_SCN_ATTRTask List Generic Attributes2ATTR_NAMEnvarchar320
18TFW_PRED_LIBRARYPredicate Library5ATTR_NAMEAttribute name of a predicatenvarchar2550
19UCF7600Data Transfer: Buffer Attributes When Loading from Stream5ATTR_NAMEField Namenvarchar300
20WGDS_TI_ATT_QU_TText Table for WGDS_TI_ATTR_QUA Table4ATTR_NAMEGDS TradeItem XML Attribute Namenvarchar1320
TOPAnalysis Process Designer
21RSANT_PRP_TREXCAPD Provider Runtime - TREX Component Descriptions8ATTR_NAMEAttribute namenvarchar640
TOPAuthentication and SSO
22SAML2_TIDCONTable for SAML2 conditions for rule-based username mapping4ATTR_NAMESAML2 attribute namenvarchar2550
TOPData Mining
23RSDMTABC_GROUPSDatamining- ABC - Grouping attribute details3ATTR_NAMEModel Field Namenvarchar300
TOPData Quality
24MDG_DQ_CONF_DCConfiguration table for duplicate check - Data Quality5ATTR_NAMEResolved Attribute for Duplicate Checknvarchar160
TOPDocument Builder
25/IPRO/TA_ATTABAttributes in xml document for an application2ATTR_NAMECommentnvarchar500
26/IPRO/TA_ATTAB_TAttributes in xml document for an application3ATTR_NAMECommentnvarchar500
TOPEnterprise Search Integration
27WCFD_ES_BOL_QPARAssign parameters to BOL extraction query6ATTR_NAMEComponent namenvarchar300
TOPFast Search Infrastructure
28SFSG_Q_CONDQuery Condition7ATTR_NAMEntext10737418230
29SFSG_Q_GROUPQuery Group4ATTR_NAMEntext10737418230
30SFSRFW_JDX_JVReplication Framework - Join View Attributes6ATTR_NAMEReplication Framework - Attribute Name on TREX-Sidenvarchar640
TOPGeneric Interaction Layer
31CRMC_DQ_ATTROPOperators for advanced query attributes3ATTR_NAMEComponent namenvarchar300
32GIL_EN_DQ_ATTROPOperators for advanced query attributes3ATTR_NAMEComponent namenvarchar300
TOPGovernance, Risk and Compliance
33GRFNDMREATObsolete: DataMart: Hierarchy8ATTR_NAMEReport: Field IDnvarchar300
TOPOLAP Technology
34RRAMBIAIOBJAnalytical Model: Mapping of InfoObject to TREX Attributes3ATTR_NAMEAttribute namenvarchar640
TOPPricing
35PRCD_SIM_ATTRPricing Document Attributes (Simulation)5ATTR_NAMEAttribute Name for IPC Pricingnvarchar300
TOPRecords and Case Management
36RMPSBPFIELDMAPMapping IP Attributes to Fields of Business Partner3ATTR_NAMEAttribute of a document or a relationshipnvarchar250
TOPSoftware Agent Framework
37CRMC_SAF_WP_RULESAF: Rules for work package11ATTR_NAMESAF: Attribute name for knowledge repositorynvarchar2550
TOPText Retrieval and Information Extraction
38STRX_IXDASDocument Attributes for Indexing2ATTR_NAMEAttribute Namenvarchar640
39STRX_IXPTSProperties of Logical Index2ATTR_NAMEAttribute Namenvarchar640
TOPTransport Management System
40TMSQAMTRETTMS: Assigning Message to Tree Nodes in Alert Monitor- Texts5ATTR_NAMETMS QA: Short Name of Monitoring Typenvarchar400
TOPTREX Search Engine Service
41COM_SE_CPOINTERSES: Change Pointer for Business Objects8ATTR_NAMEName of Changed Attributes or the Attribute Groupnvarchar640
TOPUse Subcomponents
42SODSATSTLDAP Attributes for Office Transmission Methods1ATTR_NAMEAttribute Namenvarchar630
TOPWeb Service and SOAP - ABAP
43SRT_CFG_LOG_SRCHSRT Logging: Search Table for Attributes5ATTR_NAMESRT Logging: Search Attribute Namenvarchar300
TOPWeb Survey
44TUWS_TAROBJ_ATTRSurvey: Recipient Attributes7ATTR_NAMEAttribute Namenvarchar600
45TUWS_TAROB_C_ATTSurvey: Recipient Attributes7ATTR_NAMEAttribute Namenvarchar600