P_ARunReleaseCheckMonitor

DDL: P_ARUNRELEASECHECKMONITOR Type: view COMPOSITE

P_ARunReleaseCheckMonitor is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ARunReleaseCheckLevel) and exposes 17 fields.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_ARunReleaseCheckLevel ReleaseLevel from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName PRELCHKMON view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view

Fields (17)

KeyFieldSource TableSource FieldDescription
ARunReleaseCheckRunUUID ARunReleaseCheckRunUUID
ARunReleaseCheckVariantUUID ARunReleaseCheckVariantUUID
SupAssgmtExecutionMode SupAssgmtExecutionMode
ARunReleaseCheckVariantName ARunReleaseCheckVariantName
SupAssignRunIsSimulation SupAssignRunIsSimulation
ARunReleaseCheckGroupName ARunReleaseCheckGroupName
StartedByUser StartedByUser
ARunRelChkStartUTCDateTime ARunRelChkStartUTCDateTime
LogHandle LogHandle
UxFcAllocationRunStatus AllocationRunStatus
OrderQuantity
ConfirmedRqmtQtyInBaseUnit
DeliveredQuantityInBaseUnit
AssignedQuantityInBaseUnit
FixedQuantityInBaseUnit
OnHoldQuantityInBaseUnit
SupAssgmtReservedQtyInBaseUnit 
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #COMPOSITE
 // lifecycle.contract.type: #PUBLIC_LOCAL_API

}
@AbapCatalog: {
  sqlViewName: 'PRELCHKMON',
  compiler.compareFilter: true
 }
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #X,
     sizeCategory:   #XXL
   }
}
define view P_ARunReleaseCheckMonitor
  as select from I_ARunReleaseCheckLevel as ReleaseLevel
{
  ARunReleaseCheckRunUUID,
  ARunReleaseCheckVariantUUID,
  SupAssgmtExecutionMode,
  ARunReleaseCheckVariantName,
  SupAssignRunIsSimulation,
  ARunReleaseCheckGroupName,
  StartedByUser,
  ARunRelChkStartUTCDateTime,
  // ARunRelChkStartUTCEndTime,

  LogHandle,
  // ARunRelChkRunStatus,

  AllocationRunStatus                                                                                 as UxFcAllocationRunStatus,
  case  AllocationRunStatus
  when 'U'
  then 'I'
  when 'E'
  then 'I'
  when 'X'
  then ( case SupAssignRunIsSimulation when 'X' then 'S' else 'E' end ) end                           as UxFcServiceOrderStatus,
  //ARunRelChkMonitorStatus,

  sum(OrderQuantity)                                                                                  as OrderQuantity,
  sum(ConfirmedRqmtQtyInBaseUnit)                                                                     as ConfirmedRqmtQtyInBaseUnit,
  sum(DeliveredQuantityInBaseUnit)                                                                    as DeliveredQuantityInBaseUnit,
  sum(AssignedQuantityInBaseUnit)                                                                     as AssignedQuantityInBaseUnit,
  sum(FixedQuantityInBaseUnit)                                                                        as FixedQuantityInBaseUnit,
  sum(OnHoldQuantityInBaseUnit)                                                                       as OnHoldQuantityInBaseUnit,
  sum(SupAssgmtReservedQtyInBaseUnit)                                                                 as SupAssgmtReservedQtyInBaseUnit
}
group by
  ARunReleaseCheckRunUUID,
  ARunReleaseCheckVariantUUID,
  SupAssgmtExecutionMode,
  ARunReleaseCheckVariantName,
  SupAssignRunIsSimulation,
  ARunReleaseCheckGroupName,
  StartedByUser,
  ARunRelChkStartUTCDateTime,
  //  ARunRelChkStartUTCEndTime,

  // ARunRelChkRunStatus,

  AllocationRunStatus,
  LogHandle
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ARUNRELEASECHECKLEVEL"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More