I_MDQltyBPCustSalesAreaResult

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 I_MDQltyBPCustSalesAreaResult.
-- 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.
-- SQL view name: CMDQBPCUSTSARES

CREATE VIEW I_MDQltyBPCustSalesAreaResult AS
SELECT
  knvv_dq_res.partner AS BusinessPartner,
  cast(_MultipleAssignment.BPObjectID as kunnr) AS Customer,
  knvv_dq_res.vkorg AS SalesOrganization,
  knvv_dq_res.vtweg AS DistributionChannel,
  knvv_dq_res.spart AS Division,
  knvv_dq_res.ruleuuid AS MDQualityBusinessRuleUUID,
  knvv_dq_res.resulttype AS MDQltyBusRuleEvalResultCode,
  knvv_dq_res.process_id AS MasterDataChangeProcess,
  knvv_dq_res.assignment_id AS BPAssignmentID,
  _MultipleAssignment.AddressNumber AS AddressNumber,
  knvv_dq_res.result_count AS MDQltyNmbrOfBusRuleEvalResults,
  dats_tims_to_tstmp( _MasterDataChangeProcess.finish_date, _MasterDataChangeProcess.finish_time, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as MDChgProcessFinishDateTime AS clientNULLasMDChgProcessFinishDateTime,
  knvv_dq_res.basetable AS MDQltyBusinessRuleBaseTable,
  _MasterDataChangeProcess.source_otc AS MDQltyBusinessObjectTypeCode
FROM knvv_dq_res
INNER JOIN mdc_d_prcroot AS _MasterDataChangeProcess ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MDQltyBusRuleEvalResult AS _MDQltyBusRuleEvalResult ON _MDQltyBusRuleEvalResult.MDQltyBusRuleEvalResultCode = MDQltyBusRuleEvalResultCode  -- association [0..1]
LEFT OUTER JOIN I_MDQltyBusRuleEvalResultText AS _MDQltyBusRuleEvalResultText ON _MDQltyBusRuleEvalResultText.MDQltyBusRuleEvalResultCode = MDQltyBusRuleEvalResultCode  -- association [0..*]
LEFT OUTER JOIN I_BPMultipleAssignment AS _MultipleAssignment ON _MultipleAssignment.BusinessPartner = BusinessPartner AND _MultipleAssignment.BPAssignmentID = BPAssignmentID  -- association [0..1]
;