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

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SYCLO/WB001VDevTool: Screen field value table2VALUE_IDDevTool: Value unique identifiernvarchar320
2DODP_FIELD_VALUEDBOS-DP: Data Provider Field Value6VALUE_IDDBOS Cockpit: IDnvarchar320
3DOUI_ELEM_VALUEDBOS Cockpit: Screen Element Values5VALUE_IDDBOSC-CR: Generated ID (30)nvarchar300
4TEWA_EL_ATVALMaintenance Of Characteristic Values Per Characteristic3VALUE_IDIdentifier Of Characteristic Valuenvarchar100
5TEWA_EL_ATVALTText table for characteristic values4VALUE_IDIdentifier Of Characteristic Valuenvarchar100
TOPBRFplus - ABAP-Based Business Rules
6FDT_ACTN_6110FDT: Action - Start Workflow Container data7VALUE_IDFDT: Universal Unique Identifiernvarchar320
7FDT_ACTN_6110AFDT: Action - Start Workflow Container data7VALUE_IDFDT: Universal Unique Identifiernvarchar320
8FDT_ACTN_6110SFDT: Action - Start Workflow Container data6VALUE_IDFDT: Universal Unique Identifiernvarchar320
9FDT_ACTN_6110TFDT: Action - Start Workflow Container data6VALUE_IDFDT: Universal Unique Identifiernvarchar320
10FDT_ACTN_6200FDT: Action - Raise Event8VALUE_IDFDT: Universal Unique Identifiernvarchar320
11FDT_ACTN_6200AFDT: Action - Raise Event8VALUE_IDFDT: Universal Unique Identifiernvarchar320
12FDT_ACTN_6200SFDT: Action - Raise Event7VALUE_IDFDT: Universal Unique Identifiernvarchar320
13FDT_ACTN_6200TFDT: Action - Raise Event7VALUE_IDFDT: Universal Unique Identifiernvarchar320
14FDT_ACTN_6210FDT: Action Raise Event Container Data7VALUE_IDFDT: Universal Unique Identifiernvarchar320
15FDT_ACTN_6210AFDT: Action Raise Event Container Data7VALUE_IDFDT: Universal Unique Identifiernvarchar320
16FDT_ACTN_6210SFDT: Action Raise Event Container Data6VALUE_IDFDT: Universal Unique Identifiernvarchar320
17FDT_ACTN_6210TFDT: Action Raise Event Container Data6VALUE_IDFDT: Universal Unique Identifiernvarchar320
TOPData Mining
18RSDMTC_ATTR_DTLAttribute Detail3VALUE_IDValue ID for Attr_name & Value combinationnvarchar50
19RSDMTC_MEAN_DTLMean Detail4VALUE_IDValue ID for Attr_name & Value combinationnvarchar50
20RSDMTD_ATTRFREQClass Frequency of Learnt Data3VALUE_IDEnumerated Valuenvarchar50
21RSDMTD_ATTRVALAttribute Value List3VALUE_IDEnumerated Valuenvarchar50
22RSDMTPN_COL_PARAParameters for the Model Columns4VALUE_IDParameter Value GUIDnvarchar300
23RSDMTPN_MOD_PARAParameters for the Model3VALUE_IDParameter Value GUIDnvarchar300
24RSDMTP_COL_PARAMParameters for the Model Columns4VALUE_IDParameter Value GUIDnvarchar300
25RSDMTP_MOD_PARAMParameters for the Model3VALUE_IDParameter Value GUIDnvarchar300
TOPE-Recruiting
26T77RCF_INFDATData from Questionnaire4VALUE_IDField Value Identifiernvarchar30
27T77RCF_MAPVALField Values3VALUE_IDField Value Identifiernvarchar30
28T77RCF_MAPVAL_TField Values4VALUE_IDField Value Identifiernvarchar30
29T77RCF_MBO_ATTRAttributes of MBO Objects7VALUE_IDField Value Identifiernvarchar30
TOPReusable Components of Business Suite Foundation
30/BOFU/FDTEXP103Expression BO Retrieve: Assoc Filter Values(client specific)7VALUE_IDFDT: Universal Unique Identifiernvarchar320
31/BOFU/FDTEXP103AExpression BO Retrieve: Assoc Fltr Val (MasterData: ClientDe7VALUE_IDFDT: Universal Unique Identifiernvarchar320
32/BOFU/FDTEXP103SExpression BO Retrieve: Assoc Filter Values (system)6VALUE_IDFDT: Universal Unique Identifiernvarchar320
33/BOFU/FDTEXP103TExpression BO Retrieve: Assoc Filter Values (BCF)6VALUE_IDFDT: Universal Unique Identifiernvarchar320
TOPTable Analysis
34ARDB_STAT1Table Analysis: Executed Analyses - Number per Data Set1VALUE_IDTable Analysis: Value ID within Database Analysisvarbinary160
35ARDB_STAT2Table Analyses: Executed Analyses - Fields of a Data Set1VALUE_IDTable Analysis: Value ID within Database Analysisvarbinary160
TOPWithout Description
36RSDMTA_ENUM_INFOLIS table Information3VALUE_IDItem IDnvarchar100