C_REContractReminderDateTP

DDL: C_RECONTRACTREMINDERDATETP Type: view_entity CONSUMPTION

RE Contract Reminder Date

C_REContractReminderDateTP is a Consumption CDS View that provides data about "RE Contract Reminder Date" in SAP S/4HANA. It reads from 1 data source (R_REContrReminderDateTP) and exposes 32 fields with key fields InternalRealEstateNumber, REReminderNumber, REReminderDate.

Data Sources (1)

SourceAliasJoin Type
R_REContrReminderDateTP R_REContrReminderDateTP projection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view
EndUserText.label RE Contract Reminder Date view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
KEY REReminderNumber REReminderNumber ID
KEY REReminderDate REReminderDate
REReminderUUID REReminderUUID
REReminderRule REReminderRule
REReminderReason REReminderReason
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CreationDateTime CreationDateTime Timestamp
RESourceOfCreation RESourceOfCreation Source.In.Entry
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
LastChangeDateTime LastChangeDateTime Timestamp
RESourceOfChange RESourceOfChange Editing Source
Responsible Responsible User Name
REReminderWrkflwDate REReminderWrkflwDate
REReminderIsDone REReminderIsDone
REReminderIsFix REReminderIsFix
REReminderIsWrkflwSend REReminderIsWrkflwSend
TextObjectKey TextObjectKey Text Name
REReminderInfoText REReminderInfoText
REEntryValidityCriticality REEntryValidityCriticality
REReminderNumberOfDaysLeft REReminderNumberOfDaysLeft
virtualNoteUUIDbobfconf_key
virtualNoteObjectnte_objectid
_ChangedByUser _ChangedByUser
_CreatedByUser _CreatedByUser
_REReminderReason _REReminderReason
_REReminderRule _REReminderRule
_ResponsibleUser _ResponsibleUser

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 C_REContractReminderDateTP.
-- 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 C_REContractReminderDateTP AS
SELECT
  InternalRealEstateNumber,
  REReminderNumber,
  REReminderDate,
  REReminderUUID,
  REReminderRule,
  REReminderReason,
  CreatedByUser,
  CreationDate,
  CreationTime,
  CreationDateTime,
  RESourceOfCreation,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  LastChangeDateTime,
  RESourceOfChange,
  Responsible,
  REReminderWrkflwDate,
  REReminderIsDone,
  REReminderIsFix,
  REReminderIsWrkflwSend,
  TextObjectKey,
  REReminderInfoText,
  REEntryValidityCriticality,
  REReminderNumberOfDaysLeft,
  virtual NoteUUID : /bobf/conf_key AS virtualNoteUUIDbobfconf_key,
  virtual NoteObject : nte_objectid AS virtualNoteObjectnte_objectid
FROM R_REContrReminderDateTP
;