I_RESettlementDistribution

DDL: I_RESETTLEMENTDISTRIBUTION Type: view_entity COMPOSITE Package: VDM_RE_CS
23 Fields 1 Data Sources

Settlement Distribution

I_RESettlementDistribution is a Composite CDS View that provides data about "Settlement Distribution" in SAP S/4HANA. It reads from 1 data source (I_RESettlementAmount) and exposes 23 fields with key fields RESettlementProcessUUID, RESettlementRulePeriodUUID, REServiceGroupUUID, REArchitectureObjectUUID, REServiceGroupTargetUUID. Part of development package VDM_RE_CS.

Data Sources (1)

SourceAliasJoin Type
I_RESettlementAmount _RESettlementAmount from

Annotations (8)

NameValueLevelField
EndUserText.label Settlement Distribution view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey RESettlementProcessUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view
VDM.viewType #COMPOSITE view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY RESettlementProcessUUID RESettlementProcessUUID
KEY RESettlementRulePeriodUUID RESettlementRulePeriodUUID Settl. Period GUID
KEY REServiceGroupUUID REServiceGroupUUID
KEY REArchitectureObjectUUID REArchitectureObjectUUID UUID Architecture Object
KEY REServiceGroupTargetUUID REServiceGroupTargetUUID
KEY RealEstateRentableObjectUUID RealEstateRentableObjectUUID UUID GO
KEY REContractIntRealEstateNumber REContractIntRealEstateNumber RE Key
KEY ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
RESettlementUUID RESettlementUUID
RERentableObjectIsOccupied RERentableObjectIsOccupied
RECostCategory RECostCategory Cost Category
RESettlementAmount
Currency I_RESettlementAmount Currency Valuation Crcy
_RESettlementProcess _RESettlementProcess
_RECostCategory _RECostCategory
_Currency _Currency
_REContract _REContract
_REArchitectureObject _REArchitectureObject
_RERentableObject _RERentableObject
_REServiceGroup _REServiceGroup
_REServiceGroupTarget _REServiceGroupTarget
_RESrvcGrpSettlmtRulePeriod _RESrvcGrpSettlmtRulePeriod

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_RESettlementDistribution.
-- 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 I_RESettlementDistribution AS
SELECT
  RESettlementProcessUUID,
  RESettlementRulePeriodUUID,
  REServiceGroupUUID,
  REArchitectureObjectUUID,
  REServiceGroupTargetUUID,
  RealEstateRentableObjectUUID,
  REContractIntRealEstateNumber,
  ValidityStartDate,
  ValidityEndDate,
  RESettlementUUID,
  RERentableObjectIsOccupied,
  RECostCategory,
  sum(_RESettlementAmount.RESettlementAmount) AS RESettlementAmount,
  _RESettlementAmount.Currency AS Currency
FROM I_RESettlementAmount AS _RESettlementAmount
;

Learn More