P_ARUNSIMLNLOGBSC1

CDS View

Basic View 1 for Supply Assignment Simulation Log

P_ARUNSIMLNLOGBSC1 is a CDS View in S/4HANA. Basic View 1 for Supply Assignment Simulation Log. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ARunSimlnLog view inner COMPOSITE View for ARun Log at Date Level
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM: {
  viewType: #COMPOSITE
}
@VDM.private: true
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'PARUNSIMLNLGB1',
  compiler.compareFilter: true
 }
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XXL
   }
}
// Total Confirmed Quantity

define view P_ARunSimlnLogBsc1
  as select from I_ARunSimlnLog
{
  ATPCheckUUID,
  RequirementType,
  RequirementDocumentNumber,
  RequirementDocumentItem,
  RequestedDate,
  sum(ConfirmedRqmtQtyInBaseUnit) as ConfirmedRqmtQtyInBaseUnit
}
group by
  ATPCheckUUID,
  RequirementType,
  RequirementDocumentNumber,
  RequirementDocumentItem,
  RequestedDate