R_PROJECTDEMANDEXPENSE

CDS View

Project Demand for Expense

R_PROJECTDEMANDEXPENSE is a CDS View in S/4HANA. Project Demand for Expense. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ProjectDemandExpense view_entity from BASIC Project Demand for Expense
R_ProjectDemandExpenseTP view_entity from TRANSACTIONAL Project Demand for Expense - TP 
@AccessControl.authorizationCheck: #MANDATORY

@VDM: { viewType                 : #BASIC,
        lifecycle.contract.type  : #SAP_INTERNAL_API} 

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

@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Project Demand for Expense'

define view entity R_ProjectDemandExpense
  as select from dmndexpense

  association [1..1] to R_ProjectDemand               as _Root                on $projection.ProjectDemandUUID = _Root.ProjectDemandUUID
  association [0..*] to R_ProjDmndExpenseDistribution as _ExpenseDistribution on $projection.ProjectDemandExpenseUUID = _ExpenseDistribution.ProjectDemandExpenseUUID  

{
  key projectdemandexpenseuuid       as ProjectDemandExpenseUUID,
      projectdemanduuid              as ProjectDemandUUID,
      projectdemandexpensetype       as ProjectDemandExpenseType,
      
      //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,
      
      projdmndbillingcontrolcategory as ProjDmndBillingControlCategory,
      @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,
      
      //      Associations

      _Root,
      _ExpenseDistribution

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DMNDEXPENSE"
],
"ASSOCIATED":
[
"R_PROJDMNDEXPENSEDISTRIBUTION",
"R_PROJECTDEMAND"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More