I_SrcgProjNegotiationQuotation

DDL: I_SRCGPROJNEGOTIATIONQUOTATION Type: view_entity BASIC

Quotation for Srcg Project Negotiation

I_SrcgProjNegotiationQuotation is a Basic CDS View that provides data about "Quotation for Srcg Project Negotiation" in SAP S/4HANA. It reads from 1 data source (R_SrcgProjNegotiationQuotation) and exposes 13 fields with key field SrcgProjNegttnQuotationUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_SrcgProjNegotiationQuotation R_SrcgProjNegotiationQuotation from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_SourcingProjectNegotiation _SourcingProjectNegotiation $projection.SourcingProjectNegotiationUUID = _SourcingProjectNegotiation.SourcingProjectNegotiationUUID
[0..*] I_SrcgProjNegttnQuotationItem _SrcgProjNegttnQuotationItem $projection.SrcgProjNegttnQuotationUUID = _SrcgProjNegttnQuotationItem.SrcgProjNegttnQuotationUUID
[1..1] I_SourcingProjectQuotation _SourcingProjectQuotation $projection.SourcingProjectQuotationUUID = _SourcingProjectQuotation.SourcingProjectQuotationUUID
[0..1] I_BusinessPartner _BusinessPartner $projection.Bidder = _BusinessPartner.BusinessPartner

Annotations (11)

NameValueLevelField
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Quotation for Srcg Project Negotiation view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey SrcgProjNegttnQuotationUUID view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Analytics.technicalName ISRCGNGNQTN view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY SrcgProjNegttnQuotationUUID SrcgProjNegttnQuotationUUID Negotiation Quotation UUID
SourcingProjectNegotiationUUID SourcingProjectNegotiationUUID Negotiation UUID
SourcingProjectQuotationUUID SourcingProjectQuotationUUID Supplier Quotation UUID
SourcingProjectQuotation SourcingProjectQuotation Supplier Quotation
SrcgProjQuotationVersion SrcgProjQuotationVersion Version
Bidder Bidder Business Partner
SrcgProjNegttnTotalTargetAmt SrcgProjNegttnTotalTargetAmt Total Negotiation Target Amount
DocumentCurrency DocumentCurrency Document Currency
SPQtnForNegttnLtstVersionUUID SPQtnForNegttnLtstVersionUUID Supplier Quotation Latest Version UUID
_SourcingProjectNegotiation _SourcingProjectNegotiation
_SrcgProjNegttnQuotationItem _SrcgProjNegttnQuotationItem
_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 I_SrcgProjNegotiationQuotation.
-- 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_SrcgProjNegotiationQuotation AS
SELECT
  SrcgProjNegttnQuotationUUID,
  SourcingProjectNegotiationUUID,
  SourcingProjectQuotationUUID,
  SourcingProjectQuotation,
  SrcgProjQuotationVersion,
  Bidder,
  SrcgProjNegttnTotalTargetAmt,
  DocumentCurrency,
  SPQtnForNegttnLtstVersionUUID
FROM R_SrcgProjNegotiationQuotation
LEFT OUTER JOIN I_SourcingProjectNegotiation AS _SourcingProjectNegotiation ON SourcingProjectNegotiationUUID = _SourcingProjectNegotiation.SourcingProjectNegotiationUUID  -- association [1..1]
LEFT OUTER JOIN I_SrcgProjNegttnQuotationItem AS _SrcgProjNegttnQuotationItem ON SrcgProjNegttnQuotationUUID = _SrcgProjNegttnQuotationItem.SrcgProjNegttnQuotationUUID  -- association [0..*]
LEFT OUTER JOIN I_SourcingProjectQuotation AS _SourcingProjectQuotation ON SourcingProjectQuotationUUID = _SourcingProjectQuotation.SourcingProjectQuotationUUID  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON Bidder = _BusinessPartner.BusinessPartner  -- association [0..1]
;