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

114 columns | Print definition?ERP 6.0  | DESTINATION

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWBEP/SU_ERRLOGSUTIL Error Log31DESTINATIONnvarchar320
2/IWFND/SU_ERRLOGSUTIL Error Log31DESTINATIONnvarchar320
3/IWFND/SU_TPERFSUTIL Performance Trace21DESTINATIONnvarchar320
4/IWFND/SU_TPLOADSUTIL Payload Trace19DESTINATIONnvarchar320
5/SDF/MON_CALLFunction Call of /SDF/MON2DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
6/SDF/MON_CALLPARFunction Calls of /SDF/MON parameters3DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
7BWSD_LOGDStatus Information for Individual Transfer Locations5DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
8CNVMBTSTATEStatus table for execution of all activities and history13DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
9CNVMBTSUBSTATEStatus table for execution of all subactivities and histor12DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
10CNV_10940_RUN_IDSearch Run IDs created in Sol Man for RVS9DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
11DMC_STRUC_IDMWB: Mapping Structure/ Append for Unique Identifier1DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
12IDXLOGIDoc Adapter RFC Logging6DESTINATIONRFC destinationnvarchar320
13IUUC_DDSND_IDMWB: Mapping Structure/ Append for Unique Identifier1DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
14RFCCBWHITELISTWhitelist for RFC Callbacks1DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
15RFCCBWHITELIST_APositive List for RFC Callbacks1DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
16SAPACOREPOSITORYRepository for SAP ABAP Connector2DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
17SRT_SEQ_QUE_LOCKSRT_Queue lock data6DESTINATIONRFC destinationnvarchar320
18UCONSERVASDESTUnified Connectivity Service Assembly Header3DESTINATIONUnified Connectivity Service Assembly IDnvarchar300
19UCONSTATMONITORAStorage of UCON Statistics Data (Cross Client; aggregated)11DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
20ZSPOM_EE_TIMEService Provider - Order Management Scenario EE time2DESTINATIONCharacter Field Length = 10nvarchar100
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
21SATC_AC_STATE_RFMovement data: RFC invocations2DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
TOPAccounting - General
22TFC_INST_HDRHeader Information on Status Admin for Fast Close17DESTINATIONExtSdl: Name of Destination for External Schedulernvarchar320
23TFC_TEMPL_HDRHeader Information on Status Admin for Fast Close17DESTINATIONExtSdl: Name of Destination for External Schedulernvarchar320
TOPAuthentication and SSO
24SAML2_ENT_SRVCSAML2 Service Definition for Each Entity7DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
TOPBackground RFC bgRFC
25BGRFC_CUST_I_DSTInbound Scheduler/Application Server Customizing1DESTINATIONName of Destination in Inbound Casenvarchar320
26BGRFC_CUST_SUPERCustomizing for bgRFC Supervisor Destinations2DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
27BGRFC_MAIN_I_DSTMaintain Inbound Destinations1DESTINATIONName of Destination in Inbound Casenvarchar320
28BGRFC_SRV_STATEServer Status of bgRFC Units3DESTINATIONName of Destination in Outbound Casenvarchar320
29QRFC_CUST_I_DESTInbound Scheduler / New/Old API Customizing2DESTINATIONName of Destination in Inbound Casenvarchar320
TOPBRFplus - ABAP-Based Business Rules
30FDT_BRMS_CONN_1FDT: BRMS Connection Type Settings4DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
31FDT_EXPR_4000FDT: BRMS Connector Connection attributes5DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
32FDT_EXPR_4000AFDT: BRMS Connector Connection attributes5DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
33FDT_EXPR_4000SFDT: BRMS Connector Connection attributes4DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
34FDT_EXPR_4000TFDT: BRMS Connector Connection attributes4DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
TOPBusiness Partner
35FSBPC_PRX_CPATHCustomizing Communication Path3DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
36TP44Logical Systems3DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
TOPBusiness Rule Framework
37TBRF370BRF: External Rule Engine Integration (XREI)8DESTINATIONXREI-XI: Target System (for RFC)nvarchar320
TOPBW Service API
38ROPC_BORProcess Chains Started (Workflow)3DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
39ROPC_WFBORWorkflow Processes Started3DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
TOPClaims Management
40ICL_ACTN_1000BRFplus : Tasks (Customizing)21DESTINATIONDetermination of CMC Textnvarchar10
41ICL_ACTN_1000ABRFplus : Tasks (Application)21DESTINATIONDetermination of CMC Textnvarchar10
42ICL_ACTN_1000SBRFplus : Tasks (System)20DESTINATIONDetermination of CMC Textnvarchar10
43ICL_CRFCDESTMaintenance: RFC Targets4DESTINATIONTarget System of RFCnvarchar320
44TICL928For BRF: Tasks/Prompting Action7DESTINATIONDetermination of CMC Textnvarchar10
45TICL929For BRFplus: Texts for Tasks Action (TICL928)8DESTINATIONDetermination of CMC Textnvarchar10
TOPClinical System
46TN2FO_APPLXSLFO: DocCateg. Use (XSLPROGRAM Is Language-Dependent)7DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
47TN2SAPFTPControl Parameter for SAPFTP3DESTINATIONHost destinationnvarchar80
TOPCollaborative Cross Applications
48/POA/C_CLM_SYRSystem Registry Tables6DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
49/POA/D_CLM_DPLMDeployment5DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
TOPData Mining
50RSDMTP_BAT_CRHDRCRM Target Group Creation - Details Target Group2DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
TOPData Staging
51RSDANLCONBW Archiving: Connection to a Nearline Storage4DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
52RSLOGSYSDESTDestination for Logical System (Note: Comp. EDIPOA ! )2DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
53RSPC_BUFFERShared Buffer for Processes (Esp. Customer Programs)7DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
54RSTPRFCDestinations in Clients2DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
TOPE-Recruiting
55ZJOBBOARD_CUSTCustomizing for Jobboard Destinations6DESTINATIONnvarchar2550
TOPeCATT Extended Computer Aided Test Tool
56ECLOG_SELSelection of STORE Data for RETRIEVE10DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
57TZRR_EVCMDTestZone: Result Repository Event Command6DESTINATIONDestinationnvarchar640
58TZRR_EVTCTestZone: Result Repository Event Test Case8DESTINATIONDestinationnvarchar640
TOPEnd User Technology
59RSR_PREC_LOGSYSManagement of Logical Systems for WB Precalculation2DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
TOPEngineering Desktop
60EDESK_URL_PARAME-Desktop: URL-Parameter14DESTINATIONRemote Function Call Destination in Engineering Desktopnvarchar320
TOPForms Processing
61FPCONNECTConnection-Dependent Settings1DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
62FPFONTREPLFont Replacement Form Processing4DESTINATIONTarget Fontnvarchar2000
TOPGeographical Information System
63LAYER_CONFMap Layer Configuration4DESTINATIONLayer RFC Destinationnvarchar320
64LAYER_CONF_BASEMap Service Configuration3DESTINATIONLayer RFC Destinationnvarchar320
TOPInformation Consistency
65SIC_INDEX_MAINDefine the art of indexing for business objects6DESTINATIONRFC Destination for SES or Catalog for MDMnvarchar320
TOPKnowledge Management and Collaboration
66SUWLNOTIFCFGTBLConfiguration table for UWL java-side notifications4DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
67SUWLNOTIFREGTBLRegistration table for java side server instances3DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
TOPKnowledge Warehouse
68IWCOMP_OBJThe Comparative Objects with Context and Destination4DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
69IWR3LFOLDFolders with Context and Destination for Help Links Check4DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
70IWTREFERENCIWB: Info Object Where-Used References2DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
TOPLogbook
71DIACL_LOG_ENTRYLogbook: log entry17DESTINATIONLogbook: Flight Destinationnvarchar400
TOPMarket Risk Analyzer
72AFWKFRA_KG1Key Figures: P&L Delta/Gamma12DESTINATIONRFC Exit: Destination for Change Scenariosnvarchar320
73AFWKFRA_KG1_HKey Figures: P+L Delta/Gamma13DESTINATIONRFC Exit: Destination for Change Scenariosnvarchar320
74ATRFARTRisk factor type3DESTINATIONRM RFC: Destination risk factor importnvarchar320
TOPMonitoring
75SWNCGLOBDESTSAP Workload NW Collector: GLOB_STAT RFC Destinations1DESTINATIONRFC Destination of a Monitoring Systemnvarchar320
TOPNetWeaver Enterprise Search
76ESH_ADM_BIN_ERRdetail table for error protocol in case of binary data22DESTINATIONntext10737418230
TOPObject Links
77DPR_OBL_OBTYPProperties of Object Link to Object Type14DESTINATIONLogical Destinationnvarchar320
TOPOLAP Technology
78RSDDLTIPTREXCONNTREX Destinations for Analytical Indexes1DESTINATIONDestination of Analytic Indexnvarchar320
TOPPersonnel Time Management
79PTDW_RFC_ASSIGNSAP-internal Assignment Table for RFC Call Ups2DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
TOPPortfolio Management
80RPM_OBL_OBTYPProject Object Link Type14DESTINATIONPortfolio Mgmt: RFC Logical Destinationnvarchar320
TOPProcess Monitoring Infrastructure
81SSPIPSDESTProcess Step Destinations4DESTINATIONDestination for a Stepnvarchar320
82SSPISTCLPRStatistic Collector Read Parameter (Retry & Trans-ID List)2DESTINATIONDestination for a Stepnvarchar320
83SSPISTCONFConfiguration for Performance Data Analysis6DESTINATIONDestination for a Stepnvarchar320
84SSPISTRECSCompressed Statistical Records Before Cumulation2DESTINATIONDestination for a Stepnvarchar320
TOPProduct Data Management
85CONVERT_SPECDetailed information about special conversions4DESTINATIONWS application for conversionnvarchar30
86CONV_FILEClipboard for Objects to Convert26DESTINATIONWS application for conversionnvarchar30
TOPRelationships Between Objects with GUID Identification
87COMC_IL_RELTYPEDefinition of Relationship Types for Object Relationships4DESTINATIONType of Object in a Relationshipnvarchar100
88COMC_IL_TYPEDefinition of Relationship Types for Object Relationships3DESTINATIONType of Object in a Relationshipnvarchar100
TOPRisk Analysis
89JBRBV0VaR - Global Control23DESTINATIONRM RFC: Destination in SAP Banking RMnvarchar320
90JBRBV2VaR Simulation Types19DESTINATIONRM RFC: Destination in SAP Banking RMnvarchar320
TOPSAP Business Workflow
91SWFSWRSYSTEMWorkflow System Handler: Assignment ID for Remote Dest.4DESTINATIONnvarchar2550
TOPService Data Download
92/BDL/CLIENTSClients where data is to be collected explicitly2DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
93/BDL/RFCDESTMultiple RFC-destinations1DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
94/BDL/SAPOSSinformation table for OSS-User1DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
95/BDL/STAMPLast task runs (service def refresh/session refresh)1DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
96/SDF/MON_DESTMonitoring destinations2DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
97/SDF/T_CONFFILESFiles to be read for Service Download6DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
TOPStorage and Retention Service
98DAS_STORESILM SRS: Store Administration9DESTINATIONHTTP Connection to ILM Storenvarchar320
TOPTranslation Tools
99LXE_CUSTMNRTranslation Areas4DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
100LXE_PARAM_NWTranslation6DESTINATIONText Line With 255 Charactersnvarchar2550
101LXE_WSPROXYMaintenance of Web Service Client for SLXE3DESTINATIONDestination for a Web Servicenvarchar2550
TOPTravel Planning
102FTPT_PLANGeneral Plan Data9DESTINATIONDestination of travel plannvarchar590
103FTPT_PLANHISTORYGeneral Plan Data10DESTINATIONDestination of travel plannvarchar590
TOPTreasury
104ATVO3Statistics Type for Parameterizing Estimation Functions11DESTINATIONDestination of RFC-FB to ext. calc. in stat. calculatornvarchar320
TOPUniversal Data Integration
105RSSDKCONDescription of SDK Connections2DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
TOPWeb Service and SOAP - ABAP
106SRT_ASSIGN_DIRAssignments of Profiles to Configurations8DESTINATIONWSP Name of Profile Configurationnvarchar320
107SRT_CFG_CLI_ASGNAssignment of HTTP Destination to WS Client RT Configuration4DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
108SRT_SEQ_DEL_QUEbgrfc queues that can be deleted because of seq termination2DESTINATIONName of Destination in Inbound Casenvarchar320
109SRT_SEQ_QUEUESoap sequence: assigned queue7DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
110SRT_SEQ_QUE_HISTSoap sequence : History of former queues7DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
111SRT_SEQ_SDC_ASFKSequence SchedulerfFunctionsets async border4DESTINATIONLogical Destination (Specified in Function Call)nvarchar320
112SRT_SYSTEM_DIRSystem Directory6DESTINATIONWSP Name of Profile Configurationnvarchar320
113SRT_TEST_DESTINATable for testing1DESTINATIONCharacter field, length 32nvarchar320
TOPWeb Survey
114TUBD_REMOTEBusiness Domain Lib: Remote Systems4DESTINATIONLogical Destination (Specified in Function Call)nvarchar320