I_MDQltyBPCustCoCodeResult

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_MDQltyBPCustCoCodeResult.
-- 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: CMDQBPCUSTCORES

CREATE VIEW I_MDQltyBPCustCoCodeResult AS
SELECT
  partner AS BusinessPartner,
  cast(_MultipleAssignment.BPObjectID as kunnr) AS Customer,
  knb1_dq_res.bukrs AS CompanyCode,
  ruleuuid AS MDQualityBusinessRuleUUID,
  resulttype AS MDQltyBusRuleEvalResultCode,
  knb1_dq_res.process_id AS MasterDataChangeProcess,
  assignment_id AS BPAssignmentID,
  _MultipleAssignment.AddressNumber AS AddressNumber,
  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,
  basetable AS MDQltyBusinessRuleBaseTable
FROM knb1_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]
;