P_BasisPriceQuotationActual

DDL: P_BASISPRICEQUOTATIONACTUAL SQL: PBASPRICEQUOTL Type: view BASIC
24 Fields 1 Data Sources

P_BasisPriceQuotationActual is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (P_BasisPriceQuotation) and exposes 24 fields with key fields BasisType, BasisID, DerivativeContrSpecification, MarketIdentifierCode, PlannedDeliveryStartDate.

Data Sources (1)

SourceAliasJoin Type
P_BasisPriceQuotation Quotation from

Annotations (8)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PBASPRICEQUOTL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY BasisType P_BasisPriceQuotation BasisType Basis Type
KEY BasisID P_BasisPriceQuotation BasisID Basis ID
KEY DerivativeContrSpecification P_BasisPriceQuotation DerivativeContrSpecification DCS ID
KEY MarketIdentifierCode P_BasisPriceQuotation MarketIdentifierCode MIC
KEY PlannedDeliveryStartDate P_BasisPriceQuotation PlannedDeliveryStartDate Delivery Start Date
KEY PlannedDeliveryEndDate P_BasisPriceQuotation PlannedDeliveryEndDate Delivery End Date
KEY PriceQuotationType P_BasisPriceQuotation PriceQuotationType Price Type
KEY PriceQuotationDate P_BasisPriceQuotation PriceQuotationDate Price Date
KEY PriceQuotationTime P_BasisPriceQuotation PriceQuotationTime Price Time
KEY ValidityStartUTCDateTime
MaturityKeyDate MaturityKeyDate Maturity Key Date
DerivativeContractMaturityCode DerivativeContractMaturityCode Contr. Maturity Code
PriceQuotation PriceQuotation RVP f.PricePro.
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 P_BasisPriceQuotationActual.
-- 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: PBASPRICEQUOTL

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

Learn More