I_SourcingProjectContact

DDL: I_SOURCINGPROJECTCONTACT Type: view_entity BASIC
10 Fields 1 Data Sources 3 Associations

Contact for Sourcing Project

I_SourcingProjectContact is a Basic CDS View that provides data about "Contact for Sourcing Project" in SAP S/4HANA. It reads from 1 data source (R_SourcingProjectContact) and exposes 10 fields with key field SourcingProjectContactUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_SourcingProjectContact R_SourcingProjectContact from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_SourcingProject _SourcingProject $projection.SourcingProjectUUID = _SourcingProject.SourcingProjectUUID
[0..1] I_SourcingProjectContactCat _SourcingProjectContactCat $projection.SourcingProjectContactCategory = _SourcingProjectContactCat.SourcingProjectContactCategory
[0..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey SourcingProjectContactUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
EndUserText.label Contact for Sourcing Project view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectContactUUID SourcingProjectContactUUID Contact UUID
SourcingProjectUUID SourcingProjectUUID Sourcing Project UUID
SourcingProjectContactCategory SourcingProjectContactCategory Contact Category
BusinessPartner BusinessPartner Issuing Authority
SrcgProjCntctIsVisibleToSuplr SrcgProjCntctIsVisibleToSuplr Visible to Supplier
IsBusinessPurposeCompleted _BusinessPartner IsBusinessPurposeCompleted Purpose Completed
AuthorizationGroup _BusinessPartner AuthorizationGroup AuthorizGroup
_SourcingProject _SourcingProject
_SourcingProjectContactCat _SourcingProjectContactCat
_BusinessPartner _BusinessPartner

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_SourcingProjectContact.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_SourcingProjectContact AS
SELECT
  SourcingProjectContactUUID,
  SourcingProjectUUID,
  SourcingProjectContactCategory,
  BusinessPartner,
  SrcgProjCntctIsVisibleToSuplr,
  _BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _BusinessPartner.AuthorizationGroup AS AuthorizationGroup
FROM R_SourcingProjectContact
LEFT OUTER JOIN I_SourcingProject AS _SourcingProject ON SourcingProjectUUID = _SourcingProject.SourcingProjectUUID  -- association [1..1]
LEFT OUTER JOIN I_SourcingProjectContactCat AS _SourcingProjectContactCat ON SourcingProjectContactCategory = _SourcingProjectContactCat.SourcingProjectContactCategory  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
;

Learn More