A_REContrAdjustmentTerm

DDL: A_RECONTRADJUSTMENTTERM Type: view_entity CONSUMPTION Package: ODATA_RE_CN

Adjustment Terms

A_REContrAdjustmentTerm is a Consumption CDS View that provides data about "Adjustment Terms" in SAP S/4HANA. It reads from 1 data source (R_REContrAdjustmentTermTP) and exposes 52 fields with key fields InternalRealEstateNumber, RETermNumber, REAdjustmentRule, REAdjustmentElementaryRule, ValidityStartEndDateValue. It is exposed through 1 OData service (API_RECONTRACT). Part of development package ODATA_RE_CN.

Data Sources (1)

SourceAliasJoin Type
R_REContrAdjustmentTermTP R_REContrAdjustmentTermTP 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
EndUserText.label Adjustment Terms view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name REContrAdjustmentTerm_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_RECONTRACT API_REAL_ESTATE_CONTRACT V4 C2 C1

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
KEY RETermNumber RETermNumber Number
KEY REAdjustmentRule REAdjustmentRule
KEY REAdjustmentElementaryRule REAdjustmentElementaryRule
KEY ValidityStartEndDateValue ValidityStartEndDateValue Validity Period
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
REAdjustmentMethod REAdjustmentMethod
REAdjustmentIsIndivGlobParam REAdjustmentIsIndivGlobParam
REAdjustmentIsIndivSpcfcParam REAdjustmentIsIndivSpcfcParam
RETermName RETermName Name of Term
RealEstateObjectType RealEstateObjectType Object Type
REStatusObject REStatusObject Val. Obj. No.
REIdentificationKey REIdentificationKey Object ID
RERuleIsUsingDefaults RERuleIsUsingDefaults
REIsRuleApprovalRequired REIsRuleApprovalRequired
REIsActvtnWithoutApprvl REIsActvtnWithoutApprvl
REIsDueDateChangeable REIsDueDateChangeable
REAdjustmentPercentPassedValue REAdjustmentPercentPassedValue
REHasRentalObjectIncrease REHasRentalObjectIncrease
REAdjustmentDirection REAdjustmentDirection
REAdjustmentChangeDirection REAdjustmentChangeDirection
REAdjustmentFrequency REAdjustmentFrequency
REFrequencyUnit REFrequencyUnit Frequency Unit
REIsIntervalFromFrqcyStart REIsIntervalFromFrqcyStart
REIsSimulationRule REIsSimulationRule
RERuleHasNoDocument RERuleHasNoDocument
REAdjustmentSubsqntCondition REAdjustmentSubsqntCondition
REAdjustmentIsOnNextNotice REAdjustmentIsOnNextNotice
REAdjustmentBase REAdjustmentBase
REAdjustmentIsAutoDefault REAdjustmentIsAutoDefault
REAdjustmentIsNotifRequired REAdjustmentIsNotifRequired
REAdjustmentIsTimeDependent REAdjustmentIsTimeDependent
REAdjustmentDueDateIsMandatory REAdjustmentDueDateIsMandatory
REAdjustmentIsNotRetroActive REAdjustmentIsNotRetroActive
REAdjustmentBlockReason REAdjustmentBlockReason
REConditionType REConditionType
RERuleSortOrder RERuleSortOrder
RECurrencyTranslationRule RECurrencyTranslationRule Currency Translation Rule
REAdjustmentIndexSeries REAdjustmentIndexSeries
REAdjustmentIndexBaseYear REAdjustmentIndexBaseYear
REAdjustmentIdxIsAlwaysBaseYr REAdjustmentIdxIsAlwaysBaseYr
REAdjustmentIdxMinChgPointsVal REAdjustmentIdxMinChgPointsVal
REAdjustmentIdxMinChgPercent REAdjustmentIdxMinChgPercent
REAdjustmentIsIdxChgPointsExcd REAdjustmentIsIdxChgPointsExcd
REAdjustmentIsIdxChgPctExcd REAdjustmentIsIdxChgPctExcd
REAdjustmentRhythmFlexible REAdjustmentRhythmFlexible
REAdjustmentDelayInMonths REAdjustmentDelayInMonths
REAdjustmentDelayUnit REAdjustmentDelayUnit
REAdjustmentIndexBasis REAdjustmentIndexBasis
REAdjustmentIndexOrSpread REAdjustmentIndexOrSpread
REAdjustmentIndexOrPerformance REAdjustmentIndexOrPerformance

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_REContrAdjustmentTerm.
-- 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_REContrAdjustmentTerm AS
SELECT
  InternalRealEstateNumber,
  RETermNumber,
  REAdjustmentRule,
  REAdjustmentElementaryRule,
  ValidityStartEndDateValue,
  ValidityStartDate,
  ValidityEndDate,
  REAdjustmentMethod,
  REAdjustmentIsIndivGlobParam,
  REAdjustmentIsIndivSpcfcParam,
  RETermName,
  RealEstateObjectType,
  REStatusObject,
  REIdentificationKey,
  RERuleIsUsingDefaults,
  REIsRuleApprovalRequired,
  REIsActvtnWithoutApprvl,
  REIsDueDateChangeable,
  REAdjustmentPercentPassedValue,
  REHasRentalObjectIncrease,
  REAdjustmentDirection,
  REAdjustmentChangeDirection,
  REAdjustmentFrequency,
  REFrequencyUnit,
  REIsIntervalFromFrqcyStart,
  REIsSimulationRule,
  RERuleHasNoDocument,
  REAdjustmentSubsqntCondition,
  REAdjustmentIsOnNextNotice,
  REAdjustmentBase,
  REAdjustmentIsAutoDefault,
  REAdjustmentIsNotifRequired,
  REAdjustmentIsTimeDependent,
  REAdjustmentDueDateIsMandatory,
  REAdjustmentIsNotRetroActive,
  REAdjustmentBlockReason,
  REConditionType,
  RERuleSortOrder,
  RECurrencyTranslationRule,
  REAdjustmentIndexSeries,
  REAdjustmentIndexBaseYear,
  REAdjustmentIdxIsAlwaysBaseYr,
  REAdjustmentIdxMinChgPointsVal,
  REAdjustmentIdxMinChgPercent,
  REAdjustmentIsIdxChgPointsExcd,
  REAdjustmentIsIdxChgPctExcd,
  REAdjustmentRhythmFlexible,
  REAdjustmentDelayInMonths,
  REAdjustmentDelayUnit,
  REAdjustmentIndexBasis,
  REAdjustmentIndexOrSpread,
  REAdjustmentIndexOrPerformance
FROM R_REContrAdjustmentTermTP
;