I_ProjectDemandSituation

DDL: I_PROJECTDEMANDSITUATION SQL: IPRJDMNDSITN Type: view BASIC

Demand exception handling

I_ProjectDemandSituation is a Basic CDS View that provides data about "Demand exception handling" in SAP S/4HANA. It reads from 1 data source (R_ProjectDemand) and exposes 6 fields with key field ProjectDemandUUID. It has 2 associations to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
R_ProjectDemand R_ProjectDemand from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ProjectDemandWorkPackageText _ProjectElementData $projection.ReferencedObjectUUID = _ProjectElementData.ProjectElementUUID
[0..1] I_SitnInstceIndicator _SitnInstceIndicator _SitnInstceIndicator.SitnInstceAnchorObjectKey = $projection.ProjectDemandFormattedName and _SitnInstceIndicator.SitnDefAnchorObject = 'ProjectDemandFormattedName'

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IPRJDMNDSITN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Demand exception handling view
VDM.viewType #BASIC view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey ProjectDemandUUID view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
Search.searchable true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ProjectDemandUUID ProjectDemandUUID
ProjectDemandFormattedName
ProjectDemand ProjectDemand
ProjectDemandName ProjectDemandName
_SitnInstceIndicator _SitnInstceIndicator
ReferencedObjectUUID ReferencedObjectUUID 

@AbapCatalog.sqlViewName: 'IPRJDMNDSITN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Demand exception handling'
@VDM: {
    viewType: #BASIC
}
@Metadata.allowExtensions: true
@AccessControl: {
    authorizationCheck:     #NOT_REQUIRED,
    personalData.blocking:  #BLOCKED_DATA_EXCLUDED
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
   semanticKey:       [ 'ProjectDemand' ],
   representativeKey: 'ProjectDemandUUID',  
   usageType: {
     serviceQuality:  #D,
     dataClass:       #MIXED,
     sizeCategory:    #L
    }
} 

@Search.searchable: true
define view I_ProjectDemandSituation as select from R_ProjectDemand 
  association [0..1] to I_ProjectDemandWorkPackageText as _ProjectElementData on $projection.ReferencedObjectUUID = _ProjectElementData.ProjectElementUUID
  
 association [0..1] to I_SitnInstceIndicator as _SitnInstceIndicator on _SitnInstceIndicator.SitnInstceAnchorObjectKey = $projection.ProjectDemandFormattedName
                                                                         and _SitnInstceIndicator.SitnDefAnchorObject = 'ProjectDemandFormattedName'
{

key ProjectDemandUUID,

  bintohex(ProjectDemandUUID) as ProjectDemandFormattedName,
  
  ProjectDemand,
  
  ProjectDemandName,
  
 _SitnInstceIndicator,

  @Consumption.hidden: true
  ReferencedObjectUUID


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

Learn More