C_ABOPSegmentTP

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_ABOPSegmentTP.
-- 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: CABOPSEGMENTTP

CREATE VIEW C_ABOPSegmentTP AS
SELECT
  ABOPSegmentUUID,
  ABOPSegmentCondition,
  ABOPSegmentProcedure,
  ABOPSegmentType,
  _TextInSessionLanguage.ABOPSegmentDescription AS ABOPSegmentDescription,
  ATPSelOptnToolDefUUID,
  cast( ' ' as atp_bop_sgmt_migrtn_is_open preserving type ) AS ABOPSgmtConditionMigrtnIsOpen,
  NumberOfRelatedABOPVariants,
  CreationDateTime,
  CreatedByUser,
  cast(_CreatedByUser.UserDescription as atp_crted_by_user_description) AS CreatedByUserDescription,
  cast(CreatedByUser as atp_created_by_user_id) AS ABOPSegmentCreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  cast(_LastChangedByUser.UserDescription as atp_chgd_by_user_description) AS LastChangedByUserDescription,
  cast(LastChangedByUser as atp_changed_by_user_id) AS ABOPSegmentLastChangedByUser,
  LastUsageUTCDateTime
FROM I_ABOPSegmentTP
LEFT OUTER JOIN C_ABOPSegmentSortTP AS _Sort ON ABOPSegmentUUID = _Sort.ABOPSegmentUUID  -- association [0..*]
LEFT OUTER JOIN C_ABOPSegmentTextTP AS _Text ON ABOPSegmentUUID = _Text.ABOPSegmentUUID  -- association [0..*]
LEFT OUTER JOIN C_ABOPSegmentTextTP AS _TextInSessionLanguage ON ABOPSegmentUUID = _TextInSessionLanguage.ABOPSegmentUUID AND _TextInSessionLanguage.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_ATPSelOptnToolDefinitionTP AS _SelOptnToolDefinition ON ATPSelOptnToolDefUUID = _SelOptnToolDefinition.ATPSelOptnToolDefUUID  -- association [0..1]
LEFT OUTER JOIN C_ABOPSegmentSimulationTP AS _Simulation ON ABOPSegmentUUID = _Simulation.ABOPSegmentUUID  -- association [0..*]
LEFT OUTER JOIN C_ABOPSegmentSimulationTP AS _SimulationByUser ON ABOPSegmentUUID = _SimulationByUser.ABOPSegmentUUID AND _SimulationByUser.CreatedByUser = $session.user  -- association [0..1]
LEFT OUTER JOIN I_ABOPVariantSegment AS _VariantSegment ON ABOPSegmentUUID = _VariantSegment.ABOPSegmentUUID  -- association [0..*]
LEFT OUTER JOIN C_ABOPVariantUsageInSegment AS _UsageInSegment ON ABOPSegmentUUID = _UsageInSegment.ABOPSegmentUUID  -- association [0..*]
;