I_ARunDemandGroupRuleTP

DDL: I_ARUNDEMANDGROUPRULETP SQL: IARNDMNDGRPRLTP Type: view TRANSACTIONAL Package: ARUN_RULE
11 Fields 1 Data Sources 3 Associations

ARun Demand Grouping Rule

I_ARunDemandGroupRuleTP is a Transactional CDS View that provides data about "ARun Demand Grouping Rule" in SAP S/4HANA. It reads from 1 data source (I_ARunDemandGroupRule) and exposes 11 fields with key field ARunDemandGroupRuleUUID. It has 3 associations to related views. Part of development package ARUN_RULE.

Data Sources (1)

SourceAliasJoin Type
I_ARunDemandGroupRule I_ARunDemandGroupRule from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_ARunDemandGroupAttribTP _GroupAttrib $projection.ARunDemandGroupRuleUUID = _GroupAttrib.ARunDemandGroupRuleUUID
[0..*] I_ARunDemandGroupValuesTP _GroupAttribVal $projection.ARunDemandGroupRuleUUID = _GroupAttribVal.ARunDemandGroupRuleUUID
[0..1] P_ARunDmndGrpRuleARunRule _GrpRuleARunRule $projection.ARunDemandGroupRuleUUID= _GrpRuleARunRule.ARunDemandGroupRuleUUID

Annotations (20)

NameValueLevelField
AbapCatalog.sqlViewName IARNDMNDGRPRLTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label ARun Demand Grouping Rule view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.compositionRoot true view
ObjectModel.createEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence ARNGRPRULE_D view
ObjectModel.sapObjectNodeType.name ARunDemandGroupRule view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ARunDemandGroupRuleUUID ARunDemandGroupRuleUUID ARun Group Rule UUID
ARunDemandGroupRule ARunDemandGroupRule Demand Group Rule
ARunDemandGroupRuleText ARunDemandGroupRuleText ARun Group Rule Text
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
ARunIsRuleUsed _GrpRuleARunRule ARunIsRuleUsed
_GroupRuleText _GroupRuleText
_GroupAttrib _GroupAttrib
_GroupAttribVal _GroupAttribVal

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_ARunDemandGroupRuleTP.
-- 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: IARNDMNDGRPRLTP

CREATE VIEW I_ARunDemandGroupRuleTP AS
SELECT
  ARunDemandGroupRuleUUID,
  ARunDemandGroupRule,
  ARunDemandGroupRuleText,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  _GrpRuleARunRule.ARunIsRuleUsed AS ARunIsRuleUsed
FROM I_ARunDemandGroupRule
LEFT OUTER JOIN I_ARunDemandGroupAttribTP AS _GroupAttrib ON ARunDemandGroupRuleUUID = _GroupAttrib.ARunDemandGroupRuleUUID  -- association [0..*]
LEFT OUTER JOIN I_ARunDemandGroupValuesTP AS _GroupAttribVal ON ARunDemandGroupRuleUUID = _GroupAttribVal.ARunDemandGroupRuleUUID  -- association [0..*]
LEFT OUTER JOIN P_ARunDmndGrpRuleARunRule AS _GrpRuleARunRule ON ARunDemandGroupRuleUUID= _GrpRuleARunRule.ARunDemandGroupRuleUUID  -- association [0..1]
;

Learn More