R_SOURCINGPROJECTTYPE

CDS View

Sourcing Project Type

R_SOURCINGPROJECTTYPE is a CDS View in S/4HANA. Sourcing Project Type. It contains 9 fields. 13 CDS views read from this table.

Used by 13 CDS view(s) 9 fields

CDS Views using this table (13)

ViewTypeJoinVDMDescription
I_ProdSrcgTypeCanclnModel view_entity from BASIC Cancelation Model for Product Srcg Type
I_ProdSrcgTypeItemExcludeModel view_entity from BASIC Item Exclude Model for Product Srcg Type
I_ProdSrcgTypeUnconfdRsnModel view_entity from BASIC Unconfd Reason Model for Prod Srcg Type
I_ProdSrcgTypeUnlkSuplrModel view_entity from BASIC Unlock Supplier Model for Prod Srcg Type
I_ProdSrcgTypeVersionModel view_entity from BASIC Version Model for Product Sourcing Type
I_SourcingProjectType view_entity from BASIC Type of Sourcing Project
I_SPQtnTypeContactCatModel view_entity from BASIC Contact Category Model for SPQtn Type
I_SrcgProjCntctCatBySrcgType view_entity from BASIC Cntct Category Grps for Srcg Proj Types
I_SrcgProjFollowOnDocCat view_entity from BASIC Follow On Document Category in Srcg Proj
I_SrcgProjFollowOnDocType view_entity from BASIC Follow On Document Type in Sourcing Proj
I_SrcgProjTypeContactCatModel view_entity from BASIC Contact Category Model for SrcPrj Type
I_SrcgProjTypeMilestoneModel view_entity from BASIC Milestone Model for Sourcing Proj Type
I_SrcgProjTypePhaseModel view_entity from BASIC Phase Model for Sourcing Project Type

Fields (9)

KeyField CDS FieldsUsed in Views
KEY SourcingProjectType SourcingProjectType 12
KEY SrcgProjCancellationRsnGroup SrcgProjCancellationRsnGroup 1
KEY SrcgProjContactGroup SrcgProjContactGroup 2
KEY SrcgProjItemUnconfdDmndRsnGrp SrcgProjItemUnconfdDmndRsnGrp 1
KEY SrcgProjMilestoneGroup SrcgProjMilestoneGroup 1
KEY SrcgProjPhaseGroup SrcgProjPhaseGroup 1
KEY SrcgProjQtnItemExcludingRsnGrp SrcgProjQtnItemExcludingRsnGrp 1
KEY SrcgProjSuplrUnlockingRsnGroup SrcgProjSuplrUnlockingRsnGroup 1
KEY SrcgProjVersioningReasonGroup SrcgProjVersioningReasonGroup 1 
@ClientHandling.algorithm: #SESSION_VARIABLE

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

@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel:{
               representativeKey: 'SourcingProjectType',
               usageType: {
                 dataClass: #CUSTOMIZING,
                 serviceQuality: #A,
                 sizeCategory: #S
              }
}

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


@EndUserText.label: 'Sourcing Project Type'
define view R_SourcingProjectType
  as select from mmpursrcgproj_ty
 {
    key sptype                      as SourcingProjectType,    
        sp_unconfd_dmnd_group       as SrcgProjItemUnconfdDmndRsnGrp,
        sp_dclnsuplrpartcip_group   as SrcPrjSuplrPartcipnDclnRsnGrp,
        sp_excludingqtnitem_group   as SrcgProjQtnItemExcludingRsnGrp,
        sp_unlockingsuplr_group     as SrcgProjSuplrUnlockingRsnGroup,
        sp_versioning_group         as SrcgProjVersioningReasonGroup,
     
        sp_cont_group               as SrcgProjContactGroup,
      
        sp_fod_group                as SrcgProjFollowOnDocumentGroup,
    
        sp_mlstn_group              as SrcgProjMilestoneGroup,
     
        sp_phase_group              as SrcgProjPhaseGroup,
    
        sp_dmd_confirm_enablement   as SrcgProjItmConfDmndHasEnabled,

        sourcingscenario            as SourcingScenario,

        sp_cancellationrsn_group    as SrcgProjCancellationRsnGroup    
  }

Learn More