A_REContrCondition

DDL: A_RECONTRCONDITION Type: view_entity CONSUMPTION Package: ODATA_RE_CN
40 Fields 1 Data Sources 1 OData Services

Conditions

A_REContrCondition is a Consumption CDS View that provides data about "Conditions" in SAP S/4HANA. It reads from 1 data source (R_REContrConditionTP) and exposes 40 fields with key fields REConditionUUID, InternalRealEstateNumber. It is exposed through 1 OData service (API_RECONTRACT). Part of development package ODATA_RE_CN.

Data Sources (1)

SourceAliasJoin Type
R_REContrConditionTP R_REContrConditionTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Conditions view
OData.entityType.name REContrCondition_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_RECONTRACT API_REAL_ESTATE_CONTRACT V4 C2 C1

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY REConditionUUID REConditionUUID
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
REStatusObjectCalculation REStatusObjectCalculation
REContractSubjectNumber REContractSubjectNumber Contract Object Number
REStatusObjectTypeCalculation REStatusObjectTypeCalculation
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
RECalculationRuleParam2 RECalculationRuleParam2
REDistributionRule REDistributionRule Distrib. Form.
REDistributionRuleParam1 REDistributionRuleParam1 Dist.Form.Param
REDistributionRuleParam2 REDistributionRuleParam2 Dist.Form.Param
REReasonForChange REReasonForChange
REStsObjectParamCalculation REStsObjectParamCalculation
REStsObjectParamDistribution REStsObjectParamDistribution

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 A_REContrCondition.
-- 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 A_REContrCondition AS
SELECT
  REConditionUUID,
  InternalRealEstateNumber,
  REStatusObjectCalculation,
  REContractSubjectNumber,
  REStatusObjectTypeCalculation,
  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,
  RECalculationRuleParam2,
  REDistributionRule,
  REDistributionRuleParam1,
  REDistributionRuleParam2,
  REReasonForChange,
  REStsObjectParamCalculation,
  REStsObjectParamDistribution
FROM R_REContrConditionTP
;

Learn More