I_NearbyMaturityKeyDate

DDL: I_NEARBYMATURITYKEYDATE Type: view BASIC
9 Fields 1 Data Sources

Nearby Maturity Key Date

I_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 9 fields with key fields DerivativeContrSpecification, DCSPeriodType, MaturitySelectionType, MaturitySelectionRoutine, CmmdtyForwardIndexTiming.

Data Sources (1)

SourceAliasJoin Type
cmm_nb_keydate cmm_nb_keydate from

Annotations (9)

NameValueLevelField
EndUserText.label Nearby Maturity Key Date view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName INEARBYMKD view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (9)

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 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 I_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 I_NearbyMaturityKeyDate AS
SELECT
  dcsid AS DerivativeContrSpecification,
  period_type AS DCSPeriodType,
  dcs_selection_type AS MaturitySelectionType,
  keydate_selection_rout AS MaturitySelectionRoutine,
  timing AS CmmdtyForwardIndexTiming,
  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