C_AltvBsdConfAltvDetnTP

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_AltvBsdConfAltvDetnTP.
-- 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_AltvBsdConfAltvDetnTP AS
SELECT
  AltvBsdConfAltvDetnUUID,
  IsActiveEntity,
  HasDraftEntity,
  HasActiveEntity,
  AltvBsdConfAltvDetnName,
  AltvBsdConfAltvDetnSource,
  _AltvDetnSourceText.AltvBsdConfAltvDetnSourceText AS AltvBsdConfAltvDetnSourceText,
  SrceAltvConfAltvDetnTmplUUID,
  _AltvDetnTmplText.AltvBsdConfAltvDetnText AS SrceAltvConfAltvDetnTmplText,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  _TextInSessionLanguage.AltvBsdConfAltvDetnText AS AltvBsdConfAltvDetnText,
  NmbrOfRelatedAltvSubstnStrgies,
  CreationDateTime,
  CreatedByUser,
  cast(_CreatedByUser.UserDescription as atp_crted_by_user_description preserving type) AS CreatedByUserDescription,
  cast(CreatedByUser as atp_created_by_user_id preserving type) AS AltvConfAltvDetnCreatedByUser,
  cast(_CreatedByUser.UserDescription as atp_crted_by_user_description preserving type) AS AltvConfDetnCreatedByUserDesc,
  LastChangeDateTime,
  LastChangedByUser,
  cast(_LastChangedByUser.UserDescription as atp_chgd_by_user_description preserving type) AS LastChangedByUserDescription,
  cast(LastChangedByUser as atp_changed_by_user_id preserving type) AS AltvConfAltvDetnLastChgdByUser,
  cast(_LastChangedByUser.UserDescription as atp_chgd_by_user_description preserving type) AS AltvConfDetnLastChgdByUserDesc
FROM R_AltvBsdConfAltvDetnWithDraft
LEFT OUTER JOIN C_AltvBsdConfAltvDetnTextTP AS _Text ON AltvBsdConfAltvDetnUUID = _Text.AltvBsdConfAltvDetnUUID AND IsActiveEntity = _Text.IsActiveEntity  -- association [0..*]
LEFT OUTER JOIN C_AltvBsdConfAltvDetnTP AS _SiblingEntity ON AltvBsdConfAltvDetnUUID = _SiblingEntity.AltvBsdConfAltvDetnUUID AND IsActiveEntity != _SiblingEntity.IsActiveEntity  -- association [0..1]
LEFT OUTER JOIN C_AltvConfAltvDetnUsageInStrgy AS _UsageInStrategy ON AltvBsdConfAltvDetnUUID = _UsageInStrategy.AltvBsdConfAltvDetnUUID  -- association [0..*]
LEFT OUTER JOIN C_AltvConfRatgAttribBsdDetnTP AS _RatingAttributeBsdDetn ON AltvBsdConfAltvDetnUUID = _RatingAttributeBsdDetn.AltvBsdConfAltvDetnUUID  -- association [0..1]
LEFT OUTER JOIN C_AltvConfBusAddInBsdDetnTP AS _BusinessAddInBsdDetn ON AltvBsdConfAltvDetnUUID = _BusinessAddInBsdDetn.AltvBsdConfAltvDetnUUID  -- association [0..1]
LEFT OUTER JOIN C_AltvBsdConfAltvDetnTextTP AS _TextInSessionLanguage ON AltvBsdConfAltvDetnUUID = _TextInSessionLanguage.AltvBsdConfAltvDetnUUID AND IsActiveEntity = _TextInSessionLanguage.IsActiveEntity AND _TextInSessionLanguage.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AltvBsdConfAltvDetnSourceTxt AS _AltvDetnSourceText ON AltvBsdConfAltvDetnSource = _AltvDetnSourceText.AltvBsdConfAltvDetnSource AND _AltvDetnSourceText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AltvConfAltvDetnTmplText AS _AltvDetnTmplText ON SrceAltvConfAltvDetnTmplUUID = _AltvDetnTmplText.AltvBsdConfAltvDetnUUID AND _AltvDetnTmplText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DraftAdministrativeData AS _DraftAdministrativeData ON DraftAdministrativeDataUUID = _DraftAdministrativeData.DraftUUID  -- association [0..1]
;