R_ManageSeasonTextTP

DDL: R_MANAGESEASONTEXTTP Type: view_entity TRANSACTIONAL
13 Fields 1 Data Sources 1 Associations

Season Text

R_ManageSeasonTextTP is a Transactional CDS View that provides data about "Season Text" in SAP S/4HANA. It reads from 1 data source (I_SeasonBasicText) and exposes 13 fields with key fields ProductSeasonInternalUUID, Language. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SeasonBasicText _SeasonBasicText from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language and $projection.Language = $session.system_language

Annotations (10)

NameValueLevelField
EndUserText.label Season Text view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey ProductSeasonInternalUUID view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name Season view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ProductSeasonInternalUUID SeasonInternalIdentifier Sea Int. Identifier
KEY Language Language Report Text Language
ProductSeasonText ProductSeasonText User Group
LongText LongText Text Name
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
_Language _Language
_ManageSeasonTP _ManageSeasonTP
_Season _Season

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 R_ManageSeasonTextTP.
-- 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 R_ManageSeasonTextTP AS
SELECT
  SeasonInternalIdentifier AS ProductSeasonInternalUUID,
  Language,
  ProductSeasonText,
  LongText,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime
FROM I_SeasonBasicText AS _SeasonBasicText
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language AND Language = $session.system_language  -- association [0..1]
;

Learn More