I_PMRPCAPACITYCHANGEPROPOSAL

CDS View

PMRP Capacity Change Proposal

I_PMRPCAPACITYCHANGEPROPOSAL is a CDS View in S/4HANA. PMRP Capacity Change Proposal. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_PMRPChgProposalPerCapacity view_entity from TRANSACTIONAL PMRP Change Proposal Per Capacity
R_PMRPCapacityChangeProposalTP view_entity from TRANSACTIONAL PMRP Capacity Change Proposal - TP 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'PMRP Capacity Change Proposal'
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #M, dataClass: #TRANSACTIONAL}
@VDM.viewType: #BASIC
define view entity I_PMRPCapacityChangeProposal
  as select from pmrp_capchgprpsl

  association to I_PMRPBucket as _Bucket   on  $projection.PMRPReferencePlan      = _Bucket.PMRPReferencePlan
                                           and $projection.BucketInternalID       = _Bucket.BucketInternalID

{
  key resource_id                                           as PMRPResourceInternalID,
  key bucket_id                                             as BucketInternalID,
      reference_id                                          as PMRPReferencePlan,
      mod_factor                                            as AdaptedCapacityRateInPercent,
      capacity                                              as PMRPRefCapacityInSec,
      cast( capacity * mod_factor / 100  as pmrp_capacity ) as PMRPAvailableCapacityInSeconds,
      capacity_demand                                       as PMRPCapacityDemandQtyInSeconds,
      change_status                                         as PMRPChgPrpslProcessingStatus,
      cast( case
              when change_status = '0'
              and _Bucket.PeriodIsInPast = ' '
              then 'X'
              else ' '
            end                         as abap_boolean )   as PMRPCapacityChangeIsNeeded,

      /* Associations */
      _Bucket
}

Learn More