I_REAdjustmentRule

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 I_REAdjustmentRule.
-- 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.
-- SQL view name: IREADJRULE

CREATE VIEW I_REAdjustmentRule AS
SELECT
  adjmrule AS REAdjustmentRule,
  adjmmeth AS REAdjustmentMethod,
  rulechangeable AS RERuleIsChangeable,
  isrulecomb AS REAdjustmentRuleIsCombined,
  ispartcomb AS REAdjustmentRuleIsPartlyCmbnd,
  approval AS REIsRuleApprovalRequired,
  actifnoappr AS REIsActvtnWithoutApprvl,
  dtchangeable AS REIsDueDateChangeable,
  percentagepass AS REAdjustmentPercentPassedValue,
  userorateinc AS REHasRentalObjectIncrease,
  adjmdirection AS REAdjustmentDirection,
  changedirection AS REAdjustmentChangeDirection,
  rhythm AS REAdjustmentFrequency,
  cast ( rhythmunit as recdvdmfrequencyunit ) AS REFrequencyUnit,
  rhythmbegin AS REIsIntervalFromFrqcyStart,
  simulationrule AS REIsSimulationRule,
  nodocument AS RERuleHasNoDocument,
  adjmcotype AS REAdjustmentSubsqntCondition,
  nextadjmnotice AS REAdjustmentIsOnNextNotice,
  adjmbase AS REAdjustmentBase,
  autodefault AS REAdjustmentIsAutoDefault,
  announce AS REAdjustmentIsNotifRequired,
  ruleorder AS RERuleSortOrder,
  timedeptype AS REAdjustmentIsTimeDependent,
  ddupmandatory AS REAdjustmentDueDateIsMandatory,
  noretroactive AS REAdjustmentIsNotRetroActive,
  blockreason AS REAdjustmentBlockReason,
  ctrule AS RECurrencyTranslationRule,
  depcondtype AS REConditionType
FROM tivajrule
LEFT OUTER JOIN I_RECurrencyTranslationRule AS _RECurrencyTranslationRule ON RECurrencyTranslationRule = _RECurrencyTranslationRule.RECurrencyTranslationRule  -- association [0..1]
LEFT OUTER JOIN I_REConditionType AS _REConditionType ON REConditionType = _REConditionType.REConditionType  -- association [0..1]
LEFT OUTER JOIN I_REAdjustmentBlockReason AS _REAdjustmentBlockReason ON REAdjustmentMethod = _REAdjustmentBlockReason.REAdjustmentMethod AND REAdjustmentBlockReason = _REAdjustmentBlockReason.REAdjustmentBlockReason  -- association [0..1]
LEFT OUTER JOIN I_REAdjustmentMethod AS _REAdjustmentMethod ON REAdjustmentMethod = _REAdjustmentMethod.REAdjustmentMethod  -- association [1..1]
LEFT OUTER JOIN I_REAdjustmentRuleText AS _Text ON /* condition not available in parsed metadata */  -- association [0..*]
;