Reporting for Finance in SAP S/4HANA — Lesson 2: Custom CDS Views and Analytical Query Construction

Learning Objectives

• Explain how Custom CDS Views and Analytical Query Construction supports trusted embedded finance reporting.
• Complete the workflow and produce a reviewable custom CDS and query evidence portfolio.
• Evaluate the condition where a calculated measure returns inconsistent totals after drilldown and select a supported response.

Detailed Topics

• Custom CDS view applications: document sequence, decision points, and handoffs required for correct transaction execution.
• Associations, dimensions, and measures: determination logic and master-data influences that shape the resulting SAP document flow.
• Analytical query filters and formulas: status changes, confirmations, messages, and operational evidence produced during processing.
• Previewing and publishing analytical content: exception paths and recovery choices needed when normal processing cannot continue.

Instructor Demonstration

The instructor models an end-to-end decision path covering Custom CDS view applications, Associations, dimensions, and measures, Analytical query filters and formulas, Previewing and publishing analytical content. Navigation, documents, configuration influences, authorization boundaries, and retained evidence are connected to custom CDS and query evidence portfolio, including a controlled test where a calculated measure returns inconsistent totals after drilldown.

Hands-On Exercise

Complete a controlled activity covering Custom CDS view applications, Associations, dimensions, and measures, Analytical query filters and formulas, Previewing and publishing analytical content and preserve the final result in custom CDS and query evidence portfolio.

1. Define the expected business result and the SAP objects that should produce it.
2. Perform the lesson scenario, capturing before-and-after evidence for every material decision.
3. Test the exception without changing unrelated settings or data, then explain the first divergence.
4. Apply proportionate remediation and complete a focused regression test before handover.

Scenario Analysis

• Which SAP object, rule, master record, or process step most strongly influences the observed result?
• What evidence distinguishes a configuration problem from data, authorization, integration, or timing causes?
• How should the custom CDS and query evidence portfolio be approved, retained, monitored, and updated after handover?

Troubleshooting Guidance

Start at the earliest point where expected SAP behavior differs from the observed result. Review process sequence, master data, organizational assignments, configuration, authorization, integration, and timing separately. Treat “a calculated measure returns inconsistent totals after drilldown” as a testable hypothesis until settings, documents, logs, reports, and retest outcomes confirm the cause.

Validation Checklist

• Required structures, master data, roles, settings, and dependencies for Custom CDS Views and Analytical Query Construction are present.
• The custom CDS and query evidence portfolio connects each conclusion to objective, reviewable SAP evidence.
• Normal processing, the stated exception, integration behavior, and access boundaries were tested.
• Corrections, retest criteria, ownership, documentation, monitoring, and operational handover are complete.

Lesson Outcome

Learners can apply Custom CDS Views and Analytical Query Construction, explain the resulting SAP behavior, and defend the outcome through custom CDS and query evidence portfolio.