DTP
The Data Transfer Process (DTP) is the SAP BW/BW4HANA object that moves data between persistence layers (PSA, DataSource, ADSO/InfoCube, and other targets) using the rules defined in a Transformation. This part covers DTP fundamentals, types (full and delta), configuration, and intermediate design topics including filters, error handling, delta queue mechanics, semantic groups, and performance/troubleshooting in production landscapes.
Overview
The Data Transfer Process (DTP) is the SAP BW/BW4HANA object that moves data between persistence layers (PSA, DataSource, ADSO/InfoCube, and other targets) using the rules defined in a Transformation. This part covers DTP fundamentals, types (full and delta), configuration, and intermediate design topics including filters, error handling, delta queue mechanics, semantic groups, and performance/troubleshooting in production landscapes.
Lessons in this topic
- SAP DTP Tutorial (Part 1)Understand what a DTP is, why it exists between transformations and data targets, the difference between Full and Delta DTPs, and how to configure a basic DTP end to end.
- DTP Design in Practice: Filters, Error Handling, Delta Mechanics, and Troubleshooting (Part 2)Go beyond basic setup to design DTPs correctly for production: applying filters and semantic groups, configuring error stack handling, understanding delta queue mechanics, and diagnosing common load failures.
- DTP Error Handling, Semantic Groups and Delta Queue Management (Part 3)Learn how to configure DTP error handling, semantic grouping, and delta queue behavior to build resilient, restartable data loads in production BW and BW/4HANA landscapes.
- Advanced DTP: Architecture, Integration and Production Design (Part 4)Advanced capstone for DTP, connecting the existing lesson areas: DTP Fundamentals: Purpose, Types, and Basic Configuration; DTP Design in Practice: Filters, Error Handling, Delta Mechanics, and Troubleshooting; DTP Error Handling, Semantic Groups and Delta Queue Management. The goal is to move from feature knowledge to architecture, integration, production support and governance decisions.
Interview questions covered
- What are the core concepts of DTP, and how would you explain them clearly in an SAP interview?
- How would you apply DTP in a real SAP project? Walk through the design or implementation approach.
- A production issue is reported in DTP. What would you check first, and how would you troubleshoot it systematically?
- What are the most important design decisions, trade-offs, and best practices in DTP?
- Suppose you inherit an existing DTP solution. How would you review it before making a change?
- A senior architect is reviewing DTP. The project situation is: A retail company loads daily sales transactions from an ECC DataSource into a BW/4HANA ADSO. What design changes, validation evidence and production controls would you require before approving the solution?
- Using this SAP project situation — A retail company loads daily sales transactions from an ECC DataSource into a BW/4HANA ADSO — explain DTP Fundamentals: Purpose, Types, and Basic Configuration. What should happen, which concepts or process steps matter, and what common mistake would you avoid?
- A project encounters this situation while working on DTP Error Handling, Semantic Groups and Delta Queue Management: A retail BW client had a delta DTP loading POS transaction data into an ADSO nightly. Walk through how you would analyze the requirement or issue, what you would validate, and how you would test the solution before release.
- A project encounters this situation while working on DTP Design in Practice: Filters, Error Handling, Delta Mechanics, and Troubleshooting: A finance reporting team notices that a monthly aggregated key figure in an ADSO occasionally shows incorrect totals only on days with very high transaction volume. Walk through how you would analyze the requirement or issue, what you would validate, and how you would test the solution before release.