I_SrcgProjQtnNameBySemanticKey

DDL: I_SRCGPROJQTNNAMEBYSEMANTICKEY Type: view_entity BASIC Package: VDM_MM_PUR_SRCGPROJQTN
9 Fields 1 Data Sources

Srcg Proj Qtn Name by Semantic Key

I_SrcgProjQtnNameBySemanticKey is a Basic CDS View that provides data about "Srcg Proj Qtn Name by Semantic Key" in SAP S/4HANA. It reads from 1 data source (R_SourcingProjectQuotation) and exposes 9 fields with key fields SourcingProjectQuotation, SrcgProjQuotationVersion. Part of development package VDM_MM_PUR_SRCGPROJQTN.

Data Sources (1)

SourceAliasJoin Type
R_SourcingProjectQuotation R_SourcingProjectQuotation from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Analytics.technicalName ISPQNAMEBYSEMK view
ObjectModel.representativeKey SourcingProjectQuotation view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view
EndUserText.label Srcg Proj Qtn Name by Semantic Key view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectQuotation SourcingProjectQuotation Supplier Quotation
KEY SrcgProjQuotationVersion SrcgProjQuotationVersion Version
SourcingProjectQuotationName SourcingProjectQuotationName Name
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
SourcingProjectQuotationType SourcingProjectQuotationType Sourcing Project Quotation Type
CompanyCode CompanyCode Receiver Company Code
MaterialGroup MaterialGroup Product Group
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.

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_SrcgProjQtnNameBySemanticKey.
-- 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_SrcgProjQtnNameBySemanticKey AS
SELECT
  SourcingProjectQuotation,
  SrcgProjQuotationVersion,
  SourcingProjectQuotationName,
  PurchasingOrganization,
  PurchasingGroup,
  SourcingProjectQuotationType,
  CompanyCode,
  MaterialGroup,
  IsEndOfPurposeBlocked
FROM R_SourcingProjectQuotation
;

Learn More