I_REValuationTermCockpitApp

DDL: I_REVALUATIONTERMCOCKPITAPP SQL: IREVALUATIONAPP Type: view BASIC Package: VDM_RE_CE
9 Fields 1 Data Sources 3 Associations

Real Estate Valuation Term Cockpit App

I_REValuationTermCockpitApp is a Basic CDS View that provides data about "Real Estate Valuation Term Cockpit App" in SAP S/4HANA. It reads from 1 data source (P_REValuationRule) and exposes 9 fields with key fields InternalRealEstateNumber, REValuationRuleUUID. It has 3 associations to related views. Part of development package VDM_RE_CE.

Data Sources (1)

SourceAliasJoin Type
P_REValuationRule _ValuationTerm from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_REValuationStatus _ValuationStatus $projection.REValuationStatus = _ValuationStatus.REValuationStatus
[0..1] I_REValuationRuleStatus _ValuationRuleStatus $projection.REValuationRuleStatus = _ValuationRuleStatus.REValuationRuleStatus
[0..1] I_REValuationRule _REValuationRule $projection.REValuationRule = _REValuationRule.REValuationRule

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IREVALUATIONAPP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Real Estate Valuation Term Cockpit App view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
ObjectModel.representativeKey REValuationRuleUUID view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
KEY REValuationRuleUUID REValuationRuleUUID Val. Rule
REValuationRule REValuationRule Valuation Rule
REValuationRuleStatus REValuationRuleStatus Rule Status
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
_ValuationStatus _ValuationStatus
_ValuationRuleStatus _ValuationRuleStatus
_REValuationRule _REValuationRule

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 I_REValuationTermCockpitApp.
-- 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.
-- SQL view name: IREVALUATIONAPP

CREATE VIEW I_REValuationTermCockpitApp AS
SELECT
  InternalRealEstateNumber,
  REValuationRuleUUID,
  REValuationRule,
  REValuationRuleStatus,
  ValidityStartDate,
  ValidityEndDate
FROM P_REValuationRule AS _ValuationTerm
LEFT OUTER JOIN I_REValuationStatus AS _ValuationStatus ON REValuationStatus = _ValuationStatus.REValuationStatus  -- association [0..1]
LEFT OUTER JOIN I_REValuationRuleStatus AS _ValuationRuleStatus ON REValuationRuleStatus = _ValuationRuleStatus.REValuationRuleStatus  -- association [0..1]
LEFT OUTER JOIN I_REValuationRule AS _REValuationRule ON REValuationRule = _REValuationRule.REValuationRule  -- association [0..1]
;

Learn More