P_ARunSimlnLog

DDL: P_ARUNSIMLNLOG Type: view COMPOSITE Package: VDM_ARUN_MONITOR

View for ARun Log at Date Level

P_ARunSimlnLog is a Composite CDS View that provides data about "View for ARun Log at Date Level" in SAP S/4HANA. It reads from 2 data sources (P_ARunSimlnLogBsc1, I_ARunSimlnLog) and exposes 10 fields. Part of development package VDM_ARUN_MONITOR.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
P_ARunSimlnLogBsc1 req inner
I_ARunSimlnLog sched from

Annotations (9)

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

Fields (10)

KeyFieldSource TableSource FieldDescription
ATPCheckUUID I_ARunSimlnLog ATPCheckUUID
RequirementType I_ARunSimlnLog RequirementType
RequirementDocumentNumber I_ARunSimlnLog RequirementDocumentNumber
RequirementDocumentItem I_ARunSimlnLog RequirementDocumentItem
RequestedDate I_ARunSimlnLog RequestedDate
ProductAvailabilityDate I_ARunSimlnLog ProductAvailabilityDate
ConfirmedRqmtQtyInBaseUnit
DeliveredQuantityInBaseUnit I_ARunSimlnLog DeliveredQuantityInBaseUnit
ARunTotSupProtQty I_ARunSimlnLog ARunTotSupProtQty
ARunActualSupProtQty I_ARunSimlnLog ARunActualSupProtQty 
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #COMPOSITE
}
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@VDM.private: true
@AbapCatalog: {
  sqlViewName: 'PARUNSIMLOG',
  compiler.compareFilter: true
 }
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XXL
   }
}
define view P_ARunSimlnLog
  as select from I_ARunSimlnLog     as sched
    inner join   P_ARunSimlnLogBsc1 as req on  sched.ATPCheckUUID              = req.ATPCheckUUID
                                           and sched.RequirementType           = req.RequirementType
                                           and sched.RequirementDocumentNumber = req.RequirementDocumentNumber
                                           and sched.RequirementDocumentItem   = req.RequirementDocumentItem
                                           and sched.RequestedDate             = req.RequestedDate
{
  sched.ATPCheckUUID,
  sched.RequirementType,
  sched.RequirementDocumentNumber,
  sched.RequirementDocumentItem,
  sched.RequestedDate,
  sched.ProductAvailabilityDate,
  // Total Requested = Requested + Confirmed + Delivered

  case
    when sched.RequestedRqmtQtyInBaseUnit > 0
      then sched.RequestedRqmtQtyInBaseUnit - req.ConfirmedRqmtQtyInBaseUnit + sched.ConfirmedRqmtQtyInBaseUnit + sched.DeliveredQuantityInBaseUnit
      else sched.ConfirmedRqmtQtyInBaseUnit+sched.DeliveredQuantityInBaseUnit
  end                                                                                                        as RequestedRqmtQtyInBaseUnit,
  // Total Confirmed = Confirmed + Delivered

  sched.ConfirmedRqmtQtyInBaseUnit + sched.DeliveredQuantityInBaseUnit                                       as ConfirmedRqmtQtyInBaseUnit,
  sched.DeliveredQuantityInBaseUnit,
  sched.ARunTotSupProtQty,
  sched.ARunActualSupProtQty
}

Learn More