I_ARunRule

DDL: I_ARUNRULE Type: view BASIC
39 Fields 1 Data Sources 3 Associations

Basic View for Supply Assignment Rule

I_ARunRule is a Basic CDS View that provides data about "Basic View for Supply Assignment Rule" in SAP S/4HANA. It reads from 1 data source (arun_rule) and exposes 39 fields with key field ARunRuleUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
arun_rule arun_rule from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ARunRuleText _ARunRuleText $projection.ARunRuleUUID = _ARunRuleText.ARunRuleUUID and _ARunRuleText.Language = $session.system_language
[0..1] I_ARunDemandGroupRule _ARunGroupRule $projection.ARunDemandGroupRuleUUID = _ARunGroupRule.ARunDemandGroupRuleUUID
[0..1] I_ARunSupSelRule _ARunSupSelRule $projection.ARunSupplySelectionRuleUUID = _ARunSupSelRule.ARunSupplySelectionRuleUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IARUNRULE view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Basic View for Supply Assignment Rule view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view
ObjectModel.representativeKey ARunRuleUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
AbapCatalog.preserveKey true view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY ARunRuleUUID arunruleuuid ARun Rule UUID
ARunRuleName arunrulename ARun Rule
ARunRuleDescription _ARunRuleText ARunRuleDescription ARun Rule Descriptio
ABOPStockSortRule abopstocksortrule Supply Sort Rule
ABOPAllocReleaseIsRequired abopallocreleaseisrequired Release Check Req.
ABOPSupplySelHorizonInDays abopsupplyselhorizonindays Supply Horizon
ABOPAssignmentPreviewIsActive abopassignmentpreviewisactive Assignment Preview
ABOPSupplyReassignmentIsReqd abopsupplyreassignmentisreqd Reassignment
ARunStkOverwriteIsRequired arunstkoverwriteisrequired Overwrite Supply Sel
ARunPhysicalStkIsSelected arunphysicalstkisselected Include Physical Sto
ARunPOStkIsSelected arunpostkisselected Include PO
ARunASNStkIsSelected arunasnstkisselected Incl. Shipping Not.
ARunProdnOrdStkIsSelected arunprodnordstkisselected Incl. Production Ord
ARunPurReqnStkIsSelected arunpurreqnstkisselected Incl. Purchase Req
ARunPlndOrdStkIsSelected arunplndordstkisselected Incl. Planned Order
ARunReleaseRule arunreleaserule Release Rule
ARunDistributionStrategy arundistributionstrategy ARun Distribution Lo
ARunGroupingStrategy arungroupingstrategy ARun Grouping Logic
ARunMinAssgmtPercent arunminassgmtpercent Min. Assgmt Percent
ARunMaxAssgmtPercent arunmaxassgmtpercent Max Assgmt Percent
ARunSupProtExecMode arunsupprotexecmode SUP Mode
ARunDemandGroupRuleUUID arundemandgroupruleuuid ARun Group Rule UUID
CreatedByUser createdbyuser User Name
CreationDateTime creationdatetime Timestamp
LastChangedByUser lastchangedbyuser User Name
LastChangeDateTime lastchangedatetime Timestamp
ARunIgnoreCanclnDteChk arunignorecanclndtechk Ignore Canc. Dt. Chk
ARunIgnoreStorLocChk arunignorestorlocchk Ignore S.loc Check
ARunRuleFilterMode arunrulefiltermode Filter Mode
ARunSupplySelectionRuleUUID arunsupplyselectionruleuuid ARun Sel Rule UUID
ARunIgnrCanclnDteSupDteChk arunignrcanclndtesupdtechk Ignr Canceln Dte Chk
ARunIgnrCanclnDteReqdDteChk arunignrcanclndtereqddtechk Canceln Date Check
ARunIncludeIncmpltOrdChk arunincludeincmpltordchk Incomplete Orders
ARunIgnoreBatchCheck arunignorebatchcheck Ignore Batch Check
ARunIgnorePastCanclnDateCheck arunignorepastcanclndatecheck Ignr Past Cancln Dte
ARunConfBsdSegmtnIsSeld arunconfbsdsegmtnisseld Con-based Seg & Prio
_ARunRuleText _ARunRuleText
_ARunGroupRule _ARunGroupRule
_ARunSupSelRule _ARunSupSelRule

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_ARunRule.
-- 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_ARunRule AS
SELECT
  ARunRuleUUID,
  ARunRuleName,
  _ARunRuleText.ARunRuleDescription AS ARunRuleDescription,
  ABOPStockSortRule,
  ABOPAllocReleaseIsRequired,
  ABOPSupplySelHorizonInDays,
  ABOPAssignmentPreviewIsActive,
  ABOPSupplyReassignmentIsReqd,
  ARunStkOverwriteIsRequired,
  ARunPhysicalStkIsSelected,
  ARunPOStkIsSelected,
  ARunASNStkIsSelected,
  ARunProdnOrdStkIsSelected,
  ARunPurReqnStkIsSelected,
  ARunPlndOrdStkIsSelected,
  ARunReleaseRule,
  ARunDistributionStrategy,
  ARunGroupingStrategy,
  ARunMinAssgmtPercent,
  ARunMaxAssgmtPercent,
  ARunSupProtExecMode,
  ARunDemandGroupRuleUUID,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  ARunIgnoreCanclnDteChk,
  ARunIgnoreStorLocChk,
  ARunRuleFilterMode,
  ARunSupplySelectionRuleUUID,
  ARunIgnrCanclnDteSupDteChk,
  ARunIgnrCanclnDteReqdDteChk,
  ARunIncludeIncmpltOrdChk,
  ARunIgnoreBatchCheck,
  ARunIgnorePastCanclnDateCheck,
  ARunConfBsdSegmtnIsSeld
FROM arun_rule
LEFT OUTER JOIN I_ARunRuleText AS _ARunRuleText ON ARunRuleUUID = _ARunRuleText.ARunRuleUUID AND _ARunRuleText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ARunDemandGroupRule AS _ARunGroupRule ON ARunDemandGroupRuleUUID = _ARunGroupRule.ARunDemandGroupRuleUUID  -- association [0..1]
LEFT OUTER JOIN I_ARunSupSelRule AS _ARunSupSelRule ON ARunSupplySelectionRuleUUID = _ARunSupSelRule.ARunSupplySelectionRuleUUID  -- association [0..1]
;

Learn More