R_REContrValuationDraft

DDL: R_RECONTRVALUATIONDRAFT Type: view_entity BASIC Package: RAP_RE_CN
52 Fields 1 Data Sources

Real Estate Valuation Term Draft

R_REContrValuationDraft is a Basic CDS View that provides data about "Real Estate Valuation Term Draft" in SAP S/4HANA. It reads from 1 data source (vicerule_d) and exposes 52 fields with key fields InternalRealEstateNumber, RETermNumber, ValidityStartEndDateValue, DraftUUID. Part of development package RAP_RE_CN.

Data Sources (1)

SourceAliasJoin Type
vicerule_d vicerule_d from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Real Estate Valuation Term Draft view
ObjectModel.representativeKey RETermNumber view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber internalrealestatenumber RE Key
KEY RETermNumber retermnumber Number
KEY ValidityStartEndDateValue validitystartenddatevalue Validity Period
KEY DraftUUID draftuuid UUID
ParentDraftUUID parentdraftuuid NodeID
RETermType retermtype Term Category
RETermName retermname Name of Term
REValuationRuleUUID revaluationruleuuid Val. Rule
REValuationRule revaluationrule Valuation Rule
ValidityStartDate validitystartdate Validity Start Date
ValidityEndDate validityenddate ValidTo
REStatusObject restatusobject Val. Obj. No.
RealEstateObjectType realestateobjecttype Object Type
ObjectValidFrom objectvalidfrom Relation Valid From
REConsiderationStartDate reconsiderationstartdate Start of Consideration
RECashFlowPostingFromDate recashflowpostingfromdate First Posting From
REStatusObjectAsset restatusobjectasset Asset Number
REValuationClassification revaluationclassification Classification
REInterestRate reinterestrate Interest Rate
REFrequencyTerm refrequencyterm Frequency Term
REDistributionRule redistributionrule Distrib. Form.
REDistributionRuleParam1 redistributionruleparam1 Dist.Form.Param
REDistributionRuleParam2 redistributionruleparam2 Dist.Form.Param
REProbableEndDate reprobableenddate Probable End
REAssetRightOfUseEndDate reassetrightofuseenddate Usage End RoU
REValuationRuleStatus revaluationrulestatus Rule Status
REValuationStatus revaluationstatus Valuation Status
REValuationStatusReason revaluationstatusreason Reason for Stat.
REValuationBehavior revaluationbehavior Val. Behavior
RETaxType retaxtype Tax Type
TaxGroup taxgroup Tax Group
REAccountingObject reaccountingobject Object Number Account Assignment
REAccountingObjectType reaccountingobjecttype Object Type
REInfoText reinfotext Note
REValuationCurrency revaluationcurrency Valuation Currency
REValuationQuestionnaireUUID revaluationquestionnaireuuid Questionnaire
Country country Venue: Ctry/Reg
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes
REValuationFactorNumerator revaluationfactornumerator Numer. Factor
REValuationFactorDenominator revaluationfactordenominator Den. Factor
REEntryValidity reentryvalidity Entry Validity
REEntryValidityCriticality reentryvaliditycriticality
REIdentification reidentification Object
REAccountingObjIdentification reaccountingobjidentification Accounting Object ID
MasterFixedAsset masterfixedasset Fixed Asset
FixedAsset fixedasset Sub-number
_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_REContrValuationDraft.
-- 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_REContrValuationDraft AS
SELECT
  InternalRealEstateNumber,
  RETermNumber,
  ValidityStartEndDateValue,
  DraftUUID,
  ParentDraftUUID,
  RETermType,
  RETermName,
  REValuationRuleUUID,
  REValuationRule,
  ValidityStartDate,
  ValidityEndDate,
  REStatusObject,
  RealEstateObjectType,
  ObjectValidFrom,
  REConsiderationStartDate,
  RECashFlowPostingFromDate,
  REStatusObjectAsset,
  REValuationClassification,
  REInterestRate,
  REFrequencyTerm,
  REDistributionRule,
  REDistributionRuleParam1,
  REDistributionRuleParam2,
  REProbableEndDate,
  REAssetRightOfUseEndDate,
  REValuationRuleStatus,
  REValuationStatus,
  REValuationStatusReason,
  REValuationBehavior,
  RETaxType,
  TaxGroup,
  REAccountingObject,
  REAccountingObjectType,
  REInfoText,
  REValuationCurrency,
  REValuationQuestionnaireUUID,
  Country,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges,
  REValuationFactorNumerator,
  REValuationFactorDenominator,
  REEntryValidity,
  REEntryValidityCriticality,
  REIdentification,
  REAccountingObjIdentification,
  MasterFixedAsset,
  FixedAsset
FROM vicerule_d
;

Learn More