I_ARunDemandGroupValues

DDL: I_ARUNDEMANDGROUPVALUES SQL: IDMNDGRVAL Type: view BASIC
30 Fields 1 Data Sources 1 Associations

ARun Demand Group Attribute Values

I_ARunDemandGroupValues is a Basic CDS View that provides data about "ARun Demand Group Attribute Values" in SAP S/4HANA. It reads from 1 data source (arun_dgroup_vals) and exposes 30 fields with key field ARunDemandGroupValueUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
arun_dgroup_vals arun_dgroup_vals from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ARunDemandGroupRule _GroupRule $projection.ARunDemandGroupRuleUUID = _GroupRule.ARunDemandGroupRuleUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IDMNDGRVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label ARun Demand Group Attribute Values view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY ARunDemandGroupValueUUID arundemandgroupvalueuuid ARun Group Valu UUID
ARunDemandGroupRuleUUID arundemandgroupruleuuid ARun Group Rule UUID
ARunGroupPriority arungrouppriority Group Priority
ARunDemandCharc01Value arundemandcharc01value Characteristic Value
ARunDemandCharc02Value arundemandcharc02value Characteristic Value
ARunDemandCharc03Value arundemandcharc03value Characteristic Value
ARunDemandCharc04Value arundemandcharc04value Characteristic Value
ARunDemandCharc05Value arundemandcharc05value Characteristic Value
ARunDemandCharc06Value arundemandcharc06value Characteristic Value
ARunDemandCharc07Value arundemandcharc07value Characteristic Value
ARunDemandCharc08Value arundemandcharc08value Characteristic Value
ARunDemandCharc09Value arundemandcharc09value Characteristic Value
ARunDemandCharc10Value arundemandcharc10value Characteristic Value
ARunDemandCharc01UUID arundemandcharc01uuid Product Allocation Characteristic Catalog Path UUID
ARunDemandCharc02UUID arundemandcharc02uuid Product Allocation Characteristic Catalog Path UUID
ARunDemandCharc03UUID arundemandcharc03uuid Product Allocation Characteristic Catalog Path UUID
ARunDemandCharc04UUID arundemandcharc04uuid Product Allocation Characteristic Catalog Path UUID
ARunDemandCharc05UUID arundemandcharc05uuid Product Allocation Characteristic Catalog Path UUID
ARunDemandCharc06UUID arundemandcharc06uuid Product Allocation Characteristic Catalog Path UUID
ARunDemandCharc07UUID arundemandcharc07uuid Product Allocation Characteristic Catalog Path UUID
ARunDemandCharc08UUID arundemandcharc08uuid Product Allocation Characteristic Catalog Path UUID
ARunDemandCharc09UUID arundemandcharc09uuid Product Allocation Characteristic Catalog Path UUID
ARunDemandCharc10UUID arundemandcharc10uuid Product Allocation Characteristic Catalog Path UUID
ARunDemandGroupID arundemandgroupid Group Name
ARunReleaseRule arunreleaserule Release Rule
ARunMinAssgmtPercent arunminassgmtpercent Min. Assgmt Percent
ARunMaxAssgmtPercent arunmaxassgmtpercent Max Assgmt Percent
ARunDmndSupSharePercent arundmndsupsharepercent Supply Share (%)
BusPrpsOfRefdValueIsCompleted busprpsofrefdvalueiscompleted Purpose Completed
_GroupRule _GroupRule

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_ARunDemandGroupValues.
-- 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: IDMNDGRVAL

CREATE VIEW I_ARunDemandGroupValues AS
SELECT
  ARunDemandGroupValueUUID,
  ARunDemandGroupRuleUUID,
  ARunGroupPriority,
  ARunDemandCharc01Value,
  ARunDemandCharc02Value,
  ARunDemandCharc03Value,
  ARunDemandCharc04Value,
  ARunDemandCharc05Value,
  ARunDemandCharc06Value,
  ARunDemandCharc07Value,
  ARunDemandCharc08Value,
  ARunDemandCharc09Value,
  ARunDemandCharc10Value,
  ARunDemandCharc01UUID,
  ARunDemandCharc02UUID,
  ARunDemandCharc03UUID,
  ARunDemandCharc04UUID,
  ARunDemandCharc05UUID,
  ARunDemandCharc06UUID,
  ARunDemandCharc07UUID,
  ARunDemandCharc08UUID,
  ARunDemandCharc09UUID,
  ARunDemandCharc10UUID,
  ARunDemandGroupID,
  ARunReleaseRule,
  ARunMinAssgmtPercent,
  ARunMaxAssgmtPercent,
  ARunDmndSupSharePercent,
  BusPrpsOfRefdValueIsCompleted
FROM arun_dgroup_vals
LEFT OUTER JOIN I_ARunDemandGroupRule AS _GroupRule ON ARunDemandGroupRuleUUID = _GroupRule.ARunDemandGroupRuleUUID  -- association [1..1]
;

Learn More