C_REValnMngConditionTP

DDL: C_REVALNMNGCONDITIONTP Type: view_entity CONSUMPTION
55 Fields 1 Data Sources

Contract Conditions

C_REValnMngConditionTP is a Consumption CDS View that provides data about "Contract Conditions" in SAP S/4HANA. It reads from 1 data source (R_REContrConditionTP) and exposes 55 fields with key fields REConditionUUID, InternalRealEstateNumber.

Data Sources (1)

SourceAliasJoin Type
R_REContrConditionTP R_REContrConditionTP projection

Annotations (7)

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

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY REConditionUUID REConditionUUID
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
REStatusObjectCalculation REStatusObjectCalculation
virtualSemanticObjectchar40
REConditionType REConditionType
REExtConditionPurpose REExtConditionPurpose
ValidityStartEndDateValue ValidityStartEndDateValue Validity Period
ValidityStartDate ValidityStartDate Validity Start Date
REStatusObjectDistribution REStatusObjectDistribution
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
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
REPostingTermName _REContrCndnSelPostingTerm RETermName Name of Term
RERhythmTermType RERhythmTermType
RERhythmTermName _REContrCndnSelRhythmTerm RETermName Name of Term
REOrglAssgmtTermType REOrglAssgmtTermType
REOrglAssgmtTermName _REContrCndnSelOrglAssgmtTerm RETermName Name of Term
CurrencyNameasCurrencyNamelocalized

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_REValnMngConditionTP.
-- 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_REValnMngConditionTP AS
SELECT
  REConditionUUID,
  InternalRealEstateNumber,
  REStatusObjectCalculation,
  virtual SemanticObject : char40 AS virtualSemanticObjectchar40,
  REConditionType,
  REExtConditionPurpose,
  ValidityStartEndDateValue,
  ValidityStartDate,
  REStatusObjectDistribution,
  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,
  REEntryValidity,
  REEntryValidityCriticality,
  _REContract._REContractType.REConditionGroup AS REConditionGroup,
  _REContract.REContractType AS REContractType,
  _REContract.CompanyCode AS CompanyCode,
  _REContract.RealEstateContract AS RealEstateContract,
  REPostingTermType,
  _REContrCndnSelPostingTerm.RETermName AS REPostingTermName,
  RERhythmTermType,
  _REContrCndnSelRhythmTerm.RETermName AS RERhythmTermName,
  REOrglAssgmtTermType,
  _REContrCndnSelOrglAssgmtTerm.RETermName AS REOrglAssgmtTermName,
  _Currency._Text.CurrencyName as CurrencyName : localized AS CurrencyNameasCurrencyNamelocalized
FROM R_REContrConditionTP
;

Learn More