I_RESettlementApprtmtDistr

DDL: I_RESETTLEMENTAPPRTMTDISTR Type: view_entity COMPOSITE Package: VDM_RE_CS
44 Fields 3 Data Sources 1 Associations

Settlement Apportionment Distribution

I_RESettlementApprtmtDistr is a Composite CDS View that provides data about "Settlement Apportionment Distribution" in SAP S/4HANA. It reads from 3 data sources (I_RESettlementAmount, I_RESettlementApprtmtAmount, I_RESettlementReferenceFactor) and exposes 44 fields with key fields RESettlementProcessUUID, RESettlementRulePeriodUUID, Ledger, REServiceGroupUUID, REArchitectureObjectUUID. It has 1 association to related views. Part of development package VDM_RE_CS.

Data Sources (3)

SourceAliasJoin Type
I_RESettlementAmount _RESettlementAmount inner
I_RESettlementApprtmtAmount _RESettlementApprtmtAmount inner
I_RESettlementReferenceFactor _RESettlementReferenceFactor from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_RESettlementProcess _RESettlementProcessData _RESettlementProcessData.RESettlementProcessUUID = _RESettlementAmount.RESettlementProcessUUID

Annotations (8)

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

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY RESettlementProcessUUID I_RESettlementAmount RESettlementProcessUUID
KEY RESettlementRulePeriodUUID I_RESettlementAmount RESettlementRulePeriodUUID Settl. Period GUID
KEY Ledger I_RESettlementAmount Ledger Ledger
KEY REServiceGroupUUID I_RESettlementAmount REServiceGroupUUID
KEY REArchitectureObjectUUID I_RESettlementReferenceFactor REArchitectureObjectUUID UUID Architecture Object
KEY REServiceGroupTargetUUID I_RESettlementReferenceFactor REServiceGroupTargetUUID
KEY RealEstateRentableObjectUUID I_RESettlementReferenceFactor RealEstateRentableObjectUUID UUID GO
KEY REContractIntRealEstateNumber I_RESettlementReferenceFactor REContractIntRealEstateNumber RE Key
KEY RECostCategory I_RESettlementReferenceFactor RECostCategory Cost Category
KEY ValidityStartDate I_RESettlementReferenceFactor ValidityStartDate Validity Start Date
ValidityEndDate I_RESettlementReferenceFactor ValidityEndDate ValidTo
RERentableObjectIsOccupied I_RESettlementReferenceFactor RERentableObjectIsOccupied
RETotalNumberOfSettlementDays I_RESettlementReferenceFactor RETotalNumberOfSettlementDays
RENumberOfSettlementDays I_RESettlementReferenceFactor RENumberOfSettlementDays
REMeasurementType I_RESettlementReferenceFactor REMeasurementType
REMeasurementQuantity I_RESettlementReferenceFactor REMeasurementQuantity
REMeasurementUnit I_RESettlementReferenceFactor REMeasurementUnit
REDenominatorMethod I_RESettlementReferenceFactor REDenominatorMethod Denominator Method
RESettlementDenominator I_RESettlementReferenceFactor RESettlementDenominator Fixed Denominator
RESettlementShareDenominator I_RESettlementReferenceFactor RESettlementShareDenominator
REApportionmentFactorValue I_RESettlementReferenceFactor REApportionmentFactorValue
REVacancyPercent I_RESettlementReferenceFactor REVacancyPercent Vacancy
RESettlementAmount
Currency I_RESettlementAmount Currency Valuation Crcy
RESettlementTotalAmount
RESettlmtDataRetrievalStatus I_RESettlementAmount RESettlmtDataRetrievalStatus
RESettlementStatus I_RESettlementAmount RESettlementStatus
RESettlementUUID _RESettlementProcessData RESettlementUUID
_RESettlementProcess I_RESettlementAmount _RESettlementProcess
_Ledger I_RESettlementAmount _Ledger
_REContract I_RESettlementReferenceFactor _REContract
_REArchitectureObject I_RESettlementReferenceFactor _REArchitectureObject
_RERentableObject I_RESettlementReferenceFactor _RERentableObject
_REServiceGroup I_RESettlementAmount _REServiceGroup
_REServiceGroupTarget I_RESettlementReferenceFactor _REServiceGroupTarget
_RESrvcGrpSettlmtRulePeriod I_RESettlementAmount _RESrvcGrpSettlmtRulePeriod
_RECostCategory I_RESettlementReferenceFactor _RECostCategory
_REMeasurementType I_RESettlementReferenceFactor _REMeasurementType
_UnitOfMeasure I_RESettlementReferenceFactor _UnitOfMeasure
_REDenominatorMethod I_RESettlementReferenceFactor _REDenominatorMethod
_Currency I_RESettlementAmount _Currency
_RESettlmtDataRetrievalStatus I_RESettlementAmount _RESettlmtDataRetrievalStatus
_RESettlementStatus I_RESettlementAmount _RESettlementStatus
_RESettlement _RESettlementProcessData _RESettlement

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_RESettlementApprtmtDistr.
-- 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_RESettlementApprtmtDistr AS
SELECT
  _RESettlementAmount.RESettlementProcessUUID AS RESettlementProcessUUID,
  _RESettlementAmount.RESettlementRulePeriodUUID AS RESettlementRulePeriodUUID,
  _RESettlementAmount.Ledger AS Ledger,
  _RESettlementAmount.REServiceGroupUUID AS REServiceGroupUUID,
  _RESettlementReferenceFactor.REArchitectureObjectUUID AS REArchitectureObjectUUID,
  _RESettlementReferenceFactor.REServiceGroupTargetUUID AS REServiceGroupTargetUUID,
  _RESettlementReferenceFactor.RealEstateRentableObjectUUID AS RealEstateRentableObjectUUID,
  _RESettlementReferenceFactor.REContractIntRealEstateNumber AS REContractIntRealEstateNumber,
  _RESettlementReferenceFactor.RECostCategory AS RECostCategory,
  _RESettlementReferenceFactor.ValidityStartDate AS ValidityStartDate,
  _RESettlementReferenceFactor.ValidityEndDate AS ValidityEndDate,
  _RESettlementReferenceFactor.RERentableObjectIsOccupied AS RERentableObjectIsOccupied,
  _RESettlementReferenceFactor.RETotalNumberOfSettlementDays AS RETotalNumberOfSettlementDays,
  _RESettlementReferenceFactor.RENumberOfSettlementDays AS RENumberOfSettlementDays,
  _RESettlementReferenceFactor.REMeasurementType AS REMeasurementType,
  _RESettlementReferenceFactor.REMeasurementQuantity AS REMeasurementQuantity,
  _RESettlementReferenceFactor.REMeasurementUnit AS REMeasurementUnit,
  _RESettlementReferenceFactor.REDenominatorMethod AS REDenominatorMethod,
  _RESettlementReferenceFactor.RESettlementDenominator AS RESettlementDenominator,
  _RESettlementReferenceFactor.RESettlementShareDenominator AS RESettlementShareDenominator,
  _RESettlementReferenceFactor.REApportionmentFactorValue AS REApportionmentFactorValue,
  _RESettlementReferenceFactor.REVacancyPercent AS REVacancyPercent,
  sum(_RESettlementAmount.RESettlementAmount) AS RESettlementAmount,
  _RESettlementAmount.Currency AS Currency,
  sum(_RESettlementApprtmtAmount.RESettlementAmount) AS RESettlementTotalAmount,
  _RESettlementAmount.RESettlmtDataRetrievalStatus AS RESettlmtDataRetrievalStatus,
  _RESettlementAmount.RESettlementStatus AS RESettlementStatus,
  _RESettlementProcessData.RESettlementUUID AS RESettlementUUID,
  _RESettlementAmount._RESettlementProcess AS _RESettlementProcess,
  _RESettlementAmount._Ledger AS _Ledger,
  _RESettlementReferenceFactor._REContract AS _REContract,
  _RESettlementReferenceFactor._REArchitectureObject AS _REArchitectureObject,
  _RESettlementReferenceFactor._RERentableObject AS _RERentableObject,
  _RESettlementAmount._REServiceGroup AS _REServiceGroup,
  _RESettlementReferenceFactor._REServiceGroupTarget AS _REServiceGroupTarget,
  _RESettlementAmount._RESrvcGrpSettlmtRulePeriod AS _RESrvcGrpSettlmtRulePeriod,
  _RESettlementReferenceFactor._RECostCategory AS _RECostCategory,
  _RESettlementReferenceFactor._REMeasurementType AS _REMeasurementType,
  _RESettlementReferenceFactor._UnitOfMeasure AS _UnitOfMeasure,
  _RESettlementReferenceFactor._REDenominatorMethod AS _REDenominatorMethod,
  _RESettlementAmount._Currency AS _Currency,
  _RESettlementAmount._RESettlmtDataRetrievalStatus AS _RESettlmtDataRetrievalStatus,
  _RESettlementAmount._RESettlementStatus AS _RESettlementStatus,
  _RESettlementProcessData._RESettlement AS _RESettlement
FROM I_RESettlementReferenceFactor AS _RESettlementReferenceFactor
INNER JOIN I_RESettlementAmount AS _RESettlementAmount ON /* join condition not captured in parsed metadata */
INNER JOIN I_RESettlementApprtmtAmount AS _RESettlementApprtmtAmount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RESettlementProcess AS _RESettlementProcessData ON _RESettlementProcessData.RESettlementProcessUUID = _RESettlementAmount.RESettlementProcessUUID  -- association [1..1]
;

Learn More