A_REContrValuationCondition

DDL: A_RECONTRVALUATIONCONDITION Type: view_entity CONSUMPTION
19 Fields 1 Data Sources 1 OData Services

Condition Specific Valuations

A_REContrValuationCondition is a Consumption CDS View that provides data about "Condition Specific Valuations" in SAP S/4HANA. It reads from 1 data source (R_REContrValuationConditionTP) and exposes 19 fields with key fields InternalRealEstateNumber, RETermNumber, ValidityStartEndDateValue, REConditionType, REConditionValidityStartDate. It is exposed through 1 OData service (API_RECONTRACT).

Data Sources (1)

SourceAliasJoin Type
R_REContrValuationConditionTP R_REContrValuationConditionTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Condition Specific Valuations view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name REContrValuationCondition_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_RECONTRACT API_REAL_ESTATE_CONTRACT V4 C2 C1

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
KEY RETermNumber RETermNumber Number
KEY ValidityStartEndDateValue ValidityStartEndDateValue Validity Period
KEY REConditionType REConditionType
KEY REConditionValidityStartDate REConditionValidityStartDate
KEY REExtConditionPurpose REExtConditionPurpose
KEY REStatusObjectCalculation REStatusObjectCalculation
RETermName RETermName Name of Term
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
REConditionValidityEndDate REConditionValidityEndDate
REValuationCndnProperty REValuationCndnProperty
REValuationCndnConsdtn REValuationCndnConsdtn
REIsValuationCndnConsdtn REIsValuationCndnConsdtn
REValuationCndnSharePercent REValuationCndnSharePercent
REValuationCndnShareAbsltAmt REValuationCndnShareAbsltAmt
REValuationCurrency REValuationCurrency Valuation Currency
REValuationCndnStatus REValuationCndnStatus
REInfoText REInfoText Note

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 A_REContrValuationCondition.
-- 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 A_REContrValuationCondition AS
SELECT
  InternalRealEstateNumber,
  RETermNumber,
  ValidityStartEndDateValue,
  REConditionType,
  REConditionValidityStartDate,
  REExtConditionPurpose,
  REStatusObjectCalculation,
  RETermName,
  ValidityStartDate,
  ValidityEndDate,
  REConditionValidityEndDate,
  REValuationCndnProperty,
  REValuationCndnConsdtn,
  REIsValuationCndnConsdtn,
  REValuationCndnSharePercent,
  REValuationCndnShareAbsltAmt,
  REValuationCurrency,
  REValuationCndnStatus,
  REInfoText
FROM R_REContrValuationConditionTP
;

Learn More