R_REContrValuationConditionTP

DDL: R_RECONTRVALUATIONCONDITIONTP Type: view_entity TRANSACTIONAL Package: RAP_RE_CN
32 Fields 1 Data Sources 1 Associations

Real Estate Valuation Condition TP

R_REContrValuationConditionTP is a Transactional CDS View that provides data about "Real Estate Valuation Condition TP" in SAP S/4HANA. It reads from 1 data source (I_REValuationRuleCondition) and exposes 32 fields with key fields InternalRealEstateNumber, RETermNumber, ValidityStartEndDateValue, REConditionType, REConditionValidityStartDate. It has 1 association to related views. Part of development package RAP_RE_CN.

Data Sources (1)

SourceAliasJoin Type
I_REValuationRuleCondition I_REValuationRuleCondition from

Associations (1)

CardinalityTargetAliasCondition
[0..1] R_REContrValuationTP _REContrValuation $projection.InternalRealEstateNumber = _REContrValuation.InternalRealEstateNumber and $projection.retermnumber = _REContrValuation.RETermNumber and $projection.ValidityStartEndDateValue = _REContrValuation.ValidityStartEndDateValue

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Real Estate Valuation Condition TP view
ObjectModel.representativeKey RETermNumber view
Analytics.technicalName RREVALNCNDNTP view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
KEY RETermNumber _REValuationTerm RETermNumber Number
KEY ValidityStartEndDateValue
KEY REConditionType _RECondition REConditionType
KEY REConditionValidityStartDate
KEY REExtConditionPurpose _RECondition REExtConditionPurpose
KEY REStatusObjectCalculation _RECondition REStatusObjectCalculation
REValuationRuleUUID REValuationRuleUUID Val. Rule
REConditionUUID REConditionUUID Condition
REConditionValidityEndDate
RETermName
ValidityStartDate
ValidityEndDate
REValuationCndnProperty REValuationCndnProperty Val. Property
REValuationCndnConsdtn REValuationCndnConsdtn Consideration
REIsValuationCndnConsdtn REIsValuationCndnConsdtn Cons. Condition
REValuationCndnSharePercent REValuationCndnSharePercent Percentage
REValuationCndnShareAbsltAmt REValuationCndnShareAbsltAmt Abs. Share
REValuationCurrency REValuationCurrency Valuation Currency
REValuationCndnStatus REValuationCndnStatus Status C. Rule
REInfoText REInfoText Note
REValuationRule REValuationRule Valuation Rule
_REValuationTerm _REValuationTerm
_RECondition _RECondition
_REConditionType _RECondition _REConditionType
_REConditionPurposeExt _RECondition _REConditionPurposeExt
_REContract _REContract
_REValuationCndnProperty _REValuationCndnProperty
_REValuationCndnConsdtn _REValuationCndnConsdtn
_REValuationCndnStatus _REValuationCndnStatus
_REValuationRule _REValuationRule
_REContrValuation _REContrValuation

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_REContrValuationConditionTP.
-- 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_REContrValuationConditionTP AS
SELECT
  InternalRealEstateNumber,
  _REValuationTerm.RETermNumber AS RETermNumber,
  cast(concat(_REValuationTerm.ValidityStartDate, _REValuationTerm.ValidityEndDate ) as recadateperiod) AS ValidityStartEndDateValue,
  _RECondition.REConditionType AS REConditionType,
  cast(_RECondition.ValidityStartDate as rebdvdmcondvalidfrom preserving type ) AS REConditionValidityStartDate,
  _RECondition.REExtConditionPurpose AS REExtConditionPurpose,
  _RECondition.REStatusObjectCalculation AS REStatusObjectCalculation,
  REValuationRuleUUID,
  REConditionUUID,
  cast( _RECondition.ValidityEndDate as rebdvdmcondvalidto preserving type ) AS REConditionValidityEndDate,
  _REValuationTerm._RETerm.RETermName AS RETermName,
  cast( _REValuationTerm.ValidityStartDate as rebdvdmvalvalidfrom preserving type ) AS ValidityStartDate,
  cast(_REValuationTerm.ValidityEndDate as rebdvdmvalvalidto preserving type ) AS ValidityEndDate,
  REValuationCndnProperty,
  REValuationCndnConsdtn,
  REIsValuationCndnConsdtn,
  REValuationCndnSharePercent,
  REValuationCndnShareAbsltAmt,
  REValuationCurrency,
  REValuationCndnStatus,
  REInfoText,
  REValuationRule,
  _RECondition._REConditionType AS _REConditionType,
  _RECondition._REConditionPurposeExt AS _REConditionPurposeExt
FROM I_REValuationRuleCondition
LEFT OUTER JOIN R_REContrValuationTP AS _REContrValuation ON InternalRealEstateNumber = _REContrValuation.InternalRealEstateNumber AND retermnumber = _REContrValuation.RETermNumber AND ValidityStartEndDateValue = _REContrValuation.ValidityStartEndDateValue  -- association [0..1]
;

Learn More