I_RESalesRuleReportingAssgmt

DDL: I_RESALESRULEREPORTINGASSGMT SQL: IRESALESRULEREP Type: view BASIC Package: VDM_RE_SR
16 Fields 1 Data Sources 2 Associations

Real Estate Sales Reporting Assignment

I_RESalesRuleReportingAssgmt is a Basic CDS View that provides data about "Real Estate Sales Reporting Assignment" in SAP S/4HANA. It reads from 1 data source (visrtmsbrp) and exposes 16 fields with key fields InternalRealEstateNumber, ValidityStartDate, RESalesRuleTermNumber, RESalesReportingTermNumber. It has 2 associations to related views. Part of development package VDM_RE_SR.

Data Sources (1)

SourceAliasJoin Type
visrtmsbrp _SalesRuleReportingAssgmt from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_REKeyAssgmt _REKeyAssgmt $projection.InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber
[0..1] I_Currency _Currency $projection.RESalesCurrency = _Currency.Currency

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IRESALESRULEREP 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 #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.representativeKey RESalesRuleTermNumber view
VDM.viewType #BASIC view
EndUserText.label Real Estate Sales Reporting Assignment view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber intreno Source Object
KEY ValidityStartDate sbvalidfrom Valid From
KEY RESalesRuleTermNumber sbtermno SR No.
KEY RESalesReportingTermNumber rptermno RepRuleNo.
RESalesCurrency salescurr Currency
RESalesUnit salesunit Unit
RESalesAmountType amounttype What Sales
RESalesQuantityAmountType amounttype_quan Net/Gross
REMinSalesAmount minsales Sales from
REMinSalesRptgIntervalAmount minsalesrep Min.sales/rep.
REMaxSalesAmount maxsales Sales To
REMinSalesQuantity minquantity Q.Sales From
REMinSalesRptgIntervalQuantity minquantityrep MinQSales/RepI
REMaxSalesQuantity maxquantity Q.Sales To
_REKeyAssgmt _REKeyAssgmt
_Currency _Currency

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_RESalesRuleReportingAssgmt.
-- 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: IRESALESRULEREP

CREATE VIEW I_RESalesRuleReportingAssgmt AS
SELECT
  intreno AS InternalRealEstateNumber,
  sbvalidfrom AS ValidityStartDate,
  sbtermno AS RESalesRuleTermNumber,
  rptermno AS RESalesReportingTermNumber,
  salescurr AS RESalesCurrency,
  salesunit AS RESalesUnit,
  amounttype AS RESalesAmountType,
  amounttype_quan AS RESalesQuantityAmountType,
  minsales AS REMinSalesAmount,
  minsalesrep AS REMinSalesRptgIntervalAmount,
  maxsales AS REMaxSalesAmount,
  minquantity AS REMinSalesQuantity,
  minquantityrep AS REMinSalesRptgIntervalQuantity,
  maxquantity AS REMaxSalesQuantity
FROM visrtmsbrp AS _SalesRuleReportingAssgmt
LEFT OUTER JOIN I_REKeyAssgmt AS _REKeyAssgmt ON InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON RESalesCurrency = _Currency.Currency  -- association [0..1]
;

Learn More