R_ProjectDemandService

DDL: R_PROJECTDEMANDSERVICE Type: view_entity BASIC

Project Demand for Service

R_ProjectDemandService is a Basic CDS View that provides data about "Project Demand for Service" in SAP S/4HANA. It reads from 1 data source (servicedemand) and exposes 21 fields with key field ProjectDemandServiceUUID. It has 8 associations to related views.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
servicedemand servicedemand from

Associations (8)

CardinalityTargetAliasCondition
[0..1] R_ProjectDemandServiceSupply _ServiceSupply _ServiceSupply.ProjectDemandUUID = $projection.ProjectDemandUUID
[1..1] R_ProjectDemand _RootTP $projection.ProjectDemandUUID = _RootTP.ProjectDemandUUID
[0..1] I_ProductStdVH _Material $projection.Material = _Material.Product
[1..1] I_ProductDescription _MaterialText $projection.Material = _MaterialText.Product and _MaterialText.Language = $session.system_language
[0..1] I_ProductGroup_2 _MaterialGroup $projection.MaterialGroup = _MaterialGroup.ProductGroup
[1..1] I_ProductGroupText_2 _MaterialGroupText $projection.MaterialGroup = _MaterialGroupText.ProductGroup and _MaterialGroupText.Language = $session.system_language
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[0..1] I_PurchasingInfoRecord _PurchasingInfoRecord $projection.PurchasingInfoRecord = _PurchasingInfoRecord.PurchasingInfoRecord

Annotations (11)

NameValueLevelField
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey ProjectDemandServiceUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Project Demand for Service view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ProjectDemandServiceUUID projectdemandserviceuuid
ProjectDemandUUID projectdemanduuid
Material material
MaterialGroup materialgroup
Supplier supplier
PurchasingInfoRecord purchasinginforecord
PurchaseContract purchasecontract
PurchaseContractItem purchasecontractitem
MaterialPlannedDeliveryDurn materialplanneddeliverydurn
CreatedByUser createdbyuser
CreationDateTime creationdatetime
LastChangedByUser lastchangedbyuser
LastChangeDateTime lastchangedatetime
_RootTP _RootTP
_ServiceSupply _ServiceSupply
_Material _Material
_MaterialText _MaterialText
_MaterialGroup _MaterialGroup
_MaterialGroupText _MaterialGroupText
_Supplier _Supplier
_PurchasingInfoRecord _PurchasingInfoRecord 
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

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

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

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

define view entity R_ProjectDemandService
  as select from servicedemand

  association [0..1] to R_ProjectDemandServiceSupply as _ServiceSupply        on  _ServiceSupply.ProjectDemandUUID = $projection.ProjectDemandUUID
  association [1..1] to R_ProjectDemand              as _RootTP               on  $projection.ProjectDemandUUID = _RootTP.ProjectDemandUUID

  association [0..1] to I_ProductStdVH               as _Material             on  $projection.Material = _Material.Product
  association [1..1] to I_ProductDescription         as _MaterialText         on  $projection.Material   = _MaterialText.Product
                                                                              and _MaterialText.Language = $session.system_language
  association [0..1] to I_ProductGroup_2             as _MaterialGroup        on  $projection.MaterialGroup = _MaterialGroup.ProductGroup
  association [1..1] to I_ProductGroupText_2         as _MaterialGroupText    on  $projection.MaterialGroup   = _MaterialGroupText.ProductGroup
                                                                              and _MaterialGroupText.Language = $session.system_language
  association [0..1] to I_Supplier                   as _Supplier             on  $projection.Supplier = _Supplier.Supplier
  association [0..1] to I_PurchasingInfoRecord       as _PurchasingInfoRecord on  $projection.PurchasingInfoRecord = _PurchasingInfoRecord.PurchasingInfoRecord

{

  key projectdemandserviceuuid    as ProjectDemandServiceUUID,

      projectdemanduuid           as ProjectDemandUUID,

      @Consumption.valueHelp: '_Material'
      material                    as Material,

      @ObjectModel.foreignKey.association: '_MaterialGroup'
      materialgroup               as MaterialGroup,

      @ObjectModel.foreignKey.association: '_Supplier'
      supplier                    as Supplier,

      @ObjectModel.foreignKey.association: '_PurchasingInfoRecord'
      purchasinginforecord        as PurchasingInfoRecord,

      purchasecontract            as PurchaseContract,

      purchasecontractitem        as PurchaseContractItem,

      materialplanneddeliverydurn as MaterialPlannedDeliveryDurn,

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

      _RootTP,
      _ServiceSupply,

      _Material,
      _MaterialText,
      _MaterialGroup,
      _MaterialGroupText,
      _Supplier,
      _PurchasingInfoRecord

}

Learn More