C_RFQSuppQuotationStatus

DDL: C_RFQSUPPQUOTATIONSTATUS SQL: CSUPLRQTNSTATUS Type: view CONSUMPTION
11 Fields 1 Data Sources 1 Associations

Consumption View For Supplier Quotation

C_RFQSuppQuotationStatus is a Consumption CDS View that provides data about "Consumption View For Supplier Quotation" in SAP S/4HANA. It reads from 1 data source (P_Rfqitemsmntr) and exposes 11 fields with key fields RequestForQuotation, RequestForQuotationItem, SupplierQuotation, SupplierQuotationItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_Rfqitemsmntr P_Rfqitemsmntr from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ProcmtQuotationSts _ProcmtQuotationSts _ProcmtQuotationSts.QtnLifecycleStatus = $projection.QtnLifecycleStatus association[1..1] to I_RequestForQuotation as _RequestForQuotation on $projection.RequestForQuotation = _RequestForQuotation.RequestForQuotation

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CSUPLRQTNSTATUS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
EndUserText.label Consumption View For Supplier Quotation view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY RequestForQuotation RequestForQuotation RFQ
KEY RequestForQuotationItem RequestForQuotationItem RFQ Item
KEY SupplierQuotation SupplierQuotation RFQ
KEY SupplierQuotationItem SupplierQuotationItem Supplier Quotation Item
Plant Plant Valuation Area
QtnLifecycleStatus QtnLifecycleStatus Quotation Status
QtnLifecycleStatusName Quotation Status Name
NumberOfContractItems RFQ Items
Supplier P_Rfqitemsmntr Supplier Supplier
_ProcmtQuotationSts _ProcmtQuotationSts
_RequestForQuotation _RequestForQuotation

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_RFQSuppQuotationStatus.
-- 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: CSUPLRQTNSTATUS

CREATE VIEW C_RFQSuppQuotationStatus AS
SELECT
  RequestForQuotation,
  RequestForQuotationItem,
  SupplierQuotation,
  SupplierQuotationItem,
  Plant,
  QtnLifecycleStatus,
  _ProcmtQuotationSts._Text[1: Language = $session.system_language ].QtnLifecycleStatusName AS QtnLifecycleStatusName,
  cast( 1 as mm_a_contractitems ) AS NumberOfContractItems,
  P_Rfqitemsmntr.Supplier AS Supplier
FROM P_Rfqitemsmntr
LEFT OUTER JOIN I_ProcmtQuotationSts AS _ProcmtQuotationSts ON _ProcmtQuotationSts.QtnLifecycleStatus = QtnLifecycleStatus association[1..1] to I_RequestForQuotation as _RequestForQuotation on RequestForQuotation = _RequestForQuotation.RequestForQuotation  -- association [1..1]
;

Learn More