I_ARUNRELEASECHECKLEVEL

CDS View

Release Check level Calculation Query

I_ARUNRELEASECHECKLEVEL is a CDS View in S/4HANA. Release Check level Calculation Query. It contains 61 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 61 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ARunReleaseCheckCube view from COMPOSITE Cube view for Release Check
P_ARUNRELEASECHECKMntr view from COMPOSITE
P_ARunReleaseCheckMonitor view from COMPOSITE

Fields (61)

KeyField CDS FieldsUsed in Views
KEY ARunReleaseCheckResultUUID ARunReleaseCheckResultUUID 1
KEY ARunReleaseCheckRunUUID ARunReleaseCheckRunUUID 1
ARunDelivGrpRelChkPct ARunDelivGrpRelChkPct 1
ARunDelivGrpRelChkRule ARunDelivGrpRelChkRule 1
ARunDelivGrpRelChkStatus ARunDelivGrpRelChkStatus 1
ARunDelivGrpRelFlfmtPct ARunDelivGrpRelFlfmtPct 1
ARunDocItemGrpRelChkFlfmtPct ARunDocItemGrpRelChkFlfmtPct 1
ARunDocItemGrpRelChkPct ARunDocItemGrpRelChkPct 1
ARunDocItemGrpRelChkRule ARunDocItemGrpRelChkRule 1
ARunDocItemGrpRelChkStatus ARunDocItemGrpRelChkStatus 1
ARunDocumentItemGroupRuleUUID ARunDocumentItemGroupRuleUUID 1
ARunGenericArticleRelChkPct ARunGenericArticleRelChkPct 1
ARunGenericArticleRelChkRule ARunGenericArticleRelChkRule 1
ARunGenericArticleRelChkStatus ARunGenericArticleRelChkStatus 1
ARunGenericArticleRelFlfmtPct ARunGenericArticleRelFlfmtPct 1
ARunHdrGrpRelChkFlfmtPct ARunHdrGrpRelChkFlfmtPct 1
ARunHdrGrpRelChkPct ARunHdrGrpRelChkPct 1
ARunHdrGrpRelChkRule ARunHdrGrpRelChkRule 1
ARunHdrGrpRelChkStatus ARunHdrGrpRelChkStatus 1
ARunHeaderGroupRuleUUID ARunHeaderGroupRuleUUID 1
ARunHeaderRelChkPct ARunHeaderRelChkPct 1
ARunHeaderRelChkRule ARunHeaderRelChkRule 1
ARunHeaderRelChkStatus ARunHeaderRelChkStatus 1
ARunHeaderRelFlfmtPct ARunHeaderRelFlfmtPct 1
ARunItemRelChkPct ARunItemRelChkPct 1
ARunItemRelChkRule ARunItemRelChkRule 1
ARunItemRelChkStatus ARunItemRelChkStatus 1
ARunItemRelFlfmtPct ARunItemRelFlfmtPct 1
ARunMatlAvailyDateRelChkPct ARunMatlAvailyDateRelChkPct 1
ARunMatlAvailyDateRelChkRule ARunMatlAvailyDateRelChkRule 1
ARunMatlAvailyDateRelChkStatus ARunMatlAvailyDateRelChkStatus 1
ARunMatlAvailyDateRelFlfmtPct ARunMatlAvailyDateRelFlfmtPct 1
ARunRelChkCalcQty ARunRelChkCalcQty 1
ARunRelChkMatAvailyDateCalcQty ARunRelChkMatAvailyDateCalcQty 1
ARunRelChkRunDocItemGrpVal ARunRelChkRunDocItemGrpVal 1
ARunRelChkRunHdrGrpVal ARunRelChkRunHdrGrpVal 1
ARunReleaseCheckVariantName ARunReleaseCheckVariantName 1
ARunReleaseCheckVariantUUID ARunReleaseCheckVariantUUID 1
ARunShipgGrpRelChkPct ARunShipgGrpRelChkPct 1
ARunShipgGrpRelChkRule ARunShipgGrpRelChkRule 1
ARunShipgGrpRelChkStatus ARunShipgGrpRelChkStatus 1
ARunShipgGrpRelFlfmtPct ARunShipgGrpRelFlfmtPct 1
AssignedQuantityInBaseUnit AssignedQuantityInBaseUnit 1
AssignedSupplyType AssignedSupplyType 1
BaseUnit BaseUnit 1
ConfirmedRqmtQtyInBaseUnit ConfirmedRqmtQtyInBaseUnit 1
DeliveredQuantityInBaseUnit DeliveredQuantityInBaseUnit 1
FixedQuantityInBaseUnit FixedQuantityInBaseUnit 1
OnHoldQuantityInBaseUnit OnHoldQuantityInBaseUnit 1
OrderQuantity OrderQuantity 1
PreviousSupplyAssignmentStatus PreviousSupplyAssignmentStatus 1
ProductAvailabilityDate ProductAvailabilityDate 1
RequestedDate RequestedDate 1
RequirementDocumentItem RequirementDocumentItem 1
RequirementDocumentNumber RequirementDocumentNumber 1
RequirementType RequirementType 1
SupAssgmtExecutionMode SupAssgmtExecutionMode 1
SupAssgmtReservedQtyInBaseUnit SupAssgmtReservedQtyInBaseUnit 1
SupAssignRunIsSimulation SupAssignRunIsSimulation 1
SupplyAssignmentStatus SupplyAssignmentStatus 1
UnassignedQtyInBaseUnit UnassignedQtyInBaseUnit 1 
@EndUserText.label: 'Release Check level Calculation Query'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #BASIC
}
@AbapCatalog: {
  sqlViewName: 'IRELCHKLEVEL',
  compiler.compareFilter: true
 }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #X,
     sizeCategory:   #XXL
   }
}
define view I_ARunReleaseCheckLevel
  as select from P_ARunReleaseCheckRun as ReleaseLevel
{
  ReleaseLevel.clientid,
  ReleaseLevel.ARunReleaseCheckRunUUID,
  ReleaseLevel.ARunReleaseCheckVariantUUID,
  ReleaseLevel.SupAssgmtExecutionMode,
  ReleaseLevel.ARunReleaseCheckVariantName,
  ReleaseLevel.ARunReleaseCheckResultUUID,
  ReleaseLevel.RequirementDocumentNumber,
  ReleaseLevel.RequirementDocumentItem,
  ReleaseLevel.RequirementType,
  ReleaseLevel.RequestedDate,
  ReleaseLevel.ProductAvailabilityDate,
  ReleaseLevel.SupplyAssignmentStatus,
  ReleaseLevel.PreviousSupplyAssignmentStatus,
  ReleaseLevel.AssignedSupplyType,
  ReleaseLevel.OrderQuantity,
  ReleaseLevel.ConfirmedRqmtQtyInBaseUnit,
  ReleaseLevel.DeliveredQuantityInBaseUnit,
  ReleaseLevel.AssignedQuantityInBaseUnit,
  ReleaseLevel.FixedQuantityInBaseUnit,
  ReleaseLevel.OnHoldQuantityInBaseUnit,
  ReleaseLevel.SupAssgmtReservedQtyInBaseUnit,
  ReleaseLevel.UnassignedQtyInBaseUnit,
  ReleaseLevel.BaseUnit,
  ReleaseLevel.ARunMatlAvailyDateRelChkStatus,
  ReleaseLevel.ARunItemRelChkStatus,
  ReleaseLevel.ARunGenericArticleRelChkStatus,
  ReleaseLevel.ARunDelivGrpRelChkStatus,
  ReleaseLevel.ARunHeaderRelChkStatus,
  ReleaseLevel.ARunShipgGrpRelChkStatus,
  ReleaseLevel.ARunDocItemGrpRelChkStatus,
  ReleaseLevel.ARunHdrGrpRelChkStatus,
  ReleaseLevel.ARunMatlAvailyDateRelChkRule,
  ReleaseLevel.ARunItemRelChkRule,
  ReleaseLevel.ARunGenericArticleRelChkRule,
  ReleaseLevel.ARunDelivGrpRelChkRule,
  ReleaseLevel.ARunHeaderRelChkRule,
  ReleaseLevel.ARunShipgGrpRelChkRule,
  ReleaseLevel.ARunDocItemGrpRelChkRule,
  ReleaseLevel.ARunHdrGrpRelChkRule,
  ReleaseLevel.ARunDocumentItemGroupRuleUUID,
  ReleaseLevel.ARunHeaderGroupRuleUUID,
  LogHandle,
  SupAssignRunIsSimulation,
  ARunReleaseCheckGroupName,
  StartedByUser,
  ARunRelChkStartUTCDateTime,
  AllocationRunStatus,
  cast(ReleaseLevel.ARunMatlAvailyDateRelChkPct   as abap.int2) as ARunMatlAvailyDateRelChkPct,
  cast(ReleaseLevel.ARunItemRelChkPct             as abap.int2) as ARunItemRelChkPct,
  cast(ReleaseLevel.ARunGenericArticleRelChkPct   as abap.int2) as ARunGenericArticleRelChkPct,
  cast(ReleaseLevel.ARunDelivGrpRelChkPct         as abap.int2) as ARunDelivGrpRelChkPct,
  cast(ReleaseLevel.ARunHeaderRelChkPct           as abap.int2) as ARunHeaderRelChkPct,
  cast(ReleaseLevel.ARunShipgGrpRelChkPct         as abap.int2) as ARunShipgGrpRelChkPct,
  cast(ReleaseLevel.ARunDocItemGrpRelChkPct       as abap.int2) as ARunDocItemGrpRelChkPct,
  cast(ReleaseLevel.ARunHdrGrpRelChkPct           as abap.int2) as ARunHdrGrpRelChkPct,
  cast(ReleaseLevel.ARunMatlAvailyDateRelFlfmtPct as abap.int2) as ARunMatlAvailyDateRelFlfmtPct,
  cast(ReleaseLevel.ARunItemRelFlfmtPct           as abap.int2) as ARunItemRelFlfmtPct,
  cast(ReleaseLevel.ARunGenericArticleRelFlfmtPct as abap.int2) as ARunGenericArticleRelFlfmtPct,
  cast(ReleaseLevel.ARunDelivGrpRelFlfmtPct       as abap.int2) as ARunDelivGrpRelFlfmtPct,
  cast(ReleaseLevel.ARunHeaderRelFlfmtPct         as abap.int2) as ARunHeaderRelFlfmtPct,
  cast(ReleaseLevel.ARunShipgGrpRelFlfmtPct       as abap.int2) as ARunShipgGrpRelFlfmtPct,
  cast(ReleaseLevel.ARunDocItemGrpRelChkFlfmtPct  as abap.int2) as ARunDocItemGrpRelChkFlfmtPct,
  cast(ReleaseLevel.ARunHdrGrpRelChkFlfmtPct      as abap.int2) as ARunHdrGrpRelChkFlfmtPct,
  ReleaseLevel.ARunRelChkConfirmedQuantity                      as ARunRelChkMatAvailyDateCalcQty,
  //Release Check Denominator value except for Product Availibilty date

  case ArunRelChkQtySelectionMethod
  when '1'
     then ARunRelChkOrderQuantity
  when '2'
     then ARunRelChkConfirmedQuantity
  end                                                           as ARunRelChkCalcQty,
  NetAmount,
  DocumentCurrency,
  ReleaseLevel.ARunRelChkRunDocItemGrpVal,
  ReleaseLevel.ARunRelChkRunHdrGrpVal
}

Learn More