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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

47 columns | Print definition?ERP 6.0  | BLDGR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IAM/C_FSELField Selection and Control3BLDGRField Control Groupnvarchar40
2/IAM/C_FSELAMAdditional modifiable fields3BLDGRField Control Groupnvarchar40
3/IAM/C_FSELMField Selection and Control3BLDGRField Control Groupnvarchar40
4/IAM/C_FSELMLBoolean Expression for Influencing Field3BLDGRField Control Groupnvarchar40
5/IAM/C_FSELNNode Type Assignment to Field Control3BLDGRField Control Groupnvarchar40
6/IAM/C_FSEL_TField Selection and Control - Text Table4BLDGRField Control Groupnvarchar40
7T365Initial values for PM notification transactions5BLDGRScreen groupnvarchar20
8T370Start Values for PM Master Data Transactions5BLDGRScreen groupnvarchar20
9T450PTransaction control for maintaining ind. requirements9BLDGRScreen groupnvarchar20
10TC62Sequence of detail screens when processing header externally5BLDGRScreen groupnvarchar20
11TCS05Transaction-Specific Defaults for BOMs5BLDGRScreen groupnvarchar20
12TK180Default Values per Transaction (Screen Sequence Control)6BLDGRScreen groupnvarchar20
13TKKPAScreen Sequence Control Path5BLDGRScreen groupnvarchar20
TOPBasic Functions
14T180Screen Sequence Control: Transaction Default Values5BLDGRScreen groupnvarchar20
TOPCentral Field Selection
15TFAWField selection: Influencing fields3BLDGRField selection control: Screen groupnvarchar40
16TFAWATables assigned to program and screen group3BLDGRField selection control: Screen groupnvarchar40
17TFAWCField Selection: Field Attribute Changes (User Definition)3BLDGRField selection control: Screen groupnvarchar40
18TFAWLField selection: Definitions of field attribute changes3BLDGRField selection control: Screen groupnvarchar40
19TFAWXField selection: Influencing/influenced field pairs3BLDGRField selection control: Screen groupnvarchar40
20TFAWYFeld selection: pairs influencing/changed fields (End user)3BLDGRField selection control: Screen groupnvarchar40
TOPPeriodical Sales and Distribution
21TJ180Initial Values of Transaction in IS-M5BLDGRScreen groupnvarchar20
22TJ182IS-M: Initial Values for Function Modules (Screen/F.Mod.)5BLDGRScreen groupnvarchar20
TOPProduct Cost Planning
23TCK18Deactivating Functions in Screen Sequence Control2BLDGRScreen groupnvarchar20
TOPProduction Orders
24TCO05CUA status depending on panel, trans. type, funct. type etc.3BLDGRScreen groupnvarchar20
25TCO36PP orders: Control table for calling up pop-up windows2BLDGRScreen groupnvarchar20
26TCO62Defining screen sequences for input facility and verificatn.6BLDGRScreen groupnvarchar20
TOPProject System
27TPICKAnalysis of Function Code PICK2BLDGRScreen groupnvarchar20
TOPRemaining Beverage - Obsolete Objects
28/BEV3/CH180Screen Sequence Control: Transaction Default Values6BLDGRScreen groupnvarchar20
29/BEV3/CHCTS01Selection Tables + Default Selection Fields4BLDGRScreen groupnvarchar20
30/BEV3/CHCTS02Selection Table + Selection Fields4BLDGRScreen groupnvarchar20
31/BEV3/CHCTS03Filter ID and Name4BLDGRScreen groupnvarchar20
32/BEV3/CHRGGEN3Customer No. Rule12BLDGRScreen groupnvarchar20
TOPRouting
33TC01CUA status table3BLDGRScreen groupnvarchar20
34TC02Check whether an FCode is permitted2BLDGRScreen groupnvarchar20
35TC33Allocation of function code to the operation to be checked2BLDGRScreen groupnvarchar20
36TCA36Task lists: Ctrl.tab. for callng. popups from functn.modules3BLDGRScreen groupnvarchar20
37TCA62Defining screen sequences for entry tool6BLDGRScreen groupnvarchar20
38TCA66Screen sequence definition6BLDGRScreen groupnvarchar20
TOPScreen Painter
39TFAWTScreens: Screen Groups for Programs3BLDGRScreen group for screen classificationnvarchar40
TOPScreen Sequence Control
40T185Screen sequence control: Paths between processing locations3BLDGRScreen groupnvarchar20
41T185DScreen Control: Dialog2BLDGRScreen groupnvarchar20
42T185VScreen sequence control: Processing location(s)2BLDGRScreen groupnvarchar20
43T185WScreen Sequence Control: Processing Locations: Texts3BLDGRScreen groupnvarchar20
TOPTime Sheet
44CATS_REC_FIELDSCATS: Table to hold CAC2 column set6BLDGRField selection control: Screen groupnvarchar40
TOPTransaction Manager
45AT185Treasury: Starting Values for Subsequent Screen Control5BLDGRScreen groupnvarchar20
TOPWarranties
46T790Warranty Transaction - Initial Values5BLDGRScreen groupnvarchar20
TOPWork Center
47TC10Initial values for CIM screen sequence4BLDGRScreen groupnvarchar20