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

44 columns | Print definition?ERP 6.0  | ENTRY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_LIC_MBMulti-Backend connection during counting6ENTRY5 Character Numeric NUMCnvarchar50
2BBP_WFL_TRACEBBP_WFL_TRACE2ENTRYGUID in 'RAW' formatvarbinary160
3BBP_WFL_TRACE1ABBP_WFL_TRACE1A2ENTRYGUID in 'RAW' formatvarbinary160
4BBP_WFL_TRACE1IBBP_WFL_TRACE1I2ENTRYGUID in 'RAW' formatvarbinary160
5BBP_WFL_TRACE1OBBP_WFL_TRACE1O2ENTRYGUID in 'RAW' formatvarbinary160
6BBP_WFL_TRACE_ABBP_WFL_TRACE_A2ENTRYGUID in 'RAW' formatvarbinary160
7BBP_WFL_TRACE_CSBBP_WFL_TRACE_CS2ENTRYGUID in 'RAW' formatvarbinary160
8BBP_WFL_TRACE_IBBP_WFL_TRACE_I2ENTRYGUID in 'RAW' formatvarbinary160
TOPABAP Search Engine for ERP Solution Database
9SRTMLEXENTText Retrieval: Lexicon entries (client-specific)4ENTRYText Retrieval: Lexicon Entrynvarchar300
10SRTMOCCURText Retrieval: Occurence of lex.entry in doc. (client spec)4ENTRYText Retrieval: Lexicon Entrynvarchar300
11SRTVLEXENTText Retrieval: Lexicon entries3ENTRYText Retrieval: Lexicon Entrynvarchar300
12SRTVOCCURText Retrieval: Occurence of lexicon entry in documents3ENTRYText Retrieval: Lexicon Entrynvarchar300
13SRTVSTOPLSList of stop words3ENTRYText Retrieval: Lexicon Entrynvarchar300
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
14CRMRDTPOOLText Pool Items (OBSOLETE)6ENTRYLanguage-dependent text in ABAP/4 text poolnvarchar2550
TOPData Retention Tool
15TXX_ADMI_PARDART-Administration ---Segment-Management---10ENTRYCommentnvarchar500
TOPEmployee Interaction Center
16THREIC_AT_ENTRYPEIC: Activity Tab: Parameter Values2ENTRYEIC: Item for Activity Processing Areasnvarchar320
17THREIC_AT_PROFEEIC: Profile and Value Assignment3ENTRYEIC: Item for Activity Processing Areasnvarchar320
TOPEnd User Technology
18RSBEXTEXTSBW: Web / Report Designer common Customer texts pool3ENTRYLanguage-dependent text in ABAP/4 text poolnvarchar2550
TOPFlexible Real Estate Management
19VICAWBLUSEDUSRLast x Processed Objects per User (for Favorites)3ENTRYSequential Number of Last x Objectstinyint30
TOPInventory Management
20MIGO_CUST_FIELDSMIGO: Field Selection per Movement Type4ENTRYAttribute for field selectionnvarchar10
TOPLocal Currency Changeover
21EWUCLERREMU Cnv: Table for Faulty/Unconverted Entries7ENTRYEMU conversion: Restart argument for terminated conversionnvarchar2550
TOPLocalization
22J_1IEX_CUST_FLDSJ1IEX: Incoming Invoices field selections4ENTRYAttribute for field selectionnvarchar10
23J_3RFTAX_FRMTElectronic Tax Format Version's Entries3ENTRYElectronic Tax Report Entrynvarchar300
24J_3RFTAX_FRMTTText table for Electronic Format Version Entries3ENTRYElectronic Tax Report Entrynvarchar300
TOPNon Profit Organizations
25T7UNCMT_LOGLog Table6ENTRYntext10737418230
TOPOverhead Cost Controlling
26PFPARPeriod-End Partner: Processing Parameters6ENTRYNatural Numberint100
27PFSELPeriod-End Partner: Selection Criteria6ENTRYNatural Numberint100
TOPPlanning
28T8PL01SFFI Planning: Special Handling of Dimensions8ENTRYPossible entry: Single value or intervalnvarchar20
TOPSchedule Manager
29SMPARAMSchedule Manager Monitor: Processing Parameters5ENTRYNatural Numberint100
30SMSELKRITSchedule Manager Monitor: Selection Criteria5ENTRYNatural Numberint100
31SMSPOOLBatch Information for an Entry in the Monitor3ENTRYNatural Numberint100
TOPSCM Basis
32CIFTXTPOOLTable for Storing Additional Integration Model Texts3ENTRYCIF: Text in ABAP/4-Textpool, Lower Case Allowednvarchar2550
TOPStatements
33P01W_DBKRData Module: Remuneration Statement for Sick Pay11ENTRYEmployed Sincenvarchar80
34P01W_DBMUData Module: Statement of Earnings, Maternity Pay10ENTRYEmployed Sincenvarchar80
TOPTraining Management
35HRT5047Table Section Infotype 50474ENTRYInitial Screen for Follow-Upnvarchar10
36LSOFOLLOWUPControl Options for Follow-Up Processing1ENTRYInitial Screen for Follow-Upnvarchar10
37LSOFUPROCESSFollow-Up Procedure2ENTRYInitial Screen for Follow-Upnvarchar10
38LSOLEARNCOMPLE-Signature of Learner13ENTRYLSO Initial Accessnvarchar10
39LSOLEARNESIGNE-Signature of Learner13ENTRYLSO Initial Accessnvarchar10
TOPTravel Planning
40TA20LBEZTree Structure (Current Settings for Travel Planning)3ENTRYTree entrynvarchar80
41TA20LETree Node (Current Settings for Travel Planning)2ENTRYTree entrynvarchar80
42TA20LE1Tree Node (Language-Dependent)3ENTRYTree entrynvarchar80
TOPWorkbench Tools Editors, Painters, Modelers
43EUINFOLIRepository Infosystem: Save background lists9ENTRYCounter for object data in Table EUINFOLISTnvarchar20
TOPWorkplace FrontendMiddleware
44PBLAYOUTLayout Data for Portal Builder (Internal Data)3ENTRYNatural Numberint100