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

29 columns | Print definition?ERP 6.0  | SELOPTION

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IXOS/DCRMS_VAIDSelection screen of DocLink for Records Management10SELOPTIONOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
2/OTEB/SWF_TACT2xIM activities remote parameters 28SELOPTIONOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
3/OTEB/SWF_TACT3xIM activities remote parameters 38SELOPTIONOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
4/OTEB/SWF_TMPTA2Temporary storage of /OTEB/SWF_T_TACT2 data for web dynpro9SELOPTIONOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
5/OTEB/SWF_TMPTA3Temporary storage of /OTEB/SWF_T_TACT3 data for web dynpro9SELOPTIONOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
6/OTEB/SWF_TSVALTemporary storage of selection data for documents8SELOPTIONOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
7/OTEI/SWF_TMPTA2Temporary storage of /OTEB/SWF_T_TACT2 data for web dynpro9SELOPTIONOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
8/OTEI/SWF_TMPTA3Temporary storage of /OTEB/SWF_T_TACT3 data for web dynpro9SELOPTIONOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
9/OTEI/SWF_TSVALTemporary storage of selection data for documents8SELOPTIONOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
10T77HRFONL_ABWKOtest for ABWKO7SELOPTIONOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
TOPALE Integration Technology
11TBDMO_DETALE/ CCMS Monitoring Connection: Group Definition Details7SELOPTIONABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPClaims Management
12TIGN222Default Values for Optional Search Criteria for a Search8SELOPTIONABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPControl Plan
13QPCPC_SELRANGECustomizing Table for Selection Area10SELOPTIONType of OPTION component in row type of a Ranges typenvarchar20
TOPCross-Application Components
14/IXOS/DC_TACUSTRAdministration for Customizing, Ranges for user6SELOPTIONnvarchar20
15/IXOS/DC_TCNTSFRRestriction of selection fields at node types10SELOPTIONOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
16/IXOS/DC_TC_NTSRMemorized deleted restrictions of sel. fields at node types12SELOPTIONOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
TOPDefault Risk and Limit System
17ATLARCharacteristic Filter for Limit Types8SELOPTIONSelection operator OPTION for range tablesnvarchar20
18ATLSFDisplay Filters for Limit Characteristics6SELOPTIONSelection operator OPTION for range tablesnvarchar20
19KLTAGENDSF1Table for View Maintenance for End-of-Day Processing6SELOPTIONSelection operator OPTION for range tablesnvarchar20
TOPDenmark
20T5M7KPerson Selection for Payroll Run from T5M7D6SELOPTIONSelection option for current intervalnvarchar20
21T5M7LPayroll acct. area selections for payroll run from T5M7D6SELOPTIONSelection option for current intervalnvarchar20
TOPE-Recruiting
22T77RCF_WL_SEL_OPossible Input Options for Worklists5SELOPTIONSelection Operator (EQ/BT/CP/...)nvarchar20
23T77RCF_WL_SEL_PVValues for Selection Profiles in Worklists7SELOPTIONSelection Operator (EQ/BT/CP/...)nvarchar20
TOPEngineering Change Record
24/PLMI/ECR_PREREQECR - Status Prerequisite customizing table7SELOPTIONSelection Optionnvarchar20
TOPEnvironment, Health and Safety Master Data
25TCGENVEXTEHS: Customizing - Conditions for Parameters9SELOPTIONSelection Optionnvarchar20
TOPGRC Risk Management
26HRP1851DB Table for Infotype 185120SELOPTIONSelection Table Optionnvarchar20
TOPProduct Safety
27CCRCC_FILTEREHS: Data Filtering8SELOPTIONSelection Optionnvarchar20
28TCGBAEHS: BOMBOS - Selection of BOM and BOM Items7SELOPTIONSelection Optionnvarchar20
TOPRisk Analysis
29JBRSICRITRestrictions for Subviews8SELOPTIONOption for ranges tablesnvarchar20