R_SrcgProjContributionForUser

DDL: R_SRCGPROJCONTRIBUTIONFORUSER Type: view_entity COMPOSITE

Sourcing Project

R_SrcgProjContributionForUser is a Composite CDS View that provides data about "Sourcing Project" in SAP S/4HANA.

8 fields

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Sourcing Project view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectUUID Contact SourcingProjectUUID
UserID Contact UserID
BusinessPartnerUUID Contact BusinessPartnerUUID
SourcingProjectType SP SourcingProjectType
CompanyCode SP CompanyCode
PurchasingGroup SP PurchasingGroup
PurchasingOrganization SP PurchasingOrganization
MaterialGroup SP MaterialGroup 
@AccessControl: { authorizationCheck:     #PRIVILEGED_ONLY,
                  personalData.blocking:  #BLOCKED_DATA_EXCLUDED
}
@EndUserText.label: 'Sourcing Project'
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
  lifecycle: {
    contract: { type: #SAP_INTERNAL_API  }
  },
  viewType: #COMPOSITE
}
@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity R_SrcgProjContributionForUser
  as select distinct from R_SourcingProjectContact as Contact
  inner to one join R_SourcingProject as SP on SP.SourcingProjectUUID = Contact.SourcingProjectUUID

{
  key Contact.SourcingProjectUUID,
  Contact.UserID,
  Contact.BusinessPartnerUUID,
  SP.SourcingProjectType,
  SP.CompanyCode,
  SP.PurchasingGroup,
  SP.PurchasingOrganization,
  SP.MaterialGroup
  
} where Contact.SrcgProjContactIsContributor = 'X' and Contact.UserID = $session.user

Learn More