R_PROCUREMENTPROJECT

CDS View

Procurement Project

R_PROCUREMENTPROJECT is a CDS View in S/4HANA. Procurement Project. 4 CDS views read from this table.

Used by 4 CDS view(s)

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_ProcurementProjectVH view_entity from CONSUMPTION Procurement Project
I_ProcurementProject view_entity from BASIC Procurement Project
P_SrcgProjProcmtProjProdnDte view_entity from CONSUMPTION Production Dates for the Procurement Project in Srcg Project
R_ProcurementProjectTP view_entity from TRANSACTIONAL Procurement Project - TP 
@ClientHandling.algorithm: #SESSION_VARIABLE

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

@AccessControl.authorizationCheck: #MANDATORY

@ObjectModel:{
               representativeKey: 'ProcurementProjectUUID',
               semanticKey: ['ProcurementProject'],

               usageType: {
                 dataClass: #TRANSACTIONAL,
//               Service Quality A/B needed

                 serviceQuality: #A,
                 sizeCategory: #M
              }
}

@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API
}

@EndUserText.label: 'Procurement Project'
define view R_ProcurementProject
  as select from mmprocmtproj

  association [1..*] to R_ProcurementProjectPlant     as _ProcurementProjectPlant     on $projection.ProcurementProjectUUID = _ProcurementProjectPlant.ProcurementProjectUUID

  association [1..*] to I_ProcurementProjActvtnStsTxt as _ProcurementProjActvtnStsTxt on $projection.ProcurementProjectActvtnSts = _ProcurementProjActvtnStsTxt.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

{
  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,
 
      procmtplanningsubprojectuuid  as ProcmtPlanningSubprojectUUID,
      iseopblocked                as IsEndOfPurposeBlocked,

      //composition

      _ProcurementProjectPlant,
      //text

      _CompanyCode,
      _ProcurementProjActvtnStsTxt,
      //contact card

      _CreatedByUser,
      _ChangedByUser

}

Learn More