P_NearbyMaturityKeyDate

DDL: P_NEARBYMATURITYKEYDATE Type: view_entity BASIC
10 Fields 1 Data Sources

Nearby Maturity Key Date

P_NearbyMaturityKeyDate is a Basic CDS View that provides data about "Nearby Maturity Key Date" in SAP S/4HANA. It reads from 1 data source (cmm_nb_keydate) and exposes 10 fields with key fields DerivativeContrSpecification, DCSPeriodType, MaturitySelectionType, MaturitySelectionRoutine, CmmdtyForwardIndexTiming.

Data Sources (1)

SourceAliasJoin Type
cmm_nb_keydate cmm_nb_keydate from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Nearby Maturity Key Date view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY DerivativeContrSpecification dcsid DCSID
KEY DCSPeriodType period_type Repeat Appmt Type
KEY MaturitySelectionType dcs_selection_type Maturity Sel. Type
KEY MaturitySelectionRoutine keydate_selection_rout Maturity Sel. Rt.
KEY CmmdtyForwardIndexTiming timing Timing
KEY TimeToMaturity tenor Time to Maturity
KEY NearbyMaturityStartDate Validity Start Time
NearbyMaturityEndDate Validity End Time
NearbyMaturityKeyDate Maturity Key Date
NearbyMarketDataAccessKey instrument Differentiator

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_NearbyMaturityKeyDate.
-- 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.

CREATE VIEW P_NearbyMaturityKeyDate AS
SELECT
  dcsid AS DerivativeContrSpecification,
  period_type AS DCSPeriodType,
  dcs_selection_type AS MaturitySelectionType,
  keydate_selection_rout AS MaturitySelectionRoutine,
  timing AS CmmdtyForwardIndexTiming,
  tenor AS TimeToMaturity,
  cast(valid_from as cds_nearby_maturity_start_date) AS NearbyMaturityStartDate,
  cast(valid_to as cds_nearby_maturity_end_date) AS NearbyMaturityEndDate,
  cast(keydate as cds_nearby_maturity_key_date) AS NearbyMaturityKeyDate,
  instrument AS NearbyMarketDataAccessKey
FROM cmm_nb_keydate
;

Learn More