C_REContrRenewalTermRulesTP

DDL: C_RECONTRRENEWALTERMRULESTP Type: view_entity CONSUMPTION

RE Contract Renewal Rules

C_REContrRenewalTermRulesTP is a Consumption CDS View that provides data about "RE Contract Renewal Rules" in SAP S/4HANA. It reads from 1 data source (R_REContrRenewalTermRulesTP) and exposes 26 fields with key fields InternalRealEstateNumber, RETermType, RETermNumber, RERenewalType, RERenewalSequenceNumber.

Data Sources (1)

SourceAliasJoin Type
R_REContrRenewalTermRulesTP R_REContrRenewalTermRulesTP projection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label RE Contract Renewal Rules view
Metadata.allowExtensions true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
KEY RETermType RETermType Term Category
KEY RETermNumber RETermNumber Number
KEY RERenewalType RERenewalType
KEY RERenewalSequenceNumber RERenewalSequenceNumber
KEY RERenewalRuleType RERenewalRuleType
RERenewalSequenceNumberForEdit RERenewalSequenceNumberForEdit
RERenewalRuleTypeForEdit RERenewalRuleTypeForEdit
RERenewalRule RERenewalRule
REAutomaticRenewalType REAutomaticRenewalType
RENumberOfRenewals RENumberOfRenewals
RERenewalPeriodInYears RERenewalPeriodInYears
RERenewalPeriodInMonths RERenewalPeriodInMonths
RERenewalPeriodInDays RERenewalPeriodInDays
RERenewalRoundingDateRule RERenewalRoundingDateRule
RENotificationPeriodInYears RENotificationPeriodInYears
RENotificationPeriodInMonths RENotificationPeriodInMonths
RENotificationPeriodInWeeks RENotificationPeriodInWeeks
RENotificationPeriodInDays RENotificationPeriodInDays
RENotificationRoundingDateRule RENotificationRoundingDateRule
_RERenewalType _RERenewalType
_RERenewalRule _RERenewalRule
_RERenewalDateRoundingRule _RERenewalDateRoundingRule
_RENotificationDateRndngRule _RENotificationDateRndngRule
_RERenewalRuleType _RERenewalRuleType
_REContractredirectedtoC_REContractTP

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_REContrRenewalTermRulesTP.
-- 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_REContrRenewalTermRulesTP AS
SELECT
  InternalRealEstateNumber,
  RETermType,
  RETermNumber,
  RERenewalType,
  RERenewalSequenceNumber,
  RERenewalRuleType,
  RERenewalSequenceNumberForEdit,
  RERenewalRuleTypeForEdit,
  RERenewalRule,
  REAutomaticRenewalType,
  RENumberOfRenewals,
  RERenewalPeriodInYears,
  RERenewalPeriodInMonths,
  RERenewalPeriodInDays,
  RERenewalRoundingDateRule,
  RENotificationPeriodInYears,
  RENotificationPeriodInMonths,
  RENotificationPeriodInWeeks,
  RENotificationPeriodInDays,
  RENotificationRoundingDateRule
FROM R_REContrRenewalTermRulesTP
;