I_ProjectDemandExpense

DDL: I_PROJECTDEMANDEXPENSE Type: view_entity BASIC

Project Demand for Expense

I_ProjectDemandExpense is a Basic CDS View that provides data about "Project Demand for Expense" in SAP S/4HANA. It reads from 1 data source (R_ProjectDemandExpense) and exposes 10 fields with key field ProjectDemandExpenseUUID. It has 2 associations to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
R_ProjectDemandExpense R_ProjectDemandExpense from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ProjectDemand _Root $projection.ProjectDemandUUID = _Root.ProjectDemandUUID
[0..*] I_ProjDmndExpenseDistribution _ExpenseDistribution $projection.ProjectDemandExpenseUUID = _ExpenseDistribution.ProjectDemandExpenseUUID

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey ProjectDemandExpenseUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Project Demand for Expense view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ProjectDemandExpenseUUID ProjectDemandExpenseUUID
ProjectDemandUUID ProjectDemandUUID
ProjectDemandExpenseType ProjectDemandExpenseType
ProjDmndBillingControlCategory ProjDmndBillingControlCategory
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
_Root _Root
_ExpenseDistribution _ExpenseDistribution 
@AccessControl.authorizationCheck: #MANDATORY

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

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

@Analytics: {
  dataExtraction: { 
    enabled: true,
    delta.changeDataCapture: {
      automatic: true
    }
  }
}
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Project Demand for Expense'

define view entity I_ProjectDemandExpense
  as select from R_ProjectDemandExpense

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

{
  key ProjectDemandExpenseUUID       as ProjectDemandExpenseUUID,
      ProjectDemandUUID              as ProjectDemandUUID,
      ProjectDemandExpenseType       as ProjectDemandExpenseType,
      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":
[
"R_PROJECTDEMANDEXPENSE"
],
"ASSOCIATED":
[
"I_PROJDMNDEXPENSEDISTRIBUTION",
"I_PROJECTDEMAND"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More