I_ABOPCustomSortVH

DDL: I_ABOPCUSTOMSORTVH Type: view_entity BASIC Package: ATP_BOP_SETUP_VDM

Value Help for ABOP Custom Sort Name

I_ABOPCustomSortVH is a Basic CDS View that provides data about "Value Help for ABOP Custom Sort Name" in SAP S/4HANA. It reads from 1 data source (atp_bop_css) and exposes 9 fields with key field ABOPCustomSortName. It has 1 association to related views. Part of development package ATP_BOP_SETUP_VDM.

Data Sources (1)

SourceAliasJoin Type
atp_bop_css atp_bop_css from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ABOPCustomSortText _Text $projection.ABOPCustomSortUUID = _Text.ABOPCustomSortUUID and _Text.Language = $session.system_language

Annotations (6)

NameValueLevelField
EndUserText.label Value Help for ABOP Custom Sort Name view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ABOPCustomSortName abopcustomsortname Sequence Name
ABOPCustomSortUUID abopcustomsortuuid Cust. Sort Seq. UUID
ABOPSortAttribute abopsortattribute Sort Attribute
ABOPSortAttributeFldPathUUID abopsortattributefldpathuuid Product Allocation Characteristic Catalog Path UUID
CreationDateTime creationdatetime Timestamp
CreatedByUser createdbyuser User Name
LastChangeDateTime lastchangedatetime Timestamp
LastChangedByUser lastchangedbyuser User Name
_Text _Text

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_ABOPCustomSortVH.
-- 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_ABOPCustomSortVH AS
SELECT
  ABOPCustomSortName,
  ABOPCustomSortUUID,
  ABOPSortAttribute,
  ABOPSortAttributeFldPathUUID,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM atp_bop_css
LEFT OUTER JOIN I_ABOPCustomSortText AS _Text ON ABOPCustomSortUUID = _Text.ABOPCustomSortUUID AND _Text.Language = $session.system_language  -- association [0..1]
;