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

56 columns | Print definition?ERP 6.0  | PROFILE_NAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/MRE/RSC_OBJ_FLPMobile Retail Object Filter Profile2PROFILE_NAMEERP Mobile Retail Customizing Profile Namenvarchar120
2/MRE/RSC_OBJ_FLTMobile Retail Object Filter Profile Description2PROFILE_NAMEERP Mobile Retail Customizing Profile Namenvarchar120
3/MRE/RSC_OBJ_FPVMobile Retail Object Filter Profile Values2PROFILE_NAMEERP Mobile Retail Customizing Profile Namenvarchar120
4/MRE/RSC_SOR_FLPMobile Retail Mapping Object Filter Profile To Sales Org3PROFILE_NAMEERP Mobile Retail Customizing Profile Namenvarchar120
5/MRE/SORG_ATTRCustomizing table for sales organization attributes12PROFILE_NAMEOrder Profilenvarchar80
6/SLOAP/LEVELcheck table to determine level of org-elements3PROFILE_NAMEVersion Number Componentnvarchar20
7SRT_REQ_D_CI_PROSRT: Business Scenario Provider -> Contract Implementation9PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
8SRT_ST_ACT_CFACCCentral Config: Actual State of Consumer for Domain System14PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
9SRT_ST_ACT_CFACTSOAP Configuration: Actual State of Consumer Objects13PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
10SRT_ST_ACT_C_CCentral Config: Actual State of Consumer for Domain System11PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
11SRT_ST_ACT_EPROSOAP Configuration: Actual State of Event Provider Config11PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
12SRT_ST_ACT_EPROCCentral Config: Actual State of Event Provider Config for DS12PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
13SRT_ST_ACT_P_CCentral Config: Actual State of Provider for Domain System4PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
14UCONCFGPROFILERTTable for Default profile and configuration2PROFILE_NAMEUCON: ID for HTTP Server Objectsnvarchar300
15UCONRFCPROFCFGRTRuntime Table for Relation Customizing & Profile2PROFILE_NAMEUCON: ID for HTTP Server Objectsnvarchar300
TOPDocument Management System
16DMS_PROF01DMS: Profile Definition2PROFILE_NAMEProfile key for processing of original filesnvarchar100
17DMS_PROF02DMS: Allocation Profile - Group/User2PROFILE_NAMEProfile key for processing of original filesnvarchar100
18DMS_PROF03DMS: Profile Definitions for Applications2PROFILE_NAMEProfile key for processing of original filesnvarchar100
19DMS_PROF04Profile definition for process2PROFILE_NAMEProfile key for processing of original filesnvarchar100
TOPEnterprise Service Framework Layer
20SCOL_BO_PROPERTYESF : Business Object - Property4PROFILE_NAMEESF: Business Object Profilenvarchar300
TOPInformation Consistency
21SIC_PROFILE_DATADefinition of Profile Data4PROFILE_NAMEService Profilenvarchar300
22SIC_PROFILE_NAMEDefinition of Profile Names9PROFILE_NAMEService Profilenvarchar300
TOPIntegrated Product and Process Engineering
23CLUIPROFILETText Table of Profile Definitions for iPPE Workbench Express4PROFILE_NAMEProfile Desription in the iPPE Workbench Expressnvarchar400
TOPRemote Control and Communication Framework
24CSIC_PROFILECSI Administration Profile for Cloud Providers1PROFILE_NAMECSI Profile Namenvarchar100
25CSIC_PROVIDERAvailable Cloud Providers5PROFILE_NAMECSI Absolute Typename in ABAPnvarchar2000
26CSID_INST_LOGCSI: Instance Log Information10PROFILE_NAMECSI Profile Namenvarchar100
27CSIL_INSTANCESCSI Current Runstate Table2PROFILE_NAMECSI Profile Namenvarchar100
28CSIL_INSTEVTHNDLCSI Eventhandlers registered for a given instance2PROFILE_NAMECSI Profile Namenvarchar100
29RCCC_SERVICEPRFRCCF Service Profiles1PROFILE_NAMERCCF Service Profile Namenvarchar200
TOPRuntime WorkbenchMonitoring
30SXMSAGGDATSAP XI Status Overview: Aggregated Data3PROFILE_NAMESAP XI Status Overview: Aggregation Profilenvarchar200
31SXMSAGGMAPSAP XI Status Overview: Mapping Aggregation Key Attribute2PROFILE_NAMESAP XI Status Overview: Aggregation Profilenvarchar200
32SXMSAGGPERIODSAP XI Status Overview: Aggregration Profile Periods1PROFILE_NAMESAP XI Status Overview: Aggregation Profilenvarchar200
33SXMSAGGPROFSAP XI Status Overview: Aggregration Profile Header1PROFILE_NAMESAP XI Status Overview: Aggregation Profilenvarchar200
34SXMSAGGPROFRSAP XI Status Overview: Aggregration Profile Runtime Data1PROFILE_NAMESAP XI Status Overview: Aggregation Profilenvarchar200
35SXMSAGGPROFTSAP XI Status Overview: Aggregration Profile Short Text2PROFILE_NAMESAP XI Status Overview: Aggregation Profilenvarchar200
TOPServices
36SSRVRTASSIGNXI Services: Mapping from Binding to Assignment4PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
TOPSyntax, Compiler, Runtime
37SLAD_FAV_PROFILESLAD: Favorites in the Profile Management2PROFILE_NAMESLAD: Name of Objectnvarchar400
TOPTravel Planning
38TA23CTAmadeus Profile2PROFILE_NAMEAmadeus Profilenvarchar200
39TA23CT1Amadeus Profile Text Table3PROFILE_NAMEAmadeus Profilenvarchar200
TOPWeb Service and SOAP - ABAP
40SRTFT_ASSIGNSRT Configuration Assignments2PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
41SRTFT_ASSIGN_IFSRT DT Assignments: Target State2PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
42SRTFT_ASSIGN_SECSRT DT Assignments: Target State2PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
43SRTFT_QUEUEProcessing FIFO5PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
44SRTFT_QUEUE_LOGLog of SRT Configuration FIFO6PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
45SRT_ASSIGN_DIRAssignments of Profiles to Configurations7PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
46SRT_PEND_TASKPending SRT Configuration Tasks7PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
47SRT_PRF_CFG_DIRSOAP Runtime Framework: Profile Configuration Directory4PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
48SRT_PRF_DIRSOAP Runtime Framework: Profile Directory3PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
49SRT_PRF_DIR_VSOAP Runtime Framework: Profile Version Directory3PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
50SRT_PROF_ASSIGNAssignment of Configuration Profiles4PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
51SRT_REQ_DATA_PSOAP Configuration Group for Mass Config.: Data Provider6PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
52SRT_REQ_DATA_PROSOAP Configuration Group for Mass Config.: Data Provider5PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
53SRT_ST_ACT_CSOAP Configuration: Actual State of Consumer Objects10PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
54SRT_ST_ACT_PSOAP Configuration: Actual State of Provider Objects3PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
55SRT_ST_REQ_CSOAP Configuration: Required State of Consumer Objects10PROFILE_NAMEWSP Name of Profile Configurationnvarchar320
56SRT_ST_REQ_PSOAP Configuration: Required State of Provider Objects3PROFILE_NAMEWSP Name of Profile Configurationnvarchar320