I_ARunRelChkVariantTP

DDL: I_ARUNRELCHKVARIANTTP Type: view TRANSACTIONAL
34 Fields 1 Data Sources 3 Associations

Release Check Variant Trans. Processing

I_ARunRelChkVariantTP is a Transactional CDS View that provides data about "Release Check Variant Trans. Processing" in SAP S/4HANA. It reads from 1 data source (I_ARunRelChkVariant) and exposes 34 fields with key field ARunReleaseCheckVariantUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ARunRelChkVariant I_ARunRelChkVariant from

Associations (3)

CardinalityTargetAliasCondition
[1..*] I_ARunRelChkABOPVariantTP _RelChkBOPVar $projection.ARunReleaseCheckVariantUUID = _RelChkBOPVar.ARunReleaseCheckVariantUUID
[1..*] I_ARunRelChkRelRuleTP _RelChkRelRule $projection.ARunReleaseCheckVariantUUID = _RelChkRelRule.ARunReleaseCheckVariantUUID
[1..*] I_ARunRelChkDetnLogicTP _RelChkDet $projection.ARunReleaseCheckVariantUUID = _RelChkDet.ARunReleaseCheckVariantUUID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IARUNRELCHKVARTP view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK 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 ARUNRCVAR_D view
EndUserText.label Release Check Variant Trans. Processing view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY ARunReleaseCheckVariantUUID ARunReleaseCheckVariantUUID Release Check UUID
ARunReleaseCheckVariantName ARunReleaseCheckVariantName RC Variant
ARunReleaseCheckVariantDesc 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
_RelChkBOPVar _RelChkBOPVar
_RelChkRelRule _RelChkRelRule
_RelChkDet _RelChkDet
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
ARunDemandGroupRule ARunDemandGroupRule Demand Group Rule
ARunDemandGroupRuleUUID ARunDemandGroupRuleUUID ARun Group Rule UUID
ARunIncompleteItmIsIncluded ARunIncompleteItmIsIncluded Include Incomplete Items
ARunUnconfirmedItmIsIncluded ARunUnconfirmedItmIsIncluded Include Unconfirmed Items
ARunDocItemGroupRuleName ARunDocItemGroupRuleName Demand Group Rule
ARunDocumentItemGroupRuleUUID ARunDocumentItemGroupRuleUUID Doc Item Group UUID
ARunHdrGroupRuleName ARunHdrGroupRuleName Demand Group Rule
ARunHeaderGroupRuleUUID ARunHeaderGroupRuleUUID Header Group UUID
ARunRelChkRunQtyRoundingStrgy ARunRelChkRunQtyRoundingStrgy Rounding Strategy
ARunRelChkRunMngExssQtyAssgd ARunRelChkRunMngExssQtyAssgd Manage excess QTY
ARunRelChkDocSelIsABOPSgmt ARunRelChkDocSelIsABOPSgmt Select documents using BOP sgmt
ARunRelChkRdyForDlvStsIsExcld ARunRelChkRdyForDlvStsIsExcld Exclude Status F
ARunRelChkHoldForDlvStsIsExcld ARunRelChkHoldForDlvStsIsExcld Exclude Status H
ARunRelChkOnResvnStsIsExcld ARunRelChkOnResvnStsIsExcld Exclude Status R
ARunRelChkInbForOutbStsIsExcld ARunRelChkInbForOutbStsIsExcld Exclude Status C

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_ARunRelChkVariantTP.
-- 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_ARunRelChkVariantTP AS
SELECT
  ARunReleaseCheckVariantUUID,
  ARunReleaseCheckVariantName,
  ARunReleaseCheckVariantDesc,
  SupAssignRunIsSimulation,
  ARunReleaseCheckGroupName,
  ARunReferenceReleaseRule,
  ARunRelRuleDeterminationMethod,
  ARunRelChkQtySelectionMethod,
  ARunFailedQtyIsIncluded,
  ARunDeliveryQtyIsIncluded,
  CreationDateTime,
  LastChangeDateTime,
  CreatedByUser,
  LastChangedByUser,
  ARunDemandGroupRule,
  ARunDemandGroupRuleUUID,
  ARunIncompleteItmIsIncluded,
  ARunUnconfirmedItmIsIncluded,
  ARunDocItemGroupRuleName,
  ARunDocumentItemGroupRuleUUID,
  ARunHdrGroupRuleName,
  ARunHeaderGroupRuleUUID,
  ARunRelChkRunQtyRoundingStrgy,
  ARunRelChkRunMngExssQtyAssgd,
  ARunRelChkDocSelIsABOPSgmt,
  ARunRelChkRdyForDlvStsIsExcld,
  ARunRelChkHoldForDlvStsIsExcld,
  ARunRelChkOnResvnStsIsExcld,
  ARunRelChkInbForOutbStsIsExcld
FROM I_ARunRelChkVariant
LEFT OUTER JOIN I_ARunRelChkABOPVariantTP AS _RelChkBOPVar ON ARunReleaseCheckVariantUUID = _RelChkBOPVar.ARunReleaseCheckVariantUUID  -- association [1..*]
LEFT OUTER JOIN I_ARunRelChkRelRuleTP AS _RelChkRelRule ON ARunReleaseCheckVariantUUID = _RelChkRelRule.ARunReleaseCheckVariantUUID  -- association [1..*]
LEFT OUTER JOIN I_ARunRelChkDetnLogicTP AS _RelChkDet ON ARunReleaseCheckVariantUUID = _RelChkDet.ARunReleaseCheckVariantUUID  -- association [1..*]
;

Learn More