C_ChmlSuplrMatlMntr

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_ChmlSuplrMatlMntr.
-- 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_ChmlSuplrMatlMntr AS
SELECT
  SupplierMaterial.ChmlSuplrMatlUUID AS ChmlSuplrMatlNavgnLink,
  _SuplrMatlAssignment.ActiveChmlCmplncInfoUUID AS ChmlCmplncInfoNavgnLink,
  _BusinessPartner.SearchTerm2 AS SearchTerm2,
  _BusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  _BusinessPartner.OrganizationBPName2 AS OrganizationBPName2,
  _BusinessPartner.OrganizationBPName3 AS OrganizationBPName3,
  _BusinessPartner.OrganizationBPName4 AS OrganizationBPName4,
  _MaterialData.ChmlCmplncInternalName AS ChmlCmplncInternalName,
  _MaterialData.Material AS Material,
  SupplierMaterial._BusinessPartner AS _BusinessPartner,
  SupplierMaterial._BusinessPartnerSupplier AS _BusinessPartnerSupplier
FROM I_ChmlSuplrMatl AS SupplierMaterial
LEFT OUTER JOIN C_ChmlSuplrMatlSupplierContact AS _SupplierContactData ON BusinessPartnerSupplier = _SupplierContactData.BusinessPartnerSupplier  -- association [1..1]
LEFT OUTER JOIN I_ChmlCmplncSuplrForRawMatl AS _SuplrMatlAssignment ON ActiveChmlSuplrMatlUUID = _SuplrMatlAssignment.ChmlSuplrMatlUUID  -- association [1..1]
LEFT OUTER JOIN P_ChmlSuplrMatlDataMntr AS _MaterialData ON ActiveChmlSuplrMatlUUID = _MaterialData.ChmlSuplrMatlUUID  -- association [1..1]
LEFT OUTER JOIN P_ChmlSuplrMatlSuplrStsWithT AS _SupplierStatusWithOD ON ActiveChmlSuplrMatlUUID = _SupplierStatusWithOD.ChmlSuplrMatlUUID  -- association [1..1]
LEFT OUTER JOIN P_ChmlSuplrMatlDataStsSortSqnc AS _DataStatusSortSqnc ON ChmlSuplrMatlDataStatus = _DataStatusSortSqnc.ChmlSuplrMatlDataStatus  -- association [1..1]
LEFT OUTER JOIN I_ChmlSuplrMatlSuplrStsVH AS _ChmlSuplrMatlSuplrStsVH ON chmlsuplrmatlsuplrsts = _ChmlSuplrMatlSuplrStsVH.ChmlSuplrMatlSuplrSts  -- association [0..1]
LEFT OUTER JOIN I_ChmlSuplrMatlDataStsVH AS _ChmlSuplrMatlDataStsVH ON ChmlSuplrMatlDataStatus = _ChmlSuplrMatlDataStsVH.ChmlSuplrMatlDataStatus  -- association [0..1]
;