I_RERegistrationEntryMerge

DDL: I_REREGISTRATIONENTRYMERGE SQL: IREREGISTRATMERG Type: view COMPOSITE Package: VDM_RE_CA
54 Fields 2 Data Sources

Real Estate Registration Entry Merge

I_RERegistrationEntryMerge is a Composite CDS View that provides data about "Real Estate Registration Entry Merge" in SAP S/4HANA. It reads from 2 data sources (I_RERegistrationEntry, I_RERegistrationEntryCompleted) and exposes 54 fields with key field RERegistrationUUID. Part of development package VDM_RE_CA.

Data Sources (2)

SourceAliasJoin Type
I_RERegistrationEntry _RERegistrationEntry from
I_RERegistrationEntryCompleted _RERegistrationEntryCompleted union

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IREREGISTRATMERG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Real Estate Registration Entry Merge view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY RERegistrationUUID RERegistrationUUID
REStatusObjectSource REStatusObjectSource Object Number
REStatusObjectTarget REStatusObjectTarget Object Number
TargetInternalRealEstateNumber _REObjectTypeDetailsTarget InternalRealEstateNumber RE Key
RERegistrationReason RERegistrationReason Registr.Reason
RERegistrationState RERegistrationState Object State
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
RERegistrationIntReferenceText RERegistrationIntReferenceText Int. reference
RERegistrationInformationText RERegistrationInformationText Additional Info
Responsible Responsible User Name
RERegistrationPriority RERegistrationPriority Priority
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
IsCompleted
_CreatedByUser _CreatedByUser
_ChangedByUser _ChangedByUser
_ResponsibleUser _ResponsibleUser
_RERegistrationReason _RERegistrationReason
_RERegistrationState _RERegistrationState
_REObjectTypeDetailsSource _REObjectTypeDetailsSource
REStatusObjectSource REStatusObjectSource Object Number
REStatusObjectTarget REStatusObjectTarget Object Number
TargetInternalRealEstateNumber _REObjectTypeDetailsTarget InternalRealEstateNumber RE Key
RERegistrationReason RERegistrationReason Registr.Reason
RERegistrationState RERegistrationState Object State
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
RERegistrationIntReferenceText RERegistrationIntReferenceText Int. reference
RERegistrationInformationText RERegistrationInformationText Additional Info
Responsible Responsible User Name
RERegistrationPriority RERegistrationPriority Priority
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
IsCompleted
_CreatedByUser _CreatedByUser
_ChangedByUser _ChangedByUser
_ResponsibleUser _ResponsibleUser
_RERegistrationReason _RERegistrationReason
_RERegistrationState _RERegistrationState
_REObjectTypeDetailsSource _REObjectTypeDetailsSource
_REObjectTypeDetailsTarget _REObjectTypeDetailsTarget

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_RERegistrationEntryMerge.
-- 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: IREREGISTRATMERG

CREATE VIEW I_RERegistrationEntryMerge AS
SELECT
  RERegistrationUUID,
  REStatusObjectSource,
  REStatusObjectTarget,
  _REObjectTypeDetailsTarget.InternalRealEstateNumber AS TargetInternalRealEstateNumber,
  RERegistrationReason,
  RERegistrationState,
  ValidityStartDate,
  ValidityEndDate,
  RERegistrationIntReferenceText,
  RERegistrationInformationText,
  Responsible,
  RERegistrationPriority,
  CreatedByUser,
  CreationDate,
  CreationTime,
  RESourceOfCreation,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  RESourceOfChange,
  ' ' AS IsCompleted
FROM I_RERegistrationEntry AS _RERegistrationEntry
-- UNION with additional select branch(es): I_RERegistrationEntryCompleted
;

Learn More