SAP Communication Services: Mail, Fax, SMS, Telephony Tables

Are you looking for the right table related to SAP Communication Services: Mail, Fax, SMS, Telephony Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Communication Services: Mail, Fax, SMS, Telephony (BC-SRV-COM) module.

Top 10 tables in Communication Services: Mail, Fax, SMS, Telephony

TableDescription
SPH_ATICSAPphone: Address data areas for incoming caller search
SOFFCHKOSOFF: Checkout Data to a Physical Information Object
SOHSSAPoffice: DB for Home System (Shared Buffer)
SOFDSAPoffice: Object Definition
SOESSAPoffice: External send operation
SOEMSREPSAPoffice: Control table for emergency sys. return transport
SOCXSAPoffice: table for storing SAPcomm IDs
SOCSSAPoffice: table for storage of an Office ID (SAPcomm)
SOPCPATHPath + File Name for Deleting PC Work Files
SOFFPHRISOFF: Incoming Links for Physical Information Objects

List of tables in Communication Services: Mail, Fax, SMS, Telephony

TableDescription
SPH_ATICSAPphone: Address data areas for incoming caller search
SOFFCHKOSOFF: Checkout Data to a Physical Information Object
SOHSSAPoffice: DB for Home System (Shared Buffer)
SOFDSAPoffice: Object Definition
SOESSAPoffice: External send operation
SOEMSREPSAPoffice: Control table for emergency sys. return transport
SOCXSAPoffice: table for storing SAPcomm IDs
SOCSSAPoffice: table for storage of an Office ID (SAPcomm)
SOPCPATHPath + File Name for Deleting PC Work Files
SOFFPHRISOFF: Incoming Links for Physical Information Objects
SODSATSAPoffice: User-friendly LDAP attribute names
SOFMSAPoffice: Folder contents
MIME_DSNCBCOM MIME: Assignment of Message Number to DSN Status Code
BCSD_BLMODULEBCS: Modules in Which Breakloops Can Be Activated
SOMGTable for persistence of objects MESSAGE/RECIPIENT
SOERSAPoffice: receive externally
BCST_ROBCS: Folders for Semantic and Technical SAP Role Keys
BCSD_ENVIDMapping Envelope ID - Request ID
BCST_SFSmart Forms Database Table CL_SMART_FORM_BCS
SOFINDSAPoffice: Search table via SOFD
SORPSAPoffice: Replication Table
BCST_FLTVLBCS: Filter Values for BADI DOC_PERSONALIZE_BCS
BCSD_STMLBCS: Status Confirmation by E-Mail for Specific Address Area
BCSD_BREAKLOOPBCS: Breakloops in SAPconnect
BCST_OUBCS: Folder for Semantic and Technical Org. Units Key
BCSTTATFCDText Table for BCST_ATFCD
BCST_IBCTBCS: Shared Buffer for Inbound Distribution
SOFFCONT1SOFF: Table for Document Contents (import/export)
SODESTSAPoffice: Destinations
BCST_FLTVTPPF: Text Table for PPFTFLTVAL
SOFFPHHRSOFF: Outgoing Hyperlinks from Physical Objects
BCST_SRBCS: Status of Send Orders
BCST_REBCS: Status of Recipient Entries
SOC3NSAPoffice: DB for Objects (Header/Content)
SXRFCSAPconnect: Assignment of RFC address to node
SRSCENATTRRouting Scenario: Attributes
SRSAGRPRouting Server: Agent_Group Table
SRSCENDESTRouting Scenario: Destinations
SPH_USTOATSAPphone: Assign address data areas to user
SRATTCATWFBCOM Routing: Data Element Reference of an Attribute
SRSATTRIBTRouting Server: Attribute Table Temp
SRATTCATBCOM Routing: Attribute Catalog
SREQRORGBCS: Senders and Recipients to Be Deleted (Send Order Reorg)
SOIDSAPoffice: Inverse record for distribution list
BCST_ASSIGNMENTSBCS: Assignment to Disclosure Documents
SOFFPHPRSOFF: Attributes of Physical Information Objects
SRSRESPRouting Server: Responsibility Table
SOFFPHNMSOFF: Use of Target Anchor in Physical Objects
SBCMPHIOBCOM MIME: Instances of Physical Information Objects
SOSXTESTSAPoffice/SAPconnect: Temporary folder for test results
SOFFLORISOFF: Incoming Links for Logical Information Objects
SOFFPHFSOFF: Files of Physical Information Objects
SRSRVAPPBCOM Routing: Server for each Application
BCS_MSG_REQUESTRequests
SBCMPHREBCOM MIME: Outgoing Relationships of Physical Info. Objects
SOMFTSAPoffice: SOMF language table
SOIMAPSAPoffice: Mapping Table IMAP UID - API2 ID
SRSSRCHTRouting Server: Search Table Table
SPH_DEFLCTSAPphone: Language-dependent texts for SPH_DEFLEC
SRBCSBRELRelationships in GOS Environment
SRSSCENRouting Server: Scenario Table
SOCYSAPoffice: inverse table for SOCX (SAPcomm ID table)
BCS_MSG_REC_STATRecipient Status
SOUXASAPoffice: Address ID for System User without USR02
SOCVPCSAPoffice: Conversion Table for PC Documents
SOFFPHRESOFF: Outgoing Links for Physical Information Objects
SOADRBUFSAPoffice: DB for objects (import/export)
SOURSAPoffice: Set of Regulations for User Agent
SRIRSCENBCOM Internal Router: Scenario Header Data
SRSRESPTRouting Server: Responsibility Table Temp
SPH_SITESSAPphone: Site Attributes
SRIRSCENATBCOM Internal Router: Scenario Attributes
BCSD_STATUSERBCS: User statistics data
SPH_TERMNLSAPphone: Work center settings
BCST_RETEBCS: Status of Technical Recipients
SOQUOTAQuota: Number and Size of Documents in Private Folders
SRSCONFIGRouting Server: Config Table
SRSRVCHNLRouting Server: Channels (Phone Calls, E-Mails, Fax, ...)
TSINGSAPBPT: Config. - Classes Columns Belong To
TSALQSAPaccess: language-dependent description of requests
TSINKSAPBPT: General SAP configuration names
SIN_T_LINKNavigation Area of SAPBPT Workplace
SOFFREPRSOFF: Attributes of Links
SOREORGObsolete -SAPoffice: Reorg. tab. for interim storage of keys
SXRETRYSAPconnect: Disruptions in RFC connections to node
SOFFCHKFSOFF: File Name of Last Checkout
TMLVWInternational country code conversion
SOOFSAPoffice: object folder
SOOCSAPoffice: object counter (per object type and year)
TSOVTSAPoffice: Processing types, text table
SXDOMAINSSAPconnect: Management of Internet Mail Addresses Domains
T164OSAPcomm: Server location
BCST_DLBCS: Folder for Semantic and Technical DL Key
BCST_PPFMDPersistence of BCS Medium for PPF
SPH_USNOLISAPphone: Telephone number list for each user
SOATTSAPoffice: Attachments for BOR objects
SIN_T_LANGWorkplace Classes: Language-dependent Descriptions
SRIRREQATTBCOM Interaction Routing: Request Attributes
SOPRSAPoffice: System-wide profile
TSINDSAPBPT: Class Descriptions
T005KCommunication: country dialling code
SOMLSAPoffice: Multiple MLP: List of relevant systems
BCSD_RQSTBCS: Status Requests for Specific Address Area
SRSSRCHTTRouting Server: Search Table Table Temp
SRIRREQUESTBCOM Interaction Routing: Requests
SOFASAPoffice: user-specific authorization for shared folders
BCS_MSG_MAP_DSCAMapping for communication arrangement and SMTP configuration
SODSATSTLDAP Attributes for Office Transmission Methods
TSINBSAPBPT: Configuration Table (Translations)
SOFFLORESOFF: Outgoing Links for Logical Information Objects
SADRFFax addresses with cover sheet
SBCMPHPRBCOM MIME: Attributes of Physical Information Objects
SRSAGRPTRouting Server: Agent_Group Table Temp
T164URegional subscriber number characteristic
BCST_ASSIGNMENTBCS: Assignment to Disclosure Documents
SXTELMOINSAPconnect: Telephone number modification (incoming)
T164CSAPcomm: Destination server assignment
SRIRTIMEBCOM Internal Router: Time Stamp
SPH_AGRUSRSAPphone: Users of Authorization Groups
SORTSUBFSAPoffice: User-specific sort of folders subscribed to
TSINOSAPBPT: General SAP configuration columns
SODSPROFPresettings for access to LDAP service
TSINLSAPBPT: General SAP configuration names (languages)
SXPARAMSSAPconnect: Parameter Table
SXCPRECVSAPconnect: Language for Code Page
TSINISAPBPT: Valid classes in integrated inbox
TSINSSAPBPT: Inbox Filter Options
SRSSCENTRouting Server: Scenario Table Temp
SORDSAPoffice: Viewed Records for Shared Folders
SXFORMATGSAPconnect: Format groups
SXADDRTYPESAPconnect: Address types
SOOSSAPoffice: send process
SOSCSAPoffice: Connection table to SAPcomm and SAPconnect
SOXPSAPoffice: Table for data transfer during express handling
BCST_IBNDBCS: Rules for Inbound Distribution
BCSD_STATBCS: Statistical Data
SXDEVTYPESAPconnect: Device Types for Format Conversion
BCS_MSG_SMTPCONFSMTP Configuration
TSOTDValid Object Types
BWWF_MIMEAssignment table beetween conversion key and MIME type
SPH_ATICTSAPphone: Address data areas - Text table for SPH_ATIC
SBCMLOIOTBCOM MIME: Descriptions of Logical Information Objects
T164PSAPcomm: Server selection
SPH_AGRKYSSAPphone: Internal Key for Authorization Groups
SOFFLOIOTSOFF: Descriptions of Logical Information Objects
TSOTTObject Type Texts
SOSUSAPoffice: Substitute for a user
SBCMPHFBCOM MIME: Files of Physical Information Objects
SOUBSAPoffice: Inverse user (SAPoffice user)
SODMSAPoffice: distribution list contents
SMYOWPMyObjects Hierarchy in WP (Cluster)
SBCMLOPRBCOM MIME: Attribute Values of Logical Information Objects
SOSUBUTWorkplace: Private Sort of Folders Subscribed to
SPH_STEEXCSAPphone: F_ALLOTHNO=(' ') X =>For All (Non)Allowed Numbers
SOUDSAPoffice: user definition
SXCOS_TSAPconnect: Text table for send classes
BCST_NOTEMapping: Send Order GUID -> SAPOffice Doc. ID of Note
SPH_SERVERSAPphone: Telephony server settings
BCS_MSG_RECIPRecipients
TSINPSAPBPT: General SAP configuration filters
SOFFLOIOSOFF: Instances of Logical Information Objects
TSOPASAPoffice: SET/GET Parameter
TSOPEExclusion of Specific File Extensions
SOFFRESOFF: Instances of Links
SIN_T_INIWorkplace: Classes Involved at Workplace
SPH_STESRVSAPphone: Server in Sites
TSOUXSAPoffice: System User without USR02
TSOTXGeneral texts for SAPoffice
SRSATGRPRouting Server: AttribGroup Table
SOFFLOPRSOFF: Attribute Values of Logical Information Objects
BCS_MSG_MIMEMIME
SBCMLOIOBCOM MIME: Instances of Logical Information Objects
SXSERVSAPconnect: Node capabilities
SADROSAPoffice: Table for storing UNIX addresses
SXCPSENDSAPconnect: Code Page for Language
SRSCENARIORouting Scenario: Definition
SPH_STEAGRSAPphone: Authorization Groups of Sites
SOGRSAPoffice: Recipient determination during inbound distrib.
SRSERVERSAP Rule-Based Routing Servers
SODSPROF2LDAP Profile (New 4.6C)
SXADMINTABSAPconnect and SAPphone: Administration
TSARQSAPaccess: all supported requests
SOMFSAPoffice: Address tables for fax screen
BCST_PDFPersistence for CL_PDF_FORM_BCS
SRIRATGRPBCOM Internal Router: Attribute Group
SADRUSAPoffice: Table for storing UNIX addresses
SMYONODESNodes for MyObjects
BCSTTATFLTText Table for BCST_ATFLT
SOEPSAPoffice: Table for data transfer during express handling
SBCMCHKFBCOM MIME: File Name of Last Checkout
EMSERVERAssignment of External Mail Server to User
TSINUSAPBPT: Configuration Table User
BCST_CAMPersistence of a BAS Address
SXDEVTYPLSAPconnect: Device Types for Language-Dependent Conversion
TSOPCFAVFavorites PC Documents
SBCMCONT1SDOK: Table for Document Contents (Import/Export)
SOC3SAPoffice: DB for objects (import/export)
SXTELMOOUTSAPconnect: Telephone number modification (outgoing)
BCST_SUBCS: Folder for Semantic and Technical SAP User Key
T164ASAPcomm: System Parameters
T005JCommunication: country dialling code exceptions (Telephone)
SOFFPHIOSOFF: Instances of Physical Information Objects
SADRX5X.500 Directory Entries
SRSATTRIBRouting Server: Attribute Table
SPH_IDMETHSAPphone: Identification Methods for Work Center Settings
SOFRSAPoffice: Distribution List Table for Incoming Faxes
SPH_TELUSRSAPphone: User settings
SRIRSCENDEBCOM Internal Router: Scenario Destinations
SRSACTIONRouting Server: Actions Table
SXCONVERT2SAPconnect: Conversion Functions for Format Categories
SRIRRESPBCOM Internal Router: Scenario Responsibilities
SOSTSAPoffice: Status log table
SBCMCHKOBCOM MIME: Checkout Data for Physical Information Object
SXCPDEFSAPconnect: Default Codepage for Each Send Type
SXJOBSSAPconnect: Send Jobs
SRIRAGRPBCOM Internal Router: Agent Group
BCST_ATFCDValue Table for Function Codes
SMYONODEENodes for MyObjects
SPH_AGREXTSAPphone: Numbers of Authorization Groups
SXCONVERTSAPconnect: Conversion functions
SMYONODETNodes for MyObjects (Text)
SORFSAPoffice: Replication Table
SRSTSTRouting Server: Time Stamp Table Temp
BCST_RESPOBCS: Persistence of a Spool/Print Recipient
TSINRSAPBPT: Configuration names
SXCOSSAPconnect: Send attribute classes
SPH_EXTNSNSAPphone: Extensions per Work Center
TSOEXSAPoffice: Trace Table
SPH_PCTONOSAPphone: Work center settings
SRIRSEARCHBCOM Internal Router: Search Tables (with Addresses)
T005J_EXTEnhancement of Table T005J
SRSATGRPTRouting Server: AttribGroup Table Temp
SRSCENSERVRouting Scenario: Server
T005K_EXTEnhancement of Table T005K
SRSTSRouting Server: Time Stamp Table
SRSDESTTRouting Server: Description Table Temp
T164YSAPcomm: Incoming Mail Recipients
SRSCENTYPERouting Scenario: Classifications
TSOPTSAPoffice: Parameter Texts
T005ICommunication: Country dialling code exceptions (Telex)
TSCMSTATSAPcomm: Spool <-> Application key
TSOCXSAPoffice: SOC3 split
SRSDESTRouting Server: Description Table
TSINNSAPBPT: Configuration Names
SRRESPONSRouting: Responsibility
TBCS_RECIPControl Table for Possible Dialog Recipient Types
TSINESAPBPT: Valid Classes in Integrated Inbox
TSOVMSAPoffice: valid processing types
TSINASAPBPT: Configuration Table
SXNODESSAPconnect: Communication nodes
SXROUTESAPconnect: Routing table
SORSSAPoffice: Resubmission of user
BCST_BORBCS: Folder for Semantic and Technical BOR Object Key
BCST_CVDOCPersistence of CL_COVER_DOCUMENT_BCS
BCST_ATFLTFilter Values for BAdI ATT_SELECT_BCS
SPH_SERVTSAPphone: Telephony server - Text table for SPH_SERVER
TSINHSAPBPT: Assignment of valid function codes and classes
SOODSAPoffice: Object definition
SOUCSAPoffice: Inverse user (SAP user)
SMYOTREEMyObjects Together with Hierarchy
SOSTATSAPoffice: Statistics