I_ProjectDemandServiceSupply

DDL: I_PROJECTDEMANDSERVICESUPPLY Type: view BASIC

Supply Data of Service Demand

I_ProjectDemandServiceSupply is a Basic CDS View that provides data about "Supply Data of Service Demand" in SAP S/4HANA. It reads from 1 data source (R_ProjectDemandServiceSupply) and exposes 11 fields with key field ProjectDemandServiceSupplyUUID. It has 2 associations to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
R_ProjectDemandServiceSupply R_ProjectDemandServiceSupply from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ProjectDemand _Root $projection.ProjectDemandUUID = _Root.ProjectDemandUUID
[1..1] I_ProjectDemandService _Service $projection.ProjectDemandServiceUUID = _Service.ProjectDemandServiceUUID

Annotations (16)

NameValueLevelField
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName IPROJDMNDSRVCSUP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey ProjectDemandServiceSupplyUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
Analytics.dataExtraction.enabled true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Supply Data of Service Demand view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ProjectDemandServiceSupplyUUID ProjectDemandServiceSupplyUUID
ProjectDemandServiceUUID ProjectDemandServiceUUID
ProjectDemandUUID ProjectDemandUUID
PurchaseRequisition PurchaseRequisition
PurchaseRequisitionItem PurchaseRequisitionItem
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
_Service _Service
_Root _Root 
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API

@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED

@AbapCatalog: {
    sqlViewName: 'IPROJDMNDSRVCSUP',
    compiler.compareFilter: true,
    preserveKey:true
}

@ObjectModel: {
   modelingPattern: #ANALYTICAL_DIMENSION,
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #EXTRACTION_DATA_SOURCE ],
   semanticKey:       [ 'PurchaseRequisition' ],
   representativeKey: 'ProjectDemandServiceSupplyUUID',
   usageType: {
     serviceQuality:  #A,
     dataClass:       #TRANSACTIONAL,
     sizeCategory:    #XL
   }
}
@Analytics.dataExtraction.enabled: true
@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'Supply Data of Service Demand'

define view I_ProjectDemandServiceSupply
  as select from R_ProjectDemandServiceSupply

  association [1..1] to I_ProjectDemand        as _Root    on $projection.ProjectDemandUUID = _Root.ProjectDemandUUID
  association [1..1] to I_ProjectDemandService as _Service on $projection.ProjectDemandServiceUUID = _Service.ProjectDemandServiceUUID
{

  key ProjectDemandServiceSupplyUUID as ProjectDemandServiceSupplyUUID,
      ProjectDemandServiceUUID       as ProjectDemandServiceUUID,
      ProjectDemandUUID              as ProjectDemandUUID,

      PurchaseRequisition            as PurchaseRequisition,
      PurchaseRequisitionItem        as PurchaseRequisitionItem,

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

      _Service,
      _Root

}

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

Learn More