C_SrcgProjContactDocVarbl

DDL: C_SRCGPROJCONTACTDOCVARBL SQL: CSRCGPROJCNTVB Type: view CONSUMPTION
11 Fields 1 Data Sources 1 Associations

Doc Varbl for Contacts for Sourcing Proj

C_SrcgProjContactDocVarbl is a Consumption CDS View that provides data about "Doc Varbl for Contacts for Sourcing Proj" in SAP S/4HANA. It reads from 1 data source (I_SourcingProjectContact) and exposes 11 fields with key field SourcingProjectContactUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SourcingProjectContact I_SourcingProjectContact from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_SourcingProjectDocVarbl _SourcingProject $projection.SourcingProjectUUID = _SourcingProject.SourcingProjectUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CSRCGPROJCNTVB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey SourcingProjectContactUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
EndUserText.label Doc Varbl for Contacts for Sourcing Proj view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectContactUUID SourcingProjectContactUUID Contact UUID
SourcingProjectUUID SourcingProjectUUID Sourcing Project UUID
SourcingProjectContactCategory SourcingProjectContactCategory Contact Category
SourcingProjectContactCatName
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerFullName
SrcgProjCntctIsVisibleToSuplr SrcgProjCntctIsVisibleToSuplr Visible to Supplier
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
AuthorizationGroup AuthorizationGroup AuthorizGroup
_SourcingProject _SourcingProject
_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 C_SrcgProjContactDocVarbl.
-- 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: CSRCGPROJCNTVB

CREATE VIEW C_SrcgProjContactDocVarbl AS
SELECT
  SourcingProjectContactUUID,
  SourcingProjectUUID,
  SourcingProjectContactCategory,
  _SourcingProjectContactCat._SourcingProjectContactCatT[1: Language = $session.system_language ].SourcingProjectContactCatName AS SourcingProjectContactCatName,
  BusinessPartner,
  _BusinessPartner[IsBusinessPurposeCompleted = ''].BusinessPartnerFullName AS BusinessPartnerFullName,
  SrcgProjCntctIsVisibleToSuplr,
  IsBusinessPurposeCompleted,
  AuthorizationGroup
FROM I_SourcingProjectContact
LEFT OUTER JOIN C_SourcingProjectDocVarbl AS _SourcingProject ON SourcingProjectUUID = _SourcingProject.SourcingProjectUUID  -- association [1..1]
;

Learn More