I_ABOPSegmentValueHelp

DDL: I_ABOPSEGMENTVALUEHELP SQL: IABOPSEGMENTVALH Type: view BASIC

Value Help for ABOP Variant Segments

I_ABOPSegmentValueHelp is a Basic CDS View that provides data about "Value Help for ABOP Variant Segments" in SAP S/4HANA. It reads from 1 data source (atp_bop_seg) and exposes 13 fields with key field ABOPSegmentName. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
atp_bop_seg atp_bop_seg from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ABOPSegmentText _Text $projection.ABOPSegmentUUID = _Text.ABOPSegmentUUID and _Text.Language = $session.system_language
[0..1] I_User _CreatedByUser _CreatedByUser.UserID = $projection.CreatedByUser
[0..1] I_User _LastChangedByUser _LastChangedByUser.UserID = $projection.LastChangedByUser

Annotations (11)

NameValueLevelField
EndUserText.label Value Help for ABOP Variant Segments view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IABOPSEGMENTVALH view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
ObjectModel.semanticKey ABOPSegmentName view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ABOPSegmentName abopsegmentname Segment Name
ABOPSegmentUUID abopsegmentuuid BOP Segment UUID
ABOPSegmentDescription _Text ABOPSegmentDescription Segment Description
ABOPSegmentCondition abopsegmentcondition Selection Criteria
ABOPSegmentType abopsegmenttype BOP Segment Type
ATPSelOptnToolDefUUID atpseloptntooldefuuid SOT Definition
CreationDateTime creationdatetime Timestamp
CreatedByUser createdbyuser User Name
LastChangeDateTime lastchangedatetime Timestamp
LastChangedByUser lastchangedbyuser User Name
_Text _Text
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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_ABOPSegmentValueHelp.
-- 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: IABOPSEGMENTVALH

CREATE VIEW I_ABOPSegmentValueHelp AS
SELECT
  ABOPSegmentName,
  ABOPSegmentUUID,
  _Text.ABOPSegmentDescription AS ABOPSegmentDescription,
  ABOPSegmentCondition,
  ABOPSegmentType,
  ATPSelOptnToolDefUUID,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM atp_bop_seg
LEFT OUTER JOIN I_ABOPSegmentText AS _Text ON ABOPSegmentUUID = _Text.ABOPSegmentUUID AND _Text.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON _LastChangedByUser.UserID = LastChangedByUser  -- association [0..1]
;