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

59 columns | Print definition?ERP 6.0  | SEARCH_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CTS_SAVED_SEARCHCTS Table for Saved Searches7SEARCH_IDGUID in 'CHAR' Format in Uppercasenvarchar320
2CTS_SEARCH_APPLCTS Table for Saved Searches7SEARCH_IDGUID in 'CHAR' Format in Uppercasenvarchar320
3CTS_SEARCH_DESCRCTS Table to manage the Description Text for Saved Searches2SEARCH_IDGUID in 'CHAR' Format in Uppercasenvarchar320
4MDGM_SEARCHFPM Table for saved searches6SEARCH_IDGUID in 'CHAR' Format in Uppercasenvarchar320
5MDGM_SEARCH_APPLFPM Table for saved searches6SEARCH_IDGUID in 'CHAR' Format in Uppercasenvarchar320
6MDGM_SEARCH_DESCFPM Table to manage the description text for saved searches2SEARCH_IDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPApplication Framework
7USMD203CStored Search Criteria (by User and Entity Type)6SEARCH_IDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPBusiness Context Viewer
8/BCV/C_DSBIData Provider BI Query2SEARCH_IDSearch Connector IDnvarchar200
9/BCV/C_DSBPData Provider BAPI2SEARCH_IDSearch Connector IDnvarchar200
10/BCV/C_DSESData Provider Enterprise Search2SEARCH_IDSearch Connector IDnvarchar200
11/BCV/C_DSISData Provider InfoSets2SEARCH_IDSearch Connector IDnvarchar200
12/BCV/C_DSSESData Provider Search Engine Service2SEARCH_IDSearch Connector IDnvarchar200
13/BCV/C_DSWFData Provider Workflow2SEARCH_IDSearch Connector IDnvarchar200
14/BCV/C_DSWSData Provider Web Services2SEARCH_IDSearch Connector IDnvarchar200
15/BCV/C_ESCONEnterprise Search Connectors2SEARCH_IDSearch Connector IDnvarchar200
16/BCV/C_EXPAROutput Parameter2SEARCH_IDSearch Connector IDnvarchar200
17/BCV/C_EXPARTOutput Parameter Description3SEARCH_IDSearch Connector IDnvarchar200
18/BCV/C_INPARInput Parameter2SEARCH_IDSearch Connector IDnvarchar200
19/BCV/C_INPARTInput Parameter Description3SEARCH_IDSearch Connector IDnvarchar200
20/BCV/C_LPBCV Logical port2SEARCH_IDSearch Connector IDnvarchar200
21/BCV/C_QATTRQuery Field7SEARCH_IDInternal ID of Search Connectornvarchar100
22/BCV/C_QSCONQuery Search Connector3SEARCH_IDInternal ID of Search Connectornvarchar100
23/BCV/C_QSCONTQuery Search Connector Description3SEARCH_IDInternal ID of Search Connectornvarchar100
24/BCV/C_SESYSSearch System2SEARCH_IDSearch Connector IDnvarchar200
25/BCV/C_SESYSRSearch System (Reference System)2SEARCH_IDSearch Connector IDnvarchar200
26/BCV/C_SRCHSearch ID2SEARCH_IDSearch Connector IDnvarchar200
27/BCV/C_SRCHTSearch Connector description3SEARCH_IDSearch Connector IDnvarchar200
28/BCV/D_SRCHGSearch Connector: generated reports2SEARCH_IDSearch Connector IDnvarchar200
29/BCV/D_SSTATSearch Execution Statistics2SEARCH_IDSearch Connector IDnvarchar200
TOPCollaboration Folders
30CFX_SEARCHESCFX: List of Search Queries for each User2SEARCH_IDGUID in 'CHAR' Format in Uppercasenvarchar320
31CFX_SEARCHRESCFX: List of Search Results2SEARCH_IDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPDialog SAP-GUI
32BUT_LOCA_CSIDLocator Customizing: Search IDs2SEARCH_IDPrivate: Locator Search IDnvarchar300
33BUT_LOCA_CSIDTLocator Customizing: Search IDs Texts2SEARCH_IDPrivate: Locator Search IDnvarchar300
34BUT_LOCA_PSHISTLocator Personalization: Search History7SEARCH_IDPrivate: Locator Search IDnvarchar300
TOPFloorplan Manager Web Dynpro ABAP
35FPM_SAVED_SEARCHFPM Table for saved searches8SEARCH_IDGUID in 'CHAR' Format in Uppercasenvarchar320
36FPM_SEARCH_DESCRFPM Table to manage the description text for saved searches2SEARCH_IDGUID in 'CHAR' Format in Uppercasenvarchar320
37FPM_SSEARCH_APPLFPM Table for saved searches8SEARCH_IDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPProfitability Analysis
38TKENODE01ACO-PA: Attributes for Node Table TKENODE016SEARCH_IDCO-PA Hierarchy Repository: Type-dependent search argumentnvarchar500
TOPQuery Management
39/PLMPCV/D_QATTRQuery attribute7SEARCH_IDInternal ID of Search Connectornvarchar200
40/PLMPCV/D_QSCONQuery Search Connector3SEARCH_IDInternal ID of Search Connectornvarchar200
41/PLMPCV/D_QSCONTQuery Search Connector Description3SEARCH_IDInternal ID of Search Connectornvarchar200
TOPSearch Integration
42/PLMPCV/C_DSBIData Source BI Query2SEARCH_IDSearch Connector IDnvarchar200
43/PLMPCV/C_DSBPData Source BAPI2SEARCH_IDSearch Connector IDnvarchar200
44/PLMPCV/C_DSESData Source Enterprise Search2SEARCH_IDSearch Connector IDnvarchar200
45/PLMPCV/C_DSSESData Source Search Engine Service2SEARCH_IDSearch Connector IDnvarchar200
46/PLMPCV/C_ESCONEnterprise Search Connectors2SEARCH_IDSearch Connector IDnvarchar200
47/PLMPCV/C_EXPAROutput Parameter2SEARCH_IDSearch Connector IDnvarchar200
48/PLMPCV/C_EXPARTOutput Parameter Description3SEARCH_IDSearch Connector IDnvarchar200
49/PLMPCV/C_INPARInput Parameter2SEARCH_IDSearch Connector IDnvarchar200
50/PLMPCV/C_INPARTInput Parameter Description3SEARCH_IDSearch Connector IDnvarchar200
51/PLMPCV/D_SESYSSearch System2SEARCH_IDSearch Connector IDnvarchar200
52/PLMPCV/D_SESYSRSearch System (Reference System)2SEARCH_IDSearch Connector IDnvarchar200
53/PLMPCV/D_SRCHSearch ID2SEARCH_IDSearch Connector IDnvarchar200
54/PLMPCV/D_SRCHTSearch Connector description3SEARCH_IDSearch Connector IDnvarchar200
55/PLMPCV/D_SSTATSearch Execution Statistics2SEARCH_IDSearch Connector IDnvarchar200
TOPTalent Management
56T5TMCSRC_DESCRTMC CSI: Tab to Manage Description Text for Saved Searches2SEARCH_IDGUID in 'CHAR' Format in Uppercasenvarchar320
57T5TMCSRC_SAVEDTMC CSI: Table for Saved Combined Searches8SEARCH_IDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPUser Interface
58WCF_UST_SEARCHShared saved search4SEARCH_IDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPWeb Service and SOAP - ABAP
59UDDICL_SEARCHUDDI Client: Temporary Store for Search Results(OverviewURL)2SEARCH_IDUDDI Client: Reference ID for Search Queriesnvarchar320