I_SourcingProjectType

DDL: I_SOURCINGPROJECTTYPE Type: view_entity BASIC

Type of Sourcing Project

I_SourcingProjectType is a Basic CDS View that provides data about "Type of Sourcing Project" in SAP S/4HANA. It reads from 1 data source (R_SourcingProjectType) and exposes 18 fields with key field SourcingProjectType. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_SourcingProjectType R_SourcingProjectType from

Associations (5)

CardinalityTargetAliasCondition
[0..*] I_SrcgProjPhaseGroupText _SrcgProjPhaseGroupText $projection.SrcgProjPhaseGroup = _SrcgProjPhaseGroupText.SrcgProjPhaseGroup
[0..*] I_SrcgProjMilestoneGroupText _SrcgProjMilestoneGroupText $projection.SrcgProjMilestoneGroup = _SrcgProjMilestoneGroupText.SrcgProjMilestoneGroup
[0..*] I_SrcgProjContactGroupText _SrcgProjContactGroupText $projection.SrcgProjContactGroup = _SrcgProjContactGroupText.SrcgProjContactGroup
[0..*] I_SPQtnFollowOnDocGroupText _SPQtnFollowOnDocGroupText $projection.SrcgProjFollowOnDocumentGroup = _SPQtnFollowOnDocGroupText.SrcgProjFollowOnDocumentGroup
[0..*] I_SourcingProjectTypeText _SourcingProjectTypeText

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey SourcingProjectType view
ObjectModel.sapObjectNodeType.name SourcingProjectType view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.modelingPattern #NONE view
VDM.viewType #BASIC view
Search.searchable true view
EndUserText.label Type of Sourcing Project view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectType SourcingProjectType
_SourcingProjectTypeText _SourcingProjectTypeText
SrcgProjItemUnconfdDmndRsnGrp SrcgProjItemUnconfdDmndRsnGrp
SrcPrjSuplrPartcipnDclnRsnGrp SrcPrjSuplrPartcipnDclnRsnGrp
SrcgProjQtnItemExcludingRsnGrp SrcgProjQtnItemExcludingRsnGrp
SrcgProjSuplrUnlockingRsnGroup SrcgProjSuplrUnlockingRsnGroup
SrcgProjVersioningReasonGroup SrcgProjVersioningReasonGroup
SrcgProjContactGroup SrcgProjContactGroup
_SrcgProjContactGroupText _SrcgProjContactGroupText
SrcgProjFollowOnDocumentGroup SrcgProjFollowOnDocumentGroup
_SPQtnFollowOnDocGroupText _SPQtnFollowOnDocGroupText
SrcgProjMilestoneGroup SrcgProjMilestoneGroup
_SrcgProjMilestoneGroupText _SrcgProjMilestoneGroupText
SrcgProjPhaseGroup SrcgProjPhaseGroup
_SrcgProjPhaseGroupText _SrcgProjPhaseGroupText
SrcgProjItmConfDmndHasEnabled SrcgProjItmConfDmndHasEnabled
SourcingScenario SourcingScenario
SrcgProjCancellationRsnGroup SrcgProjCancellationRsnGroup
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel:{
    representativeKey: 'SourcingProjectType',
    sapObjectNodeType.name: 'SourcingProjectType',
    resultSet.sizeCategory: #XS,
    usageType:{
        dataClass: #CUSTOMIZING,
        serviceQuality: #A,
        sizeCategory: #S
        },
    supportedCapabilities: [#SEARCHABLE_ENTITY,#SQL_DATA_SOURCE,#CDS_MODELING_DATA_SOURCE,#CDS_MODELING_ASSOCIATION_TARGET],
    modelingPattern: #NONE
    }   

@VDM.viewType: #BASIC

@Search.searchable: true

@EndUserText.label: 'Type of Sourcing Project'
define root view entity I_SourcingProjectType
  as select from R_SourcingProjectType 
  composition [0..*] of I_SourcingProjectTypeText    as _SourcingProjectTypeText
  association [0..*] to I_SrcgProjPhaseGroupText     as _SrcgProjPhaseGroupText     on $projection.SrcgProjPhaseGroup = _SrcgProjPhaseGroupText.SrcgProjPhaseGroup
  association [0..*] to I_SrcgProjMilestoneGroupText as _SrcgProjMilestoneGroupText on $projection.SrcgProjMilestoneGroup = _SrcgProjMilestoneGroupText.SrcgProjMilestoneGroup
  association [0..*] to I_SrcgProjContactGroupText   as _SrcgProjContactGroupText   on $projection.SrcgProjContactGroup = _SrcgProjContactGroupText.SrcgProjContactGroup
  association [0..*] to I_SPQtnFollowOnDocGroupText  as _SPQtnFollowOnDocGroupText  on $projection.SrcgProjFollowOnDocumentGroup = _SPQtnFollowOnDocGroupText.SrcgProjFollowOnDocumentGroup
{
      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
      @ObjectModel.text.association: '_SourcingProjectTypeText'
  key SourcingProjectType               as SourcingProjectType,
      _SourcingProjectTypeText,

      SrcgProjItemUnconfdDmndRsnGrp     as SrcgProjItemUnconfdDmndRsnGrp,
      SrcPrjSuplrPartcipnDclnRsnGrp     as SrcPrjSuplrPartcipnDclnRsnGrp,
      SrcgProjQtnItemExcludingRsnGrp    as SrcgProjQtnItemExcludingRsnGrp,
      SrcgProjSuplrUnlockingRsnGroup    as SrcgProjSuplrUnlockingRsnGroup,
      SrcgProjVersioningReasonGroup     as SrcgProjVersioningReasonGroup,

      @ObjectModel.text.association: '_SrcgProjContactGroupText'
      SrcgProjContactGroup              as SrcgProjContactGroup,
      _SrcgProjContactGroupText,

      @ObjectModel.text.association: '_SPQtnFollowOnDocGroupText'
      SrcgProjFollowOnDocumentGroup     as SrcgProjFollowOnDocumentGroup,
      _SPQtnFollowOnDocGroupText,

      @ObjectModel.text.association: '_SrcgProjMilestoneGroupText'
      SrcgProjMilestoneGroup            as SrcgProjMilestoneGroup,
      _SrcgProjMilestoneGroupText,

      @ObjectModel.text.association: '_SrcgProjPhaseGroupText'
      SrcgProjPhaseGroup               as SrcgProjPhaseGroup,
      _SrcgProjPhaseGroupText,

      SrcgProjItmConfDmndHasEnabled    as SrcgProjItmConfDmndHasEnabled,

      SourcingScenario                 as SourcingScenario,

      SrcgProjCancellationRsnGroup     as SrcgProjCancellationRsnGroup

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_SOURCINGPROJECTTYPE"
],
"ASSOCIATED":
[
"I_SOURCINGPROJECTTYPETEXT",
"I_SPQTNFOLLOWONDOCGROUPTEXT",
"I_SRCGPROJCONTACTGROUPTEXT",
"I_SRCGPROJMILESTONEGROUPTEXT",
"I_SRCGPROJPHASEGROUPTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/