C_SrcgProjQtnSuplrCntctDocVar

DDL: C_SRCGPROJQTNSUPLRCNTCTDOCVAR Type: view CONSUMPTION
9 Fields 1 Data Sources 2 Associations

Doc Varbl for Supplier Contact in SPQtn

C_SrcgProjQtnSuplrCntctDocVar is a Consumption CDS View that provides data about "Doc Varbl for Supplier Contact in SPQtn" in SAP S/4HANA. It reads from 1 data source (I_SrcgProjQtnSupplierContact) and exposes 9 fields with key field SrcgProjQtnSupplierContactUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SrcgProjQtnSupplierContact I_SrcgProjQtnSupplierContact from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_SourcingProjQtnDocVarbl _SourcingProjectQuotation $projection.SourcingProjectQuotationUUID = _SourcingProjectQuotation.SourcingProjectQuotationUUID
[0..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CSPQTNCONTDV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey SrcgProjQtnSupplierContactUUID 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 Supplier Contact in SPQtn view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY SrcgProjQtnSupplierContactUUID SrcgProjQtnSupplierContactUUID Contact UUID for Supplier Quotation
SourcingProjectQuotationUUID SourcingProjectQuotationUUID Supplier Quotation UUID
SrcgProjQtnSupplierContactCat SrcgProjQtnSupplierContactCat Contact Category
SourcingProjectContactCatName
BusinessPartner BusinessPartner Issuing Authority
IsBusinessPurposeCompleted _BusinessPartner IsBusinessPurposeCompleted Purpose Completed
AuthorizationGroup _BusinessPartner AuthorizationGroup AuthorizGroup
_SourcingProjectQuotation _SourcingProjectQuotation
_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_SrcgProjQtnSuplrCntctDocVar.
-- 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 C_SrcgProjQtnSuplrCntctDocVar AS
SELECT
  SrcgProjQtnSupplierContactUUID,
  SourcingProjectQuotationUUID,
  SrcgProjQtnSupplierContactCat,
  _SourcingProjectContactCat._SourcingProjectContactCatT[1: Language = $session.system_language ].SourcingProjectContactCatName AS SourcingProjectContactCatName,
  BusinessPartner,
  _BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _BusinessPartner.AuthorizationGroup AS AuthorizationGroup
FROM I_SrcgProjQtnSupplierContact
LEFT OUTER JOIN C_SourcingProjQtnDocVarbl AS _SourcingProjectQuotation ON SourcingProjectQuotationUUID = _SourcingProjectQuotation.SourcingProjectQuotationUUID  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
;

Learn More