I_ProcurementProject

DDL: I_PROCUREMENTPROJECT Type: view_entity BASIC

Procurement Project

I_ProcurementProject is a Basic CDS View that provides data about "Procurement Project" in SAP S/4HANA. It reads from 1 data source (R_ProcurementProject) and exposes 18 fields with key field ProcurementProjectUUID. It has 6 associations to related views.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
R_ProcurementProject R_ProcurementProject from

Associations (6)

CardinalityTargetAliasCondition
[1..*] I_ProcurementProjectPlant _ProcurementProjectPlant $projection.ProcurementProjectUUID = _ProcurementProjectPlant.ProcurementProjectUUID
[0..1] I_ProcurementProjectActvtnSts _ProcurementProjectActvtnSts $projection.ProcurementProjectActvtnSts = _ProcurementProjectActvtnSts.ProcurementProjectActvtnSts
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_UserContactCard _CreatedByUser $projection.CreatedByUser = _CreatedByUser.ContactCardID
[0..1] I_UserContactCard _ChangedByUser $projection.LastChangedByUser = _ChangedByUser.ContactCardID
[1..1] E_ProcurementProject _Extension $projection.ProcurementProjectUUID = _Extension.ProcurementProjectUUID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey ProcurementProjectUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view
EndUserText.label Procurement Project view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ProcurementProjectUUID ProcurementProjectUUID
ProcurementProject ProcurementProject
ProcurementProjectName ProcurementProjectName
ExternalProjectReference ExternalProjectReference
CompanyCode CompanyCode
LastChangedByUser LastChangedByUser
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
CreationDateTime CreationDateTime
ProcurementProjectActvtnSts ProcurementProjectActvtnSts
SourcingOrigin SourcingOrigin
SourcingScenario SourcingScenario
IsEndOfPurposeBlocked IsEndOfPurposeBlocked
_ProcurementProjectPlant _ProcurementProjectPlant
_CompanyCode _CompanyCode
_CreatedByUser _CreatedByUser
_ChangedByUser _ChangedByUser
_ProcurementProjectActvtnSts _ProcurementProjectActvtnSts 
@AccessControl.authorizationCheck: #MANDATORY

@ObjectModel:{ representativeKey: 'ProcurementProjectUUID',
               semanticKey: ['ProcurementProject'],
               usageType.dataClass: #TRANSACTIONAL,
               usageType.serviceQuality: #A,
               usageType.sizeCategory: #M }

@VDM.viewType: #BASIC

@EndUserText.label: 'Procurement Project'

define view entity I_ProcurementProject
  as select from R_ProcurementProject 

  association [1..*] to I_ProcurementProjectPlant     as _ProcurementProjectPlant     on $projection.ProcurementProjectUUID = _ProcurementProjectPlant.ProcurementProjectUUID
  association [0..1] to I_ProcurementProjectActvtnSts as _ProcurementProjectActvtnSts on $projection.ProcurementProjectActvtnSts = _ProcurementProjectActvtnSts.ProcurementProjectActvtnSts
  association [0..1] to I_CompanyCode                 as _CompanyCode                 on $projection.CompanyCode = _CompanyCode.CompanyCode
  //tbd

  association [0..1] to I_UserContactCard             as _CreatedByUser               on $projection.CreatedByUser = _CreatedByUser.ContactCardID
  association [0..1] to I_UserContactCard             as _ChangedByUser               on $projection.LastChangedByUser = _ChangedByUser.ContactCardID

  //Extension

  association [1..1] to E_ProcurementProject          as _Extension                   on $projection.ProcurementProjectUUID = _Extension.ProcurementProjectUUID

{

  key ProcurementProjectUUID      as ProcurementProjectUUID,
      ProcurementProject          as ProcurementProject,
      ProcurementProjectName      as ProcurementProjectName,

      ExternalProjectReference    as ExternalProjectReference,
      CompanyCode                 as CompanyCode,

      @Semantics.user.lastChangedBy: true
      LastChangedByUser           as LastChangedByUser,
      @Semantics.user.createdBy: true
      CreatedByUser               as CreatedByUser,

      @Semantics.systemDateTime.lastChangedAt: true
      LastChangeDateTime          as LastChangeDateTime,

      @Semantics.systemDateTime.createdAt: true
      CreationDateTime            as CreationDateTime,

      ProcurementProjectActvtnSts as ProcurementProjectActvtnSts,
      SourcingOrigin              as SourcingOrigin, 
      SourcingScenario            as SourcingScenario,           
      IsEndOfPurposeBlocked       as IsEndOfPurposeBlocked,

      /* Associations */
      _ProcurementProjectPlant,
      //foreign key associations

      _CompanyCode,
      //tbd

      _CreatedByUser,
      _ChangedByUser,
      _ProcurementProjectActvtnSts


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_PROCUREMENTPROJECT"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_PROCUREMENTPROJECTACTVTNSTS",
"I_PROCUREMENTPROJECTPLANT",
"I_USERCONTACTCARD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More