C_ARunDemandGroupValues

DDL: C_ARUNDEMANDGROUPVALUES SQL: CDMNDGRATVAL Type: view CONSUMPTION Package: ARUN_RULE
30 Fields 1 Data Sources 1 Associations 1 OData Services

ARun Demand Grouping Attribute Values

C_ARunDemandGroupValues is a Consumption CDS View that provides data about "ARun Demand Grouping Attribute Values" in SAP S/4HANA. It reads from 1 data source (I_ARunDemandGroupValuesTP) and exposes 30 fields with key field ARunDemandGroupValueUUID. It has 1 association to related views. It is exposed through 1 OData service (UI_RFM_ARUN_DEMAND_GROUP). Part of development package ARUN_RULE.

Data Sources (1)

SourceAliasJoin Type
I_ARunDemandGroupValuesTP I_ARunDemandGroupValuesTP from

Associations (1)

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

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CDMNDGRATVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label ARun Demand Grouping Attribute Values view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
UI.headerInfo.typeName Value view
UI.headerInfo.typeNamePlural Values view

OData Services (1)

ServiceBindingVersionContractRelease
UI_RFM_ARUN_DEMAND_GROUP UI_RFM_ARUN_DEMAND_GROUP V2 C1 NOT_RELEASED

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY ARunDemandGroupValueUUID ARunDemandGroupValueUUID ARun Group Valu UUID
ARunDemandGroupRuleUUID ARunDemandGroupRuleUUID ARun Group Rule UUID
ARunDemandCharc01Value ARunDemandCharc01Value Characteristic 1
ARunDemandCharc02Value ARunDemandCharc02Value Characteristic 2
ARunDemandCharc03Value ARunDemandCharc03Value Characteristic 3
ARunDemandCharc04Value ARunDemandCharc04Value Characteristic 4
ARunDemandCharc05Value ARunDemandCharc05Value Characteristic 5
ARunDemandCharc06Value ARunDemandCharc06Value Characteristic 6
ARunDemandCharc07Value ARunDemandCharc07Value Characteristic 7
ARunDemandCharc08Value ARunDemandCharc08Value Characteristic 8
ARunDemandCharc09Value ARunDemandCharc09Value Characteristic 9
ARunDemandCharc10Value ARunDemandCharc10Value Characteristic 10
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 ID
ARunGroupPriority ARunGroupPriority Group Priority
ARunReleaseRule ARunReleaseRule Release Rule
ARunMinAssgmtPercent ARunMinAssgmtPercent Minimum Assignment (%)
ARunMaxAssgmtPercent ARunMaxAssgmtPercent Maximum Assignment (%)
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 C_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: CDMNDGRATVAL

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

Learn More