C_ARunDemandSortRule

DDL: C_ARUNDEMANDSORTRULE SQL: CARNDMNDSRTRL Type: view CONSUMPTION Package: ARUN_RULE
11 Fields 1 Data Sources 3 Associations 1 OData Services

ARun Demand Sorting Rule

C_ARunDemandSortRule is a Consumption CDS View that provides data about "ARun Demand Sorting Rule" in SAP S/4HANA. It reads from 1 data source (I_ARunDemandSortRuleTP) and exposes 11 fields with key field ARunDemandSortRuleUUID. It has 3 associations to related views. It is exposed through 1 OData service (UI_RFM_ARUN_DEMAND_SORT). Part of development package ARUN_RULE.

Data Sources (1)

SourceAliasJoin Type
I_ARunDemandSortRuleTP I_ARunDemandSortRuleTP from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_User _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID
[0..1] I_User _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID
[0..*] C_ARunDemandSortAttrib _SortAttrib $projection.ARunDemandSortRuleUUID = _SortAttrib.ARunDemandSortRuleUUID

Annotations (23)

NameValueLevelField
AbapCatalog.sqlViewName CARNDMNDSRTRL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label ARun Demand Sorting Rule view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.createEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.draftEnabled true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.compositionRoot true view
ObjectModel.representativeKey ARunDemandSortRuleUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
UI.headerInfo.typeName Demand Sorting Rule view
UI.headerInfo.typeNamePlural Demand Sorting Rules view
UI.headerInfo.title.value ARunDemandSortRule view
UI.headerInfo.description.value ARunDemandSortRuleText view

OData Services (1)

ServiceBindingVersionContractRelease
UI_RFM_ARUN_DEMAND_SORT UI_RFM_ARUN_DEMAND_SORT V2 C1 NOT_RELEASED

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ARunDemandSortRuleUUID ARunDemandSortRuleUUID ARun Sort Rule UUID
ARunDemandSortRule ARunDemandSortRule Sorting Rule
ARunDemandSortRuleText ARunDemandSortRuleText Sorting Rule Description
CreatedByUser CreatedByUser Created By
CreatedByUserDescription _CreatedByUser UserDescription Created By User Description
CreationDateTime CreationDateTime Created On
LastChangedByUser LastChangedByUser Changed By
LastChangedByUserDescription _LastChangedByUser UserDescription Changed By User Description
LastChangeDateTime LastChangeDateTime Changed On
_SortRuleText _SortRuleText
_SortAttrib _SortAttrib

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_ARunDemandSortRule.
-- 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: CARNDMNDSRTRL

CREATE VIEW C_ARunDemandSortRule AS
SELECT
  ARunDemandSortRuleUUID,
  ARunDemandSortRule,
  ARunDemandSortRuleText,
  CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserDescription,
  CreationDateTime,
  LastChangedByUser,
  _LastChangedByUser.UserDescription AS LastChangedByUserDescription,
  LastChangeDateTime
FROM I_ARunDemandSortRuleTP
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN C_ARunDemandSortAttrib AS _SortAttrib ON ARunDemandSortRuleUUID = _SortAttrib.ARunDemandSortRuleUUID  -- association [0..*]
;

Learn More