R_REContrRenewalTermAndRulesTP

DDL: R_RECONTRRENEWALTERMANDRULESTP Type: view_entity TRANSACTIONAL Package: RAP_RE_CN
31 Fields 1 Data Sources

Real Estate Renewal Term and Rules TP

R_REContrRenewalTermAndRulesTP is a Transactional CDS View that provides data about "Real Estate Renewal Term and Rules TP" in SAP S/4HANA. It reads from 1 data source (I_RERenewalTerm) and exposes 31 fields with key fields InternalRealEstateNumber, RETermType, RETermNumber, RERenewalType, RERenewalSequenceNumber. Part of development package RAP_RE_CN.

Data Sources (1)

SourceAliasJoin Type
I_RERenewalTerm _RERenewalTerm from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Real Estate Renewal Term and Rules TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey RETermNumber view
Analytics.technicalName RRECNRNWLTRMRLTP view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
KEY RETermType RETermType Term Category
KEY RETermNumber RETermNumber Number
KEY RERenewalType
KEY RERenewalSequenceNumber
KEY RERenewalRuleType
RealEstateObjectType RealEstateObjectType Object Type
RETermName RETermName Name of Term
REStatusObject _REContract REStatusObject Val. Obj. No.
REIdentificationKey _REContract REIdentificationKey Object ID
RERenewalRule
REAutomaticRenewalType
RENumberOfRenewals
RERenewalPeriodInYears
RERenewalPeriodInMonths
RERenewalPeriodInDays
RERenewalRoundingDateRule
RENotificationPeriodInYears
RENotificationPeriodInMonths
RENotificationPeriodInWeeks
RENotificationPeriodInDays
RENotificationRoundingDateRule
_RERenewalType
_RERenewalRule _REMergedRenewalRule _RERenewalRule
_RERenewalDateRoundingRule _REMergedRenewalRule _RERenewalDateRoundingRule
_RENotificationDateRndngRule _REMergedRenewalRule _RENotificationDateRndngRule
_RERenewalRuleType _REMergedRenewalRule _RERenewalRuleType
_REMergedRenewalRule I_RERenewalTerm _REMergedRenewalRule
_RERenewalTerm _RERenewalTerm
_RETermType _RETermType
_REContract _REContract

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_REContrRenewalTermAndRulesTP.
-- 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_REContrRenewalTermAndRulesTP AS
SELECT
  InternalRealEstateNumber,
  RETermType,
  RETermNumber,
  _RERenewalTerm._REMergedRenewalRule.RERenewalType AS RERenewalType,
  _RERenewalTerm._REMergedRenewalRule.RERenewalSequenceNumber AS RERenewalSequenceNumber,
  _RERenewalTerm._REMergedRenewalRule.RERenewalRuleType AS RERenewalRuleType,
  RealEstateObjectType,
  RETermName,
  _REContract.REStatusObject AS REStatusObject,
  _REContract.REIdentificationKey AS REIdentificationKey,
  _RERenewalTerm._REMergedRenewalRule.RERenewalRule AS RERenewalRule,
  _RERenewalTerm._REMergedRenewalRule.REAutomaticRenewalType AS REAutomaticRenewalType,
  _RERenewalTerm._REMergedRenewalRule.RENumberOfRenewals AS RENumberOfRenewals,
  _RERenewalTerm._REMergedRenewalRule.RERenewalPeriodInYears AS RERenewalPeriodInYears,
  _RERenewalTerm._REMergedRenewalRule.RERenewalPeriodInMonths AS RERenewalPeriodInMonths,
  _RERenewalTerm._REMergedRenewalRule.RERenewalPeriodInDays AS RERenewalPeriodInDays,
  _RERenewalTerm._REMergedRenewalRule.RERenewalRoundingDateRule AS RERenewalRoundingDateRule,
  _RERenewalTerm._REMergedRenewalRule.RENotificationPeriodInYears AS RENotificationPeriodInYears,
  _RERenewalTerm._REMergedRenewalRule.RENotificationPeriodInMonths AS RENotificationPeriodInMonths,
  _RERenewalTerm._REMergedRenewalRule.RENotificationPeriodInWeeks AS RENotificationPeriodInWeeks,
  _RERenewalTerm._REMergedRenewalRule.RENotificationPeriodInDays AS RENotificationPeriodInDays,
  _RERenewalTerm._REMergedRenewalRule.RENotificationRoundingDateRule AS RENotificationRoundingDateRule,
  _RERenewalTerm._REMergedRenewalRule._RERenewalType AS _RERenewalType,
  _REMergedRenewalRule._RERenewalRule AS _RERenewalRule,
  _REMergedRenewalRule._RERenewalDateRoundingRule AS _RERenewalDateRoundingRule,
  _REMergedRenewalRule._RENotificationDateRndngRule AS _RENotificationDateRndngRule,
  _REMergedRenewalRule._RERenewalRuleType AS _RERenewalRuleType,
  _RERenewalTerm._REMergedRenewalRule AS _REMergedRenewalRule
FROM I_RERenewalTerm AS _RERenewalTerm
;

Learn More