I_LglCntntMContextBasic

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_LglCntntMContextBasic.
-- 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: ILCMCONTEXTBASIC

CREATE VIEW I_LglCntntMContextBasic AS
SELECT
  LglCntntMContextUUID,
  LglCntntMContext,
  LglCntntMContextVersion,
  LglCntntMContextTitle,
  LglCntntMContextStatus,
  LglCntntMStsPrfl,
  LglCntntMContextOwner,
  LglCntntMCreatedByUser,
  LglCntntMCreatedUTCDateTime,
  LglCntntMChangedUTCDateTime,
  LglCntntMChangedByUser,
  LglCntntMContextValidFromDate,
  LglCntntMContextValidToDate,
  LglCntntMCntxtLanguage,
  LglCntntMPrevCntxtVers,
  LglCntntMCntxtIsReadOnly,
  LglCntntMProfile,
  IsEndOfPurposeBlocked,
  LglCntntMGovLaw,
  LglCntntMCntxtAccessLvl,
  LglCntntMMainOrgType,
  LglCntntMMainOrgCoCode,
  LglCntntMMainOrgSalesOrg,
  LglCntntMMainOrgPurOrg,
  LglCntntMLongTextUUID,
  LglCntntMIntegrationType
FROM lcm_context
LEFT OUTER JOIN I_LglCntntMGovLaw AS _LglCntntMGovLaw ON LglCntntMGovLaw = _LglCntntMGovLaw.LglCntntMGovLaw  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMAccessLvlText AS _LglCntntMAccessLvlText ON LglCntntMCntxtAccessLvl = _LglCntntMAccessLvlText.LglCntntMAccessLvl AND _LglCntntMAccessLvlText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMMainOrgTypeText AS _LglCntntMMainOrgTypeText ON LglCntntMMainOrgType = _LglCntntMMainOrgTypeText.LglCntntMMainOrgType  -- association [0..*]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON LglCntntMMainOrgPurOrg = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrganizationText ON LglCntntMMainOrgSalesOrg = _SalesOrganizationText.SalesOrganization  -- association [0..*]
LEFT OUTER JOIN I_LglCntntMProfileText AS _LglCntntMProfileText ON LglCntntMProfile = _LglCntntMProfileText.LglCntntMProfile AND _LglCntntMProfileText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMIntegTypeText AS _LglCntntMIntegTypeText ON LglCntntMIntegrationType = _LglCntntMIntegTypeText.LglCntntMIntegrationType  -- association [0..*]
LEFT OUTER JOIN I_LCMContextParentCategory AS _ContextParentCategory ON LglCntntMContextUUID = _ContextParentCategory.LglCntntMContextUUID  -- association [1..*]
LEFT OUTER JOIN I_LCMContextCategory AS _ContextCategory ON LglCntntMContextUUID = _ContextCategory.LglCntntMContextUUID  -- association [1..*]
LEFT OUTER JOIN I_LCMContextEntity AS _ContextEntity ON LglCntntMContextUUID = _ContextEntity.LglCntntMContextUUID  -- association [1..*]
LEFT OUTER JOIN I_LCMContextEntity AS _MainContextEntity ON LglCntntMContextUUID = _MainContextEntity.LglCntntMContextUUID AND _MainContextEntity.LglCntntMIsMainEntity = 'X'  -- association [1..1]
LEFT OUTER JOIN I_LCMStatusText AS _ContextStatusText ON LglCntntMContextStatus = _ContextStatusText.LglCntntMStatus AND _ContextStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LanguageText AS _LanguageText ON LglCntntMCntxtLanguage = _LanguageText.LanguageCode AND _LanguageText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LCMUserAddressAssignment AS _Owner ON LglCntntMContextOwner = _Owner.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_LCMUserAddressAssignment AS _CreatedBy ON LglCntntMCreatedByUser = _CreatedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_LCMUserAddressAssignment AS _ChangedBy ON LglCntntMChangedByUser = _ChangedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMUserDetails AS _OwnerUserDetails ON _OwnerUserDetails.ContactCardID = LglCntntMContextOwner  -- association [0..1]
LEFT OUTER JOIN E_LglCntntMContext AS _Extension ON LglCntntMContextUUID = _Extension.LglCntntMContextUUID  -- association [1..1]
;