R_IntOrdSettlmtDistrRuleRETP

DDL: R_INTORDSETTLMTDISTRRULERETP Type: view_entity TRANSACTIONAL Package: RAP_FIN_CO_INTORDSETTLMTRULE
33 Fields 2 Data Sources 2 Associations

Settlement Distribution Rule Real Estate

R_IntOrdSettlmtDistrRuleRETP is a Transactional CDS View that provides data about "Settlement Distribution Rule Real Estate" in SAP S/4HANA. It reads from 2 data sources (I_IntOrderSettlementDistrRule, P_IntOrdSettlmtDistrRuleRE) and exposes 33 fields with key fields ControllingObject, Ledger, LedgerGroup, SettlementDistributionRuleGrp, SettlmtDistrRuleSequence. It has 2 associations to related views. Part of development package RAP_FIN_CO_INTORDSETTLMTRULE.

Data Sources (2)

SourceAliasJoin Type
I_IntOrderSettlementDistrRule _IntOrderSettlementDistrRule inner
P_IntOrdSettlmtDistrRuleRE P_IntOrdSettlmtDistrRuleRE from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_IntOrderSettlementRuleTP _IntOrderSettlementRuleTP $projection.ControllingObject = _IntOrderSettlementRuleTP.ControllingObject
[1..1] I_RETaxCorrectionItem _RETaxCorrectionItem $projection.InternalRealEstateNumber = _RETaxCorrectionItem.InternalRealEstateNumber

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Settlement Distribution Rule Real Estate view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY ControllingObject I_IntOrderSettlementDistrRule ControllingObject Object number
KEY Ledger I_IntOrderSettlementDistrRule Ledger Ledger
KEY LedgerGroup I_IntOrderSettlementDistrRule LedgerGroup Ledger Group
KEY SettlementDistributionRuleGrp I_IntOrderSettlementDistrRule SettlementDistributionRuleGrp
KEY SettlmtDistrRuleSequence I_IntOrderSettlementDistrRule SettlmtDistrRuleSequence
SettlmtWithFreeDefinedCurrency I_IntOrderSettlementDistrRule SettlmtWithFreeDefinedCurrency
ControllingArea I_IntOrderSettlementDistrRule ControllingArea Controlling Area
OrderType I_IntOrderSettlementDistrRule OrderType Order Type
InternalRealEstateNumber P_IntOrdSettlmtDistrRuleRE InternalRealEstateNumber RE Key
REInternalFinNumber P_IntOrdSettlmtDistrRuleRE REInternalFinNumber Real Estate Key
REStatusObject P_IntOrdSettlmtDistrRuleRE REStatusObject Val. Obj. No.
CompanyCode P_IntOrdSettlmtDistrRuleRE CompanyCode Receiver Company Code
REBusinessEntity P_IntOrdSettlmtDistrRuleRE REBusinessEntity RE Business Entity
REBusinessEntityName P_IntOrdSettlmtDistrRuleRE REBusinessEntityName
RealEstateBuilding P_IntOrdSettlmtDistrRuleRE RealEstateBuilding Building
REBuildingName P_IntOrdSettlmtDistrRuleRE REBuildingName
RealEstateProperty P_IntOrdSettlmtDistrRuleRE RealEstateProperty Land
REPropertyName P_IntOrdSettlmtDistrRuleRE REPropertyName
RERentalObject P_IntOrdSettlmtDistrRuleRE RERentalObject
RERentalObjectName P_IntOrdSettlmtDistrRuleRE RERentalObjectName
RealEstateContract P_IntOrdSettlmtDistrRuleRE RealEstateContract Real Estate Contract
REContractName P_IntOrdSettlmtDistrRuleRE REContractName Contract Name
REServiceChargeKey P_IntOrdSettlmtDistrRuleRE REServiceChargeKey
REServiceChargeKeyName P_IntOrdSettlmtDistrRuleRE REServiceChargeKeyName
RESettlementUnitID P_IntOrdSettlmtDistrRuleRE RESettlementUnitID
RESettlementUnitName P_IntOrdSettlmtDistrRuleRE RESettlementUnitName
SettlementReferenceDate P_IntOrdSettlmtDistrRuleRE SettlementReferenceDate Reference date
REAuthorizationGroup P_IntOrdSettlmtDistrRuleRE REAuthorizationGroup Authoriz. Group
REContractType P_IntOrdSettlmtDistrRuleRE REContractType Contract Type
_REPartnerAssgmt P_IntOrdSettlmtDistrRuleRE _REPartnerAssgmt
_RETaxCorrectionItem _RETaxCorrectionItem
_IntOrdSettlementDistrRuleTP _IntOrdSettlementDistrRuleTP
_IntOrderSettlementRuleTP _IntOrderSettlementRuleTP

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 R_IntOrdSettlmtDistrRuleRETP.
-- 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 R_IntOrdSettlmtDistrRuleRETP AS
SELECT
  _IntOrderSettlementDistrRule.ControllingObject AS ControllingObject,
  _IntOrderSettlementDistrRule.Ledger AS Ledger,
  _IntOrderSettlementDistrRule.LedgerGroup AS LedgerGroup,
  _IntOrderSettlementDistrRule.SettlementDistributionRuleGrp AS SettlementDistributionRuleGrp,
  _IntOrderSettlementDistrRule.SettlmtDistrRuleSequence AS SettlmtDistrRuleSequence,
  _IntOrderSettlementDistrRule.SettlmtWithFreeDefinedCurrency AS SettlmtWithFreeDefinedCurrency,
  _IntOrderSettlementDistrRule.ControllingArea AS ControllingArea,
  _IntOrderSettlementDistrRule.OrderType AS OrderType,
  P_IntOrdSettlmtDistrRuleRE.InternalRealEstateNumber AS InternalRealEstateNumber,
  P_IntOrdSettlmtDistrRuleRE.REInternalFinNumber AS REInternalFinNumber,
  P_IntOrdSettlmtDistrRuleRE.REStatusObject AS REStatusObject,
  P_IntOrdSettlmtDistrRuleRE.CompanyCode AS CompanyCode,
  P_IntOrdSettlmtDistrRuleRE.REBusinessEntity AS REBusinessEntity,
  P_IntOrdSettlmtDistrRuleRE.REBusinessEntityName AS REBusinessEntityName,
  P_IntOrdSettlmtDistrRuleRE.RealEstateBuilding AS RealEstateBuilding,
  P_IntOrdSettlmtDistrRuleRE.REBuildingName AS REBuildingName,
  P_IntOrdSettlmtDistrRuleRE.RealEstateProperty AS RealEstateProperty,
  P_IntOrdSettlmtDistrRuleRE.REPropertyName AS REPropertyName,
  P_IntOrdSettlmtDistrRuleRE.RERentalObject AS RERentalObject,
  P_IntOrdSettlmtDistrRuleRE.RERentalObjectName AS RERentalObjectName,
  P_IntOrdSettlmtDistrRuleRE.RealEstateContract AS RealEstateContract,
  P_IntOrdSettlmtDistrRuleRE.REContractName AS REContractName,
  P_IntOrdSettlmtDistrRuleRE.REServiceChargeKey AS REServiceChargeKey,
  P_IntOrdSettlmtDistrRuleRE.REServiceChargeKeyName AS REServiceChargeKeyName,
  P_IntOrdSettlmtDistrRuleRE.RESettlementUnitID AS RESettlementUnitID,
  P_IntOrdSettlmtDistrRuleRE.RESettlementUnitName AS RESettlementUnitName,
  P_IntOrdSettlmtDistrRuleRE.SettlementReferenceDate AS SettlementReferenceDate,
  P_IntOrdSettlmtDistrRuleRE.REAuthorizationGroup AS REAuthorizationGroup,
  P_IntOrdSettlmtDistrRuleRE.REContractType AS REContractType,
  P_IntOrdSettlmtDistrRuleRE._REPartnerAssgmt AS _REPartnerAssgmt
FROM P_IntOrdSettlmtDistrRuleRE
INNER JOIN I_IntOrderSettlementDistrRule AS _IntOrderSettlementDistrRule ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_IntOrderSettlementRuleTP AS _IntOrderSettlementRuleTP ON ControllingObject = _IntOrderSettlementRuleTP.ControllingObject  -- association [1..1]
LEFT OUTER JOIN I_RETaxCorrectionItem AS _RETaxCorrectionItem ON InternalRealEstateNumber = _RETaxCorrectionItem.InternalRealEstateNumber  -- association [1..1]
;

Learn More