C_BasisPriceQuotation

DDL: C_BASISPRICEQUOTATION SQL: CBASPRICEQUOT Type: view CONSUMPTION
15 Fields 1 Data Sources

Basis Price Quotation

C_BasisPriceQuotation is a Consumption CDS View that provides data about "Basis Price Quotation" in SAP S/4HANA. It reads from 1 data source (I_BasisPriceQuotation) and exposes 15 fields.

Data Sources (1)

SourceAliasJoin Type
I_BasisPriceQuotation I_BasisPriceQuotation from

Annotations (10)

NameValueLevelField
EndUserText.label Basis Price Quotation view
Analytics.query true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CBASPRICEQUOT view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (15)

KeyFieldSource TableSource FieldDescription
BasisType BasisType Basis Type
BasisID BasisID Basis ID
DerivativeContrSpecification DerivativeContrSpecification DCS ID
MarketIdentifierCode MarketIdentifierCode MIC
PriceQuotationDate PriceQuotationDate
PriceQuotationType PriceQuotationType Price Type
PlannedDeliveryStartDate PlannedDeliveryStartDate
PlannedDeliveryEndDate PlannedDeliveryEndDate
ValidityStartUTCDateTime ValidityStartUTCDateTime Validity Start
MaturityKeyDate MaturityKeyDate Maturity Key Date
DerivativeContractMaturityCode DerivativeContractMaturityCode Contr. Maturity Code
Currency Currency Valuation Crcy
UnitOfMeasure UnitOfMeasure Unit Protected Qty
PriceQuotation PriceQuotation
CreatedByUser CreatedByUser User Name

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_BasisPriceQuotation.
-- 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: CBASPRICEQUOT

CREATE VIEW C_BasisPriceQuotation AS
SELECT
  BasisType,
  BasisID,
  DerivativeContrSpecification,
  MarketIdentifierCode,
  PriceQuotationDate,
  PriceQuotationType,
  PlannedDeliveryStartDate,
  PlannedDeliveryEndDate,
  ValidityStartUTCDateTime,
  MaturityKeyDate,
  DerivativeContractMaturityCode,
  Currency,
  UnitOfMeasure,
  PriceQuotation,
  CreatedByUser
FROM I_BasisPriceQuotation
;

Learn More