C_FinDtaConstcyResultBusProc

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_FinDtaConstcyResultBusProc.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_FinDtaConstcyResultBusProc AS
SELECT
  ConsistencyAnalysisRun,
  CompanyCode,
  ImpactedBusinessProcess,
  TotalNumberOfIssues,
  _ConstcyResults.TotalNumberOfIssues AS TotalNumberOfErrors
FROM I_FinDtaConstcyRsltByBusProc AS _FinDtaConstcyResultBusProc
LEFT OUTER JOIN C_FinDtaConstcyIssDetBusProc AS _BusProcResultToIssue ON _FinDtaConstcyResultBusProc.ConsistencyAnalysisRun = _BusProcResultToIssue.ConsistencyAnalysisRun AND _FinDtaConstcyResultBusProc.CompanyCode = _BusProcResultToIssue.CompanyCode AND _FinDtaConstcyResultBusProc.ImpactedBusinessProcess = _BusProcResultToIssue.ImpactedBusinessProcess  -- association [1..*]
LEFT OUTER JOIN I_FinDtaConstcyIssByCrrtnSts AS _BusProcResultToIssueCrrtnSts ON _FinDtaConstcyResultBusProc.ConsistencyAnalysisRun = _BusProcResultToIssueCrrtnSts.ConsistencyAnalysisRun AND _FinDtaConstcyResultBusProc.CompanyCode = _BusProcResultToIssueCrrtnSts.CompanyCode AND _FinDtaConstcyResultBusProc.ImpactedBusinessProcess = _BusProcResultToIssueCrrtnSts.ImpactedBusinessProcess  -- association [1..*]
LEFT OUTER JOIN I_FinDtaConstcyIssByCritlty AS _BusProcResultToIssueCritlty ON _FinDtaConstcyResultBusProc.ConsistencyAnalysisRun = _BusProcResultToIssueCritlty.ConsistencyAnalysisRun AND _FinDtaConstcyResultBusProc.CompanyCode = _BusProcResultToIssueCritlty.CompanyCode AND _FinDtaConstcyResultBusProc.ImpactedBusinessProcess = _BusProcResultToIssueCritlty.ImpactedBusinessProcess  -- association [1..*]
LEFT OUTER JOIN C_FinDtaConstcyIssByErrGrp AS _BusProcResultToIssueErrGrp ON _FinDtaConstcyResultBusProc.ConsistencyAnalysisRun = _BusProcResultToIssueErrGrp.ConsistencyAnalysisRun AND _FinDtaConstcyResultBusProc.CompanyCode = _BusProcResultToIssueErrGrp.CompanyCode AND _FinDtaConstcyResultBusProc.ImpactedBusinessProcess = _BusProcResultToIssueErrGrp.ImpactedBusinessProcess  -- association [1..*]
LEFT OUTER JOIN I_FinDtaConstcyBusProcText AS _BusinessProcessText ON _FinDtaConstcyResultBusProc.ImpactedBusinessProcess = _BusinessProcessText.ImpactedBusinessProcess  -- association [1..1]
LEFT OUTER JOIN C_FinDtaConstcyResult AS _ConstcyResults ON _FinDtaConstcyResultBusProc.ConsistencyAnalysisRun = _ConstcyResults.ConsistencyAnalysisRun AND _FinDtaConstcyResultBusProc.CompanyCode = _ConstcyResults.CompanyCode  -- association [1..1]
;