I_ARunRuleTP

DDL: I_ARUNRULETP SQL: IARUNRULETP Type: view TRANSACTIONAL Package: ARUN_RULE
42 Fields 1 Data Sources 1 Associations

Supply Assignment Rule TP View

I_ARunRuleTP is a Transactional CDS View that provides data about "Supply Assignment Rule TP View" in SAP S/4HANA. It reads from 1 data source (I_ARunRule) and exposes 42 fields with key field ARunRuleUUID. It has 1 association to related views. Part of development package ARUN_RULE.

Data Sources (1)

SourceAliasJoin Type
I_ARunRule I_ARunRule from

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_ARUNRULEABOPVARIANT _ARunRuleABOPVar $projection.ARunRuleUUID = _ARunRuleABOPVar.ARunRuleUUID

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IARUNRULETP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Supply Assignment Rule TP View view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL 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 ARUNRULE_D view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY ARunRuleUUID ARunRuleUUID ARun Rule UUID
ARunRuleName ARunRuleName ARun Rule
ARunRuleDescription 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
ARunSupplySelectionRuleUUID ARunSupplySelectionRuleUUID ARun Sel Rule UUID
ARunSupplySelectionRule _ARunSupSelRule ARunSupplySelectionRule ARun Supply Sel Rule
ARunDemandGroupRule _ARunGroupRule ARunDemandGroupRule Demand Group Rule
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
CreationDate
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangeDate
ARunIsRuleUsed _ARunRuleABOPVar ARunIsRuleUsed
ARunQtyRoundingStrgy ARunQtyRoundingStrgy Rounding Strategy
ARunIgnoreCanclnDteChk ARunIgnoreCanclnDteChk Ignore Canc. Dt. Chk
ARunIgnoreStorLocChk ARunIgnoreStorLocChk Ignore S.loc Check
ARunRuleFilterMode ARunRuleFilterMode Filter Mode
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

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_ARunRuleTP.
-- 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: IARUNRULETP

CREATE VIEW I_ARunRuleTP AS
SELECT
  ARunRuleUUID,
  ARunRuleName,
  ARunRuleDescription,
  ABOPStockSortRule,
  ABOPAllocReleaseIsRequired,
  ABOPSupplySelHorizonInDays,
  ABOPAssignmentPreviewIsActive,
  ABOPSupplyReassignmentIsReqd,
  ARunStkOverwriteIsRequired,
  ARunPhysicalStkIsSelected,
  ARunPOStkIsSelected,
  ARunASNStkIsSelected,
  ARunProdnOrdStkIsSelected,
  ARunPurReqnStkIsSelected,
  ARunPlndOrdStkIsSelected,
  ARunSupplySelectionRuleUUID,
  _ARunSupSelRule.ARunSupplySelectionRule AS ARunSupplySelectionRule,
  _ARunGroupRule.ARunDemandGroupRule AS ARunDemandGroupRule,
  ARunReleaseRule,
  ARunDistributionStrategy,
  ARunGroupingStrategy,
  ARunMinAssgmtPercent,
  ARunMaxAssgmtPercent,
  ARunSupProtExecMode,
  ARunDemandGroupRuleUUID,
  CreatedByUser,
  CreationDateTime,
  cast(tstmp_to_dats( CreationDateTime, 'UTC', $session.client, 'NULL' ) as sup_creation_date) AS CreationDate,
  LastChangedByUser,
  LastChangeDateTime,
  cast(tstmp_to_dats( LastChangeDateTime, 'UTC', $session.client, 'NULL' ) as sup_last_change_date) AS LastChangeDate,
  _ARunRuleABOPVar.ARunIsRuleUsed AS ARunIsRuleUsed,
  ARunQtyRoundingStrgy,
  ARunIgnoreCanclnDteChk,
  ARunIgnoreStorLocChk,
  ARunRuleFilterMode,
  ARunIgnrCanclnDteSupDteChk,
  ARunIgnrCanclnDteReqdDteChk,
  ARunIncludeIncmpltOrdChk,
  ARunIgnoreBatchCheck,
  ARunIgnorePastCanclnDateCheck,
  ARunConfBsdSegmtnIsSeld
FROM I_ARunRule
LEFT OUTER JOIN P_ARUNRULEABOPVARIANT AS _ARunRuleABOPVar ON ARunRuleUUID = _ARunRuleABOPVar.ARunRuleUUID  -- association [0..1]
;

Learn More