C_SrcgProjPotentialContactVH

DDL: C_SRCGPROJPOTENTIALCONTACTVH SQL: CSRCGPROJPTCNTVH Type: view CONSUMPTION Package: ODATA_MM_PUR_SRCGPROJ_MAINTAIN
3 Fields 2 Data Sources 2 OData Services

Potential Contact for Sourcing Project

C_SrcgProjPotentialContactVH is a Consumption CDS View that provides data about "Potential Contact for Sourcing Project" in SAP S/4HANA. It reads from 2 data sources (I_SrcgProjPotentialContact, I_PersonWorkAgrmtStatus) and exposes 3 fields with key field BusinessPartner. It is exposed through 2 OData services (UI_SOURCINGPROJECT_MANAGE, UI_SRCGPROJ_CONTRIBUTE). Part of development package ODATA_MM_PUR_SRCGPROJ_MAINTAIN.

Data Sources (2)

SourceAliasJoin Type
I_SrcgProjPotentialContact bupa from
I_PersonWorkAgrmtStatus WorkAgrmtStatus inner

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CSRCGPROJPTCNTVH view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey BusinessPartner view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.dataCategory #VALUE_HELP view
UI.headerInfo.typeName Contact view
UI.headerInfo.typeNamePlural Contacts view
UI.headerInfo.imageUrl EmployeeImageURL view
VDM.viewType #CONSUMPTION view
Search.searchable true view
Consumption.ranked true view
EndUserText.label Potential Contact for Sourcing Project view

OData Services (2)

ServiceBindingVersionContractRelease
UI_SOURCINGPROJECT_MANAGE UI_SOURCINGPROJECT_MANAGE V2 C1 NOT_RELEASED
UI_SRCGPROJ_CONTRIBUTE UI_SRCGPROJ_CONTRIBUTE V2 C1 NOT_RELEASED

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner
PersonFullName I_SrcgProjPotentialContact PersonFullName Full Name
DataController10

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 C_SrcgProjPotentialContactVH.
-- 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.
-- SQL view name: CSRCGPROJPTCNTVH

CREATE VIEW C_SrcgProjPotentialContactVH AS
SELECT
  cast (bupa.BusinessPartner as mm_pur_srcgproj_contact_id preserving type ) AS BusinessPartner,
  bupa.PersonFullName AS PersonFullName
FROM I_SrcgProjPotentialContact AS bupa
INNER JOIN I_PersonWorkAgrmtStatus AS WorkAgrmtStatus ON /* join condition not captured in parsed metadata */
;

Learn More