How to extract SAP document attachments into Alteryx

In this demo you will learn how the DVW Alteryx Connector for SAP, SAP Document Read Tool allows users to: ​​Search for & extract attachments from SAP Transactional Data and Master Data in any of the SAP supported MIME type formats including texts, images, audio, video and applications such as PDF, MS Word, MS Excel, MS Powerpoint etc.

Highlights

• Quick SAP Attachment Extraction: Extract attachments in a few simple steps using Alteryx.
• Transaction FB03: Demonstrates accessing an SAP document with an attachment.
• Document Mapping: Uses company code to find document-attachment mappings in SAP tables.
• Dynamic Filters: Employs filters to specify the documents of interest.
• Hex to Blob Conversion: Converts hexadecimal data to blob format for attachments.
• File Naming: Dynamically generates descriptive file names for attachments. 
• Outputting Files: Outputs the final attachments to a specified destination.

Key Insights

• Streamlined Process: The workflow showcases an efficient method for extracting SAP attachments, making it accessible even for beginners.
• Importance of Mapping: Understanding the mapping between documents and attachments is crucial for successful extraction.
• Dynamic Filtering Benefits: Utilizing dynamic filters allows for precise data retrieval, enhancing workflow efficiency.
• Technical Table Utilization: Leveraging technical tables in SAP is key to linking documents with their respective attachments.
• Tool Integration: The integration of various Alteryx tools (e.g., logon, summation, and blob output) demonstrates the platform’s versatility and capability.
• Importance of Proper Naming: Creating meaningful file names is vital for easy identification and organization of extracted attachments.
• Successful Workflow Execution: Running the entire workflow successfully confirms the effectiveness of the extraction process in a short time frame.

More DVW Alteryx Connector for SAP Demos