P_CmmdtyLogcMatlValnMinMaxQtn

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

View for Quot. data of Material Val.

P_CmmdtyLogcMatlValnMinMaxQtn 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 (P_CmmdtyVersLogcMatlValnQtan) and exposes 11 fields.

Data Sources (1)

SourceAliasJoin Type
P_CmmdtyVersLogcMatlValnQtan P_CmmdtyVersLogcMatlValnQtan 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.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M 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 bukrs Value
record_type record_type Type of Data Record
matnr matnr Vehicle Model
werks werks Receiving Plant
quotgroup quotgroup Quotation Group
dcsid dcsid DCSID
mic mic MIC
pricetype pricetype Price Type
basis_type basis_type Basis Type
basis_id basis_id Strategy
curve curve 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_CmmdtyLogcMatlValnMinMaxQtn.
-- 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_CmmdtyLogcMatlValnMinMaxQtn AS
SELECT
  bukrs,
  record_type,
  matnr,
  werks,
  quotgroup,
  dcsid,
  mic,
  pricetype,
  basis_type,
  basis_id,
  curve
FROM P_CmmdtyVersLogcMatlValnQtan
;

Learn More