R_PROJDMNDRSCEREQDISTRIBUTION

CDS View

Resource Req Distribution for Rsce Dmnd

R_PROJDMNDRSCEREQDISTRIBUTION is a CDS View in S/4HANA. Resource Req Distribution for Rsce Dmnd. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ProjDmndRsceReqDistribution view from BASIC Resource Req Distribution for Rsce Dmnd
R_ProjDmndRsceReqDistrTP view_entity from TRANSACTIONAL Resource Request Distribution - TP 
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

@Analytics.technicalName: 'RPrjDmndReqDistr'
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED

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

@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Resource Req Distribution for Rsce Dmnd'

define view entity R_ProjDmndRsceReqDistribution
  as select from dmndrscerqdstr

  association [1]    to R_ProjectDemand                as _Root                        on $projection.ProjectDemandUUID = _Root.ProjectDemandUUID  
  association [1]    to R_ProjectDemandResourceRequest as _ProjDmndRsceReq             on $projection.ProjDmndResourceRequestUUID = _ProjDmndRsceReq.ProjDmndResourceRequestUUID

  association [1]    to I_EnterpriseProject            as _EnterpriseProject           on $projection.ProjectUUID = _EnterpriseProject.ProjectUUID

  association [0..1] to I_UnitOfMeasureStdVH           as _ProjDmndRsceReqDistrQtyUnit on $projection.ProjDmndRsceReqDistrQtyUnit = _ProjDmndRsceReqDistrQtyUnit.UnitOfMeasure
  association [0..1] to I_Currency                     as _DmndRsceReqDistrPerdAmtCur  on $projection.ProjDmndRsceReqDistrPerdAmtCur = _DmndRsceReqDistrPerdAmtCur.Currency
  association [0..1] to I_Currency                     as _DmndRsceReqDistrRevnAmtCur  on $projection.ProjDmndRsceReqDistrRevnAmtCur = _DmndRsceReqDistrRevnAmtCur.Currency  

{
  key projdmndrscereqdistruuid       as ProjDmndRsceReqDistrUUID,
      projdmndresourcerequestuuid    as ProjDmndResourceRequestUUID,      
      projectdemanduuid              as ProjectDemandUUID,

      @ObjectModel.foreignKey.association: '_EnterpriseProject'
      //Casting to a type which annotates Change Document Relevance as false. This field is already written into Change Document in root node .

      //cast(projectuuid as tv_proj_dmnd_uuid_chg_doc preserving type ) as ProjectUUID, "commented out, please see message 2380013083

      cast(projectuuid as tv_project_uuid_chg_doc preserving type ) as ProjectUUID,
         
      //Casting to a type which annotates Change Document Relevance as false. This field is already written into Change Document in root node .

      //cast(referencedobjectuuid as tv_proj_dmnd_uuid_chg_doc preserving type ) as ReferencedObjectUUID, "commented out, please see message 2380013083

      cast(referencedobjectuuid as tv_dmnd_ref_obj_uuid_chg_doc preserving type ) as ReferencedObjectUUID,
       
      projdmndrscereqdistryearval    as ProjDmndRsceReqDistrYearVal,
      projdmndrscereqdistrperdval    as ProjDmndRsceReqDistrPerdVal,

      @Semantics: { quantity : {unitOfMeasure: 'ProjDmndRsceReqDistrQtyUnit'} }
      projdmndrscereqdistrquantity   as ProjDmndRsceReqDistrQuantity,

      @ObjectModel.foreignKey.association:    '_ProjDmndRsceReqDistrQtyUnit'
      projdmndrscereqdistrqtyunit    as ProjDmndRsceReqDistrQtyUnit,

      @Semantics: { amount : {currencyCode: 'ProjDmndRsceReqDistrPerdAmtCur'} }
      projdmndrscereqdistrperdamt    as ProjDmndRsceReqDistrPerdAmt,

      @ObjectModel.foreignKey.association:    '_DmndRsceReqDistrPerdAmtCur'
      projdmndrscereqdistrperdamtcur as ProjDmndRsceReqDistrPerdAmtCur,

      @Semantics: { amount : {currencyCode: 'ProjDmndRsceReqDistrRevnAmtCur'} }
      projdmndrscereqdistrrevenueamt as ProjDmndRsceReqDistrRevenueAmt,

      @ObjectModel.foreignKey.association:    '_DmndRsceReqDistrRevnAmtCur'
      projdmndrscereqdistrrevnamtcur as ProjDmndRsceReqDistrRevnAmtCur,

      projdmndreferencedplandatauuid as ProjDmndReferencedPlanDataUUID,
      projdmndrscereqdistrstartdate  as ProjDmndRsceReqDistrStartDate,
      projdmndrscereqdistrenddate    as ProjDmndRsceReqDistrEndDate,

      @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,

      /* BO internal Associations */
      _Root,
      _ProjDmndRsceReq,

      /* External Associations */
      _EnterpriseProject,
      _ProjDmndRsceReqDistrQtyUnit,
      _DmndRsceReqDistrPerdAmtCur,
      _DmndRsceReqDistrRevnAmtCur
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DMNDRSCERQDSTR"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_ENTERPRISEPROJECT",
"I_UNITOFMEASURESTDVH",
"R_PROJECTDEMAND",
"R_PROJECTDEMANDRESOURCEREQUEST"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More