SAP Tables - SAP Business One/ERP Table Definition reference

 Module:  Table: 

icon of database logic symbol SAP  TABLESv1Made in Britain - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OVTG52Tax Definition
7OJDT100Journal Entry
8OPCH386A/P Invoice
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

2OINV268A/R Invoice
3ORCT154Incoming Payment
4OVPM154Outgoing Payments
5OOCR9Loading Factors
6OIVL77Whse Journal
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction - the webs number one PHP Function reference tool

76 columns | Print definition?ERP 6.0  | PORT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GEOE/CONFIG_17Picture Marker Path6PORTGeoServicePortnvarchar400
2/IXOS/RSA_T_RENSTable: Rendition Server Overview8PORTPortnvarchar40
3/OTX/RM_AUNITCFGServer-specific configuration for unit tests23PORTPortnvarchar60
4/OTX/RM_TELIBEnterprise Library Server Settings17PORTPortnvarchar60
5/SYCLO/MDW05Syclo Middleware Server Data8PORTPort of Hostnvarchar50
6/XFT/APPLLAYHTTPApplication layer: HTTP destination6PORTPortnvarchar50
7IDXLOG_ADMConfiguration: IDoc Adapter RFC Logging2PORTPorts in IDoc Adapternvarchar100
8UCONIPVHOSTRTRuntime Table for relation IP/Port and SNC Flag to Vhost3PORTPortnumber (33XX or 42XX where XX is the system number)nvarchar40
9UCONVIRTHOSTRFCVirtual hosts for RFC3PORTPortnumber (33XX or 42XX where XX is the system number)nvarchar40
10ZSYSTEM_PARTNERALandscape Data: additional Attributes5PORTHTTP Portnvarchar80
TOPALE Integration Technology
11EDCPICEDI table of received IDocs from R/23PORTR/2 portnvarchar100
12EDIPOTable for description of ports for EDI1PORTPortnvarchar100
13EDIPO2Table for R/2 Port Definitions2PORTPortnvarchar100
14EDIPOATable for ALE Port Definitions2PORTPortnvarchar100
15EDIPODTable for File Port Definitions2PORTPortnvarchar100
16EDIPOFPorts for ABAP programming interface2PORTPortnvarchar100
17EDIPOITable for describing Internet ports2PORTPortnvarchar100
18EDIPORTSummary Table for all Port Types for IDoc Processing2PORTPortnvarchar100
19EDIPOXTable for Description of XML Port2PORTPortnvarchar100
20EDIPOXHTable for XML HTTP Port Description2PORTPortnvarchar100
21EDIPOXUConversion of special characters for XML2PORTPortnvarchar100
22EDI_CPINB_MDMPCode Pages for Various Languages in MDMP Inbox2PORTSender port (SAP System, EDI subsystem)nvarchar100
23IDXEDISDEFIDoc Adapter Segment Versions for each Port1PORTPorts in IDoc Adapternvarchar100
24IDXEDSAPPLIDoc Adapter Fields in the Segments for each Port1PORTPorts in IDoc Adapternvarchar100
25IDXIDOCSYNIDoc Adapter IDoc Syntax Description for each Port1PORTPorts in IDoc Adapternvarchar100
26IDXPORSM59IDoc Adapter Destination and Partner for Status Confirmation1PORTPorts in IDoc Adapternvarchar100
27IDXSLOADIDoc Adapter Administration1PORTPorts in IDoc Adapternvarchar100
28IDXSTRUCTIDoc Adapter: IDoc Structure Information Procurement1PORTPorts in IDoc Adapternvarchar100
TOPBroadcast Messaging
29CRMC_CIC_BROADProfile Table for Broadcast Component8PORTPort Number for Connecting to Broadcast Servernvarchar50
TOPBusiness Server Pages
30BSPHOSTMapping Table for Host Names and Ports in BSP5PORTnvarchar60
TOPClientServer Technology
31HTTPURLLOCHTTP URL Location Exception Table7PORTnvarchar60
32HTTP_WHITELISTHTTP White List6PORTnvarchar60
33HTTP_WHITELIST_SHTTP White List6PORTPort, for example, 1080 (empty = not used)nvarchar60
TOPClinical System
34TN1AETITLEIS-H*MED RAD: Assignment of RAD and PACS Resources10PORTPortint100
TOPContent Management Service
35SCMSCACHECache Properties2PORTCache Server Portnvarchar50
36SCMSCACHTKPRO CMS: Cache Descriptions3PORTCache Server Portnvarchar50
37SCMS_SERCAMonitored Cache Servers2PORTCache Server Portnvarchar50
38SCMS_SERCSMonitored Cache Servers2PORTContent Server Portnvarchar50
39SCMS_SERPXMonitored Aliases2PORTPort for Content Server Aliasnvarchar50
40SCMS_STACAStatus of Monitored Cache Servers2PORTCache Server Portnvarchar50
41SCMS_STACSStatus of Monitored Content Servers2PORTContent Server Portnvarchar50
42SCMS_STAPXStatus of Monitored Aliases2PORTPort for Content Server Aliasnvarchar50
TOPCross-Application Components
43/IXOS/DC_TCNTHLTable for nodetype hyperlinks9PORTHyperlink portnvarchar200
44/IXOS/RS_T_RENDIRendition Servers6PORTRendition Server Portnvarchar40
TOPDatabase Monitors
45ALLAZYMT2ALERTS NEXT GEN: NEW (>=4.6A) Database Monitoring Tree1PORTnvarchar100
46LDAPSERVERLDAP Server5PORTPort number of LDAP serverint100
TOPDocument Management Framework
47SKWGURLPRTIndividual Parts for URL Generation3PORTNot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40
TOPElectronic Data Interchange
48PRISBCPARAPRICAT: SBC Parameters for PRICAT Customers6PORTPRICAT: Port of an SBC Servernvarchar50
TOPInformation System
49CMS_BII_PP_AP_PRCMS-Basel II: Data Extr. Appl Params for Parall.Proc Dex Set7PORTReceiver port (SAP System, EDI subsystem)nvarchar100
50TCMS_BII_DEXPRCMS-Basel II: Data Extraction Process Settings5PORTReceiver port (SAP System, EDI subsystem)nvarchar100
TOPIntegration Server
51IDXALEREQUESTXI IDoc Adapter: Send ALEAUD as Request Message2PORTPorts in IDoc Adapternvarchar100
52IDXLNKOBJIDoc Adapter Link Segment Fields for Port1PORTPorts in IDoc Adapternvarchar100
53IDXMDMPLANGUMDMP: IDoc type with language field1PORTPorts in IDoc Adapternvarchar100
54IDXMDMPRCVMDMP Support Receiver1PORTPorts in IDoc Adapternvarchar100
55IDXNOALEDo not request IDoc Adapter exception list acknowledgement1PORTPorts in IDoc Adapternvarchar100
56IDXQUEUEIDoc Adapter Queue1PORTPorts in IDoc Adapternvarchar100
57IDXRCVPORIDoc Adapter Link GUID with IDoc, Receiver and so on4PORTPorts in IDoc Adapternvarchar100
58IDXSERIALOBJIDoc Adapter: Object Channel Serialization2PORTPorts in IDoc Adapternvarchar100
59IDXSNDBSIAssignment Sender IDoc Partner for Business System Instance1PORTPorts in IDoc Adapternvarchar100
60IDXSNDPORIDoc Adapter Link GUID with IDoc, Sender System and so on3PORTPorts in IDoc Adapternvarchar100
61IDXTRCMONIIDoc-Adapter Tracking Destination1PORTPorts in IDoc Adapternvarchar100
TOPInternet Communication Framework
62PPROXY_CPlugin Proxy Configuration for HTTP/HTTPS Client (Host/Port)4PORTProxy Portnvarchar120
TOPManagement of Internal Controls
63FOPCWFNOTIFCFADetails for Notification System per Work Item6PORTnvarchar60
64SCMLPSMOI_WS: Configuration of Logical Ports for SAPSTARTSRV9PORTPort Numbernvarchar50
TOPNetWeaver Enterprise Search
65ESH_ADM_MDM_CONNESH: Connections to MDM Servers4PORTMDM: Portnvarchar50
TOPRadiology RAD - Assignment of RAD and PACS Resources7PORTPortint100
TOPSAP Business Workflow
67SWFWSHANDTHandler Customizing for Web Service Execution in Workflow5PORTHandler Portnvarchar160
TOPSAP NetWeaver Mobile - Use subcomponents
68MECONFIG_J2EEHost Name and Port of J2EE Engine for MI3PORTPort of Hostnvarchar50
TOPService Data Download
69/SDF/DB6PMCNDB6: Configuration Nodes (Partitions)6PORTint100
TOPSystem Landscape DirectoryComponent Repository
70LCRT_SERVADDRLandscape Directory Server Addresses2PORTPort Number of Landscape Directory Servernvarchar50
71TREX_INDEX_SERVIndex Server Location for Indexing4PORTPort Numbernvarchar50
72TREX_SEARCH_SERVIndex Server Location for Search3PORTPort Numbernvarchar50
TOPUse Subcomponents
73SODSPROFPresettings for access to LDAP service4PORTPort number of LDAP serviceint100
TOPWeb Service and SOAP - ABAP
74SRT_CFG_CLI_ASGNAssignment of HTTP Destination to WS Client RT Configuration7PORTPort Numbernvarchar50
75SRT_DEST_WSDLSRT: Table for destinations for wsdl lookup4PORTnvarchar50
76SRT_TEST_RESULTSResults of Performance Measurements5PORTLogical Port Namenvarchar600