R_REContrRegistryEntryTP

DDL: R_RECONTRREGISTRYENTRYTP Type: view_entity TRANSACTIONAL Package: RAP_RE_CN

Real Estate Registry Entry TP

R_REContrRegistryEntryTP is a Transactional CDS View that provides data about "Real Estate Registry Entry TP" in SAP S/4HANA. It reads from 1 data source (I_RERegistrationEntryMerge) and exposes 28 fields with key fields RERegistrationUUID, TargetInternalRealEstateNumber. Part of development package RAP_RE_CN.

Data Sources (1)

SourceAliasJoin Type
I_RERegistrationEntryMerge I_RERegistrationEntryMerge from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Real Estate Registry Entry TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey RERegistrationUUID view
Analytics.technicalName RRECNREGISTRY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY RERegistrationUUID RERegistrationUUID
KEY TargetInternalRealEstateNumber TargetInternalRealEstateNumber RE Key
REStatusObjectSource REStatusObjectSource Object Number
REStatusObjectTarget REStatusObjectTarget Object Number
RERegistrationReason RERegistrationReason
RERegistrationState RERegistrationState
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
RERegistrationIntReferenceText RERegistrationIntReferenceText
RERegistrationInformationText RERegistrationInformationText
Responsible Responsible User Name
RERegistrationPriority RERegistrationPriority
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
RESourceOfCreation RESourceOfCreation Source.In.Entry
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
RESourceOfChange RESourceOfChange Editing Source
_CreatedByUser _CreatedByUser
_ChangedByUser _ChangedByUser
_ResponsibleUser _ResponsibleUser
_RERegistrationReason _RERegistrationReason
_RERegistrationState _RERegistrationState
_REObjectTypeDetailsSource _REObjectTypeDetailsSource
_REObjectTypeDetailsTarget _REObjectTypeDetailsTarget
_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_REContrRegistryEntryTP.
-- 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_REContrRegistryEntryTP AS
SELECT
  RERegistrationUUID,
  TargetInternalRealEstateNumber,
  REStatusObjectSource,
  REStatusObjectTarget,
  RERegistrationReason,
  RERegistrationState,
  ValidityStartDate,
  ValidityEndDate,
  RERegistrationIntReferenceText,
  RERegistrationInformationText,
  Responsible,
  RERegistrationPriority,
  CreatedByUser,
  CreationDate,
  CreationTime,
  RESourceOfCreation,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  RESourceOfChange
FROM I_RERegistrationEntryMerge
;