I_WorkViewAssgmtTP

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_WorkViewAssgmtTP.
-- 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 I_WorkViewAssgmtTP AS
SELECT
  I_WorkViewAssgmt.WorkView AS WorkView,
  I_WorkViewAssgmt.WorkViewAssgmtUUID AS WorkViewAssgmtUUID,
  I_WorkViewAssgmt.WorkViewUUID AS WorkViewUUID,
  I_WorkViewAssgmt.WorkViewGroupUUID AS WorkViewGroupUUID,
  I_WorkViewAssgmt.ComplianceRequirement AS ComplianceRequirement,
  I_WorkViewAssgmt.WorkViewComposition AS WorkViewComposition,
  I_WorkViewAssgmt.WorkViewProperty AS WorkViewProperty,
  I_WorkViewAssgmt.WorkViewDataType AS WorkViewDataType,
  I_WorkViewAssgmt.ProdCmplncLegalArea AS ProdCmplncLegalArea,
  I_WorkViewAssgmt.WorkViewComposition AS ChmlCompositionType,
  I_WorkViewAssgmt.CreationDateTime AS CreationDateTime,
  I_WorkViewAssgmt.CreatedByUser AS CreatedByUser,
  I_WorkViewAssgmt.LastChangeDateTime AS LastChangeDateTime,
  I_WorkViewAssgmt.LastChangedByUser AS LastChangedByUser
LEFT OUTER JOIN I_WorkViewCmplDataTP AS _ComplDataCmplncReq ON ComplianceRequirement = _ComplDataCmplncReq.CmplncData  -- association [1..1]
LEFT OUTER JOIN I_WorkViewCmpstnType AS _Composition ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_WorkViewCmpstnType AS _WorkViewCmpstnType ON ProdCmplncLegalArea = _WorkViewCmpstnType.WorkView  -- association [0..1]
LEFT OUTER JOIN I_PCPrptyRootTypeText AS _Property ON WorkViewProperty = _Property.DomainValue AND _Property.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_WorkViewTP AS _WorkView ON WorkViewUUID = _WorkView.WorkViewUUID AND WorkView = _WorkView.WorkView  -- association [0..1]
LEFT OUTER JOIN I_WorkViewComplianceTypeText AS _CmplTypeText ON WorkViewDataType = _CmplTypeText.CategoryFlag AND _CmplTypeText.Language = $session.system_language  -- association [0..1]
;