I_ARunRelChkVariant

DDL: I_ARUNRELCHKVARIANT Type: view BASIC
31 Fields 2 Data Sources 5 Associations

Basic View for Release Check Variant

I_ARunRelChkVariant is a Basic CDS View that provides data about "Basic View for Release Check Variant" in SAP S/4HANA. It reads from 2 data sources (arun_rc_variant, I_ARunRelChkVarDesc) and exposes 31 fields with key field ARunReleaseCheckVariantUUID. It has 5 associations to related views.

Data Sources (2)

SourceAliasJoin Type
arun_rc_variant RelChkVar from
I_ARunRelChkVarDesc RelChkVarDesc inner

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_User _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID
[0..1] I_User _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID
[0..1] I_ARunDemandGroupRule _ARunGroupRule $projection.ARunDemandGroupRuleUUID = _ARunGroupRule.ARunDemandGroupRuleUUID
[0..1] I_ARunDemandGroupRule _ARunDocumentItemGroupRule $projection.ARunDocumentItemGroupRuleUUID = _ARunDocumentItemGroupRule.ARunDemandGroupRuleUUID
[0..1] I_ARunDemandGroupRule _ARunHeaderGroupRule $projection.ARunHeaderGroupRuleUUID = _ARunHeaderGroupRule.ARunDemandGroupRuleUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IARUNRELCHKVAR view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Basic View for Release Check Variant view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY ARunReleaseCheckVariantUUID arun_rc_variant arunreleasecheckvariantuuid Release Check UUID
ARunReleaseCheckVariantName arunreleasecheckvariantname RC Variant
ARunReleaseCheckVariantDesc I_ARunRelChkVarDesc ARunReleaseCheckVariantDesc ARun Release Check Variant Description
SupAssignRunIsSimulation supassignrunissimulation Simulation
ARunReleaseCheckGroupName arunreleasecheckgroupname ARun Release Check Variant Group
ARunReferenceReleaseRule arunreferencereleaserule Release Rule
ARunRelRuleDeterminationMethod arunrelruledeterminationmethod Determin.Logic
ARunRelChkQtySelectionMethod arunrelchkqtyselectionmethod Supply Assignment Release Check Quantity Selection Methods
ARunFailedQtyIsIncluded arunfailedqtyisincluded Include Failed Quantities
ARunDeliveryQtyIsIncluded arundeliveryqtyisincluded Include Delivery/GI Quantities
CreationDateTime creationdatetime Timestamp
LastChangeDateTime lastchangedatetime Timestamp
CreatedByUser createdbyuser User Name
LastChangedByUser lastchangedbyuser User Name
ARunDemandGroupRuleUUID arundemandgroupruleuuid ARun Group Rule UUID
ARunDemandGroupRule _ARunGroupRule ARunDemandGroupRule Demand Group Rule
ARunIncompleteItmIsIncluded arunincompleteitmisincluded Include Incomplete Items
ARunUnconfirmedItmIsIncluded arununconfirmeditmisincluded Include Unconfirmed Items
ARunDocumentItemGroupRuleUUID arun_rc_variant arundocumentitemgroupruleuuid Doc Item Group UUID
ARunDocItemGroupRuleName _ARunDocumentItemGroupRule ARunDemandGroupRule Demand Group Rule
ARunHeaderGroupRuleUUID arun_rc_variant arunheadergroupruleuuid Header Group UUID
ARunHdrGroupRuleName _ARunHeaderGroupRule ARunDemandGroupRule Demand Group Rule
ARunRelChkRunQtyRoundingStrgy arun_rc_variant arunrelchkrunqtyroundingstrgy Rounding Strategy
ARunRelChkRunMngExssQtyAssgd arun_rc_variant arunrelchkrunmngexssqtyassgd Manage excess QTY
ARunRelChkDocSelIsABOPSgmt arunrelchkdocselisabopsgmt Select documents using BOP sgmt
ARunRelChkRdyForDlvStsIsExcld arun_rc_variant arunrelchkrdyfordlvstsisexcld Exclude Status F
ARunRelChkHoldForDlvStsIsExcld arun_rc_variant arunrelchkholdfordlvstsisexcld Exclude Status H
ARunRelChkOnResvnStsIsExcld arun_rc_variant arunrelchkonresvnstsisexcld Exclude Status R
ARunRelChkInbForOutbStsIsExcld arun_rc_variant arunrelchkinbforoutbstsisexcld Exclude Status C
_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_ARunRelChkVariant.
-- 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.

CREATE VIEW I_ARunRelChkVariant AS
SELECT
  RelChkVar.arunreleasecheckvariantuuid AS ARunReleaseCheckVariantUUID,
  ARunReleaseCheckVariantName,
  RelChkVarDesc.ARunReleaseCheckVariantDesc AS ARunReleaseCheckVariantDesc,
  SupAssignRunIsSimulation,
  ARunReleaseCheckGroupName,
  ARunReferenceReleaseRule,
  ARunRelRuleDeterminationMethod,
  ARunRelChkQtySelectionMethod,
  ARunFailedQtyIsIncluded,
  ARunDeliveryQtyIsIncluded,
  CreationDateTime,
  LastChangeDateTime,
  CreatedByUser,
  LastChangedByUser,
  ARunDemandGroupRuleUUID,
  _ARunGroupRule.ARunDemandGroupRule AS ARunDemandGroupRule,
  ARunIncompleteItmIsIncluded,
  ARunUnconfirmedItmIsIncluded,
  RelChkVar.arundocumentitemgroupruleuuid AS ARunDocumentItemGroupRuleUUID,
  _ARunDocumentItemGroupRule.ARunDemandGroupRule AS ARunDocItemGroupRuleName,
  RelChkVar.arunheadergroupruleuuid AS ARunHeaderGroupRuleUUID,
  _ARunHeaderGroupRule.ARunDemandGroupRule AS ARunHdrGroupRuleName,
  RelChkVar.arunrelchkrunqtyroundingstrgy AS ARunRelChkRunQtyRoundingStrgy,
  RelChkVar.arunrelchkrunmngexssqtyassgd AS ARunRelChkRunMngExssQtyAssgd,
  ARunRelChkDocSelIsABOPSgmt,
  RelChkVar.arunrelchkrdyfordlvstsisexcld AS ARunRelChkRdyForDlvStsIsExcld,
  RelChkVar.arunrelchkholdfordlvstsisexcld AS ARunRelChkHoldForDlvStsIsExcld,
  RelChkVar.arunrelchkonresvnstsisexcld AS ARunRelChkOnResvnStsIsExcld,
  RelChkVar.arunrelchkinbforoutbstsisexcld AS ARunRelChkInbForOutbStsIsExcld
FROM arun_rc_variant AS RelChkVar
INNER JOIN I_ARunRelChkVarDesc AS RelChkVarDesc ON /* join condition not captured in parsed metadata */
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]
LEFT OUTER JOIN I_ARunDemandGroupRule AS _ARunGroupRule ON ARunDemandGroupRuleUUID = _ARunGroupRule.ARunDemandGroupRuleUUID  -- association [0..1]
LEFT OUTER JOIN I_ARunDemandGroupRule AS _ARunDocumentItemGroupRule ON ARunDocumentItemGroupRuleUUID = _ARunDocumentItemGroupRule.ARunDemandGroupRuleUUID  -- association [0..1]
LEFT OUTER JOIN I_ARunDemandGroupRule AS _ARunHeaderGroupRule ON ARunHeaderGroupRuleUUID = _ARunHeaderGroupRule.ARunDemandGroupRuleUUID  -- association [0..1]
;

Learn More