I_ABOPCustomSort

DDL: I_ABOPCUSTOMSORT SQL: IABOPCS Type: view BASIC Package: ATP_BOP_SETUP_VDM

ABOP Custom Sort Sequence

I_ABOPCustomSort is a Basic CDS View that provides data about "ABOP Custom Sort Sequence" in SAP S/4HANA. It reads from 1 data source (atp_bop_css) and exposes 15 fields with key field ABOPCustomSortUUID. It has 4 associations to related views. It is exposed through 1 OData service (ASQL_F2158). Part of development package ATP_BOP_SETUP_VDM.

Data Sources (1)

SourceAliasJoin Type
atp_bop_css atp_bop_css from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_ABOPCustomSortVal _CustomSortVal $projection.ABOPCustomSortUUID = _CustomSortVal.ABOPCustomSortUUID
[0..*] I_ABOPCustomSortText _Text $projection.ABOPCustomSortUUID = _Text.ABOPCustomSortUUID
[0..1] I_User _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID
[0..1] I_User _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID

Annotations (13)

NameValueLevelField
EndUserText.label ABOP Custom Sort Sequence view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IABOPCS view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey ABOPCustomSortUUID view
ObjectModel.compositionRoot true view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F2158 ASQL_F2158 C2 NOT_RELEASED

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ABOPCustomSortUUID abopcustomsortuuid Cust. Sort Seq. UUID
ABOPCustomSortName abopcustomsortname Sequence Name
ABOPSortAttribute abopsortattribute Sort Attribute
ABOPSortAttributeFldPathUUID abopsortattributefldpathuuid Product Allocation Characteristic Catalog Path UUID
ABOPSortAttributeFldPathIntID abopsortattributefldpathintid Catalog Path Internal ID
IsDefaultSortSequence isdefaultsortsequence Def. Cust. Sort Seq.
CreationDateTime creationdatetime Timestamp
CreatedByUser createdbyuser User Name
LastChangeDateTime lastchangedatetime Timestamp
LastChangedByUser lastchangedbyuser User Name
LastUsageUTCDateTime lastusageutcdatetime Used On
_CustomSortVal _CustomSortVal
_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_ABOPCustomSort.
-- 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: IABOPCS

CREATE VIEW I_ABOPCustomSort AS
SELECT
  ABOPCustomSortUUID,
  ABOPCustomSortName,
  ABOPSortAttribute,
  ABOPSortAttributeFldPathUUID,
  ABOPSortAttributeFldPathIntID,
  IsDefaultSortSequence,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  LastUsageUTCDateTime
FROM atp_bop_css
LEFT OUTER JOIN I_ABOPCustomSortVal AS _CustomSortVal ON ABOPCustomSortUUID = _CustomSortVal.ABOPCustomSortUUID  -- association [0..*]
LEFT OUTER JOIN I_ABOPCustomSortText AS _Text ON ABOPCustomSortUUID = _Text.ABOPCustomSortUUID  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
;