C_SupplierQuotationDEX

DDL: C_SUPPLIERQUOTATIONDEX SQL: CMMSUPLRSQTNDEX Type: view CONSUMPTION
37 Fields 1 Data Sources 1 Associations

Data Extraction for Supplier Quotation

C_SupplierQuotationDEX (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Supplier Quotation · Sourcing & Procurement

C_SupplierQuotationDEX is a Consumption CDS View (Fact) that provides data about "Data Extraction for Supplier Quotation" in SAP S/4HANA. It reads from 1 data source (I_SupplierQuotation_Api01) and exposes 37 fields with key field SupplierQuotation. It has 1 association to related views.

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentMM-PUR-ANA
CapabilitiesData Source for Data Extraction
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_SupplierQuotation_Api01 SupplierQuotation from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_PurchasingDocument _SupplierQuotationExtension $projection.SupplierQuotation = _SupplierQuotationExtension.PurchasingDocument

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CMMSUPLRSQTNDEX view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.modelingPattern #ANALYTICAL_FACT view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view
EndUserText.label Data Extraction for Supplier Quotation view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY SupplierQuotation I_SupplierQuotation_Api01 SupplierQuotation Supplier Quotation Number
CompanyCode I_SupplierQuotation_Api01 CompanyCode Receiver Company Code
PurchasingDocumentCategory I_SupplierQuotation_Api01 PurchasingDocumentCategory Purchasing Document Category
PurchasingDocumentType I_SupplierQuotation_Api01 PurchasingDocumentType Supplier Quotation Document Type
Supplier I_SupplierQuotation_Api01 Supplier Supplier
CreatedByUser I_SupplierQuotation_Api01 CreatedByUser User of person who created a purchasing document
CreationDate I_SupplierQuotation_Api01 CreationDate Creation Date of Purchasing Document
LastChangeDateTime I_SupplierQuotation_Api01 LastChangeDateTime Change Time Stamp
Language I_SupplierQuotation_Api01 Language Report Text Language
DocumentCurrency I_SupplierQuotation_Api01 DocumentCurrency Document Currency
IncotermsClassification I_SupplierQuotation_Api01 IncotermsClassification Incoterms (Part 1)
IncotermsTransferLocation I_SupplierQuotation_Api01 IncotermsTransferLocation Incoterms (Part 2)
IncotermsVersion I_SupplierQuotation_Api01 IncotermsVersion Incoterms Version
IncotermsLocation1 I_SupplierQuotation_Api01 IncotermsLocation1 Incoterms Location 1
IncotermsLocation2 I_SupplierQuotation_Api01 IncotermsLocation2 Incoterms Location 2
PaymentTerms I_SupplierQuotation_Api01 PaymentTerms Terms of Payment Key
CashDiscount1Days I_SupplierQuotation_Api01 CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days I_SupplierQuotation_Api01 CashDiscount2Days Days from Baseline Date for Payment
CashDiscount1Percent I_SupplierQuotation_Api01 CashDiscount1Percent Cash Discount Percentage 1
CashDiscount2Percent I_SupplierQuotation_Api01 CashDiscount2Percent Cash Discount Percentage 2
NetPaymentDays I_SupplierQuotation_Api01 NetPaymentDays Net Payment Terms Period
PricingProcedure I_SupplierQuotation_Api01 PricingProcedure Procedure (Pricing, Output Control, Acct. Det., Costing,...)
PricingDocument I_SupplierQuotation_Api01 PurchasingDocumentCondition Number of the Document Condition
PurchasingOrganization I_SupplierQuotation_Api01 PurchasingOrganization Purchasing Organization
PurchasingGroup I_SupplierQuotation_Api01 PurchasingGroup Purchasing Group
PurchasingDocumentOrderDate I_SupplierQuotation_Api01 PurchasingDocumentOrderDate Purchasing Document Date
RequestForQuotation I_SupplierQuotation_Api01 RequestForQuotation Request for Quotation
SupplierQuotationExternalID I_SupplierQuotation_Api01 SupplierQuotationExternalID Quotation Number
QuotationSubmissionDate I_SupplierQuotation_Api01 QuotationSubmissionDate Quotation Submission Date
QuotationLatestSubmissionDate I_SupplierQuotation_Api01 QuotationLatestSubmissionDate Deadline for Submission of Bid/Quotation
BindingPeriodValidityEndDate I_SupplierQuotation_Api01 BindingPeriodValidityEndDate Binding Period for Quotation
ExchangeRate I_SupplierQuotation_Api01 ExchangeRate Exchange rate
ExchangeRateIsFixed I_SupplierQuotation_Api01 ExchangeRateIsFixed Indicator for Fixed Exchange Rate
QtnLifecycleStatus I_SupplierQuotation_Api01 QTNLifecycleStatus Supplier Quotation Lifecycle Status
FollowOnDocumentCategory I_SupplierQuotation_Api01 FollowOnDocumentCategory Follow-On Purchasing Document Category
PurgDocFollowOnDocumentType I_SupplierQuotation_Api01 FollowOnDocumentType Follow-On Purchasing Document Type
IsEndOfPurposeBlocked I_SupplierQuotation_Api01 IsEndOfPurposeBlocked Business Purpose Completed

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_SupplierQuotationDEX.
-- 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: CMMSUPLRSQTNDEX

CREATE VIEW C_SupplierQuotationDEX AS
SELECT
  SupplierQuotation.SupplierQuotation AS SupplierQuotation,
  SupplierQuotation.CompanyCode AS CompanyCode,
  SupplierQuotation.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  SupplierQuotation.PurchasingDocumentType AS PurchasingDocumentType,
  SupplierQuotation.Supplier AS Supplier,
  SupplierQuotation.CreatedByUser AS CreatedByUser,
  SupplierQuotation.CreationDate AS CreationDate,
  SupplierQuotation.LastChangeDateTime AS LastChangeDateTime,
  SupplierQuotation.Language AS Language,
  SupplierQuotation.DocumentCurrency AS DocumentCurrency,
  SupplierQuotation.IncotermsClassification AS IncotermsClassification,
  SupplierQuotation.IncotermsTransferLocation AS IncotermsTransferLocation,
  SupplierQuotation.IncotermsVersion AS IncotermsVersion,
  SupplierQuotation.IncotermsLocation1 AS IncotermsLocation1,
  SupplierQuotation.IncotermsLocation2 AS IncotermsLocation2,
  SupplierQuotation.PaymentTerms AS PaymentTerms,
  SupplierQuotation.CashDiscount1Days AS CashDiscount1Days,
  SupplierQuotation.CashDiscount2Days AS CashDiscount2Days,
  SupplierQuotation.CashDiscount1Percent AS CashDiscount1Percent,
  SupplierQuotation.CashDiscount2Percent AS CashDiscount2Percent,
  SupplierQuotation.NetPaymentDays AS NetPaymentDays,
  SupplierQuotation.PricingProcedure AS PricingProcedure,
  SupplierQuotation.PurchasingDocumentCondition AS PricingDocument,
  SupplierQuotation.PurchasingOrganization AS PurchasingOrganization,
  SupplierQuotation.PurchasingGroup AS PurchasingGroup,
  SupplierQuotation.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  SupplierQuotation.RequestForQuotation AS RequestForQuotation,
  SupplierQuotation.SupplierQuotationExternalID AS SupplierQuotationExternalID,
  SupplierQuotation.QuotationSubmissionDate AS QuotationSubmissionDate,
  SupplierQuotation.QuotationLatestSubmissionDate AS QuotationLatestSubmissionDate,
  SupplierQuotation.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  SupplierQuotation.ExchangeRate AS ExchangeRate,
  SupplierQuotation.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  SupplierQuotation.QTNLifecycleStatus AS QtnLifecycleStatus,
  SupplierQuotation.FollowOnDocumentCategory AS FollowOnDocumentCategory,
  SupplierQuotation.FollowOnDocumentType AS PurgDocFollowOnDocumentType,
  SupplierQuotation.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked
FROM I_SupplierQuotation_Api01 AS SupplierQuotation
LEFT OUTER JOIN E_PurchasingDocument AS _SupplierQuotationExtension ON SupplierQuotation = _SupplierQuotationExtension.PurchasingDocument  -- association [1..1]
;

Learn More