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

35 columns | Print definition?ERP 6.0  | EXPRESSION_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FDT_DDBV_0020BRFplus: Dynamic Database View - Result Field Definition7EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
2FDT_DDBV_0020ABRFplus: Dynamic Database View - Result Field Definition7EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
3FDT_DDBV_0020SBRFplus: Dynamic Database View - Result Field Definition6EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
4FDT_DDBV_0020TBRFplus: Dynamic Database View - Result Field Definition6EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
TOPBRFplus - ABAP-Based Business Rules
5FDT_ACTN_1110FDT: Action - Static method call parameters4EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
6FDT_ACTN_1110AFDT: Action - Static method call parameters4EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
7FDT_ACTN_1110SFDT: Action - Static method call parameters3EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
8FDT_ACTN_1110TFDT: Action - Static method call parameters3EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
9FDT_EXPR_0230FDT: Expression - Decision Tree (Nodes)8EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
10FDT_EXPR_0230AFDT: Expression - Decision Tree (Nodes)8EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
11FDT_EXPR_0230SFDT: Expression - Decision Tree (Nodes)7EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
12FDT_EXPR_0230TFDT: Expression - Decision Tree (Nodes)7EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
13FDT_EXPR_0242FDT: Expression - Decision Table (Cells)6EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
14FDT_EXPR_0242AFDT: Expression - Decision Table (Cells)6EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
15FDT_EXPR_0242SFDT: Expression - Decision Table (Cells)5EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
16FDT_EXPR_0242TFDT: Expression - Decision Table (Cells)5EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
17FDT_EXPR_1505FDT: Expression - Static Method Parameters4EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
18FDT_EXPR_1505AFDT: Expression - Static Method Parameters4EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
19FDT_EXPR_1505SFDT: Expression - Static Method Parameters3EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
20FDT_EXPR_1505TFDT: Expression - Static Method Parameters3EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
21FDT_EXPR_E0242FDT: Enhancement for Decision Table - Cell data6EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
22FDT_EXPR_E0242SFDT: Enhancement for Decision Table - Cell data5EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
23FDT_EXPR_E0242TFDT: Enhancement for Decision Table - Cell data5EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
24FDT_FNCT_0100FDT: Function - Attributes5EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
25FDT_FNCT_0100AFDT: Function - Attributes5EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
26FDT_FNCT_0100SFDT: Function - Attributes4EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
27FDT_FNCT_0100TFDT: Function - Attributes4EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
28FDT_RLST_1000FDT: RuleSet - Rules11EXPRESSION_IDnvarchar320
29FDT_RLST_1000AFDT: RuleSet - Rules11EXPRESSION_IDnvarchar320
30FDT_RLST_1000SFDT: RuleSet - Rules10EXPRESSION_IDnvarchar320
31FDT_RLST_1000TFDT: RuleSet - Rules10EXPRESSION_IDnvarchar320
TOPReusable Components of Business Suite Foundation
32/BOFU/FDTEXP201Expression BO Data Extraction(Deep)5EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
33/BOFU/FDTEXP201AExpression BO Data Extraction(Deep)5EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
34/BOFU/FDTEXP201SExpression BO Data Extraction(Deep)4EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320
35/BOFU/FDTEXP201TExpression BO Data Extraction(Deep)4EXPRESSION_IDFDT: Universal Unique Identifiernvarchar320