R_REContractNoticeTP

DDL: R_RECONTRACTNOTICETP Type: view_entity TRANSACTIONAL
26 Fields 1 Data Sources

Real Estate Contract Notice - TP

R_REContractNoticeTP is a Transactional CDS View that provides data about "Real Estate Contract Notice - TP" in SAP S/4HANA. It reads from 1 data source (I_REContractNotice) and exposes 26 fields with key fields InternalRealEstateNumber, RENoticeNumber.

Data Sources (1)

SourceAliasJoin Type
I_REContractNotice I_REContractNotice from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey InternalRealEstateNumber view
Analytics.technicalName RRECNNOTICE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Real Estate Contract Notice - TP view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
KEY RENoticeNumber RENoticeNumber Sequence no.
LastChangeDate LastChangeDate Time Stamp
REContractNoticeCategory REContractNoticeCategory Subj. of Notice
REContractNoticePerDate REContractNoticePerDate Notice Per
REContractNoticeReason REContractNoticeReason Notice Reason
REContrNoticeRejectionReason REContrNoticeRejectionReason Rejection Reas.
REIsExtraordinaryNotice REIsExtraordinaryNotice Extraord.Reason
REContractNoticeParty REContractNoticeParty Notice Given By
REContractNoticeIsActive REContractNoticeIsActive Notice Active
REContractNoticeActivationDate REContractNoticeActivationDate Notice Activ.On
REContractNoticeReversionDate REContractNoticeReversionDate Reversed on
REContractNoticeReceptionDate REContractNoticeReceptionDate Entry Date
REContractNoticeObjectionDate REContractNoticeObjectionDate Object. on
REContrNtcRequestIsConsidered REContrNtcRequestIsConsidered Consid.Request
REContractNoticeRequestDate REContractNoticeRequestDate Notice req. on
REContractNoticeApprovalDate REContractNoticeApprovalDate Approved on
REContractNoticeRejectionDate REContractNoticeRejectionDate Rejected on
REContrNtcLegalDepartmentDate REContrNtcLegalDepartmentDate Legal dept. on
REContractNoticeWithdrawalDate REContractNoticeWithdrawalDate Withdrawal on
REContrNtcFllwUpPostingDueDate REContrNtcFllwUpPostingDueDate FollPost. Due
_REContract _REContract
_RENoticeReason _RENoticeReason
_RENoticeCategory _RENoticeCategory
_RENoticeParty _RENoticeParty
_RENoticeRejectionReason _RENoticeRejectionReason

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_REContractNoticeTP.
-- 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_REContractNoticeTP AS
SELECT
  InternalRealEstateNumber,
  RENoticeNumber,
  LastChangeDate,
  REContractNoticeCategory,
  REContractNoticePerDate,
  REContractNoticeReason,
  REContrNoticeRejectionReason,
  REIsExtraordinaryNotice,
  REContractNoticeParty,
  REContractNoticeIsActive,
  REContractNoticeActivationDate,
  REContractNoticeReversionDate,
  REContractNoticeReceptionDate,
  REContractNoticeObjectionDate,
  REContrNtcRequestIsConsidered,
  REContractNoticeRequestDate,
  REContractNoticeApprovalDate,
  REContractNoticeRejectionDate,
  REContrNtcLegalDepartmentDate,
  REContractNoticeWithdrawalDate,
  REContrNtcFllwUpPostingDueDate
FROM I_REContractNotice
;

Learn More