C_REContractRenewalTermTP

DDL: C_RECONTRACTRENEWALTERMTP Type: view_entity CONSUMPTION
19 Fields 1 Data Sources 1 Associations

RE Contract Renewal Term

C_REContractRenewalTermTP is a Consumption CDS View that provides data about "RE Contract Renewal Term" in SAP S/4HANA. It reads from 1 data source (R_REContrRenewalTermTP) and exposes 19 fields with key fields InternalRealEstateNumber, RETermType, RETermNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_REContrRenewalTermTP R_REContrRenewalTermTP projection

Associations (1)

CardinalityTargetAliasCondition
[1..*] C_RERenewalSimulation _RERenewalSimulation $projection.InternalRealEstateNumber = _RERenewalSimulation.InternalRealEstateNumber and $projection.RETermType = _RERenewalSimulation.RETermType and $projection.RETermNumber = _RERenewalSimulation.RETermNumber and $projection.RERenewalType = _RERenewalSimulation.RERenewalType

Annotations (7)

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

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
KEY RETermType RETermType Term Category
KEY RETermNumber RETermNumber Number
RERenewalType RERenewalType
RealEstateObjectType RealEstateObjectType Object Type
RETermName RETermName Name of Term
REStatusObject _REContract REStatusObject Val. Obj. No.
REIdentificationKey _REContract REIdentificationKey Object ID
RERenewalRule RERenewalRule
REAutomaticRenewalType REAutomaticRenewalType
RETermTypeNameasRETermTypeNamelocalized
virtualRERenewalRuleIsHiddenabap_boolean
virtualIsDraftEntityrecabool
virtualNoteUUIDbobfconf_key
virtualNoteObjectnte_objectid
_RERenewalType _RERenewalType
_RERenewalRule _RERenewalRule
_RETermType _RETermType
_RERenewalSimulation _RERenewalSimulation

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_REContractRenewalTermTP.
-- 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_REContractRenewalTermTP AS
SELECT
  InternalRealEstateNumber,
  RETermType,
  RETermNumber,
  RERenewalType,
  RealEstateObjectType,
  RETermName,
  _REContract.REStatusObject AS REStatusObject,
  _REContract.REIdentificationKey AS REIdentificationKey,
  RERenewalRule,
  REAutomaticRenewalType,
  _RETermType._Text.RETermTypeName as RETermTypeName : localized AS RETermTypeNameasRETermTypeNamelocalized,
  virtual RERenewalRuleIsHidden : abap_boolean AS virtualRERenewalRuleIsHiddenabap_boolean,
  virtual IsDraftEntity : recabool AS virtualIsDraftEntityrecabool,
  virtual NoteUUID : /bobf/conf_key AS virtualNoteUUIDbobfconf_key,
  virtual NoteObject : nte_objectid AS virtualNoteObjectnte_objectid
FROM R_REContrRenewalTermTP
LEFT OUTER JOIN C_RERenewalSimulation AS _RERenewalSimulation ON InternalRealEstateNumber = _RERenewalSimulation.InternalRealEstateNumber AND RETermType = _RERenewalSimulation.RETermType AND RETermNumber = _RERenewalSimulation.RETermNumber AND RERenewalType = _RERenewalSimulation.RERenewalType  -- association [1..*]
;

Learn More