I_LCMContextTP

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_LCMContextTP.
-- 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_LCMContextTP AS
SELECT
  LglCntntMContextUUID,
  LglCntntMContext,
  LglCntntMContextVersion,
  LglCntntMContextTitle,
  LglCntntMContextStatus,
  LglCntntMContextStatus AS LglCntntMContextCurStatus,
  LglCntntMStsPrfl,
  LglCntntMContextOwner,
  LglCntntMCreatedByUser,
  LglCntntMCreatedUTCDateTime,
  LglCntntMChangedUTCDateTime,
  LglCntntMChangedByUser,
  cast ('' as lcm_is_used preserving type) AS LglCntntMIsUsed,
  cast ('' as lcm_ctx_operation_flag preserving type ) AS LglCntntMContextOperation,
  LglCntntMContextValidFromDate,
  LglCntntMContextValidToDate,
  LglCntntMPrevCntxtVers,
  LglCntntMCntxtIsReadOnly,
  LglCntntMProfile,
  IsEndOfPurposeBlocked,
  LglCntntMLongTextUUID,
  LglCntntMLongText,
  LglCntntMLongTextMimeType,
  LglCntntMCntxtLanguage,
  LglCntntMGovLaw,
  LglCntntMCntxtAccessLvl,
  LglCntntMMainOrgType,
  LglCntntMMainOrgCoCode,
  LglCntntMMainOrgSalesOrg,
  LglCntntMMainOrgPurOrg,
  LglCntntMIntegrationType
FROM I_LcmContext
LEFT OUTER JOIN E_LglCntntMContext AS _Extension ON LglCntntMContextUUID = _Extension.LglCntntMContextUUID  -- association [1..1]
LEFT OUTER JOIN I_LglCntntMAccessLvlText AS _LglCntntMAccessLvlText ON LglCntntMCntxtAccessLvl = _LglCntntMAccessLvlText.LglCntntMAccessLvl  -- association [0..*]
LEFT OUTER JOIN I_LglCntntMProfileText AS _LglCntntMProfileText ON LglCntntMProfile = _LglCntntMProfileText.LglCntntMProfile  -- association [0..*]
LEFT OUTER JOIN I_LanguageText AS _LanguageText ON LglCntntMCntxtLanguage = _LanguageText.LanguageCode  -- association [0..*]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrganizationText ON LglCntntMMainOrgSalesOrg = _SalesOrganizationText.SalesOrganization  -- association [0..*]
LEFT OUTER JOIN I_LCMStatusText AS _LglCntntMCntxtCurrentStsTxt ON LglCntntMContextCurStatus = _LglCntntMCntxtCurrentStsTxt.LglCntntMStatus  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON LglCntntMMainOrgCoCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_LCMContextEntity AS _LCMContextMainEntity ON _LCMContextMainEntity.LglCntntMContextUUID = LglCntntMContextUUID AND _LCMContextMainEntity.LglCntntMIsMainEntity = 'X'  -- association [0..1]
LEFT OUTER JOIN I_LCMCtxIntContactTP AS _LCMCtxIntContactTP ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_LCMCtxExtContactTP AS _LCMCtxExtContactTP ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_LCMContextEntityTP AS _LCMContextEntityTP ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_LCMContextDateTP AS _LCMContextDateTP ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_LCMContextRelationshipTP AS _LCMContextRelationshipTP ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_LCMContextObjectLinksTP AS _LCMContextObjectLinksTP ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_LCMContextCategoryGroupTP AS _LCMContextCategoryGroupTP ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_LglCntntMContextDocTP AS _LglCntntMContextDocTP ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_LglCntntMCntxtRnwlAndTermnTP AS _LglCntntMCntxtRnwlAndTermnTP ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMCntxtPhseTP AS _LglCntntMCntxtPhseTP ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_LglCntntMCntxtRuleGroupTP AS _LglCntntMCntxtRuleGroupTP ON /* condition not available in parsed metadata */  -- association [1..*]
;