I_MDChangeProcessConfignTP

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_MDChangeProcessConfignTP.
-- 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: IMDCHGPROCCONFTP

CREATE VIEW I_MDChangeProcessConfignTP AS
SELECT
  db_key AS MDChgProcConfignUUID,
  conf_id AS MDChangeProcessConfiguration,
  source_otc AS MDChgProcessSrceObjectTypeCode,
  step_type AS MDChgProcessStepType,
  adapter AS MDChgProcessStepAdapter,
  parallel_procs AS MDChgProcNmbrParallelProcesses,
  queue_prefix AS MDChgProcQueuePrefix
FROM mdc_d_cnfroot
LEFT OUTER JOIN I_MDChgProcConfignActvtTP AS _ActvtConfign ON _ActvtConfign.MDChgProcConfignUUID = MDChgProcConfignUUID  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcConfignBRCTP AS _BestRecdConfign ON _BestRecdConfign.MDChgProcConfignUUID = MDChgProcConfignUUID  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcConfignFilterTP AS _FilterConfign ON _FilterConfign.MDChgProcConfignUUID = MDChgProcConfignUUID  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcConfignFuzzyTP AS _FuzzyConfign ON _FuzzyConfign.MDChgProcConfignUUID = MDChgProcConfignUUID  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcConfignMtchgAddrTP AS _MtchgAddrConfign ON _MtchgAddrConfign.MDChgProcConfignUUID = MDChgProcConfignUUID  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcConfignMtchgCstmTP AS _MtchgCstmConfign ON _MtchgCstmConfign.MDChgProcConfignUUID = MDChgProcConfignUUID  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcConfignMtchgFirmTP AS _MtchgFirmConfign ON _MtchgFirmConfign.MDChgProcConfignUUID = MDChgProcConfignUUID  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcConfignMtchgPersTP AS _MtchgPersConfign ON _MtchgPersConfign.MDChgProcConfignUUID = MDChgProcConfignUUID  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcConfignScopeTP AS _ScopeConfign ON _ScopeConfign.MDChgProcConfignUUID = MDChgProcConfignUUID  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcConfignStdTP AS _StdConfign ON _StdConfign.MDChgProcConfignUUID = MDChgProcConfignUUID  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcConfignValdtnTP AS _ValdtnConfign ON _ValdtnConfign.MDChgProcConfignUUID = MDChgProcConfignUUID  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcConfignEvalTP AS _EvalConfign ON _EvalConfign.MDChgProcConfignUUID = MDChgProcConfignUUID  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcConfignUpdateTP AS _UpdateConfign ON _UpdateConfign.MDChgProcConfignUUID = MDChgProcConfignUUID  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcConfignMassEnrichTP AS _MassEnrichConfign ON _MassEnrichConfign.MDChgProcConfignUUID = MDChgProcConfignUUID  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcConfignMassSearchTP AS _MassSearchConfign ON _MassSearchConfign.MDChgProcConfignUUID = MDChgProcConfignUUID  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcConfignSimlnTP AS _SimlnConfign ON _SimlnConfign.MDChgProcConfignUUID = MDChgProcConfignUUID  -- association [0..*]
;