I_ProjDmndExpenseDistribution

DDL: I_PROJDMNDEXPENSEDISTRIBUTION Type: view_entity BASIC

Distribution of Proj Demand for Expense

I_ProjDmndExpenseDistribution is a Basic CDS View that provides data about "Distribution of Proj Demand for Expense" in SAP S/4HANA. It reads from 1 data source (R_ProjDmndExpenseDistribution) and exposes 16 fields with key field ProjDmndExpnDistributionUUID. It has 2 associations to related views.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
R_ProjDmndExpenseDistribution R_ProjDmndExpenseDistribution from

Associations (2)

CardinalityTargetAliasCondition
[1] I_ProjectDemand _Root $projection.ProjectDemandUUID = _Root.ProjectDemandUUID
[1] I_ProjectDemandExpense _Expense $projection.ProjectDemandExpenseUUID = _Expense.ProjectDemandExpenseUUID

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Analytics.technicalName IPrjDmndExpnsDst view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey ProjDmndExpnDistributionUUID 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 Distribution of Proj Demand for Expense view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ProjDmndExpnDistributionUUID ProjDmndExpnDistributionUUID
ProjectDemandExpenseUUID ProjectDemandExpenseUUID
ProjectDemandUUID ProjectDemandUUID
ProjDmndReferencedPlanDataUUID ProjDmndReferencedPlanDataUUID
ProjDmndExpnDistrPeriodVal ProjDmndExpnDistrPeriodVal
ProjDmndExpnDistrYearVal ProjDmndExpnDistrYearVal
ProjDmndExpnDistrAmount ProjDmndExpnDistrAmount
ProjDmndExpnDistrRevenueAmt ProjDmndExpnDistrRevenueAmt
ProjDmndExpnDistrAmountCrcy ProjDmndExpnDistrAmountCrcy
ProjDmndExpnDistrRevnAmtCrcy ProjDmndExpnDistrRevnAmtCrcy
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
_Root _Root
_Expense _Expense 
@AccessControl.authorizationCheck: #MANDATORY
@Analytics.technicalName: 'IPrjDmndExpnsDst'
@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       : 'ProjDmndExpnDistributionUUID',
    usageType.dataClass     : #TRANSACTIONAL,
    usageType.serviceQuality: #A,
    usageType.sizeCategory  : #M
}

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

define view entity I_ProjDmndExpenseDistribution
  as select from R_ProjDmndExpenseDistribution

  association [1] to I_ProjectDemand        as _Root              on $projection.ProjectDemandUUID = _Root.ProjectDemandUUID 
  association [1] to I_ProjectDemandExpense as _Expense           on $projection.ProjectDemandExpenseUUID = _Expense.ProjectDemandExpenseUUID

{
  key ProjDmndExpnDistributionUUID   as ProjDmndExpnDistributionUUID,
      ProjectDemandExpenseUUID       as ProjectDemandExpenseUUID,
      ProjectDemandUUID              as ProjectDemandUUID,
      ProjDmndReferencedPlanDataUUID as ProjDmndReferencedPlanDataUUID,
      ProjDmndExpnDistrPeriodVal     as ProjDmndExpnDistrPeriodVal,
      ProjDmndExpnDistrYearVal       as ProjDmndExpnDistrYearVal,
      @Semantics.amount.currencyCode: 'ProjDmndExpnDistrAmountCrcy'
      ProjDmndExpnDistrAmount        as ProjDmndExpnDistrAmount,
      @Semantics.amount.currencyCode: 'ProjDmndExpnDistrRevnAmtCrcy'
      ProjDmndExpnDistrRevenueAmt    as ProjDmndExpnDistrRevenueAmt,
      ProjDmndExpnDistrAmountCrcy    as ProjDmndExpnDistrAmountCrcy,
      ProjDmndExpnDistrRevnAmtCrcy   as ProjDmndExpnDistrRevnAmtCrcy,
      @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,

      _Root,
      _Expense

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

Learn More