P_BASISPRICEQUOTATION

CDS View

P_BASISPRICEQUOTATION is a CDS View in S/4HANA. It contains 9 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_BasisPriceQuotationActual view from BASIC
P_Basispricequotationaggr view from BASIC

Fields (9)

KeyField CDS FieldsUsed in Views
KEY BasisID BasisID 1
KEY BasisType BasisType 1
KEY DerivativeContrSpecification DerivativeContrSpecification 1
KEY MarketIdentifierCode MarketIdentifierCode 1
KEY PlannedDeliveryEndDate PlannedDeliveryEndDate 1
KEY PlannedDeliveryStartDate PlannedDeliveryStartDate 1
KEY PriceQuotationDate PriceQuotationDate 1
KEY PriceQuotationTime PriceQuotationTime 1
KEY PriceQuotationType PriceQuotationType 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_BASISPRICEQUOTATION (
    BASISID,
    BASISTYPE,
    DERIVATIVECONTRSPECIFICATION,
    MARKETIDENTIFIERCODE,
    PLANNEDDELIVERYENDDATE,
    PLANNEDDELIVERYSTARTDATE,
    PRICEQUOTATIONDATE,
    PRICEQUOTATIONTIME,
    PRICEQUOTATIONTYPE,
    PRIMARY KEY (BASISID, BASISTYPE, DERIVATIVECONTRSPECIFICATION, MARKETIDENTIFIERCODE, PLANNEDDELIVERYENDDATE, PLANNEDDELIVERYSTARTDATE, PRICEQUOTATIONDATE, PRICEQUOTATIONTIME, PRICEQUOTATIONTYPE)
);