C_ManageSeason

DDL: C_MANAGESEASON Type: view_entity CONSUMPTION
29 Fields 1 Data Sources 2 Associations

Manage Seasons

C_ManageSeason is a Consumption CDS View that provides data about "Manage Seasons" in SAP S/4HANA. It reads from 1 data source (R_ManageSeasonTP) and exposes 29 fields with key field ProductSeasonInternalUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_ManageSeasonTP R_ManageSeasonTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..1] C_ManageSeason _Parent $projection.ProductSeasonInternalUUID = _Parent.ProductSeasonInternalUUID
[0..*] C_ProductSeason _SeasonProduct $projection.ProductSeasonYear = _SeasonProduct.ProductSeasonYear and $projection.ProductSeason = _SeasonProduct.ProductSeason and $projection.ProductCollection = _SeasonProduct.ProductCollection and $projection.ProductTheme = _SeasonProduct.ProductTheme

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey ProductSeasonInternalUUID view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.query.implementedBy ABAP:CL_RFM_SEASON_HIERARCHY_QUERY view
VDM.viewType #CONSUMPTION view
EndUserText.label Manage Seasons view
Metadata.allowExtensions true view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY ProductSeasonInternalUUID ProductSeasonInternalUUID
ProductSeasonYear ProductSeasonYear Season Year
ProductSeason ProductSeason Season
ProductCollection ProductCollection Collection
ProductTheme ProductTheme Theme
ConsolidatedProductSeasonID ConsolidatedProductSeasonID
ConsolidatedSeasonText ConsolidatedSeasonText
ProductSeasonValidFrom ProductSeasonValidFrom Validity From
ProductSeasonValidTo ProductSeasonValidTo Validity To
ProductSeasonText ProductSeasonText
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
CreatedByUserName CreatedByUserName Person Resp.
LastChangedByUserName LastChangedByUserName User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
HierarchyNodeTechnicalID HierarchyNodeTechnicalID
HierarchyParentTechnicalNode HierarchyParentTechnicalNode
HierarchyDistanceFromRoot HierarchyDistanceFromRoot Dist. From Root
HierarchyDescendantCount HierarchyDescendantCount Desc. Count
HierarchyDrillState HierarchyDrillState Drill State
HierarchyNodeOrdinalNumber HierarchyNodeOrdinalNumber Node Number
_CreatedByUser _CreatedByUser
_SeasonProduct _SeasonProduct
_Parent _Parent
_CreatedByUserContactCard _CreatedByUserContactCard
_LastChangedByUserContactCard _LastChangedByUserContactCard

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 C_ManageSeason.
-- 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 C_ManageSeason AS
SELECT
  ProductSeasonInternalUUID,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  ConsolidatedProductSeasonID,
  ConsolidatedSeasonText,
  ProductSeasonValidFrom,
  ProductSeasonValidTo,
  ProductSeasonText,
  CreatedByUser,
  LastChangedByUser,
  CreatedByUserName,
  LastChangedByUserName,
  CreationDate,
  CreationTime,
  LastChangeDate,
  LastChangeTime,
  HierarchyNodeTechnicalID,
  HierarchyParentTechnicalNode,
  HierarchyDistanceFromRoot,
  HierarchyDescendantCount,
  HierarchyDrillState,
  HierarchyNodeOrdinalNumber
FROM R_ManageSeasonTP
LEFT OUTER JOIN C_ManageSeason AS _Parent ON ProductSeasonInternalUUID = _Parent.ProductSeasonInternalUUID  -- association [0..1]
LEFT OUTER JOIN C_ProductSeason AS _SeasonProduct ON ProductSeasonYear = _SeasonProduct.ProductSeasonYear AND ProductSeason = _SeasonProduct.ProductSeason AND ProductCollection = _SeasonProduct.ProductCollection AND ProductTheme = _SeasonProduct.ProductTheme  -- association [0..*]
;

Learn More