SharePoint - Message Output
Message Output in SAP allows users to generate and distribute documents from SAP to various output channels. With docuflow, these generated documents can be routed to your Sharepoint environment for storage and distribution.
Key benefits include:
- Centralized document storage in Sharepoint
- Secure distribution with SharePoint's permission settings
- Seamless integration with SAP processes
- Support for multiple output formats
- Audit trail and compliance features
- Reduced manual effort through automation
Example use cases:
- Distributing invoices, shipping notifications, and order confirmations to customers, partners, and suppliers via SharePoint
When storing Message Output documents, there are two options:
- Content Server
- ECM Server
Content Server is a communication specification defined by SAP that uses HTTPS to communicate with the docuflow middleware. docuflow is an SAP Content Server certified application.
ECM Server is a communication specification based on SAP’s RFC socket protocol called JCo (Java Connector). The ECM server unlocks remote function calls and docuflow provides an API within SAP to leverage this technology, allowing enhanced functionality over standard Content Server.
While we are only discussing Outbound communications, ECM with JCo does allow for bi-directional communication between docuflow and SAP, Inbound and Outbound.
[Architecture Diagram]
Pros:
- HTTPS protocol – routes well over the public internet and can be used with stateful packet inspection firewalls
- Does not require docuflow transports to be deployed in SAP
- There will be no modifications to print program required
Cons:
- Does not inherently allow for custom metadata to be sent during upload to SharePoint unless call back is used. See Call Back Guide below.
- See the below section on custom metadata
- Does not inherently get dynamic routing unless call back is used
- No Dynamic folder creation unless call back is used
Pros:
- Custom metadata can be sent real-time
- Real-time dynamic routing
- Real-time dynamic folder creation
Cons:
- RFC protocol requires non-standard ports to be opened
- Modification to Z version of print program required
Custom metadata can be set in SharePoint as columns in content types. Custom metadata is any values from SAP beyond those required by docuflow.
Custom metadata is most valuable when there is the desire to:
- Allow end-users to access SAP-linked documents directly in the SharePoint interface, especially through search.
- Enables Microsoft Search.
- Enables access to Search Refiners in SharePoint.
- Trigger a Power Automate workflow.
- Allow other Business Systems to access/link to documents stored by SAP (i.e. SalesForce).
Metadata enables inbound scenarios. For example, a document arriving in SharePoint can:
- Link to an existing SAP object.
- Trigger an SAP workflow with container values.
- Trigger custom ABAP code.
How custom metadata is applied to SharePoint varies based on the method of outbound storage, ECM or Content Server.
ECM has native support for selecting a SharePoint Content Type and its column values when creating the document in a document library. Content Server, based on the SAP specification, does not allow custom metadata to be set during the creation of the document in SharePoint. This must be done through a docuflow technology called a ‘call back’.
Call backs utilize the ECM connectivity and update the document metadata/columns once the SAP Content Server store/create operation has been completed. This means there are additional API calls/time required to update the document with business metadata.
Call backs utilize the ECM connectivity and update the document metadata once the SAP Content Server store/create operation has been completed. This means there are additional API calls/time required to update the document with business metadata.
[Graphic Overview to be added in the future]
Pros:
- Can enable metadata based searching and search result filtering for users accessing content within SharePoint
- Enables the ability to do inbound rules when using ECM connectivity
Cons:
- Content Server does not inherently allow for custom metadata to be sent during upload to SharePoint. This then requires an ECM call to back populate the custom metadata which adds additional transaction time and SharePoint Graph API calls.
- Please see the section ‘Application Throttling’ in the following Microsoft information page: https://learn.microsoft.com/en-us/sharepoint/dev/general-development/how-to-avoid-getting-throttled-or-blocked-in-sharepoint-online
Dynamic Location Routing Dynamic Location Routing is a feature that allows documents to be automatically stored in different SharePoint folders based on associated SAP data when the document is transferred from SAP to SharePoint.
This capability enables organizations to create rules and logic that determine the storage location of documents based on specific SAP attributes or metadata. By leveraging Dynamic Location Routing, companies can:
- Automatically categorize and file documents according to business-specific criteria
- Ensure consistent and organized storage of documents across various departments or processes
- Simplify document management and improve information accessibility
Here are a couple of examples to illustrate how Dynamic Location Routing can be used:
Example1: Routing based on code: Documents attached to Sales Orders within a Sales Organzization with code 1000, go to SharePoint location 1000: SAPDocs->Sales Orders->1000 Documents attached to Sales Orders within a Sales Organzization with code 2000, go to SharePoint folder 2000 : SAPDocs->Sales Orders->2000
Example2: Internal vs. External documents: SAP information, such as ArchiveLink document type, classification, or vendor number, can be used to automatically classify documents as either internal or external and route them to the appropriate SharePoint folders.
External documents, intended for vendor access, are stored in a SharePoint folder that the specific vendor can view. Internal documents, meant for internal use only, are stored in a separate SharePoint folder inaccessible to vendors, even if the document is related to a specific vendor.
This automated categorization and routing process, based on SAP metadata, helps organizations maintain better control over document access and ensures that information is shared appropriately.
Document Libraries and/or Folders are sometimes leveraged to logically bundle a series of documents together.
SharePoint implements Permission inheritance from Site Collection->Site/Subsite->Document Library->Folder. Permission inheritance can be broken at any of these levels up until 100,000 items exist, at which point it is no longer possible. As a general best practice, it is best to break inheritance at the highest possible level in the hierarchy.
ECM will allow dynamic selection at any level of Site/Subsite/Document Library/Folder/SubFolder.
Content Server allows for only a single target Document Library to be selected per Content Repository configuration.
Pros:
- Can ensure security models are followed
- Can implement business logic around folders. E.g. create a new Document Library folder for every new Work Order that is created in Plant Maintenance
- ECM can link folders to SAP business objects vs individual documents. This can be used for scenarios where large batches of documents need to be easily linked to SAP Business Objects
Cons:
- Content Server does not inherently allow for custom folders to be created in its specification
There are three options available when deciding how to view SAP content stored and linked to SharePoint Online:
- SAP Viewer: The document is downloaded to the user’s computer and the SAP viewer will display the document
- SharePoint Authenticated URL Link: A SharePoint Viewing URL is returned to the user who must then authenticate to SharePoint to view the document. The user must have permissions to the Document. The document is viewed in the SharePoint web based viewer
- SharePoint Unauthenticated (Short Lived) URL Link: A short lived unauthenticated URL is generated and returned to the user. The user does not need to authenticate to SharePoint Online to view the item. The document is viewed in the SharePoint web based viewer. By default the URL expires in 1 minute, but this expiry period is configurable in docuflow
Each of the above options has pros and cons listed below:
Pros:
- SAP Viewer allows notes to be attached to documents
Cons:
- SAP Viewer has limited file type support
- SAP Viewer must be maintained on the user’s desktop (IT overhead)
- The document is downloaded (highest bandwidth) to the local computer before viewing
Pros:
- SharePoint Online Viewer has a wide range of file type support
- SharePoint Online Viewer is web based and runs in the browser
- The SAP viewer does not have to be installed or maintained
- The document does not need to be downloaded to the local computer before viewing (lowest bandwidth)
Cons:
- The user must have access rights to the document in the SharePoint Online document library
Pros:
- SharePoint Online Viewer has a wide range of file type support
- SharePoint Online Viewer is web based and runs in the browser
- The SAP viewer does not have to be installed or maintained
- The document does not need to be downloaded to the local computer before viewing (lowest bandwidth)
- The user does not need access rights to the document in the SharePoint Online document library, SAP controls access
Cons:
- Additional configuration of SharePoint site collections to allow unauthenticated URLs to be generated. Configuration of this setting is per Site Collection