C_REContractConditionTP

DDL: C_RECONTRACTCONDITIONTP Type: view_entity CONSUMPTION Package: ODATA_RE_CONTRACT_APP
76 Fields 1 Data Sources 2 Associations 1 OData Services 1 Fiori Apps

RE Contract Condition

C_REContractConditionTP is a Consumption CDS View that provides data about "RE Contract Condition" in SAP S/4HANA. It reads from 1 data source (R_REContrConditionTP) and exposes 76 fields with key fields REConditionUUID, InternalRealEstateNumber. It has 2 associations to related views. It is exposed through 1 OData service (UI_RECONTRACT). It is used in 1 Fiori application: Contract Management. Part of development package ODATA_RE_CONTRACT_APP.

Data Sources (1)

SourceAliasJoin Type
R_REContrConditionTP R_REContrConditionTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_REContractConditionCalc _REContractConditionCalc $projection.REConditionUUID = _REContractConditionCalc.REConditionUUID
[0..*] C_REContractConditionDistr _REContractConditionDistr $projection.REConditionUUID = _REContractConditionDistr.REConditionUUID

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 Condition view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_RECONTRACT UI_RECONTRACT V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5273 Contract Management Transactional This Fiori App allows customers to manage and maintain their Real Estate Contracts. Through the App customers get the ability to easily understand their contracts and liabilities.

Contract Management

Business Role: Contract Specialist - Leasing

The term section of the contract has been restructured. It now includes subsections for dates, renewal terms, and notice terms to ease navigation inside the contract.

Fields (76)

