R_PROJECTDEMANDSERVICESUPPLY

CDS View

Supply Data of Service Demand

R_PROJECTDEMANDSERVICESUPPLY is a CDS View in S/4HANA. Supply Data of Service Demand. 4 CDS views read from this table.

Used by 4 CDS view(s)

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_MngProjDmndSrvcPurReqnOrd view from CONSUMPTION Manage Proj Dmnd Srvc PR/PO fields
I_MngProjDmndSrvcPurReqnOrd view from COMPOSITE PR related fields for material demand
I_ProjectDemandServiceSupply view from BASIC Supply Data of Service Demand
I_ProjectDemandServiceSupplyTP view_entity from TRANSACTIONAL Supply Data of Service Demand - TP 
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED

@ObjectModel: {
   modelingPattern: #ANALYTICAL_DIMENSION,
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ],
   semanticKey:       [ 'PurchaseRequisition' ],
   representativeKey: 'ProjectDemandServiceSupplyUUID',
   usageType: {
     serviceQuality:  #A,
     dataClass:       #TRANSACTIONAL,
     sizeCategory:    #XL
   }
}

@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Supply Data of Service Demand'

define view entity R_ProjectDemandServiceSupply
  as select from servicesupply

  association [1..1] to R_ProjectDemand        as _Root    on $projection.ProjectDemandUUID = _Root.ProjectDemandUUID
  association [1..1] to R_ProjectDemandService as _Service on $projection.ProjectDemandServiceUUID = _Service.ProjectDemandServiceUUID
{

  key projectdemandservicesupplyuuid as ProjectDemandServiceSupplyUUID,
      projectdemandserviceuuid       as ProjectDemandServiceUUID,
      projectdemanduuid              as ProjectDemandUUID,

      purchaserequisition            as PurchaseRequisition,
      purchaserequisitionitem        as PurchaseRequisitionItem,

      @Semantics.user.createdBy: true
      createdbyuser                  as CreatedByUser,
      @Semantics.systemDateTime.createdAt: true
      creationdatetime               as CreationDateTime,
      @Semantics.user.lastChangedBy: true
      lastchangedbyuser              as LastChangedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      lastchangedatetime             as LastChangeDateTime,


      _Service,
      _Root
}

Learn More