C_ChmlCmplncReqMntr

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_ChmlCmplncReqMntr.
-- 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_ChmlCmplncReqMntr AS
SELECT
  ComplianceRequest.ChmlCmplncRequestUUID AS ChmlCmplncRequestNavgnLink,
  cast( ComplianceRequest._Product._Text[1: Language = $session.system_language ].ProductName as ehfnd_cci_product_name ) AS ProductName,
  _ReqResponsibility._Text[1: Language = $session.system_language ].CmplncReqResponsibilityName AS CmplncReqResponsibilityName,
  cast( '' as ehfnd_country_desc_long ) AS CountryName,
  cast( ' ' as ehfnd_sales_org_id preserving type ) AS SalesOrganization,
  cast( ' ' as ehfnd_plant_id preserving type ) AS ActivePlant
FROM I_ChmlCmplncReqTP AS ComplianceRequest
LEFT OUTER JOIN C_ChmlCmplncReqMktTP AS _RequestedMarket ON ChmlCmplncRequestUUID = _RequestedMarket.ChmlCmplncRequestUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncReqPlntTP AS _RequestedPlnt ON ChmlCmplncRequestUUID = _RequestedPlnt.ChmlCmplncRequestUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncReqSlsOrgTP AS _RequestedSlsOrg ON ChmlCmplncRequestUUID = _RequestedSlsOrg.ChmlCmplncRequestUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncInfo AS _ChmlCmplncInfo ON ChmlCmplncInfoUUID = _ChmlCmplncInfo.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncBusProcVH AS _BusinessProcessVH ON ChmlCmplncBusinessProcess = _BusinessProcessVH.ChmlCmplncBusinessProcess  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncReqOrigTypeVH AS _OriginTypeVH ON ChmlCmplncRequestOriginType = _OriginTypeVH.ChmlCmplncRequestOriginType  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncReqOriginProcVH AS _OriginProcessVH ON ChmlCmplncReqOriginProc = _OriginProcessVH.ChmlCmplncReqOriginProc  -- association [1..1]
LEFT OUTER JOIN C_ChmlCmplncReqRequesterVH AS _RequesterVH ON ChmlCmplncReqBPRequester = _RequesterVH.ChmlCmplncReqBPRequester  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncReqRequesterUserVH AS _RequesterUserVH ON ChmlCmplncReqRequester = _RequesterUserVH.UserID  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncReqCmplncProcVH AS _CmplncProcVH ON ChmlCmplncReqCmplncProc = _CmplncProcVH.ChmlCmplncReqCmplncProc  -- association [1..1]
LEFT OUTER JOIN I_CmplncReqResponsibility AS _ReqResponsibility ON CmplncReqResponsibility = _ReqResponsibility.CmplncReqResponsibility  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _ActivePlant ON ActivePlant = _ActivePlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrganizationText ON SalesOrganization = _SalesOrganizationText.SalesOrganization  -- association [0..*]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroupVH ON MaterialGroup = _ProductGroupVH.ProductGroup  -- association [0..1]
;