KeyFieldSource TableSource FieldDescription
KEY REConditionUUID REConditionUUID
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
REStatusObjectCalculation REStatusObjectCalculation
REStatusObjectIDCalculation REStatusObjectIDCalculation
REStatusObjectTypeCalculation REStatusObjectTypeCalculation
REConditionType REConditionType
REExtConditionPurpose REExtConditionPurpose
ValidityStartEndDateValue ValidityStartEndDateValue Validity Period
ValidityStartDate ValidityStartDate Validity Start Date
REStatusObjectDistribution REStatusObjectDistribution
REStatusObjectIDDistribution REStatusObjectIDDistribution
REObjectTypeDistribution REObjectTypeDistribution
REObjectTypePosting REObjectTypePosting
ValidityEndDate ValidityEndDate ValidTo
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
RESourceOfCreation RESourceOfCreation Source.In.Entry
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
RESourceOfChange RESourceOfChange Editing Source
REIsOneTimeCondition REIsOneTimeCondition
REConditionIsStatistical REConditionIsStatistical
REPostingTerm REPostingTerm
RERhythmTerm RERhythmTerm
REAdjustmentNumber REAdjustmentNumber
REOrglAssignmentTerm REOrglAssignmentTerm
RESalesTerm RESalesTerm
REPeakSalesTerm REPeakSalesTerm
RESrvcChrgSettlementPostingTrm RESrvcChrgSettlementPostingTrm
REWithholdingTaxTerm REWithholdingTaxTerm
RECalculationRule RECalculationRule
REUnitPrice REUnitPrice
REConditionCurrency REConditionCurrency
RECalculationRuleParam1 RECalculationRuleParam1
REMeasurementTypeForEdit REMeasurementTypeForEdit
RECalculationRuleParam2 RECalculationRuleParam2
REMeasurementUnitForEdit REMeasurementUnitForEdit
REDistributionRule REDistributionRule Distrib. Form.
REDistributionRuleParam1 REDistributionRuleParam1 Distribution Formula Parameter 1
REDistributionRuleParam2 REDistributionRuleParam2 Distribution Formula Parameter 2
REReasonForChange REReasonForChange
REStsObjectParamCalculation REStsObjectParamCalculation
REStsObjectParamDistribution REStsObjectParamDistribution
RECashFlowPostingFromDate RECashFlowPostingFromDate First Posting From
REConditionExceptionalDueDate REConditionExceptionalDueDate
REEntryValidity REEntryValidity Entry Validity
REEntryValidityCriticality REEntryValidityCriticality
REConditionGroup
REContractType _REContract REContractType Contract Type
CompanyCode _REContract CompanyCode Receiver Company Code
RealEstateContract _REContract RealEstateContract Real Estate Contract
REPostingTermType REPostingTermType
REOrglAssgmtTermType REOrglAssgmtTermType
RERhythmTermType RERhythmTermType
REPostingTermName _REContrCndnSelPostingTerm RETermName Name of Term
RERhythmTermName _REContrCndnSelRhythmTerm RETermName Name of Term
REOrglAssgmtTermName _REContrCndnSelOrglAssgmtTerm RETermName Name of Term
REPostingTermPlaceholderName _REContrCndnSelPostingTerm RETermName Name of Term
RERhythmTermPlaceholderName _REContrCndnSelRhythmTerm RETermName Name of Term
REOrglAssTermPlaceholderName _REContrCndnSelOrglAssgmtTerm RETermName Name of Term
CurrencyNameasCurrencyNamelocalized
virtualIsDraftEntityrecabool
virtualNoteUUIDbobfconf_key
virtualNoteObjectnte_objectid
_Currency _Currency
_CreatedByUser _CreatedByUser
_ChangedByUser _ChangedByUser
_REConditionType _REConditionType
_REConditionPurposeExt _REConditionPurposeExt
_REObjectTypeDistribution _REObjectTypeDistribution
_REObjectTypePosting _REObjectTypePosting
_RECndnCalculationRuleExt _RECndnCalculationRuleExt
_RECndnDistributionRuleExt _RECndnDistributionRuleExt
_REConditionChangeReason _REConditionChangeReason
_REContractConditionCalc _REContractConditionCalc
_REContractConditionDistr _REContractConditionDistr

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_REContractConditionTP.
-- 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_REContractConditionTP AS
SELECT
  REConditionUUID,
  InternalRealEstateNumber,
  REStatusObjectCalculation,
  REStatusObjectIDCalculation,
  REStatusObjectTypeCalculation,
  REConditionType,
  REExtConditionPurpose,
  ValidityStartEndDateValue,
  ValidityStartDate,
  REStatusObjectDistribution,
  REStatusObjectIDDistribution,
  REObjectTypeDistribution,
  REObjectTypePosting,
  ValidityEndDate,
  CreatedByUser,
  CreationDateTime,
  RESourceOfCreation,
  LastChangedByUser,
  LastChangeDateTime,
  RESourceOfChange,
  REIsOneTimeCondition,
  REConditionIsStatistical,
  REPostingTerm,
  RERhythmTerm,
  REAdjustmentNumber,
  REOrglAssignmentTerm,
  RESalesTerm,
  REPeakSalesTerm,
  RESrvcChrgSettlementPostingTrm,
  REWithholdingTaxTerm,
  RECalculationRule,
  REUnitPrice,
  REConditionCurrency,
  RECalculationRuleParam1,
  REMeasurementTypeForEdit,
  RECalculationRuleParam2,
  REMeasurementUnitForEdit,
  REDistributionRule,
  REDistributionRuleParam1,
  REDistributionRuleParam2,
  REReasonForChange,
  REStsObjectParamCalculation,
  REStsObjectParamDistribution,
  RECashFlowPostingFromDate,
  REConditionExceptionalDueDate,
  REEntryValidity,
  REEntryValidityCriticality,
  _REContract._REContractType.REConditionGroup AS REConditionGroup,
  _REContract.REContractType AS REContractType,
  _REContract.CompanyCode AS CompanyCode,
  _REContract.RealEstateContract AS RealEstateContract,
  REPostingTermType,
  REOrglAssgmtTermType,
  RERhythmTermType,
  _REContrCndnSelPostingTerm.RETermName AS REPostingTermName,
  _REContrCndnSelRhythmTerm.RETermName AS RERhythmTermName,
  _REContrCndnSelOrglAssgmtTerm.RETermName AS REOrglAssgmtTermName,
  _REContrCndnSelPostingTerm.RETermName AS REPostingTermPlaceholderName,
  _REContrCndnSelRhythmTerm.RETermName AS RERhythmTermPlaceholderName,
  _REContrCndnSelOrglAssgmtTerm.RETermName AS REOrglAssTermPlaceholderName,
  _Currency._Text.CurrencyName as CurrencyName : localized AS CurrencyNameasCurrencyNamelocalized,
  virtual IsDraftEntity : recabool AS virtualIsDraftEntityrecabool,
  virtual NoteUUID : /bobf/conf_key AS virtualNoteUUIDbobfconf_key,
  virtual NoteObject : nte_objectid AS virtualNoteObjectnte_objectid
FROM R_REContrConditionTP
LEFT OUTER JOIN C_REContractConditionCalc AS _REContractConditionCalc ON REConditionUUID = _REContractConditionCalc.REConditionUUID  -- association [0..*]
LEFT OUTER JOIN C_REContractConditionDistr AS _REContractConditionDistr ON REConditionUUID = _REContractConditionDistr.REConditionUUID  -- association [0..*]
;

Learn More