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

36 columns | Print definition?ERP 6.0  | ATTR_VALUE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPPSSRM/ATTRApplication data of Questionnaire6ATTR_VALUEValue of Dynamic Attributenvarchar1300
2/SAPPSSRM/C_ATTRCustomizing data of Questionnaire6ATTR_VALUEValue of Dynamic Attributenvarchar1300
3BBP_PDDYNDynamic attributes7ATTR_VALUEValue of Dynamic Attributenvarchar1300
4GRACSTDROLEDefault Role4ATTR_VALUEAttribute Valuenvarchar750
5GRFNDMOBJATTRDataMart: Object attributes (multivalue, CDF)7ATTR_VALUELong text for DataMartntext10737418230
6GRFNDMOBJREGATTRDataMart: Object attributes (multivalue, CDF)6ATTR_VALUELong text for DataMartntext10737418230
7GRFNDMRELATTRDataMart: Relational Attributes7ATTR_VALUELong text for DataMartntext10737418230
8J_3RF_ATTR_VALSTAttribute vallues text table15ATTR_VALUEAttribute Valuenvarchar2550
9SCMGLOCAVALSPreset values of locator search fields5ATTR_VALUEAttribute valuenvarchar2550
10STC_SCN_ATTRTask List Generic Attributes3ATTR_VALUEntext10737418230
11TEWA_EL_ATVALTText table for characteristic values5ATTR_VALUECharacteristic Value For Sample Characteristicnvarchar2540
12WGDS_TI_ATTRIBUTPricat Storage for TI related Attributes14ATTR_VALUEGDS TradeItem Preparation Instruction Textnvarchar1320
TOPAuthentication and SSO
13SAML2_TIDCONTable for SAML2 conditions for rule-based username mapping5ATTR_VALUESAML2 attribute valuenvarchar2550
TOPBRFplus - ABAP-Based Business Rules
14FDT_CTLG_0500FDT: Catalog Attribute Values6ATTR_VALUEnvarchar700
15FDT_CTLG_0500AFDT: Catalog Attribute Values6ATTR_VALUEnvarchar700
16FDT_CTLG_0500SFDT: Catalog Attribute Values5ATTR_VALUEnvarchar700
17FDT_CTLG_0500TFDT: Catalog Attribute Values5ATTR_VALUEnvarchar700
18FDT_CTLG_E0500FDT: Enhancement - Catalog Attribute Values6ATTR_VALUEnvarchar700
19FDT_CTLG_E0500SFDT: Enhancement - Catalog Attribute Values5ATTR_VALUEnvarchar700
20FDT_CTLG_E0500TFDT: Enhancement - Catalog Attribute Values5ATTR_VALUEnvarchar700
TOPCommunication Services Mail, Fax, SMS, Telephony
21SRSATGRPRouting Server: AttribGroup Table3ATTR_VALUERouting Attribute Valuenvarchar320
22SRSATGRPTRouting Server: AttribGroup Table Temp3ATTR_VALUERouting Attribute Valuenvarchar320
TOPData Mining
23RSDMTABC_GROUPSDatamining- ABC - Grouping attribute details4ATTR_VALUEModel Field Value (low)nvarchar640
24RSDMTC_DISTRIBUTDistribution of Attribute Values among a Cluster4ATTR_VALUEAttribute Valuesnvarchar640
TOPEnd User Technology
25RSKPI_ATTR_VALValues of KPI Attributes2ATTR_VALUEPredefined Value of KPI Attributenvarchar300
26RSKPI_ATTR_VALTValues of KPI Attributes2ATTR_VALUEPredefined Value of KPI Attributenvarchar300
27RSRD_ATTR_DEPDependencies Between Attributes3ATTR_VALUE30 Charactersnvarchar300
28RSRD_ATTR_VALUEPosible Values for Class Attributes in Broadcasting Framewk3ATTR_VALUE30 Charactersnvarchar300
29RSRD_ATTR_VALUETText Table for RSRD_ATTR_VALUE3ATTR_VALUE30 Charactersnvarchar300
TOPGovernance, Risk and Compliance
30GRFNDMATTRTDataMart: Storage for attribute texts5ATTR_VALUEAttribute value in DMnvarchar400
31GRFNDMREATObsolete: DataMart: Hierarchy9ATTR_VALUELong text for DataMartntext10737418230
TOPPricing
32PRCD_SIM_ATTRPricing Document Attributes (Simulation)6ATTR_VALUEAttribut Value for IPC Pricingnvarchar500
TOPSet Types and Attributes
33COMM_ATTR_DB_TMHTemplate for Database Tables of Multi-Value Attributes6ATTR_VALUEData Element for Templatesnvarchar100
34COMM_ATTR_DB_TMPTemplate for Database Tables of Multi-Value Attributes5ATTR_VALUEData Element for Templatesnvarchar100
TOPWeb Survey
35TUWS_TAROBJ_ATTRSurvey: Recipient Attributes8ATTR_VALUEAttribute Valuenvarchar600
36TUWS_TAROB_C_ATTSurvey: Recipient Attributes8ATTR_VALUEAttribute Valuenvarchar600