P_CmmdtyLogcMatlValnQtanDate

DDL: P_CMMDTYLOGCMATLVALNQTANDATE Type: view_entity COMPOSITE
11 Fields 1 Data Sources

View for Quot. data of Material Val.

P_CmmdtyLogcMatlValnQtanDate is a Composite CDS View that provides data about "View for Quot. data of Material Val." in SAP S/4HANA. It reads from 1 data source (I_VersionedLogcDocument) and exposes 11 fields.

Data Sources (1)

SourceAliasJoin Type
I_VersionedLogcDocument I_VersionedLogcDocument from

Parameters (2)

NameTypeDefault
P_Eval_From cmm_snapshot_start
P_Eval_To cmm_snapshot_end

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label View for Quot. data of Material Val. view

Fields (11)

KeyFieldSource TableSource FieldDescription
bukrs CompanyCode Receiver Company Code
record_type MTMDataSourceType Type of Data Record
matnr Material Vehicle Model
werks Plant Valuation Area
quotgroup QuotationGroup Quotation Group
dcsid DerivativeContrSpecification DCS ID
mic MarketIdentifierCode MIC
pricetype QuotationPriceType Price Type
basis_type BasisType Basis Type
basis_id BasisID Basis ID
curve CommodityCurve Curve

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_CmmdtyLogcMatlValnQtanDate.
-- 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.
-- Parameters: P_Eval_From : cmm_snapshot_start, P_Eval_To : cmm_snapshot_end

CREATE VIEW P_CmmdtyLogcMatlValnQtanDate AS
SELECT
  CompanyCode AS bukrs,
  MTMDataSourceType AS record_type,
  Material AS matnr,
  Plant AS werks,
  QuotationGroup AS quotgroup,
  DerivativeContrSpecification AS dcsid,
  MarketIdentifierCode AS mic,
  QuotationPriceType AS pricetype,
  BasisType AS basis_type,
  BasisID AS basis_id,
  CommodityCurve AS curve
FROM I_VersionedLogcDocument
;

Learn More