I_RESalesRuleTerm

DDL: I_RESALESRULETERM SQL: IRETMSALESRULE Type: view COMPOSITE Package: VDM_RE_SR
39 Fields 1 Data Sources 5 Associations

Real Estate Sales Rule Term

I_RESalesRuleTerm is a Composite CDS View that provides data about "Real Estate Sales Rule Term" in SAP S/4HANA. It reads from 1 data source (I_RESalesRuleTermBasic) and exposes 39 fields with key fields InternalRealEstateNumber, RETermType, RETermNumber, ValidityStartDate, RESalesReportingTermNumber. It has 5 associations to related views. Part of development package VDM_RE_SR.

Data Sources (1)

SourceAliasJoin Type
I_RESalesRuleTermBasic _SalesRuleTerm from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_REKeyAssgmt _REKeyAssgmt $projection.InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber
[1..1] I_RETerm _RETerm $projection.InternalRealEstateNumber = _RETerm.InternalRealEstateNumber and $projection.RETermType = _RETerm.RETermType and $projection.RETermNumber = _RETerm.RETermNumber
[1..1] I_RETermType _RETermType $projection.RETermType = _RETermType.RETermType and $projection.RealEstateObjectType = _RETermType.RealEstateObjectType
[0..*] I_RESalesRuleRptgAssgmtGrading _RESalesRuleRptgGrading $projection.InternalRealEstateNumber = _RESalesRuleRptgGrading.InternalRealEstateNumber and $projection.RETermNumber = _RESalesRuleRptgGrading.RESalesRuleTermNumber and $projection.RESalesReportingTermNumber = _RESalesRuleRptgGrading.RESalesReportingTermNumber and $projection.ValidityStartDate = _RESalesRuleRptgGrading.ValidityStartDate
[1..1] I_RESalesRule _RESalesRule $projection.RESalesRule = _RESalesRule.RESalesRule

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IRETMSALESRULE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.representativeKey RETermNumber view
VDM.viewType #COMPOSITE view
EndUserText.label Real Estate Sales Rule Term view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
KEY RETermType RETermType Term Category
KEY RETermNumber RETermNumber Number
KEY ValidityStartDate ValidityStartDate Validity Start Date
KEY RESalesReportingTermNumber RESalesReportingTermNumber
KEY RESalesItemNumberGrading _RESalesRuleRptgGrading RESalesItemNumberGrading
ValidityEndDate ValidityEndDate ValidTo
RealEstateObjectType RealEstateObjectType Object Type
REStatusObject REStatusObject Val. Obj. No.
RETermName RETermName Name of Term
RESalesRule RESalesRule Sales Rule Type
REIsPeakSalesRule REIsPeakSalesRule Peak Sales Rule
RESalesRuleIsUsingPeriodicPost RESalesRuleIsUsingPeriodicPost Post Using CF
RESalesCurrency RESalesCurrency
RESalesUnit RESalesUnit
RESalesAmountType RESalesAmountType
RESalesQuantityAmountType RESalesQuantityAmountType
REMinSalesAmount REMinSalesAmount
REMinSalesRptgIntervalAmount REMinSalesRptgIntervalAmount
REMinSalesQuantity REMinSalesQuantity
REMinSalesRptgIntervalQuantity REMinSalesRptgIntervalQuantity
REMaxSalesAmount REMaxSalesAmount
REMaxSalesQuantity REMaxSalesQuantity
RESalesUnitGrading _RESalesRuleRptgGrading RESalesUnitGrading
REMinSalesGradingAmount _RESalesRuleRptgGrading REMinSalesGradingAmount
REMaxSalesGradingAmount _RESalesRuleRptgGrading REMaxSalesGradingAmount
REMinSalesGradingQuantity _RESalesRuleRptgGrading REMinSalesGradingQuantity
REMaxSalesGradingQuantity _RESalesRuleRptgGrading REMaxSalesGradingQuantity
REPerUnitGradingPrice _RESalesRuleRptgGrading REPerUnitGradingPrice
RESalesMinRentGradingAmount _RESalesRuleRptgGrading RESalesMinRentGradingAmount
RESalesRentGradingPercent _RESalesRuleRptgGrading RESalesRentGradingPercent
_REKeyAssgmt _REKeyAssgmt
_RETerm _RETerm
_REObjectType _REObjectType
_RETermType _RETermType
_RESalesRule _RESalesRule
_Currency _Currency
_RESalesRuleReporting _RESalesRuleReporting
_RESalesRuleRptgGrading _RESalesRuleRptgGrading

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_RESalesRuleTerm.
-- 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: IRETMSALESRULE

CREATE VIEW I_RESalesRuleTerm AS
SELECT
  InternalRealEstateNumber,
  RETermType,
  RETermNumber,
  ValidityStartDate,
  RESalesReportingTermNumber,
  _RESalesRuleRptgGrading.RESalesItemNumberGrading AS RESalesItemNumberGrading,
  ValidityEndDate,
  RealEstateObjectType,
  REStatusObject,
  RETermName,
  RESalesRule,
  REIsPeakSalesRule,
  RESalesRuleIsUsingPeriodicPost,
  RESalesCurrency,
  RESalesUnit,
  RESalesAmountType,
  RESalesQuantityAmountType,
  REMinSalesAmount,
  REMinSalesRptgIntervalAmount,
  REMinSalesQuantity,
  REMinSalesRptgIntervalQuantity,
  REMaxSalesAmount,
  REMaxSalesQuantity,
  _RESalesRuleRptgGrading.RESalesUnitGrading AS RESalesUnitGrading,
  _RESalesRuleRptgGrading.REMinSalesGradingAmount AS REMinSalesGradingAmount,
  _RESalesRuleRptgGrading.REMaxSalesGradingAmount AS REMaxSalesGradingAmount,
  _RESalesRuleRptgGrading.REMinSalesGradingQuantity AS REMinSalesGradingQuantity,
  _RESalesRuleRptgGrading.REMaxSalesGradingQuantity AS REMaxSalesGradingQuantity,
  _RESalesRuleRptgGrading.REPerUnitGradingPrice AS REPerUnitGradingPrice,
  _RESalesRuleRptgGrading.RESalesMinRentGradingAmount AS RESalesMinRentGradingAmount,
  _RESalesRuleRptgGrading.RESalesRentGradingPercent AS RESalesRentGradingPercent
FROM I_RESalesRuleTermBasic AS _SalesRuleTerm
LEFT OUTER JOIN I_REKeyAssgmt AS _REKeyAssgmt ON InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_RETerm AS _RETerm ON InternalRealEstateNumber = _RETerm.InternalRealEstateNumber AND RETermType = _RETerm.RETermType AND RETermNumber = _RETerm.RETermNumber  -- association [1..1]
LEFT OUTER JOIN I_RETermType AS _RETermType ON RETermType = _RETermType.RETermType AND RealEstateObjectType = _RETermType.RealEstateObjectType  -- association [1..1]
LEFT OUTER JOIN I_RESalesRuleRptgAssgmtGrading AS _RESalesRuleRptgGrading ON InternalRealEstateNumber = _RESalesRuleRptgGrading.InternalRealEstateNumber AND RETermNumber = _RESalesRuleRptgGrading.RESalesRuleTermNumber AND RESalesReportingTermNumber = _RESalesRuleRptgGrading.RESalesReportingTermNumber AND ValidityStartDate = _RESalesRuleRptgGrading.ValidityStartDate  -- association [0..*]
LEFT OUTER JOIN I_RESalesRule AS _RESalesRule ON RESalesRule = _RESalesRule.RESalesRule  -- association [1..1]
;

Learn More