I_BasisPriceQuotation

DDL: I_BASISPRICEQUOTATION SQL: IBASPRICEQUOT Type: view BASIC
24 Fields 1 Data Sources

Basis Price Quotation

I_BasisPriceQuotation is a Basic CDS View (Cube) that provides data about "Basis Price Quotation" in SAP S/4HANA. It reads from 1 data source (P_BasisPriceQuotationActual) and exposes 24 fields with key fields BasisType, BasisID, DerivativeContrSpecification, MarketIdentifierCode, PlannedDeliveryStartDate.

Data Sources (1)

SourceAliasJoin Type
P_BasisPriceQuotationActual P_BasisPriceQuotationActual from

Annotations (11)

NameValueLevelField
EndUserText.label Basis Price Quotation view
Analytics.dataCategory #CUBE view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName IBASPRICEQUOT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY BasisType BasisType Basis Type
KEY BasisID BasisID Basis ID
KEY DerivativeContrSpecification DerivativeContrSpecification DCS ID
KEY MarketIdentifierCode MarketIdentifierCode MIC
KEY PlannedDeliveryStartDate PlannedDeliveryStartDate
KEY PlannedDeliveryEndDate PlannedDeliveryEndDate
KEY PriceQuotationType PriceQuotationType Price Type
KEY PriceQuotationDate PriceQuotationDate
KEY PriceQuotationTime PriceQuotationTime
KEY ValidityStartUTCDateTime ValidityStartUTCDateTime Validity Start
MaturityKeyDate MaturityKeyDate Maturity Key Date
DerivativeContractMaturityCode DerivativeContractMaturityCode Contr. Maturity Code
PriceQuotation PriceQuotation
UnitOfMeasure UnitOfMeasure Unit Protected Qty
Currency Currency Valuation Crcy
CreatedByUser CreatedByUser User Name
IsDeleted IsDeleted TRUE
_BasisID _BasisID
_BasisType _BasisType
_Currency _Currency
_DerivativeContrSpecification _DerivativeContrSpecification
_MarketIdentifierCode _MarketIdentifierCode
_PriceQuotationType _PriceQuotationType
_UnitOfMeasure _UnitOfMeasure

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_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: IBASPRICEQUOT

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

Learn More